<?php
declare(strict_types=1);

return [
    'up' => "ALTER TABLE `sa_groups`
    ADD COLUMN `min_age` TINYINT UNSIGNED NULL AFTER `monthly_fee_nonmember`,
    ADD COLUMN `max_age` TINYINT UNSIGNED NULL AFTER `min_age`;
ALTER TABLE `sa_subscriptions`
    ADD COLUMN `overdue_notified_at` TIMESTAMP NULL AFTER `receipt_number`;
ALTER TABLE `sa_group_players`
    ADD COLUMN `transferred_to_group_id` BIGINT UNSIGNED NULL AFTER `notes`,
    ADD COLUMN `transfer_reason` VARCHAR(500) NULL AFTER `transferred_to_group_id`",
    'down' => "ALTER TABLE `sa_groups`
    DROP COLUMN `max_age`,
    DROP COLUMN `min_age`;
ALTER TABLE `sa_subscriptions`
    DROP COLUMN `overdue_notified_at`;
ALTER TABLE `sa_group_players`
    DROP COLUMN `transfer_reason`,
    DROP COLUMN `transferred_to_group_id`",
];
