ext_tables.sql

#
# Table structure for table 'tx_mysqlreport_query_information'
#
CREATE TABLE tx_mysqlreport_query_information
(
	query_id               int(11)       unsigned DEFAULT '0',
	mode                   char(3)       DEFAULT ''           NOT NULL,
	ip                     varchar(45)   DEFAULT ''           NOT NULL,
	request                text,
	referer                text,
	unique_call_identifier varchar(24)   DEFAULT ''           NOT NULL,
	duration               decimal(11,8) DEFAULT '0.00000000' NOT NULL,
	query                  blob                               NOT NULL,
	query_type             varchar(20)   DEFAULT ''           NOT NULL,
	explain_query          text                               NOT NULL,
	using_index            tinyint(1)    DEFAULT '0'          NOT NULL,
	using_fulltable        tinyint(1)    DEFAULT '0'          NOT NULL,

	KEY                    uniqueCalls (unique_call_identifier,crdate,mode,duration)
);