深圳网上售书系统.rar_commerce_电子商务_管理系统_网上书

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Book_Orders_FK1]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[Orders] DROP CONSTRAINT Book_Orders_FK1 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Class_Book_FK1]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[Book] DROP CONSTRAINT Class_Book_FK1 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[User_Orders_FK1]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[Orders] DROP CONSTRAINT User_Orders_FK1 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Book]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Book] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Class] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Message] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Orders] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UserInfo] GO CREATE TABLE [dbo].[Book] ( [BookID] [int] IDENTITY (1, 1) NOT NULL , [BookName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Price] [decimal](10, 2) NULL , [Publish] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Num] [int] NULL , [Photo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [ClassID] [int] NULL , [Description] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Class] ( [ClassID] [int] IDENTITY (1, 1) NOT NULL , [ClassName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Message] ( [MessageID] [int] IDENTITY (1, 1) NOT NULL , [Sender] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [SenderMail] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Receiver] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [ReceiverMail] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [MsgInfo] [text] COLLATE Chinese_PRC_CI_AS NULL , [MsgDate] [datetime] NULL , [State] [int] NULL DEFAULT(0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Orders] ( [OrdersID] [int] IDENTITY (1, 1) NOT NULL , [UserID] [int] NULL , [BookID] [int] NULL , [BookNum] [int] NULL , [TotalCharge] [decimal](10, 2) NULL , [OrderDate] [datetime] NULL , [ServiceOver] [int] NULL DEFAULT(1) ) ON [PRIMARY] GO CREATE TABLE [dbo].[UserInfo] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [NiceName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [UserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Addr] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [EMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Zip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Role] [int] NULL , [State] [int] NULL DEFAULT(0) ) ON [PRIMARY] GO --------------------------------------------- insert into UserInfo(NiceName,UserName,Password,Tel,Addr,EMail,Zip,Role,State) values ('admin','administrator','123','4567','bit','[email protected]','36000',1,1)