update.sql 693 B

123456789101112131415161718
  1. ALTER TABLE `v2_server`
  2. ADD `last_check_at` int(11) NULL AFTER `rate`;
  3. ALTER TABLE `v2_server`
  4. ADD `network` varchar(11) COLLATE 'utf8_general_ci' NOT NULL AFTER `rate`;
  5. ALTER TABLE `v2_server`
  6. ADD `settings` text COLLATE 'utf8_general_ci' NULL AFTER `network`;
  7. /* 2019-11-18 */
  8. ALTER TABLE `v2_server`
  9. ADD `show` tinyint(1) NOT NULL DEFAULT '0' AFTER `settings`;
  10. /* 2019-11-23 */
  11. ALTER TABLE `v2_user`
  12. CHANGE `enable` `enable` tinyint(1) NOT NULL DEFAULT '1' AFTER `transfer_enable`;
  13. /* 2019-11-25 */
  14. ALTER TABLE `v2_order`
  15. ADD `type` int(11) NOT NULL COMMENT '1新购2续费3升级' AFTER `plan_id`;
  16. /* 2019-11-27 */
  17. ALTER TABLE `v2_user`
  18. ADD `commission_rate` int(11) NULL AFTER `password`;