if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_YX_CMS_A_RELATIONS_YX_CHANN]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[YX_CMS_ArticleTemplate] DROP CONSTRAINT FK_YX_CMS_A_RELATIONS_YX_CHANN
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_YX_ArticlePinlun_YX_CmsArticle]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[YX_ArticlePinlun] DROP CONSTRAINT FK_YX_ArticlePinlun_YX_CmsArticle
;

if exists (select * from sysobjects where id = OBJECT_ID('[YX_ProductClass]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [YX_ProductClass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteProduct]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DeleteUser]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DownClass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DownClass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DownNewsClass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DownNewsClass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetMentList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetMentList]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_ArticleTemplte]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_ArticleTemplte]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_GetObj]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_GetObj]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_GetTemplate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_GetTemplate]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_Select]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_Select]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_ShopProClass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_ShopProClass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_ShowProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_ShowProduct]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_UpdateShopbase_pic]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_UpdateShopbase_pic]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_deleteArticleCMSclass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_deleteArticleCMSclass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_deleteProclass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_deleteProclass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_deleteclass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_deleteclass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Proc_ShopLink]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Proc_ShopLink]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShowCorrelation]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ShowCorrelation]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShowSql]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ShowSql]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShowVote]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ShowVote]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpClass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpClass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpNewsClass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpNewsClass]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpProductDZ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpProductDZ]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateShopbase]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateShopbase]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_CMSAddChannel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[YX_CMSAddChannel]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_PagerList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[YX_PagerList]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pagination]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[pagination]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[updatepaipai]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[updatepaipai]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pro_ShowBuyProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Pro_ShowBuyProduct]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_ViewBuyvote]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[YX_ViewBuyvote]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_ViewShopvote2]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[YX_ViewShopvote2]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_Viewvote]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[YX_Viewvote]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_jppro]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[YX_jppro]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YX_viewshopvote]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[YX_viewshopvote]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[<%NoDown%>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[<%NoDown%>]
;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[YX_Onlinepayment] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_HankName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_HankUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_HankXX] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_HankOk] [int] NULL ,
	[YX_userid] [int] NULL ,
	[YX_AdiUser] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Rui] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NULL ,
	[yx_rui] [money] NULL ,
	[yx_money] [money] NULL ,
	[yx_start] [int] NULL ,
	[yx_time] [datetime] NOT NULL ,
	[yx_orderid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Shop] (
	[YX_SHOPID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_SHOPUserID] [int] NOT NULL ,
	[YX_SHOPuser] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SHOPName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SHOPLogo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SHOPClass] [int] NOT NULL ,
	[YX_SHOPProject] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SHOPContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ADdisplay] [int] NULL ,
	[YX_ADType] [int] NULL ,
	[YX_ADtitle] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ADTel] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_BanerContent] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ADText] [varchar] (5000) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SHOPTemplate] [int] NULL ,
	[YX_SHOPTJ] [int] NULL ,
	[YX_SHOPFlag] [int] NULL ,
	[yx_shopProductHit] [int] NULL ,
	[YX_CreateShopTime] [datetime] NOT NULL ,
	[YX_ShopPinpai] [int] NULL ,
	[YX_Stat] [int] NULL ,
	[YX_Shopdjstart] [int] NULL ,
	[YX_Shopdj] [int] NULL ,
	[yx_shopms] [int] NULL ,
	[yx_daytime] [int] NULL ,
	[yx_endtime] [datetime] NULL ,
	[yx_GuaStart] [int] NULL ,
	[yx_GuaTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [YX_Store] (
[YX_id] [int]  IDENTITY (1, 1)  NOT NULL,
[YX_Name] [varchar]  (500) NULL,
[YX_Money] [money]  NULL,
[YX_Ordinal] [int]  NULL,
[YX_Num] [int]  NULL DEFAULT (0))
;

CREATE TABLE [dbo].[YX_WebInfo] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_WebName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Key] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Ex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fac] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Moble] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Post] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Copy] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Send] [int] NULL ,
	[YX_Email_Server] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Email_User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Email_Pwd] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ArticleNum] [int] NULL ,
	[YX_Notice0] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice1] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice2] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice3] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice4] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice5] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Notice6] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_WebReg] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UpdateTime] [datetime] NULL ,
	[YX_WebUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_JF] [int] NULL ,
	[YX_ProSH] [int] NULL ,
	[YX_Open] [int] NULL ,
	[YX_Open_Exc] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ShopTime] [int] NULL ,
	[YX_regmail] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_sellmail] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_buymail] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_suessmail] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_top] [int] NULL ,
	[YX_foot] [int] NULL ,
	[YX_BBSOpen] [int] NULL ,
	[YX_ShopOpen] [int] NULL ,
	[YX_ComsOpen] [int] NULL ,
	[YX_GuaOpen] [int] NULL ,
	[YX_RuiOpen] [int] NULL ,
	[YX_Rui] [money] NULL ,
	[YX_Ratio] [float] NULL ,
	[yx_edition] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_jackclose] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_close] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Worth] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_orderid] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_userid] [int] NULL ,
	[yx_money] [money] NULL ,
	[yx_time] AS (getdate()) ,
	[yx_start] [int] NOT NULL ,
	[yx_orderidstart] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ts] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_userid] [int] NOT NULL ,
	[YX_proid] [int] NOT NULL ,
	[YX_tsuserid] [int] NOT NULL ,
	[YX_tscontent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_tszt] [int] NOT NULL ,
	[YX_tstype] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_tsjg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_tsdate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_tstype] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_start] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[yx_buyproduct] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Class] [int] NULL ,
	[YX_Userid] [int] NULL ,
	[YX_ProductName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_prosxid] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_proskin] [int] NULL ,
	[YX_KeysWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Spic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProCon] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_KcNum] [int] NULL ,
	[YX_ProPrice] [float] NULL ,
	[YX_Veri] [int] NULL ,
	[YX_ViewNum] [int] NULL ,
	[YX_AddTime] [datetime] NULL ,
	[YX_PinPai] [int] NULL ,
	[YX_proyxq] [int] NULL ,
	[YX_sf] [int] NULL ,
	[YX_cs] [int] NULL ,
	[YX_yb] [int] NULL ,
	[YX_sj] [int] NULL ,
	[YX_zt] [int] NULL ,
	[yx_sstart] [int] NULL ,
	[yx_openstart] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;


