oswilno/migrations/20220712193614_create_news.sql

CREATE TYPE "NewsStatus" AS ENUM (
    'Pending',
    'Published',
    'Hidden'
    );

CREATE TABLE news
(
    id           serial unique not null primary key,
    title        text          not null unique,
    body         text          not null,
    status       "NewsStatus"  not null default 'Pending',
    published_at timestamp     not null default now(),
    created_at   timestamp     not null default now()
);