ALTER TABLE rekognition_customer_profiles
  ADD COLUMN first_name_th VARCHAR(120) NULL AFTER company_group,
  ADD COLUMN first_name_en VARCHAR(120) NULL AFTER first_name_th,
  ADD COLUMN last_name_th VARCHAR(120) NULL AFTER first_name_en,
  ADD COLUMN last_name_en VARCHAR(120) NULL AFTER last_name_th,
  ADD COLUMN nickname_th VARCHAR(120) NULL AFTER last_name_en,
  ADD COLUMN nickname_en VARCHAR(120) NULL AFTER nickname_th,
  ADD COLUMN company_th VARCHAR(255) NULL AFTER nickname_en,
  ADD COLUMN company_en VARCHAR(255) NULL AFTER company_th,
  ADD KEY idx_customer_profiles_name_th (first_name_th, last_name_th),
  ADD KEY idx_customer_profiles_company_th (company_th);

UPDATE rekognition_customer_profiles
SET
  first_name_th = COALESCE(first_name_th, first_name),
  last_name_th = COALESCE(last_name_th, last_name),
  nickname_th = COALESCE(nickname_th, nickname),
  company_th = COALESCE(company_th, company);