#!/bin/bash
# SET SOME VARIABLES
TOPICS=3

TOPIC_1="country"
VERSION_TOPIC_1="administrative_units.gaul_eez_dissolved_201912"
FID_TOPIC_1="country_id"

TOPIC_2="ecoregion"
VERSION_TOPIC_2="habitats_and_biotopes.ecoregions_2019"
FID_TOPIC_2="first_level_code"

TOPIC_3="wdpa"
VERSION_TOPIC_3="protected_sites.wdpa_202003"
FID_TOPIC_3="wdpaid"

SQL="sql"

## database parameters
HOST="dopaprc"
USER="h05ibex"
DB="wolfe"
SCH="cep202003"
PO=5432

dbpar1="host=${HOST} user=${USER} dbname=${DB} port=${PO}"
dbpar2="-h ${HOST} -U ${USER} -d ${DB} -p ${PO}"