<?php

class Migration_20240906175620_fix_resources_tbl_data
{
    public static function up(PDO $pdo)
    {
        $sql = "
                UPDATE resources SET dataPage = 'include/properties/my_properties.php' WHERE id = 3;
                UPDATE resources SET dataPage = 'include/properties/rolestbl.php' WHERE id = 6;
                UPDATE resources SET dataPage = 'include/admin/admin_setup.php' WHERE id = 14;
                UPDATE resources SET dataPage = 'include/admin/dealer_setup.php' WHERE id = 15;
                UPDATE resources SET slug = 'dashboard.php?tab=dealer_setup' WHERE id = 15;
            ";

        $pdo->exec($sql);
    }

    public static function down(PDO $pdo)
    {
        $sql = "
            DROP TABLE IF EXISTS `resources`;
        ";

        $pdo->exec($sql);
    }
}