1_Create.User.sql

CREATE USER wdauthen WITH PASSWORD 'BBEcLWu5Cdzy3aeH'
  LOGIN
  NOSUPERUSER
  INHERIT
  NOCREATEDB
  NOCREATEROLE
  NOREPLICATION;
  
CREATE USER wdchat WITH PASSWORD 'BBRyAPNh6g4H9qte'
  LOGIN
  NOSUPERUSER
  INHERIT
  NOCREATEDB
  NOCREATEROLE
  NOREPLICATION;

CREATE DATABASE "WDCHAT"
    WITH 
    OWNER = wdchat
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_US.UTF-8'
    LC_CTYPE = 'en_US.UTF-8'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1;

CREATE DATABASE "WDAUTHEN"
    WITH 
    OWNER = wdauthen
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_US.UTF-8'
    LC_CTYPE = 'en_US.UTF-8'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1;