CREATE TABLE [dbo].[<%NoDown%>] (
	[NoDown] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Ad] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_AdType] [int] NULL ,
	[YX_AdName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdExp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdWidth] [int] NULL ,
	[YX_AdHeight] [int] NULL ,
	[YX_AdAddr] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdBz] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Addtime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ArticlePinlun] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ArticleID] [int] NOT NULL ,
	[ChannelID] [int] NOT NULL ,
	[Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Addtime] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Article_CMSClass] (
	[YX_ID] [int] NOT NULL ,
	[YX_ClassName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ParentID] [int] NULL ,
	[YX_ParentPath] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_DePath] [int] NULL ,
	[YX_RootID] [int] NULL ,
	[YX_Child] [int] NULL ,
	[YX_PrevID] [int] NULL ,
	[YX_NextID] [int] NULL ,
	[YX_OrderID] [int] NULL ,
	[YX_KeysWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ClassTxt] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ChannelClass] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_CMS] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_TemplateType] [int] NULL ,
	[YX_CMS_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CMS_Code] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CMS_SM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CMS_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelType] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_CMSCSS] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_TemplateType] [int] NULL ,
	[YX_CssName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CssContent] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_CMSModel] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_TemplateType] [int] NULL ,
	[YX_CMSModelName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CMSType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CMSSM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CMSContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_CMS_ArticleTemplate] (
	[YX_tID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_TemplateID] [int] NOT NULL ,
	[YX_ID] [int] NULL ,
	[YX_ChannelID] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Page_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_PageExc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_PageCod] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Channel] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_ChannelName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ChannelStyle_Color] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ChannelExc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ChannelType] [int] NULL ,
	[YX_Template] [int] NULL ,
	[YX_ChannelMode] [int] NULL ,
	[YX_ChannelDir] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ChannelStat] [int] NULL ,
	[YX_ChannelUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Path] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_CmsArticle] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_NewsClass] [int] NULL ,
	[YX_NewsTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Stat1] [int] NULL ,
	[YX_Stat2] [int] NULL ,
	[YX_Stat3] [int] NULL ,
	[YX_ShowPic] [int] NULL ,
	[YX_PicUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_NewsSH] [int] NULL ,
	[YX_ViewNum] [int] NULL ,
	[YX_Addtime] [datetime] NULL ,
	[YX_ChannelID] [int] NULL ,
	[default_html] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Collection] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_CollUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CollName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CollID] [int] NULL ,
	[YX_CollTime] [smalldatetime] NULL ,
	[YX_Typeclass] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Commentary] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_ProductID] [int] NULL ,
	[YX_Commentary] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AddTime] [datetime] NULL ,
	[YX_IP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_equally] [int] NULL ,
	[YX_AdminHF] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_CEmail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Factory] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Fac_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fac_Addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fac_Url] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fac_Parson] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fac_Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fac_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Txt] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Tj] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Inves] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_InvesName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_OkNum] [int] NULL ,
	[YX_Selected] [int] NULL ,
	[YX_start] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_LY] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_LyUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyEmail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyQQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyTel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyAddr] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyTime] [datetime] NULL ,
	[YX_LyHF] [int] NULL ,
	[YX_HFContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LyXS] [int] NULL ,
	[YX_HFTime] [datetime] NULL ,
	[YX_HFProson] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LYType] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_LeaveMS] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_senduser] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_reluser] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_start] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Link] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_WebName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Type] [int] NULL ,
	[YX_Url] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Logo] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Ver] [int] NULL ,
	[YX_Userid] [int] NULL ,
	[YX_SetUsername] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_linkUserID] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_LoginInfo] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_AdminUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Pwd] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LoginIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LoginTime] [datetime] NULL ,
	[YX_LoginSuccess] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_MSN] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_MSNID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Exc] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_MYT] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_MYTID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_MYTName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_MYTExe] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

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

