%syntax-version=1.0.0 %project=life-archive %uri=https://git.tojo.tokyo/life-archive.git kakeibo 2023-03-11T15:56:41Z Masaya Tojo # Add schema for use in kakeibo. transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo # Add table for tracking transactions. items [kakeibo transactions] 2023-03-12T04:48:30Z Masaya Tojo # Add table for tracking items. update_timestamp [kakeibo] 2023-03-12T13:57:49Z Masaya Tojo # Add function to update timestamp. transactions_update_timestamp [transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo # Add update_timestamp trigger to transactions table. items_update_timestamp [items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo # Add update_timestamp trigger to items table. @v1.0.0-alpha.1 2023-03-12T14:21:52Z Masaya Tojo # Tag v1.0.0-alpha.1. articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo # Add table to manage articles. transactions [transactions@v1.0.0-alpha.1 articles] 2023-03-12T15:06:03Z Masaya Tojo # Add article_id column to transactions table. items [items@v1.0.0-alpha.1 articles] 2023-03-12T15:12:15Z Masaya Tojo # Add article_id column to items table. @v1.0.0-alpha.2 2023-03-12T15:18:49Z Masaya Tojo # Tag v1.0.0-alpha.2. transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo # Add table to manage transaction type codes. articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo # Add update_timestamp trigger to articles table. transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo # Add foreign key constraint to transactions table referencing types table. common 2023-03-27T15:01:06Z Masaya Tojo # Add common schema. update_timestamp [update_timestamp@v1.0.0-alpha.2] 2023-03-27T15:03:00Z Masaya Tojo # Add update_timestamp to common schema. @v1.0.0-alpha.3 2023-03-27T15:07:33Z Masaya Tojo # Tag v1.0.0-alpha.3. articles_update_timestamp [articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo # 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 # 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 # Change kakeibo.update_timestamp to common.update_timestamp. update_timestamp [update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:18:34Z Masaya Tojo # Drop kakeibo.update_timestamp. photo 2023-03-27T15:39:16Z Masaya Tojo # Add photo schema. photo.photos [photo] 2023-03-27T16:00:51Z Masaya Tojo # Add table for tracking photos.