aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/setup.sql
diff options
context:
space:
mode:
authorMatthew Lemon <y@yulqen.org>2024-04-10 15:05:57 +0100
committerMatthew Lemon <y@yulqen.org>2024-04-10 15:05:57 +0100
commitb408be58debc72322fa1680a8f7293b9ba3b571f (patch)
treea20f0d5618aaa7618f024121342f94d3299b5dc6 /migrations/setup.sql
parent1f5402530a5c5011ee4e3d0fc8c94636fbd4ed60 (diff)
Postgres implementation now set up and in containers - no tables yet
Diffstat (limited to 'migrations/setup.sql')
-rw-r--r--migrations/setup.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/migrations/setup.sql b/migrations/setup.sql
new file mode 100644
index 0000000..3d95044
--- /dev/null
+++ b/migrations/setup.sql
@@ -0,0 +1,6 @@
+/* should be added manually at this point */
+CREATE DATABASE dbasik;
+\c dbasik
+
+CREATE ROLE 'dbasik' WITH LOGIN PASSWORD 'dbasik';
+CREATE EXTENSION IF NOT EXISTS citext;