From ecdcfff2460db708ae4b471140335ce47aaaf54b Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
Date: Fri, 15 Mar 2024 22:28:01 +0100
Subject: Landing page and fixed register problems

---
 dbinit.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'dbinit.sql')

diff --git a/dbinit.sql b/dbinit.sql
index 271eb2b..95cdf2f 100644
--- a/dbinit.sql
+++ b/dbinit.sql
@@ -1,2 +1,12 @@
 CREATE DATABASE arfnet2;
 
+CREATE TABLE `arfnet2`.`users` (
+    `id` INT NOT NULL AUTO_INCREMENT ,
+    `username` VARCHAR(31) NOT NULL ,
+    `password` VARCHAR(255) NOT NULL ,
+    `email` VARCHAR(127) NOT NULL ,
+    `verifycode` VARCHAR(31) NOT NULL ,
+    `type` ENUM('client','helpdesk','accountant','admin') NOT NULL ,
+    `regdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
+    PRIMARY KEY (`id`)
+);
-- 
cgit v1.2.3

