CREATE DATABASE spacebin;
DO $$
DECLARE
    db_name text default 'spacebin';
    username text default 'spacebin';
    user_password text default '/Yg6OS+BJMj5rHFGhsf00A==';
BEGIN
    EXECUTE format('CREATE USER %I WITH PASSWORD %L', username, user_password);

    EXECUTE format('GRANT ALL PRIVILEGES ON DATABASE %I TO %I', db_name, username);
    SET search_path TO db_name, public;

    EXECUTE format('GRANT ALL PRIVILEGES ON SCHEMA public TO %I', username);
    EXECUTE format('GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO %I', username);
    EXECUTE format('GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO %I', username);
    EXECUTE format('ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO %I', username);
    EXECUTE format('ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO %I', username);
END $$;

grant all privileges on schema public to spacebin