/*
 * Copyright ©  2022 Thomas J Collinson
 * All rights reserved
 */

ALTER TABLE `booked_jobs`
    ADD `uuid` CHAR(36) DEFAULT NULL NULL;

CREATE UNIQUE INDEX `booked_jobs_uuid_uindex`
    ON `booked_jobs` (`uuid`);

ALTER TABLE `invoice_accounts`
    CHANGE `icabbi_id` `dispatch_id` INT UNSIGNED NOT NULL;

ALTER TABLE `invoice_accounts`
    ADD `type` VARCHAR(15) NULL;