<?php
declare(strict_types=1);

return [
    'up' => "
ALTER TABLE hr_departments ADD COLUMN department_type VARCHAR(10) NOT NULL DEFAULT 'qism' COMMENT 'idara=إدارة (top-level), qism=قسم (under idara)' AFTER department_code;
ALTER TABLE hr_departments ADD CONSTRAINT chk_hr_dept_type CHECK (department_type IN ('idara', 'qism'))
",
    'down' => "
ALTER TABLE hr_departments DROP CONSTRAINT chk_hr_dept_type;
ALTER TABLE hr_departments DROP COLUMN department_type
",
];