CREATE TABLE [dbo].[YX_Manage] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_AdminUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Pwd] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Diction] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Num] [int] NULL ,
	[YX_LoginTime] [datetime] NULL ,
	[YX_Stat] [int] NULL ,
	[YX_LYstat] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Mark] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NULL ,
	[yx_classid] [int] NULL ,
	[yx_name] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Matches] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_DowryType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Qdprice] [float] NULL ,
	[YX_QdWeight] [int] NULL ,
	[YX_XFDW] [float] NULL ,
	[YX_Content] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ModCms] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_TemplateType] [int] NULL ,
	[YX_ModCMSName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ModCMSSM] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ModCMSCode] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelType] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_OkJP] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_JPPic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_JF] [float] NULL ,
	[YX_JPName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LpStat] [int] NULL ,
	[YX_LPNum] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_OrderForm] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_OrderFormID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Proid] [int] NULL ,
	[YX_ProName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_userid] [int] NULL ,
	[YX_reuserid] [int] NULL ,
	[YX_Sumcount] [int] NULL ,
	[YX_SumPrice] [float] NULL ,
	[YX_SumWB] [float] NULL ,
	[YX_OrderStart] [int] NULL ,
	[YX_OrderDate] [datetime] NULL ,
	[YX_hydz] [int] NULL ,
	[YX_RGoodsUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_userpromoble] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsAddr] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsFY] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_DGoodsType] [int] NOT NULL ,
	[YX_DGoodsPrice] [float] NULL ,
	[YX_PaymentType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_PaymentPrice] [float] NULL ,
	[YX_SendType] [int] NULL ,
	[YX_SendTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SendContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Ok] [int] NULL ,
	[yx_orderdis] [int] NULL ,
	[yx_ispj] [int] NULL ,
	[yx_ispj2] [int] NULL ,
	[yx_zfborderid] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_tuhou] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_PageType] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Page_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Page_TypeValue] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_PinPai] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_PinPaiName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ClassID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_pinpaipic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_panpaitj] [int] NULL ,
	[YX_panpaicontent] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ProPara] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_ProHypoth] [int] NULL ,
	[YX_ProName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProSell] [int] NULL ,
	[YX_Proportion] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProVer] [int] NULL ,
	[YX_ProShow] [int] NULL ,
	[YX_Bthwb] [int] NULL ,
	[YX_BthwbNum] [real] NULL ,
	[YX_Regwb] [int] NULL ,
	[YX_RegwbNum] [real] NULL ,
	[YX_NewsPicNum] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Product] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Class] [int] NULL ,
	[YX_Userid] [int] NULL ,
	[YX_ProductName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_prosxid] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_proskin] [int] NULL ,
	[YX_BMa] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_KeysWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Product_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Sm] [int] NULL ,
	[YX_TPrice] [int] NULL ,
	[YX_Tj] [int] NULL ,
	[YX_Display] [int] NULL ,
	[YX_Spic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Bpic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProCon] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProXXCon] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProFactre] [int] NULL ,
	[YX_ProWeight] [float] NULL ,
	[YX_ProDw] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_YnBs] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_YnNum] [int] NULL ,
	[YX_StarNum] [int] NULL ,
	[YX_KcNum] [int] NULL ,
	[YX_ProPrice] [float] NULL ,
	[YX_ProDZ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Veri] [int] NULL ,
	[YX_XSNum] [int] NULL ,
	[YX_ViewNum] [int] NULL ,
	[YX_AddTime] [datetime] NULL ,
	[YX_JFNum] [float] NULL ,
	[YX_ProCD] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProYear] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProGG] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProJD] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProShop] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ZT1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ZT2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ZT3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ZT4] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_PinPai] [int] NULL ,
	[YX_proyxq] [int] NULL ,
	[YX_sf] [int] NULL ,
	[YX_cs] [int] NULL ,
	[YX_hp] [int] NULL ,
	[YX_yb] [int] NULL ,
	[YX_bx] [int] NULL ,
	[YX_shopclassid] [int] NULL ,
	[YX_sj] [int] NULL ,
	[YX_jyfs] [int] NULL ,
	[YX_yhdyf] [int] NULL ,
	[YX_py] [float] NULL ,
	[YX_kd] [float] NULL ,
	[YX_gmcount] [int] NULL ,
	[YX_progmfs] [int] NULL ,
	[YX_projjfd] [float] NULL ,
	[YX_paimaijssj] [datetime] NULL ,
	[YX_sptj] [int] NULL ,
	[YX_zt] [int] NULL ,
	[YX_xjsj] [datetime] NULL ,
	[yx_wgyy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_xjzt] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_comity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_num] [int] NULL ,
	[yx_sstart] [int] NULL ,
	[yx_openstart] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [YX_ProductClass] (
[YX_ID] [int]  NULL,
[YX_ClassName] [nvarchar]  (100) NULL,
[YX_ParentID] [int]  NULL,
[YX_ParentPath] [nvarchar]  (100) NULL,
[YX_DePath] [int]  NULL,
[YX_RootID] [int]  NULL,
[YX_Child] [int]  NULL,
[YX_PrevID] [int]  NULL,
[YX_NextID] [int]  NULL,
[YX_OrderID] [int]  NULL,
[YX_KeysWord] [nvarchar]  (100) NULL,
[YX_ClassTxt] [ntext]  NULL,
[YX_Factory] [nvarchar]  (100) NULL,
[YX_Channel] [int]  NULL DEFAULT (0),
[yx_paientcsid] [int]  NULL,
[yx_money] [money]  NULL DEFAULT (0))
;

