--------------------------------------------------
-- 2.1.0 to 2.1.1 delta
-- based on apm_2_1_0-to-2_1_1.sql
-- Created 20090923, TNS
--
-- This script has not been executed for ALL
-- DBs that appear to be at 2.1.1.
--------------------------------------------------


CREATE TABLE IF NOT EXISTS `sys_sql_trace` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `script` varchar(200) collate latin1_general_ci NOT NULL,
  `path` varchar(500) collate latin1_general_ci NOT NULL,
  `sql` text collate latin1_general_ci NOT NULL,
  `type` varchar(20) collate latin1_general_ci NOT NULL,
  `info` text collate latin1_general_ci,
  `num_rows` int(11) default NULL,
  `affected_rows` int(11) default NULL,
  `insert_id` int(11) default NULL,
  `error` text collate latin1_general_ci,
  PRIMARY KEY  (`id`),
  KEY `path` (`path`),
  KEY `timestamp` (`timestamp`),
  KEY `script` (`script`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='SQL Trace';
