表名：ZL_Guest_Bar












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2Gidvarchar500   是 内容模型ID
3CateIDint40   否 所属贴吧
4Pidint40   否 所属留言,便于获取
5ReplyIDint40   是 回复留言编号
6ReplyUserIDint40   是 回复留言的用户ID
7Titlenvarchar2000   是 回复标题
8MsgContentntext160   是 回复内容
9IPnvarchar2000   是 IP地址
10ColledIDSnvarchar40000   是 收藏了该条信息的用户IDS
11MsgTypeint40   是 消息类型
12Statusint40   是 状态
13CUserint40   是 创建人UserID
14CUNamenvarchar500   是 创建人用户名
15CDatedatetime83   是 创建时间
16Subtitlenvarchar30000   是 副标题
17PostFlagnvarchar3000   是 提交标识
18Stylenvarchar2000   是 绑定样式
19OrderFlagint40   否01,版面置顶；2,全局置顶
20HitCountint40   是 点击量
21IDCodenvarchar500   是 身份标记,用于区分不同的匿名用户
22LikeIDSnvarchar5000   否''收藏该帖的用户IDS
23R_CUserint40   是 最近一次的回贴记录
24R_CUNamenvarchar500   是 最后一次回帖用户名
25R_CDatedatetime83   是 最后一次回帖时间

简要说明：

贴吧贴子表

GO

CREATE TABLE [dbo].[ZL_Guest_Bar](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Gid] [varchar](50) NULL,
[CateID] [int] NOT NULL,
[Pid] [int] NOT NULL,
[ReplyID] [int] NULL,
[ReplyUserID] [int] NULL,
[Title] [nvarchar](200) NULL,
[MsgContent] [ntext] NULL,
[IP] [nvarchar](200) NULL,
[ColledIDS] [nvarchar](4000) NULL,
[MsgType] [int] NULL,
[Status] [int] NULL,
[CUser] [int] NULL,
[CUName] [nvarchar](50) NULL,
[CDate] [datetime] NULL,
[Subtitle] [nvarchar](3000) NULL,
[PostFlag] [nvarchar](300) NULL,
[Style] [nvarchar](200) NULL,
[OrderFlag] [int] NOT NULL,
[HitCount] [int] NULL,
[IDCode] [nvarchar](50) NULL,
[LikeIDS] [nvarchar](500) NOT NULL,
[R_CUser] [int] NULL,
[R_CUName] [nvarchar](50) NULL,
[R_CDate] [datetime] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ZL_Guest_Bar] ADD  CONSTRAINT [DF_ZL_Guest_Bar_ColledIDS]  DEFAULT ('') FOR [ColledIDS]
GO
ALTER TABLE [dbo].[ZL_Guest_Bar] ADD  CONSTRAINT [DF_ZL_Guest_Bar_OrderFlag]  DEFAULT ((0)) FOR [OrderFlag]
GO
ALTER TABLE [dbo].[ZL_Guest_Bar] ADD  CONSTRAINT [DF_ZL_Guest_Bar_LikeIDS]  DEFAULT ('') FOR [LikeIDS]

