TRS.WCM.Developer/贵州项目6个WCM节点迁移到海云/迁移前每个节点的特殊处理/city7/00_rename_table.sql

rename table exchange_appendix to wcmappendix;
rename table exchange_channel to wcmchannel;
rename table exchange_channelchildindexquote to wcmchannelchildindexquote;
rename table exchange_channelsyn to wcmchannelsyn;
rename table exchange_chnldoc to wcmchnldoc;
rename table exchange_document to wcmdocument;
rename table exchange_folderpublishconfig to wcmfolderpublishconfig;
rename table exchange_template to wcmtemplate;
rename table exchange_templateargument to wcmtemplateargument;
rename table exchange_templateemploy to wcmtemplateemploy;
rename table exchange_templatenest to wcmtemplatenest;
rename table exchange_templatequote to wcmtemplatequote;
rename table exchange_website to wcmwebsite;
rename table exchange_classinfo to xwcmclassinfo;
rename table exchange_classinfoview to xwcmclassinfoview;
rename table exchange_dbfieldinfo to xwcmdbfieldinfo;
rename table exchange_metaviewemployer to xwcmmetaviewemployer;
rename table exchange_metaviewfieldgroup to xwcmmetaviewfieldgroup;
rename table exchange_tableinfo to xwcmtableinfo;
rename table exchange_viewfieldinfo to xwcmviewfieldinfo;
rename table exchange_viewinfo to xwcmviewinfo;

-- metatables
rename table exchange_metatableldr to wcmmetatableldr;
rename table exchange_metatableGovInfo to wcmmetatableGovInfo;
rename table exchange_metatablezjdc to wcmmetatablezjdc;
rename table exchange_metatablezxft to wcmmetatablezxft;
rename table exchange_metatablelyd to wcmmetatablelyd;
rename table exchange_metatabledlgg to wcmmetatabledlgg;
rename table exchange_metatableGXZZZS to wcmmetatableGXZZZS;
rename table exchange_metatabletjsj to wcmmetatabletjsj;

SELECT CONCAT('rename table exchange_metatable',TABLENAME,' to wcmmetatable',TABLENAME ,';') from exchange_tableinfo;