Mercurial > hg > purlService
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;