1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户自增Id', `username` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '用户登录名', `password` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '用户登录密码', `isEnable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户是否被禁用(1:禁用,0:启用)', `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '真实姓名', `avatar` varchar(300) COLLATE utf8_bin DEFAULT NULL COMMENT '用户头像', `phone` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '用户电话', `QQ` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'QQ', `wechat` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '微信', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; insert into `admin`(`id`,`username`,`password`,`isEnable`,`name`,`avatar`,`phone`,`QQ`,`wechat`) values (1,'admin','$2a$10$7PMd9hwuYYe6.8rgmfn1x.GbrS4FyuH1nf80xb45zqm/ntZyzccBG',1,'张三','密码为111,这个字段是给头像用的','111','2548841623','微信'), (2,'admins','$2a$10$k.uVP6DEc/X.DceezRIi1.zALL6rhsMpCVZFbt6pZDppdFV3wLIWi',1,'李四','密码为111,这个字段是给头像用的','111','111','111'); CREATE TABLE `admin_role` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户表与角色表的关联表自增ID', `adminID` int(11) NOT NULL COMMENT '对应用户表的ID', `roleID` int(11) NOT NULL COMMENT '对于角色表的ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; insert into `admin_role`(`id`,`adminID`,`roleID`) values (1,1,1); CREATE TABLE `role` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色表自增Id', `name` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '角色的英文名,给电脑用的', `nameZH` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '角色中文名,给用户看的', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; insert into `role`(`id`,`name`,`nameZH`) values (1,'ROLE_system','系统管理员'), (2,'ROLE_admin','用户'), (3,'ROLE_user','普通用户');
|