[Aplaws-commit] r1001 - contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade

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

Author: apevec
Date: 2005-11-17 23:21:16 +0100 (Thu, 17 Nov 2005)
New Revision: 1001

Modified:
   contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.2-1.0.3.sql
Log:
correct upgrade script


Modified: contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.2-1.0.3.sql
===================================================================
--- contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.2-1.0.3.sql	2005-11-17 22:01:16 UTC (rev 1000)
+++ contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.2-1.0.3.sql	2005-11-17 22:21:16 UTC (rev 1001)
@@ -13,9 +13,10 @@
   geo_area varchar2(4000)
 );
 
-update CAM_CONSULTATIONS set geo_area = (select to_char(geo_area) from tmp_CAM_CONSULTATIONS t where t.consultation_id = consultation_id);
-update CAM_CONSULTATIONS set target_audience = (select to_char(target_audience) from tmp_CAM_CONSULTATIONS t where t.consultation_id = consultation_id);
-update CAM_CONSULTATIONS set consultation_type = (select to_char(consultation_type) from tmp_CAM_CONSULTATIONS t where t.consultation_id = consultation_id);
-update CAM_CONSULTATIONS set topic = (select to_char(topic) from tmp_CAM_CONSULTATIONS t where t.consultation_id = consultation_id);
+update CAM_CONSULTATIONS c set geo_area = (select to_char(geo_area) from tmp_CAM_CONSULTATIONS where consultation_id = c.consultation_id);
+update CAM_CONSULTATIONS c set target_audience = (select to_char(target_audience) from tmp_CAM_CONSULTATIONS where consultation_id = c.consultation_id);
+update CAM_CONSULTATIONS c set consultation_type = (select to_char(consultation_type) from tmp_CAM_CONSULTATIONS where consultation_id = c.consultation_id);
+update CAM_CONSULTATIONS c set topic = (select to_char(topic) from tmp_CAM_CONSULTATIONS where consultation_id = c.consultation_id);
 
-drop table tmp_CAM_CONSULTATIONS;
+-- leave temp table, just in case
+-- drop table tmp_CAM_CONSULTATIONS;