diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-28 01:10:08 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-28 01:10:08 +0900 |
commit | 37db03353a121d039a98af49aa034fb2d8f6e6ea (patch) | |
tree | 2b92da1e57dec3297473e7bf1b2288fc53da71ec | |
parent | a32412ed8826a036be7ebf76ecba8c9134301ecb (diff) |
Add table for tracking photos.
-rw-r--r-- | deploy/photo.photos.sql | 16 | ||||
-rw-r--r-- | revert/photo.photos.sql | 7 | ||||
-rw-r--r-- | sqitch.plan | 1 | ||||
-rw-r--r-- | verify/photo.photos.sql | 15 |
4 files changed, 39 insertions, 0 deletions
diff --git a/deploy/photo.photos.sql b/deploy/photo.photos.sql new file mode 100644 index 0000000..6cb3cba --- /dev/null +++ b/deploy/photo.photos.sql @@ -0,0 +1,16 @@ +-- Deploy life-archive:photo.photos to pg +-- requires: photo + +BEGIN; + +CREATE TABLE photo.photos ( + id SERIAL PRIMARY KEY, + url TEXT NOT NULL, + taken_at timestamp NOT NULL, + place TEXT NOT NULL, + note TEXT CHECK (note <> ''), + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/revert/photo.photos.sql b/revert/photo.photos.sql new file mode 100644 index 0000000..f150626 --- /dev/null +++ b/revert/photo.photos.sql @@ -0,0 +1,7 @@ +-- Revert life-archive:photo.photos from pg + +BEGIN; + +DROP TABLE photo.photos; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index 76ab4a8..2ef8efd 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -26,3 +26,4 @@ items_update_timestamp [items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11: transactions_update_timestamp [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. diff --git a/verify/photo.photos.sql b/verify/photo.photos.sql new file mode 100644 index 0000000..c3e2c42 --- /dev/null +++ b/verify/photo.photos.sql @@ -0,0 +1,15 @@ +-- Verify life-archive:photo.photos on pg + +BEGIN; + +SELECT id, + url, + taken_at, + place, + note, + created_at, + updated_at + FROM photo.photos + WHERE FALSE; + +ROLLBACK; |