if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StoreOrderProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[StoreOrderProduct]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_AdminUserInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_AdminUserInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_BulletionCon]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_BulletionCon]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_GoodsCon]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_GoodsCon]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_GoodsType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_GoodsType]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_SpecialGoods]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_SpecialGoods]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_UserInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_UserInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_UserOrderCon]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_UserOrderCon]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_UserOrderDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_UserOrderDetail]
GO
CREATE TABLE [dbo].[t_AdminUserInfo] (
[Asr_Id] [int] IDENTITY (1, 1) NOT NULL ,
[Asr_name] [varchar] (50) NULL ,
[Asr_pwd] [varchar] (20) NULL ,
[Asr_realname] [varchar] (50) NULL ,
[Asr_email] [varchar] (100) NULL ,
[Asr_inputdate] [datetime] NULL ,
[Asr_updatedate] [datetime] NULL ,
[Asr_isvalid] [varchar] (2) NULL ,
[Asr_level] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_BulletionCon] (
[B_Id] [int] IDENTITY (1, 1) NOT NULL ,
[B_title] [varchar] (100) NULL ,
[B_Con] [varchar] (4000) NULL ,
[B_inputdate] [datetime] NULL ,
[B_updateDate] [datetime] NULL ,
[Asr_Id] [int] NULL ,
[B_point] [int] NULL ,
[B_sort] [int] NULL ,
[B_valid] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_GoodsCon] (
[Ste_Id] [int] IDENTITY (1, 1) NOT NULL ,
[Ste_name] [varchar] (100) NOT NULL ,
[St_typeid] [int] NULL ,
[Ste_time] [datetime] NULL ,
[Ste_imgurl] [varchar] (200) NULL ,
[Ste_content] [varchar] (4000) NULL ,
[Ste_desc] [varchar] (1000) NULL ,
[Ste_sort] [int] NULL ,
[Ste_value] [varchar] (50) NULL ,
[Ste_point] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_GoodsType] (
[St_typeid] [int] IDENTITY (1, 1) NOT NULL ,
[St_name] [varchar] (100) NULL ,
[St_fid] [varchar] (50) NULL ,
[St_havechild] [varchar] (2) NULL ,
[St_sort] [int] NULL ,
[St_inputdate] [datetime] NULL ,
[St_isValid] [varchar] (2) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_SpecialGoods] (
[SG_Id] [int] IDENTITY (1, 1) NOT NULL ,
[Ste_Id] [int] NULL ,
[SG_inputdate] [datetime] NULL ,
[SG_updateDate] [datetime] NULL ,
[SG_nowValue] [varchar] (30) NULL ,
[SG_valid] [int] NULL ,
[Asr_Id] [int] NULL ,
[SG_point] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_UserInfo] (
[Usr_Id] [int] IDENTITY (1, 1) NOT NULL ,
[Usr_name] [varchar] (50) NULL ,
[Usr_pwd] [varchar] (20) NULL ,
[Usr_realname] [varchar] (50) NULL ,
[Usr_sex] [varchar] (2) NULL ,
[Usr_tel] [varchar] (20) NULL ,
[Usr_email] [varchar] (100) NULL ,
[Usr_address] [varchar] (200) NULL ,
[Usr_zip] [varchar] (10) NULL ,
[Usr_inputdate] [datetime] NULL ,
[Usr_updatedate] [datetime] NULL ,
[Usr_level] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_UserOrderCon] (
[Odr_no] [varchar] (30) NOT NULL ,
[Odr_time] [datetime] NULL ,
[Odr_ispass] [varchar] (2) NULL ,
[Odr_passtime] [datetime] NULL ,
[Asr_Id] [int] NULL ,
[Odr