DB_51Aspx/sql2000数据库/MyBookShop.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

CREATE DATABASE MyBookShop
GO

USE MyBookShop
GO

CREATE TABLE [dbo].[Cart] (
	[CartId] [int] IDENTITY (1, 1) NOT NULL ,
	[UserId] [int] NULL ,
	[BookId] [int] NULL ,
	[Amount] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Book] (
	[BookId] [int] IDENTITY (1, 1) NOT NULL ,
	[BookName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CategoryID] [int] NULL ,
	[Price] [float] NULL ,
	[Publisher] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[PublishDate] [datetime] NULL ,
	[Author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageNum] [int] NULL ,
	[PictureUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[SaleCount] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Category] (
	[CategoryID] [int] IDENTITY (1, 1) NOT NULL ,
	[CategoryName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[User] (
	[UserId] [int] IDENTITY (1, 1) NOT NULL ,
	[LoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zip] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO
--DownLoad From 51aspx.com
Insert Into Category(CategoryName) Values ('中外文学')
Insert Into Category(CategoryName) Values ('政治经济')
Insert Into Category(CategoryName) Values ('学术名著')
Insert Into Category(CategoryName) Values ('IT技术')
GO