|
创建库- CREATE DATABASE `school` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
复制代码 创建表- CREATE TABLE `sys_user` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
- `username` varchar(50) NOT NULL,
- `password` varchar(50) NOT NULL,
- `nickname` varchar(50) NOT NULL,
- `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 可用 1 删除',
- `descinfo` varchar(200) DEFAULT ' ',
- `create_time` bigint(20) NOT NULL,
- `modify_time` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `username_UNIQUE` (`username`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
复制代码 增加唯一键- ALTER TABLE `school`.`sys_user` ADD UNIQUE INDEX `username_UNIQUE` (`username` ASC);
复制代码 |
|