From a7ef3f5a54cf45eaa5db4b200604a650929194dc Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
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