CREATE TABLE [dbo].[YX_Promanger] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_userid] [int] NOT 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 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Remittance] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_HKFution] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_HKContent] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ZHao] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_SHOPClass] (
	[YX_SHOPClassid] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_SHOPName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_shoporder] [int] NULL ,
	[YX_userid] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[yx_bankcard] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NULL ,
	[yx_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_bankname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_cardno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ShopTemplate] (
	[YX_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_ShopTemplateName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ShopTemplateExc] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ShopTempPic] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Cssname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_default] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Shoping] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_OrderID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProBianMa] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_OrderProNum] [int] NULL ,
	[YX_Price] [float] NULL ,
	[YX_ShopPrice] [float] NULL ,
	[YX_WB] [int] NULL ,
	[YX_Proweight] [float] NULL ,
	[YX_OrderAddtime] [datetime] NULL ,
	[YX_SFWB] [int] NULL ,
	[YX_WBPrice] [float] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Template] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_Template_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YX_Template_Dir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Template_Desc] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Template_SelectedFlag] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_UserInfo] (
	[YX_UserID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserRank] [int] NULL ,
	[YX_UserTname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserPassWd] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserPwdQuestion] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserAnswer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserEmail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserTel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Mobel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YX_UserAddr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserSex] [int] NULL ,
	[YX_UserBrithday] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserMSN] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserQQ] [bigint] NULL ,
	[YX_UserExpense] [float] NULL ,
	[YX_Usersum] [int] NULL ,
	[YX_ReTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserHttp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProductPerson] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProductEmail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProductTel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProductCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_ProductAddr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LoginNum] [int] NULL ,
	[YX_LoginTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_LoginIP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SHE] [int] NULL ,
	[YX_DJ] [int] NULL ,
	[YX_JF] [float] NULL ,
	[YX_sf] [int] NULL ,
	[YX_Stat] [int] NULL ,
	[YX_cs] [int] NULL ,
	[YX_Authentication] [int] NULL ,
	[YX_ShopTime] [datetime] NULL ,
	[YX_ShopOkDay] [int] NULL ,
	[YX_SFZpic] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Regtime] [datetime] NULL ,
	[YX_User_icd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[photo] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_credit] [int] NULL ,
	[YX_bcredit] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_UserParameter] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_UserReg] [int] NULL ,
	[YX_UserVer] [int] NULL ,
	[YX_SenderEmail] [int] NULL ,
	[YX_EmailConfir] [int] NULL ,
	[YX_StrFilters] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_TJUser] [int] NULL ,
	[YX_RetPwd] [int] NULL ,
	[YX_ShopTime] [int] NULL ,
	[YX_Userfw] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_UserZFB] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_UserRank] (
	[YX_ID] [int] NOT NULL ,
	[YX_Rankname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RankPic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Zk] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_SJMoney] [float] NULL ,
	[YX_SFSJ] [int] NULL ,
	[YX_MaxMoney] [float] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Vote] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_VoidType] [int] NULL ,
	[YX_SellUser] [int] NOT NULL ,
	[YX_ProID] [int] NOT NULL ,
	[YX_VoidhfTime] [datetime] NULL ,
	[YX_hfContent] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_maiuser] [int] NULL ,
	[YX_VoteContent] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_VoteTiem] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_WebHelp] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_TypeID] [int] NULL ,
	[YX_Disply] [int] NULL ,
	[YX_TitleHelp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_TitleContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AddTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Write_Prson] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_area] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_parentid] [int] NULL ,
	[YX_areaname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_commend] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_userid] [int] NOT NULL ,
	[yx_productid] [int] NOT NULL ,
	[yx_classid] [int] NOT NULL ,
	[yx_days] [int] NOT NULL ,
	[yx_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_price] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_special] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_addtime] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_credit] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_map] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_grade] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_point] [int] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_paipai] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_orderformid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_proid] [int] NULL ,
	[YX_proname] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_userid] [int] NULL ,
	[YX_reuserid] [int] NULL ,
	[YX_reusercj] [float] NULL ,
	[yx_sumcount] [int] NULL ,
	[yx_orderstart] [int] NULL ,
	[YX_adddate] [datetime] NULL ,
	[YX_RGoodsUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_userpromoble] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsAddr] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_RGoodsCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_DGoodsType] [int] NULL ,
	[YX_DGoodsPrice] [float] NULL ,
	[YX_Enddate] [datetime] NULL ,
	[YX_OK] [int] NULL ,
	[yx_jsdate] [datetime] NULL ,
	[yx_paimaizt] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_proskin] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_skinname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_skincontent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_default] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_prosx] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_classid] [int] NULL ,
	[yx_parentid] [int] NULL ,
	[yx_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_check] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_sell] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_userid] [int] NOT NULL ,
	[YX_proid] [int] NOT NULL ,
	[YX_selluserid] [int] NOT NULL ,
	[YX_sellcontent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_selltype] [int] NULL ,
	[YX_selldate] [datetime] NULL ,
	[YX_pjtype] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_lxfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_fhsj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_xfcd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_ddzt] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_thfw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_yb] (
	[YX_id] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_userid] [int] NOT NULL ,
	[YX_adddate] [datetime] NOT NULL ,
	[YX_ybcount] [int] NULL ,
	[YX_ybxhcount] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[Yx_Messages] (
	[Yx_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Yx_UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_SendID] [int] NULL ,
	[Yx_GetID] [int] NULL ,
	[Yx_Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Time] [datetime] NULL ,
	[Yx_IsRead] [int] NULL ,
	[Yx_Hf] [int] NULL ,
	[Yx_Back] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[Yx_PingLun] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Yx_UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Number] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Time] [datetime] NULL ,
	[Yx_Reply] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_MID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_ProName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[Yx_QQ] (
	[Yx_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Yx_QQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yx_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[yx_labeviwe] (
	[yx_id] [int] NOT NULL ,
	[yx_bigid] [int] NOT NULL ,
	[yx_paretid] [int] NOT NULL ,
	[yx_name] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_value] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_tpye] [int] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[yx_labewrite] (
	[yx_id] [int] NOT NULL ,
	[yx_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yx_type] [int] NOT NULL ,
	[yx_value] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[yx_postform] (
	[yx_id] [int] IDENTITY (1, 1) NOT NULL ,
	[yx_orderid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_fhsj] [datetime] NULL ,
	[yx_dhsj] [datetime] NULL ,
	[yx_ydgs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yx_lxfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[YX_Ad] ADD 
	CONSTRAINT [PK_YX_Ad] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ArticlePinlun] ADD 
	CONSTRAINT [DF__YX_Articl__Addti__489AC854] DEFAULT (getdate()) FOR [Addtime],
	CONSTRAINT [PK_YX_ArticlePinlun] PRIMARY KEY  CLUSTERED 
	(
		[ArticleID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Article_CMSClass] ADD 
	CONSTRAINT [PK_YX_Article_CMSClass] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_CMS] ADD 
	CONSTRAINT [DF__YX_CMS__ChannelT__3D2915A8] DEFAULT (0) FOR [ChannelType],
	CONSTRAINT [PK_YX_CMS] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_CMSModel] ADD 
	CONSTRAINT [DF_YX_CMSModel_ChannelID] DEFAULT (0) FOR [ChannelID]
;

ALTER TABLE [dbo].[YX_CMS_ArticleTemplate] ADD 
	CONSTRAINT [PK_YX_CMS_ARTICLETEMPLATE] PRIMARY KEY  CLUSTERED 
	(
		[YX_TemplateID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Channel] ADD 
	CONSTRAINT [PK_YX_CHANNEL] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_CmsArticle] ADD 
	CONSTRAINT [PK_YX_CmsArticle] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Collection] ADD 
	CONSTRAINT [DF_YX_Collection_YX_CollTime] DEFAULT (getdate()) FOR [YX_CollTime],
	CONSTRAINT [DF_YX_Collection_YX_Typeclass] DEFAULT (0) FOR [YX_Typeclass],
	CONSTRAINT [PK_YX_Collection] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Inves] ADD 
	CONSTRAINT [DF_YX_Inves_YX_start] DEFAULT (0) FOR [YX_start],
	CONSTRAINT [PK_YX_Inves] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_LY] ADD 
	CONSTRAINT [DF_YX_LY_YX_LyTime] DEFAULT (getdate()) FOR [YX_LyTime],
	CONSTRAINT [DF_YX_LY_YX_LyHF] DEFAULT (0) FOR [YX_LyHF],
	CONSTRAINT [DF_YX_LY_YX_LyXS] DEFAULT (1) FOR [YX_LyXS],
	CONSTRAINT [DF_YX_LY_YX_HFTime] DEFAULT (getdate()) FOR [YX_HFTime],
	CONSTRAINT [DF_YX_LY_YX_LYType] DEFAULT (0) FOR [YX_LYType]
