CREATE TABLE `order_transactions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` varchar(255) NOT NULL,
  `reference_id` varchar(255) NOT NULL,
  `amount` decimal(19,9) NOT NULL,
  `payment_mode` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `check_no` varchar(255) DEFAULT NULL,
  `session_key` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE orders ADD COLUMN session_key VARCHAR(255);
ALTER TABLE orders ADD COLUMN check_no VARCHAR(255);
ALTER TABLE orders ADD COLUMN is_parent tinyint(1);