<?php
declare(strict_types=1);

return [
    'up' => "
        ALTER TABLE `sa_group_players`
            ADD COLUMN `payment_request_id` BIGINT UNSIGNED NULL AFTER `created_by`,
            ADD COLUMN `activated_by_payment_id` BIGINT UNSIGNED NULL AFTER `payment_request_id`,
            MODIFY COLUMN `status` VARCHAR(20) NOT NULL DEFAULT 'pending_payment' COMMENT 'pending_payment, active, paused, transferred, withdrawn'
    ",
    'down' => "
        ALTER TABLE `sa_group_players`
            DROP COLUMN `payment_request_id`,
            DROP COLUMN `activated_by_payment_id`,
            MODIFY COLUMN `status` VARCHAR(20) NOT NULL DEFAULT 'active' COMMENT 'active, paused, transferred, withdrawn'
    ",
];
