<?php
declare(strict_types=1);

return [
    'up' => "ALTER TABLE coaches ADD COLUMN coach_type VARCHAR(20) NOT NULL DEFAULT 'independent' AFTER employment_type;
ALTER TABLE coaches ADD INDEX idx_coaches_type (coach_type)",
    'down' => "ALTER TABLE coaches DROP INDEX idx_coaches_type;
ALTER TABLE coaches DROP COLUMN coach_type",
];
