diff options
| author | Malf Furious <m@lfurio.us> | 2018-10-22 00:17:58 -0400 |
|---|---|---|
| committer | Malf Furious <m@lfurio.us> | 2018-10-22 00:17:58 -0400 |
| commit | 176f65e60daa2a777aa03744c4df477cc812523d (patch) | |
| tree | 820633bafe627f3fc86a3ec4cc070ec7795a4a7b /srvs/mysql.sql | |
| parent | 055c62010b7d37760458ceea6dfe7363746bfca0 (diff) | |
| parent | 384f2649b714d310b385a59cc34d11fff1d85ef2 (diff) | |
| download | scrott-176f65e60daa2a777aa03744c4df477cc812523d.tar.gz scrott-176f65e60daa2a777aa03744c4df477cc812523d.zip | |
Merge branch 'feature/rework-issue' into dev
Diffstat (limited to 'srvs/mysql.sql')
| -rw-r--r-- | srvs/mysql.sql | 25 |
1 files changed, 21 insertions, 4 deletions
diff --git a/srvs/mysql.sql b/srvs/mysql.sql index 13db8c7..72167d4 100644 --- a/srvs/mysql.sql +++ b/srvs/mysql.sql @@ -70,6 +70,23 @@ CREATE TABLE views ( ); /* + * Scrott issues may have multiple assignees. This table is used to + * co-relate assignees and issues along with additional meta-data. + */ +DROP TABLE IF EXISTS assignees; +CREATE TABLE assignees ( + guid varchar(8) NOT NULL, /* guid of issue */ + assignee varchar(8) NOT NULL, /* user */ + assigner varchar(8) NOT NULL, /* user */ + assigned datetime NOT NULL, /* timestamp */ + dismisser varchar(8) NOT NULL DEFAULT '', /* user */ + dismissed varchar(64) NOT NULL DEFAULT '', /* timestamp */ + signedoff varchar(64) NOT NULL DEFAULT '', /* timestamp */ + + PRIMARY KEY (guid, assignee) +); + +/* * Base table for Scrott objects * * Explaination of permissions... @@ -179,10 +196,10 @@ DROP TABLE IF EXISTS issues; CREATE TABLE issues ( guid varchar(8) NOT NULL, numb int(32) NOT NULL DEFAULT 0, - assignee varchar(8) NOT NULL DEFAULT '', - seen int(1) NOT NULL DEFAULT 0, /* has the assignee seen this yet? */ - description text NOT NULL, - due varchar(64) NOT NULL DEFAULT '', + mesg varchar(8) NOT NULL DEFAULT '', + closer varchar(8) NOT NULL DEFAULT '', /* user */ + closed varchar(64) NOT NULL DEFAULT '', /* timestamp */ + due varchar(64) NOT NULL DEFAULT '', /* timestamp */ tags text NOT NULL, PRIMARY KEY (guid) |