summaryrefslogtreecommitdiffstats
path: root/srvs
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2018-10-20 21:43:46 -0400
committerMalf Furious <m@lfurio.us>2018-10-20 21:43:46 -0400
commitb093b3affe3ac6878e2242bff310dc466687a825 (patch)
tree6d7606813f85a5e4cca705b20d6632b9ab29ae57 /srvs
parent9df5344050ec0a2b8bec03c7a89fff9d7d41ce2f (diff)
downloadscrott-b093b3affe3ac6878e2242bff310dc466687a825.tar.gz
scrott-b093b3affe3ac6878e2242bff310dc466687a825.zip
issue: Add open/close data
Diffstat (limited to 'srvs')
-rw-r--r--srvs/mysql.sql3
1 files changed, 3 insertions, 0 deletions
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,