From 37db03353a121d039a98af49aa034fb2d8f6e6ea Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Mar 2023 01:10:08 +0900 Subject: Add table for tracking photos. --- deploy/photo.photos.sql | 16 ++++++++++++++++ revert/photo.photos.sql | 7 +++++++ sqitch.plan | 1 + verify/photo.photos.sql | 15 +++++++++++++++ 4 files changed, 39 insertions(+) create mode 100644 deploy/photo.photos.sql create mode 100644 revert/photo.photos.sql create mode 100644 verify/photo.photos.sql 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 # 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. 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; -- cgit v1.2.3