第十讲 shiro （4）所需要的数据表

冷不防 2022-05-23 11:48 170阅读 0赞

![20180608103243342][]

\----------------------------  
shiro.sql文件的内容如下：  
\----------------------------

/\*  
Navicat MySQL Data Transfer  
  
  
Source Server : bengdi  
Source Server Version : 50611  
Source Host : localhost:3306  
Source Database : shrio  
  
  
Target Server Type : MYSQL  
Target Server Version : 50611  
File Encoding : 65001  
  
  
Date: 2018-06-09 03:37:17  
\*/  
  
  
SET FOREIGN\_KEY\_CHECKS=0;  
  
  
\-- ----------------------------  
\-- Table structure for \`p\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`p\`;  
CREATE TABLE \`p\` (  
\`id\` int(10) unsigned NOT NULL AUTO\_INCREMENT,  
\`pname\` varchar(45) NOT NULL,  
PRIMARY KEY (\`id\`) USING BTREE  
) ENGINE=InnoDB AUTO\_INCREMENT=7 DEFAULT CHARSET=gbk;  
  
  
\-- ----------------------------  
\-- Records of p  
\-- ----------------------------  
INSERT INTO \`p\` VALUES ('1', 'dele');  
INSERT INTO \`p\` VALUES ('4', 'add');  
INSERT INTO \`p\` VALUES ('5', 'update');  
INSERT INTO \`p\` VALUES ('6', 'select');  
  
  
\-- ----------------------------  
\-- Table structure for \`role\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`role\`;  
CREATE TABLE \`role\` (  
\`id\` int(10) unsigned NOT NULL AUTO\_INCREMENT,  
\`name\` varchar(45) NOT NULL,  
PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=3 DEFAULT CHARSET=gbk;  
  
  
\-- ----------------------------  
\-- Records of role  
\-- ----------------------------  
INSERT INTO \`role\` VALUES ('1', 'admin');  
INSERT INTO \`role\` VALUES ('2', 'guest');  
  
  
\-- ----------------------------  
\-- Table structure for \`rp\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`rp\`;  
CREATE TABLE \`rp\` (  
\`roleid\` int(10) unsigned NOT NULL AUTO\_INCREMENT,  
\`permissionid\` int(10) unsigned NOT NULL,  
PRIMARY KEY (\`roleid\`,\`permissionid\`) USING BTREE,  
KEY \`FK\_mapping\_rp\_1\` (\`permissionid\`),  
CONSTRAINT \`FK\_mapping\_rp\_1\` FOREIGN KEY (\`permissionid\`) REFERENCES \`p\` (\`id\`),  
CONSTRAINT \`FK\_mapping\_rp\_2\` FOREIGN KEY (\`roleid\`) REFERENCES \`role\` (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=3 DEFAULT CHARSET=gbk;  
  
  
\-- ----------------------------  
\-- Records of rp  
\-- ----------------------------  
INSERT INTO \`rp\` VALUES ('1', '1');  
INSERT INTO \`rp\` VALUES ('1', '4');  
INSERT INTO \`rp\` VALUES ('1', '5');  
INSERT INTO \`rp\` VALUES ('1', '6');  
INSERT INTO \`rp\` VALUES ('2', '6');  
  
  
\-- ----------------------------  
\-- Table structure for \`ur\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`ur\`;  
CREATE TABLE \`ur\` (  
\`userid\` int(10) unsigned NOT NULL AUTO\_INCREMENT,  
\`roleid\` int(10) unsigned NOT NULL DEFAULT '0',  
PRIMARY KEY (\`userid\`,\`roleid\`),  
KEY \`FK\_mapper\_ur\_2\` (\`roleid\`),  
CONSTRAINT \`FK\_mapper\_ur\_1\` FOREIGN KEY (\`userid\`) REFERENCES \`user\` (\`id\`),  
CONSTRAINT \`FK\_mapper\_ur\_2\` FOREIGN KEY (\`roleid\`) REFERENCES \`role\` (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=42 DEFAULT CHARSET=gbk;  
  
  
\-- ----------------------------  
\-- Records of ur  
\-- ----------------------------  
INSERT INTO \`ur\` VALUES ('30', '1');  
INSERT INTO \`ur\` VALUES ('36', '1');  
INSERT INTO \`ur\` VALUES ('37', '1');  
INSERT INTO \`ur\` VALUES ('40', '1');  
INSERT INTO \`ur\` VALUES ('41', '1');  
INSERT INTO \`ur\` VALUES ('30', '2');  
INSERT INTO \`ur\` VALUES ('35', '2');  
INSERT INTO \`ur\` VALUES ('37', '2');  
INSERT INTO \`ur\` VALUES ('38', '2');  
INSERT INTO \`ur\` VALUES ('39', '2');  
  
  
\-- ----------------------------  
\-- Table structure for \`user\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`user\`;  
CREATE TABLE \`user\` (  
\`id\` int(10) unsigned NOT NULL AUTO\_INCREMENT,  
\`username\` varchar(45) NOT NULL,  
\`password\` varchar(200) NOT NULL,  
PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=42 DEFAULT CHARSET=gbk;  
  
  
\-- ----------------------------  
\-- Records of user  
\-- ----------------------------  
INSERT INTO \`user\` VALUES ('30', '12', '$shiro1$SHA-512$1$$Wq20VSDc2HJrKCKnp4u1PXlPVXGZ1dSr3t0sVaS9bKc2B2BcVY3j24DI6GwxlkhFZhY+0TJ+gui2dX0ZMhE8uA==');  
INSERT INTO \`user\` VALUES ('35', '11', '$shiro1$SHA-512$1$$dKScaY29PBLjawsodEfYM/dPOTf/Ey6/9wVLqhhiPDWnBbsYuC4qwDhLUSfblwFuY2CfcSvJDjUGz76pdZn0bw==');  
INSERT INTO \`user\` VALUES ('36', 'aaaa', 'aaaa');  
INSERT INTO \`user\` VALUES ('37', 'bbbb', 'bbbb');  
INSERT INTO \`user\` VALUES ('38', 'cccc', 'cccc');  
INSERT INTO \`user\` VALUES ('39', 'dddd', 'dddd');  
INSERT INTO \`user\` VALUES ('40', 'eeee', 'eeee');  
INSERT INTO \`user\` VALUES ('41', 'ffff', 'ffff');

[20180608103243342]: /images/20220523/c6ed0867243c44e6b9db98edb3cd6083.png