github.com/Go-To-Byte/DouSheng/user_center@v0.0.0-20230524130918-ad531c1a3f6a/docs/sql/tables.sql (about) 1 CREATE TABLE IF NOT EXISTS `user` ( 2 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID', 3 `username` varchar(32) DEFAULT '' COMMENT '用户名', 4 `password` varchar(60) NOT NULL DEFAULT '' COMMENT '密码', 5 PRIMARY KEY (`id`), 6 UNIQUE KEY `user_pk2` (`username`) USING BTREE 7 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';