From da57beb574fb9f756a7de036e8003f75ec47432c Mon Sep 17 00:00:00 2001 From: arf20 Date: Sat, 16 Mar 2024 02:51:06 +0100 Subject: Email verification --- dbinit.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index 95cdf2f..5a989ab 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -6,6 +6,7 @@ CREATE TABLE `arfnet2`.`users` ( `password` VARCHAR(255) NOT NULL , `email` VARCHAR(127) NOT NULL , `verifycode` VARCHAR(31) NOT NULL , + `status` ENUM('verified','unverified') NOT NULL DEFAULT 'unverified' , `type` ENUM('client','helpdesk','accountant','admin') NOT NULL , `regdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`) -- cgit v1.2.3