sql

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cart]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cart]
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].[products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[products]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[relay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[relay]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[size]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[size]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[type_1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[type_1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[type_2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[type_2]
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].[cart] (
 [cartid] [int] IDENTITY (1, 1) NOT NULL ,
 [userid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [productid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [count] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [checkout] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[message] (
 [Messages_ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Messages_Name] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [Messages_Content] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [Messages_Time] [datetime] NULL ,
 [IsDelete] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[orders] (
 [orderid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [productid] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [userid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [acceptname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [address] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [postalcode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [delivery] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [payment] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [ordertime] [datetime] NULL ,
 [orderprice] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[products] (
 [productid] [int] IDENTITY (1, 1) NOT NULL ,
 [productname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [typeid_1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [typeid_2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [recommended] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [specials] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [price] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [userprice] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [specialsprice] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [pointcount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [imagepath] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [count] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [sellcount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [description] [varchar] (800) COLLATE Chinese_PRC_CI_AS NULL ,
 [curency] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [sizeid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [store] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[relay] (
 [Relay_ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Relay_Content] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [Relay_Time] [datetime] NULL ,
 [Messages_ID] [int] NULL ,
 [MUser_ID] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[size] (
 [sizeid] [int] IDENTITY (1, 1) NOT NULL ,
 [sizename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [sizevalue] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[type_1] (
 [typeid_1] [int] IDENTITY (1, 1) NOT NULL ,
 [typename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[type_2] (
 [typeid_2] [int] IDENTITY (1, 1) NOT NULL ,
 [typeid_1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [typename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[userinfo] (
 [userid] [int] IDENTITY (1, 1) NOT NULL ,
 [username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [power] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [question] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [answer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO