ZL_Pub_TW
GO
CREATE TABLE [dbo].[ZL_Pub_TW] (
[ID] [int] IDENTITY (1, 1) NOT NULL,
[Pubupid] [int] NULL,
[PubUserName] [nvarchar] (255) NULL,
[PubUserID] [int] NULL,
[PubContentid] [int] NULL,
[PubInputer] [nvarchar] (255) NULL,
[Parentid] [int] NULL DEFAULT (0),
[PubIP] [nvarchar] (255) NULL,
[Pubnum] [int] NULL DEFAULT (0),
[Pubstart] [int] NULL DEFAULT (0),
[PubTitle] [nvarchar] (255) NULL,
[PubContent] [ntext] NULL,
[PubAddTime] [datetime] NULL DEFAULT (getdate()),
[Optimal] [int] NULL DEFAULT (0),
[ClassLevel1] [nvarchar] (255) NULL DEFAULT (''),
[ClassLevel2] [nvarchar] (255) NULL DEFAULT (''))
ALTER TABLE [ZL_Pub_TW] WITH NOCHECK ADD CONSTRAINT [PK_ZL_Pub_TW] PRIMARY KEY NONCLUSTERED ( [ID] )
SET IDENTITY_INSERT [ZL_Pub_TW]
detele from ZL_Pub_TW
drop table ZL_Pub_TW
TRUNCATE table ZL_Pub_TW