summaryrefslogtreecommitdiff
path: root/installation/setup_db.sql
diff options
context:
space:
mode:
authorDawid Rycerz <dawid@rycerz.xyz>2025-07-14 19:34:59 +0300
committerDawid Rycerz <dawid@rycerz.xyz>2025-07-14 19:34:59 +0300
commit50ce8cb96b2b218751c2fc2a6b19372f51846acc (patch)
treee2c634d2ce856062d527667d47815a05a53361c8 /installation/setup_db.sql
parent0ab2e5ba2b0631b28b5b1405559237b3913c878f (diff)
feat: rewrite in rust
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