diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-10 20:23:28 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-10 20:23:28 +0900 |
| commit | 53a2f222ded608c99d25f11bcf26af3c0324875b (patch) | |
| tree | 1262a925caf1c0b5a35a8822c96053b2e9d34209 /verify | |
| parent | a4ba55b9d14bf39348bf9272a620de3558458a3b (diff) | |
Add schema for diary objects.
Diffstat (limited to 'verify')
| -rw-r--r-- | verify/schema.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/verify/schema.sql b/verify/schema.sql new file mode 100644 index 0000000..ba8c5d8 --- /dev/null +++ b/verify/schema.sql @@ -0,0 +1,10 @@ +-- Verify diary:schema on pg + +BEGIN; + +DO $$ +BEGIN + ASSERT (SELECT has_schema_privilege('diary', 'usage')); +END $$; + +ROLLBACK; |