;

ALTER TABLE [dbo].[YX_LeaveMS] ADD 
	CONSTRAINT [DF_YX_LeaveMS_yx_start] DEFAULT (0) FOR [yx_start],
	CONSTRAINT [PK_YX_LeaveMS] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Link] ADD 
	CONSTRAINT [DF_YX_Link_YX_Userid] DEFAULT (0) FOR [YX_Userid],
	CONSTRAINT [PK_YX_Link] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Mailsubscribe] ADD 
	CONSTRAINT [PK_YX_Mailsubscribe] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Manage] ADD 
	CONSTRAINT [DF_YX_Manage_YX_Num] DEFAULT (0) FOR [YX_Num],
	CONSTRAINT [DF_YX_Manage_YX_Stat] DEFAULT (0) FOR [YX_Stat],
	CONSTRAINT [DF_YX_Manage_YX_LYstat] DEFAULT (0) FOR [YX_LYstat]
;

ALTER TABLE [dbo].[YX_ModCms] ADD 
	CONSTRAINT [DF__YX_ModCms__Chann__3C34F16F] DEFAULT (0) FOR [ChannelType]
;

ALTER TABLE [dbo].[YX_OrderForm] ADD 
	CONSTRAINT [DF_YX_OrderForm_YX_SumPrice] DEFAULT (0.00) FOR [YX_SumPrice],
	CONSTRAINT [DF_YX_OrderForm_YX_SumWB] DEFAULT (0) FOR [YX_SumWB],
	CONSTRAINT [DF_YX_OrderForm_YX_OrderStart] DEFAULT (0) FOR [YX_OrderStart],
	CONSTRAINT [DF_YX_OrderForm_YX_SendType] DEFAULT (0) FOR [YX_SendType],
	CONSTRAINT [DF_YX_OrderForm_YX_Ok] DEFAULT (1) FOR [YX_Ok],
	CONSTRAINT [DF__YX_OrderF__yx_or__4E3E9311] DEFAULT (0) FOR [yx_orderdis],
	CONSTRAINT [DF_YX_OrderForm_yx_ispj] DEFAULT (0) FOR [yx_ispj],
	CONSTRAINT [DF_YX_OrderForm_yx_ispj2] DEFAULT (0) FOR [yx_ispj2]
