From c0a8a46352279e105b026b1e0344eba6b0cfb231 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Mon, 25 Dec 2023 12:55:49 +0100
Subject: Use table for forbidden user names.

---
 schema.sql | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 831be32..f10ab2c 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,6 +1,18 @@
 -- Blacklists --
 
-create table if not exists blacklist_mail ( mail text primary key ) without rowid;
+create table if not exists blacklist_mail ( mail text primary key collate nocase ) without rowid;
+create table if not exists blacklist_name ( name text primary key collate nocase ) without rowid;
+
+insert or ignore into blacklist_mail (mail) values
+	('%@example.com')
+;
+
+insert or ignore into blacklist_name (name) values
+	('None'),
+	('System'),
+	('Deleted'),
+	('null')
+;
 
 -- Titles --
 
-- 
cgit v1.2.3

