+ Defined schema for message table

1 files changed, 13 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index 58cbc45..fd37b18 100644
--- a/schema.sql
+++ b/schema.sql
@@ -50,7 +50,8 @@ CREATE TABLE `object` (
         'group',
         'pad',
         'stage',
-        'issue'
+        'issue',
+        'message'
     )                             NOT NULL,
     PRIMARY KEY (`guid`)
 );
@@ -121,3 +122,14 @@ CREATE TABLE `issue` (
     `desc`     text           DEFAULT NULL,
     PRIMARY KEY (`guid`)
 );
+
+/* Message objects - special attributes */
+/* Notice: These are discussion messages, comments on issues, and also private messages sent directly to users */
+DROP TABLE IF EXISTS `message`;
+CREATE TABLE `message` (
+    `guid`   varchar(10)          NOT NULL,
+    `author` varchar(10)          NOT NULL,
+    `unread` int(10) unsigned     NOT NULL DEFAULT 1,
+    `message` text            DEFAULT NULL,
+    PRIMARY KEY (`guid`)
+);