if exists (select * from sysobjects where id = OBJECT_ID('[TAXI_GUESTBOOK]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [TAXI_GUESTBOOK]

CREATE TABLE [TAXI_GUESTBOOK] (
[I_BOOKID] [int]  IDENTITY (1, 1)  NOT NULL,
[V_USERNAME] [varchar]  (50) NULL,
[V_GENDER] [varchar]  (4) NULL,
[V_QQ] [varchar]  (20) NULL,
[V_EMAIL] [varchar]  (100) NULL,
[V_CONTENT] [varchar]  (1000) NULL,
[V_REPLY] [varchar]  (1000) NULL,
[D_POSTTIME] [datetime]  NULL DEFAULT (getdate()),
[I_HASREPLY] [varchar]  (10) NULL DEFAULT (0),
[D_REPLYTIME] [datetime]  NULL,
[V_TELPHONE] [varchar]  (50) NULL,
[I_DEPARTMENT] [int]  NULL)

ALTER TABLE [TAXI_GUESTBOOK] WITH NOCHECK ADD  CONSTRAINT [PK_TAXI_GUESTBOOK] PRIMARY KEY  NONCLUSTERED ( [I_BOOKID] )
SET IDENTITY_INSERT [TAXI_GUESTBOOK] ON