index
:
life-archive-schema.git
main
Sqitch: 私生活用 DB のマイグレーション管理.
Masaya Tojo
about
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
verify
Age
Commit message (
Expand
)
Author
2023-04-25
Add NOT NULL constraint to column `type`.
HEAD
main
Masaya Tojo
2023-04-23
Rename column from `type_code` to `type`.
Masaya Tojo
2023-04-19
Revert "Add `transaction_type` enum type."
...
Masaya Tojo
2023-04-19
Revert "Rename type_code column to type and change type to transaction_type."
...
Masaya Tojo
2023-04-08
Rename type_code column to type and change type to transaction_type.
Masaya Tojo
2023-04-08
Add `transaction_type` enum type.
Masaya Tojo
2023-03-29
Remove trnasaction_types from history.
Masaya Tojo
2023-03-28
Add `kakeibo.` prefix.
Masaya Tojo
2023-03-28
Add table for tracking photos.
Masaya Tojo
2023-03-28
Add photo schema.
Masaya Tojo
2023-03-28
Drop kakeibo.update_timestamp.
Masaya Tojo
2023-03-28
Change kakeibo.update_timestamp to common.update_timestamp.
Masaya Tojo
2023-03-28
Add update_timestamp to common schema.
Masaya Tojo
2023-03-28
Add common schema.
Masaya Tojo
2023-03-27
Delete insert/delete functions.
Masaya Tojo
2023-03-27
Rename `schema` to `kakeibo`.
Masaya Tojo
2023-03-14
Add foreign key constraint to transactions table referencing types table.
Masaya Tojo
2023-03-14
Add update_timestamp trigger to articles table.
Masaya Tojo
2023-03-14
Add table to manage transaction type codes.
Masaya Tojo
2023-03-13
Add article_id column to items table.
Masaya Tojo
2023-03-13
Add article_id column to transactions table.
Masaya Tojo
2023-03-12
Add table to manage articles.
Masaya Tojo
2023-03-12
Add update_timestamp trigger to items table.
Masaya Tojo
2023-03-12
Add update_timestamp trigger to transactions table.
Masaya Tojo
2023-03-12
Add function to update timestamp.
Masaya Tojo
2023-03-12
Add function to delete transaction.
Masaya Tojo
2023-03-12
Add function to delete item.
Masaya Tojo
2023-03-12
Add function to add new item.
Masaya Tojo
2023-03-12
Add function to create new transaction.
Masaya Tojo
2023-03-12
Add table for tracking items.
Masaya Tojo
2023-03-12
Add table for tracking transactions.
Masaya Tojo
2023-03-12
Add schema for use in kakeibo.
Masaya Tojo