<?php
declare(strict_types=1);

return [
    'up' => "ALTER TABLE `reservations`
    ADD COLUMN `is_archived` TINYINT(1) NOT NULL DEFAULT 0 AFTER `created_by`,
    ADD COLUMN `archived_at` TIMESTAMP NULL DEFAULT NULL AFTER `is_archived`,
    ADD COLUMN `archived_by` BIGINT UNSIGNED NULL AFTER `archived_at`;

    ALTER TABLE `activity_subscriptions`
    ADD COLUMN `is_archived` TINYINT(1) NOT NULL DEFAULT 0 AFTER `created_by`,
    ADD COLUMN `archived_at` TIMESTAMP NULL DEFAULT NULL AFTER `is_archived`,
    ADD COLUMN `archived_by` BIGINT UNSIGNED NULL AFTER `archived_at`",
    'down' => "ALTER TABLE `reservations`
    DROP COLUMN `archived_by`,
    DROP COLUMN `archived_at`,
    DROP COLUMN `is_archived`;

    ALTER TABLE `activity_subscriptions`
    DROP COLUMN `archived_by`,
    DROP COLUMN `archived_at`,
    DROP COLUMN `is_archived`",
];
