diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-02-26 15:31:20 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-01 02:28:55 +0900 |
| commit | acf7f9ecff4ddad620b85b07b4b4e6952946b385 (patch) | |
| tree | 4acfdb576ce86c06fc2424835f18e2a1c1b54778 | |
| parent | b87b77ed16add946e7bd4f8321af3d91f77f3329 (diff) | |
Add kakeibo schema.
| -rw-r--r-- | deploy/appschema.sql | 7 | ||||
| -rw-r--r-- | revert/appschema.sql | 7 | ||||
| -rw-r--r-- | sqitch.plan | 1 | ||||
| -rw-r--r-- | verify/appschema.sql | 7 |
4 files changed, 22 insertions, 0 deletions
diff --git a/deploy/appschema.sql b/deploy/appschema.sql new file mode 100644 index 0000000..9bbf75b --- /dev/null +++ b/deploy/appschema.sql @@ -0,0 +1,7 @@ +-- Deploy kakeibo:appschema to pg + +BEGIN; + +CREATE SCHEMA kakeibo; + +COMMIT; diff --git a/revert/appschema.sql b/revert/appschema.sql new file mode 100644 index 0000000..dd45ae6 --- /dev/null +++ b/revert/appschema.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:appschema from pg + +BEGIN; + +DROP SCHEMA kakeibo; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index 01ccc7a..e7792fe 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -2,3 +2,4 @@ %project=kakeibo %uri=http://http//git.private.tojo.tokyo/kakeibo.git +appschema 2023-02-26T06:27:59Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for all kakeibo objects. diff --git a/verify/appschema.sql b/verify/appschema.sql new file mode 100644 index 0000000..3fdad1a --- /dev/null +++ b/verify/appschema.sql @@ -0,0 +1,7 @@ +-- Verify kakeibo:appschema on pg + +BEGIN; + +SELECT pg_catalog.has_schema_privilege('kakeibo', 'usage'); + +ROLLBACK; |