20190107.sql 367 B

123456789
  1. -- 移除节点无用字段、加入是否nat机字段
  2. ALTER TABLE `ss_node`
  3. ADD COLUMN `is_nat` TINYINT NOT NULL DEFAULT '0' COMMENT '是否为NAT机:0-否、1-是' AFTER `is_subscribe`,
  4. DROP COLUMN `icmp`,
  5. DROP COLUMN `tcp`,
  6. DROP COLUMN `udp`;
  7. ALTER TABLE `ss_node`
  8. CHANGE COLUMN `traffic` `traffic` INT(11) NOT NULL DEFAULT '1000' COMMENT '每月可用流量,单位G' AFTER `bandwidth`;