summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2016-02-07 14:12:58 -0500
committerMalf Furious <m@lfurio.us>2016-02-07 14:12:58 -0500
commit89341dc13fd30bed744e052aa5f82deb4d4a5b93 (patch)
treea4bf0a8dee9e280cf4b7e7d2565559b6714816f9
parent72e37180b69db2c067b926b54c64e1989bef0be4 (diff)
downloadscrott-89341dc13fd30bed744e052aa5f82deb4d4a5b93.tar.gz
scrott-89341dc13fd30bed744e052aa5f82deb4d4a5b93.zip
Use only a single object type for log messages
Eliminate redunancy in the data model by using just one object type to denote 'log' instead of parent object specfic types (eg: log-user, log-group, log-pad, ....). This is a redundancy because the type of the parent can be quired simply by following the log entry's parent ptr and assessing its type value.
-rw-r--r--schema.sql6
1 files changed, 1 insertions, 5 deletions
diff --git a/schema.sql b/schema.sql
index 8902fbf..fcca540 100644
--- a/schema.sql
+++ b/schema.sql
@@ -60,11 +60,7 @@ CREATE TABLE `object` (
'stage',
'issue',
'message',
- 'log-user',
- 'log-group',
- 'log-admin',
- 'log-pad',
- 'log-issue'
+ 'log',
) NOT NULL,
PRIMARY KEY (`guid`)
);