[Aplaws-commit] r2460 - trunk/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4

[<pb...@fe...>]

Author: pboy
Date: 2013-02-02 13:53:24 +0000 (Sat, 02 Feb 2013)
New Revision: 2460

Modified:
   trunk/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql
Log:
Fixed update script (removed core admin sitemap, which no longer works because all sitenodes are rfeplaced by new style apps). (On behalf of JensP)

Modified: trunk/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql
===================================================================
--- trunk/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql	2013-02-02 13:51:41 UTC (rev 2459)
+++ trunk/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql	2013-02-02 13:53:24 UTC (rev 2460)
@@ -135,3 +135,24 @@
 -- functionality and is removed.
 -- New, legacy free application works without a (dummy) Application table
 drop table sitemap_app ;
+
+delete from applications 
+    where application_type_id =
+        (select application_type_id from application_types 
+            where object_type like '%sitemap.SiteMap%');
+
+delete from object_container_map
+    where object_id = 
+        (select object_id from acs_objects
+            where object_type like '%sitemap.SiteMap%');
+
+delete from object_context
+    where object_id = 
+        (select object_id from acs_objects
+            where object_type like '%sitemap.SiteMap%');
+
+delete from acs_objects
+    where object_type like '%sitemap.SiteMap%';
+
+delete from application_types 
+    where object_type like '%sitemap.SiteMap%';
\ No newline at end of file