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

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

Author: apevec
Date: 2006-04-21 01:41:01 +0200 (Fri, 21 Apr 2006)
New Revision: 1115

Removed:
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/upgrade-6.3.0-6.3.1.sql
Modified:
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-6.3.0-6.3.1.sql
   trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql
Log:
separate upgrade script for PostgreSQL


Deleted: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/default/upgrade-6.3.0-6.3.1.sql

Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-6.3.0-6.3.1.sql	2006-04-20 13:55:17 UTC (rev 1114)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/oracle-se-6.3.0-6.3.1.sql	2006-04-20 23:41:01 UTC (rev 1115)
@@ -1 +1,7 @@
-@@ ../default/upgrade-6.3.0-6.3.1.sql
+alter table ldn_dublin_core_items add
+  (item_id integer constraint ldn_dub_cor_ite_ite_id_f_f7q6_ references cms_items(item_id));
+update ldn_dublin_core_items dc
+  set item_id
+   = (select dcm.item_id from LDN_DUBLIN_CORE_ITEM_MAP dcm where dcm.dublin_id=dc.dublin_id);
+
+-- drop table ldn_dublin_core_item_map;

Modified: trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql	2006-04-20 13:55:17 UTC (rev 1114)
+++ trunk/ccm-ldn-dublin/sql/ccm-ldn-dublin/upgrade/postgres-6.3.0-6.3.1.sql	2006-04-20 23:41:01 UTC (rev 1115)
@@ -1 +1,8 @@
-\i ../default/upgrade-6.3.0-6.3.1.sql
+alter table ldn_dublin_core_items add
+  item_id integer constraint ldn_dub_cor_ite_ite_id_f_f7q6_ references cms_items(item_id);
+update ldn_dublin_core_items
+  set item_id = dcm.item_id
+  from LDN_DUBLIN_CORE_ITEM_MAP dcm
+  where dcm.dublin_id=ldn_dublin_core_items.dublin_id;
+
+-- drop table ldn_dublin_core_item_map;