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 BulletinBoard (
	id  int,
	nid int,
	name nvarchar(255),
	city nvarchar(50),
	career nvarchar(100),
	company nvarchar(255),
	email nvarchar(80),
	subject nvarchar(255),
	message ntext,
	edittime smalldatetime,
	ip nvarchar(50),
	status tinyint NULL 
)
GO