-- 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,
  tag_id INT REFERENCES tags,
  PRIMARY KEY(article_id, tag_id)
);

COMMIT;