1CREATE DATABASE MyBookShop
 2GO
 3
 4USE MyBookShop
 5GO
 6
 7CREATE TABLE [dbo].[Cart] (
 8    [CartId] [int] IDENTITY (1, 1) NOT NULL ,
 9    [UserId] [int] NULL ,
10    [BookId] [int] NULL ,
11    [Amount] [int] NULL 
12) ON [PRIMARY]
13GO
14
15CREATE TABLE [dbo].[Book] (
16    [BookId] [int] IDENTITY (1, 1) NOT NULL ,
17    [BookName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
18    [CategoryID] [int] NULL ,
19    [Price] [float] NULL ,
20    [Publisher] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
21    [PublishDate] [datetime] NULL ,
22    [Author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
23    [PageNum] [int] NULL ,
24    [PictureUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
25    [Description] [text] COLLATE Chinese_PRC_CI_AS NULL ,
26    [SaleCount] [int] NULL 
27) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
28GO
29
30CREATE TABLE [dbo].[Category] (
31    [CategoryID] [int] IDENTITY (1, 1) NOT NULL ,
32    [CategoryName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
33) ON [PRIMARY]
34GO
35
36CREATE TABLE [dbo].[User] (
37    [UserId] [int] IDENTITY (1, 1) NOT NULL ,
38    [LoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
39    [UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
40    [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
41    [Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
42    [Zip] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
43) ON [PRIMARY]
44GO
45--DownLoad From 51aspx.com
46Insert Into Category(CategoryName) Values ('中外文学')
47Insert Into Category(CategoryName) Values ('政治经济')
48Insert Into Category(CategoryName) Values ('学术名著')
49Insert Into Category(CategoryName) Values ('IT技术')
50GO