/*
SQLyog Community v13.1.6 (64 bit)
MySQL - 5.7.31-log : Database - authoritymanagement
*********************************************************************
*/

/*!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*/`authoritymanagement` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `authoritymanagement`;

/*Table structure for table `t_fun` */

DROP TABLE IF EXISTS `t_fun`;

CREATE TABLE `t_fun` (
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `fname` varchar(16) DEFAULT NULL COMMENT '功能名称',
  `ftype` int(11) DEFAULT NULL COMMENT '功能类别1菜单2按钮',
  `fhref` varchar(64) DEFAULT NULL COMMENT '菜单对应的请求',
  `fauth` varchar(32) DEFAULT NULL COMMENT '权限标识',
  `pid` int(11) DEFAULT NULL COMMENT '父级功能id,根菜单的父级功能是-1',
  `reserve1` varchar(16) DEFAULT NULL,
  `reserve2` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

/*Data for the table `t_fun` */

insert  into `t_fun`(`fid`,`fname`,`ftype`,`fhref`,`fauth`,`pid`,`reserve1`,`reserve2`) values 
(1,'权限管理',1,NULL,'com.qxgl.auth',-1,NULL,NULL),
(2,'用户管理',1,'findUser?page=1&rows=10','com.qxgl.auth.user',1,NULL,NULL),
(3,'角色管理',1,'role.jsp','com.qxgl.auth.role',1,NULL,NULL),
(4,'功能管理',1,'fun.jsp','com.qxgl.auth.fun',1,NULL,NULL),
(5,'基本信息管理',1,NULL,'com.qxgl.base',-1,NULL,NULL),
(6,'药品管理',1,'ypFindAll','com.qxgl.base.yp',5,NULL,NULL),
(7,'供应商管理',1,'gysFindAll','com.qxgl.base.gys',5,NULL,NULL),
(8,'药局管理',1,'yjFindAll','com.qxgl.base.yj',5,NULL,NULL),
(9,'用户新建',2,NULL,'com.qxgl.auth.user.add',2,NULL,NULL),
(10,'用户删除',2,NULL,'com.qxgl.auth.user.delete',2,NULL,NULL),
(11,'住院',1,'','com.zy',-1,NULL,NULL),
(12,'入院登记',1,NULL,'com.zy.sq',11,NULL,NULL),
(20,'编辑',2,NULL,'com.qxgl.auth.user.edit',2,NULL,NULL),
(21,'角色分配',2,NULL,'com.qxgl.auth.user.assignRoles',2,NULL,NULL),
(22,'添加角色',2,NULL,'com.qxgl.auth.role.add',3,NULL,NULL),
(24,'删除角色',2,NULL,'com.qxgl.auth.role.delete',3,NULL,NULL),
(25,'编辑角色',2,NULL,'com.qxgl.auth.role.edit',3,NULL,NULL),
(26,'功能分配',2,NULL,'com.qxgl.auth.role.setFuns',3,NULL,NULL),
(27,'新建功能',2,NULL,'com.qxgl.auth.fun.add',4,NULL,NULL),
(28,'修改',2,NULL,'com.qxgl.auth.fun.funUpdate',4,NULL,NULL),
(29,'删除',2,NULL,'com.qxgl.auth.fun.dfun',4,NULL,NULL),
(31,'护士站管理',1,NULL,'com.zy.hszgl',11,NULL,NULL);

/*Table structure for table `t_role` */

DROP TABLE IF EXISTS `t_role`;

CREATE TABLE `t_role` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `rname` varchar(16) DEFAULT NULL,
  `rdescription` varchar(32) DEFAULT NULL,
  `reserve1` varchar(16) DEFAULT NULL,
  `reserve2` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

/*Data for the table `t_role` */

insert  into `t_role`(`rid`,`rname`,`rdescription`,`reserve1`,`reserve2`) values 
(1,'普通员工','很牛',NULL,NULL),
(2,'组长','很牛',NULL,NULL),
(3,'总管','很牛',NULL,NULL),
(4,'经理','很牛',NULL,NULL),
(5,'管理员5','很牛',NULL,NULL),
(6,'管理员666','很牛666',NULL,NULL),
(7,'管理员7','很牛',NULL,NULL),
(8,'管理员8','很牛',NULL,NULL),
(9,'管理员9','很牛',NULL,NULL),
(10,'管理员10','很牛',NULL,NULL),
(11,'管理员11','很牛',NULL,NULL),
(12,'管理员12','很牛',NULL,NULL),
(13,'管理员13','很牛',NULL,NULL),
(15,'22','22',NULL,NULL);

/*Table structure for table `t_role_fun` */

DROP TABLE IF EXISTS `t_role_fun`;

CREATE TABLE `t_role_fun` (
  `rid` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  PRIMARY KEY (`rid`,`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_role_fun` */

insert  into `t_role_fun`(`rid`,`fid`) values 
(1,5),
(1,6),
(1,7),
(1,8),
(4,1),
(4,2),
(4,3),
(4,4),
(4,5),
(4,6),
(4,7),
(4,8),
(4,9),
(4,10),
(4,11),
(4,12),
(4,20),
(4,21),
(4,22),
(4,24),
(4,25),
(4,26),
(4,27),
(4,28),
(4,29);

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(32) DEFAULT NULL,
  `upass` varchar(32) DEFAULT NULL,
  `reserve1` varchar(32) DEFAULT NULL,
  `reserve2` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

/*Data for the table `t_user` */

insert  into `t_user`(`uid`,`uname`,`upass`,`reserve1`,`reserve2`) values 
(2,'张三','123456','1',NULL),
(3,'李四','123456','1',NULL),
(4,'ttt1','123456','0',NULL),
(5,'ttt2','123456','0',NULL),
(6,'ttt3','123456','0',NULL),
(7,'ttt4','123456','0',NULL),
(10,'ttt7','123456','0',NULL),
(11,'ttt8','123456','1',NULL),
(12,'ttt9','123456','1',NULL),
(13,'ttt10','123456','1',NULL),
(14,'ttt11','123456','0',NULL),
(15,'ttt12','123456','0',NULL),
(16,'ttt13','123456','0',NULL),
(17,'ttt14','123456','1',NULL),
(18,'ttt15','123456','1',NULL),
(19,'ttt16','123456','1',NULL),
(20,'ttt17','123456','1',NULL),
(21,'ttt18','123456','1',NULL),
(22,'ttt19','123456','1',NULL),
(23,'ttt20','123456','1',NULL),
(24,'ttt21','123456','1',NULL),
(25,'th1','123456','1',NULL),
(26,'th2','123456','1',NULL),
(27,'th3','123456','1',NULL),
(28,'th4','123456','1',NULL),
(29,'th5','123456','1',NULL),
(30,'th6','123456','1',NULL),
(31,'th7','123456','1',NULL),
(32,'th8','123456','1',NULL),
(33,'th9','123456','1',NULL),
(34,'th1','123456','1',NULL),
(35,'th2','123456','1',NULL),
(36,'th3','123456','1',NULL),
(37,'th4','123456','1',NULL),
(38,'th5','123456','1',NULL),
(39,'th6','123456','1',NULL),
(40,'th7','123456','1',NULL),
(41,'th8','123456','1',NULL),
(42,'th99','123456','1',NULL),
(43,'th1','123456','1',NULL),
(44,'th2','123456','1',NULL),
(45,'th3','123456','1',NULL),
(46,'th4','123456','1',NULL),
(47,'th5','123456','1',NULL),
(48,'th6','123456','1',NULL),
(49,'th7','123456','1',NULL),
(50,'th8','123456','1',NULL),
(51,'th9','123456','1',NULL);

/*Table structure for table `t_user_role` */

DROP TABLE IF EXISTS `t_user_role`;

CREATE TABLE `t_user_role` (
  `uid` int(11) NOT NULL,
  `rid` int(11) NOT NULL,
  PRIMARY KEY (`uid`,`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_user_role` */

insert  into `t_user_role`(`uid`,`rid`) values 
(2,1),
(2,4),
(9,1);

/*!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 */;