--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/wp-content/themes/selecta/ocmx/ocmx-setup.php	Fri Mar 12 13:29:04 2010 +0000
@@ -0,0 +1,51 @@
+<?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;
+}
+?>
\ No newline at end of file