diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-28 00:01:31 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-28 00:01:31 +0900 |
commit | db73168c4eca48e363e27c7129f2e14dcfa0425f (patch) | |
tree | eb28eed787e8c5a4f7b99884b4dc4a6ff14e2cf9 | |
parent | 6b8ab6fe190e9d8f42242ff1f57be8c28e9ca066 (diff) |
Add common schema.
-rw-r--r-- | deploy/common.sql | 7 | ||||
-rw-r--r-- | revert/common.sql | 7 | ||||
-rw-r--r-- | sqitch.plan | 1 | ||||
-rw-r--r-- | verify/common.sql | 7 |
4 files changed, 22 insertions, 0 deletions
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 <masaya@t transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transaction type codes. articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to articles table. transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo <masaya@tojo.tokyo> # Add foreign key constraint to transactions table referencing types table. +common 2023-03-27T15:01:06Z Masaya Tojo <masaya@tojo.tokyo> # 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; |