表名：ZL_DocPermission












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2UserIDvarchar500   是  
3UserNamenvarchar500   是 用户名
4GroupNamenvarchar500   是 所属权限组
5Statusvarchar100   是 1,权限组2,用户与权限组的关联,不设的话为默认组
6OnlyMevarchar100   是 能否看到其他人的文章
7AllowNodesvarchar1000   是 允许节点
8CreateAblevarchar100   是 允许创建
9RetrieveAblevarchar100   是 允许查询
10UpdateAblevarchar100   是 允许更新
11DeleteAblevarchar100   是 允许删除
12Remindnvarchar1000   是 备注信息（预留字段）
13OwnGroupIDvarchar100   是 所属权限组ID

简要说明：

项目成员比表

CREATE TABLE [dbo].[ZL_DocPermission] (
[ID] [int]  IDENTITY (1, 1)  NOT NULL,
[UserID] [varchar]  (50) NULL,
[UserName] [nvarchar]  (50) NULL,
[GroupName] [nvarchar]  (50) NULL,
[Status] [varchar]  (10) NULL,
[OnlyMe] [varchar]  (10) NULL,
[AllowNodes] [varchar]  (100) NULL,
[CreateAble] [varchar]  (10) NULL,
[RetrieveAble] [varchar]  (10) NULL,
[UpdateAble] [varchar]  (10) NULL,
[DeleteAble] [varchar]  (10) NULL,
[Remind] [nvarchar]  (100) NULL,
[OwnGroupID] [varchar]  (10) NULL)

ALTER TABLE [ZL_DocPermission] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_DocPermission] PRIMARY KEY  NONCLUSTERED ( [ID] )
SET IDENTITY_INSERT [ZL_DocPermission] ON
INSERT [ZL_DocPermission] ([ID],[UserID],[GroupName],[Status],[OnlyMe],[AllowNodes],[CreateAble],[RetrieveAble],[UpdateAble],[DeleteAble],[Remind]) VALUES ( 1,N'0',N'默认组',N'1',N'1',N'1',N'1',N'1',N'1',N'0',N'当你未给用户指定组,默认拥有此组权限')
INSERT [ZL_DocPermission] ([ID],[UserID],[GroupName],[Status],[OnlyMe],[AllowNodes],[CreateAble],[RetrieveAble],[UpdateAble],[DeleteAble]) VALUES ( 2,N'0',N'用户组',N'1',N'0',N'1',N'1',N'1',N'0',N'0')
INSERT [ZL_DocPermission] ([ID],[UserID],[GroupName],[Status],[OnlyMe],[CreateAble],[UpdateAble],[DeleteAble]) VALUES ( 3,N'0',N'管理组',N'1',N'1',N'1',N'1',N'1')
SET IDENTITY_INSERT [ZL_DocPermission] OFF

--注意：将清空全表数据

detele from ZL_DocPermission

--注意：将删除整个表

drop table ZL_DocPermission

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_DocPermission