diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-08-27 23:02:22 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-10-13 02:09:30 +0900 |
| commit | d1f764982dcde658d2b930fdbc8d5e4de84c4a70 (patch) | |
| tree | c26ad6e7b21e66aabfbaa9920125c16310a64dc7 | |
| parent | fb56e667f9f77c6f30f6cdd7c69c6d148f738741 (diff) | |
Add schema
| -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..6ad1074 --- /dev/null +++ b/deploy/schema.sql @@ -0,0 +1,7 @@ +-- Deploy photos:schema to pg + +BEGIN; + +CREATE SCHEMA photos; + +COMMIT; diff --git a/revert/schema.sql b/revert/schema.sql new file mode 100644 index 0000000..1f6b1c1 --- /dev/null +++ b/revert/schema.sql @@ -0,0 +1,7 @@ +-- Revert photos:schema from pg + +BEGIN; + +DROP SCHEMA photos; + +COMMIT; diff --git a/sqitch.plan b/sqitch.plan index a153a40..ec96975 100644 --- a/sqitch.plan +++ b/sqitch.plan @@ -2,3 +2,4 @@ %project=photos %uri=http://git.private.tojo.tokyo/ +schema 2023-08-27T13:52:33Z Masaya Tojo,,, <masaya@laptop> # Add schema for all photos objects. diff --git a/verify/schema.sql b/verify/schema.sql new file mode 100644 index 0000000..f732792 --- /dev/null +++ b/verify/schema.sql @@ -0,0 +1,7 @@ +-- Verify photos:schema on pg + +BEGIN; + +SELECT pg_catalog.has_schema_privilege('photos', 'usage'); + +ROLLBACK; |