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