权限管理--设计表

感谢我的网友--yshin提供的资料

基本表

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Base_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Base_User]
GO

CREATE TABLE [dbo].[Base_User] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[User_no] [nvarchar] (50) COLLATE Chinese_PRC_BIN NOT NULL ,
[User_wkno] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[User_name] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[User_pass] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[User_per] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[User_mail] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[User_sect] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[User_veri] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[Set_time] [smalldatetime] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Class_Per]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Class_Per]
GO

CREATE TABLE [dbo].[Class_Per] (
[per_no] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[per_class] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Class_Sect]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Class_Sect]
GO

CREATE TABLE [dbo].[Class_Sect] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[sect_no] [nvarchar] (10) COLLATE Chinese_PRC_BIN NOT NULL ,
[sect_class] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Class_Veri]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Class_Veri]
GO

CREATE TABLE [dbo].[Class_Veri] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[veri_no] [nvarchar] (50) COLLATE Chinese_PRC_BIN NOT NULL ,
[veri_class] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Menu_Oper]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Menu_Oper]
GO

CREATE TABLE [dbo].[Menu_Oper] (
[id] [varchar] (50) COLLATE Chinese_PRC_BIN NOT NULL ,
[title] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Menu_Tree]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Menu_Tree]
GO

CREATE TABLE [dbo].[Menu_Tree] (
[no] [int] IDENTITY (11, 1) NOT NULL ,
[id] [nvarchar] (50) COLLATE Chinese_PRC_BIN NOT NULL ,
[node] [nvarchar] (3) COLLATE Chinese_PRC_BIN NULL ,
[root] [nvarchar] (3) COLLATE Chinese_PRC_BIN NULL ,
[text] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[open_href] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[leaf] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[per] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[other] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[orderby] [int] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Per_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Per_user]
GO

CREATE TABLE [dbo].[Per_user] (
[per_no] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL ,
[tree_no] [nvarchar] (50) COLLATE Chinese_PRC_BIN NULL
) ON [PRIMARY]
GO