CREATE ROLE motech NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${MOTECH_PWD}';
CREATE DATABASE motech;
REVOKE ALL ON DATABASE motech FROM public;
ALTER DATABASE motech OWNER TO motech;

CREATE DATABASE motechschema;
REVOKE ALL ON DATABASE motechschema FROM public;
ALTER DATABASE motechschema OWNER TO motech;

CREATE DATABASE motechdata;
REVOKE ALL ON DATABASE motechdata FROM public;
ALTER DATABASE motechdata OWNER TO motech;

CREATE DATABASE motechquartz;
REVOKE ALL ON DATABASE motechquartz FROM public;
ALTER DATABASE motechquartz OWNER TO motech;
