db config

config.sql

-- Role: "publicmapping"

-- DROP ROLE publicmapping;

CREATE ROLE publicmapping LOGIN
  ENCRYPTED PASSWORD 'md50eb21ab7f658fe8dba10a343d987eed3'
  NOSUPERUSER INHERIT CREATEDB NOCREATEROLE;

-- Database: publicmapping1

-- DROP DATABASE publicmapping1;

CREATE DATABASE publicmapping2
  WITH OWNER = publicmapping
       ENCODING = 'UTF8'
       LC_COLLATE = 'en_US.UTF-8'
       LC_CTYPE = 'en_US.UTF-8'
       CONNECTION LIMIT = -1
           TEMPLATE = template_postgis;

\c publicmapping2

ALTER TABLE geometry_columns OWNER TO publicmapping;
ALTER TABLE spatial_ref_sys OWNER TO publicmapping;

-- See: http://www.postgresql.org/docs/8.4/static/ddl-schemas.html
-- for the reasons for creating a schema with the same name as the 
-- user name.
CREATE SCHEMA publicmapping2 AUTHORIZATION publicmapping;
~