From b093b3affe3ac6878e2242bff310dc466687a825 Mon Sep 17 00:00:00 2001 From: Malf Furious 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') 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