ALTER TABLE `transaction` ADD `Slug` VARCHAR(14) NOT NULL AFTER `Payment_Link`, ADD `Hits` INT NOT NULL AFTER `Slug`;


ALTER TABLE `Transaction` ADD `User_Agent` VARCHAR(100) NOT NULL COMMENT 'source from which payment link is clicked' AFTER `Slug`;

ALTER TABLE `Transaction` CHANGE `Status` `Status` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'pending, fail, success, partial, canceled';

ALTER TABLE `Order_Hdr` CHANGE `Payment_Status` `Payment_Status` ENUM('Pending','Paid','Refund Pending', 'Partial') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE `Transaction` CHANGE `Transaction_For` `Transaction_For` ENUM('Payment','Refund','Payout') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Payment' COMMENT 'Differentiate transaction type with this column. e.g. It is for Payment or Refund or Payout';

ALTER TABLE `Order_Hdr` ADD `Refund_Amount` DECIMAL(20,2) NOT NULL DEFAULT '0' COMMENT 'If refund is initiated then refund amount is stored here, if refund processed then refund in minus will store here' AFTER `Saving_Amount`;

ALTER TABLE `Order_Hdr` CHANGE `Payment_Status` `Payment_Status` ENUM('Pending','Paid','Refund Pending','Partial','Refund Initiated','Refund Paid','Refund Partial Paid') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;


ALTER TABLE `Store_Transaction_Detail` CHANGE `Deposit_Mode` `Deposit_Mode` ENUM('1','2','3','4','5','6','7','8','9') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '1-NEFT , 2-Cheque , 3-NA ,4-Cash , 5-Credit Card, 6-Debit Card, 7-PayTm, 8-Online-Billdesk, 9-Online-Easebuzz';

ALTER TABLE `Store_Transaction_Detail` ADD `Mode` VARCHAR(50) NOT NULL COMMENT 'Payment Mode' AFTER `Branch_Name`;