4dkankan-agent/doc/update-1.3.1.sql

ALTER TABLE `4dkankan_v4`.`t_user`
    ADD COLUMN `agent_key` varchar(255) NULL DEFAULT NULL AFTER `ss_download_num`;

CREATE TABLE `t_agent_authorize_modeling` (
                                              `id` int NOT NULL AUTO_INCREMENT COMMENT '本地算法授权',
                                              `customer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客户名称',
                                              `customer_type` int DEFAULT NULL COMMENT '客户类别0直销，1经销',
                                              `end_customer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '终端客户',
                                              `use_type` int DEFAULT NULL COMMENT '使用类型',
                                              `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
                                              `authorize_key` text COMMENT '授权key',
                                              `authorize_start_time` varchar(255) DEFAULT NULL COMMENT '授权期限',
                                              `authorize_end_time` varchar(255) DEFAULT NULL,
                                              `agent_id` int DEFAULT NULL,
                                              `create_agent_id` int DEFAULT NULL,
                                              `rec_status` varchar(255) DEFAULT 'A',
                                              `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                              `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


ALTER TABLE `4dkankan_v4`.`t_agent_new`
    ADD COLUMN `create_agent_id` int NULL AFTER `agent_level`;