-- Deploy diary:article_taggings to pg
-- requires: schema
-- requires: tags
-- requires: articles

BEGIN;

SET search_path to diary;

CREATE TABLE article_taggings(
  article_id UUID REFERENCES articles(id),
  tag_id INT REFERENCES tags(id),
  PRIMARY KEY(article_id, tag_id)
);

COMMIT;