-- Run only when an existing local MySQL database failed V9__operation_management.sql.
-- This upgrades the pre-existing legacy movie_ticket_record table so Flyway can rerun V9.

alter table movie_ticket_record
    modify column package_id bigint unsigned null,
    modify column talent_id bigint unsigned null,
    add column package_name varchar(128) not null default '' after receive_no,
    add column merchants varchar(500) default null after package_name,
    add column talent_mobile varchar(20) default null after talent_name,
    add column talent_level varchar(64) default null after talent_mobile,
    add column card_no varchar(64) default null after talent_level,
    add column received_at datetime default null after receive_time,
    add column deleted tinyint default 0 after created_at;

update movie_ticket_record
set received_at = receive_time,
    talent_level = card_level
where received_at is null;

delete from flyway_schema_history
where version = '9' and success = 0;