deploy/articles.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- 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;