;

ALTER TABLE [dbo].[YX_PinPai] ADD 
	CONSTRAINT [DF_YX_PinPai_YX_panpaitj] DEFAULT (0) FOR [YX_panpaitj]
;

ALTER TABLE [dbo].[YX_Product] ADD 
	CONSTRAINT [DF_YX_Product_YX_Userid] DEFAULT (0) FOR [YX_Userid],
	CONSTRAINT [DF_YX_Product_YX_Display] DEFAULT (0) FOR [YX_Display],
	CONSTRAINT [DF_YX_Product_YX_XSNum] DEFAULT (0) FOR [YX_XSNum],
	CONSTRAINT [DF_YX_Product_YX_ViewNum] DEFAULT (0) FOR [YX_ViewNum],
	CONSTRAINT [DF_YX_Product_YX_AddTime] DEFAULT (getdate()) FOR [YX_AddTime],
	CONSTRAINT [DF_YX_Product_YX_PinPai] DEFAULT (0) FOR [YX_PinPai],
	CONSTRAINT [DF_YX_Product_YX_hp] DEFAULT (0) FOR [YX_hp],
	CONSTRAINT [DF_YX_Product_YX_yb] DEFAULT (0) FOR [YX_yb],
	CONSTRAINT [DF_YX_Product_YX_bx] DEFAULT (0) FOR [YX_bx],
	CONSTRAINT [DF_YX_Product_YX_shopclassid] DEFAULT (0) FOR [YX_shopclassid],
	CONSTRAINT [DF_YX_Product_YX_sj] DEFAULT (1) FOR [YX_sj],
	CONSTRAINT [DF_YX_Product_YX_jyfs] DEFAULT (0) FOR [YX_jyfs],
	CONSTRAINT [DF_YX_Product_YX_yhdyf] DEFAULT (1) FOR [YX_yhdyf],
	CONSTRAINT [DF_YX_Product_YX_py] DEFAULT (0) FOR [YX_py],
	CONSTRAINT [DF_YX_Product_YX_kd] DEFAULT (0) FOR [YX_kd],
	CONSTRAINT [DF_YX_Product_YX_gmcount] DEFAULT (0) FOR [YX_gmcount],
	CONSTRAINT [DF_YX_Product_YX_progmfs] DEFAULT (0) FOR [YX_progmfs],
	CONSTRAINT [DF_YX_Product_YX_projjfd] DEFAULT (0) FOR [YX_projjfd],
	CONSTRAINT [DF_YX_Product_YX_sptj] DEFAULT (0) FOR [YX_sptj],
	CONSTRAINT [DF_YX_Product_yx_comity] DEFAULT ('否') FOR [yx_comity],
	CONSTRAINT [DF_YX_Product_yx_sstart] DEFAULT (0) FOR [yx_sstart],
	CONSTRAINT [DF_YX_Product_yx_openstart] DEFAULT (0) FOR [yx_openstart]
;

ALTER TABLE [dbo].[YX_ProductClass] ADD 
	CONSTRAINT [DF_YX_ProductClass_YX_Channel] DEFAULT (0) FOR [YX_Channel]
;

ALTER TABLE [YX_ProductClass] WITH NOCHECK ADD  CONSTRAINT [PK_YX_ProductClass] PRIMARY KEY  NONCLUSTERED ( [YX_ParentID] )
;

