--ݿļ
--1ƷԱ
/****** :  [dbo].[AddShuxing]    ű: 2007-12-13 14:52:30 ******/
CREATE TABLE [dbo].[AddShuxing] (
	[SXid] [int] IDENTITY (1, 1) NOT NULL ,
	[SXname] [varchar] (50) NULL ,
	[Dname] [varchar] (50) NULL ,
	[Did] [int] NULL ,
	[SXtype] [int] NULL ,
	[SXcount] [text] NULL ,
	[IsDuo] [int] NULL ,
	[NeiRong] [text] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

ALTER TABLE [dbo].[AddShuxing] WITH NOCHECK ADD 
	CONSTRAINT [PK_AddShuxing] PRIMARY KEY  CLUSTERED 
	(
		[SXid]
	)  ON [PRIMARY] 
;
--2Ʒ
/****** :  [dbo].[PiFa]    ű: 2007-12-13 14:54:43 ******/
CREATE TABLE [dbo].[PiFa] (
	[Pid] [int] IDENTITY (1, 1) NOT NULL ,
	[PShuLiang] [int] NULL ,
	[PiFajia] [int] NULL ,
	[Did] [int] NULL ,
	[Shopid] [int] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[PiFa] WITH NOCHECK ADD 
	CONSTRAINT [PK_PiFa] PRIMARY KEY  CLUSTERED 
	(
		[Pid]
	)  ON [PRIMARY] 
;
--3ӱyx_area
/****** :  [dbo].[YX_area]    ű: 2007-12-13 14:58:43 ******/
CREATE TABLE [dbo].[YX_area] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_parentid] [int] NULL ,
	[YX_areaname] [varchar] (50) NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_area] ADD 
	CONSTRAINT [DF__YX_area__YX_pare__04459E07] DEFAULT (0) FOR [YX_parentid],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;
--4ӡyx_biaojiao
CREATE TABLE [dbo].[YX_Biaoji] (
	[YX_BId] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Bname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TX_leiBie] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ShopID] [int] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_Biaoji] ADD 
	CONSTRAINT [PK_YX_Biaoji] PRIMARY KEY  CLUSTERED 
	(
		[YX_BId]
	)  ON [PRIMARY] 
;
--5ӱYX_Borncard
CREATE TABLE [dbo].[YX_Borncard] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NULL ,
	[yx_card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_pwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_meony] [money] NULL ,
	[yx_start] [int] NULL ,
	[yx_time] [datetime] NULL ,
	[yx_st] [int] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_Borncard] ADD 
	CONSTRAINT [DF_YX_Borncard_yx_userid] DEFAULT (0) FOR [yx_userid],
	CONSTRAINT [DF_YX_Borncard_yx_start] DEFAULT (0) FOR [yx_start],
	CONSTRAINT [DF_YX_Borncard_yx_st] DEFAULT (0) FOR [yx_st],
	CONSTRAINT [PK_YX_Borncard] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;
--6ӳ̱YX_ChanShang
CREATE TABLE [dbo].[YX_ChanShang] (
	[YX_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_CSShortName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSChengLiSJ] [datetime] NULL ,
	[YX_CSName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSContext] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSDate] [datetime] NULL ,
	[YX_CSAdress] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSTel] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSFile] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSChuanZhen] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSYouZhen] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSZhuYe] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CSFenLei] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_ChanShang] ADD 
	CONSTRAINT [PK_YX_ChanShang] PRIMARY KEY  CLUSTERED 
	(
		[YX_Id]
	)  ON [PRIMARY] 
;
--7ӳֵ¼YX_ChongZhiJL
CREATE TABLE [dbo].[YX_ChongZhiJL] (
	[JL_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[JL_ShiJian] [datetime] NULL ,
	[JL_UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[JL_JinE] [decimal](18, 0) NULL ,
	[JL_ChongZhiKH] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[JL_zhangtai] [int] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_ChongZhiJL] ADD 
	CONSTRAINT [DF_YX_ChongZhiJL_JL_ShiJian] DEFAULT (getdate()) FOR [JL_ShiJian],
	CONSTRAINT [DF_YX_ChongZhiJL_JL_zhangtai] DEFAULT (0) FOR [JL_zhangtai],
	CONSTRAINT [PK_YX_ChongZhiJL] PRIMARY KEY  CLUSTERED 
	(
		[JL_ID]
	)  ON [PRIMARY] 
;
--8YX_InvesһУ
--YX_Titlevarvchar,50;
ALTER TABLE YX_Inves ADD YX_Title varchar(50) NULL
;

--9ӱYX_Mailsubscribe
CREATE TABLE [dbo].[YX_Mailsubscribe] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_mail] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_Mailsubscribe] ADD 
	CONSTRAINT [PK_YX_Mailsubscribe] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;
