CREATE TABLE t_user (
id bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
name varchar(50) NOT NULL COMMENT 'name',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create_time',
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update_time',
update_id bigint unsigned DEFAULT NULL COMMENT 'update_id',
create_id bigint unsigned NOT NULL COMMENT 'create_id',
enable tinyint unsigned DEFAULT NULL COMMENT '1-true 0-false',
code varchar(15) NOT NULL COMMENT 'code',
PRIMARY KEY (id),
KEY idx_user_user_id (create_id) USING BTREE COMMENT 'userId索引'
) ENGINE=InnoDB AUTO_INCREMENT=12345679 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='User 表';
