diff options
| author | arf20 <aruizfernandez05@gmail.com> | 2024-03-16 02:51:06 +0100 |
|---|---|---|
| committer | arf20 <aruizfernandez05@gmail.com> | 2024-03-16 02:51:06 +0100 |
| commit | da57beb574fb9f756a7de036e8003f75ec47432c (patch) | |
| tree | b34bba686432f972816bb649d47431fcd2efa66e /dbinit.sql | |
| parent | ecdcfff2460db708ae4b471140335ce47aaaf54b (diff) | |
| download | arfnet2-cstims-da57beb574fb9f756a7de036e8003f75ec47432c.tar.gz arfnet2-cstims-da57beb574fb9f756a7de036e8003f75ec47432c.zip | |
Email verification
Diffstat (limited to 'dbinit.sql')
| -rw-r--r-- | dbinit.sql | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -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`) |