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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2010-10-04 14:08:49 +0000 (Mon, 04 Oct 2010)
New Revision: 7018

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
forgot timestamp_create

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	2010-10-04 14:04:19 UTC (rev 7017)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-10-04 14:08:49 UTC (rev 7018)
@@ -599,13 +599,14 @@
 DROP TABLE wmc_keyword CASCADE;
 DROP TABLE wmc_md_topic_category CASCADE;
 
---ALTER TABLE mb_user_wmc ADD COLUMN wmc_timestamp_create INTEGER;
+
 --adopt mb_user_wmc to store a serial column too!
 ALTER TABLE mb_user_wmc DROP CONSTRAINT pk_user_wmc;
 ALTER TABLE mb_user_wmc DROP CONSTRAINT mb_user_wmc_pkey; --for older implementations
 --DROP SEQUENCE mb_user_wmc_wmc_serial_id_seq cascade;
 CREATE SEQUENCE mb_user_wmc_wmc_serial_id_seq;
 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');