MySQL DDL Demo

 1 CREATE TABLE `user` (
 2   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 3   `mobile` varchar(13) NOT NULL COMMENT ‘手机号‘,
 4   `user_alias` varchar(13) NOT NULL COMMENT ‘用户别名‘,
 5   `password` varchar(128) NOT NULL COMMENT ‘用户密码‘,
 6   `user_type` tinyint(4) unsigned DEFAULT NULL COMMENT ‘用户类型，1：普通用户；2：VIP会员‘,
 7   `user_state` tinyint(4) unsigned DEFAULT NULL COMMENT ‘用户状态‘,
 8   `reg_channel` tinyint(4) unsigned DEFAULT NULL COMMENT ‘注册渠道‘,
 9   `reg_time` bigint(20) unsigned NOT NULL COMMENT ‘注册时间‘,
10   `last_login_time` timestamp(3) NULL DEFAULT NULL COMMENT ‘最后一次登录时间‘,
11   `last_logout_time` timestamp(3) NULL DEFAULT NULL COMMENT ‘最后一次登出时间‘,
12   `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
13   `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
14   PRIMARY KEY (`id`),
15   UNIQUE KEY `uk_mobile` (`mobile`),
16   KEY `idx_reg_channel` (`reg_channel`)
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;