<?php
declare(strict_types=1);

return [
    'up' => "
ALTER TABLE `sa_groups`
    ADD COLUMN `source_type` VARCHAR(30) NULL DEFAULT NULL COMMENT 'NULL=normal, pool_reservation=created by reservation wizard' AFTER `status`,
    ADD COLUMN `pool_reservation_id` BIGINT UNSIGNED NULL AFTER `source_type`,
    ADD INDEX `idx_sa_grp_source` (`source_type`)
",
    'down' => "
ALTER TABLE `sa_groups`
    DROP INDEX `idx_sa_grp_source`,
    DROP COLUMN `pool_reservation_id`,
    DROP COLUMN `source_type`
",
];
