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

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

$fields = [
    'bike_owned' => "VARCHAR(100) NULL DEFAULT NULL",
    'bike_number' => "VARCHAR(50) NULL DEFAULT NULL"
];

foreach ($fields as $field => $type) {
    $check = $conn->query("SHOW COLUMNS FROM users LIKE '$field'");
    if ($check->num_rows == 0) {
        if ($conn->query("ALTER TABLE users ADD `$field` $type")) {
            echo "Added field: $field\n";
        } else {
            echo "Error adding field $field: " . $conn->error . "\n";
        }
    } else {
        echo "Field already exists: $field\n";
    }
}

echo "Bike fields migration completed.\n";
?>

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