From 79c9bd6a059050bfcaf879b1854550ccffaa4d15 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Mon, 6 Mar 2023 02:04:29 +0900 Subject: Add update_timestamp trigger to articles table. --- sqitch.plan | 1 + 1 file changed, 1 insertion(+) (limited to 'sqitch.plan') 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 # Add table for link to diary articles. transactions_article_id [transactions articles] 2023-03-05T14:25:46Z Masaya Tojo # Add article_id column to transactions table. items_article_id [items articles] 2023-03-05T14:32:43Z Masaya Tojo # Add article_id column to items table. +articles_update_timestamp [articles update_timestamp] 2023-03-05T17:01:58Z Masaya Tojo # Add update_timestamp trigger to articles table. -- cgit v1.2.3