From c6095ad062eaa0f5576cfab1c4fe436b90c2fbfe Mon Sep 17 00:00:00 2001
From: Jesusaves <cpntb1@ymail.com>
Date: Sat, 10 Apr 2021 00:45:07 -0300
Subject: Add initial tools

---
 localserver/initdb.sh | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100755 localserver/initdb.sh

(limited to 'localserver/initdb.sh')

diff --git a/localserver/initdb.sh b/localserver/initdb.sh
new file mode 100755
index 0000000..074f8c5
--- /dev/null
+++ b/localserver/initdb.sh
@@ -0,0 +1,26 @@
+#!/usr/bin/env bash
+
+export DIR="$(pwd)"
+export VER=$(cat versions/sqlver 2>/dev/null)
+
+cd ../../server-data/sql-files
+
+echo Creating db and user...
+echo Enter mysql root password:
+mysql --force -u root -p <./init.sql
+result=$?
+if [ "$result" != 0 ]; then
+    echo Password failed. Trying with sudo...
+    sudo mysql --force -u root <./init.sql
+fi
+
+export CMD="mysql -u evol -pevol evol"
+
+echo Creating tables...
+$CMD <main.sql
+$CMD <logs.sql
+
+if [[ -z "${VER}" ]]; then
+    mkdir ${DIR}/versions
+    echo "20" >${DIR}/versions/sqlver
+fi
-- 
cgit v1.2.3-60-g2f50