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;