ALTER TABLE `tblcoupons` CHANGE `stripe_coupon_id` `stripe_coupon_id` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

ALTER TABLE `tblcoupons` ADD `charge_bee_coupon_id` VARCHAR(500) NULL DEFAULT NULL AFTER `is_active`;

ALTER TABLE `tblcoupons` ADD `apple_coupon_data` TEXT NULL DEFAULT NULL AFTER `is_active`;

CREATE INDEX coupons_charge_bee_coupon_id ON tblcoupons (charge_bee_coupon_id);

CREATE INDEX coupons_apple_coupon_data ON tblcoupons (apple_coupon_data);