Make it slightly easier to create a new SQL database, since we do not hard-code database names.

1 files changed, 0 insertions, 36 deletions

diff --git a/sql/nms.sql b/sql/nms.sql
index 881e19a..bd695e1 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -1,40 +1,4 @@
 --
--- 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
 --