if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BulletinBoard]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BulletinBoard]
GO

CREATE TABLE [dbo].[BulletinBoard] (
	[id] [int]  ,
	[nid] [int] NULL ,
	[name] [nvarchar] (255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[city] [nvarchar] (50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[career] [nvarchar] (100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[company] [nvarchar] (255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[email] [nvarchar] (80) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[subject] [nvarchar] (255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[msg] [ntext] COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[edittime] [smalldatetime] NULL ,
	[ip] [nvarchar] (50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
	[status] [tinyint] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO