6_recover.sql 1.7 KB

1234567891011121314151617181920212223242526272829303132333435
  1. delete from trs_hycloud_iip.wcmwebsite where siteid > 100000;
  2. delete from trs_hycloud_iip.xwcmviewinfo where viewinfoid > 100000;
  3. delete from trs_hycloud_iip.xwcmtableinfo where tableinfoid > 100000;
  4. delete from trs_hycloud_iip.xwcmmetaviewfieldgroup where metaviewfieldgroupid > 100000;
  5. delete from trs_hycloud_iip.xwcmclassinfoview where classinfoviewid > 100000;
  6. delete from trs_hycloud_iip.xwcmclassinfo where classinfoid > 100000;
  7. delete from trs_hycloud_iip.xwcmdbfieldinfo where dbfieldinfoid > 100000;
  8. delete from trs_hycloud_iip.xwcmmetaviewemployer where metaviewemployerid > 100000;
  9. delete from trs_hycloud_iip.xwcmviewfieldinfo where viewfieldinfoid > 100000;
  10. delete from trs_hycloud_iip.xwcmdbfieldinfo where dbfieldinfoid > 100000;
  11. delete from trs_hycloud_iip.wcmchannel where channelid > 1000000;
  12. delete from trs_hycloud_iip.wcmchannelsyn where channelsynid > 1000000;
  13. delete from trs_hycloud_iip.wcmtemplate where tempid > 1000000;
  14. delete from trs_hycloud_iip.wcmfolderpublishconfig where folderpublishconfigid > 1000000;
  15. delete from trs_hycloud_iip.wcmtemplateargument where templateargumentid > 1000000;
  16. delete from trs_hycloud_iip.wcmtemplateemploy where templateemployid > 1000000;
  17. delete from trs_hycloud_iip.wcmtemplatenest where templatenestid > 1000000;
  18. delete from trs_hycloud_iip.wcmtemplatequote where templatequoteid > 1000000;
  19. delete from trs_hycloud_iip.wcmappendix where appendixid > 10000000;
  20. delete from trs_hycloud_iip.wcmchnldoc where recid > 10000000;
  21. delete from trs_hycloud_iip.wcmdocument where docid > 10000000;
  22. delete from trs_mas.mas_masid where id > 1000000;
  23. delete from trs_mas.mas_masvideo where id > 1000000;
  24. delete from trs_data_migration.data_migration_log;