<?php

namespace App\Database\Migrations;

use CodeIgniter\Database\Migration;

class RemoveDuplicateCalendarConfigurationKeys extends Migration
{
    private const DUPLICATE_KEYS = [
        '1st_day_of_school',
        'Make_up_exam',
        'year_start_date',
        'registration_day',
    ];

    public function up(): void
    {
        if (! $this->db->tableExists('configuration')) {
            return;
        }

        $this->db->table('configuration')
            ->whereIn('config_key', self::DUPLICATE_KEYS)
            ->delete();
    }

    public function down(): void
    {
        // Obsolete duplicate keys should not be recreated.
    }
}