From db73168c4eca48e363e27c7129f2e14dcfa0425f Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Mar 2023 00:01:31 +0900 Subject: Add common schema. --- deploy/common.sql | 7 +++++++ revert/common.sql | 7 +++++++ sqitch.plan | 1 + verify/common.sql | 7 +++++++ 4 files changed, 22 insertions(+) create mode 100644 deploy/common.sql create mode 100644 revert/common.sql create mode 100644 verify/common.sql diff --git a/deploy/common.sql b/deploy/common.sql new file mode 100644 index 0000000..7a8e581 --- /dev/null +++ b/deploy/common.sql @@ -0,0 +1,7 @@ +-- Deploy life-archive:common to pg + +BEGIN; + +CREATE SCHEMA common; + +COMMIT; diff --git a/revert/common.sql b/revert/common.sql new file mode 100644 index 0000000..d2673a6 --- /dev/null +++ b/revert/common.sql @@ -0,0 +1,7 @@ +-- Revert life-archive:common from pg + +BEGIN; + +DROP SCHEMA common; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index d29087f..bd62574 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -18,3 +18,4 @@ items [items@v1.0.0-alpha.1 articles] 2023-03-12T15:12:15Z Masaya Tojo # Add table to manage transaction type codes. articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo # Add update_timestamp trigger to articles table. transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo # Add foreign key constraint to transactions table referencing types table. +common 2023-03-27T15:01:06Z Masaya Tojo # Add common schema. diff --git a/verify/common.sql b/verify/common.sql new file mode 100644 index 0000000..6bfd462 --- /dev/null +++ b/verify/common.sql @@ -0,0 +1,7 @@ +-- Verify life-archive:common on pg + +BEGIN; + +SELECT pg_catalog.has_schema_privilege('common', 'usage'); + +ROLLBACK; -- cgit v1.2.3