deploy/article_links.sql


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

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

BEGIN;

SET search_path to diary;

CREATE TABLE article_links(
  article_id UUID REFERENCES articles,
  linked_article_id UUID REFERENCES articles(article_id),
  PRIMARY KEY(article_id, linked_article_id)
);

COMMIT;