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
|
