summaryrefslogtreecommitdiffstats
path: root/srvs
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2018-10-20 21:24:01 -0400
committerMalf Furious <m@lfurio.us>2018-10-20 21:24:01 -0400
commit9df5344050ec0a2b8bec03c7a89fff9d7d41ce2f (patch)
treed3c6de59a826e9a11514840cdf21402632cf86bd /srvs
parent055c62010b7d37760458ceea6dfe7363746bfca0 (diff)
downloadscrott-9df5344050ec0a2b8bec03c7a89fff9d7d41ce2f.tar.gz
scrott-9df5344050ec0a2b8bec03c7a89fff9d7d41ce2f.zip
issue: Add author and authored fields
Diffstat (limited to 'srvs')
-rw-r--r--srvs/mysql.sql2
1 files changed, 2 insertions, 0 deletions
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,