diff options
author | Malf Furious <m@lfurio.us> | 2018-10-20 21:43:46 -0400 |
---|---|---|
committer | Malf Furious <m@lfurio.us> | 2018-10-20 21:43:46 -0400 |
commit | b093b3affe3ac6878e2242bff310dc466687a825 (patch) | |
tree | 6d7606813f85a5e4cca705b20d6632b9ab29ae57 /srvs | |
parent | 9df5344050ec0a2b8bec03c7a89fff9d7d41ce2f (diff) | |
download | scrott-b093b3affe3ac6878e2242bff310dc466687a825.tar.gz scrott-b093b3affe3ac6878e2242bff310dc466687a825.zip |
issue: Add open/close data
Diffstat (limited to 'srvs')
-rw-r--r-- | srvs/mysql.sql | 3 |
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, |