From 53a2f222ded608c99d25f11bcf26af3c0324875b Mon Sep 17 00:00:00 2001
From: Masaya Tojo <masaya@tojo.tokyo>
Date: Sun, 10 Mar 2024 20:23:28 +0900
Subject: Add schema for diary objects.

---
 verify/schema.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 verify/schema.sql

(limited to 'verify/schema.sql')

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;
-- 
cgit v1.2.3

