项目名称: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]
网站无须三方授权 · 安全稳定、维护方便