blob: 0b9b973b34d73fd05df7907d060a65305769c7e2 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
-- 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
);
COMMENT ON COLUMN articles.hash is 'SHA256 of org subtrees';
COMMENT ON COLUMN articles.body is 'HTML of org entries';
COMMIT;
|
