From 6819f27ab74011ff13bdd4f156a09a4372269d34 Mon Sep 17 00:00:00 2001 From: M 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