From 0673511d3939c04efd0e3fd350c47b4bfb3e322e Mon Sep 17 00:00:00 2001
From: Henry Jameson <me@hjkos.com>
Date: Sun, 26 Nov 2017 20:57:49 +0300
Subject: first version of safe DB setup

---
 lib/mix/tasks/sample_psql.eex | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 lib/mix/tasks/sample_psql.eex

(limited to 'lib/mix/tasks/sample_psql.eex')

diff --git a/lib/mix/tasks/sample_psql.eex b/lib/mix/tasks/sample_psql.eex
new file mode 100644
index 000000000..5353fa216
--- /dev/null
+++ b/lib/mix/tasks/sample_psql.eex
@@ -0,0 +1,6 @@
+CREATE USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB;
+CREATE DATABASE pleroma_dev;
+ALTER DATABASE pleroma_dev OWNER TO pleroma;
+\c pleroma_dev;
+--Extensions made by ecto.migrate that need superuser access
+CREATE EXTENSION citext;
-- 
cgit v1.2.3