PostgreSQL

init_db.sh

# Create database owner
createuser -U postgres --createdb --createrole ${DB_OWNER};
psql --dbname ${DB_NAME} -c "ALTER USER '${DB_OWNER}' WITH PASSWORD '${DB_OWNER_PASSWORD}';"

# Create database
createdb -U ${DB_OWNER} ${DB_NAME};

# List databases
psql -U ${DB_OWNER} --list

# Create schema user
createuser -U ${DB_OWNER} --createdb --createrole ${SCHEMA_USER};
psql --dbname ${DB_NAME} -c "ALTER USER ${SCHEMA_USER} WITH PASSWORD '${SCHEMA_PASSWORD}';"

# Create schema
psql --dbname ${DB_NAME} -c "CREATE SCHEMA IF NOT EXISTS ${SCHEMA} AUTHORIZATION ${SCHEMA_USER};"
psql --dbname ${DB_NAME} -c "ALTER ROLE ${SCHEMA_USER} SET search_path TO ${SCHEMA},public;"
psql --dbname ${DB_NAME} -c "ALTER ROLE ${DB_OWNER} SET search_path TO ${SCHEMA},public;"

# Create table in schema
psql --dbname ${DB_NAME} -c "CREATE TABLE ${SCHEMA}.films {
    code        char(5) CONSTRAINT firstkey PRIMARY KEY,
    title       varchar(40) NOT NULL,
    did         integer NOT NULL,
    date_prod   date,
    kind        varchar(10),
    len         interval hour to minute
);