From a7ef3f5a54cf45eaa5db4b200604a650929194dc Mon Sep 17 00:00:00 2001 From: arf20 Date: Thu, 21 Mar 2024 16:22:33 +0100 Subject: Add close comment to tickets --- dbinit.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index 017f60a..9ee8f0d 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -29,6 +29,7 @@ CREATE TABLE `arfnet2`.`orders` ( `billing` VARCHAR(255) NOT NULL , `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `status` ENUM('setting up','active','inactive') NOT NULL DEFAULT 'setting up' , + `duedate` TIMESTAMP NOT NULL DEFAULT 0 , `comments` TEXT NOT NULL , PRIMARY KEY (`id`) ); @@ -40,6 +41,7 @@ CREATE TABLE `arfnet2`.`tickets` ( `body` TEXT NOT NULL , `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `status` ENUM('open','closed') NOT NULL DEFAULT 'open' , + `closecomment` TEXT NOT NULL DEFAULT '', `asignee` INT NOT NULL , PRIMARY KEY (`id`) ); -- cgit v1.2.3