[Mapbender-commits] r7786 - branches/2.7/resources/db/pgsql/UTF-8/update trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: marc
Date: 2011-04-28 11:19:42 -0700 (Thu, 28 Apr 2011)
New Revision: 7786

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
fix 4 #819

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2011-04-27 13:06:31 UTC (rev 7785)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2011-04-28 18:19:42 UTC (rev 7786)
@@ -608,7 +608,7 @@
 ALTER  TABLE mb_user_wmc ADD COLUMN wmc_serial_id INTEGER;
 ALTER TABLE mb_user_wmc ADD COLUMN wmc_timestamp_create INTEGER;
 ALTER  TABLE mb_user_wmc ALTER COLUMN wmc_serial_id SET DEFAULT nextval('mb_user_wmc_wmc_serial_id_seq');
---UPDATE mb_user_wmc SET wmc_serial_id = NEXTVAL('mb_user_wmc_wmc_serial_id_seq'); TODO: this is only for older installations - if a serial column exists before, the serial ids will be updated - that is not what we want cause this are the references!
+UPDATE mb_user_wmc SET wmc_serial_id = NEXTVAL('mb_user_wmc_wmc_serial_id_seq') WHERE wmc_serial_id is null;
 
 
 

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2011-04-27 13:06:31 UTC (rev 7785)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2011-04-28 18:19:42 UTC (rev 7786)
@@ -608,10 +608,9 @@
 ALTER  TABLE mb_user_wmc ADD COLUMN wmc_serial_id INTEGER;
 ALTER TABLE mb_user_wmc ADD COLUMN wmc_timestamp_create INTEGER;
 ALTER  TABLE mb_user_wmc ALTER COLUMN wmc_serial_id SET DEFAULT nextval('mb_user_wmc_wmc_serial_id_seq');
---UPDATE mb_user_wmc SET wmc_serial_id = NEXTVAL('mb_user_wmc_wmc_serial_id_seq'); TODO: this is only for older installations - if a serial column exists before, the serial ids will be updated - that is not what we want cause this are the references!
+UPDATE mb_user_wmc SET wmc_serial_id = NEXTVAL('mb_user_wmc_wmc_serial_id_seq') WHERE wmc_serial_id is null;
 
 
-
 -- Constraint: pk_user_wmc
 
 ALTER TABLE mb_user_wmc