From c0a8a46352279e105b026b1e0344eba6b0cfb231 Mon Sep 17 00:00:00 2001 From: Tor Andersson 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