--10YX_OrderForm޸ģ
--YX_OrderFormIDֶδӡnvarchar50޸Ϊ"YX_OrderFormID,float,8";
--ֶΡYX_RGoodsMoblenvarchar,50;
--[֧ID]ֶΡyx_zfborderidvarvhar,50;
--[Ƿ׳ɹ]ֶΡyx_orderdis,int,4,ĬֵΪ0
ALTER TABLE YX_OrderForm ALTER column [YX_OrderFormID] float NULL
; 
ALTER TABLE YX_OrderForm ADD YX_RGoodsMoble NVARCHAR(50) NULL
;
ALTER TABLE YX_OrderForm ADD yx_zfborderid VARCHAR(50) NULL
;
ALTER TABLE YX_OrderForm ADD yx_orderdis int  NULL DEFAULT 0
;
--11yx_pinpai޸ģ
--ֶΡyx_BigPinPai,varchar,100;
--ֶΡyx_CSName,varchar,100;
ALTER TABLE yx_pinpai ADD yx_BigPinPai varchar(100)  NULL 
;
ALTER TABLE yx_pinpai ADD yx_CSName varchar(100)  NULL 
;

--12YX_product޸ģ
--ֶΡYX_Spic޸Ϊ"nvarchar,400";
ALTER TABLE YX_product ALTER column [YX_Spic] NVARCHAR(400) 
;
--ֶΡYX_Bpic޸Ϊ"nvarchar,4000";
ALTER TABLE YX_product ALTER column [YX_Bpic] NVARCHAR(4000) 
;
--ֶΡYX_ProWeight޸Ϊ"float,8"
ALTER   TABLE   YX_product   DROP   CONSTRAINT   DF_YX_Product_YX_ProWeight   
;
ALTER TABLE YX_product ALTER column [YX_ProWeight] FLOAT NULL  
;
/*鿴ԼĶ룺
--1EXEC sp_helpconstraint DF_YX_Product_YX_ProWeight
--2EXEC sp_helptext DF_YX_Product_YX_ProWeight    
--3sp_helpCONSTRAINT DF_YX_Product_YX_ProWeight */  
--ֶ"zdname1"޸Ϊ"varchar,4000";
ALTER TABLE YX_product ALTER column [zdname1] NVARCHAR(4000) 
;
--ֶΡzdname2޸Ϊint,4;
ALTER TABLE YX_product ALTER column [zdname2] INT 
;
--ֶΡzdname3޸Ϊfloat,8;
ALTER TABLE YX_product ALTER column [zdname3] FLOAT 
;
--ֶΡzdname4޸Ϊint,4;
ALTER TABLE YX_product ALTER column [zdname4] INT 
;
--ֶΡzdname5޸Ϊint,4;
ALTER TABLE YX_product ALTER column [zdname5] INT 
;
--ֶΡzdname7޸Ϊint,4;
ALTER TABLE YX_product ALTER column [zdname7] INT 
;
--ֶ[ͼĵַ]Yx_SNPic,varchar,8000;
ALTER TABLE YX_product ADD Yx_SNPic varchar(8000)  NULL 
;
--ֶ[Ʒ]YX_BJNum,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD YX_BJNum INT  NULL DEFAULT 0
;
--ֶ[λ]YX_WTDanWei,char,10;
ALTER TABLE YX_product ADD YX_WTDanWei CHAR(10) NULL
;
--ֶ[ ]YX_DiQu,varchar,100;
ALTER TABLE YX_product ADD YX_DiQu VARCHAR(100) NULL
;
--ֶ[ǷǻվƷ]YX_HuiShou,int,4,ĬֵΪ1;
ALTER TABLE YX_product ADD YX_HuiShou INT  NULL DEFAULT 0
;
--ֶ[]YX_ChangShang,varchar,50;
ALTER TABLE YX_product ADD YX_ChangShang VARCHAR(50) NULL
;
--ֶ[]YX_Mai,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD YX_Mai INT  NULL DEFAULT 0
;
--ֶ[]YX_Song,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD YX_Song INT  NULL DEFAULT 0
;
--ֶ[]YX_CXtype,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD YX_CXtype INT  NULL DEFAULT 0
;
--ֶ[Ʒ]YX_BianHao,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD YX_BianHao INT  NULL DEFAULT 0
;
--ֶ[Ƿ]yx_sstart,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD yx_sstart INT  NULL DEFAULT 0
;
--ֶ[Ƿ]yx_ispifa,int,4,ĬֵΪ0;
ALTER TABLE YX_product ADD yx_ispifa INT  NULL DEFAULT 0
;
--13YX_Product_ziduan޸ģ
--ֶ[ֶε]zdtype,int,4,null;
--ֶ[Ƿж],"Iszdduo",bit,1,null;
ALTER TABLE YX_Product_ziduan ADD zdtype INT  NULL 
;
ALTER TABLE YX_Product_ziduan ADD Iszdduo BIT  NULL 
;
--14½YX_Promanger
CREATE TABLE [dbo].[YX_Promanger] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_userid] [int] NOT NULL ,
	[YX_UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_userproname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YX_userproaddress] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YX_userpropost] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YX_userprotel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YX_userpromoble] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_Promanger] ADD 
	CONSTRAINT [PK__YX_Promanger__417994D0] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;
