glintechjames/postgres13-atlassian repository overview

-- Create Crowd user & database
CREATE USER crowduser PASSWORD 'postgres';
CREATE DATABASE crowddb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
ALTER DATABASE crowddb OWNER TO crowduser;
GRANT ALL PRIVILEGES ON DATABASE crowddb TO crowduser;

-- Create Jira user & database
CREATE USER jirauser PASSWORD 'postgres';
CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
ALTER DATABASE jiradb OWNER TO jirauser;
GRANT ALL PRIVILEGES ON DATABASE jiradb TO jirauser;
    
 -- Create Confluence user & database
CREATE USER confluenceuser PASSWORD 'postgres' CREATEDB CREATEROLE;
CREATE DATABASE confluencedb WITH ENCODING 'UTF-8' LC_COLLATE 'en_US.utf8' LC_CTYPE 'en_US.utf8' TEMPLATE template0;
ALTER DATABASE confluencedb OWNER TO confluenceuser;
GRANT ALL PRIVILEGES ON DATABASE confluencedb TO confluenceuser;

-- Create Bitbucket user & database
CREATE USER bitbucketuser PASSWORD 'postgres';
CREATE DATABASE bitbucketdb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
ALTER DATABASE bitbucketdb OWNER TO bitbucketuser;
GRANT ALL PRIVILEGES ON DATABASE bitbucketdb TO bitbucketuser;

-- Create Bamboo user & database
CREATE USER bamboouser PASSWORD 'postgres';
CREATE DATABASE bamboodb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
ALTER DATABASE bitbucketdb OWNER TO bamboouser;
GRANT ALL PRIVILEGES ON DATABASE bitbucketdb TO bamboouser;

-- Set default schema for database. Run against jiradb only
CREATE SCHEMA jira AUTHORIZATION jirauser;
ALTER DATABASE jiradb SET search_path TO jira;
SHOW search_path;