[jboss-user] [JBoss Portal] - Re: CMS repository corruption

[Antoine_h]

The names of all the cms table starts with "jbp_cms_"

so you can build a sql script that do all those drops.

Here is my script (should work fine, even if I did not check it for a long time) :
------------------------------
  | -- Drop CMS tables
  | ------------------------------
  | Drop Table jbp_cms_cmsentry;
  | Drop Table jbp_cms_perm_criteria;
  | Drop Table jbp_cms_perm_role;
  | Drop Table jbp_cms_perm_user;
  | Drop Table jbp_cms_perm;
  | Drop Table jbp_cms_repositoryentry;
  | Drop Table jbp_cms_version_binval;
  | Drop Table jbp_cms_version_node;
  | Drop Table jbp_cms_version_prop;
  | Drop Table jbp_cms_version_refs;
  | Drop Table jbp_cms_versionentry;
  | Drop Table jbp_cms_wsp_binval;
  | Drop Table jbp_cms_wsp_node;
  | Drop Table jbp_cms_wsp_prop;
  | Drop Table jbp_cms_wsp_refs;
  | 
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4157899#4157899

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4157899