aboutsummaryrefslogtreecommitdiff
path: root/dbinit.sql
diff options
context:
space:
mode:
Diffstat (limited to 'dbinit.sql')
-rw-r--r--dbinit.sql1
1 files changed, 1 insertions, 0 deletions
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`)