sql建表语句
CREATE TABLE `unregister_user_task` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `user_id` bigint(20) NOT NULL COMMENT '用户id', `phone_number` varchar(20) NOT NULL COMMENT '电话', `account_type` tinyint(1) NOT NULL COMMENT '1 司机 2 货主 ', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 0 - 预处理 1 - 处理成功 2 - 处理失败', `deal_count` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '处理次数', `cancel_time` datetime NOT NULL COMMENT '取消时间', `history_flag` tinyint(1) NOT NULL COMMENT '是否存量记录 1 是 0 否', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_status_created_time_deal_count` (`create_time`,`status`,`deal_count`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;