text: -- Convert schema '/home/jjohnston/sites/Xqursion/share/migrations/_source/deploy/25/001-auto.yml' to '/home/jjohnston/sites/Xqursion/share/migrations/_source/deploy/24/001-auto.yml':;
  
  ;
  BEGIN;
  
  ;
  DROP INDEX journey_log_fk_step_id;
  
  ;
  DROP INDEX journey_log_idx_step_id;
  
  ;
  CREATE TEMPORARY TABLE steps_temp_alter (
    id char(64) NOT NULL,
    journey_id char(64) NOT NULL,
    title varchar(255) NOT NULL,
    url varchar(4096) NOT NULL,
    dependency_group_id char(64),
    error_url varchar(4096),
    created_at datetime NOT NULL,
    updated_at datetime NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (journey_id) REFERENCES journeys(id) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  ;
  INSERT INTO steps_temp_alter( id, journey_id, title, url, dependency_group_id, error_url, created_at, updated_at) SELECT id, journey_id, title, url, dependency_group_id, error_url, created_at, updated_at FROM steps;
  
  ;
  DROP TABLE steps;
  
  ;
  CREATE TABLE steps (
    id char(64) NOT NULL,
    journey_id char(64) NOT NULL,
    title varchar(255) NOT NULL,
    url varchar(4096) NOT NULL,
    dependency_group_id char(64),
    error_url varchar(4096),
    created_at datetime NOT NULL,
    updated_at datetime NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (journey_id) REFERENCES journeys(id) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  ;
  CREATE INDEX steps_idx_journey_id02 ON steps (journey_id);
  
  ;
  INSERT INTO steps SELECT id, journey_id, title, url, dependency_group_id, error_url, created_at, updated_at FROM steps_temp_alter;
  
  ;
  DROP TABLE steps_temp_alter;
  
  ;
  
  COMMIT;
  
  