From 0cb2a90f5422ca5c2f04ecf986a555c758afae61 Mon Sep 17 00:00:00 2001 From: arf20 Date: Mon, 18 Mar 2024 19:47:44 +0100 Subject: Client sees orders, order status --- dbinit.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index 7f7dec9..506729a 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -6,9 +6,9 @@ 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 , + `status` ENUM('verified','unverified') NOT NULL DEFAULT 'unverified' , PRIMARY KEY (`id`) ); @@ -28,6 +28,7 @@ CREATE TABLE `arfnet2`.`orders` ( `client` INT NOT NULL , `billing` VARCHAR(255) NOT NULL , `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , + `status` ENUM('active','inactive') NOT NULL , `comments` TEXT NOT NULL , PRIMARY KEY (`id`) ); -- cgit v1.2.3