权限管理--设计表

感谢我的网友--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'IsUse