<?php

/*
 * A simple script to add the commentmeta table added by WordPress 2.9
 * to all the blogs of a WordPress MU website.
 *
 * Install: Rename to .php and place in mu-plugins folder.
 *
 * Run the script by visiting Site Admin->Upgrade and upgrade all your blogs.
 *
 * Copyright Donncha O Caoimh, http://ocaoimh.ie/
 * Inspired by John's script at http://thelifeofjohn.com/blog/wordpress-mu/add-commentmeta-tables-to-an-existing-mu-installation/
 */

function add_commentmeta( $id ) {
	global $wpdb;
	if ( ! empty($wpdb->charset) )
		$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
	if ( ! empty($wpdb->collate) )
		$charset_collate .= " COLLATE $wpdb->collate";
	$db_table = $wpdb->get_blog_prefix( $id ) . "commentmeta";
	$wpdb->query( "CREATE TABLE IF NOT EXISTS $db_table (
			meta_id bigint(20) unsigned NOT NULL auto_increment,
			comment_id bigint(20) unsigned NOT NULL default '0',
			meta_key varchar(255) default NULL,
			meta_value longtext,
			PRIMARY KEY  (meta_id),
			KEY comment_id (comment_id),
			KEY meta_key (meta_key)
			) $charset_collate;" );
}

add_action( 'wpmu_upgrade_site', 'add_commentmeta' );
?>