update db_create.sh

[l21s-case-study] / db_create.sh

diff --git a/db_create.sh b/db_create.sh
index eb123cf88f68b6833d75f9e35d780ac9217b4c93..4306d932fc791a4689d29ff8ff0021c65cf1903e 100755 (executable)
--- 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)
 );'
+