SQL：欄目頁增加type_prev和type_ne北些xt字段

項目名稱：MB1013

更新詳細：

alter table db_cn_catal這些ogue 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,i綠農shtml int null, addr_lon varchar(50河上) null,addr_lat varchar(50) n電作ull,summary text null，video_什國url varchar(400) n錯媽ull

alter table db_cn_catalogue add p日歌age_list varchar(50) nu上對ll,page_detail varchar(50) null答關 ,sort_json var紙開char(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_det為黃ail='detail.html' 笑舊where 1=1

CREATE TABLE [dbo].[db_cn_Ar懂是ticle_Temp](

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

[title] [varchar](200) NULL,

[content] [text] NULL,

[pubdate] [datetime] NULL,

[isdeal] [int] NULL

) ON [PRIMARY] T河術EXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].聽女[db_Collect_Confi店兵g](

[Id] [int] IDENTITY(1,1) NOT N近信ULL,

[rule_name] [varchar](100) NULL,

[rule_url] [varch機街ar](200) NULL,

[page_s] [varchar](50山你) NULL,

[page_e] [varchar](50樂算) NULL,

[time_list] [varchar](50) 通器NULL,

[time_page] [va風明rchar](50) NULL,

[rule_config] [text] NULL,她民

[pubdate] [datetime] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIM嗎秒ARY]

alter table db_seo_anchor add art_num 黑朋int null,seo_arr var話動char(400) null,anchor_type i紙務nt null,site_domain varcha外金r(50) null,site_lang 要家varchar(50) null

alter table db_msg_user add usr_mail va訊街rchar(100) null,usr_tel varch慢房ar(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_IPD綠業enied add poolbo樂樂t varchar(400) null

alter table db_Collect_C店麗onfig add site_domain varcha東算r(50) null,site_lang v劇答archar(50) null

alter table db_cn_Banner add 的船_width int null用醫,_height int null

public const int switch_tagla相數ng = 0;//開(kāi)啟TAG語言版本 ,1為關閉語言版本弟呢

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

CREATE TABLE [dbo].[db_seo_s關什iteurl](

[Id] [int] IDENTIT農刀Y(1,1) NOT NULL,

[title] [varchar對業](800) NULL,

[Scheme] [varch他費ar](50) NULL,

[Domain] [varchar](1厭微00) NULL,

[Domain_root] [var東場char](50) NULL,

[Encoding] [varcha熱嗎r](50) NULL,

[url] [varchar](100) NUL文愛L,

[url_from] [varchar](100放愛) NULL,

[hits] [int] NULL,

[dofav] [int] NULL,

[unfav] [int] NULL,

[pubdate] [datetime] NULL,資做

[pubdate_modify] [datetime] NULL,

[islock] [int] NU到厭LL,

[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_dof對看av] 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_in生一time] DEFAULT ((0)) FOR 錯喝[intime]

GO

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

CREATE TABLE [dbo].[db_Me間工mber_OrderRecover](

[Id] [int] IDENTITY(1,1) NOT N飛愛ULL,

[rsn] [varchar](50) N冷得ULL,

[rc_address] [v關數archar](50) NULL,

[addr_lon] [varchar](50) NULL,

[addr_lat] [varchar](50) NULL,

[rc_name] [varchar](50) NU劇不LL,

[rc_tel] [varchar](50) NULL,

[re_type] [varchar](50) N技靜ULL,

[re_num] [varchar](50) NULL,

[remark] [text] NULL,

[pic_url] [varchar](200) NULL,

[thm_url] [varchar](200) NULL,

[pubdate] [date吧票time] NULL,

[deal_status] [in的通t] NULL,

[deal_agent] [int] NUL知老L,

[deal_time] [datetime] NU錢我LL,

[timestamp] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMAR你銀Y]

/*行業劃分*/

CREATE TABLE [dbo].[db_Site_Indu算店stry](

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

[Indr_name] [varchar](5兒麗0) 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] [datet跳醫ime] 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](1車暗00) NULL,

[hits] [int] NULL

) ON [PRIMARY]