CREATE DATABASE MyChatRoom
GO
USE MyChatRoom
GO
CREATE TABLE [dbo].[Message] (
[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CreateTime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[Color] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Emotion] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[User] (
[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO