[Aplaws-commit] r905 - trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade

[<ss...@vh...>]

Author: sshinde
Date: 2005-09-22 12:18:55 +0200 (Thu, 22 Sep 2005)
New Revision: 905

Modified:
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-1.4.2-1.4.3.sql
Log:
Added sample statements to delete duplicate dublin mappings.


Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-1.4.2-1.4.3.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-1.4.2-1.4.3.sql	2005-09-22 07:09:47 UTC (rev 904)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-1.4.2-1.4.3.sql	2005-09-22 10:18:55 UTC (rev 905)
@@ -2,4 +2,15 @@
 add ccn_portal_instance varchar2(200);
 -- following query must return 0 rows, otherwise unique index creation will fail
 select item_id from ldn_dublin_core_item_map group by item_id having count(*) >1;
+--
+-- Deletion of duplicate dublin item mappings involves following tables.
+-- dublin_id entry in following delete statements should be figured out
+-- manually.
+--delete from ldn_dublin_core_item_map where dublin_id = 168927;
+--delete from LDN_DUBLIN_CORE_ITEMS where dublin_id = 168927;
+--delete from cms_items where item_id = 168927;
+--delete from object_context where object_id = 168927;
+--delete from OBJECT_CONTAINER_MAP where object_id = 168927;
+--delete from acs_objects where object_id = 168927;
+--
 @@ ../default/index-ldn_dc_map_item_id_idx.sql