<?php
declare(strict_types=1);

return function (\App\Core\Database $db): void {
    $db->raw("
        ALTER TABLE `members`
        ADD COLUMN `regulatory_discount_id` BIGINT UNSIGNED NULL AFTER `discount_amount`,
        ADD COLUMN `regulatory_discount_amount` DECIMAL(15,2) NULL AFTER `regulatory_discount_id`,
        ADD COLUMN `regulatory_discount_document` VARCHAR(500) NULL AFTER `regulatory_discount_amount`,
        ADD INDEX `idx_members_regulatory_discount` (`regulatory_discount_id`)
    ");
};
