CUNY Academic Commons

<?php

global $wpdb;

$cr_tables = $wpdb->get_col( "SHOW TABLES LIKE '%etcomment_rating%'" );

foreach ( $cr_tables as $cr_table ) {

	$query = "ALTER TABLE {$cr_table} ADD COLUMN etcommentrating_id bigint(20) unsigned NOT NULL auto_increment PRIMARY KEY";

	$wpdb->query( $query );

}

$ra_tables = $wpdb->get_col( "SHOW TABLES LIKE '%etright_answer%'" );

foreach ( $ra_tables as $ra_table ) {

	$query = "ALTER TABLE {$ra_table} ADD COLUMN etrightanswer_id bigint(20) unsigned NOT NULL auto_increment PRIMARY KEY";

	$wpdb->query( $query );

}