CREATE TABLE [dbo].[ChuzhuYuYue] (
	[CId] [int] IDENTITY (1, 1) NOT NULL ,
	[Cname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cteleph] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ccount] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[Cguanlian] [int] NULL ,
	[Cshijian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[D99_Tmp] (
	[subdirectory] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[depth] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[file] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[Items] (
	[ItemID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[VoteCount] [int] NULL ,
	[SubjectID] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[NewsPingLun] (
	[Pid] [int] IDENTITY (1, 1) NOT NULL ,
	[Pname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NeiRong] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[SiJian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuanLian] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[Pay_GuanLi] (
	[Pay_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[NeiRong] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[PerGradeManage] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[gradename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[isReg] [bit] NULL ,
	[isCheck] [bit] NULL ,
	[isFees] [bit] NULL ,
	[Fees] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[chuzhuItems] [int] NULL ,
	[chushouItems] [int] NULL ,
	[qiuzhuItems] [int] NULL ,
	[qiugouItems] [int] NULL ,
	[Validity] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[Profile] (
	[ProfileID] [int] IDENTITY (1, 1) NOT NULL ,
	[IsRepeatVote] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[Subjects] (
	[SubjectID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mode] [bit] NULL ,
	[TopicID] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[Topics] (
	[TopicID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[IsCurrent] [bit] 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] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdUrl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdExp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdWidth] [int] NULL ,
	[YX_AdHeight] [int] NULL ,
	[YX_AdAddr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_AdBz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Addtime] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Admins] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[admin_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[admin_password] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[admin_roles] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[admin_logins] [int] NULL ,
	[admin_lastlogintime] [datetime] NULL ,
	[admin_lastloginIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[admin_Diction] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_AgencyCompanyRegInfo] (
	[AC_ACID] [int] IDENTITY (1, 1) NOT NULL ,
	[AC_AreaID] [int] NOT NULL ,
	[AC_ShopName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_ShopAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_CompanyDesc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_LinkMan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_Mobile] [varchar] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_Phone] [varchar] (11) COLLATE Chinese_PRC_CI_AS NULL ,
	[AC_Email] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[AC_CheckFlag] [bit] NULL ,
	[AC_Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_ShopCount] [int] NULL ,
	[AC_ZongJi] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[AC_BuiltTime] [datetime] NULL ,
	[AC_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AC_ChuZhuItems] [int] NULL ,
	[AC_ChuShouItems] [int] NULL ,
	[AC_QiuGouItems] [int] NULL ,
	[AC_QiuZhuItems] [int] NULL ,
	[AC_StopSerTime] [datetime] NULL ,
	[AC_IsFees] [bit] NULL ,
	[AC_CheckedTime] [datetime] NULL ,
	[AC_RegTime] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_AgencyCompanyShop] (
	[ACS_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ACS_ShopLogo] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopLocality] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopAdmin] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopPhone] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopFax] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopAddress] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopZipCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopIntegral] [int] NOT NULL ,
	[ACS_Agencyid] [int] NULL ,
	[ACS_SHOPSTYLE] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_SHOPNAME] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ACS_ShopDesc] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopShow] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACS_ShopJob] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[ac_areaId] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_AreaBig] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_AreaBig] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Paixu] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_AreaSmall] (
	[YX_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[YX_AreaBig] [int] NULL ,
	[YX_AreaSmall] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Paixu] [int] NULL ,
	[YX_Key] [int] NULL ,
	[YX_County] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Map] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_BigName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Article_CMSClass] (
	[YX_ID] [int] IDENTITY (1, 1) 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] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building] (
	[BU_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_City] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Abbreviation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Region] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Pwd] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Projectaddress] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Corporatename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Contactperson] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Telephone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Handset] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Regdate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Sellername] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Sellertell] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Selleremail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Sellerpic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Sellstaddress] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Xq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Salescondition] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Propertytype] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Constructionform] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Faces] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Repair] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Propertyexpense] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Housequantity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Openingdate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Entersdate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Startingprice] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Heightprice] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Avgprice] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Unit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Area] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Floorspace] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Paymentmethod] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Hotline] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Projectsynopsis] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Permit] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Volumerate] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Afforestationrate] [varchar] (53) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Berth] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Mainhousehold] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Floorcondition] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Transportation] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Trade] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Education] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Medicalservice] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Bank] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Structure] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Windowsanddoors] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Watersupply] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Heating] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Safe] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Network] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Communication] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Outerwall] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Innerwall] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Powersupply] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Airfeed] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Kitchen] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Bathroom] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Hall] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Fireprevention] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Elevator] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Other] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Developer] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Prowebsite] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_DeveloperTell] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_DeveloperFox] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Landscapedesign] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Businessagent] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Propertycompany] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Buildingannouncement] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_BJOrganization] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Awarditem] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Revisiontime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_Clickquantity] [int] NULL ,
	[BU_Verification] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_isRecommendation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_chuzhuitems] [int] NULL ,
	[BU_chushouitems] [int] NULL ,
	[BU_qiuzhuitems] [int] NULL ,
	[BU_qiugouitems] [int] NULL ,
	[BU_IsFees] [bit] NULL ,
	[BU_CHeckedTime] [datetime] NULL ,
	[BU_StopSerTime] [datetime] NULL ,
	[BU_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BU_IsCheck] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_CityZx] (
	[CityZxID] [int] IDENTITY (1, 1) NOT NULL ,
	[CityZxType] [int] NULL ,
	[CityZxTitle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CityZxCount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CityZxRD] [int] NULL ,
	[CityZxBiaoji] [int] NULL ,
	[CityZxPic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_Commentar] (
	[Com_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_ID] [int] NULL ,
	[BU_Name] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Com_Content] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Com_time] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_Diary] (
	[Diary_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_ID] [int] NULL ,
	[Diary_Title] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Address] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Content] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Progress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Startdate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Enddate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Startstime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Diary_Endtime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_Errorcorrection] (
	[Error_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_ID] [int] NULL ,
	[Error_Cont] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Error_Human] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Error_Tell] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Error_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_Household] (
	[Hou_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_ID] [int] NULL ,
	[Hou_Type] [int] NULL ,
	[Hou_Pic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hou_Shi] [int] NULL ,
	[Hou_Ting] [int] NULL ,
	[Hou_Wei] [int] NULL ,
	[Hou_Chu] [int] NULL ,
	[Hou_ShiSize] [int] NULL ,
	[Hou_TingSize] [int] NULL ,
	[Hou_WeiSize] [int] NULL ,
	[Hou_ChuSize] [int] NULL ,
	[Hou_Picinfo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hou_IsRecommendation] [int] NULL ,
	[Hou_ZongSize] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hou_Isdefault] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_Registration] (
	[Reg_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_ID] [int] NULL ,
	[Reg_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Age] [int] NULL ,
	[Reg_Handset] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Officetele] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Householdtele] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Zip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Adress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reg_Type1] [int] NULL ,
	[Reg_Type2] [int] NULL ,
	[Reg_Type3] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_Building_vote] (
	[Vote_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BU_ID] [int] NULL ,
	[BU_Region] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Vote_Price] [int] NULL ,
	[Vote_Transportation] [int] NULL ,
	[Vote_Sector] [int] NULL ,
	[Vote_Construction] [int] NULL ,
	[Vote_Property] [int] NULL ,
	[Vote_Education] [int] NULL ,
	[Vote_Trade] [int] NULL 
) 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_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 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ChaoXiang] (
	[HF_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[HF_Content] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HF_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ChuShou] (
	[House_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[House_BianHao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_IsCheck] [bit] NULL ,
	[House_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_CityName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ID] [int] NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Addrinfo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area_id] [int] NULL ,
	[House_Addressinfo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Size1] [float] NULL ,
	[House_Size2] [float] NULL ,
	[House_Size3] [float] NULL ,
	[House_HouseType] [varchar] (9) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_InputPrice] [decimal](10, 2) NULL ,
	[House_CountexPress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_RepaiDegree] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_RoomNum] [int] NULL ,
	[House_OfficeNum] [int] NULL ,
	[House_WashNum] [int] NULL ,
	[House_YangTaiNum] [int] NULL ,
	[House_Use] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Floor] [int] NULL ,
	[House_TotalFloor] [int] NULL ,
	[House_Right] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_BuildYear] [int] NULL ,
	[House_Forward] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Feature] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_RoomSetting] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_RoomFixing] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_PouseOwnerMemo] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Structure] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_ExternalWall] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_StopCar] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_CellCount] [int] NULL ,
	[House_ServicePrice] [float] NULL ,
	[House_ServiceexPress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_CloseArea] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Chamber] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_School] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Garden] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Piazza] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Buslineinfo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Street] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_YiLiao] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_CertID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_ConsignID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Special] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_ReleaseDay] [int] NULL ,
	[House_OwnerName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Ownersex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_OwnerPhone1] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_OwnerPhone2] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_OwnerIDCard] [varchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_OwnerEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Condition] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_Hit] [int] NULL ,
	[House_IsCommend] [bit] NULL ,
	[House_PinYin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_ShortPinYin] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_CommentNum] [int] NULL ,
	[House_PublishDate] [datetime] NULL ,
	[House_IsHavePicture] [bit] NULL ,
	[House_LeaveDay] [int] NULL ,
	[House_State] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_YuYueNum] [int] NULL ,
	[House_PublishIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[House_LastModifyTime] [datetime] NULL ,
	[House_ModifyNum] [int] NULL ,
	[House_Items] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ChuZu] (
	[HR_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[U_ID] [int] NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_BianHao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_CityName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area_ID] [int] NULL ,
	[HR_XiaoQuDZ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_DetailAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Household] [int] NULL ,
	[HR_HouseOffice] [int] NULL ,
	[HR_Housewash] [int] NULL ,
	[HR_YangTai] [int] NULL ,
	[HR_HouseSize] [float] NULL ,
	[HR_ZengSongSize] [float] NULL ,
	[HR_UseSize] [float] NULL ,
	[HR_Housefloor] [int] NULL ,
	[HR_HousefloorTotol] [int] NULL ,
	[HR_RepairDegree] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Forward] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_JiChuSS] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_ShiNeiSS] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_HouseShortHireTime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_HouseHirePrice] [float] NULL ,
	[HR_HouseHirePriceUnit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_PayWay] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_InTime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Deposit] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_BossPay] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_WaterPrice] [float] NULL ,
	[HR_PowerPrice] [float] NULL ,
	[HR_NetPrice] [float] NULL ,
	[HR_Property] [float] NULL ,
	[HR_PropertyUnit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Education] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Traffic] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Medical] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Bussiness] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Features] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_HaveKey] [bit] NULL ,
	[HR_PublishPeriod] [int] NULL ,
	[HR_PinYin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_ShortPinYin] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Hit] [int] NULL ,
	[HR_IsCommend] [bit] NULL ,
	[HR_CommentNum] [int] NULL ,
	[HR_PublishDate] [datetime] NULL ,
	[HR_LasrModifyTime] [datetime] NULL ,
	[HR_ModifyNum] [int] NULL ,
	[HR_PublishIP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_IsCheck] [bit] NULL ,
	[HR_HavePicture] [bit] NULL ,
	[HR_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_Use] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HR_YueYueNum] [int] 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 ,
	[YX_URL] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_GeRenYH] (
	[U_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[U_Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[U_CompanyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area_ID] [int] NULL ,
	[U_CongYeZS] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuDD] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuSJ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuBFJG] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuTP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_GeRenRY] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Pwd] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[U_Question] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Answer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_NiCheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_TureName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Sex] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Birthday] [datetime] NULL ,
	[U_RegDate] [datetime] NULL ,
	[U_RegIP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_MobilePhone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Telephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Blog] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_IDCard] [varchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_QQ] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_MSN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Interduce] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_IsCheck] [bit] NULL ,
	[U_LastLoginTime] [datetime] NULL ,
	[U_LoginCount] [int] NULL ,
	[U_ArticalCount] [int] NULL ,
	[U_CommentCount] [int] NULL ,
	[U_IsClose] [bit] NULL ,
	[U_HouseSaleCount] [int] NULL ,
	[U_HouseRequestSaleCount] [int] NULL ,
	[U_HouseRentalCount] [int] NULL ,
	[U_HouseBrothelCount] [int] NULL ,
	[U_ChuShou] [bit] NULL ,
	[U_ChuZu] [int] NULL ,
	[U_QiuGou] [int] NULL ,
	[U_QiuZu] [int] NULL ,
	[U_LastModifyTime] [datetime] NULL ,
	[U_ModifyNum] [int] NULL ,
	[U_LoginNum] [int] NULL ,
	[U_FriendNum] [int] NULL ,
	[U_FriendedNum] [int] NULL ,
	[U_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_CheckedTime] [datetime] NULL ,
	[U_IsFees] [bit] NULL ,
	[U_UseItems] [int] NULL ,
	[U_stopServiceTime] [datetime] NULL ,
	[U_ChuZhuItems] [int] NULL ,
	[U_QiuGouItems] [int] NULL ,
	[U_QiuZhuItems] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_GongGao] (
	[AN_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AN_Publisher] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[AN_Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AN_Content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[AN_ContentLength] [int] NULL ,
	[AN_EndTime] [datetime] NULL ,
	[AN_Grade] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AN_Type] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[AN_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AN_PublishTime] [datetime] NULL ,
	[AN_LastModifyTime] [datetime] NULL ,
	[AN_ModifyNum] [int] NULL ,
	[AN_Hit] [int] NULL ,
	[AN_FuJian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_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 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_JingJiRen] (
	[U_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[U_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[U_CompanyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area_ID] [int] NULL ,
	[U_CongYeZS] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuDD] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuSJ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuBFJG] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ZhengShuTP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_GeRenRY] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Pwd] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[U_Question] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Answer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_NiCheng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_TureName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Sex] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Birthday] [datetime] NULL ,
	[U_RegDate] [datetime] NULL ,
	[U_RegIP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_MobilePhone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Telephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Blog] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_IDCard] [varchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_QQ] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_MSN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Interduce] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_IsCheck] [bit] NULL ,
	[U_LastLoginTime] [datetime] NULL ,
	[U_LoginCount] [int] NULL ,
	[U_ArticalCount] [int] NULL ,
	[U_CommentCount] [int] NULL ,
	[U_IsClose] [bit] NULL ,
	[U_HouseSaleCount] [int] NULL ,
	[U_HouseRequestSaleCount] [int] NULL ,
	[U_HouseRentalCount] [int] NULL ,
	[U_HouseBrothelCount] [int] NULL ,
	[U_ChuShou] [bit] NULL ,
	[U_ChuZu] [int] NULL ,
	[U_QiuGou] [int] NULL ,
	[U_QiuZu] [int] NULL ,
	[U_LastModifyTime] [datetime] NULL ,
	[U_ModifyNum] [int] NULL ,
	[U_LoginNum] [int] NULL ,
	[U_FriendNum] [int] NULL ,
	[U_FriendedNum] [int] NULL ,
	[U_Photo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShopId] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_LeaveWord] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Time] [datetime] NULL ,
	[content] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_LeiBie] (
	[HT_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[HT_Content] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HT_OrderBy] [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_LiuYan] (
	[LY_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[LY_Date] [datetime] NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ID] [int] NULL ,
	[LY_IsRegMember] [bit] NULL ,
	[LY_Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LY_Content] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[LY_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LY_State] [bit] NULL ,
	[LY_Grade] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LY_Hit] [int] NULL ,
	[LY_IsRePeat] [bit] 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_NewsClass] (
	[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_Factory] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_PageType] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_PingLun] (
	[PL_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PL_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_BianHao] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_IsRegMember] [bit] NULL ,
	[PL_JiaoTong] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_WuYe] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_DiDuan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_PeiTao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_ShouJia] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_ZuJin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_Content] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_PublishDate] [datetime] NULL ,
	[PL_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_Lengh] [int] NULL ,
	[PL_HuanJing] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PL_IsCheck] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_QiuGou] (
	[CS_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[U_ID] [int] NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_BianHao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_CityName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_PublishDate] [datetime] NULL ,
	[CS_lastModifyTime] [datetime] NULL ,
	[CS_ModifyNum] [int] NULL ,
	[CS_Sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_MobilePhone] [varchar] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_Tel] [varchar] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_XiaoQuDZ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_SmoallAreaMust] [bit] NULL ,
	[Area_ID] [int] NULL ,
	[CS_AreaMust] [bit] NULL ,
	[CS_Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_SizeMin] [int] NULL ,
	[CS_SizeMax] [int] NULL ,
	[CS_SizeMust] [bit] NULL ,
	[CS_PriceMin] [int] NULL ,
	[CS_PriceMax] [int] NULL ,
	[CS_PriceMust] [bit] NULL ,
	[CS_CustomerGrade] [int] NULL ,
	[CS_RoomNum1] [int] NULL ,
	[CS_RoomOffice1] [int] NULL ,
	[CS_RoomNum2] [int] NULL ,
	[CS_RoomOffice2] [int] NULL ,
	[CS_ROMust] [bit] NULL ,
	[CS_HouseType] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_HouseTypeMust] [bit] NULL ,
	[CS_Use] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_HouseUseMust] [bit] NULL ,
	[CS_FloorMin] [int] NULL ,
	[CS_FloorMax] [int] NULL ,
	[CS_FloorMust] [bit] NULL ,
	[CS_Forward] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_ForwardMust] [bit] NULL ,
	[CS_RepairDegree] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_RepairDegreeMust] [bit] NULL ,
	[CS_Right] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_RightMust] [bit] NULL ,
	[CS_NearSchool] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_NearPark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_NearGround] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_NearBus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_NearStreet] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_NearMust] [bit] NULL ,
	[CS_BuildYear] [int] NULL ,
	[CS_BuildYearMust] [bit] NULL ,
	[CS_Other] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_PublishDay] [int] NULL ,
	[CS_PinYin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_ShortPinYin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_Hit] [int] NULL ,
	[CS_IsCommend] [bit] NULL ,
	[CS_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_YuYueNum] [int] NULL ,
	[CS_PublisIP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_IsCheck] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_QiuZu] (
	[TE_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[U_ID] [int] NULL ,
	[TE_CityName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TE_BianHao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_MobilePhone] [varchar] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Tel] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_SmallArea] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_SmallAreaMust] [bit] NULL ,
	[Area_ID] [int] NULL ,
	[Area_IDMust] [bit] NULL ,
	[TE_HouseType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_IDMust] [bit] NULL ,
	[TE_HouseHoldA] [int] NULL ,
	[TE_HouseOfficeA] [int] NULL ,
	[TE_HouseHoldB] [int] NULL ,
	[TE_HouseOfficeB] [int] NULL ,
	[TE_HOMust] [bit] NULL ,
	[TE_SizeMin] [int] NULL ,
	[TE_SizeMax] [int] NULL ,
	[TE_SizeMust] [bit] NULL ,
	[TE_FloorMin] [int] NULL ,
	[TE_FloorMax] [int] NULL ,
	[TE_FloorMust] [bit] NULL ,
	[TE_HouseUse] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_HouseUseMust] [bit] NULL ,
	[TE_HouseFoward] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_ForwardMust] [bit] NULL ,
	[TE_RepairDegree] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_RepairDegreeMust] [bit] NULL ,
	[TE_Infrastructure] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_HouseInfrastructure] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_InfrastructureMust] [bit] NULL ,
	[TE_HouseInfrastructureMust] [bit] NULL ,
	[TE_HireMin] [int] NULL ,
	[TE_HireMax] [int] NULL ,
	[TE_HirePriceMust] [bit] NULL ,
	[TE_Validity] [int] NULL ,
	[TE_HireMinNum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Method] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_HireContent] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_School] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Park] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Ground] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Bus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Street] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_PinYin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_ShortPinYin] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Hit] [int] NULL ,
	[TE_IsCommend] [bit] NULL ,
	[TE_PublishDate] [datetime] NULL ,
	[TE_IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_LastModifyTime] [datetime] NULL ,
	[TE_ModifyNum] [int] NULL ,
	[TE_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_Check] [bit] NULL ,
	[TE_YuYueNum] [int] NULL ,
	[TE_IsHeZu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TE_IsHavePicture] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_QuYu] (
	[Area_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Area_Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area_OrderBy] [int] NULL ,
	[YX_AreaBig] [int] NULL ,
	[YX_Paixu] [int] NULL ,
	[YX_Key] [int] NULL ,
	[YX_County] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_Map] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[YX_BigName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_QuanShu] (
	[HR_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[HR_Content] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HR_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_RiCheng] (
	[RC_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[RC_Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RC_Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RC_StartDate] [datetime] NULL ,
	[RC_EndDate] [datetime] NULL ,
	[RC_StartTime] [datetime] NULL ,
	[RC_EndTime] [datetime] NULL ,
	[RC_Content] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[RC_JinDu] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_ID] [int] NULL ,
	[RC_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RC_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[RC_PublishDate] [datetime] NULL ,
	[RC_LastModifyTime] [datetime] NULL ,
	[RC_ModifyNum] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_SheShi] (
	[IF_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[IF_Content] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IF_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IF_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ShuJuKuBF] (
	[DB_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[DB_Time] [datetime] NULL ,
	[DB_ContentLength] [float] NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DB_Path] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[DB_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DB_IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DB_ViewNum] [int] NULL ,
	[DB_LoadNum] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_SysInfo] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sys_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_url] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_keywords] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_des] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_addr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_tel] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_fax] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_mobile] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_post] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_copyright] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_issendemail] [int] NULL ,
	[sys_isclose] [int] NULL ,
	[sys_isclosedes] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[sys_ispersonreg] [int] NULL ,
	[sys_iscentercomreg] [int] NULL ,
	[sys_ishousesalereg] [int] NULL ,
	[sys_ArticleNum] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_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_TongXunLu] (
	[LA_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[U_ID] [int] NULL ,
	[U_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[U_Type] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LA_IDCard] [varchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_CityName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Sex] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_CompanyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_CompanyPart] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Type] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_MobilePhone] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_WorkPhone] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_HomePhone] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Fax] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_QQ] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_MSN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Blog] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Content] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_Date] [datetime] NULL ,
	[LA_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LA_LastModifyTime] [datetime] NULL ,
	[LA_ModifyNum] [int] NULL ,
	[LA_ViewNum] [int] NULL ,
	[LA_AcceptLetterNum] [int] NULL ,
	[LA_SendLetterNum] [int] NULL ,
	[LA_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_TuPian] (
	[TP_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[TP_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_BianHao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_UpLoadDate] [datetime] NULL ,
	[TP_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_UpLoaderName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_PicType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_ContentLength] [float] NULL ,
	[TP_IsDefault] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_XiaoQu] (
	[SA_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SA_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area_ID] [int] NULL ,
	[SA_DetailAddress] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SA_ChuShouNum] [int] NULL ,
	[SA_ChuZuNum] [int] NULL ,
	[SA_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_YongTu] (
	[HU_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[HU_Content] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HU_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_YouQingLJ] (
	[FL_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FL_CompanyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_CompanyAddress] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_CompanyManager] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_CompanyPhone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_URL] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_PicURL] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_PicPath] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_Hit] [int] NULL ,
	[FL_OrderBy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_IsCommend] [bit] NULL ,
	[FL_AddTime] [datetime] NULL ,
	[FL_AddIP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FL_LastModifyTime] [datetime] NULL ,
	[FL_ModifyNum] [int] NULL ,
	[FL_EndDate] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_YuYue] (
	[YY_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[House_BianHao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_PublishDate] [datetime] NULL ,
	[YY_Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_Content] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_State] [bit] NULL ,
	[YY_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_QQ] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_MSN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YY_IsRegMember] [bit] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ZhongJieYQLJ] (
	[ZFL_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ZJ_ID] [int] NULL ,
	[ZFL_URL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_PicURL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_PicPath] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_OrderBy] [int] NULL ,
	[ZFL_CompanyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_CompanyPhone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_CompanyPeople] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_CompanyAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_AddTime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_AddIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZFL_LastModifyTime] [datetime] NULL ,
	[ZFL_ModifyNum] [int] NULL ,
	[ZFL_Hit] [int] NULL ,
	[ZFL_EndDate] [datetime] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[YX_ZhuangXiuCD] (
	[HRP_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[HRP_Content] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HRP_OrderBy] [int] NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[ZhongJieYuYue] (
	[ZId] [int] IDENTITY (1, 1) NOT NULL ,
	[Zname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zteleph] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zemail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zcount] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[GuanLianid] [int] NULL ,
	[ShiJian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_Applications] (
	[ApplicationName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoweredApplicationName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ApplicationId] [uniqueidentifier] NOT NULL ,
	[Description] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_Membership] (
	[ApplicationId] [uniqueidentifier] NOT NULL ,
	[UserId] [uniqueidentifier] NOT NULL ,
	[Password] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PasswordFormat] [int] NOT NULL ,
	[PasswordSalt] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MobilePIN] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[LoweredEmail] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[PasswordQuestion] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[PasswordAnswer] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsApproved] [bit] NOT NULL ,
	[IsLockedOut] [bit] NOT NULL ,
	[CreateDate] [datetime] NOT NULL ,
	[LastLoginDate] [datetime] NOT NULL ,
	[LastPasswordChangedDate] [datetime] NOT NULL ,
	[LastLockoutDate] [datetime] NOT NULL ,
	[FailedPasswordAttemptCount] [int] NOT NULL ,
	[FailedPasswordAttemptWindowStart] [datetime] NOT NULL ,
	[FailedPasswordAnswerAttemptCount] [int] NOT NULL ,
	[FailedPasswordAnswerAttemptWindowStart] [datetime] NOT NULL ,
	[Comment] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_Paths] (
	[ApplicationId] [uniqueidentifier] NOT NULL ,
	[PathId] [uniqueidentifier] NOT NULL ,
	[Path] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoweredPath] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_PersonalizationAllUsers] (
	[PathId] [uniqueidentifier] NOT NULL ,
	[PageSettings] [image] NOT NULL ,
	[LastUpdatedDate] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_PersonalizationPerUser] (
	[Id] [uniqueidentifier] NOT NULL ,
	[PathId] [uniqueidentifier] NULL ,
	[UserId] [uniqueidentifier] NULL ,
	[PageSettings] [image] NOT NULL ,
	[LastUpdatedDate] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_Profile] (
	[UserId] [uniqueidentifier] NOT NULL ,
	[PropertyNames] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PropertyValuesString] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PropertyValuesBinary] [image] NOT NULL ,
	[LastUpdatedDate] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_Roles] (
	[ApplicationId] [uniqueidentifier] NOT NULL ,
	[RoleId] [uniqueidentifier] NOT NULL ,
	[RoleName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoweredRoleName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Description] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_SchemaVersions] (
	[Feature] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CompatibleSchemaVersion] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IsCurrentVersion] [bit] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_Users] (
	[ApplicationId] [uniqueidentifier] NOT NULL ,
	[UserId] [uniqueidentifier] NOT NULL ,
	[UserName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LoweredUserName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MobileAlias] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsAnonymous] [bit] NOT NULL ,
	[LastActivityDate] [datetime] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_UsersInRoles] (
	[UserId] [uniqueidentifier] NOT NULL ,
	[RoleId] [uniqueidentifier] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[aspnet_WebEvent_Events] (
	[EventId] [char] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EventTimeUtc] [datetime] NOT NULL ,
	[EventTime] [datetime] NOT NULL ,
	[EventType] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EventSequence] [decimal](19, 0) NOT NULL ,
	[EventOccurrence] [decimal](19, 0) NOT NULL ,
	[EventCode] [int] NOT NULL ,
	[EventDetailCode] [int] NOT NULL ,
	[Message] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[ApplicationPath] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[ApplicationVirtualPath] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[MachineName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RequestUrl] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[ExceptionType] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Details] [ntext] 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]
