CUNY Academic Commons

<?php

global $wpdb;

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

foreach ( $cr_tables as $cr_table ) {

	if ( $wpdb->get_var( "SHOW INDEX FROM {$cr_table} WHERE Key_name = 'PRIMARY'" ) ) {

		continue;

	}

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

	$wpdb->query( $query );

	WP_CLI::log( $cr_table );

}