From a32412ed8826a036be7ebf76ecba8c9134301ecb Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Mar 2023 00:40:41 +0900 Subject: Add photo schema. --- deploy/photo.sql | 7 +++++++ revert/photo.sql | 7 +++++++ sqitch.plan | 1 + verify/photo.sql | 7 +++++++ 4 files changed, 22 insertions(+) create mode 100644 deploy/photo.sql create mode 100644 revert/photo.sql create mode 100644 verify/photo.sql diff --git a/deploy/photo.sql b/deploy/photo.sql new file mode 100644 index 0000000..02e215a --- /dev/null +++ b/deploy/photo.sql @@ -0,0 +1,7 @@ +-- Deploy life-archive:photo to pg + +BEGIN; + +CREATE SCHEMA photo; + +COMMIT; diff --git a/revert/photo.sql b/revert/photo.sql new file mode 100644 index 0000000..7260dda --- /dev/null +++ b/revert/photo.sql @@ -0,0 +1,7 @@ +-- Revert life-archive:photo from pg + +BEGIN; + +DROP SCHEMA photo; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index d87cb53..76ab4a8 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -25,3 +25,4 @@ articles_update_timestamp [articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T items_update_timestamp [items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo # Change kakeibo.update_timestamp to common.update_timestamp. 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. diff --git a/verify/photo.sql b/verify/photo.sql new file mode 100644 index 0000000..1dc6f03 --- /dev/null +++ b/verify/photo.sql @@ -0,0 +1,7 @@ +-- Verify life-archive:photo on pg + +BEGIN; + +SELECT pg_catalog.has_schema_privilege('photo', 'usage'); + +ROLLBACK; -- cgit v1.2.3