-- NOTE THIS IS FOR DEV USE ONLY NEEDED TO MAKE ALL THE USERS NEEDED TO MATCH PROD SETUP
CREATE SCHEMA IF NOT EXISTS bracketeer;
CREATE USER api WITH PASSWORD 'api';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON ALL TABLES IN SCHEMA bracketeer TO api;

-- probably can clamp this permissions further but migrations tend to be insane.
CREATE USER goose WITH PASSWORD 'goose';
GRANT ALL PRIVILEGES ON SCHEMA bracketeer TO goose;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA bracketeer TO goose;