<?php
/*
Original version by John James Jacoby
This tweaked version is by Ron Rennick

*/
/*
 * This function will loop through all blogs and
 * add the commentmeta table to each of them.
 * ------------------------------------------
 * Recommended usage: Add to functions.php and run one time,
 * or add to /mu-plugins/ and refresh page one time.
 */

add_action ( 'init', 'jjj_add_commentmeta' );
function jjj_add_commentmeta() {
	global $wpdb, $wpmu_version;

	/* Already done? If so, stop */
	$already_done = get_site_option( 'jjj_commentmeta' );
	if ( isset( $already_done ) && !empty( $already_done ) )
		return false;

	/* Check WP version, and if this has been done before */
	$method = ( isset( $wpmu_version ) ? 'mu' : 'su' );
	
	/* Get Charset */
	if ( $wpdb->has_cap( 'collation' ) ) {
		if ( ! empty($wpdb->charset) )
			$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
		if ( ! empty($wpdb->collate) )
			$charset_collate .= " COLLATE $wpdb->collate";
	}

	/* Meaty */
	switch ( $method ) {
		case 'mu':
			$blogs = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs ORDER BY registered DESC" );

			foreach ( $blogs as $blog_id ) {
				$table_name = $wpdb->get_blog_prefix( $blog_id ) . 'commentmeta';
				$commentmeta = $wpdb->query( "CREATE TABLE $table_name ( 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;" );
			}
			break;
		case 'su':
		default:
			$table_name = $wpdb->prefix . 'commentmeta';
			$commentmeta = $wpdb->query( "CREATE TABLE $table_name ( 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;" );

			break;
	}
	update_site_option( 'jjj_commentmeta', '1' );
}

?>