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

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

$fields = [
    'salutation' => "VARCHAR(20) NULL",
    'first_name' => "VARCHAR(100) NULL",
    'last_name' => "VARCHAR(100) NULL",
    'nickname' => "VARCHAR(100) NULL",
    'language' => "VARCHAR(50) NULL",
    'nationality' => "VARCHAR(100) NULL",
    'birthday' => "DATE NULL",
    'phone_prefix' => "VARCHAR(10) NULL",
    'mobile_number' => "VARCHAR(20) NULL",
    'landline_prefix' => "VARCHAR(10) NULL",
    'landline' => "VARCHAR(20) NULL",
    'street' => "VARCHAR(255) NULL",
    'city' => "VARCHAR(100) NULL",
    'zipcode' => "VARCHAR(20) NULL",
    'country' => "VARCHAR(100) NULL",
    'interested_categories' => "TEXT NULL",
    'share_contact' => "TINYINT(1) DEFAULT 0",
    'receive_catalog' => "TINYINT(1) DEFAULT 0",
    'privacy_policy_accepted' => "TINYINT(1) DEFAULT 0",
    'subscribe_newsletter' => "TINYINT(1) DEFAULT 0"
];

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

echo "Migration completed.\n";
?>

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