CREATE ROLE metacpan;
CREATE ROLE "metacpan-api";

-- make things easier for when we're poking around from inside the container
CREATE USER root;

CREATE ROLE metacpan WITH LOGIN;
CREATE ROLE "metacpan-api" WITH LOGIN;

-- make things easier for when we're poking around from inside the container
CREATE USER root;

Add LOGIN permissions to new roles
Add LOGIN permissions to new roles

These were missing from the initial commit which causes metacpan and
metacpan-api to be unable to log into the database. These statements
could have been `CREATE USER` statements and would have avoided the need
for `WITH LOGIN`, but the end result is the same now.
