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

BEGIN;

SET search_path to diary;

CREATE TABLE articles(
  id UUID PRIMARY KEY,
  timestamp TIMESTAMPTZ NOT NULL,
  hash VARCHAR(64) NOT NULL,
  title TEXT NOT NULL,
  body TEXT NOT NULL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

COMMENT ON COLUMN articles.hash is 'SHA256 of org subtrees';
COMMENT ON COLUMN articles.body is 'HTML of org entries';

COMMIT;