glzjin_11_clean.sql

DROP TABLE invite_code;

ALTER TABLE `user`
  DROP `node_class`,
  DROP `node_speed`,
  DROP `node_period`;
  
DROP TABLE ss_reset_pwd;

ALTER TABLE `ss_node`
  DROP `offset`,
  DROP `node_speed_sum`,
  DROP `node_ping`;CREATE TABLE `smartline` ( `id` BIGINT NOT NULL AUTO_INCREMENT , `node_class` BIGINT NOT NULL , `domain_prefix` TEXT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;


INSERT INTO `ss_node` (`id`, `name`, `type`, `server`, `method`, `info`, `status`, `sort`, `custom_method`, `traffic_rate`, `node_class`, `node_speedlimit`, `node_connector`, `node_bandwidth`, `node_bandwidth_limit`, `bandwidthlimit_resetday`, `node_heartbeat`, `node_ip`) VALUES (NULL, '智能线路（速度） - Shadowsocks', '1', 'smart.zhaoj.in', 'aes-256-cfb', '智能线路，注重速度。', '可用', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', NULL);

INSERT INTO `ss_node` (`id`, `name`, `type`, `server`, `method`, `info`, `status`, `sort`, `custom_method`, `traffic_rate`, `node_class`, `node_speedlimit`, `node_connector`, `node_bandwidth`, `node_bandwidth_limit`, `bandwidthlimit_resetday`, `node_heartbeat`, `node_ip`) VALUES (NULL, '智能线路（延时） - Shadowsocks', '1', 'smart.zhaoj.in', 'aes-256-cfb', '智能线路，降低延时。', '可用', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', NULL);

ALTER TABLE `smartline` ADD `type` INT NULL DEFAULT '0' AFTER `domain_prefix`;

ALTER TABLE `smartline` ADD `t_node` INT NULL AFTER `type`, ADD `u_node` INT NULL AFTER `t_node`, ADD `c_node` INT NULL AFTER `u_node`;

ALTER TABLE `smartline` ADD `t_id` BIGINT NOT NULL AFTER `c_node`, ADD `u_id` BIGINT NOT NULL AFTER `t_id`, ADD `c_id` BIGINT NOT NULL AFTER `u_id`;

CREATE TABLE `blockip` ( `id` BIGINT NOT NULL AUTO_INCREMENT , `nodeid` INT NOT NULL , `ip` TEXT NOT NULL , `datetime` BIGINT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

CREATE TABLE `unblockip` ( `id` BIGINT NOT NULL AUTO_INCREMENT , `ip` TEXT NOT NULL , `datetime` BIGINT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; 

ALTER TABLE `unblockip` ADD `userid` BIGINT NOT NULL AFTER `datetime`;