权限脚本

aa

DROP TABLE IF EXISTS seq;
CREATE TABLE seq (
	currid int(11) NOT NULL,
	tname varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS users;
CREATE TABLE users (
	id int(11) NOT NULL,
	username varchar(100) NOT NULL,
	pwd varchar(200) NOT NULL,
	state char(1) default '1' NOT NULL,
	regtime varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS resources;
CREATE TABLE resources (
	id int(11) NOT NULL,
	name varchar(20) NOT NULL,
	type char(1) default '1' NOT NULL,
	method varchar(100),
	url varchar(100),
	pid int(11) NOT NULL,
	icon varchar(20),
	path varchar(100) NOT NULL,
	flag char(1) default '1' NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS log;
CREATE TABLE log (
	id int(11) NOT NULL,
	operator varchar(20) NOT NULL,
	ip varchar(40) NOT NULL,
	time varchar(20) NOT NULL,
	method varchar(40) NOT NULL,
	result char(1) NOT NULL,
	memo varchar(1000)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS role;
CREATE TABLE role (
	id int(11) NOT NULL,
	name varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS userrole;
CREATE TABLE userrole (
	userid int(11) NOT NULL,
	roleid int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS roleres;
CREATE TABLE roleres (
	roleid int(11) NOT NULL,
	resid int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS dic;
CREATE TABLE dic (
	id int(11) NOT NULL,
	name varchar(100) NOT NULL,
	val varchar(100) NOT NULL,
	type varchar(100) NOT NULL,
	memo int(11)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert into users values(-1,'admin','JBglCJM+uJx5UOkAHmoNpw==',1,'2008-08-08 08:08:08');


insert into resources values(1001,'系统管理',1,null,null,0,null,'1001',1);
insert into resources values(1002,'用户管理',2,null,'userlist.jsp',1001,null,'1001/1002',1);
insert into resources values(1003,'角色管理',2,null,'rolemgr.jsp',1001,null,'1001/1003',1);
insert into resources values(1004,'资源管理',2,null,'resmgr.jsp',1001,null,'1001/1004',1);
insert into resources values(1005,'数据字典',2,null,'dicmgr.jsp',1001,null,'1001/1005',1);
insert into resources values(1006,'日志管理',2,null,'aaa.jsp',1001,null,'1001/1006',1);
insert into resources values(1007,'用户删除',3,'PmsService.deluser','pmsdeluser',1002,null,'1001/1002/1007',1);
insert into resources values(1008,'用户分配角色',3,'PmsService.setrole','pmssetrole',1002,null,'1001/1002/1008',1);
insert into resources values(1009,'角色增加',3,'PmsService.addrole','pmsaddrole',1003,null,'1001/1003/1009',1);
insert into resources values(1010,'角色分配资源',3,'PmsService.setres','pmssetres',1003,null,'1001/1003/1010',1);
insert into resources values(1011,'资源增加',3,'PmsService.addres','pmsaddres',1004,null,'1001/1004/1011',1);
insert into resources values(1012,'资源删除',3,'PmsService.delres','pmsdelres',1004,null,'1001/1004/1012',1);
insert into resources values(1013,'字典增加',3,'PmsService.adddic','pmsadddic',1005,null,'1001/1005/1013',1);
insert into resources values(1014,'字典删除',3,'PmsService.deldic','pmsdeldic',1005,null,'1001/1005/1014',1);
insert into resources values(1015,'用户增加',3,'PmsService.reg','pmsreg',1002,null,'1001/1002/1015',1);
insert into resources values(1016,'用户激活',3,'PmsService.activeuser','pmsactiveuser',1002,null,'1001/1002/1016',1);
insert into resources values(1017,'用户禁止',3,'PmsService.canceluser','pmscanceluser',1002,null,'1001/1002/1017',1);