��JFIF��`�`��Viewing File: /home/u820193700/domains/throtllr.com/public_html/backend/migrate_tours_format.php

<?php
require_once 'api/db.php';

echo "Starting migration for Unified Tour Format...\n";

$queries = [
    "ALTER TABLE tours ADD COLUMN route_image_url VARCHAR(255) DEFAULT NULL AFTER image_url",
    "ALTER TABLE tours ADD COLUMN route_description TEXT DEFAULT NULL AFTER route_details",
    "ALTER TABLE tours ADD COLUMN tarmac_pc INT DEFAULT 70 AFTER route_description",
    "ALTER TABLE tours ADD COLUMN offroad_pc INT DEFAULT 30 AFTER tarmac_pc",
    "ALTER TABLE tours ADD COLUMN max_altitude VARCHAR(50) DEFAULT '14,500 ft' AFTER offroad_pc"
];

foreach ($queries as $sql) {
    if ($conn->query($sql)) {
        echo "Successfully executed: $sql\n";
    }
    else {
        echo "Error executing query: " . $conn->error . "\n";
    }
}

echo "Migration completed.\n";
?>

Back to Directory ��}�!1AQa"q2��#B��R��$3br� %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�� w�!1AQaq"2�B�� #3R�br� $4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz��?��_��+��?��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��