diff options
| author | Tor Andersson <tor@ccxvii.net> | 2023-09-07 19:32:14 +0200 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2023-09-13 20:06:36 +0200 |
| commit | e6b8e078ef046750661972ba6d23e103462493f8 (patch) | |
| tree | 5f2ce04dbca4c9b63f4359ab45f08035d0168e2a /schema.sql | |
| parent | cfdaea82e9bf0ad50d1bd5163b3a3ceb1ec7e515 (diff) | |
| download | server-e6b8e078ef046750661972ba6d23e103462493f8.tar.gz | |
Add mail verification.
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
@@ -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, |