blob: 8c259d147c0916dc1196663481e6243798805d42 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- 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;
|
