[Mapbender-commits] r5844 - trunk/mapbender/resources/db

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2010-03-26 11:19:02 -0400 (Fri, 26 Mar 2010)
New Revision: 5844

Modified:
   trunk/mapbender/resources/db/install.bat
   trunk/mapbender/resources/db/install.sh
   trunk/mapbender/resources/db/update.bat
   trunk/mapbender/resources/db/update.sh
Log:
added pgsql_serial_set_sequences_2.7.sql to keep the sequences up-to-date

Modified: trunk/mapbender/resources/db/install.bat
===================================================================
--- trunk/mapbender/resources/db/install.bat	2010-03-26 15:08:27 UTC (rev 5843)
+++ trunk/mapbender/resources/db/install.bat	2010-03-26 15:19:02 UTC (rev 5844)
@@ -133,6 +133,8 @@
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.6_to_2.6.1_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
 echo   update to 2.7
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.6.1_to_2.7rc1_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
+echo   update sequences
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/pgsql_serial_set_sequences_2.7.sql %DBNAME% 1>> log_sequences.txt 2>> err_sequences.txt
 
 :POFILES
 rem install mapbender.conf

Modified: trunk/mapbender/resources/db/install.sh
===================================================================
--- trunk/mapbender/resources/db/install.sh	2010-03-26 15:08:27 UTC (rev 5843)
+++ trunk/mapbender/resources/db/install.sh	2010-03-26 15:19:02 UTC (rev 5844)
@@ -1,4 +1,4 @@
-#!/bin/bash
+#/bin/bash
 #
 # create database for mapbender
 #
@@ -144,6 +144,8 @@
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.6_to_2.6.1_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
 	echo "update to 2.7"
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.6.1_to_2.7rc1_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
+	echo "update sequences"
+	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/pgsql_serial_set_sequences_2.7.sql $DBNAME >> log_sequences.txt 2>> err_squences.txt
 
 }
 

Modified: trunk/mapbender/resources/db/update.bat
===================================================================
--- trunk/mapbender/resources/db/update.bat	2010-03-26 15:08:27 UTC (rev 5843)
+++ trunk/mapbender/resources/db/update.bat	2010-03-26 15:19:02 UTC (rev 5844)
@@ -106,7 +106,8 @@
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.6_to_2.6.1_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
 echo   update to 2.7
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.6.1_to_2.7rc1_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
-
+echo   update to 2.7
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/pgsql_serial_set_sequences_2.7.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
 goto END:
 
 :PGNOTFOUND

Modified: trunk/mapbender/resources/db/update.sh
===================================================================
--- trunk/mapbender/resources/db/update.sh	2010-03-26 15:08:27 UTC (rev 5843)
+++ trunk/mapbender/resources/db/update.sh	2010-03-26 15:19:02 UTC (rev 5844)
@@ -97,7 +97,8 @@
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.6_to_2.6.1_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
 	echo "update to 2.7"
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.6.1_to_2.7rc1_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
-
+    echo "update sequences"
+    psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/pgsql_serial_set_sequences_2.7.sql $DBNAME >> log_update.txt 2>> err_update.txt
 }
 
 #magic starts here