数据库表的设计

xiaoxiao2021-12-13 17

CREATE TABLE `uc_user` ( `user_id` varchar(128) CHARACTER SET ujis NOT NULL DEFAULT 'NULL', `name` char(36) NOT NULL COMMENT '帐号名', `password` char(50) NOT NULL COMMENT '密码', `avatar` blob NOT NULL COMMENT 'avatar字符串', PRIMARY KEY (`user_id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `user_id` (`user_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户中心表'; ALTER TABLE `uc_user` MODIFY COLUMN `user_id` varchar(128) CHARACTER SET ujis NOT NULL DEFAULT 'NULL' FIRST , ADD UNIQUE INDEX `user_id` USING BTREE (`user_id`) ;

转载请注明原文地址: https://ju.6miu.com/read-950244.html

专利

最新回复(0)