From 6819f27ab74011ff13bdd4f156a09a4372269d34 Mon Sep 17 00:00:00 2001
From: M <m@lfurio.us>
Date: Fri, 20 Nov 2015 21:34:29 -0500
Subject: + Defined schema for message table

---
 schema.sql | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

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`)
+);
-- 
cgit v1.2.3

