summaryrefslogtreecommitdiff
path: root/sqitch.plan
blob: 5010772d9fc325a32524c9ff31c886251b54fd1c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
%syntax-version=1.0.0
%project=photos
%uri=https://git.tojo.tokyo/photos-schema.git

schema 2023-08-27T13:52:33Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for all photos objects.
photos [schema] 2023-08-29T13:12:25Z Masaya Tojo <masaya@tojo.tokyo> # Create table to manage my photos.
update_timestamp [schema] 2023-08-29T15:03:35Z Masaya Tojo <masaya@tojo.tokyo> # Add function to update timestamp
photos_update_timestamp [schema photos update_timestamp] 2023-08-29T15:15:40Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to photos table
diaries [schema photos] 2023-08-29T15:30:42Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage diaries
diaries_update_timestamp [schema diaries update_timestamp] 2023-08-29T15:57:21Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to diaries table
transactions [schema photos] 2023-08-30T15:06:32Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transactions
transactions_update_timestamp [schema transactions update_timestamp] 2023-08-30T15:38:02Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to transactions table
@v1.0.0-alpha1 2023-09-11T16:42:56Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha1
photos [photos@v1.0.0-alpha1] 2023-11-11T06:26:38Z Masaya Tojo <masaya@tojo.tokyo> # Change taken_at column type to timestamptz
@v1.0.0-alpha2 2023-11-11T07:37:57Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha2