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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
|
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `pe_permission`; CREATE TABLE `pe_permission` ( `id` varchar(40) NOT NULL COMMENT '主键', `name` varchar(255) DEFAULT NULL COMMENT '权限名称', `code` varchar(20) DEFAULT NULL, `description` text COMMENT '权限描述', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `pe_permission` VALUES ('1', '添加用户', 'user-add', null); INSERT INTO `pe_permission` VALUES ('2', '查询用户', 'user-find', null); INSERT INTO `pe_permission` VALUES ('3', '更新用户', 'user-update', null); INSERT INTO `pe_permission` VALUES ('4', '删除用户', 'user-delete', null);
DROP TABLE IF EXISTS `pe_role`; CREATE TABLE `pe_role` ( `id` varchar(40) NOT NULL COMMENT '主键ID', `name` varchar(40) DEFAULT NULL COMMENT '权限名称', `description` varchar(255) DEFAULT NULL COMMENT '说明', PRIMARY KEY (`id`), UNIQUE KEY `UK_k3beff7qglfn58qsf2yvbg41i` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `pe_role` VALUES ('1', '系统管理员', '系统日常维护'); INSERT INTO `pe_role` VALUES ('2', '普通员工', '普通操作权限');
DROP TABLE IF EXISTS `pe_role_permission`; CREATE TABLE `pe_role_permission` ( `role_id` varchar(40) NOT NULL COMMENT '角色ID', `permission_id` varchar(40) NOT NULL COMMENT '权限ID', PRIMARY KEY (`role_id`,`permission_id`), KEY `FK74qx7rkbtq2wqms78gljv87a0` (`permission_id`), KEY `FKee9dk0vg99shvsytflym6egxd` (`role_id`), CONSTRAINT `fk-p-rid` FOREIGN KEY (`role_id`) REFERENCES `pe_role` (`id`), CONSTRAINT `fk-pid` FOREIGN KEY (`permission_id`) REFERENCES `pe_permission` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `pe_role_permission` VALUES ('1', '1'); INSERT INTO `pe_role_permission` VALUES ('1', '2'); INSERT INTO `pe_role_permission` VALUES ('2', '2'); INSERT INTO `pe_role_permission` VALUES ('1', '3'); INSERT INTO `pe_role_permission` VALUES ('1', '4');
DROP TABLE IF EXISTS `pe_user`; CREATE TABLE `pe_user` ( `id` varchar(40) NOT NULL COMMENT 'ID', `username` varchar(255) NOT NULL COMMENT '用户名称', `password` varchar(255) DEFAULT NULL COMMENT '密码', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `pe_user` VALUES ('1', 'zhangsan', '123456'); INSERT INTO `pe_user` VALUES ('2', 'lisi', '123456'); INSERT INTO `pe_user` VALUES ('3', 'wangwu', '123456');
DROP TABLE IF EXISTS `pe_user_role`; CREATE TABLE `pe_user_role` ( `role_id` varchar(40) NOT NULL COMMENT '角色ID', `user_id` varchar(40) NOT NULL COMMENT '权限ID', KEY `FK74qx7rkbtq2wqms78gljv87a1` (`role_id`), KEY `FKee9dk0vg99shvsytflym6egx1` (`user_id`), CONSTRAINT `fk-rid` FOREIGN KEY (`role_id`) REFERENCES `pe_role` (`id`), CONSTRAINT `fk-uid` FOREIGN KEY (`user_id`) REFERENCES `pe_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `pe_user_role` VALUES ('1', '1');
|