From da57beb574fb9f756a7de036e8003f75ec47432c Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
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

