Index: branches/5.3.x/core/install/install_schema.sql =================================================================== diff -u -N -r15574 -r15578 --- branches/5.3.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15574) +++ branches/5.3.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15578) @@ -422,6 +422,38 @@ KEY `timestamp` (SentOn) ); +CREATE TABLE SystemLog ( + LogId int(11) NOT NULL AUTO_INCREMENT, + LogUniqueId int(11) DEFAULT NULL, + LogLevel tinyint(4) NOT NULL DEFAULT '7', + LogType tinyint(4) NOT NULL DEFAULT '3', + LogCode int(11) DEFAULT NULL, + LogMessage longtext, + LogTimestamp int(11) DEFAULT NULL, + LogDate datetime DEFAULT NULL, + LogEventName varchar(100) NOT NULL DEFAULT '', + LogHostname varchar(255) NOT NULL DEFAULT '', + LogRequestSource tinyint(4) DEFAULT NULL, + LogRequestURI varchar(255) NOT NULL DEFAULT '', + LogRequestData longtext, + LogUserId int(11) DEFAULT NULL, + LogInterface tinyint(4) DEFAULT NULL, + IpAddress varchar(15) NOT NULL DEFAULT '', + LogSessionKey int(11) DEFAULT NULL, + LogSessionData longtext, + LogBacktrace longtext, + LogSourceFilename varchar(255) NOT NULL DEFAULT '', + LogSourceFileLine int(11) DEFAULT NULL, + LogProcessId bigint(20) unsigned DEFAULT NULL, + LogMemoryUsed bigint(20) unsigned NOT NULL, + LogUserData longtext NOT NULL, + LogNotificationStatus tinyint(4) NOT NULL DEFAULT '0', + PRIMARY KEY (LogId), + KEY LogLevel (LogLevel), + KEY LogType (LogType), + KEY LogNotificationStatus (LogNotificationStatus) +); + CREATE TABLE SystemCache ( VarName varchar(255) NOT NULL default '', Data longtext,