<?php
declare(strict_types=1);

return [
    'up' => "ALTER TABLE sa_coaches ADD COLUMN coach_type VARCHAR(20) NOT NULL DEFAULT 'independent' AFTER employment_type;
ALTER TABLE sa_coaches ADD COLUMN academy_id BIGINT UNSIGNED NULL AFTER coach_type;
ALTER TABLE sa_coaches ADD INDEX idx_sa_coaches_type (coach_type);
ALTER TABLE sa_coaches ADD INDEX idx_sa_coaches_academy (academy_id)",
    'down' => "ALTER TABLE sa_coaches DROP INDEX idx_sa_coaches_academy;
ALTER TABLE sa_coaches DROP INDEX idx_sa_coaches_type;
ALTER TABLE sa_coaches DROP COLUMN academy_id;
ALTER TABLE sa_coaches DROP COLUMN coach_type",
];
