当前文件路径：myBBS/DB_51aspx/MyBBS.sql

		            
 1CREATE DATABASE MyBBS
 2GO
 3
 4USE MyBBS
 5GO
 6
 7CREATE TABLE [dbo].[Reply] (
 8    [ReplyID] [int] IDENTITY (1, 1) NOT NULL ,
 9    [TopicID] [int] NULL ,
10    [UserLoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
11    [Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
12    [Content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
13    [CreateTime] [datetime] NULL ,
14    [IP] [char] (15) COLLATE Chinese_PRC_CI_AS NULL 
15) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
16GO
17
18CREATE TABLE [dbo].[Topic] (
19    [TopicID] [int] IDENTITY (1, 1) NOT NULL ,
20    [UserLoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
21    [Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
22    [Content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
23    [CreateTime] [datetime] NULL ,
24    [IP] [char] (15) COLLATE Chinese_PRC_CI_AS NULL 
25) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
26GO
27
28CREATE TABLE [dbo].[User] (
29    [UserID] [int] IDENTITY (1, 1) NOT NULL ,
30    [LoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
31    [UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
32    [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
33    [Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
34    [Homepage] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
35    [Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
36) ON [PRIMARY]
37GO
38
39