[TOC] # 數據庫更換資源 ## 1、addonarticle 替換資源 ``` update jlxh_addonarticle set body=replace(body,'href=\"/uploads','href=\"https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/uploads'); update jlxh_addonarticle set body=replace(body,'src=\"/uploads','src=\"https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/uploads'); update jlxh_addonarticle set body=replace(body,'href=\"/ueditor','href=\"https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/ueditor'); update jlxh_addonarticle set body=replace(body,'src=\"/ueditor','src=\"https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/ueditor'); ``` ## 2、更改 litpic 字段長度 ``` ALTER TABLE `sj_archives` MODIFY COLUMN `litpic` char(200) ; ``` ## 3、archives 替換資源 ``` update jlxh_archives set litpic=replace(litpic,'/uploads','https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/uploads'); update jlxh_archives set litpic=replace(litpic,'/ueditor','https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/ueditor'); ``` ## 4、更改 loggo 字段長度 ``` ALTER TABLE `sj_flink` MODIFY COLUMN `logo` char(200); ``` ## 5、flink 替換資源 ``` update jlxh_flink set logo=replace(logo,'/uploads','https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/uploads'); update jlxh_uploads set url=replace(url,'/uploads','https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/uploads'); ``` ## 6、arctype目錄替換（不必須） ``` update jlxh_arctype set typedir=replace(typedir,'{cmspath}/','{cmspath}/a/'); update jlxh_arctype set sitepath=replace(sitepath,'{cmspath}/','{cmspath}/a/'); update jlxh_arctype set content=replace(content,'/uploads','https://sxjsjlxh.oss-cn-hangzhou.aliyuncs.com/uploads'); ``` ## 7、myppt ``` update xnc_myppt set pic=replace(pic,'/uploads','https://xncdlb.oss-cn-hangzhou.aliyuncs.com/uploads'); ```