diff options
| author | patrick-scho | 2025-11-23 23:35:33 +0100 |
|---|---|---|
| committer | patrick-scho | 2025-11-23 23:35:33 +0100 |
| commit | 2d8d02bc7e7bdf9fedcaac9f4675a800a8c0e42f (patch) | |
| tree | cde97cfaa65692c5d13474df67e38cad90d2e84d /db_create.sh | |
| parent | 1dae937da69814ac9284cde92bebafca18534646 (diff) | |
| download | l21s-case-study-2d8d02bc7e7bdf9fedcaac9f4675a800a8c0e42f.tar.gz l21s-case-study-2d8d02bc7e7bdf9fedcaac9f4675a800a8c0e42f.zip | |
db scripts
Diffstat (limited to 'db_create.sh')
| -rwxr-xr-x | db_create.sh | 10 |
1 files changed, 10 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) +);' |