- ALTER TABLE `4dkankan_v4`.`t_agent_new`
- ADD COLUMN `agent_level` int NULL DEFAULT 0 COMMENT '代理等级' AFTER `status`;
- UPDATE t_agent_new set `agent_level` = 1 WHERE parent_id is not null;
- ALTER TABLE `4dkankan_v4`.`t_user_increment`
- ADD COLUMN `auth_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) AFTER `subscription_order`;
- UPDATE t_user_increment set auth_time = update_time ;
|