RcWaG3yW

1CREATE USER username WITH PASSWORD 'password';
2
3CREATE DATABASE database;
4
5GRANT ALL PRIVILEGES ON DATABASE database to username;
6
7CREATE TABLE IF NOT EXISTS USERS (
8  id          SERIAL    PRIMARY KEY,
9  name        TEXT      NOT NULL,
10  created_at  DATE      NOT NULL,
11  updated_at  DATE      NOT NULL
12  
13  
14CREATE TABLE IF NOT EXISTS POSTS (
15  id          SERIAL    PRIMARY KEY,
16  created_at  DATE      NOT NULL,
17  updated_at  DATE      NOT NULL,
18  users_id    INT       references USERS(id)
19);