summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorM <m@lfurio.us>2015-11-20 21:42:06 -0500
committerM <m@lfurio.us>2015-11-20 21:42:06 -0500
commit81a46c7cf94aae9b39fd2bf3232778ea261281ff (patch)
tree32bfb7bfeeee274bd94e7bb5734abd7647c55219 /schema.sql
parent6819f27ab74011ff13bdd4f156a09a4372269d34 (diff)
downloadscrott-81a46c7cf94aae9b39fd2bf3232778ea261281ff.tar.gz
scrott-81a46c7cf94aae9b39fd2bf3232778ea261281ff.zip
+ Declaired types for system log levels. they will be encapsulated in Message-type objects
Diffstat (limited to 'schema.sql')
-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,