Index: branches/RC/core/install/upgrades.sql =================================================================== diff -u -r10156 -r10294 --- branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10156) +++ branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10294) @@ -180,4 +180,39 @@ INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_ThumbnailImageWidth', 120, 'In-Portal:Users', 'in-portal:configure_users'); INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_ThumbnailImageHeight', 120, 'In-Portal:Users', 'in-portal:configure_users'); INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_FullImageWidth', 450, 'In-Portal:Users', 'in-portal:configure_users'); -INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_FullImageHeight', 450, 'In-Portal:Users', 'in-portal:configure_users'); \ No newline at end of file +INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_FullImageHeight', 450, 'In-Portal:Users', 'in-portal:configure_users'); + +# ===== v 4.3.0 ===== +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`) +); \ No newline at end of file