表名：ZL_Publish_Node












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2Pidint40   否 父节点id
3NodeNamenvarchar2000   是 节点名称
4Describenvarchar5000   是 节点信息
5CDatedatetime83   是 创建时间
6CAdminint40   是 创建人
7Authnvarchar5000   是 节点权限

简要说明：

报纸分类表

GO
CREATE TABLE [dbo].[ZL_Publish_Node](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Pid] [int] NOT NULL,
[NodeName] [nvarchar](200) NULL,
[Describe] [nvarchar](500) NULL,
[CDate] [datetime] NULL,
[CAdmin] [int] NULL,
[Auth] [nvarchar](500) NULL,) ON [PRIMARY]

SET IDENTITY_INSERT [ZL_Publish_Node] ON
INSERT [ZL_Publish_Node] ([ID],[Pid],[NodeName],[CDate],[CAdmin]) VALUES ( 1,0,N'国际报刊',N'2017/4/7 11:29:30',0)
INSERT [ZL_Publish_Node] ([ID],[Pid],[NodeName],[CDate],[CAdmin]) VALUES ( 2,0,N'国家报刊',N'2017/4/7 11:29:42',0)
INSERT [ZL_Publish_Node] ([ID],[Pid],[NodeName],[CDate],[CAdmin]) VALUES ( 3,0,N'地方报纸',N'2017/4/7 11:29:48',0)
INSERT [ZL_Publish_Node] ([ID],[Pid],[NodeName],[CDate],[CAdmin]) VALUES ( 4,0,N'娱乐新闻',N'2017/4/7 11:29:54',0)
SET IDENTITY_INSERT [ZL_Publish_Node] OFF

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

detele from ZL_Publish_Node

--注意：将删除整个表

drop table ZL_Publish_Node

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

TRUNCATE table ZL_Publish_Node