搜索历史

清除历史

热门搜索

网络工作室网站建设seo优化小程序

资讯动态

资讯动态

News Center

SQL:栏目页增加type_prev和type_next字段

更新日志 2022/11/27 9:09:11    admin    阅读 1085

项目名称: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]


TAG标签:
链接地址:/html/news/logs/1534.html
郑重声明:以上内容来源自玖捌网络工作室,转载请注明出处!
相关更新日志

兼顾高品质与个性化的界面设计

网站无须三方授权 · 安全稳定、维护方便

玖捌网络工作室
18972931619
扫码获取最新报价
0.040253