message.sql

查看留言信息．查看资料

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

CREATE TABLE [dbo].[message] (
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[photo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[content] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO