diff createPurlDB.sql @ 2:fb2a3b4542a4

restservice
author dwinter
date Wed, 31 Oct 2012 21:54:55 +0100
parents 08a476cdcfea
children
line wrap: on
line diff
--- a/createPurlDB.sql	Wed Oct 31 16:35:12 2012 +0100
+++ b/createPurlDB.sql	Wed Oct 31 21:54:55 2012 +0100
@@ -1,3 +1,19 @@
+-- Database: "purlDB"
+
+-- DROP DATABASE "purlDB";
+
+CREATE DATABASE "purlDB"
+  WITH OWNER = postgres
+       ENCODING = 'UTF8'
+       TABLESPACE = pg_default
+       LC_COLLATE = 'C'
+       LC_CTYPE = 'C'
+       CONNECTION LIMIT = -1;
+GRANT CONNECT, TEMPORARY ON DATABASE "purlDB" TO public;
+GRANT ALL ON DATABASE "purlDB" TO postgres;
+GRANT ALL ON DATABASE "purlDB" TO "purlUSER";
+
+
 -- Table: purls
 
 -- DROP TABLE purls;