-- Deploy diary:articles to pg
-- requires: schema

BEGIN;

SET search_path to diary;

CREATE TABLE articles(
  article_id UUID PRIMARY KEY,
  timestamp TIMESTAMPTZ NOT NULL,
  hash VARCHAR(64) NOT NULL,
  source TEXT NOT NULL,
  title VARCHAR NOT NULL,
  body TEXT NOT NULL
);

COMMIT;