<?php
global $wpdb;

$company_table_name = $wpdb->prefix . 'bw_winners_companies';
$query = "ALTER TABLE $company_table_name DROP INDEX import_id;";

$wpdb->query( $query );
if ( $wpdb->last_error ) {
	if ( $wpdb->last_error = "Can't DROP 'import_id'; check that column/key exists" ) {
		$wpdb->last_error = false;
	} else {
		return $wpdb->last_error;
	}
}

$query = "ALTER TABLE $company_table_name DROP COLUMN import_id;";
$wpdb->query( $query );
if ( $wpdb->last_error ) {
	return $wpdb->last_error;
}


// $query = "ALTER TABLE $company_table_name ADD import_id VARCHAR(200);";
// $wpdb->query( $query );
// if ( $wpdb->last_error ) {
// 	return $wpdb->last_error;
// }

// $query = "ALTER TABLE $company_table_name ADD CONSTRAINT import_id UNIQUE(import_id);";
// $wpdb->query( $query );
// if ( $wpdb->last_error ) {
// 	return $wpdb->last_error;
// }

// $query = "UPDATE $company_table_name SET import_id = TRIM(BOTH '-' FROM REGEXP_REPLACE(LOWER( name ), '[^0-9a-z ]+', '-'));";

// $wpdb->query( $query );
// if ( $wpdb->last_error ) {
// 	return $wpdb->last_error;
// }


return false;