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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2009-09-26 10:28:22 -0400 (Sat, 26 Sep 2009)
New Revision: 4712

Modified:
   trunk/mapbender/resources/db/install.sh
Log:
added update to 2.7rc1

Modified: trunk/mapbender/resources/db/install.sh
===================================================================
--- trunk/mapbender/resources/db/install.sh	2009-09-26 14:26:54 UTC (rev 4711)
+++ trunk/mapbender/resources/db/install.sh	2009-09-26 14:28:22 UTC (rev 4712)
@@ -45,7 +45,7 @@
         echo "database character encoding? (i)so-8859-1 or (u)tf-8?"
         read DBENCODING
     done
- 
+
    #ask for database template
     if [ "$DBVERSION" = "p" ]
     then
@@ -65,16 +65,16 @@
     #nicer vars
     if [  "$DBVERSION" = "p" ]
     then
-        DBVERSION="pgsql" 
+        DBVERSION="pgsql"
     else
-        DBVERSION="mysql" 
+        DBVERSION="mysql"
     fi
 
     if [  "$DBENCODING" = "i" ]
     then
-        DBENCODING="ISO-8859-1" 
+        DBENCODING="ISO-8859-1"
     else
-        DBENCODING="UTF-8" 
+        DBENCODING="UTF-8"
     fi
 
     echo ""
@@ -84,8 +84,8 @@
     echo ""
     echo "database port (e.g. 5432 for postgres, 3306 for mysql)?"
     read DBPORT
-    
 
+
     echo ""
     echo "database user?"
     read DBUSER
@@ -148,7 +148,7 @@
 	echo "update to 2.6"
 	mysql $DBNAME -p$DBPASSWORD -u $DBUSER -h $DBHOST -P $DBPORT < mysql/$DBENCODING/update/update_2.6rc1_to_2.6_mysql_$DBENCODING.sql >> log_update.txt 2>> err_update.txt
 
-	
+
 }
 
 #Create Database (Postgres)
@@ -166,7 +166,7 @@
     createdb -U $DBUSER  -h $DBHOST -p $DBPORT -E $DBENCODING $DBNAME -T $DBTEMPLATE
     echo "creating schema"
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/pgsql_schema_2.5.sql $DBNAME > log_schema.txt 2> err_schema.txt
-    echo "loading data"	
+    echo "loading data"
     psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/pgsql_data_2.5.sql $DBNAME > log_data.txt 2> err_data.txt
 	echo "setting sequences"
     psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/pgsql_serial_set_sequences_2.5.sql $DBNAME > log_sequences.txt 2> err_squences.txt
@@ -178,8 +178,9 @@
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.5.1_to_2.6rc1_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
 	echo "update to 2.6"
 	psql -U $DBUSER  -h $DBHOST -p $DBPORT -f pgsql/$DBENCODING/update/update_2.6rc1_to_2.6_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_to_2.7rc1_pgsql_$DBENCODING.sql $DBNAME >> log_update.txt 2>> err_update.txt
 
-
 }
 
 function set_permissions(){
@@ -217,7 +218,7 @@
           fi
           echo ""
           echo "please check and edit the entries in your mapbender.conf manually!"
-          
+
     fi
 }