diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-28 00:40:41 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-28 00:40:41 +0900 |
| commit | a32412ed8826a036be7ebf76ecba8c9134301ecb (patch) | |
| tree | a580d7158411f197bcf39fe6ef03d783e47beccc | |
| parent | ae2d6e3dca949d493e6c07567dc5114042414e02 (diff) | |
Add photo schema.
| -rw-r--r-- | deploy/photo.sql | 7 | ||||
| -rw-r--r-- | revert/photo.sql | 7 | ||||
| -rw-r--r-- | sqitch.plan | 1 | ||||
| -rw-r--r-- | verify/photo.sql | 7 |
4 files changed, 22 insertions, 0 deletions
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 <masaya@tojo.tokyo> # 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 <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. 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; |