<?php

global $wpdb;

$tables = $wpdb->get_col( "SHOW TABLES LIKE '%wpmlfieldslists%'" );
foreach ( $tables as $table ) {
	if ( $wpdb->get_row( "SHOW INDEX FROM {$table} WHERE Key_name = 'PRIMARY'" ) ) {
		WP_CLI::log( "$table already has primary key" );
		continue;
	}
	$wpdb->query( "ALTER TABLE {$table} ADD COLUMN rel_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST" );
	WP_CLI::log( "Will add primary key to $table" );
}
