[JBoss Portal] - Re: CMS repository corruption
by 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
18 years, 1 month