.sql

-- Create extensions
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

--
-- Create Users
--

-- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults.
CREATE USER xxxx WITH PASSWORD 'xxxxxx';

--
-- Create Database and Schema
--

\c XXXXX
CREATE SCHEMA yyyyy;