From 9723f6c9ae3d65b59499c8cddecbc1bc9b5e3bb0 Mon Sep 17 00:00:00 2001
From: Michael Wallner <mike@php.net>
Date: Wed, 13 May 2015 17:37:15 +0200
Subject: [PATCH] createdb

---
 config/sql/createdb.sh | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100755 config/sql/createdb.sh

diff --git a/config/sql/createdb.sh b/config/sql/createdb.sh
new file mode 100755
index 0000000..6fa1562
--- /dev/null
+++ b/config/sql/createdb.sh
@@ -0,0 +1,30 @@
+#!/usr/bin/sh
+#
+# run as (postgresql) superuser
+
+psql -e <<EOF
+-- createuser -DRS pharext
+CREATE
+	USER	"pharext"
+	NOCREATEDB
+	NOREPLICATION
+	NOSUPERUSER
+;
+
+-- createdb pharext -O pharext -E utf8 -l en_US.utf8
+CREATE 
+	DATABASE	"pharext"
+	OWNER		"pharext"
+	TEMPLATE	"template0"
+	ENCODING	'utf8'
+	LC_CTYPE	'en_US.utf8'
+	LC_COLLATE	'en_US.utf8'
+;
+
+\c pharext
+
+CREATE
+	EXTENSION	"uuid-ossp"
+;
+
+EOF
-- 
2.30.2