diff options
Diffstat (limited to 'installation/setup_db.sql')
| -rw-r--r-- | installation/setup_db.sql | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/installation/setup_db.sql b/installation/setup_db.sql deleted file mode 100644 index 3014dc0..0000000 --- a/installation/setup_db.sql +++ /dev/null @@ -1,19 +0,0 @@ --- setup_db.sql - --- Create user (if it doesn't exist) -DO -$$ -BEGIN - IF NOT EXISTS ( - SELECT FROM pg_catalog.pg_roles WHERE rolname = 'silmataivas' - ) THEN - CREATE ROLE silmataivas LOGIN PASSWORD 'silmataivas'; - END IF; -END -$$; - --- Create database owned by the user -CREATE DATABASE silmataivas OWNER silmataivas; - --- Optional: grant all privileges explicitly -GRANT ALL PRIVILEGES ON DATABASE silmataivas TO silmataivas;
\ No newline at end of file |
