[Aplaws-commit] r904 - in trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin: . default upgrade

[<ap...@vh...>]

Author: apevec
Date: 2005-09-22 09:09:47 +0200 (Thu, 22 Sep 2005)
New Revision: 904

Added:
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/index-ldn_dc_map_item_id_idx.sql
Modified:
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/oracle-se-create.sql
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/postgres-create.sql
   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/postgres-1.4.2-1.4.3.sql
Log:
Workaround for SF bug [ 1174803 ] data model bug in dublin core item
    UPGRADE NOTE: there are prolly already duplicate entries in ldn_dublin_core_item_map, they must be cleaned up manually (check the query in the upgrade script)


Added: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/index-ldn_dc_map_item_id_idx.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/index-ldn_dc_map_item_id_idx.sql	2005-09-22 06:20:11 UTC (rev 903)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/index-ldn_dc_map_item_id_idx.sql	2005-09-22 07:09:47 UTC (rev 904)
@@ -0,0 +1 @@
+create unique index ldn_dc_map_item_id_idx on ldn_dublin_core_item_map(item_id);

Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/oracle-se-create.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/oracle-se-create.sql	2005-09-22 06:20:11 UTC (rev 903)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/oracle-se-create.sql	2005-09-22 07:09:47 UTC (rev 904)
@@ -1,2 +1,3 @@
 @@ ddl/oracle-se/create.sql
 @@ ddl/oracle-se/deferred.sql
+@@ default/index-ldn_dc_map_item_id_idx.sql

Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/postgres-create.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/postgres-create.sql	2005-09-22 06:20:11 UTC (rev 903)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/postgres-create.sql	2005-09-22 07:09:47 UTC (rev 904)
@@ -1,4 +1,5 @@
 begin;
 \i ddl/postgres/create.sql
 \i ddl/postgres/deferred.sql
+\i default/index-ldn_dc_map_item_id_idx.sql
 end;

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 06:20:11 UTC (rev 903)
+++ 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)
@@ -1,2 +1,5 @@
 alter table ldn_dublin_core_items
 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;
+@@ ../default/index-ldn_dc_map_item_id_idx.sql

Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-1.4.2-1.4.3.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-1.4.2-1.4.3.sql	2005-09-22 06:20:11 UTC (rev 903)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-1.4.2-1.4.3.sql	2005-09-22 07:09:47 UTC (rev 904)
@@ -1,2 +1,5 @@
 alter table ldn_dublin_core_items
 add ccn_portal_instance varchar(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;
+\i ../default/index-ldn_dc_map_item_id_idx.sql