File indexing completed on 2024-04-21 06:00:37
0001 ALTER TABLE `support` 0002 ADD COLUMN `type_id` INT(1) UNSIGNED NULL DEFAULT '0' COMMENT '0 = onetime payment, 1 = subsscription signup, 2 = subsscription payment' AFTER `create_time`, 0003 ADD COLUMN `period` VARCHAR(50) NULL AFTER `amount`; 0004 0005 0006 UPDATE `support` `p` 0007 SET `p`.`type_id` = 0; 0008 0009 ALTER TABLE `support` 0010 ADD COLUMN `subscription_id` VARCHAR(255) NULL AFTER `type_id`; 0011 0012 ALTER TABLE `support` 0013 ADD COLUMN `period_frequency` VARCHAR(50) NULL DEFAULT NULL AFTER `period`;