From b093b3affe3ac6878e2242bff310dc466687a825 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sat, 20 Oct 2018 21:43:46 -0400
Subject: issue:  Add open/close data

---
 srvs/mysql.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'srvs/mysql.sql')

diff --git a/srvs/mysql.sql b/srvs/mysql.sql
index 178fb57..9f3193b 100644
--- a/srvs/mysql.sql
+++ b/srvs/mysql.sql
@@ -181,9 +181,12 @@ CREATE TABLE issues (
     numb        int(32)             NOT NULL    DEFAULT 0,
     assignee    varchar(8)          NOT NULL    DEFAULT '',
     author      varchar(8)          NOT NULL    DEFAULT '',
+    closer      varchar(8)          NOT NULL    DEFAULT '',
     seen        int(1)              NOT NULL    DEFAULT 0,      /* has the assignee seen this yet? */
     description text                NOT NULL,
+    opened      varchar(64)         NOT NULL    DEFAULT '',
     authored    varchar(64)         NOT NULL    DEFAULT '',
+    closed      varchar(64)         NOT NULL    DEFAULT '',
     due         varchar(64)         NOT NULL    DEFAULT '',
     tags        text                NOT NULL,
 
-- 
cgit v1.2.3

