From 6fcbad753b6b513f74fa15c252d752f30491e519 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Sat, 16 Mar 2024 03:07:05 +0900 Subject: Add table to link articles. --- deploy/article_links.sql | 16 ++++++++++++++++ revert/article_links.sql | 9 +++++++++ sqitch.plan | 1 + verify/article_links.sql | 11 +++++++++++ 4 files changed, 37 insertions(+) create mode 100644 deploy/article_links.sql create mode 100644 revert/article_links.sql create mode 100644 verify/article_links.sql diff --git a/deploy/article_links.sql b/deploy/article_links.sql new file mode 100644 index 0000000..622076e --- /dev/null +++ b/deploy/article_links.sql @@ -0,0 +1,16 @@ +-- 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(id), + linked_article_id UUID REFERENCES articles(id), + PRIMARY KEY(article_id, linked_article_id) +); + + +COMMIT; diff --git a/revert/article_links.sql b/revert/article_links.sql new file mode 100644 index 0000000..d642a09 --- /dev/null +++ b/revert/article_links.sql @@ -0,0 +1,9 @@ +-- Revert diary:article_links from pg + +BEGIN; + +SET search_path to diary; + +DROP TABLE article_links; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index c500b49..ae245e1 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -6,3 +6,4 @@ schema 2024-03-10T11:00:19Z Masaya Tojo # Add schema for dia articles [schema] 2024-03-10T13:54:19Z Masaya Tojo # Add table manage diary articles. tags [schema] 2024-03-10T15:55:56Z Masaya Tojo # Add table manage diary tags. article_taggings [schema tags articles] 2024-03-15T17:54:50Z Masaya Tojo # Add table for tagging articles. +article_links [schema articles] 2024-03-15T18:04:03Z Masaya Tojo # Add table to link articles. diff --git a/verify/article_links.sql b/verify/article_links.sql new file mode 100644 index 0000000..f3fe4a0 --- /dev/null +++ b/verify/article_links.sql @@ -0,0 +1,11 @@ +-- Verify diary:article_links on pg + +BEGIN; + +SET search_path to diary; + +SELECT article_id, linked_article_id + FROM article_links + WHERE FALSE; + +ROLLBACK; -- cgit v1.2.3