fredrik@agert:~$ mysqlbinlog /var/log/mysql/mysql-bin.000265 /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #070618 11:49:43 server id 1 end_log_pos 98 Start: binlog v 4, server v 5.0.38-Ubuntu_0ubuntu1-log created 070618 11:49:43 at startup # Warning: this binlog was not closed properly. Most probably mysqld crashed writing it. ROLLBACK/*!*/; # at 98 #070618 11:51:21 server id 1 end_log_pos 198 Query thread_id=2 exec_time=0 error_code=0 use wikidb/*!*/; SET TIMESTAMP=1182160281/*!*/; SET @@session.foreign_key_checks=0, @@session.sql_auto_is_null=1, @@session.unique_checks=0/*!*/; SET @@session.sql_mode=524288/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/; DROP TABLE IF EXISTS `blog_archive`/*!*/; # at 198 #070618 11:51:21 server id 1 end_log_pos 1007 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160281/*!*/; CREATE TABLE `blog_archive` ( `ar_namespace` int(11) NOT NULL default '0', `ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `ar_text` mediumblob NOT NULL, `ar_comment` tinyblob NOT NULL, `ar_user` int(5) unsigned NOT NULL default '0', `ar_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `ar_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '', `ar_minor_edit` tinyint(1) NOT NULL default '0', `ar_flags` tinyblob NOT NULL, `ar_rev_id` int(8) unsigned default NULL, `ar_text_id` int(8) unsigned default NULL, KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 1007 #070618 11:51:21 server id 1 end_log_pos 1123 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160281/*!*/; /*!40000 ALTER TABLE `blog_archive` DISABLE KEYS *//*!*/; # at 1123 #070618 11:51:21 server id 1 end_log_pos 1238 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160281/*!*/; /*!40000 ALTER TABLE `blog_archive` ENABLE KEYS *//*!*/; # at 1238 #070618 11:51:21 server id 1 end_log_pos 1344 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160281/*!*/; DROP TABLE IF EXISTS `blog_categorylinks`/*!*/; # at 1344 #070618 11:51:21 server id 1 end_log_pos 1929 Query thread_id=2 exec_time=1 error_code=0 SET TIMESTAMP=1182160281/*!*/; CREATE TABLE `blog_categorylinks` ( `cl_from` int(8) unsigned NOT NULL default '0', `cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `cl_sortkey` varchar(86) character set latin1 collate latin1_bin NOT NULL default '', `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, UNIQUE KEY `cl_from` (`cl_from`,`cl_to`), KEY `cl_sortkey` (`cl_to`,`cl_sortkey`), KEY `cl_timestamp` (`cl_to`,`cl_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 1929 #070618 11:51:22 server id 1 end_log_pos 2051 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_categorylinks` DISABLE KEYS *//*!*/; # at 2051 #070618 11:51:22 server id 1 end_log_pos 2172 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_categorylinks` ENABLE KEYS *//*!*/; # at 2172 #070618 11:51:22 server id 1 end_log_pos 2278 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_externallinks`/*!*/; # at 2278 #070618 11:51:22 server id 1 end_log_pos 2634 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_externallinks` ( `el_from` int(8) unsigned NOT NULL default '0', `el_to` blob NOT NULL, `el_index` blob NOT NULL, KEY `el_from` (`el_from`,`el_to`(40)), KEY `el_to` (`el_to`(60),`el_from`), KEY `el_index` (`el_index`(60)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 2634 #070618 11:51:22 server id 1 end_log_pos 2756 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_externallinks` DISABLE KEYS *//*!*/; # at 2756 #070618 11:51:22 server id 1 end_log_pos 2877 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_externallinks` ENABLE KEYS *//*!*/; # at 2877 #070618 11:51:22 server id 1 end_log_pos 2981 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_filearchive`/*!*/; # at 2981 #070618 11:51:22 server id 1 end_log_pos 4569 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_filearchive` ( `fa_id` int(11) NOT NULL auto_increment, `fa_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `fa_archive_name` varchar(255) character set latin1 collate latin1_bin default '', `fa_storage_group` varchar(16) default NULL, `fa_storage_key` varchar(64) character set latin1 collate latin1_bin default '', `fa_deleted_user` int(11) default NULL, `fa_deleted_timestamp` varchar(14) character set latin1 collate latin1_bin default '', `fa_deleted_reason` text, `fa_size` int(8) unsigned default '0', `fa_width` int(5) default '0', `fa_height` int(5) default '0', `fa_metadata` mediumblob, `fa_bits` int(3) default '0', `fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL, `fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') default 'unknown', `fa_minor_mime` varchar(32) default 'unknown', `fa_description` tinyblob, `fa_user` int(5) unsigned default '0', `fa_user_text` varchar(255) character set latin1 collate latin1_bin default NULL, `fa_timestamp` varchar(14) character set latin1 collate latin1_bin default '', PRIMARY KEY (`fa_id`), KEY `fa_name` (`fa_name`,`fa_timestamp`), KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`), KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`), KEY `fa_deleted_user` (`fa_deleted_user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 4569 #070618 11:51:22 server id 1 end_log_pos 4689 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_filearchive` DISABLE KEYS *//*!*/; # at 4689 #070618 11:51:22 server id 1 end_log_pos 4808 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_filearchive` ENABLE KEYS *//*!*/; # at 4808 #070618 11:51:22 server id 1 end_log_pos 4911 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_hitcounter`/*!*/; # at 4911 #070618 11:51:22 server id 1 end_log_pos 5110 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_hitcounter` ( `hc_id` int(10) unsigned NOT NULL default '0' ) ENGINE=MEMORY DEFAULT CHARSET=latin1 MAX_ROWS=25000/*!*/; # at 5110 #070618 11:51:22 server id 1 end_log_pos 5229 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_hitcounter` DISABLE KEYS *//*!*/; # at 5229 #070618 11:51:22 server id 1 end_log_pos 5347 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_hitcounter` ENABLE KEYS *//*!*/; # at 5347 #070618 11:51:22 server id 1 end_log_pos 5445 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_image`/*!*/; # at 5445 #070618 11:51:22 server id 1 end_log_pos 6587 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_image` ( `img_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `img_size` int(8) unsigned NOT NULL default '0', `img_width` int(5) NOT NULL default '0', `img_height` int(5) NOT NULL default '0', `img_metadata` mediumblob NOT NULL, `img_bits` int(3) NOT NULL default '0', `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL, `img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown', `img_minor_mime` varchar(32) NOT NULL default 'unknown', `img_description` tinyblob NOT NULL, `img_user` int(5) unsigned NOT NULL default '0', `img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `img_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '', PRIMARY KEY (`img_name`), KEY `img_size` (`img_size`), KEY `img_timestamp` (`img_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 6587 #070618 11:51:22 server id 1 end_log_pos 6701 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_image` DISABLE KEYS *//*!*/; # at 6701 #070618 11:51:22 server id 1 end_log_pos 6814 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_image` ENABLE KEYS *//*!*/; # at 6814 #070618 11:51:22 server id 1 end_log_pos 6917 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_imagelinks`/*!*/; # at 6917 #070618 11:51:22 server id 1 end_log_pos 7265 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_imagelinks` ( `il_from` int(8) unsigned NOT NULL default '0', `il_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', UNIQUE KEY `il_from` (`il_from`,`il_to`), KEY `il_to` (`il_to`,`il_from`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 7265 #070618 11:51:22 server id 1 end_log_pos 7384 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_imagelinks` DISABLE KEYS *//*!*/; # at 7384 #070618 11:51:22 server id 1 end_log_pos 7502 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_imagelinks` ENABLE KEYS *//*!*/; # at 7502 #070618 11:51:22 server id 1 end_log_pos 7604 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_interwiki`/*!*/; # at 7604 #070618 11:51:22 server id 1 end_log_pos 7956 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_interwiki` ( `iw_prefix` char(32) NOT NULL default '', `iw_url` char(127) NOT NULL default '', `iw_local` tinyint(1) NOT NULL default '0', `iw_trans` tinyint(1) NOT NULL default '0', UNIQUE KEY `iw_prefix` (`iw_prefix`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 7956 #070618 11:51:22 server id 1 end_log_pos 8074 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_interwiki` DISABLE KEYS *//*!*/; # at 8074 #070618 11:51:22 server id 1 end_log_pos 8191 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_interwiki` ENABLE KEYS *//*!*/; # at 8191 #070618 11:51:22 server id 1 end_log_pos 8292 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_ipblocks`/*!*/; # at 8292 #070618 11:51:22 server id 1 end_log_pos 9385 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_ipblocks` ( `ipb_id` int(8) NOT NULL auto_increment, `ipb_address` tinyblob NOT NULL, `ipb_user` int(8) unsigned NOT NULL default '0', `ipb_by` int(8) unsigned NOT NULL default '0', `ipb_reason` tinyblob NOT NULL, `ipb_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '', `ipb_auto` tinyint(1) NOT NULL default '0', `ipb_anon_only` tinyint(1) NOT NULL default '0', `ipb_create_account` tinyint(1) NOT NULL default '1', `ipb_enable_autoblock` tinyint(1) NOT NULL default '1', `ipb_expiry` varchar(14) character set latin1 collate latin1_bin NOT NULL default '', `ipb_range_start` tinyblob NOT NULL, `ipb_range_end` tinyblob NOT NULL, PRIMARY KEY (`ipb_id`), UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`), KEY `ipb_user` (`ipb_user`), KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)), KEY `ipb_timestamp` (`ipb_timestamp`), KEY `ipb_expiry` (`ipb_expiry`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 9385 #070618 11:51:22 server id 1 end_log_pos 9502 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_ipblocks` DISABLE KEYS *//*!*/; # at 9502 #070618 11:51:22 server id 1 end_log_pos 9618 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_ipblocks` ENABLE KEYS *//*!*/; # at 9618 #070618 11:51:22 server id 1 end_log_pos 9714 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_job`/*!*/; # at 9714 #070618 11:51:22 server id 1 end_log_pos 10190 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_job` ( `job_id` int(9) unsigned NOT NULL auto_increment, `job_cmd` varchar(255) NOT NULL default '', `job_namespace` int(11) NOT NULL default '0', `job_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `job_params` blob NOT NULL, PRIMARY KEY (`job_id`), KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 10190 #070618 11:51:22 server id 1 end_log_pos 10302 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_job` DISABLE KEYS *//*!*/; # at 10302 #070618 11:51:22 server id 1 end_log_pos 10413 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_job` ENABLE KEYS *//*!*/; # at 10413 #070618 11:51:22 server id 1 end_log_pos 10515 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_langlinks`/*!*/; # at 10515 #070618 11:51:22 server id 1 end_log_pos 10957 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_langlinks` ( `ll_from` int(8) unsigned NOT NULL default '0', `ll_lang` varchar(10) character set latin1 collate latin1_bin NOT NULL default '', `ll_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`), KEY `ll_lang` (`ll_lang`,`ll_title`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 10957 #070618 11:51:22 server id 1 end_log_pos 11075 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_langlinks` DISABLE KEYS *//*!*/; # at 11075 #070618 11:51:22 server id 1 end_log_pos 11192 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_langlinks` ENABLE KEYS *//*!*/; # at 11192 #070618 11:51:22 server id 1 end_log_pos 11292 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_logging`/*!*/; # at 11292 #070618 11:51:22 server id 1 end_log_pos 12045 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_logging` ( `log_type` varchar(10) NOT NULL default '', `log_action` varchar(10) NOT NULL default '', `log_timestamp` varchar(14) NOT NULL default '19700101000000', `log_user` int(10) unsigned NOT NULL default '0', `log_namespace` int(11) NOT NULL default '0', `log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `log_comment` varchar(255) NOT NULL default '', `log_params` blob NOT NULL, KEY `type_time` (`log_type`,`log_timestamp`), KEY `user_time` (`log_user`,`log_timestamp`), KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`), KEY `times` (`log_timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 12045 #070618 11:51:22 server id 1 end_log_pos 12161 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_logging` DISABLE KEYS *//*!*/; # at 12161 #070618 11:51:22 server id 1 end_log_pos 12276 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_logging` ENABLE KEYS *//*!*/; # at 12276 #070618 11:51:22 server id 1 end_log_pos 12373 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_math`/*!*/; # at 12373 #070618 11:51:22 server id 1 end_log_pos 12763 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_math` ( `math_inputhash` varchar(16) NOT NULL default '', `math_outputhash` varchar(16) NOT NULL default '', `math_html_conservativeness` tinyint(1) NOT NULL default '0', `math_html` text, `math_mathml` text, UNIQUE KEY `math_inputhash` (`math_inputhash`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 12763 #070618 11:51:22 server id 1 end_log_pos 12876 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_math` DISABLE KEYS *//*!*/; # at 12876 #070618 11:51:22 server id 1 end_log_pos 12988 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_math` ENABLE KEYS *//*!*/; # at 12988 #070618 11:51:22 server id 1 end_log_pos 13092 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_objectcache`/*!*/; # at 13092 #070618 11:51:22 server id 1 end_log_pos 13436 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_objectcache` ( `keyname` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `value` mediumblob, `exptime` datetime default NULL, UNIQUE KEY `keyname` (`keyname`), KEY `exptime` (`exptime`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 13436 #070618 11:51:22 server id 1 end_log_pos 13556 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_objectcache` DISABLE KEYS *//*!*/; # at 13556 #070618 11:51:22 server id 1 end_log_pos 13675 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_objectcache` ENABLE KEYS *//*!*/; # at 13675 #070618 11:51:22 server id 1 end_log_pos 13776 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_oldimage`/*!*/; # at 13776 #070618 11:51:22 server id 1 end_log_pos 14567 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; CREATE TABLE `blog_oldimage` ( `oi_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `oi_archive_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `oi_size` int(8) unsigned NOT NULL default '0', `oi_width` int(5) NOT NULL default '0', `oi_height` int(5) NOT NULL default '0', `oi_bits` int(3) NOT NULL default '0', `oi_description` tinyblob NOT NULL, `oi_user` int(5) unsigned NOT NULL default '0', `oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', `oi_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '', KEY `oi_name` (`oi_name`(10)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!*/; # at 14567 #070618 11:51:22 server id 1 end_log_pos 14684 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_oldimage` DISABLE KEYS *//*!*/; # at 14684 #070618 11:51:22 server id 1 end_log_pos 14800 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; /*!40000 ALTER TABLE `blog_oldimage` ENABLE KEYS *//*!*/; # at 14800 #070618 11:51:22 server id 1 end_log_pos 14897 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1182160282/*!*/; DROP TABLE IF EXISTS `blog_page`/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;