update db_create.sh

1 files changed, 18 insertions, 7 deletions

diff --git a/db_create.sh b/db_create.sh
index eb123cf..4306d93 100755
--- a/db_create.sh
+++ b/db_create.sh
@@ -1,10 +1,21 @@
 #!/usr/bin/env bash
-psql users -c '
+
+DB_DIR=${1:-db}
+DB_NAME=${2:-migration}
+
+# (re)create db
+dropdb "$DB_NAME"
+createdb "$DB_NAME"
+
+# init "$DB_NAME"
+psql "$DB_NAME" -c 'DROP TABLE users;'
+psql "$DB_NAME" -c '
 CREATE TABLE users(
-    ID int NOT NULL,
-    Mail varchar(320),
-    CanRead boolean,
-    CanWrite boolean,
-    CanDelete boolean,
-    PRIMARY KEY (ID)
+    USER_ID int NOT NULL,
+    MAIL varchar(320),
+    CAN_READ boolean,
+    CAN_WRITE boolean,
+    CAN_DELETE boolean,
+    PRIMARY KEY (USER_ID)
 );'
+