#!/usr/bin/env bash

DB_DIR=${1:-db}
DB_NAME=${2:-migration}

# (re)create db
dropdb "$DB_NAME"
createdb "$DB_NAME"

# init "$DB_NAME"
psql "$DB_NAME" -c 'DROP TABLE users;'
psql "$DB_NAME" -c '
CREATE TABLE users(
    USER_ID int NOT NULL,
    MAIL varchar(320),
    CAN_READ boolean,
    CAN_WRITE boolean,
    CAN_DELETE boolean,
    PRIMARY KEY (USER_ID)
);'