表名：ZL_Guest_BarAuth












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2BarIDint40   是 栏目ID
3Uidint40   是 用户ID
4UNamenvarchar2000   是 用户名
5Lookint40   是 查看权限
6Sendint40   是 发贴权限
7Replyint40   是 回复贴权

简要说明：

贴吧权限表

GO
CREATE TABLE [dbo].[ZL_Guest_BarAuth](
[ID] [int] IDENTITY(1,1) NOT NULL,
[BarID] [int] NULL,
[Uid] [int] NULL,
[UName] [nvarchar](200) NULL,
[Look] [int] NULL,
[Send] [int] NULL,
[Reply] [int] NULL,
CONSTRAINT [PK_ZL_Bar_Auth] PRIMARY KEY CLUSTERED ([ID] ASC)WITH (PAD_INDEX  = OFF) ON [PRIMARY]) ON [PRIMARY]

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

detele from ZL_Guest_BarAuth

--注意：将删除整个表

drop table ZL_Guest_BarAuth

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

TRUNCATE table ZL_Guest_BarAuth