From 64e1dab38b26b32c1e53605a0788b7ad49d2af09 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Sun, 6 Apr 2014 11:50:10 +0200
Subject: Make it slightly easier to create a new SQL database, since we do not
 hard-code database names.

---
 sql/nms.sql | 36 ------------------------------------
 1 file changed, 36 deletions(-)

(limited to 'sql/nms.sql')

diff --git a/sql/nms.sql b/sql/nms.sql
index 881e19a..bd695e1 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -1,39 +1,3 @@
---
--- PostgreSQL database cluster dump
---
-
-\connect postgres
-
-SET client_encoding = 'UTF8';
-SET standard_conforming_strings = on;
-
---
--- Roles
---
-
-CREATE ROLE nms;
-ALTER ROLE nms WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD '<removed>';
-CREATE ROLE postgres;
-ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION;
-
-
-
-
-
-
---
--- Database creation
---
-
-CREATE DATABASE nms WITH TEMPLATE = template0 OWNER = nms;
-REVOKE ALL ON DATABASE template1 FROM PUBLIC;
-REVOKE ALL ON DATABASE template1 FROM postgres;
-GRANT ALL ON DATABASE template1 TO postgres;
-GRANT CONNECT ON DATABASE template1 TO PUBLIC;
-
-
-\connect nms
-
 --
 -- PostgreSQL database dump
 --
-- 
cgit v1.2.3

