From d73abfead2923dd1ccfca7f2982f375e9a9983c7 Mon Sep 17 00:00:00 2001
From: Jakub Czajka <jakub@ekhem.eu.org>
Date: Wed, 18 Dec 2024 16:34:10 +0100
Subject: [PATCH] [miniflux] Create database.

---
 databases/rss/miniflux_db_create.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 databases/rss/miniflux_db_create.sql

diff --git a/databases/rss/miniflux_db_create.sql b/databases/rss/miniflux_db_create.sql
new file mode 100644
index 0000000..633bd96
--- /dev/null
+++ b/databases/rss/miniflux_db_create.sql
@@ -0,0 +1,20 @@
+-- Copyright (c) 2024 Jakub Czajka <jakub@ekhem.eu.org>
+-- License: 0BSD.
+
+DO $$
+BEGIN
+    IF NOT EXISTS (SELECT * FROM pg_user WHERE usename = 'miniflux')
+    THEN
+        CREATE USER miniflux;
+    END IF;
+END$$;
+
+CREATE DATABASE rss_db
+    ENCODING 'UTF8'
+    LC_COLLATE='C'
+    LC_CTYPE='C'
+    TEMPLATE=template0
+    OWNER miniflux;
+
+-- See https://miniflux.app/docs/database.html.
+EXECUTE FORMAT('CREATE EXTENSION IF NOT EXISTS HSTORE')
-- 
2.39.5