DROP DATABASE IF EXISTS openchpl;

CREATE DATABASE openchpl
  WITH OWNER = openchpl
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;

DROP DATABASE IF EXISTS openchpl_test;

CREATE DATABASE openchpl_test
  WITH OWNER = openchpl
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;

DROP DATABASE IF EXISTS openchpl;

CREATE DATABASE openchpl
  WITH OWNER = openchpl
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;

DROP DATABASE IF EXISTS openchpl_test;

CREATE DATABASE openchpl_test
  WITH OWNER = openchpl
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;

alter database openchpl owner to openchpl;
alter database openchpl_test owner to openchpl;

Reset script more robust wrt owners
Reset script more robust wrt owners
