aboutsummaryrefslogtreecommitdiff
path: root/sqitch.plan
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-06 02:04:29 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-06 02:04:29 +0900
commit79c9bd6a059050bfcaf879b1854550ccffaa4d15 (patch)
treefd8fe07ed547a40922f335ba1fbaab5471fd4e5a /sqitch.plan
parentb121761eb44b8fd8a8aee4e0945f6a7dcec9c719 (diff)
Add update_timestamp trigger to articles table.
Diffstat (limited to 'sqitch.plan')
-rw-r--r--sqitch.plan1
1 files changed, 1 insertions, 0 deletions
diff --git a/sqitch.plan b/sqitch.plan
index 0cea7ae..240155c 100644
--- a/sqitch.plan
+++ b/sqitch.plan
@@ -30,3 +30,4 @@ insert_transaction [insert_transaction@v1.0.0-dev3 appschema transactions] 2023-
articles [appschema] 2023-03-05T14:01:38Z Masaya Tojo <masaya@tojo.tokyo> # Add table for link to diary articles.
transactions_article_id [transactions articles] 2023-03-05T14:25:46Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to transactions table.
items_article_id [items articles] 2023-03-05T14:32:43Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to items table.
+articles_update_timestamp [articles update_timestamp] 2023-03-05T17:01:58Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to articles table.