[Hyperic-hq-discuss] hq r14417 - branches/HQ_4_2_0_PATCH/installer/data

[<rm...@hy...>]

Author: rmorgan
Date: 2010-03-24 15:43:03 -0700 (Wed, 24 Mar 2010)
New Revision: 14417
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=14417

Modified:
   branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml
Log:
[HHQ-3826] Remove UI plugins which have resource view attachments on resource
types no longer defined in the tcserver plugin.  These plugin attachpoints will
be recreated when the new tcserver plugin is deployed.



Modified: branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml
===================================================================
--- branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml	2010-03-24 22:37:28 UTC (rev 14416)
+++ branches/HQ_4_2_0_PATCH/installer/data/db-upgrade.xml	2010-03-24 22:43:03 UTC (rev 14417)
@@ -10874,6 +10874,30 @@
 	    </schema-directSQL>  
    </schemaSpec>
 
+  <schemaSpec version="3.192.1">
+    <schema-directSQL>
+      <statement desc="Remove tc Server Appmgmt UI attachments">
+        delete from EAM_UI_ATTACHMENT where view_id in (select v.id from EAM_UI_VIEW v, EAM_UI_PLUGIN p where v.ui_plugin_id = p.id and p.name = 'tomcatappmgmt')
+      </statement>
+      <statement desc="Remove tc Server Appmgmgt UI views">
+        delete from EAM_UI_VIEW where ui_plugin_id in (select id from EAM_UI_PLUGIN where name = 'tomcatappmgmt')
+      </statement>
+      <statement desc="Remove tc Server Appmgmt UI plugin">
+        delete from EAM_UI_PLUGIN where name = 'tomcatappmgmt';
+      </statement>
+
+      <statement desc="Remove tc Server Config UI attachments">
+        delete from EAM_UI_ATTACHMENT where view_id in (select v.id from EAM_UI_VIEW v, EAM_UI_PLUGIN p where v.ui_plugin_id = p.id and p.name = 'tomcatserverconfig')
+      </statement>
+      <statement desc="Remove tc Server Config UI views">
+        delete from EAM_UI_VIEW where ui_plugin_id in (select id from EAM_UI_PLUGIN where name = 'tomcatserverconfig')
+      </statement>
+      <statement desc="Remove tc Server Config UI plugin">
+        delete from EAM_UI_PLUGIN where name = 'tomcatserverconfig';
+      </statement>
+    </schema-directSQL>
+  </schemaSpec>
+
 </dbupgrade>
 </target>
 </project>