-- MySQL dump 10.11
--
-- Host: localhost    Database: bug27963
-- ------------------------------------------------------
-- Server version	5.0.42-debug

--disable_query_log

SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES UTF8;
SET @OLD_TIME_ZONE=@@TIME_ZONE;
SET TIME_ZONE='+00:00';
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;

--
-- Table structure for table `STATISTICS`
--

DROP TABLE IF EXISTS `STATISTICS`;
CREATE  TABLE `STATISTICS` (
  `TABLE_CATALOG` varchar(512) default NULL,
  `TABLE_SCHEMA` varchar(64) NOT NULL default '',
  `TABLE_NAME` varchar(64) NOT NULL default '',
  `NON_UNIQUE` bigint(1) NOT NULL default '0',
  `INDEX_SCHEMA` varchar(64) NOT NULL default '',
  `INDEX_NAME` varchar(64) NOT NULL default '',
  `SEQ_IN_INDEX` bigint(2) NOT NULL default '0',
  `COLUMN_NAME` varchar(64) NOT NULL default '',
  `COLLATION` varchar(1) default NULL,
  `CARDINALITY` bigint(21) default NULL,
  `SUB_PART` bigint(3) default NULL,
  `PACKED` varchar(10) default NULL,
  `NULLABLE` varchar(3) NOT NULL default '',
  `INDEX_TYPE` varchar(16) NOT NULL default '',
  `COMMENT` varchar(16) default NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Dumping data for table `STATISTICS`
--

LOCK TABLES `STATISTICS` WRITE;
ALTER TABLE `STATISTICS` DISABLE KEYS;
INSERT INTO `STATISTICS` VALUES (NULL,'Temp1','child',0,'Temp1','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'Temp1','child',1,'Temp1','FK_child_1',1,'parent_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'Temp1','parent',0,'Temp1','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'animal','animal',0,'animal','PRIMARY',1,'idanimal','A',4,NULL,NULL,'','BTREE',''),(NULL,'animal','specs',0,'animal','PRIMARY',1,'idspec','A',9,NULL,NULL,'','BTREE',''),(NULL,'bug10722','t1',0,'bug10722','PRIMARY',1,'a','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug10722','t1',0,'bug10722','PRIMARY',2,'b','A',3,NULL,NULL,'','BTREE',''),(NULL,'bug10722','t2',0,'bug10722','PRIMARY',1,'b','A',3,NULL,NULL,'','BTREE',''),(NULL,'bug25727','t1',0,'bug25727','id',1,'id','A',NULL,NULL,NULL,'YES','BTREE',''),(NULL,'bug25998','t1',0,'bug25998','PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',0,'bug26716','PRIMARY',1,'threadid','A',16870,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','ctime',1,'ctime','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','firstpost',1,'firstpost','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','viewcount',1,'forumid','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','viewcount',2,'viewcount','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid_ctime',1,'forumid','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid_ctime',2,'ctime','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','mtime',1,'mtime','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid_mtime',1,'forumid','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid_mtime',2,'mtime','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','siteid_ctime',1,'siteid','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','siteid_ctime',2,'ctime','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid',1,'forumid','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid',2,'deleted','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','forumid',3,'isrefine','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26716','thread',1,'bug26716','firstposterid',1,'firstposterid','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'bug26870','test',0,'bug26870','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'bug27118','category',0,'bug27118','PRIMARY',1,'categoryID','A',4,NULL,NULL,'','BTREE',''),(NULL,'bug27118','forum',0,'bug27118','PRIMARY',1,'forumID','A',5,NULL,NULL,'','BTREE',''),(NULL,'bug27118','posts',0,'bug27118','PRIMARY',1,'postID','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27118','profile',0,'bug27118','PRIMARY',1,'profileID','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27118','topics',0,'bug27118','PRIMARY',1,'topicID','A',1,NULL,NULL,'','BTREE',''),(NULL,'bug27118','user',0,'bug27118','PRIMARY',1,'userID','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27379','element',0,'bug27379','PRIMARY',1,'element_id','A',5,NULL,NULL,'','BTREE',''),(NULL,'bug27379','element',1,'bug27379','new_index',1,'element_type_id','A',5,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',0,'bug27598','PRIMARY',1,'id','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',0,'bug27598','ListEmail',1,'email','A',9,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',0,'bug27598','ListEmail',2,'list_id','A',9,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',0,'bug27598','ListEmail',3,'status','A',9,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',0,'bug27598','ListEmail',4,'remove_date','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListFirstLast',1,'list_id','A',11,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListFirstLast',2,'first_name','A',123027,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListFirstLast',3,'last_name','A',123027,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListEmailStatus',1,'list_id','A',5,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListEmailStatus',2,'status','A',5,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','RemoveStatus',1,'remove_date','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','RemoveStatus',2,'status','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListLastname',1,'list_id','A',7,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListLastname',2,'last_name','A',123027,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListFirstname',1,'list_id','A',7,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListFirstname',2,'first_name','A',123027,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','SourceID',1,'source','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','SourceID',2,'list_id','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListIds',1,'list_id','A',3,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','ListIds',2,'id','A',123027,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','EmailListStatus',1,'list_id','A',5,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','EmailListStatus',2,'email','A',63,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_bl',1,'bug27598','EmailListStatus',3,'status','A',179,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',0,'bug27598','PRIMARY',1,'id','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',0,'bug27598','ListEmail',1,'email','A',19,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',0,'bug27598','ListEmail',2,'list_id','A',19,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',0,'bug27598','ListEmail',3,'status','A',201,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',0,'bug27598','ListEmail',4,'remove_date','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListFirstLast',1,'list_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListFirstLast',2,'first_name','A',9871,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListFirstLast',3,'last_name','A',9871,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListEmailStatus',1,'list_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListEmailStatus',2,'status','A',19,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','RemoveStatus',1,'remove_date','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','RemoveStatus',2,'status','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListLastname',1,'list_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListLastname',2,'last_name','A',9871,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListFirstname',1,'list_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListFirstname',2,'first_name','A',9871,NULL,NULL,'YES','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','SourceID',1,'source','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','SourceID',2,'list_id','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListIds',1,'list_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','ListIds',2,'id','A',9871,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','EmailListStatus',1,'list_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','EmailListStatus',2,'email','A',12,NULL,NULL,'','BTREE',''),(NULL,'bug27598','emails_search4more_queue',1,'bug27598','EmailListStatus',3,'status','A',55,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',0,'bug27604','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',0,'bug27604','ListEmail',1,'email','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',0,'bug27604','ListEmail',2,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',0,'bug27604','ListEmail',3,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',0,'bug27604','ListEmail',4,'remove_date','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListFirstLast',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListFirstLast',2,'first_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListFirstLast',3,'last_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListEmailStatus',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListEmailStatus',2,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','RemoveStatus',1,'remove_date','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','RemoveStatus',2,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListLastname',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListLastname',2,'last_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListFirstname',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListFirstname',2,'first_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','SourceID',1,'source','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','SourceID',2,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListIds',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','ListIds',2,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','EmailListStatus',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','EmailListStatus',2,'email','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t1',1,'bug27604','EmailListStatus',3,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',0,'bug27604','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',0,'bug27604','ListEmail',1,'email','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',0,'bug27604','ListEmail',2,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',0,'bug27604','ListEmail',3,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',0,'bug27604','ListEmail',4,'remove_date','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListFirstLast',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListFirstLast',2,'first_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListFirstLast',3,'last_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListEmailStatus',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListEmailStatus',2,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','RemoveStatus',1,'remove_date','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','RemoveStatus',2,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListLastname',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListLastname',2,'last_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListFirstname',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListFirstname',2,'first_name','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','SourceID',1,'source','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','SourceID',2,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListIds',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','ListIds',2,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','EmailListStatus',1,'list_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','EmailListStatus',2,'email','A',0,NULL,NULL,'','BTREE',''),(NULL,'bug27604','t2',1,'bug27604','EmailListStatus',3,'status','A',0,NULL,NULL,'','BTREE',''),(NULL,'issue15134','ticks_charthistory_1i',0,'issue15134','PRIMARY',1,'ISIN','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'issue15134','ticks_charthistory_1i',0,'issue15134','PRIMARY',2,'MARKET','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'issue15134','ticks_charthistory_1i',0,'issue15134','PRIMARY',3,'minute_timestamp','A',0,NULL,NULL,'','BTREE',''),(NULL,'issue15407','article_category',0,'issue15407','PRIMARY',1,'site_cd','A',1,NULL,NULL,'','BTREE',''),(NULL,'issue15407','article_category',0,'issue15407','PRIMARY',2,'category_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'issue15407','article_category',1,'issue15407','order_number',1,'order_number','A',1,NULL,NULL,'','BTREE',''),(NULL,'issue15407_2','article_category',0,'issue15407_2','PRIMARY',1,'site_cd','A',1,NULL,NULL,'','BTREE',''),(NULL,'issue15407_2','article_category',0,'issue15407_2','PRIMARY',2,'category_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'issue15407_2','article_category',1,'issue15407_2','order_number',1,'order_number','A',1,NULL,NULL,'','BTREE',''),(NULL,'mysql','columns_priv',0,'mysql','PRIMARY',1,'Host','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','columns_priv',0,'mysql','PRIMARY',2,'Db','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','columns_priv',0,'mysql','PRIMARY',3,'User','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','columns_priv',0,'mysql','PRIMARY',4,'Table_name','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','columns_priv',0,'mysql','PRIMARY',5,'Column_name','A',19,NULL,NULL,'','BTREE',''),(NULL,'mysql','db',0,'mysql','PRIMARY',1,'Host','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','db',0,'mysql','PRIMARY',2,'Db','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','db',0,'mysql','PRIMARY',3,'User','A',4,NULL,NULL,'','BTREE',''),(NULL,'mysql','db',1,'mysql','User',1,'User','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','func',0,'mysql','PRIMARY',1,'name','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_category',0,'mysql','PRIMARY',1,'help_category_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_category',0,'mysql','name',1,'name','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_keyword',0,'mysql','PRIMARY',1,'help_keyword_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_keyword',0,'mysql','name',1,'name','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_relation',0,'mysql','PRIMARY',1,'help_keyword_id','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_relation',0,'mysql','PRIMARY',2,'help_topic_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_topic',0,'mysql','PRIMARY',1,'help_topic_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','help_topic',0,'mysql','name',1,'name','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','host',0,'mysql','PRIMARY',1,'Host','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','host',0,'mysql','PRIMARY',2,'Db','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','proc',0,'mysql','PRIMARY',1,'db','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','proc',0,'mysql','PRIMARY',2,'name','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','proc',0,'mysql','PRIMARY',3,'type','A',13,NULL,NULL,'','BTREE',''),(NULL,'mysql','procs_priv',0,'mysql','PRIMARY',1,'Host','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','procs_priv',0,'mysql','PRIMARY',2,'Db','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','procs_priv',0,'mysql','PRIMARY',3,'User','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','procs_priv',0,'mysql','PRIMARY',4,'Routine_name','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','procs_priv',0,'mysql','PRIMARY',5,'Routine_type','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','procs_priv',1,'mysql','Grantor',1,'Grantor','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','tables_priv',0,'mysql','PRIMARY',1,'Host','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','tables_priv',0,'mysql','PRIMARY',2,'Db','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','tables_priv',0,'mysql','PRIMARY',3,'User','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','tables_priv',0,'mysql','PRIMARY',4,'Table_name','A',15,NULL,NULL,'','BTREE',''),(NULL,'mysql','tables_priv',1,'mysql','Grantor',1,'Grantor','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone',0,'mysql','PRIMARY',1,'Time_zone_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone_leap_second',0,'mysql','PRIMARY',1,'Transition_time','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone_name',0,'mysql','PRIMARY',1,'Name','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone_transition',0,'mysql','PRIMARY',1,'Time_zone_id','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone_transition',0,'mysql','PRIMARY',2,'Transition_time','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone_transition_type',0,'mysql','PRIMARY',1,'Time_zone_id','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','time_zone_transition_type',0,'mysql','PRIMARY',2,'Transition_type_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'mysql','user',0,'mysql','PRIMARY',1,'Host','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'mysql','user',0,'mysql','PRIMARY',2,'User','A',10,NULL,NULL,'','BTREE',''),(NULL,'system','db_database',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','db_database_user',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','db_database_user',1,'system','db_user_id',1,'db_user_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','db_database_user',1,'system','db_database_id',1,'db_database_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','db_user',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','db_user',0,'system','db_username',1,'db_username','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_admin_user',0,'system','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_admin_user',1,'system','mail_domain_id',1,'mail_domain_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_admin_user',1,'system','system_user_id',1,'system_user_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_alias',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_alias',1,'system','mail_domain_id',1,'mail_domain_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_alias',1,'system','system_user_id',1,'system_user_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_alias_domain',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_alias_domain',0,'system','alias_name',1,'alias_name','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_alias_domain',1,'system','mail_domain_id',1,'mail_domain_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','mail_box',0,'system','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_box',1,'system','mail_domain_id',1,'mail_domain_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_box',1,'system','system_user_id',1,'system_user_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_domain',0,'system','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_domain',0,'system','domain_name',1,'domain_name','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','mail_domain',1,'system','system_group_id',1,'system_group_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','request',0,'system','PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','request',1,'system','request_type_id',1,'request_type_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','request',1,'system','system_user_id',1,'system_user_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','request_attr',0,'system','PRIMARY',1,'request_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_attr',0,'system','PRIMARY',2,'request_attr_type_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_attr_type',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_attr_type',1,'system','request_type_id',1,'request_type_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_comment',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_comment',1,'system','system_user_id',1,'system_user_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_comment',1,'system','request_id',1,'request_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','request_type',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','system_group',0,'system','PRIMARY',1,'id','A',5,NULL,NULL,'','BTREE',''),(NULL,'system','system_group',0,'system','sys_gid',1,'sys_gid','A',5,NULL,NULL,'','BTREE',''),(NULL,'system','system_group',0,'system','sys_groupname',1,'sys_groupname','A',5,NULL,NULL,'','BTREE',''),(NULL,'system','system_group_membership',0,'system','PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','system_group_membership',1,'system','system_group_id',1,'system_group_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','system_group_membership',1,'system','system_user_id',1,'system_user_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','system_user',0,'system','PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','system_user',0,'system','sys_uid',1,'sys_uid','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','system_user',0,'system','sys_username',1,'sys_username','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','system_user',1,'system','system_group_id',1,'system_group_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'system','web_site',0,'system','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','web_site',0,'system','site_name',1,'site_name','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','web_site',1,'system','system_group_id',1,'system_group_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'system','web_site_alias',0,'system','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','web_site_alias',0,'system','site_alias_name',1,'site_alias_name','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','web_site_alias',1,'system','web_site_id',1,'web_site_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','web_site_user',0,'system','PRIMARY',1,'web_site_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'system','web_site_user',0,'system','PRIMARY',2,'system_user_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','City',0,'test','PRIMARY',1,'CountryCode','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'test','City',0,'test','PRIMARY',2,'District','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'test','City',0,'test','PRIMARY',3,'Name','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','CityList',1,'test','CountryCode',1,'CountryCode','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'test','Country-List',0,'test','PRIMARY',1,'Code','A',4,NULL,NULL,'','BTREE',''),(NULL,'test','Howtos_Original',0,'test','PRIMARY',1,'Record ID','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','RT_PORTFOLIO_DETAILS',0,'test','PRIMARY',1,'portfolioDetailsId','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','a',0,'test','PRIMARY',1,'a','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','articles',0,'test','PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE',''),(NULL,'test','bug24833_1',0,'test','PRIMARY',1,'id','A',5,NULL,NULL,'','BTREE',''),(NULL,'test','bug24833_2',0,'test','PRIMARY',1,'id','A',5,NULL,NULL,'','BTREE',''),(NULL,'test','bug27120',0,'test','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','child',1,'test','par_ind',1,'parent_id','A',0,NULL,NULL,'YES','BTREE',''),(NULL,'test','mtTable',0,'test','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','mtTable_record',0,'test','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','mtTable_record',0,'test','id',1,'id','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'test','mtTable_record',0,'test','id',2,'id_mtTable','A',NULL,NULL,NULL,'YES','BTREE',''),(NULL,'test','order_table_backup',0,'test','PRIMARY',1,'o_w_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','order_table_backup',0,'test','PRIMARY',2,'o_d_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','order_table_backup',0,'test','PRIMARY',3,'o_id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','parent',0,'test','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','puerto',0,'test','PRIMARY',1,'auto_n','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','t3',0,'test','PRIMARY',1,'id','A',2,NULL,NULL,'','BTREE',''),(NULL,'test','t_course',0,'test','PRIMARY',1,'course_id','A',2,NULL,NULL,'','BTREE',''),(NULL,'test','t_course_sem',0,'test','PRIMARY',1,'course_sem_id','A',5,NULL,NULL,'','BTREE',''),(NULL,'test','t_course_sem',1,'test','course_id',1,'course_id','A',5,NULL,NULL,'YES','BTREE',''),(NULL,'test','t_course_sem',1,'test','sem_id',1,'sem_id','A',5,NULL,NULL,'YES','BTREE',''),(NULL,'test','t_innodb',0,'test','PRIMARY',1,'id','A',0,NULL,NULL,'','BTREE',''),(NULL,'test','t_sem',0,'test','PRIMARY',1,'sem_id','A',8,NULL,NULL,'','BTREE',''),(NULL,'test','temp',0,'test','PRIMARY',1,'a','A',3,NULL,NULL,'','BTREE',''),(NULL,'test','test1',0,'test','PRIMARY',1,'memberID','A',2,NULL,NULL,'','BTREE',''),(NULL,'test','test2',0,'test','PRIMARY',1,'countryID','A',2,NULL,NULL,'','BTREE',''),(NULL,'test','test3',0,'test','PRIMARY',1,'logID','A',4,NULL,NULL,'','BTREE',''),(NULL,'test','testbug25611_1_1',0,'test','PRIMARY',1,'ID','A',9,NULL,NULL,'','BTREE',''),(NULL,'test','ud',0,'test','PRIMARY',1,'Id','A',4,NULL,NULL,'','BTREE',''),(NULL,'test','ud',0,'test','updatepacket_2',1,'Updatepacket','A',NULL,NULL,NULL,'YES','BTREE',''),(NULL,'test','ud',0,'test','updatepacket_2',2,'Server','A',NULL,NULL,NULL,'YES','BTREE',''),(NULL,'test','ud',1,'test','updatepacket',1,'Updatepacket','A',NULL,NULL,NULL,'YES','BTREE',''),(NULL,'test','users',0,'test','PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE',''),(NULL,'test','webcams',0,'test','PRIMARY',1,'id','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','webcams',0,'test','owner_id',1,'owner_id','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','webcams',1,'test','online',1,'online','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','webcams',1,'test','combo4',1,'active','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','webcams',1,'test','combo4',2,'online','A',1,NULL,NULL,'','BTREE',''),(NULL,'test','webcams',1,'test','combo4',3,'last_online','A',1,NULL,NULL,'','BTREE',''),(NULL,'testcase','media',0,'testcase','PRIMARY',1,'id','A',3,NULL,NULL,'','BTREE',''),(NULL,'testcase','relation',1,'testcase','child_type',1,'child_type','A',21,NULL,NULL,'','BTREE',''),(NULL,'testcase','relation',1,'testcase','child_id',1,'child_id','A',1095,NULL,NULL,'','BTREE',''),(NULL,'testcase','relation',1,'testcase','test',1,'parent_id','A',10,NULL,NULL,'','BTREE',''),(NULL,'testcase','relation',1,'testcase','test',2,'parent_type','A',16,NULL,NULL,'','BTREE',''),(NULL,'world','City',0,'world','PRIMARY',1,'ID','A',4079,NULL,NULL,'','BTREE',''),(NULL,'world','CityList',1,'world','CountryCode',1,'CountryCode','A',226,NULL,NULL,'','BTREE',''),(NULL,'world','Country',0,'world','PRIMARY',1,'Code','A',239,NULL,NULL,'','BTREE',''),(NULL,'world','CountryLanguage',0,'world','PRIMARY',1,'CountryCode','A',NULL,NULL,NULL,'','BTREE',''),(NULL,'world','CountryLanguage',0,'world','PRIMARY',2,'Language','A',984,NULL,NULL,'','BTREE',''),(NULL,'world','CountryList',0,'world','PRIMARY',1,'Code','A',239,NULL,NULL,'','BTREE','');
ALTER TABLE `STATISTICS` ENABLE KEYS;
UNLOCK TABLES;

--
-- Table structure for table `TABLES`
--

DROP TABLE IF EXISTS `TABLES`;
CREATE TABLE `TABLES` (
  `TABLE_CATALOG` varchar(512) default NULL,
  `TABLE_SCHEMA` varchar(64) NOT NULL default '',
  `TABLE_NAME` varchar(64) NOT NULL default '',
  `TABLE_TYPE` varchar(64) NOT NULL default '',
  `ENGINE` varchar(64) default NULL,
  `VERSION` bigint(21) default NULL,
  `ROW_FORMAT` varchar(10) default NULL,
  `TABLE_ROWS` bigint(21) default NULL,
  `AVG_ROW_LENGTH` bigint(21) default NULL,
  `DATA_LENGTH` bigint(21) default NULL,
  `MAX_DATA_LENGTH` bigint(21) default NULL,
  `INDEX_LENGTH` bigint(21) default NULL,
  `DATA_FREE` bigint(21) default NULL,
  `AUTO_INCREMENT` bigint(21) default NULL,
  `CREATE_TIME` datetime default NULL,
  `UPDATE_TIME` datetime default NULL,
  `CHECK_TIME` datetime default NULL,
  `TABLE_COLLATION` varchar(64) default NULL,
  `CHECKSUM` bigint(21) default NULL,
  `CREATE_OPTIONS` varchar(255) default NULL,
  `TABLE_COMMENT` varchar(80) NOT NULL default ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TABLES`
--

LOCK TABLES `TABLES` WRITE;
ALTER TABLE `TABLES` DISABLE KEYS;
INSERT INTO `TABLES` VALUES (NULL,'information_schema','CHARACTER_SETS','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,576,0,16661376,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=29127',''),(NULL,'information_schema','COLLATIONS','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,423,0,16737264,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=39662',''),(NULL,'information_schema','COLLATION_CHARACTER_SET_APPLICABILITY','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,387,0,16733880,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=43351',''),(NULL,'information_schema','COLUMNS','SYSTEM VIEW','MyISAM',0,'Dynamic',NULL,0,0,281474976710655,1024,0,NULL,'2007-04-20 23:29:55','2007-04-20 23:29:55',NULL,'utf8_general_ci',NULL,'max_rows=8715',''),(NULL,'information_schema','COLUMN_PRIVILEGES','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,2565,0,16757145,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=6540',''),(NULL,'information_schema','KEY_COLUMN_USAGE','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,4637,0,16762755,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=3618',''),(NULL,'information_schema','ROUTINES','SYSTEM VIEW','MyISAM',0,'Dynamic',NULL,0,0,281474976710655,1024,0,NULL,'2007-04-20 23:29:55','2007-04-20 23:29:55',NULL,'utf8_general_ci',NULL,'max_rows=9172',''),(NULL,'information_schema','SCHEMATA','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,3656,0,16755448,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=4588',''),(NULL,'information_schema','SCHEMA_PRIVILEGES','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,2179,0,16767405,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=7699',''),(NULL,'information_schema','STATISTICS','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,2679,0,16770540,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=6262',''),(NULL,'information_schema','TABLES','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,3641,0,16763164,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=4607',''),(NULL,'information_schema','TABLE_CONSTRAINTS','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,2504,0,16749256,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=6700',''),(NULL,'information_schema','TABLE_PRIVILEGES','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,2372,0,16748692,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=7073',''),(NULL,'information_schema','TRIGGERS','SYSTEM VIEW','MyISAM',0,'Dynamic',NULL,0,0,281474976710655,1024,0,NULL,'2007-04-20 23:29:55','2007-04-20 23:29:55',NULL,'utf8_general_ci',NULL,'max_rows=7652',''),(NULL,'information_schema','USER_PRIVILEGES','SYSTEM VIEW','MEMORY',0,'Fixed',NULL,1986,0,16759854,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'max_rows=8447',''),(NULL,'information_schema','VIEWS','SYSTEM VIEW','MyISAM',0,'Dynamic',NULL,0,0,281474976710655,1024,0,NULL,'2007-04-20 23:29:55','2007-04-20 23:29:55',NULL,'utf8_general_ci',NULL,'max_rows=15073',''),(NULL,'Temp1','child','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,16384,0,1,'2007-04-09 14:37:58',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB; (`parent_id`) REFER `temp1/parent`(`id`)'),(NULL,'Temp1','parent','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-04-09 14:26:47',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'Temp1','t1','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-04-09 14:23:32',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'animal','animal','BASE TABLE','MyISAM',10,'Dynamic',4,21,84,281474976710655,2048,0,5,'2007-02-13 13:59:58','2007-02-13 14:00:04',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'animal','animalcolor','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'animal','animalweight','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'animal','specs','BASE TABLE','MyISAM',10,'Dynamic',9,20,188,281474976710655,2048,0,18,'2007-02-13 13:59:58','2007-02-13 14:00:04',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'bug10722','t1','BASE TABLE','MyISAM',10,'Fixed',3,11,33,3096224743817215,2048,0,NULL,'2007-02-09 11:29:07','2007-02-09 11:29:45',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug10722','t2','BASE TABLE','MyISAM',10,'Fixed',3,9,27,2533274790395903,2048,0,NULL,'2007-02-09 11:29:07','2007-02-09 11:29:45',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug23775','bin','BASE TABLE','MyISAM',10,'Dynamic',0,0,0,281474976710655,1024,0,NULL,'2007-01-26 21:17:26','2007-01-26 21:17:26',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug25410','coll','BASE TABLE','MyISAM',10,'Fixed',9,16,144,4503599627370495,1024,0,NULL,'2007-01-10 10:11:23','2007-01-11 01:21:41',NULL,'latin1_danish_ci',NULL,'',''),(NULL,'bug25727','t1','BASE TABLE','MyISAM',10,'Fixed',4,7,28,1970324836974591,2048,0,NULL,'2007-01-31 14:59:24','2007-01-31 14:59:24',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug25830','OOO','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,NULL,'2007-01-30 13:31:10','2007-01-30 13:31:10',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug25998','t1','BASE TABLE','MyISAM',10,'Fixed',2,7,14,1970324836974591,2048,0,3,'2007-02-05 21:24:58','2007-02-05 21:25:53',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug25998','t2','BASE TABLE','MyISAM',10,'Fixed',2,7,14,1970324836974591,1024,0,NULL,'2007-02-05 21:29:28','2007-02-05 21:32:35',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug26280','documents','BASE TABLE','MyISAM',10,'Dynamic',3,20,60,281474976710655,1024,0,NULL,'2007-02-12 14:34:16','2007-02-12 14:34:16',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug26716','thread','BASE TABLE','MyISAM',10,'Fixed',16870,51,860370,14355223812243455,1928192,0,439736,'2007-03-06 12:52:32','2007-03-06 12:53:01',NULL,'utf8_general_ci',NULL,'delay_key_write=1',''),(NULL,'bug26870','test','BASE TABLE','MyISAM',10,'Dynamic',1,1846376,1846376,281474976710655,2048,0,NULL,'2007-03-06 22:12:31','2007-03-06 22:30:17',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug27118','category','BASE TABLE','MyISAM',10,'Dynamic',4,47,188,281474976710655,2048,0,5,'2007-03-14 13:09:00','2007-03-14 13:09:35',NULL,'latin1_general_ci',NULL,'',''),(NULL,'bug27118','forum','BASE TABLE','MyISAM',10,'Dynamic',5,60,300,281474976710655,2048,0,6,'2007-03-14 13:09:11','2007-03-14 13:09:35',NULL,'latin1_general_ci',NULL,'',''),(NULL,'bug27118','posts','BASE TABLE','MyISAM',10,'Dynamic',2,36,72,281474976710655,2048,0,3,'2007-03-14 13:09:22','2007-03-14 13:09:35',NULL,'latin1_general_ci',NULL,'',''),(NULL,'bug27118','profile','BASE TABLE','MyISAM',10,'Dynamic',0,0,0,281474976710655,1024,0,1,'2007-03-14 13:09:32','2007-03-14 13:09:32',NULL,'latin1_general_ci',NULL,'',''),(NULL,'bug27118','topics','BASE TABLE','MyISAM',10,'Fixed',1,17,17,4785074604081151,2048,0,2,'2007-03-14 13:09:38','2007-03-14 13:09:56',NULL,'latin1_general_ci',NULL,'',''),(NULL,'bug27118','user','BASE TABLE','MyISAM',10,'Dynamic',2,24,48,281474976710655,2048,0,3,'2007-03-14 13:09:44','2007-03-14 13:10:15',NULL,'latin1_general_ci',NULL,'',''),(NULL,'bug27379','element','BASE TABLE','InnoDB',10,'Compact',5,3276,16384,0,16384,0,6,'2007-03-23 13:03:07',NULL,NULL,'utf8_unicode_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'bug27598','emails_search4more_bl','BASE TABLE','InnoDB',10,'Compact',123483,165,20496384,0,49954816,0,123373,'2007-04-05 19:57:14',NULL,NULL,'latin1_swedish_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'bug27598','emails_search4more_queue','BASE TABLE','InnoDB',10,'Compact',9883,266,2637824,0,3162112,0,9737,'2007-04-05 19:57:14',NULL,NULL,'latin1_swedish_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'bug27604','t1','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,147456,0,1,'2007-04-03 10:32:26',NULL,NULL,'latin1_swedish_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'bug27604','t2','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,147456,0,1,'2007-04-03 10:32:36',NULL,NULL,'latin1_swedish_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'bug27963','STATISTICS','BASE TABLE','MyISAM',10,'Dynamic',285,79,22600,281474976710655,1024,0,NULL,'2007-04-20 23:27:49','2007-04-20 23:28:56',NULL,'utf8_general_ci',NULL,'',''),(NULL,'bug27963','TABLES','BASE TABLE','MyISAM',10,'Dynamic',0,0,0,281474976710655,1024,0,NULL,'2007-04-20 23:29:29','2007-04-20 23:29:29',NULL,'utf8_general_ci',NULL,'',''),(NULL,'c_comps','BEATBOX','BASE TABLE','MyISAM',10,'Fixed',1,9,9,2533274790395903,1024,0,NULL,'2007-02-12 13:10:03','2007-02-12 13:10:03',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'c_comps','RESOURCES','BASE TABLE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Table \'./c_comps/resources\' is marked as crashed and last (automatic?) repair fa'),(NULL,'db1','t1','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,NULL,'2007-03-22 14:32:34','2007-03-22 14:32:34',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'db2','t1','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,NULL,'2007-03-22 14:32:35','2007-03-22 14:32:35',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'issue15134','ticks_charthistory_1i','BASE TABLE','MyISAM',10,'Dynamic',0,0,0,281474976710655,1024,0,NULL,'2007-03-13 21:54:05','2007-03-13 21:54:05',NULL,'ascii_general_ci',0,'pack_keys=1 checksum=1 delay_key_write=1','ticks compressed to 1minute intervals'),(NULL,'issue15407','article_category','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,16384,0,NULL,'2007-03-22 11:04:26',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'issue15407','test','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,1024,0,NULL,'2007-03-22 11:18:22','2007-03-22 11:23:27',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'issue15407_2','article_category','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,16384,0,NULL,'2007-03-22 13:33:56',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'issue15407_2','test','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,1024,0,NULL,'2007-03-22 13:33:56','2007-03-22 13:33:56',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'mysql','columns_priv','BASE TABLE','MyISAM',10,'Fixed',19,810,15390,227994731135631359,5120,0,NULL,'2007-01-09 15:01:54','2007-04-18 01:28:30',NULL,'utf8_bin',NULL,'','Column privileges'),(NULL,'mysql','db','BASE TABLE','MyISAM',10,'Fixed',4,438,1752,123286039799267327,4096,0,NULL,'2007-01-09 15:01:54','2007-03-22 14:32:41',NULL,'utf8_bin',NULL,'','Database privileges'),(NULL,'mysql','func','BASE TABLE','MyISAM',10,'Fixed',0,0,0,162974011515469823,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_bin',NULL,'','User defined functions'),(NULL,'mysql','help_category','BASE TABLE','MyISAM',10,'Fixed',0,0,0,163536961468891135,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','help categories'),(NULL,'mysql','help_keyword','BASE TABLE','MyISAM',10,'Fixed',0,0,0,55450570411999231,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','help keywords'),(NULL,'mysql','help_relation','BASE TABLE','MyISAM',10,'Fixed',0,0,0,2533274790395903,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','keyword-topic relation'),(NULL,'mysql','help_topic','BASE TABLE','MyISAM',10,'Dynamic',0,0,0,281474976710655,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','help topics'),(NULL,'mysql','host','BASE TABLE','MyISAM',10,'Fixed',0,0,0,109775240917155839,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_bin',NULL,'','Host privileges;  Merged with database privileges'),(NULL,'mysql','proc','BASE TABLE','MyISAM',10,'Dynamic',13,112,1668,281474976710655,3072,204,NULL,'2007-01-09 15:01:54','2007-04-17 21:51:07',NULL,'utf8_general_ci',NULL,'','Stored Procedures'),(NULL,'mysql','procs_priv','BASE TABLE','MyISAM',10,'Fixed',0,0,0,239253730204057599,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_bin',NULL,'','Procedure privileges'),(NULL,'mysql','tables_priv','BASE TABLE','MyISAM',10,'Fixed',15,851,12765,239535205180768255,5120,0,NULL,'2007-01-09 15:01:54','2007-04-18 01:28:30',NULL,'utf8_bin',NULL,'','Table privileges'),(NULL,'mysql','time_zone','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,1,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','Time zones'),(NULL,'mysql','time_zone_leap_second','BASE TABLE','MyISAM',10,'Fixed',0,0,0,3659174697238527,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','Leap seconds information for time zones'),(NULL,'mysql','time_zone_name','BASE TABLE','MyISAM',10,'Fixed',0,0,0,55450570411999231,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','Time zone names'),(NULL,'mysql','time_zone_transition','BASE TABLE','MyISAM',10,'Fixed',0,0,0,4785074604081151,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','Time zone transitions'),(NULL,'mysql','time_zone_transition_type','BASE TABLE','MyISAM',10,'Fixed',0,0,0,10696049115004927,1024,0,NULL,'2007-01-09 15:01:54','2007-01-09 15:01:54',NULL,'utf8_general_ci',NULL,'','Time zone transition types'),(NULL,'mysql','user','BASE TABLE','MyISAM',10,'Dynamic',10,60,604,281474976710655,2048,0,NULL,'2007-01-09 15:01:54','2007-04-18 01:28:30',NULL,'utf8_bin',NULL,'','Users and global privileges'),(NULL,'system','all_users','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','db_database','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,1,'2007-04-10 10:03:59',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','db_database_user','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,32768,0,1,'2007-04-10 10:04:05',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','db_user','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,16384,0,1,'2007-04-10 10:04:12',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','group_users','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','group_users_admin','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','groups','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','mail_admin_user','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,32768,0,2,'2007-04-10 10:04:43',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','mail_alias','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,32768,0,1,'2007-04-10 10:04:51',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','mail_alias_domain','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,32768,0,1,'2007-04-10 10:04:59',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','mail_box','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,32768,0,2,'2007-04-10 10:05:07',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','mail_domain','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,32768,0,2,'2007-04-10 10:05:12',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','mailer_alias','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','mailer_alias_adomain','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','mailer_alias_domain','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','mailer_box','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','mailer_box_adomain','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','mailer_domain','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','request','BASE TABLE','InnoDB',10,'Compact',2,8192,16384,0,32768,0,3,'2007-04-10 10:06:55',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','request_attr','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-04-10 10:06:55',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','request_attr_type','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,16384,0,1,'2007-04-10 10:06:55',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','request_comment','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,32768,0,1,'2007-04-10 10:06:55',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','request_type','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,1,'2007-04-10 10:06:55',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','requests','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','self','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','system_group','BASE TABLE','InnoDB',10,'Compact',5,3276,16384,0,32768,0,6,'2007-04-10 10:05:19',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','system_group_membership','BASE TABLE','InnoDB',10,'Compact',2,8192,16384,0,32768,0,3,'2007-04-10 10:05:48',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','system_user','BASE TABLE','InnoDB',10,'Compact',2,8192,16384,0,49152,0,3,'2007-04-10 10:05:58',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','users','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'system','web_site','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,32768,0,2,'2007-04-10 10:06:06',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','web_site_alias','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,32768,0,1,'2007-04-10 10:06:13',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'system','web_site_user','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-04-10 10:06:31',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test','City','BASE TABLE','MyISAM',10,'Fixed',0,0,0,50384020831207423,1024,0,NULL,'2007-04-10 12:48:30','2007-04-10 12:48:30',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','CityList','BASE TABLE','MyISAM',10,'Fixed',4,43,172,12103423998558207,2048,0,NULL,'2007-02-27 18:34:38','2007-02-27 18:34:38',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','Country-List','BASE TABLE','MyISAM',10,'Fixed',4,56,224,15762598695796735,2048,0,NULL,'2007-02-27 18:34:40','2007-02-27 18:34:40',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','Howtos_Original','BASE TABLE','MyISAM',10,'Dynamic',1,2696,2696,281474976710655,2048,0,266,'2007-04-10 10:18:05','2007-04-10 10:18:51',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','MathTest','BASE TABLE','MEMORY',10,'Fixed',2,35,129060,16311155,0,0,NULL,NULL,NULL,NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','RT_PORTFOLIO_DETAILS','BASE TABLE','MyISAM',10,'Dynamic',0,0,0,281474976710655,1024,0,NULL,'2007-03-26 18:29:15','2007-03-26 18:29:15',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'test','a','BASE TABLE','MyISAM',10,'Dynamic',1,20,20,281474976710655,2048,0,NULL,'2007-04-12 15:55:31','2007-04-12 15:56:02',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','area','BASE TABLE','MyISAM',10,'Fixed',3,9,27,2533274790395903,1024,0,NULL,'2007-01-11 19:40:33','2007-01-11 19:40:33',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','articles','BASE TABLE','MyISAM',10,'Fixed',3,9,27,2533274790395903,2048,0,4,'2007-04-16 12:44:49','2007-04-16 12:45:00',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','biginttest','BASE TABLE','MyISAM',10,'Fixed',1,9,9,2533274790395903,1024,0,NULL,'2007-03-14 13:21:55','2007-03-14 13:22:21',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug1588','BASE TABLE','MyISAM',10,'Fixed',3,7,21,1970324836974591,1024,0,NULL,'2007-02-20 13:40:32','2007-02-20 13:40:54',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug1588_2','BASE TABLE','MyISAM',10,'Dynamic',3,20,60,281474976710655,1024,0,NULL,'2007-02-20 13:41:20','2007-02-20 13:41:53',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug24833_1','BASE TABLE','MyISAM',10,'Fixed',5,7,35,1970324836974591,2048,0,6,'2007-01-12 11:51:37','2007-01-15 23:24:46',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug24833_2','BASE TABLE','MyISAM',10,'Fixed',5,7,35,1970324836974591,2048,0,6,'2007-01-12 11:51:44','2007-01-15 23:26:46',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug25519','BASE TABLE','MyISAM',10,'Dynamic',1,20,20,281474976710655,1024,0,NULL,'2007-01-10 11:12:44','2007-01-10 11:12:44',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug25631','BASE TABLE','MyISAM',10,'Fixed',3,31,93,8725724278030335,1024,0,NULL,'2007-01-20 00:58:04','2007-01-20 00:58:06',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug26543','BASE TABLE','MyISAM',10,'Fixed',2,7,14,1970324836974591,1024,0,NULL,'2007-02-26 15:20:22','2007-02-26 15:20:22',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug27120','BASE TABLE','MyISAM',10,'Fixed',0,0,0,19984723346456575,1024,0,9223372036854775807,'2007-03-14 13:23:35','2007-03-14 13:23:35',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','bug3753','BASE TABLE','MyISAM',10,'Fixed',3,7,21,1970324836974591,1024,0,NULL,'2007-02-21 17:15:34','2007-02-21 17:15:34',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','child','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,16384,0,NULL,'2007-04-11 13:44:55',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB; (`parent_id`) REFER `test/parent`(`id`) ON DELETE CASCAD'),(NULL,'test','documents','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,1024,0,NULL,'2007-02-12 12:54:28','2007-02-12 12:54:37',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','inttest','BASE TABLE','MyISAM',10,'Fixed',1,7,7,1970324836974591,1024,0,NULL,'2007-03-14 13:21:11','2007-03-14 13:21:40',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','issue15407','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,1024,0,NULL,'2007-03-22 10:48:26','2007-03-22 10:49:48',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','mtTable','BASE TABLE','MyISAM',10,'Dynamic',1,20,20,281474976710655,2048,0,2,'2007-03-30 10:57:27','2007-03-30 10:58:14',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'test','mtTable_record','BASE TABLE','MyISAM',10,'Dynamic',1,20,20,281474976710655,3072,0,2,'2007-03-30 10:57:34','2007-03-30 10:58:14',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'test','order_table_backup','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-03-16 12:24:15',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test','parent','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-04-11 13:44:51',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test','puerto','BASE TABLE','MyISAM',10,'Dynamic',1,28,28,281474976710655,2048,0,2,'2007-03-29 14:47:45','2007-03-29 14:47:49',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'test','ratings','BASE TABLE','MyISAM',10,'Fixed',3,20,60,5629499534213119,1024,0,NULL,'2007-04-16 12:45:51','2007-04-16 12:46:21',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','rooms','BASE TABLE','MyISAM',10,'Fixed',4,21,84,5910974510923775,1024,0,NULL,'2007-01-11 19:40:33','2007-01-11 19:40:33',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','some-view','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'test','t','BASE TABLE','MyISAM',10,'Fixed',4,7,28,1970324836974591,1024,0,NULL,'2007-04-04 13:36:03','2007-04-09 13:39:50',NULL,'cp1251_general_ci',NULL,'',''),(NULL,'test','t1','BASE TABLE','MyISAM',10,'Fixed',2,9,18,2533274790395903,1024,0,NULL,'2007-04-18 01:28:11','2007-04-18 01:28:41',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','t3','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,2048,0,9,'2007-01-20 22:10:41','2007-01-20 22:25:11',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','t_course','BASE TABLE','InnoDB',10,'Compact',2,8192,16384,0,0,0,3,'2007-03-30 12:19:54',NULL,NULL,'cp1251_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test','t_course_sem','BASE TABLE','InnoDB',10,'Compact',5,3276,16384,0,32768,0,6,'2007-03-30 12:19:54',NULL,NULL,'cp1251_general_ci',NULL,'','InnoDB free: 166912 kB; (`course_id`) REFER `test/t_course`(`course_id`); (`sem_'),(NULL,'test','t_innodb','BASE TABLE','InnoDB',10,'Compact',0,0,16384,0,0,0,NULL,'2007-04-11 11:06:33',NULL,NULL,'utf8_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test','t_sem','BASE TABLE','InnoDB',10,'Compact',8,2048,16384,0,0,0,9,'2007-03-30 12:19:54',NULL,NULL,'cp1251_general_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test','ta','BASE TABLE','MyISAM',10,'Fixed',1,9,9,2533274790395903,1024,0,NULL,'2007-02-11 00:12:12','2007-02-11 00:12:12',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','temp','BASE TABLE','MyISAM',10,'Fixed',3,25,75,7036874417766399,2048,0,4,'2007-02-08 10:32:49','2007-02-08 10:32:58',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','test','BASE TABLE','MyISAM',10,'Fixed',1,9,9,2533274790395903,1024,0,NULL,'2007-03-20 22:46:18','2007-03-20 22:46:44',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','test1','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,2048,0,3,'2007-04-17 23:46:41','2007-04-17 23:47:03',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','test2','BASE TABLE','MyISAM',10,'Dynamic',2,20,40,281474976710655,2048,0,3,'2007-04-17 23:46:41','2007-04-17 23:47:03',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','test3','BASE TABLE','MyISAM',10,'Fixed',4,13,52,3659174697238527,2048,0,5,'2007-04-17 23:46:46','2007-04-17 23:47:03',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','test_blob','BASE TABLE','MyISAM',10,'Dynamic',1,20,20,281474976710655,1024,0,NULL,'2007-02-28 11:47:01','2007-02-28 11:47:46',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'test','testbug25611_1_1','BASE TABLE','MyISAM',10,'Dynamic',9,57,516,281474976710655,2048,0,10,'2007-01-25 11:33:45','2007-01-25 11:34:43',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','tt','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,NULL,'2007-01-29 19:32:44','2007-01-29 19:32:44',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','ud','BASE TABLE','MyISAM',10,'Fixed',4,318,1272,89509042593988607,4096,0,15005,'2007-04-13 15:39:03','2007-04-13 15:39:06',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'test','users','BASE TABLE','MyISAM',10,'Fixed',3,7,21,1970324836974591,2048,0,4,'2007-04-12 11:02:26','2007-04-12 11:03:30',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','users_friends','BASE TABLE','MyISAM',10,'Fixed',3,7,21,1970324836974591,1024,0,NULL,'2007-04-12 11:02:27','2007-04-12 11:03:30',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','v1','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'test','vbug25611_1_1','VIEW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'VIEW'),(NULL,'test','webcams','BASE TABLE','InnoDB',10,'Compact',1,16384,16384,0,49152,0,4,'2007-04-02 12:45:42',NULL,NULL,'latin1_german1_ci',NULL,'','InnoDB free: 166912 kB'),(NULL,'test',' ','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,NULL,'2007-04-20 21:38:39','2007-04-20 21:38:39',NULL,'utf8_general_ci',NULL,'',''),(NULL,'test','а','BASE TABLE','MyISAM',10,'Fixed',0,0,0,1970324836974591,1024,0,NULL,'2007-04-20 21:33:03','2007-04-20 21:33:03',NULL,'utf8_general_ci',NULL,'',''),(NULL,'testcase','media','BASE TABLE','MyISAM',10,'Dynamic',3,22,68,281474976710655,2048,0,4,'2007-01-31 14:10:32','2007-01-31 14:10:58',NULL,'utf8_unicode_ci',NULL,'',''),(NULL,'testcase','relation','BASE TABLE','MyISAM',10,'Fixed',1095,13,14287,3659174697238527,43008,52,NULL,'2007-01-31 14:10:32','2007-01-31 14:10:47','2007-01-31 14:11:25','utf8_unicode_ci',NULL,'',''),(NULL,'world','City','BASE TABLE','MyISAM',10,'Fixed',4079,67,273293,18858823439613951,43008,0,4080,'2007-01-15 11:03:19','2007-01-15 11:03:27',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'world','CityList','BASE TABLE','MyISAM',10,'Fixed',4079,43,175397,12103423998558207,39936,0,NULL,'2007-02-27 18:33:52','2007-02-27 18:33:52','2007-02-27 18:33:52','utf8_general_ci',NULL,'',''),(NULL,'world','Country','BASE TABLE','MyISAM',10,'Fixed',239,261,62379,73464968921481215,5120,0,NULL,'2007-01-15 11:03:19','2007-01-15 11:03:27',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'world','CountryLanguage','BASE TABLE','MyISAM',10,'Fixed',984,39,38376,10977524091715583,23552,0,NULL,'2007-01-15 11:03:20','2007-01-15 11:03:27',NULL,'latin1_swedish_ci',NULL,'',''),(NULL,'world','CountryList','BASE TABLE','MyISAM',10,'Fixed',239,56,13384,15762598695796735,5120,0,NULL,'2007-02-27 18:34:00','2007-02-27 18:34:00',NULL,'utf8_general_ci',NULL,'','');
ALTER TABLE `TABLES` ENABLE KEYS;
UNLOCK TABLES;
SET TIME_ZONE=@OLD_TIME_ZONE;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
SET SQL_NOTES=@OLD_SQL_NOTES;

-- Dump completed on 2007-04-20 19:30:11

#--enable_query_log

SELECT
  t.TABLE_SCHEMA
 , t.TABLE_NAME
 , s.INDEX_NAME
 , s.COLUMN_NAME
 , s.SEQ_IN_INDEX
 , (
   SELECT MAX(SEQ_IN_INDEX)
   FROM STATISTICS s2
   WHERE s.TABLE_SCHEMA = s2.TABLE_SCHEMA
   AND s.TABLE_NAME = s2.TABLE_NAME
   AND s.INDEX_NAME = s2.INDEX_NAME
  ) AS "COLS_IN_INDEX"
 , s.CARDINALITY AS "CARD"
 , t.TABLE_ROWS AS "ROWS"
 , ROUND(((s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) * 100), 2) AS "SEL %"
FROM STATISTICS s
 INNER JOIN TABLES t
  ON s.TABLE_SCHEMA = t.TABLE_SCHEMA
  AND s.TABLE_NAME = t.TABLE_NAME
WHERE t.TABLE_SCHEMA != 'mysql'
AND t.TABLE_ROWS > 10
AND s.CARDINALITY IS NOT NULL
AND (s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) < 1.00
ORDER BY "SEL %", TABLE_SCHEMA, TABLE_NAME
LIMIT 10;

explain SELECT
  t.TABLE_SCHEMA
 , t.TABLE_NAME
 , s.INDEX_NAME
 , s.COLUMN_NAME
 , s.SEQ_IN_INDEX
 , (
   SELECT MAX(SEQ_IN_INDEX)
   FROM STATISTICS s2
   WHERE s.TABLE_SCHEMA = s2.TABLE_SCHEMA
   AND s.TABLE_NAME = s2.TABLE_NAME
   AND s.INDEX_NAME = s2.INDEX_NAME
  ) AS "COLS_IN_INDEX"
 , s.CARDINALITY AS "CARD"
 , t.TABLE_ROWS AS "ROWS"
 , ROUND(((s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) * 100), 2) AS "SEL %"
FROM STATISTICS s
 INNER JOIN TABLES t
  ON s.TABLE_SCHEMA = t.TABLE_SCHEMA
  AND s.TABLE_NAME = t.TABLE_NAME
WHERE t.TABLE_SCHEMA != 'mysql'
AND t.TABLE_ROWS > 10
AND s.CARDINALITY IS NOT NULL
AND (s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) < 1.00
ORDER BY "SEL %", TABLE_SCHEMA, TABLE_NAME
LIMIT 10;

SELECT
  t.TABLE_SCHEMA
 , t.TABLE_NAME
 , s.INDEX_NAME
 , s.COLUMN_NAME
 , s.SEQ_IN_INDEX
 , s2.max_columns AS "COLS_IN_INDEX"
 , s.CARDINALITY AS "CARD"
 , t.TABLE_ROWS AS "ROWS"
 , ROUND(((s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) * 100), 2) AS "SEL %"
FROM STATISTICS s
 INNER JOIN TABLES t
  ON s.TABLE_SCHEMA = t.TABLE_SCHEMA
  AND s.TABLE_NAME = t.TABLE_NAME
 INNER JOIN (
  SELECT 
     TABLE_SCHEMA
   , TABLE_NAME
   , INDEX_NAME
   , MAX(SEQ_IN_INDEX) AS max_columns
  FROM STATISTICS
  WHERE TABLE_SCHEMA != 'mysql'
  GROUP BY TABLE_SCHEMA, TABLE_NAME, INDEX_NAME
 ) AS s2
 ON s.TABLE_SCHEMA = s2.TABLE_SCHEMA
 AND s.TABLE_NAME = s2.TABLE_NAME
 AND s.INDEX_NAME = s2.INDEX_NAME
WHERE t.TABLE_SCHEMA != 'mysql'
AND t.TABLE_ROWS > 10
AND s.CARDINALITY IS NOT NULL
AND (s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) < 1.00
ORDER BY "SEL %", TABLE_SCHEMA, TABLE_NAME 
LIMIT 10;

explain SELECT
  t.TABLE_SCHEMA
 , t.TABLE_NAME
 , s.INDEX_NAME
 , s.COLUMN_NAME
 , s.SEQ_IN_INDEX
 , s2.max_columns AS "COLS_IN_INDEX"
 , s.CARDINALITY AS "CARD"
 , t.TABLE_ROWS AS "ROWS"
 , ROUND(((s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) * 100), 2) AS "SEL %"
FROM STATISTICS s
 INNER JOIN TABLES t
  ON s.TABLE_SCHEMA = t.TABLE_SCHEMA
  AND s.TABLE_NAME = t.TABLE_NAME
 INNER JOIN (
  SELECT 
     TABLE_SCHEMA
   , TABLE_NAME
   , INDEX_NAME
   , MAX(SEQ_IN_INDEX) AS max_columns
  FROM STATISTICS
  WHERE TABLE_SCHEMA != 'mysql'
  GROUP BY TABLE_SCHEMA, TABLE_NAME, INDEX_NAME
 ) AS s2
 ON s.TABLE_SCHEMA = s2.TABLE_SCHEMA
 AND s.TABLE_NAME = s2.TABLE_NAME
 AND s.INDEX_NAME = s2.INDEX_NAME
WHERE t.TABLE_SCHEMA != 'mysql'
AND t.TABLE_ROWS > 10
AND s.CARDINALITY IS NOT NULL
AND (s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) < 1.00
ORDER BY "SEL %", TABLE_SCHEMA, TABLE_NAME 
LIMIT 10;