SET IDENTITY_INSERT [ZL_Guest_Bar] ON
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[PostFlag],[OrderFlag]) VALUES ( 1,7,0,0,0,N'11个实用经典的SQL小贴士',N'H4sIAAAAAAAEALMpsDM0fLJj1dN1855PWfF8d//T1h3PZ7UEB/o83dD/YsuWp4tX2yQV6dvZZOamKxQXJdsq6YcW5OQnprhl5qQW66ek5ubrJ6aY6GUVpCspFJdU5qTaKikplGSWgBgwCaB2/QI7AD94t4prAAAA',1,99,0,N'匿名用户',N'2015/1/15 13:45:32',N'11个实用经典的SQL小贴士<br/><p><img src="/UploadFiles/demo/ad4.jpg" style="" title="ad4.jpg"/></p><ul class=''thumbul''></ul>',N',Recommend,''',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[PostFlag],[OrderFlag]) VALUES ( 2,7,0,0,0,N'商城网站php源码模板 时尚简约大方 支持电脑手机微信app版本',N'H4sIAAAAAAAEALMpsHs6te3p/L7neyc+Xz2zIKPg2a4Jzxc0Plux8Nnc/QrPpm97umHW83UNz3cte7pk+bNpOxWeTVn/rKfx+ZStL1omPuvsfjZn19N9657sX5hYUPC8s+PZnDU2SUX6djaZuekKxUXJtkr6oQU5+Ykpbpk5qcX6Kam5+fqJKcZ6WQXpSgrFJZU5qbZKSgolmSUgBkwCqF2/wA4ALVhlkpsAAAA=',1,99,0,N'匿名用户',N'2015/1/15 13:45:39',N'商城网站php源码模板时尚简约大方支持电脑手机微信app版本<br/><p><img src="/UploadFiles/demo/ad3.jpg" style="" title="ad3.jpg"/></p><ul class=''thumbul''></ul>',N',Recommend,''',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[PostFlag],[OrderFlag]) VALUES ( 3,8,0,0,0,N'CSS的50个代码片段',N'H4sIAAAAAAAEALMpsHMODn4+q8XU4MmOVU92L36+oPF5Z/uzdVvV8pKKC6xt9AvsANhc1C4kAAAA',1,99,0,N'匿名用户',N'2015/1/15 13:45:45',N'CSS的50个代码片段<br/><ul class=''thumbul''></ul>',N',Recommend,''',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 4,8,0,0,0,N'我是小白，怎么在一天内有自己的网站',N'H4sIAAAAAAAEAAE6AMX/PHA+5oiR5piv5bCP55m977yM5oCO5LmI5Zyo5LiA5aSp5YaF5pyJ6Ieq5bex55qE572R56uZPC9wPjFtPFc6AAAA',1,99,0,N'匿名用户',N'2015/1/15 13:45:53',N'我是小白，怎么在一天内有自己的网站<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 5,10,0,0,0,N'JavaScript继承详解（三）',N'H4sIAAAAAAAEAAEmANn/PHA+SmF2YVNjcmlwdOe7p+aJv+ivpuino++8iOS4ie+8iTwvcD4T5bJGJgAAAA==',1,99,0,N'匿名用户',N'2015/1/15 13:46:00',N'JavaScript继承详解（三）<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 6,10,0,0,0,N'清新优雅鲜花店商城模板分享，支持手机+微信+app',N'H4sIAAAAAAAEAAFIALf/PHA+5riF5paw5LyY6ZuF6bKc6Iqx5bqX5ZWG5Z+O5qih5p2/5YiG5Lqr77yM5pSv5oyB5omL5py6K+W+ruS/oSthcHA8L3A+TtdmlEgAAAA=',1,99,0,N'匿名用户',N'2015/1/15 13:46:07',N'清新优雅鲜花店商城模板分享，支持手机+微信+app<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 7,14,0,0,0,N'JavaScript继承详解',N'H4sIAAAAAAAEALMpsPNKLEsMTi7KLCh5vnv5s879L9Yve7F8sVpeUnGBtY1+gR0AP0wj2yMAAAA=',1,99,0,N'匿名用户',N'2015/1/15 13:46:18',N'JavaScript继承详解<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 8,14,0,0,0,N'Bootstrap-布局系统杂记',N'H4sIAAAAAAAEAAEpANb/PHA+Qm9vdHN0cmFwLeW4g+WxgOezu+e7n+adguiusCZuYnNwOzwvcD6n3qYiKQAAAA==',1,99,0,N'匿名用户',N'2015/1/15 13:46:25',N'Bootstrap-布局系统杂记<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 9,16,0,0,0,N'scrollWidth,clientWidth,offsetWidth的区别',N'H4sIAAAAAAAEALMpsLNJVMgoSk2zVcooKSmw0tdPSirWq8rPz81J1EvO0y/OyC8vyS/ITNY1tjAzNzXTSywuqFCyK04uys/JCc9MKcnQSc7JTM0rgbDz09KKUyHs57Nanvbsetqx2kY/0U4tL6m4wNpGv8AOAG7bygNyAAAA',1,99,0,N'匿名用户',N'2015/1/15 13:46:32',N'scrollWidth,clientWidth,offsetWidth的区别<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 10,16,0,0,0,N'移动web滑屏框架分享',N'H4sIAAAAAAAEAAEoANf/PHA+56e75Yqod2Vi5ruR5bGP5qGG5p625YiG5LqrJm5ic3A7PC9wPqYVNRkoAAAA',1,99,0,N'匿名用户',N'2015/1/15 13:48:19',N'移动web滑屏框架分享<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag],[HitCount]) VALUES ( 11,17,0,0,0,N'推荐一个威客网，一元就可以提现了。',N'H4sIAAAAAAAEAAFAAL//PHA+5o6o6I2Q5LiA5Liq5aiB5a6i572R77yM5LiA5YWD5bCx5Y+v5Lul5o+Q546w5LqG44CCJm5ic3A7PC9wPm+Iy+dAAAAA',1,99,0,N'匿名用户',N'2015/1/15 13:48:27',N'推荐一个威客网，一元就可以提现了。<br/><ul class=''thumbul''></ul>',0,1)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag]) VALUES ( 12,17,0,0,0,N'CSS选择器、优先级与匹配原理',N'H4sIAAAAAAAEAAE0AMv/PHA+Q1NT6YCJ5oup5Zmo44CB5LyY5YWI57qn5LiO5Yy56YWN5Y6f55CGJm5ic3A7PC9wPggH6cA0AAAA',1,99,1,N'admin',N'2015/1/15 16:03:04',N'CSS选择器、优先级与匹配原理<br/><ul class=''thumbul''></ul>',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[PostFlag],[OrderFlag]) VALUES ( 13,18,0,0,0,N'11款导航PNG源文件',N'H4sIAAAAAAAEALMpsDM0fLZm39P1e150rArwc3+2a8Kzae1Pdm+zSSrSt7PJzE1XKC5KtlXSDy3IyU9MccvMSS3WT0nNzddPTDHSyypIV1IoLqnMSbVVUlIoySwBMWASQO36BXYAaEmsS2IAAAA=',1,99,1,N'admin',N'2015/1/15 16:03:12',N'11款导航PNG源文件<br/><p><img src="/UploadFiles/demo/ad2.jpg" style="" title="ad2.jpg"/></p><ul class=''thumbul''></ul>',N',Recommend,''',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[PostFlag],[OrderFlag]) VALUES ( 14,18,0,0,0,N'设计人应该知道设计中常见的劫难，和秒秒学来看看吧！',N'H4sIAAAAAAAEALMpsLPJzE1XKC5KtlXSDy3IyU9MccvMSS3WT0nNzddPTDHVyypIV1IoLqnMSbVVUlIoySwBMWAS+nY2+kAjhqUpSUUQNgCauhkGJAEAAA==',1,99,1,N'admin',N'2015/1/15 16:03:54',N'<br/><ul class=''thumbul''><li class=''thumbli''><img src="/UploadFiles/demo/ad5.jpg" style="" title="ad5.jpg"/></li><li class=''thumbli''><img src="/UploadFiles/demo/ad5.jpg" style="" title="ad5.jpg"/></li><li class=''thumbli''><img src="/UploadFiles/demo/01.jpg" style="" title="01.jpg"/></li><li class=''thumbli''><img src="/UploadFiles/demo/ad5.jpg" style="" title="ad5.jpg"/></li></ul>',N',Recommend,''',0)
INSERT [ZL_Guest_Bar] ([ID],[CateID],[Pid],[ReplyID],[ReplyUserID],[Title],[MsgContent],[MsgType],[Status],[CUser],[CUName],[CDate],[Subtitle],[OrderFlag],[HitCount]) VALUES ( 15,19,0,0,0,N'摘一段优酷视频来自贴吧',N'H4sIAAAAAAAEAD2PsU7DMBCGX8XyHhtVDAglnWDoUgmpA+thX2KrTnyK7ZgwISZG3oKRhaXidYrgMUhC1en0///dr+9KWv9+fP68HI5fz8fD6/fbuxCixPYBNYsjYcWByFkF0fpOPhbBeLXPMGBROwiGMzWNUHHUyRY17FEXg9XoOSOXGtsFgmYqMTHStZQ5Z9GC6n2L2oJQvpWNlw3GpYwcjNhzFnp1vvj3xOjTPi37J4MMyWC1vN/u7lbbm83Tdnc7ykGEXHOWrY6m4perC84M2sbEiq+uJpFbryea2MMM1mMXZ04YZyshZ857qngNLkyixS6dBTjnc1C9pQhK4fxyh8NMuyR1cm5KEbtTlVyXktZ/iL78N14BAAA=',1,99,0,N'匿名用户',N'2015/1/15 16:45:38',N'说点什么吧...<br/><ul class=''thumbul''><li class=''thumbli''><img src=''/App_Themes/Guest/images/Bar/videologo.png'' data-type=''quotevideo'' data-content=''http://player.youku.com/player.php/sid/XNTQ2NDIzNTEy/v.swf''/></li></ul>',0,1)
SET IDENTITY_INSERT [ZL_Guest_Bar] OFF

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

detele from ZL_Guest_Bar

--注意：将删除整个表

drop table ZL_Guest_Bar

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

TRUNCATE table ZL_Guest_Bar