Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -r1267 -r1349 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 1267) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 1349) @@ -19,7 +19,7 @@ ParentId int(11) NOT NULL default '0', Name varchar(255) NOT NULL default '', Description text NOT NULL, - CreatedOn double NOT NULL default '0', + CreatedOn int(11) NOT NULL default '0', EditorsPick tinyint(4) default NULL, Status tinyint(4) NOT NULL default '0', Pop tinyint(4) default NULL, @@ -34,7 +34,7 @@ HotItem int(11) NOT NULL default '2', NewItem int(11) NOT NULL default '2', PopItem int(11) NOT NULL default '2', - Modified double NOT NULL default '0', + Modified int(11) NOT NULL default '0', ModifiedById int(11) NOT NULL default '0', PRIMARY KEY (CategoryId), KEY ParentId (ParentId), @@ -50,7 +50,7 @@ CategoryId int(11) NOT NULL default '0', ItemResourceId int(11) NOT NULL default '0', PrimaryCat tinyint(4) NOT NULL default '0', - PRIMARY KEY (CategoryId,ItemResourceId), + KEY CategoryId (CategoryId), KEY ItemResourceId (ItemResourceId), KEY PrimaryCat (PrimaryCat) ) @@ -459,6 +459,7 @@ SessionKey varchar(50) NOT NULL default '', VariableName varchar(255) NOT NULL default '', VariableValue text NOT NULL, + PRIMARY KEY (`SessionKey`,`VariableName`), KEY SessionKey (SessionKey), KEY VariableName (VariableName) ) Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql =================================================================== diff -u -r1282 -r1349 --- trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql (.../inportal_upgrade_v1.0.11.sql) (revision 1282) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql (.../inportal_upgrade_v1.0.11.sql) (revision 1349) @@ -1,2 +1,6 @@ ALTER TABLE PortalUser DROP UNIQUE PwResetConfirm; -UPDATE Modules SET Version = '1.0.11' WHERE Name = 'In-Portal'; +ALTER TABLE Category CHANGE CreatedOn CreatedOn INT(11) DEFAULT '0' NOT NULL , CHANGE Modified Modified INT(11) DEFAULT '0' NOT NULL; +ALTER TABLE CategoryItems DROP PRIMARY KEY; +ALTER TABLE CategoryItems ADD INDEX (CategoryId); +ALTER TABLE SessionData ADD PRIMARY KEY (SessionKey, VariableName); +UPDATE Modules SET Version = '1.0.11' WHERE Name = 'In-Portal'; \ No newline at end of file Index: trunk/kernel/include/debugger.php =================================================================== diff -u -r1333 -r1349 --- trunk/kernel/include/debugger.php (.../debugger.php) (revision 1333) +++ trunk/kernel/include/debugger.php (.../debugger.php) (revision 1349) @@ -463,6 +463,8 @@ { if( dbg_ConstOn('DBG_ZEND_PRESENT') ) return; dbg_safeDefine('DBG_RAISE_ON_WARNINGS',0); + dbg_safeDefine('DBG_WINDOW_WIDTH', 500); + $this->memoryUsage['debugger_start']=memory_get_usage(); // show php session if any @@ -497,7 +499,7 @@ .debug_layer_table { border-collapse: collapse; - width: 480px; + width: px; } .debug_text, .debug_row_even TD, .debug_row_odd TD { @@ -524,7 +526,7 @@ .debug_layer_container { left: 2px; top: 1px; - width: 500px; + width: px; z-index: +1000; position: absolute; overflow: auto; @@ -539,7 +541,7 @@ .debug_layer { padding: 0px; - width: 480px; + width: px; } .debug_error {