-- Removes Member Name from existing customers table.

SET @db_name = DATABASE();
SET @sql = (
  SELECT IF(
    COUNT(*) > 0,
    'ALTER TABLE `customers` DROP COLUMN `cust_member_name`',
    'SELECT 1'
  )
  FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA = @db_name
    AND TABLE_NAME = 'customers'
    AND COLUMN_NAME = 'cust_member_name'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;