-- Update statement archetypes to the new Fitness Club Dynamics model
ALTER TABLE `statements`
  MODIFY COLUMN `archetype` ENUM(
    'Catalyst','Coach','Custodian','Conductor',
    'Champion','Connector','Cultivator','Calibrator',
    'Innovator','Motivator','Completer','Analyst',
    'Performer','Supporter','Organiser','Optimiser'
  ) NOT NULL;

UPDATE `statements`
SET `archetype` = CASE `archetype`
  WHEN 'Catalyst'   THEN 'Innovator'
  WHEN 'Coach'      THEN 'Motivator'
  WHEN 'Custodian'  THEN 'Completer'
  WHEN 'Conductor'  THEN 'Analyst'
  WHEN 'Champion'   THEN 'Performer'
  WHEN 'Connector'  THEN 'Supporter'
  WHEN 'Cultivator' THEN 'Organiser'
  WHEN 'Calibrator' THEN 'Optimiser'
  ELSE `archetype`
END;

ALTER TABLE `statements`
  MODIFY COLUMN `archetype` ENUM(
    'Innovator','Motivator','Completer','Analyst',
    'Performer','Supporter','Organiser','Optimiser'
  ) NOT NULL;
