項目名稱：MB1013

更新詳細：

alter table db_cn_catalogue add type_prev varchar(50) null，type_next varchar(800) null

alter table db_cn_article add typeid_rel varchar(50) null

早期版本：

alter table db_cn_article add tempid int null,istime int null,ishtml int null, addr_lon varchar(50) null,addr_lat varchar(50) null,summary text null，video_url varchar(400) null

alter table db_cn_catalogue add page_list varchar(50) null,page_detail varchar(50) null ,sort_json varchar(100) null ;

update [db_cn_Catalogue] set sort_json='{"Name": "pubdate","Value": "1"}' where 1=1

update db_cn_catalogue set page_list='list.html',page_detail='detail.html' where 1=1

CREATE TABLE [dbo].[db_cn_Article_Temp](

[Id] [int] IDENTITY(1,1) NOT NULL,

[title] [varchar](200) NULL,

[content] [text] NULL,

[pubdate] [datetime] NULL,

[isdeal] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[db_Collect_Config](

[Id] [int] IDENTITY(1,1) NOT NULL,

[rule_name] [varchar](100) NULL,

[rule_url] [varchar](200) NULL,

[page_s] [varchar](50) NULL,

[page_e] [varchar](50) NULL,

[time_list] [varchar](50) NULL,

[time_page] [varchar](50) NULL,

[rule_config] [text] NULL,

[pubdate] [datetime] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

alter table db_seo_anchor add art_num int null,seo_arr varchar(400) null,anchor_type int null,site_domain varchar(50) null,site_lang varchar(50) null

alter table db_msg_user add usr_mail varchar(100) null,usr_tel varchar(50) null,usr_type int null,islock int null

alter table db_site_addr add islock int null

update db_Site_Addr set islock=0 where 1=1

alter table db_cn_IPDenied add poolbot varchar(400) null

alter table db_Collect_Config add site_domain varchar(50) null,site_lang varchar(50) null

alter table db_cn_Banner add _width int null,_height int null

public const int switch_taglang = 0;//開啟TAG語言版本 ,1為關閉語言版本

/*語言版本控制權限移交超級管理員*/

CREATE TABLE [dbo].[db_seo_siteurl](

[Id] [int] IDENTITY(1,1) NOT NULL,

[title] [varchar](800) NULL,

[Scheme] [varchar](50) NULL,

[Domain] [varchar](100) NULL,

[Domain_root] [varchar](50) NULL,

[Encoding] [varchar](50) NULL,

[url] [varchar](100) NULL,

[url_from] [varchar](100) NULL,

[hits] [int] NULL,

[dofav] [int] NULL,

[unfav] [int] NULL,

[pubdate] [datetime] NULL,

[pubdate_modify] [datetime] NULL,

[islock] [int] NULL,

[invade] [int] NULL,

[intime] [int] NULL,

[IP] [varchar](100) NULL,

[TDK_T] [varchar](800) NULL,

[TDK_K] [varchar](800) NULL,

[TDK_D] [varchar](2000) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[db_seo_siteurl] ADD CONSTRAINT [DF_db_seo_siteurl_dofav] DEFAULT ((0)) FOR [dofav]

GO

ALTER TABLE [dbo].[db_seo_siteurl] ADD CONSTRAINT [DF_db_seo_siteurl_unfav] DEFAULT ((0)) FOR [unfav]

GO

ALTER TABLE [dbo].[db_seo_siteurl] ADD CONSTRAINT [DF_db_seo_siteurl_intime] DEFAULT ((0)) FOR [intime]

GO

/*回收站小程序訂單列表*/

CREATE TABLE [dbo].[db_Member_OrderRecover](

[Id] [int] IDENTITY(1,1) NOT NULL,

[rsn] [varchar](50) NULL,

[rc_address] [varchar](50) NULL,

[addr_lon] [varchar](50) NULL,

[addr_lat] [varchar](50) NULL,

[rc_name] [varchar](50) NULL,

[rc_tel] [varchar](50) NULL,

[re_type] [varchar](50) NULL,

[re_num] [varchar](50) NULL,

[remark] [text] NULL,

[pic_url] [varchar](200) NULL,

[thm_url] [varchar](200) NULL,

[pubdate] [datetime] NULL,

[deal_status] [int] NULL,

[deal_agent] [int] NULL,

[deal_time] [datetime] NULL,

[timestamp] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

/*行業劃分*/

CREATE TABLE [dbo].[db_Site_Industry](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Indr_name] [varchar](50) NULL,

[Indr_name_jc] [varchar](50) NULL,

[Indr_name_jx] [varchar](50) NULL,

[Indr_name_py] [varchar](100) NULL,

[FID] [int] NULL,

[DEP] [int] NULL,

[sort] [int] NULL,

[remark] [text] NULL,

[pic_url] [varchar](200) NULL,

[thm_url] [varchar](200) NULL,

[pubdate_add] [datetime] NULL,

[pubdate_edit] [datetime] NULL,

[islock] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

/**/

CREATE TABLE [dbo].[db_seo_Kwords](

[Id] [int] IDENTITY(1,1) NOT NULL,

[kfirst] [char](10) NULL,

[kword] [varchar](50) NULL,

[kpy] [varchar](100) NULL,

[hits] [int] NULL

) ON [PRIMARY]