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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-28 07:09:43 -0700 (Thu, 28 Jul 2011)
New Revision: 8024

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 sql for mapbender 2.7.3

fixed install.bat 2.7.22 ---> to 2.7.2


Modified: trunk/mapbender/resources/db/install.bat
===================================================================
--- trunk/mapbender/resources/db/install.bat	2011-07-28 14:04:47 UTC (rev 8023)
+++ trunk/mapbender/resources/db/install.bat	2011-07-28 14:09:43 UTC (rev 8024)
@@ -138,7 +138,9 @@
 echo   update to 2.7rc2 to 2.7.1
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7rc1_to_2.7rc2_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
 echo   update to 2.7.2
-psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.1_to_2.7.22_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.1_to_2.7.2_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
+echo   update to 2.7.3
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.2_to_2.7.3_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
 

Modified: trunk/mapbender/resources/db/install.sh
===================================================================
--- trunk/mapbender/resources/db/install.sh	2011-07-28 14:04:47 UTC (rev 8023)
+++ trunk/mapbender/resources/db/install.sh	2011-07-28 14:09:43 UTC (rev 8024)
@@ -139,6 +139,7 @@
       pgsql/$DBENCODING/update/update_2.6.2_to_2.7rc1_pgsql_$DBENCODING.sql \
       pgsql/$DBENCODING/update/update_2.7rc1_to_2.7rc2_pgsql_$DBENCODING.sql \
       pgsql/$DBENCODING/update/update_2.7.1_to_2.7.2_pgsql_$DBENCODING.sql \
+      pgsql/$DBENCODING/update/update_2.7.2_to_2.7.3_pgsql_$DBENCODING.sql \
       pgsql/pgsql_serial_set_sequences_2.7.sql \
 	> _install.sql
     echo "inserting data (this might take a while longer)"

Modified: trunk/mapbender/resources/db/update.bat
===================================================================
--- trunk/mapbender/resources/db/update.bat	2011-07-28 14:04:47 UTC (rev 8023)
+++ trunk/mapbender/resources/db/update.bat	2011-07-28 14:09:43 UTC (rev 8024)
@@ -112,6 +112,8 @@
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7rc1_to_2.7rc2_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
 echo   update to 2.7.2
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.1_to_2.7.2_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
+echo   update to 2.7.3
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.2_to_2.7.3_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_update.txt 2>> err_update.txt
 

Modified: trunk/mapbender/resources/db/update.sh
===================================================================
--- trunk/mapbender/resources/db/update.sh	2011-07-28 14:04:47 UTC (rev 8023)
+++ trunk/mapbender/resources/db/update.sh	2011-07-28 14:09:43 UTC (rev 8024)
@@ -103,6 +103,8 @@
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.7rc1_to_2.7rc2_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
     echo "update to 2.7.2"
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.7.1_to_2.7.2_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
+    echo "update to 2.7.3"
+	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.7.2_to_2.7.3_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