diff options
| -rwxr-xr-x | db_create.sh | 10 | ||||
| -rwxr-xr-x | db_drop.sh | 3 | ||||
| -rwxr-xr-x | db_start.sh (renamed from start_db.sh) | 0 |
3 files changed, 13 insertions, 0 deletions
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 index 56b9b2d..56b9b2d 100755 --- a/start_db.sh +++ b/db_start.sh |