TRS.WCM.Developer/TRS.WCM.Developer/贵州项目/6_recover.sql

delete from trs_hycloud_iip.wcmwebsite where siteid > 100000;
delete from trs_hycloud_iip.xwcmviewinfo where viewinfoid > 100000;
delete from trs_hycloud_iip.xwcmtableinfo where tableinfoid > 100000;
delete from trs_hycloud_iip.xwcmmetaviewfieldgroup where metaviewfieldgroupid > 100000;

delete from trs_hycloud_iip.xwcmclassinfoview where classinfoviewid > 100000;
delete from trs_hycloud_iip.xwcmclassinfo where classinfoid > 100000;
delete from trs_hycloud_iip.xwcmdbfieldinfo where dbfieldinfoid > 100000;
delete from trs_hycloud_iip.xwcmmetaviewemployer where metaviewemployerid > 100000;
delete from trs_hycloud_iip.xwcmviewfieldinfo where viewfieldinfoid > 100000;
delete from trs_hycloud_iip.xwcmdbfieldinfo where dbfieldinfoid > 100000;



delete from trs_hycloud_iip.wcmchannel where channelid > 1000000;
delete from trs_hycloud_iip.wcmchannelsyn where channelsynid > 1000000;
delete from trs_hycloud_iip.wcmtemplate where tempid > 1000000;
delete from trs_hycloud_iip.wcmfolderpublishconfig where folderpublishconfigid > 1000000;
delete from trs_hycloud_iip.wcmtemplateargument where templateargumentid > 1000000;
delete from trs_hycloud_iip.wcmtemplateemploy where templateemployid > 1000000;
delete from trs_hycloud_iip.wcmtemplatenest where templatenestid > 1000000;
delete from trs_hycloud_iip.wcmtemplatequote where templatequoteid > 1000000;


delete from trs_hycloud_iip.wcmappendix where appendixid > 10000000;
delete from trs_hycloud_iip.wcmchnldoc where recid > 10000000;
delete from trs_hycloud_iip.wcmdocument where docid > 10000000;

delete from trs_mas.mas_masid where id > 1000000;
delete from trs_mas.mas_masvideo where id > 1000000;

delete from trs_data_migration.data_migration_log;