当前文件路径：MyChatRoom/DB_51aspx/MyChatRoom.sql

		            
 1CREATE DATABASE MyCharRoom
 2GO
 3USE MyCharRoom
 4GO
 5
 6/**//****** 对象:  Table [dbo].[Message]    脚本日期: 09/20/2006 21:38:01 ******/
 7CREATE TABLE [dbo].[Message](
 8    [UserName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
 9    [CreateTime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
10    [Content] [text] COLLATE Chinese_PRC_CI_AS NULL,
11    [Color] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
12    [Emotion] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
13) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
14GO
15
16/**//****** 对象:  Table [dbo].[User]    脚本日期: 09/20/2006 21:38:48 ******/
17CREATE TABLE [dbo].[User](
18    [UserName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
19    [Password] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL
20) ON [PRIMARY]
21GO
22