<?php
declare(strict_types=1);

return [
    'up' => "
ALTER TABLE sa_subscriptions
    ADD COLUMN auto_generated TINYINT(1) NOT NULL DEFAULT 0 AFTER receipt_number,
    ADD COLUMN renewal_of_id BIGINT UNSIGNED NULL AFTER auto_generated,
    ADD COLUMN medical_verified TINYINT(1) NOT NULL DEFAULT 0 AFTER renewal_of_id",
    'down' => "
ALTER TABLE sa_subscriptions
    DROP COLUMN medical_verified,
    DROP COLUMN renewal_of_id,
    DROP COLUMN auto_generated"
];