ALTER TABLE [dbo].[YX_Promanger] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_SHOPClass] ADD 
	CONSTRAINT [DF__YX_SHOPCl__YX_sh__5649C92D] DEFAULT (0) FOR [YX_shoporder],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_SHOPClassid]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Shop] ADD 
	CONSTRAINT [DF_YX_Shop_YX_SHOPClass] DEFAULT (0) FOR [YX_SHOPClass],
	CONSTRAINT [DF__YX_Shop__YX_ADdi__51851410] DEFAULT (1) FOR [YX_ADdisplay],
	CONSTRAINT [DF__YX_Shop__YX_ADTy__52793849] DEFAULT (0) FOR [YX_ADType],
	CONSTRAINT [DF_YX_Shop_YX_SHOPTemplate] DEFAULT (0) FOR [YX_SHOPTemplate],
	CONSTRAINT [DF__YX_Shop__YX_SHOP__536D5C82] DEFAULT (0) FOR [YX_SHOPTJ],
	CONSTRAINT [DF_YX_Shop_YX_SHOPFlag] DEFAULT (0) FOR [YX_SHOPFlag],
	CONSTRAINT [DF__yx_shop__YX_Crea__4F32B74A] DEFAULT (getdate()) FOR [YX_CreateShopTime],
	CONSTRAINT [DF_YX_Shop_YX_ShopPinpai] DEFAULT (0) FOR [YX_ShopPinpai],
	CONSTRAINT [DF_YX_Shop_YX_Stat] DEFAULT (0) FOR [YX_Stat]
;

ALTER TABLE [dbo].[YX_ShopTemplate] ADD 
	CONSTRAINT [DF_YX_ShopTemplate_YX_default] DEFAULT (0) FOR [YX_default],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_Id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Shoping] ADD 
	CONSTRAINT [DF_YX_Shoping_YX_WB] DEFAULT (0) FOR [YX_WB],
	CONSTRAINT [DF_YX_Shoping_YX_Proweight] DEFAULT (0.00) FOR [YX_Proweight],
	CONSTRAINT [DF_YX_Shoping_YX_SFWB] DEFAULT (0) FOR [YX_SFWB],
	CONSTRAINT [DF_YX_Shoping_YX_WBPrice] DEFAULT (0) FOR [YX_WBPrice]
;

ALTER TABLE [dbo].[YX_Template] ADD 
	CONSTRAINT [DF_YX_Template_YX_Template_SelectedFlag] DEFAULT (0) FOR [YX_Template_SelectedFlag]
;

ALTER TABLE [dbo].[YX_UserInfo] ADD 
	CONSTRAINT [DF_YX_UserInfo_YX_UserRank] DEFAULT (1) FOR [YX_UserRank],
	CONSTRAINT [DF_YX_UserInfo_YX_UserSex] DEFAULT (1) FOR [YX_UserSex],
	CONSTRAINT [DF_YX_UserInfo_YX_UserExpense] DEFAULT (0.00) FOR [YX_UserExpense],
	CONSTRAINT [DF_YX_UserInfo_YX_Usersum] DEFAULT (0) FOR [YX_Usersum],
	CONSTRAINT [DF_YX_UserInfo_YX_LoginNum] DEFAULT (0) FOR [YX_LoginNum],
	CONSTRAINT [DF_YX_UserInfo_YX_DJ] DEFAULT (1) FOR [YX_DJ],
	CONSTRAINT [DF_YX_UserInfo_YX_JF] DEFAULT (0) FOR [YX_JF],
	CONSTRAINT [DF_YX_UserInfo_YX_sf] DEFAULT (0) FOR [YX_sf],
	CONSTRAINT [DF_YX_UserInfo_YX_Stat] DEFAULT (0) FOR [YX_Stat],
	CONSTRAINT [DF_YX_UserInfo_YX_cs] DEFAULT (0) FOR [YX_cs],
	CONSTRAINT [DF_YX_UserInfo_YX_Authentication] DEFAULT (0) FOR [YX_Authentication],
	CONSTRAINT [DF_YX_UserInfo_YX_ShopTime] DEFAULT (getdate()) FOR [YX_ShopTime],
	CONSTRAINT [DF_YX_UserInfo_YX_ShopOkDay] DEFAULT (0) FOR [YX_ShopOkDay],
	CONSTRAINT [DF_YX_UserInfo_YX_Regtime] DEFAULT (getdate()) FOR [YX_Regtime],
	CONSTRAINT [DF_YX_UserInfo_YX_credit] DEFAULT (0) FOR [YX_credit],
	CONSTRAINT [DF_YX_UserInfo_YX_bcredit] DEFAULT (0) FOR [YX_bcredit]
;

ALTER TABLE [dbo].[YX_UserParameter] ADD 
	CONSTRAINT [DF_YX_UserParameter_YX_ShopTime] DEFAULT (0) FOR [YX_ShopTime]
;

