<?php
/*
	good to use this instead of the $wpdb->query(): require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
	dbDelta($createClientsTable);
*/
function install_ocmx()
	{
		global $wpdb;
		
		$comment_table = $wpdb->prefix . "ocmx_comment_meta";	
		if(!check_table_existance($main_table)) :
			
			$comment_meta_table = "CREATE TABLE `".$comment_table."` (			
			`commentId` MEDIUMINT(8) unsigned NOT NULL PRIMARY KEY,
			`twitter` VARCHAR(255),
			`block_user` TINYINT,
			`email_subscribe` TINYINT);";
			
			mysql_query($comment_meta_table);
			$comments_sql = "SELECT * FROM $wpdb->comments";
			$comments_query = $wpdb->get_results($comments_sql);
			
			foreach($comments_query as $comment) :
				if($comment->comment_subscribe == "Y") :
					$comment_subs = "1";
				else :
					$comment_subs = "0";
				endif;
				$meta_update = $wpdb->query
					($wpdb->prepare
						("INSERT INTO $comment_table
							(commentId, twitter, email_subscribe)
						VALUES
							(%d, %s, %s);", 
						$comment->comment_ID, "", $comment_subs)
					);
			endforeach;
		endif;
	}
	
function check_table_existance($new_table) {
	global $wpdb;
	
	foreach ($wpdb->get_col("SHOW TABLES",0) as $table ) {
		if ($table == $new_table) {
			return true;
		}
	}
	return false;
}
?>