+ Defined initial issue object in schema

1 files changed, 16 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index 0867a75..2863cbc 100644
--- a/schema.sql
+++ b/schema.sql
@@ -46,7 +46,8 @@ CREATE TABLE `object` (
         'user',
         'group',
         'pad',
-        'stage'
+        'stage',
+        'issue'
     )                             NOT NULL,
     PRIMARY KEY (`guid`)
 );
@@ -76,6 +77,7 @@ DROP TABLE IF EXISTS `pad`;
 CREATE TABLE `pad` (
     `guid`   varchar(10)          NOT NULL,
     `stage`  varchar(10)      DEFAULT NULL,
+    `nextIssueNumber` int(10)     NOT NULL DEFAULT 0,
     PRIMARY KEY (`guid`)
 );
 
@@ -86,3 +88,16 @@ CREATE TABLE `stage` (
     `stage`  varchar(10)      DEFAULT NULL,
     PRIMARY KEY (`guid`)
 );
+
+/* Issue objects - special attributes */
+/* Notice: 'closed' issues should be denoted by being a child of the pad directly, and not the child of a pad's stages */
+/* Notice: an issue is 'unread' if the assignee has yet to review the issue.  Self assigned issues, by definition, cannot be in unread state. */
+DROP TABLE IF EXISTS `issue`;
+CREATE TABLE `issue` (
+    `guid`     varchar(10)        NOT NULL,
+    `number`   int(10) unsigned   NOT NULL,
+    `assignee` varchar(10)    DEFAULT NULL,
+    `unread`   int(10) unsigned   NOT NULL DEFAULT 1,
+    `desc`     text           DEFAULT NULL,
+    PRIMARY KEY (`guid`)
+);