From 81a46c7cf94aae9b39fd2bf3232778ea261281ff Mon Sep 17 00:00:00 2001 From: M Date: Fri, 20 Nov 2015 21:42:06 -0500 Subject: + Declaired types for system log levels. they will be encapsulated in Message-type objects --- schema.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/schema.sql b/schema.sql index fd37b18..5dd4a10 100644 --- a/schema.sql +++ b/schema.sql @@ -51,7 +51,12 @@ CREATE TABLE `object` ( 'pad', 'stage', 'issue', - 'message' + 'message', + 'log-user', + 'log-group', + 'log-admin', + 'log-pad', + 'log-issue' ) NOT NULL, PRIMARY KEY (`guid`) ); @@ -125,6 +130,7 @@ CREATE TABLE `issue` ( /* Message objects - special attributes */ /* Notice: These are discussion messages, comments on issues, and also private messages sent directly to users */ +/* Notice: System log enteries use this struct to store data as well */ DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `guid` varchar(10) NOT NULL, -- cgit v1.2.3