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.

---
 deploy/schema.sql |  7 +++++++
 revert/schema.sql |  7 +++++++
 sqitch.plan       |  1 +
 verify/schema.sql | 10 ++++++++++
 4 files changed, 25 insertions(+)
 create mode 100644 deploy/schema.sql
 create mode 100644 revert/schema.sql
 create mode 100644 verify/schema.sql

diff --git a/deploy/schema.sql b/deploy/schema.sql
new file mode 100644
index 0000000..0074317
--- /dev/null
+++ b/deploy/schema.sql
@@ -0,0 +1,7 @@
+-- Deploy diary:schema to pg
+
+BEGIN;
+
+CREATE SCHEMA diary;
+
+COMMIT;
diff --git a/revert/schema.sql b/revert/schema.sql
new file mode 100644
index 0000000..6308dd1
--- /dev/null
+++ b/revert/schema.sql
@@ -0,0 +1,7 @@
+-- Revert diary:schema from pg
+
+BEGIN;
+
+DROP SCHEMA diary;
+
+COMMIT;
diff --git a/sqitch.plan b/sqitch.plan
index 059cc93..eaacef8 100644
--- a/sqitch.plan
+++ b/sqitch.plan
@@ -2,3 +2,4 @@
 %project=diary
 %uri=https://git.tojo.tokyo/diary-schema.git/about/
 
+schema 2024-03-10T11:00:19Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for diary objects.
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