From 9df5344050ec0a2b8bec03c7a89fff9d7d41ce2f Mon Sep 17 00:00:00 2001 From: Malf Furious Date: Sat, 20 Oct 2018 21:24:01 -0400 Subject: issue: Add author and authored fields --- srvs/mysql.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'srvs') diff --git a/srvs/mysql.sql b/srvs/mysql.sql index 13db8c7..178fb57 100644 --- a/srvs/mysql.sql +++ b/srvs/mysql.sql @@ -180,8 +180,10 @@ CREATE TABLE issues ( guid varchar(8) NOT NULL, numb int(32) NOT NULL DEFAULT 0, assignee varchar(8) NOT NULL DEFAULT '', + author varchar(8) NOT NULL DEFAULT '', seen int(1) NOT NULL DEFAULT 0, /* has the assignee seen this yet? */ description text NOT NULL, + authored varchar(64) NOT NULL DEFAULT '', due varchar(64) NOT NULL DEFAULT '', tags text NOT NULL, -- cgit v1.2.3