summaryrefslogtreecommitdiff
path: root/installation/setup_db.sql
diff options
context:
space:
mode:
Diffstat (limited to 'installation/setup_db.sql')
-rw-r--r--installation/setup_db.sql19
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