ALTER TABLE [dbo].[YX_Vote] ADD 
	CONSTRAINT [DF__YX_Vote__YX_Void__4BCC3ABA] DEFAULT (0) FOR [YX_VoidType],
	CONSTRAINT [DF__YX_Vote__YX_Void__4CC05EF3] DEFAULT (getdate()) FOR [YX_VoidhfTime],
	CONSTRAINT [DF__YX_Vote__YX_Vote__4DB4832C] DEFAULT (getdate()) FOR [YX_VoteTiem],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_WebInfo] ADD 
	CONSTRAINT [DF_YX_WebInfo_YX_ShopTime] DEFAULT (0) FOR [YX_ShopTime]
;

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] 
;

ALTER TABLE [dbo].[YX_commend] ADD 
	CONSTRAINT [DF_YX_commend_yx_addtime] DEFAULT (getdate()) FOR [yx_addtime]
;

ALTER TABLE [dbo].[YX_paipai] ADD 
	CONSTRAINT [DF__YX_paipai__YX_pr__451F3D2B] DEFAULT (0) FOR [YX_proid],
	CONSTRAINT [DF__YX_paipai__YX_us__46136164] DEFAULT (0) FOR [YX_userid],
	CONSTRAINT [DF__YX_paipai__YX_re__4707859D] DEFAULT (0) FOR [YX_reuserid],
	CONSTRAINT [DF__YX_paipai__YX_re__47FBA9D6] DEFAULT (0) FOR [YX_reusercj],
	CONSTRAINT [DF_YX_paipai_yx_orderstart] DEFAULT (0) FOR [yx_orderstart],
	CONSTRAINT [DF__YX_paipai__YX_ad__48EFCE0F] DEFAULT (getdate()) FOR [YX_adddate],
	CONSTRAINT [DF_YX_paipai_YX_OK] DEFAULT (0) FOR [YX_OK],
	CONSTRAINT [DF_YX_paipai_yx_paimaizt] DEFAULT (0) FOR [yx_paimaizt],
	CONSTRAINT [PK__YX_paipai__442B18F2] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_proskin] ADD 
	CONSTRAINT [DF_YX_proskin_YX_default] DEFAULT (0) FOR [YX_default],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_prosx] ADD 
	CONSTRAINT [DF_YX_prosx_yx_classid] DEFAULT (0) FOR [yx_classid],
	CONSTRAINT [DF_YX_prosx_yx_parentid] DEFAULT (0) FOR [yx_parentid],
	CONSTRAINT [DF_YX_prosx_yx_check] DEFAULT (0) FOR [yx_check],
	CONSTRAINT [PK_YX_prosx] PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_sell] ADD 
	CONSTRAINT [DF__YX_sell__YX_sell__61BB7BD9] DEFAULT (0) FOR [YX_selltype],
	CONSTRAINT [DF__YX_sell__YX_sell__62AFA012] DEFAULT (getdate()) FOR [YX_selldate],
	CONSTRAINT [DF__YX_sell__YX_pjty__63A3C44B] DEFAULT (1) FOR [YX_pjtype],
	CONSTRAINT [PK__YX_sell__60C757A0] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ts] ADD 
	CONSTRAINT [DF__YX_ts__YX_tszt__668030F6] DEFAULT (0) FOR [YX_tszt],
	CONSTRAINT [DF__YX_ts__YX_tstype__6774552F] DEFAULT (0) FOR [YX_tstype],
	CONSTRAINT [DF__YX_ts__YX_tsdate__68687968] DEFAULT (getdate()) FOR [YX_tsdate],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_yb] ADD 
	CONSTRAINT [DF__YX_yb__YX_adddat__5CF6C6BC] DEFAULT (getdate()) FOR [YX_adddate],
	CONSTRAINT [DF__YX_yb__YX_ybcoun__5DEAEAF5] DEFAULT (0) FOR [YX_ybcount],
	CONSTRAINT [DF__YX_yb__YX_ybxhco__5EDF0F2E] DEFAULT (0) FOR [YX_ybxhcount],
	 PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[Yx_Messages] ADD 
	CONSTRAINT [DF_Yx_Messages_Yx_Time] DEFAULT (getdate()) FOR [Yx_Time],
	CONSTRAINT [DF_Yx_Messages_Yx_IsRead] DEFAULT (0) FOR [Yx_IsRead],
	CONSTRAINT [DF_Yx_Messages_Yx_Hf] DEFAULT (0) FOR [Yx_Hf]
;

ALTER TABLE [dbo].[YX_ArticlePinlun] ADD 
	CONSTRAINT [FK_YX_ArticlePinlun_YX_CmsArticle] FOREIGN KEY 
	(
		[ArticleID]
	) REFERENCES [dbo].[YX_CmsArticle] (
		[YX_ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
;

ALTER TABLE [dbo].[YX_CMS_ArticleTemplate] ADD 
	CONSTRAINT [FK_YX_CMS_A_RELATIONS_YX_CHANN] FOREIGN KEY 
	(
		[YX_ID]
	) REFERENCES [dbo].[YX_Channel] (
		[YX_ID]
	)
;

ALTER TABLE [YX_Store] WITH NOCHECK ADD  CONSTRAINT [PK_YX_Store] PRIMARY KEY  NONCLUSTERED ( [YX_id] )
;

