/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 5.6.24 : Database - mydb
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
CREATE DATABASE /!32312 IF NOT EXISTS*/mydb /*!40100 DEFAULT CHARACTER SET utf8 */;
USE mydb;
/*Table structure for table menuinfo */
DROP TABLE IF EXISTS menuinfo;
CREATE TABLE menuinfo (id int(11) NOT NULL AUTO_INCREMENT,MenuName varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*Data for the table menuinfo */
insert into menuinfo(id,MenuName) values (1,'文件'),(2,'编辑'),(3,'查看'),(4,'格式'),(5,'帮助');
/*Table structure for table roleinfo */
DROP TABLE IF EXISTS roleinfo;
CREATE TABLE roleinfo (id int(11) NOT NULL AUTO_INCREMENT,RoleName varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*Data for the table roleinfo */
insert into roleinfo(id,RoleName) values (1,'管理员'),(2,'客户'),(3,'VIP'),(4,'游客');
/*Table structure for table rolemenu */
DROP TABLE IF EXISTS rolemenu;
CREATE TABLE rolemenu (id int(11) NOT NULL AUTO_INCREMENT,RoleId int(11) DEFAULT NULL,MenuId int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY FK_rolemenu_1 (RoleId),
KEY FK_rolemenu_2 (MenuId),
CONSTRAINT FK_rolemenu_1 FOREIGN KEY (RoleId) REFERENCES roleinfo (id),
CONSTRAINT FK_rolemenu_2 FOREIGN KEY (MenuId) REFERENCES menuinfo (id)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*Data for the table rolemenu */
insert into rolemenu(id,RoleId,MenuId) values (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,2,1),(7,2,3),(8,2,5),(9,3,1),(10,3,3),(11,3,4),(12,3,5),(13,4,3),(14,4,5);
/*Table structure for table userinfo */
DROP TABLE IF EXISTS userinfo;
CREATE TABLE userinfo (id int(11) NOT NULL AUTO_INCREMENT,username varchar(20) DEFAULT NULL,userpassword varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*Data for the table userinfo */
insert into userinfo(id,username,userpassword) values (1,'网管','123456'),(2,'小学生','111111'),(3,'黄钻','222222'),(4,'路人甲',NULL),(5,'网小管','154321'),(6,'初中生','111111'),(7,'高中生','111111');
/*Table structure for table userrole */
DROP TABLE IF EXISTS userrole;
CREATE TABLE userrole (id int(11) NOT NULL AUTO_INCREMENT,UserId int(11) DEFAULT NULL,RoleId int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY FK_userrole (UserId),
KEY FK_userrole_1 (RoleId),
CONSTRAINT FK_userrole FOREIGN KEY (UserId) REFERENCES userinfo (id),
CONSTRAINT FK_userrole_1 FOREIGN KEY (RoleId) REFERENCES roleinfo (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*Data for the table userrole */
insert into userrole(id,UserId,RoleId) values (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,1),(6,6,2),(7,7,2);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
