表名：ZL_Guestcate












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1Cateidint40是是 否 分类ID
2Catenamevarchar2550   否 分类名称
3GTypeint40   是 类型
4ParentIDint40   否0所属父栏目
5Permibitvarchar2550   是''0:版块,1:分类(不显示贴子)
6NeedLogint40   是 0:匿名可发贴等,1:必须登录
7PostAuthint40   是 发贴权限,同于NeedLog
8BarImagenvarchar2550   是 栏目图片
9Descnvarchar5000   是 描述
10BarInfonvarchar2550   是 栏目信息
11OrderIDint40   是 排序ID
12BarOwnervarchar5000   是 吧主的IDS
13Statusint40   是1贴吧状态 1,普通 2,贴子需要审核(不显示)3,贴子需要审核(显示)
14SendScoreint40   是 发贴积分
15ReplyScoreint40   是 回贴积分
16ZipImgSizeint40   是 压缩图片大小
17IsPlatint40   是 是分享到能力中心
18IsShowUnauditint40   是 未审核的内容是否可显

简要说明：

贴吧栏目分类表

GO

CREATE TABLE [dbo].[ZL_Guestcate](
[Cateid] [int] IDENTITY(1,1) NOT NULL,
[Catename] [varchar](255) NOT NULL,
[GType] [int] NULL,
[ParentID] [int] NOT NULL,
[Permibit] [varchar](255) NULL,
[NeedLog] [int] NULL,
[PostAuth] [int] NULL,
[BarImage] [nvarchar](255) NULL,
[Desc] [nvarchar](500) NULL,
[BarInfo] [nvarchar](255) NULL,
[OrderID] [int] NULL,
[BarOwner] [varchar](500) NULL,
[Status] [int] NULL,
[SendScore] [int] NULL,
[ReplyScore] [int] NULL,
[ZipImgSize] [int] NULL,
[IsPlat] [int] NULL,
[IsShowUnaudit] [int] NULL,
CONSTRAINT [PK_ZL_Guestcate] PRIMARY KEY NONCLUSTERED
(
[Cateid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ZL_Guestcate] ADD  CONSTRAINT [DF__ZL_Guestc__Paren__3CF40B7E]  DEFAULT ((0)) FOR [ParentID]
GO
ALTER TABLE [dbo].[ZL_Guestcate] ADD  CONSTRAINT [DF__ZL_Guestc__Permi__3DE82FB7]  DEFAULT ('') FOR [Permibit]
GO
ALTER TABLE [dbo].[ZL_Guestcate] ADD  CONSTRAINT [DF_ZL_Guestcate_Status]  DEFAULT ((1)) FOR [Status]

SET IDENTITY_INSERT [ZL_Guestcate] ON
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog]) VALUES ( 1,N'用户留言',0,0,1)
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog]) VALUES ( 2,N'站长互动',0,0,0)
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog]) VALUES ( 3,N'互动帮助',0,0,1)
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[BarInfo],[OrderID],[BarOwner]) VALUES ( 4,N'技术专区',1,0,0,N'Recommend',0,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[BarInfo],[OrderID],[BarOwner]) VALUES ( 5,N'生活空间',1,0,0,N'Recommend',0,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 6,N'官方服务',1,0,0,0,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 7,N'网页设计',1,4,0,2,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 8,N'资源共享',1,4,0,3,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 9,N'客服投诉',1,6,0,0,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 10,N'项目外包',1,4,0,4,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 13,N'版主会议室',1,6,1,0,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 14,N'程序人生',1,4,0,1,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 15,N'站务公告',1,6,0,2,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 16,N'地市动态',1,5,0,5,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 17,N'多彩生活',1,5,0,6,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 18,N'血拼购物',1,5,0,7,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 19,N'同城交友',1,5,0,8,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 20,N'二手置换',1,5,0,9,'1')
INSERT [ZL_Guestcate] ([Cateid],[Catename],[GType],[ParentID],[NeedLog],[OrderID],[BarOwner]) VALUES ( 21,N'诗书琴画',1,5,0,10,'1')
SET IDENTITY_INSERT [ZL_Guestcate] OFF

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

detele from ZL_Guestcate

--注意：将删除整个表

drop table ZL_Guestcate

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

TRUNCATE table ZL_Guestcate