postgres_init.sql

-- This script initializes a PostgreSQL database environment with a user and a database.

-- Create User Service DB
DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'en_US.utf8' LC_CTYPE = 'en_US.utf8' TABLESPACE = pg_default CONNECTION LIMIT = -1;

-- Create Curriculum Service DB
DROP DATABASE IF EXISTS orderdb;
CREATE DATABASE orderdb WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'en_US.utf8' LC_CTYPE = 'en_US.utf8' TABLESPACE = pg_default CONNECTION LIMIT = -1;

-- Create Curriculum Service DB
DROP DATABASE IF EXISTS stationdb;
CREATE DATABASE stationdb WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'en_US.utf8' LC_CTYPE = 'en_US.utf8' TABLESPACE = pg_default CONNECTION LIMIT = -1;

-- Create Curriculum Service DB
DROP DATABASE IF EXISTS ticketdb;
CREATE DATABASE ticketdb WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'en_US.utf8' LC_CTYPE = 'en_US.utf8' TABLESPACE = pg_default CONNECTION LIMIT = -1;