[Aplaws-commit] r2481 - releases/2.0.0/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4

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

Author: pboy
Date: 2013-02-03 08:56:16 +0000 (Sun, 03 Feb 2013)
New Revision: 2481

Modified:
   releases/2.0.0/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql
Log:
Backport r2460 (update script fixed). (on behalf of JensP)

Modified: releases/2.0.0/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql
===================================================================
--- releases/2.0.0/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql	2013-02-03 08:28:27 UTC (rev 2480)
+++ releases/2.0.0/ccm-core/sql/ccm-core/upgrade/default/6.6.3-6.6.4/remove_sitemap_legacy_entries.sql	2013-02-03 08:56:16 UTC (rev 2481)
@@ -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