%syntax-version=1.0.0 %project=kakeibo %uri=http://http//git.private.tojo.tokyo/kakeibo.git appschema 2023-02-26T06:27:59Z Masaya Tojo # Add schema for all kakeibo objects. transaction_type [appschema] 2023-02-27T15:51:38Z Masaya Tojo # Add transaction type. transactions [appschema transaction_type] 2023-02-27T15:53:02Z Masaya Tojo # Add table for tracking transactions. insert_transaction [appschema transactions] 2023-02-28T01:06:21Z Masaya Tojo # Add function to insert transaction. delete_transaction [transactions appschema] 2023-02-28T12:00:07Z Masaya Tojo # Create a function to delete a transaction. items [appschema transactions] 2023-02-28T12:08:45Z Masaya Tojo # Add items table for tracking individual products in transaction. insert_item [appschema items] 2023-02-28T13:13:22Z Masaya Tojo # Add function to insert item. delete_item [appschema items] 2023-02-28T13:13:39Z Masaya Tojo # Add function to delete item. update_timestamp [appschema] 2023-02-28T14:30:04Z Masaya Tojo # Add triger function to update a timestamp. transactions_update_timestamp [transactions update_timestamp] 2023-02-28T16:43:49Z Masaya Tojo # Add update_timestamp trigger to transactions table. items_update_timestamp [items update_timestamp] 2023-02-28T17:04:02Z Masaya Tojo # Add update_timestamp trigger to items table. @v1.0.0-dev1 2023-03-04T09:29:02Z Masaya Tojo # Tag v1.0.0-dev1. transaction_type_to_integer [transactions] 2023-03-04T09:32:34Z Masaya Tojo # Make transaction type integer. insert_transaction [insert_transaction@v1.0.0-dev1 appschema transactions] 2023-03-04T10:40:25Z Masaya Tojo # Change insert_transaction signature to use integer.