neiyou_user_web/sql/update/20190213.sql

-- 适配vnet，修正限速字段，默认限速为10M
ALTER TABLE `user`
	CHANGE COLUMN `speed_limit_per_con` `speed_limit_per_con` BIGINT NOT NULL DEFAULT '10737418240' COMMENT '单连接限速，默认10G，为0表示不限速，单位Byte' AFTER `obfs_param`,
	CHANGE COLUMN `speed_limit_per_user` `speed_limit_per_user` BIGINT NOT NULL DEFAULT '10737418240' COMMENT '单用户限速，默认10G，为0表示不限速，单位Byte' AFTER `speed_limit_per_con`;


-- 优化数据库，防止暴库
ALTER TABLE `user_subscribe_log`
	ADD INDEX `sid` (`sid`);

ALTER TABLE `user_subscribe`
	ADD INDEX `user_id` (`user_id`, `status`),
	ADD INDEX `code` (`code`);