CUNY Academic Commons

<?php

global $wpdb;

$tables = $wpdb->get_col( "SHOW TABLES LIKE '%statpress%'" );

foreach ( $tables as $table ) {

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

		continue;

	}

	$wpdb->query( "ALTER TABLE {$table} ADD PRIMARY KEY (id)" );

	WP_CLI::log( $table );

}