/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#110505 10:39:54 server id 1  end_log_pos 106 	Start: binlog v 4, server v 5.1.52-log created 110505 10:39:54 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
6uDCTQ8BAAAAZgAAAGoAAAABAAQANS4xLjUyLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAADq4MJNEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
'/*!*/;
# at 106
#110505 10:39:54 server id 1  end_log_pos 199 	Query	thread_id=3	exec_time=0	error_code=0
use test/*!*/;
SET TIMESTAMP=1304617194/*!*/;
SET @@session.pseudo_thread_id=3/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
drop table if exists userstats
/*!*/;
# at 199
#110505 10:39:54 server id 1  end_log_pos 293 	Query	thread_id=3	exec_time=0	error_code=0
SET TIMESTAMP=1304617194/*!*/;
drop table if exists userstats2
/*!*/;
# at 293
#110505 10:39:54 server id 1  end_log_pos 419 	Query	thread_id=6	exec_time=1	error_code=0
SET TIMESTAMP=1304617194/*!*/;
create table userstats (i int primary key, j int) engine=innodb
/*!*/;
# at 419
#110505 10:39:55 server id 1  end_log_pos 514 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
create index usx on userstats(j)
/*!*/;
# at 514
#110505 10:39:55 server id 1  end_log_pos 641 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
create table userstats2 (i int primary key, j int) engine=innodb
/*!*/;
# at 641
#110505 10:39:55 server id 1  end_log_pos 738 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
create index us2x on userstats2(j)
/*!*/;
# at 738
#110505 10:39:55 server id 1  end_log_pos 806 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 806
# at 855
#110505 10:39:55 server id 1  end_log_pos 855 	Table_map: `test`.`userstats` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 893 	Write_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMQAAAFcDAAAAAAAAAAAAAAEABHRlc3QACXVzZXJzdGF0cwACAwMAAg==
6+DCTRcBAAAAJgAAAH0DAAAAAAAAAAAAAAEAAv/8AQAAAAEAAAA=
'/*!*/;
### INSERT INTO test.userstats
### SET
###   @1=1
###   @2=1
# at 893
#110505 10:39:55 server id 1  end_log_pos 920 	Xid = 31
COMMIT/*!*/;
# at 920
#110505 10:39:55 server id 1  end_log_pos 988 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 988
# at 1037
#110505 10:39:55 server id 1  end_log_pos 1037 	Table_map: `test`.`userstats` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 1084 	Write_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMQAAAA0EAAAAAAAAAAAAAAEABHRlc3QACXVzZXJzdGF0cwACAwMAAg==
6+DCTRcBAAAALwAAADwEAAAAAAAAAAAAAAEAAv/8AgAAAAIAAAD8AwAAAAMAAAA=
'/*!*/;
### INSERT INTO test.userstats
### SET
###   @1=2
###   @2=2
### INSERT INTO test.userstats
### SET
###   @1=3
###   @2=3
# at 1084
#110505 10:39:55 server id 1  end_log_pos 1111 	Xid = 32
COMMIT/*!*/;
# at 1111
#110505 10:39:55 server id 1  end_log_pos 1179 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 1179
# at 1229
#110505 10:39:55 server id 1  end_log_pos 1229 	Table_map: `test`.`userstats2` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 1267 	Write_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMgAAAM0EAAAAAAAAAAAAAAEABHRlc3QACnVzZXJzdGF0czIAAgMDAAI=
6+DCTRcBAAAAJgAAAPMEAAAAAAAAAAAAAAEAAv/8BAAAAAQAAAA=
'/*!*/;
### INSERT INTO test.userstats2
### SET
###   @1=4
###   @2=4
# at 1267
#110505 10:39:55 server id 1  end_log_pos 1294 	Xid = 33
COMMIT/*!*/;
# at 1294
#110505 10:39:55 server id 1  end_log_pos 1362 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 1362
# at 1411
#110505 10:39:55 server id 1  end_log_pos 1411 	Table_map: `test`.`userstats` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 1449 	Write_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMQAAAIMFAAAAAAAAAAAAAAEABHRlc3QACXVzZXJzdGF0cwACAwMAAg==
6+DCTRcBAAAAJgAAAKkFAAAAAAAAAAAAAAEAAv/8BAAAAAQAAAA=
'/*!*/;
### INSERT INTO test.userstats
### SET
###   @1=4
###   @2=4
# at 1449
#110505 10:39:55 server id 1  end_log_pos 1476 	Xid = 34
COMMIT/*!*/;
# at 1476
#110505 10:39:55 server id 1  end_log_pos 1544 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 1544
# at 1593
#110505 10:39:55 server id 1  end_log_pos 1593 	Table_map: `test`.`userstats` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 1631 	Write_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMQAAADkGAAAAAAAAAAAAAAEABHRlc3QACXVzZXJzdGF0cwACAwMAAg==
6+DCTRcBAAAAJgAAAF8GAAAAAAAAAAAAAAEAAv/8BgAAAAYAAAA=
'/*!*/;
### INSERT INTO test.userstats
### SET
###   @1=6
###   @2=6
# at 1631
#110505 10:39:55 server id 1  end_log_pos 1658 	Xid = 36
COMMIT/*!*/;
# at 1658
#110505 10:39:55 server id 1  end_log_pos 1726 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 1726
# at 1775
#110505 10:39:55 server id 1  end_log_pos 1775 	Table_map: `test`.`userstats` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 1813 	Delete_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMQAAAO8GAAAAAAAAAAAAAAEABHRlc3QACXVzZXJzdGF0cwACAwMAAg==
6+DCTRkBAAAAJgAAABUHAAAAAAAAAAAAAAEAAv/8AQAAAAEAAAA=
'/*!*/;
### DELETE FROM test.userstats
### WHERE
###   @1=1
###   @2=1
# at 1813
#110505 10:39:55 server id 1  end_log_pos 1840 	Xid = 40
COMMIT/*!*/;
# at 1840
#110505 10:39:55 server id 1  end_log_pos 1908 	Query	thread_id=6	exec_time=0	error_code=0
SET TIMESTAMP=1304617195/*!*/;
BEGIN
/*!*/;
# at 1908
# at 1957
# at 2007
#110505 10:39:55 server id 1  end_log_pos 1957 	Table_map: `test`.`userstats` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 2007 	Table_map: `test`.`userstats2` mapped to number 0
#110505 10:39:55 server id 1  end_log_pos 2054 	Delete_rows: table id 0 flags: STMT_END_F

BINLOG '
6+DCTRMBAAAAMQAAAKUHAAAAAAAAAAAAAAEABHRlc3QACXVzZXJzdGF0cwACAwMAAg==
6+DCTRMBAAAAMgAAANcHAAAAAAAAAAAAAAEABHRlc3QACnVzZXJzdGF0czIAAgMDAAI=
6+DCTRkBAAAALwAAAAYIAAAAAAAAAAAAAAEAAv/8BAAAAAQAAAD8BAAAAAQAAAA=
'/*!*/;
### DELETE FROM test.userstats2
### WHERE
###   @1=4
###   @2=4
### DELETE FROM test.userstats2
### WHERE
###   @1=4
###   @2=4
# at 2054
#110505 10:39:55 server id 1  end_log_pos 2081 	Xid = 47
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;