aboutsummaryrefslogtreecommitdiff
path: root/sqitch.plan
diff options
context:
space:
mode:
Diffstat (limited to 'sqitch.plan')
-rw-r--r--sqitch.plan26
1 files changed, 13 insertions, 13 deletions
diff --git a/sqitch.plan b/sqitch.plan
index 2ef8efd..3d51e33 100644
--- a/sqitch.plan
+++ b/sqitch.plan
@@ -3,27 +3,27 @@
%uri=https://git.tojo.tokyo/life-archive.git
kakeibo 2023-03-11T15:56:41Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for use in kakeibo.
-transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking transactions.
-items [kakeibo transactions] 2023-03-12T04:48:30Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking items.
+kakeibo.transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking transactions.
+kakeibo.items [kakeibo kakeibo.transactions] 2023-03-12T04:48:30Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking items.
update_timestamp [kakeibo] 2023-03-12T13:57:49Z Masaya Tojo <masaya@tojo.tokyo> # Add function to update timestamp.
-transactions_update_timestamp [transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to transactions table.
-items_update_timestamp [items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to items table.
+kakeibo.transactions_update_timestamp [kakeibo.transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to transactions table.
+kakeibo.items_update_timestamp [kakeibo.items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to items table.
@v1.0.0-alpha.1 2023-03-12T14:21:52Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.1.
-articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage articles.
-transactions [transactions@v1.0.0-alpha.1 articles] 2023-03-12T15:06:03Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to transactions table.
-items [items@v1.0.0-alpha.1 articles] 2023-03-12T15:12:15Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to items table.
+kakeibo.articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage articles.
+kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.1 kakeibo.articles] 2023-03-12T15:06:03Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to transactions table.
+kakeibo.items [kakeibo.items@v1.0.0-alpha.1 kakeibo.articles] 2023-03-12T15:12:15Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to items table.
@v1.0.0-alpha.2 2023-03-12T15:18:49Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.2.
-transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transaction type codes.
-articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to articles table.
-transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo <masaya@tojo.tokyo> # Add foreign key constraint to transactions table referencing types table.
+kakeibo.transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transaction type codes.
+kakeibo.articles_update_timestamp [kakeibo.articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to articles table.
+kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.2 kakeibo.articles] 2023-03-12T15:42:06Z Masaya Tojo <masaya@tojo.tokyo> # Add foreign key constraint to transactions table referencing types table.
common 2023-03-27T15:01:06Z Masaya Tojo <masaya@tojo.tokyo> # Add common schema.
update_timestamp [update_timestamp@v1.0.0-alpha.2] 2023-03-27T15:03:00Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp to common schema.
@v1.0.0-alpha.3 2023-03-27T15:07:33Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.3.
-articles_update_timestamp [articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
-items_update_timestamp [items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
-transactions_update_timestamp [transactions_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:53Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
+kakeibo.articles_update_timestamp [kakeibo.articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
+kakeibo.items_update_timestamp [kakeibo.items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
+kakeibo.transactions_update_timestamp [kakeibo.transactions_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:53Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
update_timestamp [update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:18:34Z Masaya Tojo <masaya@tojo.tokyo> # Drop kakeibo.update_timestamp.
photo 2023-03-27T15:39:16Z Masaya Tojo <masaya@tojo.tokyo> # Add photo schema.
photo.photos [photo] 2023-03-27T16:00:51Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking photos.