diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-12 00:59:34 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-12 23:38:11 +0900 |
| commit | f2d38e817eccab86a71ee04198a76c2ab3b07297 (patch) | |
| tree | 25917e8fffb01259e06fd0a43f727fe5b1da2742 | |
| parent | 8019bdc44c869025e8e4d8e78bc234651c4cb2c3 (diff) | |
Add schema for use in kakeibo.
| -rw-r--r-- | deploy/schema.sql | 7 | ||||
| -rw-r--r-- | revert/schema.sql | 7 | ||||
| -rw-r--r-- | sqitch.plan | 1 | ||||
| -rw-r--r-- | verify/schema.sql | 7 |
4 files changed, 22 insertions, 0 deletions
diff --git a/deploy/schema.sql b/deploy/schema.sql new file mode 100644 index 0000000..fdd6de2 --- /dev/null +++ b/deploy/schema.sql @@ -0,0 +1,7 @@ +-- Deploy kakeibo:schema to pg + +BEGIN; + +CREATE SCHEMA kakeibo; + +COMMIT; diff --git a/revert/schema.sql b/revert/schema.sql new file mode 100644 index 0000000..d51dc03 --- /dev/null +++ b/revert/schema.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:schema from pg + +BEGIN; + +DROP SCHEMA kakeibo; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index bcb2a72..7d85dd3 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -2,3 +2,4 @@ %project=kakeibo %uri=https://git.tojo.tokyo/kakeibo.git +schema 2023-03-11T15:56:41Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for use in kakeibo. diff --git a/verify/schema.sql b/verify/schema.sql new file mode 100644 index 0000000..661fd8a --- /dev/null +++ b/verify/schema.sql @@ -0,0 +1,7 @@ +-- Verify kakeibo:schema on pg + +BEGIN; + +SELECT pg_catalog.has_schema_privilege('kakeibo', 'usage'); + +ROLLBACK; |