From 7020671f763df8f6f151a58dd77a98d55799e00d Mon Sep 17 00:00:00 2001
From: patrick-scho <patrick.schoenberger@posteo.de>
Date: Mon, 24 Nov 2025 15:14:13 +0000
Subject: [PATCH] update db_create.sh

---
 db_create.sh | 25 ++++++++++++++++++-------
 1 file 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)
 );'
+
-- 
2.50.1