a:58:{i:0;a:3:{i:0;i:1;i:1;s:40:"Plugin activated at 2014-09-18 09:40:03.";i:2;N;}i:1;a:3:{i:0;i:1;i:1;s:27:"Installation/update begins.";i:2;N;}i:2;a:3:{i:0;i:1;i:1;s:25:"Upgrading the database...";i:2;N;}i:3;a:3:{i:0;i:1;i:1;s:31:"... SHOW TABLES (0.001 seconds)";i:2;N;}i:4;a:3:{i:0;i:1;i:1;s:238:" [OK] 	
	CREATE TABLE IF NOT EXISTS `wp_blc_filters` (
		`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`name` varchar(100) NOT NULL,
		`params` text NOT NULL,
		
		PRIMARY KEY (`id`)
	) DEFAULT CHARACTER SET utf8 (0.007 seconds)";i:2;N;}i:5;a:3:{i:0;i:1;i:1;s:705:" [OK] 
	
	CREATE TABLE IF NOT EXISTS `wp_blc_instances` (
		`instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`link_id` int(10) unsigned NOT NULL,
		`container_id` int(10) unsigned NOT NULL,
		`container_type` varchar(40) NOT NULL DEFAULT 'post',
		`link_text` varchar(250) NOT NULL DEFAULT '',
		`parser_type` varchar(40) NOT NULL DEFAULT 'link',
		`container_field` varchar(250) NOT NULL DEFAULT '',
		`link_context` varchar(250) NOT NULL DEFAULT '',
		`raw_url` text NOT NULL,
		  
		PRIMARY KEY (`instance_id`),
		KEY `link_id` (`link_id`),
		KEY `source_id` (`container_type`, `container_id`),
		KEY `parser_type` (`parser_type`)
	) DEFAULT CHARACTER SET utf8 (0.007 seconds)";i:2;N;}i:6;a:3:{i:0;i:1;i:1;s:1407:" [OK] 
	
	CREATE TABLE IF NOT EXISTS `wp_blc_links` (
		`link_id` int(20) unsigned NOT NULL AUTO_INCREMENT,
		`url` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
		`first_failure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`last_success` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`last_check_attempt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`check_count` int(4) unsigned NOT NULL DEFAULT '0',
		`final_url` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
		`redirect_count` smallint(5) unsigned NOT NULL DEFAULT '0',
		`log` text NOT NULL,
		`http_code` smallint(6) NOT NULL DEFAULT '0',
		`status_code` varchar(100) DEFAULT '',
		`status_text` varchar(250) DEFAULT '',
		`request_duration` float NOT NULL DEFAULT '0',
		`timeout` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`broken` tinyint(1) NOT NULL DEFAULT '0',
		`may_recheck` tinyint(1) NOT NULL DEFAULT '1',
		`being_checked` tinyint(1) NOT NULL DEFAULT '0',

		`result_hash` varchar(200) NOT NULL DEFAULT '',
		`false_positive` tinyint(1) NOT NULL DEFAULT '0',
		`dismissed` tinyint(1) NOT NULL DEFAULT '0',
		
		PRIMARY KEY (`link_id`),
		KEY `url` (`url`(150)),
		KEY `final_url` (`final_url`(150)),
		KEY `http_code` (`http_code`),
		KEY `broken` (`broken`)
	) DEFAULT CHARACTER SET utf8 (0.006 seconds)";i:2;N;}i:7;a:3:{i:0;i:1;i:1;s:380:" [OK] 
	
	CREATE TABLE IF NOT EXISTS `wp_blc_synch` (
		`container_id` int(20) unsigned NOT NULL,
		`container_type` varchar(40) NOT NULL,
		`synched` tinyint(2) unsigned NOT NULL,
		`last_synch` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		
		PRIMARY KEY (`container_type`,`container_id`),
		KEY `synched` (`synched`)
	) DEFAULT CHARACTER SET utf8 (0.006 seconds)";i:2;N;}i:8;a:3:{i:0;i:1;i:1;s:32:"Schema update took 0.027 seconds";i:2;N;}i:9;a:3:{i:0;i:1;i:1;s:24:"Database schema updated.";i:2;N;}i:10;a:3:{i:0;i:1;i:1;s:31:"Database successfully upgraded.";i:2;N;}i:11;a:3:{i:0;i:1;i:1;s:24:"--- Total: 0.032 seconds";i:2;N;}i:12;a:3:{i:0;i:1;i:1;s:27:"Cleaning up the database...";i:2;N;}i:13;a:3:{i:0;i:1;i:1;s:38:"... Deleting invalid container records";i:2;N;}i:14;a:3:{i:0;i:0;i:1;s:44:"... 0 synch records deleted in 0.004 seconds";i:2;N;}i:15;a:3:{i:0;i:1;i:1;s:35:"... Deleting invalid link instances";i:2;N;}i:16;a:3:{i:0;i:0;i:1;s:40:"... 0 instances deleted in 0.004 seconds";i:2;N;}i:17;a:3:{i:0;i:0;i:1;s:45:"... 0 more instances deleted in 0.000 seconds";i:2;N;}i:18;a:3:{i:0;i:1;i:1;s:27:"... Deleting orphaned links";i:2;N;}i:19;a:3:{i:0;i:0;i:1;s:36:"... 0 links deleted in 0.004 seconds";i:2;N;}i:20;a:3:{i:0;i:1;i:1;s:24:"--- Total: 0.012 seconds";i:2;N;}i:21;a:3:{i:0;i:1;i:1;s:20:"Notifying modules...";i:2;N;}i:22;a:3:{i:0;i:0;i:1;s:25:"... Updating module cache";i:2;N;}i:23;a:3:{i:0;i:1;i:1;s:36:"... Cache refresh took 0.000 seconds";i:2;N;}i:24;a:3:{i:0;i:0;i:1;s:19:"... Loading modules";i:2;N;}i:25;a:3:{i:0;i:1;i:1;s:37:"... 5 modules loaded in 0.002 seconds";i:2;N;}i:26;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "http"";i:2;N;}i:27;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "link"";i:2;N;}i:28;a:3:{i:0;i:0;i:1;s:28:"... Notifying module "image"";i:2;N;}i:29;a:3:{i:0;i:0;i:1;s:31:"... Notifying module "metadata"";i:2;N;}i:30;a:3:{i:0;i:0;i:1;s:32:"... Notifying module "url_field"";i:2;N;}i:31;a:3:{i:0;i:0;i:1;s:30:"... Notifying module "comment"";i:2;N;}i:32;a:3:{i:0;i:0;i:1;s:51:"...... Deleting synch. records for removed comments";i:2;N;}i:33;a:3:{i:0;i:0;i:1;s:38:"...... 0 rows deleted in 0.000 seconds";i:2;N;}i:34;a:3:{i:0;i:0;i:1;s:47:"...... Creating synch. records for new comments";i:2;N;}i:35;a:3:{i:0;i:0;i:1;s:39:"...... 0 rows inserted in 0.001 seconds";i:2;N;}i:36;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "post"";i:2;N;}i:37;a:3:{i:0;i:0;i:1;s:47:"...... Deleting synch records for removed posts";i:2;N;}i:38;a:3:{i:0;i:0;i:1;s:207:"DELETE synch.*
				  FROM 
					 wp_blc_synch AS synch LEFT JOIN wp_posts AS posts
					 ON posts.ID = synch.container_id
				  WHERE 
					 synch.container_type IN ('post', 'page') AND posts.ID IS NULL";i:2;N;}i:39;a:3:{i:0;i:0;i:1;s:38:"...... 0 rows deleted in 0.000 seconds";i:2;N;}i:40;a:3:{i:0;i:0;i:1;s:41:"...... Marking changed posts as unsynched";i:2;N;}i:41;a:3:{i:0;i:0;i:1;s:227:"UPDATE
					wp_blc_synch AS synch
					JOIN wp_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)
				  SET 
					synched = 0
				  WHERE
					synch.last_synch < posts.post_modified";i:2;N;}i:42;a:3:{i:0;i:0;i:1;s:38:"...... 0 rows updated in 0.000 seconds";i:2;N;}i:43;a:3:{i:0;i:0;i:1;s:43:"...... Creating synch records for new posts";i:2;N;}i:44;a:3:{i:0;i:0;i:1;s:400:"INSERT INTO wp_blc_synch(container_id, container_type, synched)
				  SELECT posts.id, posts.post_type, 0
				  FROM 
				    wp_posts AS posts LEFT JOIN wp_blc_synch AS synch
					ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)  
				  WHERE
				  	posts.post_status IN ('publish')
	 				AND posts.post_type IN ('post', 'page')
					AND synch.container_id IS NULL";i:2;N;}i:45;a:3:{i:0;i:0;i:1;s:40:"...... 13 rows inserted in 0.001 seconds";i:2;N;}i:46;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "page"";i:2;N;}i:47;a:3:{i:0;i:0;i:1;s:74:"...... Skipping "page" resyncyh since all post types were already synched.";i:2;N;}i:48;a:3:{i:0;i:0;i:1;s:28:"... Notifying module "dummy"";i:2;N;}i:49;a:3:{i:0;i:1;i:1;s:24:"--- Total: 0.011 seconds";i:2;N;}i:50;a:3:{i:0;i:1;i:1;s:38:"Updating server load limit settings...";i:2;N;}i:51;a:3:{i:0;i:1;i:1;s:59:"Set server load limit to 4.00. Current load average is 0.00";i:2;N;}i:52;a:3:{i:0;i:1;i:1;s:26:"Optimizing the database...";i:2;N;}i:53;a:3:{i:0;i:1;i:1;s:24:"--- Total: 0.001 seconds";i:2;N;}i:54;a:3:{i:0;i:1;i:1;s:26:"Completing installation...";i:2;N;}i:55;a:3:{i:0;i:1;i:1;s:20:"Configuration saved.";i:2;N;}i:56;a:3:{i:0;i:1;i:1;s:78:"Installation/update completed at 2014-09-18 09:40:03 with 23 queries executed.";i:2;N;}i:57;a:3:{i:0;i:1;i:1;s:25:"Total time: 0.102 seconds";i:2;N;}}