Index: branches/RC/core/install/upgrades.sql =================================================================== diff -u -N -r10448 -r10494 --- branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10448) +++ branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10494) @@ -248,3 +248,47 @@ # ===== v 4.3.1 ===== INSERT INTO ConfigurationAdmin VALUES ('RememberLastAdminTemplate', 'la_Text_General', 'la_config_RememberLastAdminTemplate', 'checkbox', '', '', 10.13, 0, 0); INSERT INTO ConfigurationValues VALUES (DEFAULT, 'RememberLastAdminTemplate', '', 'In-Portal:Users', 'in-portal:configure_users'); + +CREATE TABLE StatisticsCapture ( + StatisticsId int(10) unsigned NOT NULL auto_increment, + TemplateName varchar(255) NOT NULL default '', + Hits int(10) unsigned NOT NULL default '0', + ScriptTimeMin decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + ScriptTimeAvg decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + ScriptTimeMax decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + SqlTimeMin decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + SqlTimeAvg decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + SqlTimeMax decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + SqlCountMin decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + SqlCountAvg decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + SqlCountMax decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + PRIMARY KEY (StatisticsId), + KEY TemplateName (TemplateName), + KEY Hits (Hits), + KEY ScriptTimeMin (ScriptTimeMin), + KEY ScriptTimeAvg (ScriptTimeAvg), + KEY ScriptTimeMax (ScriptTimeMax), + KEY SqlTimeMin (SqlTimeMin), + KEY SqlTimeAvg (SqlTimeAvg), + KEY SqlTimeMax (SqlTimeMax), + KEY SqlCountMin (SqlCountMin), + KEY SqlCountAvg (SqlCountAvg), + KEY SqlCountMax (SqlCountMax) +); + +CREATE TABLE SlowSqlCapture ( + CaptureId int(10) unsigned NOT NULL auto_increment, + TemplateNames text, + Hits int(10) unsigned NOT NULL default '0', + SqlQuery text, + TimeMin decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + TimeAvg decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + TimeMax decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', + QueryCrc int(11) NOT NULL default '0', + PRIMARY KEY (CaptureId), + KEY Hits (Hits), + KEY TimeMin (TimeMin), + KEY TimeAvg (TimeAvg), + KEY TimeMax (TimeMax), + KEY QueryCrc (QueryCrc) +); \ No newline at end of file