summaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-08-27 23:02:22 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-10-13 02:09:30 +0900
commitd1f764982dcde658d2b930fdbc8d5e4de84c4a70 (patch)
treec26ad6e7b21e66aabfbaa9920125c16310a64dc7 /verify
parentfb56e667f9f77c6f30f6cdd7c69c6d148f738741 (diff)
Add schema
Diffstat (limited to 'verify')
-rw-r--r--verify/schema.sql7
1 files changed, 7 insertions, 0 deletions
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;