SQL權(quán)限數(shù)據(jù)庫基礎(chǔ)庫設(shè)計(與EasyUI相關(guān))

1、精選文檔create database QxDBgouse QxDB-模塊create table ModuleInfo(Id int primary key,Name varchar(20),Sort int);insert into ModuleInfo values(800,'教務(wù)管理',800)insert into ModuleInfo values(900,'學(xué)生管理',900)-功能create table FunctionInfo(Id int primary key,Name varchar(20),Sort int,Url varchar(3

2、0),ModuleId int foreign key references ModuleInfo(Id);insert into FunctionInfo values(800100,'信息管理',100,'/Home/Index',800)insert into FunctionInfo values(900100,'成績管理',100,'/Home/Grade',900)-操作create table ActionInfo(Id int primary key,Name varchar(20),Icon varchar(20

3、),Method varchar(20),Sort int,FunctionId int foreign key references FunctionInfo(Id),);insert into ActionInfo values (80010010,'查詢','icon-search','saveFun',10,800100)insert into ActionInfo values (80010020,'新增','icon-add','addFun',20,800100)insert into

4、 ActionInfo values (80010030,'編輯','icon-edit','editFun',30,800100)insert into ActionInfo values (80010040,'刪除','icon-delete','deleteFun',40,800100)insert into ActionInfo values (90010010,'查詢','icon-search','saveFun',10,900100)in

5、sert into ActionInfo values (90010020,'新增','icon-add','addFun',20,900100)insert into ActionInfo values (90010030,'編輯','icon-edit','editFun',30,900100)insert into ActionInfo values (90010040,'刪除','icon-delete','deleteFun',40,9001

6、00)-角色create table RoleInfo(Id int primary key,Name varchar(20),Sort int);insert into RoleInfo values(100,'系統(tǒng)管理員',10)insert into RoleInfo values(200,'普通管理員',20)-角色對應(yīng)的權(quán)限create table RoleDetailInfo(Id int identity primary key,RoleId int foreign key references RoleInfo(Id),ActionId int

7、foreign key references ActionInfo(Id),);insert into RoleDetailInfo values (100,80010010)insert into RoleDetailInfo values (100,80010020)insert into RoleDetailInfo values (100,80010030)-用戶create table UserInfo(Id int primary key,Name varchar(20),Sort int);insert into UserInfo values (100,'張三'

8、,10)-用戶對應(yīng)的角色create table UserDetailInfo(Id int identity primary key,UserId int foreign key references UserInfo(Id),RoleId int foreign key references RoleInfo(Id),);insert into UserDetailInfo values(100,200)-字典信息表DictionaryInfocreate table DictionaryInfo(Id int primary key ,Name varchar(50) not null,

9、Category int not null);-靜態(tài)字典create table StaticDictionary(Id int primary key,Name varchar(50) not null,DictionaryId int,Sort int,);-基礎(chǔ)字典create table CommonDictionary(Id int primary key,Name varchar(50) not null,DictionaryId int,Sort int,);-Grid配置項表create table GridInfo(Id int primary key,Name varchar(30),AutoRowHeight int,FitColumns int,Striped int,Method varchar(30),NowRap int,IdField varchar(30),Url varchar(30),LoadMsg varchar(50),pagination int,RowNumbers int,SingleSelect int,CheckOnSelect int,Selec