#!/bin/bash

set -eu

# shellcheck source=/dev/null
source "${BASE}/env_${ENVIRONMENT}"

echo "Create tombstone database and table if not already existing" 
echo "drop database if exists tombstone; create database tombstone" \
  | ssh_remote "$AZURE_MASTER" sudo -u gitlab-psql gitlab-psql -v ON_ERROR_STOP=1 -d postgres
echo "create table if not exists tombstone (created_at timestamptz default now() primary key, note text)" \
  | ssh_remote "$AZURE_MASTER" sudo -u gitlab-psql gitlab-psql -v ON_ERROR_STOP=1 -d tombstone