DROP DATABASE IF EXISTS `ant`;
CREATE DATABASE `ant`;

use `ant`;

CREATE TABLE `mosquito`
(
	`counter` INTEGER UNSIGNED AUTO_INCREMENT NOT NULL,
	`earwig` mediumblob NOT NULL,
	`file_index` INTEGER,
	PRIMARY KEY (`counter`)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;

SET @@session.character_set_client=8;	/* seems to fix the encoding */

INSERT into `mosquito` (file_index, earwig) 
	VALUES (1, 'ÁeŠ
V ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿ ÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿ\0\0x(
ü
ü
ü
ü');
INSERT into `mosquito` (file_index, earwig) 
	VALUES (1, 'ÁeŠ
V ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿ ÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿ\0\0x(
ü
ü
ü
ü');
	

SET @@session.character_set_client=33;	/* This is in the binary log. Not sure if query browser set this */

SET @@session.collation_connection=8;
SET @@session.collation_server=8;

INSERT into `mosquito` (file_index, earwig) 
	VALUES (2, 'ÁeŠ
V ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿ ÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿ\0\0x(
ü
ü
ü
ü');
INSERT into `mosquito` (file_index, earwig) 
	VALUES (2, 'ÁeŠ
V ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿV ÿÿÿÿÿÿ ÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿ\0\0x(
ü
ü
ü
ü');

select MD5(earwig), file_index from mosquito m\G;