db_create.sh


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

#!/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)
);'