summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--schema.sql8
1 files changed, 7 insertions, 1 deletions
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,