From f3a3fd199083b5a11a71c9c159534e395bfef048 Mon Sep 17 00:00:00 2001
From: Andrei Karas <akaras@inbox.ru>
Date: Sat, 5 Sep 2015 20:47:10 +0300
Subject: localserver: Add updatedb script

---
 localserver/README      |  1 +
 localserver/updatedb.sh | 24 ++++++++++++++++++++++++
 2 files changed, 25 insertions(+)
 create mode 100755 localserver/updatedb.sh

diff --git a/localserver/README b/localserver/README
index 4b00c4e..04ea81d 100644
--- a/localserver/README
+++ b/localserver/README
@@ -5,6 +5,7 @@ build.sh          - build server from sources.
 givegm.sh         - give gm rights to first account created on server.
 initdb.sh         - initialize mariadb database.
 installconfigs.sh - install configurations into server data directory.
+updatedb.sh       - update if need sql database
 
 See also http://wiki.evolonline.org/guidelines/installmariadb
          http://wiki.evolonline.org/guidelines/localserver
diff --git a/localserver/updatedb.sh b/localserver/updatedb.sh
new file mode 100755
index 0000000..1d641c2
--- /dev/null
+++ b/localserver/updatedb.sh
@@ -0,0 +1,24 @@
+#!/bin/bash
+
+export VER=$(cat versions/sqlver 2>/dev/null)
+export SQLDIR="../../server-data/sql-files/"
+export CMD="mysql -u evol -pevol evol"
+
+function run {
+    echo "Running $1"
+#    $CMD <$1
+}
+
+if [[ -z "${VER}" ]]; then
+    export VER="1"
+fi
+
+if [ "${VER}" -lt "2" ]; then
+    run "2015-07-02--18-14.sql"
+    run "2015-07-08--13-08.sql"
+    run "2015-08-27--20-42.sql"
+fi
+
+if [ "${VER}" -lt "2" ]; then
+    echo "2" >versions/sqlver
+fi
-- 
cgit v1.2.3-70-g09d2