/*NR 20-07-2022*/
ALTER TABLE `user` ADD `geoFencingPurchasedTime` VARCHAR(20) NULL DEFAULT NULL COMMENT 'eg: 15 Min' AFTER `contentMgtStorage`;

/*NR 19-10-2022*/
ALTER TABLE `user_pay_history` ADD `storage_flag` INT NOT NULL DEFAULT '1' COMMENT '1=2checkout, 2=Inapp playstore' AFTER `order_number`;
ALTER TABLE `user_pay_history` CHANGE `order_number` `order_number` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; /*(only length increased to 255 from 50)*/
ALTER TABLE `user_pay_history` ADD `price` DECIMAL(19,2) NULL DEFAULT NULL COMMENT 'using for inapp only' AFTER `ordertype`, ADD `currency_code` VARCHAR(20) NULL DEFAULT NULL COMMENT 'using for inapp only' AFTER `price`;

/*NR 28-10-2022*/
ALTER TABLE `order_master` ADD `user_pay_history_id` INT NULL DEFAULT NULL AFTER `auth`;
ALTER TABLE `order_master` ADD `inapp_title` VARCHAR(255) NULL DEFAULT NULL AFTER `user_pay_history_id`, ADD `inapp_name` VARCHAR(255) NULL DEFAULT NULL AFTER `inapp_title`, ADD `inapp_description` VARCHAR(255) NULL DEFAULT NULL AFTER `inapp_name`, ADD `inapp_subscriptionPeriod` VARCHAR(255) NULL DEFAULT NULL AFTER `inapp_description`;