db_create.sh


1
2
3
4
5
6
7
8
9
10

#!/usr/bin/env bash
psql users -c '
CREATE TABLE users(
    ID int NOT NULL,
    Mail varchar(320),
    CanRead boolean,
    CanWrite boolean,
    CanDelete boolean,
    PRIMARY KEY (ID)
);'