if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Web_Book]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Web_Book]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Web_Cart]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Web_Cart]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Web_Category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Web_Category]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Web_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Web_User]
GO
CREATE TABLE [dbo].[Web_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].[Web_Cart] (
[CartId] [int] IDENTITY (1, 1) NOT NULL ,
[UserId] [int] NULL ,
[BookId] [int] NULL ,
[Amount] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Web_Category] (
[CategoryID] [int] IDENTITY (1, 1) NOT NULL ,
[CategoryName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Web_User] (
[UserID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[UserPwd] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[GroupID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SuperUser] [bit] NULL ,
[Forbid] [bit] NULL ,
[Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[UserType] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Remark] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Web_User] WITH NOCHECK ADD
CONSTRAINT [PK_Web_User] PRIMARY KEY CLUSTERED
(
[UserID]
) ON [PRIMARY]
GO
