summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2016-02-07 15:11:25 -0500
committerMalf Furious <m@lfurio.us>2016-02-07 15:11:25 -0500
commitf7e765480572920ba396a747f0294c75ab813202 (patch)
treea76a71247be0044e393c487931471d752bafcda0 /schema.sql
parent89341dc13fd30bed744e052aa5f82deb4d4a5b93 (diff)
downloadscrott-f7e765480572920ba396a747f0294c75ab813202.tar.gz
scrott-f7e765480572920ba396a747f0294c75ab813202.zip
Add fields to Issue object
This adds attributes to an issue: due date (optional datetime) tags (space separated string of words to help categorize issues (again, optional))
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
index fcca540..e57f6e4 100644
--- a/schema.sql
+++ b/schema.sql
@@ -137,6 +137,8 @@ CREATE TABLE `issue` (
`assignee` varchar(10) DEFAULT NULL,
`unread` int(10) unsigned NOT NULL DEFAULT 1,
`desc` text DEFAULT NULL,
+ `due` datetime DEFAULT NULL,
+ `tags` text DEFAULT NULL,
PRIMARY KEY (`guid`)
);