aboutsummaryrefslogtreecommitdiff
path: root/sqitch.plan
blob: f353f40801680e4360c8f29ccb5c36a971297e5d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
%syntax-version=1.0.0
%project=life-archive
%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.
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.
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.

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.

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.
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.

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.
@v1.0.0-alpha.4 2023-04-08T04:58:15Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.4

kakeibo.transaction_type [kakeibo] 2023-04-08T05:28:15Z Masaya Tojo <masaya@tojo.tokyo> # Add `transaction_type` enum type.
kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.4 kakeibo.transaction_type] 2023-04-08T05:50:31Z Masaya Tojo <masaya@tojo.tokyo> # Rename type_code column to type and change data type from integer to transaction_type.