Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -r10024 -r10294 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10024) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10294) @@ -460,3 +460,37 @@ `IsPrimary` int(1) NOT NULL default '0', PRIMARY KEY (`SkinId`) ); + +CREATE TABLE ChangeLogs ( + ChangeLogId bigint(20) NOT NULL auto_increment, + PortalUserId int(11) NOT NULL default '0', + SessionLogId int(11) NOT NULL default '0', + `Action` tinyint(4) NOT NULL default '0', + OccuredOn int(11) NOT NULL default '0', + Prefix varchar(255) NOT NULL default '', + ItemId bigint(20) NOT NULL default '0', + Changes text NOT NULL, + MasterPrefix varchar(255) NOT NULL default '', + MasterId bigint(20) NOT NULL default '0', + PRIMARY KEY (ChangeLogId), + KEY PortalUserId (PortalUserId), + KEY SessionLogId (SessionLogId), + KEY `Action` (`Action`), + KEY OccuredOn (OccuredOn), + KEY Prefix (Prefix), + KEY MasterPrefix (MasterPrefix) +); + +CREATE TABLE SessionLogs ( + SessionLogId bigint(20) NOT NULL auto_increment, + PortalUserId int(11) NOT NULL default '0', + SessionId int(10) NOT NULL default '0', + `Status` tinyint(4) NOT NULL default '1', + SessionStart int(11) NOT NULL default '0', + SessionEnd int(11) default NULL, + IP varchar(15) NOT NULL default '', + AffectedItems int(11) NOT NULL default '0', + PRIMARY KEY (SessionLogId), + KEY SessionId (SessionId), + KEY `Status` (`Status`) +);