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

[<fa...@vh...>]

Author: fabrice
Date: 2006-06-14 17:52:52 +0200 (Wed, 14 Jun 2006)
New Revision: 1215

Added:
   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
Log:
missing index


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	2006-06-14 14:41:11 UTC (rev 1214)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/index-ldn_dc_map_item_id_idx.sql	2006-06-14 15:52:52 UTC (rev 1215)
@@ -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	2006-06-14 14:41:11 UTC (rev 1214)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/oracle-se-create.sql	2006-06-14 15:52:52 UTC (rev 1215)
@@ -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	2006-06-14 14:41:11 UTC (rev 1214)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/postgres-create.sql	2006-06-14 15:52:52 UTC (rev 1215)
@@ -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;