[Mapbender-commits] r7440 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2011-01-13 08:27:23 -0800 (Thu, 13 Jan 2011)
New Revision: 7440

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
Some bugfix for installations which have already a serial_id for wmc docs

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-01-12 16:53:53 UTC (rev 7439)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2011-01-13 16:27:23 UTC (rev 7440)
@@ -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');
+--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!