<?php
declare(strict_types=1);

return [
    'up' => "
        ALTER TABLE sa_players ADD COLUMN medical_level TINYINT UNSIGNED NULL DEFAULT NULL COMMENT '1=full, 2=moderate, 3=limited' AFTER medical_expiry_date;
        ALTER TABLE player_medical_records ADD COLUMN medical_level TINYINT UNSIGNED NULL DEFAULT NULL COMMENT '1=full, 2=moderate, 3=limited' AFTER result;
        ALTER TABLE players ADD COLUMN medical_level TINYINT UNSIGNED NULL DEFAULT NULL COMMENT '1=full, 2=moderate, 3=limited' AFTER medical_expiry_date;
    ",
    'down' => "
        ALTER TABLE sa_players DROP COLUMN medical_level;
        ALTER TABLE player_medical_records DROP COLUMN medical_level;
        ALTER TABLE players DROP COLUMN medical_level;
    ",
];
