From 2d8d02bc7e7bdf9fedcaac9f4675a800a8c0e42f Mon Sep 17 00:00:00 2001 From: patrick-scho Date: Sun, 23 Nov 2025 23:35:33 +0100 Subject: [PATCH 1/1] db scripts --- db_create.sh | 10 ++++++++++ db_drop.sh | 3 +++ start_db.sh => db_start.sh | 0 3 files changed, 13 insertions(+) create mode 100755 db_create.sh create mode 100755 db_drop.sh rename start_db.sh => db_start.sh (100%) diff --git a/db_create.sh b/db_create.sh new file mode 100755 index 0000000..eb123cf --- /dev/null +++ b/db_create.sh @@ -0,0 +1,10 @@ +#!/usr/bin/env bash +psql users -c ' +CREATE TABLE users( + ID int NOT NULL, + Mail varchar(320), + CanRead boolean, + CanWrite boolean, + CanDelete boolean, + PRIMARY KEY (ID) +);' diff --git a/db_drop.sh b/db_drop.sh new file mode 100755 index 0000000..b4ebf02 --- /dev/null +++ b/db_drop.sh @@ -0,0 +1,3 @@ +#!/usr/bin/env bash +psql users -c ' +DROP TABLE users;' diff --git a/start_db.sh b/db_start.sh similarity index 100% rename from start_db.sh rename to db_start.sh -- 2.50.1