From e6b8e078ef046750661972ba6d23e103462493f8 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Thu, 7 Sep 2023 19:32:14 +0200
Subject: Add mail verification.

---
 schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 6439d5f..feb99a9 100644
--- a/schema.sql
+++ b/schema.sql
@@ -23,7 +23,8 @@ create table if not exists users (
 	user_id integer primary key,
 	name text unique collate nocase,
 	mail text unique collate nocase,
-	notify boolean default 0,
+	notify integer default 0,
+	is_verified boolean default 0,
 	is_banned boolean default 0,
 	ctime datetime default current_timestamp,
 	password text,
-- 
cgit v1.2.3