;

ALTER TABLE [dbo].[ChuzhuYuYue] ADD 
	CONSTRAINT [PK_ChuzhuYuYue] PRIMARY KEY  CLUSTERED 
	(
		[CId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[Items] ADD 
	CONSTRAINT [PK_Items] PRIMARY KEY  CLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[NewsPingLun] ADD 
	CONSTRAINT [PK_NewsPingLun] PRIMARY KEY  CLUSTERED 
	(
		[Pid]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[Pay_GuanLi] ADD 
	CONSTRAINT [PK_Pay_GuanLi] PRIMARY KEY  CLUSTERED 
	(
		[Pay_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[Profile] ADD 
	CONSTRAINT [PK_Profile] PRIMARY KEY  CLUSTERED 
	(
		[ProfileID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[Subjects] ADD 
	CONSTRAINT [PK_Subjects] PRIMARY KEY  CLUSTERED 
	(
		[SubjectID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[Topics] ADD 
	CONSTRAINT [PK_Topics] PRIMARY KEY  CLUSTERED 
	(
		[TopicID]
	)  ON [PRIMARY] 
;

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

ALTER TABLE [dbo].[YX_Admins] ADD 
	CONSTRAINT [PK_YX_Admins] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_AgencyCompanyRegInfo] ADD 
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_CheckFlag] DEFAULT (0) FOR [AC_CheckFlag],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_BuiltTime] DEFAULT (getdate()) FOR [AC_BuiltTime],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_ChuZhuItems] DEFAULT (0) FOR [AC_ChuZhuItems],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_ChuShouItems] DEFAULT (0) FOR [AC_ChuShouItems],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_QiuGouItems] DEFAULT (0) FOR [AC_QiuGouItems],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_QiuZhuItems] DEFAULT (0) FOR [AC_QiuZhuItems],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_StopSerTime] DEFAULT (getdate()) FOR [AC_StopSerTime],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_IsFees] DEFAULT (0) FOR [AC_IsFees],
	CONSTRAINT [DF_YX_AgencyCompanyRegInfo_AC_CheckedTime] DEFAULT (getdate()) FOR [AC_CheckedTime],
	CONSTRAINT [PK_YX_AgencyCompanyRegInfo] PRIMARY KEY  CLUSTERED 
	(
		[AC_ACID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_AgencyCompanyShop] ADD 
	CONSTRAINT [PK_YX_AgencyCompanyShop] PRIMARY KEY  CLUSTERED 
	(
		[ACS_ID]
	)  ON [PRIMARY] 
;

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

ALTER TABLE [dbo].[YX_AreaSmall] ADD 
	CONSTRAINT [PK_YX_AreaSmall] PRIMARY KEY  CLUSTERED 
	(
		[YX_ID]
	)  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_Building] ADD 
	CONSTRAINT [DF_YX_Building_BU_chuzhuitems] DEFAULT (0) FOR [BU_chuzhuitems],
	CONSTRAINT [DF_YX_Building_BU_chushouitems] DEFAULT (0) FOR [BU_chushouitems],
	CONSTRAINT [DF_YX_Building_BU_qiuzhuitems] DEFAULT (0) FOR [BU_qiuzhuitems],
	CONSTRAINT [DF_YX_Building_BU_qiugouitems] DEFAULT (0) FOR [BU_qiugouitems],
	CONSTRAINT [DF_YX_Building_BU_IsFees] DEFAULT (0) FOR [BU_IsFees],
	CONSTRAINT [DF_YX_Building_BU_CHeckedTime] DEFAULT (getdate()) FOR [BU_CHeckedTime],
	CONSTRAINT [DF_YX_Building_BU_StopSerTime] DEFAULT (getdate()) FOR [BU_StopSerTime],
	CONSTRAINT [DF_YX_Building_BU_IsCheck] DEFAULT (0) FOR [BU_IsCheck],
	CONSTRAINT [PK_YX_Building] PRIMARY KEY  CLUSTERED 
	(
		[BU_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_CityZx] ADD 
	CONSTRAINT [PK_YX_Building_CityZx] PRIMARY KEY  CLUSTERED 
	(
		[CityZxID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_Commentar] ADD 
	CONSTRAINT [PK_YX_Building_Commentar] PRIMARY KEY  CLUSTERED 
	(
		[Com_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_Diary] ADD 
	CONSTRAINT [PK_YX_Building_Diary] PRIMARY KEY  CLUSTERED 
	(
		[Diary_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_Errorcorrection] ADD 
	CONSTRAINT [PK_YX_Building_Errorcorrection] PRIMARY KEY  CLUSTERED 
	(
		[Error_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_Household] ADD 
	CONSTRAINT [PK_YX_Building_Household] PRIMARY KEY  CLUSTERED 
	(
		[Hou_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_Registration] ADD 
	CONSTRAINT [PK_YX_Building_Registration] PRIMARY KEY  CLUSTERED 
	(
		[Reg_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Building_vote] ADD 
	CONSTRAINT [PK_YX_Building_vote] PRIMARY KEY  CLUSTERED 
	(
		[Vote_ID]
	)  ON [PRIMARY] 
;

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

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

ALTER TABLE [dbo].[YX_ChaoXiang] ADD 
	CONSTRAINT [PK_YX_ChaoXiang] PRIMARY KEY  CLUSTERED 
	(
		[HF_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ChuShou] ADD 
	CONSTRAINT [DF_YX_ChuShou_House_IsCheck] DEFAULT (1) FOR [House_IsCheck],
	CONSTRAINT [DF_YX_ChuShou_House_Condition] DEFAULT ('δ۳') FOR [House_Condition],
	CONSTRAINT [DF_YX_ChuShou_House_Hit] DEFAULT (0) FOR [House_Hit],
	CONSTRAINT [DF_YX_ChuShou_House_IsCommend] DEFAULT (1) FOR [House_IsCommend],
	CONSTRAINT [DF_YX_ChuShou_House_CommentNum] DEFAULT (0) FOR [House_CommentNum],
	CONSTRAINT [DF_YX_House_House_PublishDate] DEFAULT (getdate()) FOR [House_PublishDate],
	CONSTRAINT [DF_YX_ChuShou_House_State] DEFAULT ('') FOR [House_State],
	CONSTRAINT [DF_YX_ChuShou_House_YuYueNum] DEFAULT (0) FOR [House_YuYueNum],
	CONSTRAINT [DF_YX_ChuShou_House_ModifyNum] DEFAULT (0) FOR [House_ModifyNum],
	CONSTRAINT [PK_YX_ChuShou] PRIMARY KEY  CLUSTERED 
	(
		[House_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ChuZu] ADD 
	CONSTRAINT [DF_YX_ChuZu_HR_Hit] DEFAULT (0) FOR [HR_Hit],
	CONSTRAINT [DF_YX_ChuZu_HR_IsCommend] DEFAULT (1) FOR [HR_IsCommend],
	CONSTRAINT [DF_YX_ChuZu_HR_CommentNum] DEFAULT (0) FOR [HR_CommentNum],
	CONSTRAINT [DF_YX_ChuZu_HR_PublishDate] DEFAULT (getdate()) FOR [HR_PublishDate],
	CONSTRAINT [DF_YX_ChuZu_HR_ModifyNum] DEFAULT (0) FOR [HR_ModifyNum],
	CONSTRAINT [DF_YX_ChuZu_HR_IsCheck] DEFAULT (1) FOR [HR_IsCheck],
	CONSTRAINT [DF_YX_ChuZu_HR_YueYueNum] DEFAULT (0) FOR [HR_YueYueNum],
	CONSTRAINT [PK_YX_ChuZu] PRIMARY KEY  CLUSTERED 
	(
		[HR_ID]
	)  ON [PRIMARY] 
;

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

ALTER TABLE [dbo].[YX_GeRenYH] ADD 
	CONSTRAINT [DF_YX_Member_User_User_RegDate] DEFAULT (getdate()) FOR [U_RegDate],
	CONSTRAINT [DF_YX_Member_User_User_Check] DEFAULT (0) FOR [U_IsCheck],
	CONSTRAINT [DF_YX_Member_User_User_ArticalCount] DEFAULT (0) FOR [U_ArticalCount],
	CONSTRAINT [DF_YX_Member_User_User_HouseSaleCount] DEFAULT (0) FOR [U_HouseSaleCount],
	CONSTRAINT [DF_YX_Member_User_User_HouseRequestSaleCount] DEFAULT (0) FOR [U_HouseRequestSaleCount],
	CONSTRAINT [DF_YX_Member_User_User_HouseRentalCount] DEFAULT (0) FOR [U_HouseRentalCount],
	CONSTRAINT [DF_YX_Member_User_User_HouseBrothelCount] DEFAULT (0) FOR [U_HouseBrothelCount],
	CONSTRAINT [DF_YX_GeRenYH_U_IsFees] DEFAULT (0) FOR [U_IsFees],
	CONSTRAINT [DF_YX_GeRenYH_U_UseItems] DEFAULT (0) FOR [U_UseItems],
	CONSTRAINT [DF_YX_GeRenYH_U_ChuZhuItems] DEFAULT (0) FOR [U_ChuZhuItems],
	CONSTRAINT [DF_YX_GeRenYH_U_QiuGouItems] DEFAULT (0) FOR [U_QiuGouItems],
	CONSTRAINT [DF_YX_GeRenYH_U_QiuZhuItems] DEFAULT (0) FOR [U_QiuZhuItems],
	CONSTRAINT [PK_YX_Member_User] PRIMARY KEY  CLUSTERED 
	(
		[U_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_GongGao] ADD 
	CONSTRAINT [DF_YX_GongGao_AN_Publisher] DEFAULT ('վԱ') FOR [AN_Publisher],
	CONSTRAINT [DF_YX_GongGao_AN_PublishTime] DEFAULT (getdate()) FOR [AN_PublishTime],
	CONSTRAINT [PK_YX_GongGao] PRIMARY KEY  CLUSTERED 
	(
		[AN_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Inves] ADD 
	CONSTRAINT [PK_YX_Inves] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_JingJiRen] ADD 
	CONSTRAINT [PK_YX_JingJiRen] PRIMARY KEY  CLUSTERED 
	(
		[U_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_LeiBie] ADD 
	CONSTRAINT [PK_YX_LeiBie] PRIMARY KEY  CLUSTERED 
	(
		[HT_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_Link] ADD 
	CONSTRAINT [PK_YX_Link] PRIMARY KEY  CLUSTERED 
	(
		[YX_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_LiuYan] ADD 
	CONSTRAINT [PK_YX_LiuYan] PRIMARY KEY  CLUSTERED 
	(
		[LY_ID]
	)  ON [PRIMARY] 
;

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

ALTER TABLE [dbo].[YX_PingLun] ADD 
	CONSTRAINT [DF_YX_PingLun_PL_PublishDate] DEFAULT (getdate()) FOR [PL_PublishDate],
	CONSTRAINT [DF_YX_PingLun_PL_IsCheck] DEFAULT (0) FOR [PL_IsCheck],
	CONSTRAINT [PK_YX_PingLun] PRIMARY KEY  CLUSTERED 
	(
		[PL_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_QiuGou] ADD 
	CONSTRAINT [DF_YX_QiuGou_CS_PublishDate] DEFAULT (getdate()) FOR [CS_PublishDate],
	CONSTRAINT [DF_YX_QiuGou_CS_ModifyNum] DEFAULT (0) FOR [CS_ModifyNum],
	CONSTRAINT [DF_YX_QiuGou_CS_Hit] DEFAULT (0) FOR [CS_Hit],
	CONSTRAINT [DF_YX_QiuGou_CS_IsCommend] DEFAULT (1) FOR [CS_IsCommend],
	CONSTRAINT [DF_YX_QiuGou_CS_YuYueNum] DEFAULT (0) FOR [CS_YuYueNum],
	CONSTRAINT [DF_YX_QiuGou_CS_IsCheck] DEFAULT (1) FOR [CS_IsCheck],
	CONSTRAINT [PK_YX_QiuGou] PRIMARY KEY  CLUSTERED 
	(
		[CS_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_QiuZu] ADD 
	CONSTRAINT [DF_YX_QiuZu_TE_Hit] DEFAULT (0) FOR [TE_Hit],
	CONSTRAINT [DF_YX_QiuZu_TE_IsCommend] DEFAULT (1) FOR [TE_IsCommend],
	CONSTRAINT [DF_YX_QiuZu_TE_PublishDate] DEFAULT (getdate()) FOR [TE_PublishDate],
	CONSTRAINT [DF_YX_QiuZu_TE_ModifyNum] DEFAULT (0) FOR [TE_ModifyNum],
	CONSTRAINT [DF_YX_QiuZu_TE_Check] DEFAULT (1) FOR [TE_Check],
	CONSTRAINT [DF_YX_QiuZu_TE_YuYueNum] DEFAULT (0) FOR [TE_YuYueNum],
	CONSTRAINT [PK_YX_QiuZu] PRIMARY KEY  CLUSTERED 
	(
		[TE_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_QuYu] ADD 
	CONSTRAINT [PK_YX_QuYu] PRIMARY KEY  CLUSTERED 
	(
		[Area_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_QuanShu] ADD 
	CONSTRAINT [PK_YX_QuanShu] PRIMARY KEY  CLUSTERED 
	(
		[HR_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_RiCheng] ADD 
	CONSTRAINT [DF_YX_RiCheng_RC_PublishDate] DEFAULT (getdate()) FOR [RC_PublishDate],
	CONSTRAINT [PK_YX_RiCheng] PRIMARY KEY  CLUSTERED 
	(
		[RC_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_SheShi] ADD 
	CONSTRAINT [PK_YX_SheShi] PRIMARY KEY  CLUSTERED 
	(
		[IF_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ShuJuKuBF] ADD 
	CONSTRAINT [DF_YX_ShuJuKuBF_DB_Time] DEFAULT (getdate()) FOR [DB_Time],
	CONSTRAINT [PK_YX_ShuJuKuBF] PRIMARY KEY  CLUSTERED 
	(
		[DB_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_SysInfo] ADD 
	CONSTRAINT [PK_YX_SysInfo] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
;

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

ALTER TABLE [dbo].[YX_TongXunLu] ADD 
	CONSTRAINT [DF_YX_TongXunLu_LA_Date] DEFAULT (getdate()) FOR [LA_Date],
	CONSTRAINT [DF_YX_TongXunLu_LA_ModifyNum] DEFAULT (0) FOR [LA_ModifyNum],
	CONSTRAINT [DF_YX_TongXunLu_LA_ViewNum] DEFAULT (0) FOR [LA_ViewNum],
	CONSTRAINT [DF_YX_TongXunLu_LA_AcceptLetterNum] DEFAULT (0) FOR [LA_AcceptLetterNum],
	CONSTRAINT [DF_YX_TongXunLu_LA_SendLetterNum] DEFAULT (0) FOR [LA_SendLetterNum],
	CONSTRAINT [PK_YX_TongXunLu] PRIMARY KEY  CLUSTERED 
	(
		[LA_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_TuPian] ADD 
	CONSTRAINT [DF_YX_TuPian_TP_PublishDate] DEFAULT (getdate()) FOR [TP_UpLoadDate],
	CONSTRAINT [PK_YX_TuPian] PRIMARY KEY  CLUSTERED 
	(
		[TP_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_XiaoQu] ADD 
	CONSTRAINT [PK_YX_XiaoQu] PRIMARY KEY  CLUSTERED 
	(
		[SA_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_YongTu] ADD 
	CONSTRAINT [PK_YX_YongTu] PRIMARY KEY  CLUSTERED 
	(
		[HU_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_YouQingLJ] ADD 
	CONSTRAINT [PK_YX_YouQingLJ] PRIMARY KEY  CLUSTERED 
	(
		[FL_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_YuYue] ADD 
	CONSTRAINT [DF_YX_YuYue_YY_PublishDate] DEFAULT (getdate()) FOR [YY_PublishDate],
	CONSTRAINT [PK_YX_YuYue] PRIMARY KEY  CLUSTERED 
	(
		[YY_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ZhongJieYQLJ] ADD 
	CONSTRAINT [PK_YX_ZhongJieYQLJ] PRIMARY KEY  CLUSTERED 
	(
		[ZFL_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_ZhuangXiuCD] ADD 
	CONSTRAINT [PK_YX_ZhuangXiuCD] PRIMARY KEY  CLUSTERED 
	(
		[HRP_ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[ZhongJieYuYue] ADD 
	CONSTRAINT [PK_ZhongJieYuYue] PRIMARY KEY  CLUSTERED 
	(
		[ZId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_Applications] ADD 
	CONSTRAINT [DF__aspnet_Ap__Appli__60FC61CA] DEFAULT (newid()) FOR [ApplicationId],
	 PRIMARY KEY  NONCLUSTERED 
	(
		[ApplicationId]
	)  ON [PRIMARY] ,
	 UNIQUE  NONCLUSTERED 
	(
		[LoweredApplicationName]
	)  ON [PRIMARY] ,
	 UNIQUE  NONCLUSTERED 
	(
		[ApplicationName]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_Membership] ADD 
	CONSTRAINT [DF__aspnet_Me__Passw__75F77EB0] DEFAULT (0) FOR [PasswordFormat],
	 PRIMARY KEY  NONCLUSTERED 
	(
		[UserId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_Paths] ADD 
	CONSTRAINT [DF__aspnet_Pa__PathI__269AB60B] DEFAULT (newid()) FOR [PathId],
	 PRIMARY KEY  NONCLUSTERED 
	(
		[PathId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[PathId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD 
	CONSTRAINT [DF__aspnet_Perso__Id__2E3BD7D3] DEFAULT (newid()) FOR [Id],
	 PRIMARY KEY  NONCLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_Profile] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[UserId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_Roles] ADD 
	CONSTRAINT [DF__aspnet_Ro__RoleI__1387E197] DEFAULT (newid()) FOR [RoleId],
	 PRIMARY KEY  NONCLUSTERED 
	(
		[RoleId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_SchemaVersions] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[Feature],
		[CompatibleSchemaVersion]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_Users] ADD 
	CONSTRAINT [DF__aspnet_Us__UserI__64CCF2AE] DEFAULT (newid()) FOR [UserId],
	CONSTRAINT [DF__aspnet_Us__Mobil__65C116E7] DEFAULT (null) FOR [MobileAlias],
	CONSTRAINT [DF__aspnet_Us__IsAno__66B53B20] DEFAULT (0) FOR [IsAnonymous],
	 PRIMARY KEY  NONCLUSTERED 
	(
		[UserId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_UsersInRoles] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[UserId],
		[RoleId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[aspnet_WebEvent_Events] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[EventId]
	)  ON [PRIMARY] 
;
 
ALTER TABLE [dbo].[yx_CMSModel] ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[yx_id]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[YX_AreaSmall] ADD 
	CONSTRAINT [FK_YX_AreaSmall_YX_AreaBig] FOREIGN KEY 
	(
		[YX_AreaBig]
	) REFERENCES [dbo].[YX_AreaBig] (
		[YX_ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
;

ALTER TABLE [dbo].[aspnet_Membership] ADD 
	 FOREIGN KEY 
	(
		[ApplicationId]
	) REFERENCES [dbo].[aspnet_Applications] (
		[ApplicationId]
	),
	 FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[aspnet_Users] (
		[UserId]
	)
;

ALTER TABLE [dbo].[aspnet_Paths] ADD 
	 FOREIGN KEY 
	(
		[ApplicationId]
	) REFERENCES [dbo].[aspnet_Applications] (
		[ApplicationId]
	)
;

ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] ADD 
	 FOREIGN KEY 
	(
		[PathId]
	) REFERENCES [dbo].[aspnet_Paths] (
		[PathId]
	)
;

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD 
	 FOREIGN KEY 
	(
		[PathId]
	) REFERENCES [dbo].[aspnet_Paths] (
		[PathId]
	),
	 FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[aspnet_Users] (
		[UserId]
	)
;

ALTER TABLE [dbo].[aspnet_Profile] ADD 
	 FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[aspnet_Users] (
		[UserId]
	)
;

ALTER TABLE [dbo].[aspnet_Roles] ADD 
	 FOREIGN KEY 
	(
		[ApplicationId]
	) REFERENCES [dbo].[aspnet_Applications] (
		[ApplicationId]
	)
;

ALTER TABLE [dbo].[aspnet_Users] ADD 
	 FOREIGN KEY 
	(
		[ApplicationId]
	) REFERENCES [dbo].[aspnet_Applications] (
		[ApplicationId]
	)
;

ALTER TABLE [dbo].[aspnet_UsersInRoles] ADD 
	 FOREIGN KEY 
	(
		[RoleId]
	) REFERENCES [dbo].[aspnet_Roles] (
		[RoleId]
	),
	 FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[aspnet_Users] (
		[UserId]
	)
;

