GO
CREATE TABLE [dbo].[ZL_Guestbook](
[Gid] [int] IDENTITY(1,1) NOT NULL,
[Parentid] [int] NOT NULL,
[Cateid] [int] NOT NULL,
[Userid] [int] NOT NULL,
[Title] [nvarchar](200) NULL,
[Tcontent] [ntext] NOT NULL,
[Gdate] [datetime] NULL,
[Status] [int] NOT NULL,
[IP] [nvarchar](50) NULL,
CONSTRAINT [PK_ZL_GUESTBOOK] PRIMARY KEY CLUSTERED
(
[Gid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ZL_Guestbook] ADD  CONSTRAINT [DF_ZL_GUESTBOOK_PARENTID]  DEFAULT ((0)) FOR [Parentid]
GO
ALTER TABLE [dbo].[ZL_Guestbook] ADD  CONSTRAINT [DF_ZL_GUESTBOOK_GDATE]  DEFAULT (getdate()) FOR [Gdate]