db/db.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE DATABASE clog;

\connect clog

CREATE TABLE posts (
    id BIGINT NOT NULL, -- PRIMARY KEY UUID
    title CHARACTER VARYING NOT NULL,
    body CHARACTER VARYING NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);