--15½YX_prozs

CREATE TABLE [dbo].[YX_prozs] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_orderformid] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_proid] [int] NULL ,
	[yx_proname] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_proprice] [decimal](18, 0) NULL ,
	[yx_pronum] [int] NULL ,
	[yx_user] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;
--16½[ؼ]YX_SearchKeyWord
CREATE TABLE [dbo].[YX_SearchKeyWord] (
	[K_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[K_Content] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[K_Num] [int] NULL ,
	[K_Order] [int] NULL ,
	[K_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[K_Date] [datetime] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_SearchKeyWord] ADD 
	CONSTRAINT [DF_YX_SearchKeyWord_K_Num] DEFAULT (1) FOR [K_Num],
	CONSTRAINT [DF_YX_SearchKeyWord_K_Type] DEFAULT ('Ȼ') FOR [K_Type],
	CONSTRAINT [DF_YX_SearchKeyWord_K_Date] DEFAULT (getdate()) FOR [K_Date],
	CONSTRAINT [PK_YX_SearchKeyWord] PRIMARY KEY  CLUSTERED 
	(
		[K_ID]
	)  ON [PRIMARY] 
;



ALTER TABLE [dbo].[YX_prozs] ADD 
	CONSTRAINT [PK_YX_prozs] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;
--17½[Ʒλ]YX_Unit
CREATE TABLE [dbo].[YX_Unit] (
	[YX_DWID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_DWName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_DWOrder] [int] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_Unit] ADD 
	CONSTRAINT [PK_YX_Unit] PRIMARY KEY  CLUSTERED 
	(
		[YX_DWID]
	)  ON [PRIMARY] 
;
--18[û]yx_userinfo޸ģ
--ֶ[Աʻ]yx_meonydecimal9Ϊ18ĬֵΪ0
--ֶ[Ƿύ]YX_ShengJiSQ,bit,1ĬֵΪ0
--ֶ[ԱҪĵȼID]YX_ShengQingDJ,int,4ĬֵΪ0
--ֶ[ԱύǷѾ]YX_ShengQingCL,bit,1ĬֵΪ0
--ֶ[Աύʱ]YX_ShengQingSJ,datetime,8
ALTER TABLE yx_userinfo ADD yx_meony DECIMAL  NULL DEFAULT 0
;
ALTER TABLE yx_userinfo ADD YX_ShengJiSQ INT  NULL DEFAULT 0
;
ALTER TABLE yx_userinfo ADD YX_ShengQingDJ INT  NULL DEFAULT 0
;
ALTER TABLE yx_userinfo ADD YX_ShengQingCL INT  NULL DEFAULT 0
;
ALTER TABLE yx_userinfo ADD YX_ShengQingSJ DATETIME  NULL 
;

--19YX_UserRank޸ģ
--YX_IDԶ1
--ALTER TABLE YX_UserRank ALTER column [YX_ID] INT IDENTITY(1,1) 
--;
ALTER TABLE [dbo].[YX_UserRank] ADD 
	CONSTRAINT [PK_YX_UserRank] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;
--19[ϵͳϢ]YX_WebInfo޸ģ
--ֶΣyx_bbsopenint,4,ĬֵΪ0
ALTER TABLE YX_WebInfo ADD yx_bbsopen INT  NULL DEFAULT 0
;



