[Mapbender-commits] r8723 - branches/2.7/resources/db

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2013-10-10 06:56:14 -0700 (Thu, 10 Oct 2013)
New Revision: 8723

Modified:
   branches/2.7/resources/db/install.bat
   branches/2.7/resources/db/install.sh
   branches/2.7/resources/db/update.bat
   branches/2.7/resources/db/update.sh
Log:
added update_2.7.3_to_2.7.4_pgsql_UTF-8.sql file to install/update scripts

Modified: branches/2.7/resources/db/install.bat
===================================================================
--- branches/2.7/resources/db/install.bat	2013-10-10 13:53:18 UTC (rev 8722)
+++ branches/2.7/resources/db/install.bat	2013-10-10 13:56:14 UTC (rev 8723)
@@ -142,6 +142,8 @@
 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 to 2.7.4
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.3_to_2.7.4_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: branches/2.7/resources/db/install.sh
===================================================================
--- branches/2.7/resources/db/install.sh	2013-10-10 13:53:18 UTC (rev 8722)
+++ branches/2.7/resources/db/install.sh	2013-10-10 13:56:14 UTC (rev 8723)
@@ -141,6 +141,7 @@
       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/$DBENCODING/update/update_2.7.3_to_2.7.4_pgsql_$DBENCODING.sql \
       pgsql/pgsql_serial_set_sequences_2.7.sql \
 	> _install.sql
     echo "inserting data (this might take a while longer)"

Modified: branches/2.7/resources/db/update.bat
===================================================================
--- branches/2.7/resources/db/update.bat	2013-10-10 13:53:18 UTC (rev 8722)
+++ branches/2.7/resources/db/update.bat	2013-10-10 13:56:14 UTC (rev 8723)
@@ -109,11 +109,13 @@
 echo   update to 2.7rc1
 psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.6.2_to_2.7rc1_pgsql_%USEDBENC%.sql %DBNAME% 1>> log_update.txt 2>> err_update.txt
 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
+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 to 2.7.4
+psql -U %DBUSER% -h %DBHOST% -p %DBPORT% -f pgsql/%USEDBENC%/update/update_2.7.3_to_2.7.4_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: branches/2.7/resources/db/update.sh
===================================================================
--- branches/2.7/resources/db/update.sh	2013-10-10 13:53:18 UTC (rev 8722)
+++ branches/2.7/resources/db/update.sh	2013-10-10 13:56:14 UTC (rev 8723)
@@ -104,7 +104,9 @@
     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    
+	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 to 2.7.4"
+	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.7.3_to_2.7.4_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