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

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

echo "Starting Booking V2 Migration...\n";

// 1. Update bookings table
$alter_bookings = [
    "ALTER TABLE bookings ADD COLUMN IF NOT EXISTS rider_type ENUM('single', 'with_passenger', 'only_passenger') NOT NULL DEFAULT 'single' AFTER payment_status",
    "ALTER TABLE bookings ADD COLUMN IF NOT EXISTS solo_count INT(11) DEFAULT 1 AFTER rider_type",
    "ALTER TABLE bookings ADD COLUMN IF NOT EXISTS passenger_count INT(11) DEFAULT 0 AFTER solo_count",
    "ALTER TABLE bookings ADD COLUMN IF NOT EXISTS total_amount DECIMAL(10,2) DEFAULT 0.00 AFTER passenger_count"
];

foreach ($alter_bookings as $sql) {
    if ($conn->query($sql)) {
        echo "Executed: $sql\n";
    }
    else {
        echo "Error or Skip: " . $conn->error . "\n";
    }
}

// 2. Create booking_passengers table
$passengers_table = "CREATE TABLE IF NOT EXISTS booking_passengers (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    booking_id INT(11) NOT NULL,
    full_name VARCHAR(255) NOT NULL,
    age INT(11),
    gender ENUM('male', 'female', 'other', 'prefer_not_to_say'),
    emergency_contact VARCHAR(20),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE
)";
if ($conn->query($passengers_table)) {
    echo "Created booking_passengers table.\n";
}
else {
    echo "Error creating booking_passengers: " . $conn->error . "\n";
}

// 3. Create booking_addons table (to snapshot prices)
$booking_addons_table = "CREATE TABLE IF NOT EXISTS booking_addons (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    booking_id INT(11) NOT NULL,
    addon_id INT(11) NOT NULL,
    label VARCHAR(150),
    price DECIMAL(10,2),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE
)";
if ($conn->query($booking_addons_table)) {
    echo "Created booking_addons table.\n";
}
else {
    echo "Error creating booking_addons: " . $conn->error . "\n";
}

echo "Migration finished.\n";
?>

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