01-create-databases.sql

-- Run on first boot of the postgres container. Each microservice gets its own
-- database and its own role — DB-per-service.

-- payment-service
CREATE USER payment_svc       WITH PASSWORD 'payment_svc';
CREATE DATABASE payment_db    OWNER payment_svc;

-- payment-query-service
CREATE USER query_svc         WITH PASSWORD 'query_svc';
CREATE DATABASE payment_query_db OWNER query_svc;

-- fraud-check-service
CREATE USER fraud_svc         WITH PASSWORD 'fraud_svc';
CREATE DATABASE fraud_db      OWNER fraud_svc;

-- notification-service
CREATE USER notification_svc  WITH PASSWORD 'notification_svc';
CREATE DATABASE notification_db OWNER notification_svc;