<?php
require_once __DIR__ . '/config.php';

try {
    $pdo = db();
    $sql = <<<SQL
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    dealer_id INT NOT NULL,
    username VARCHAR(255) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (dealer_id) REFERENCES dealers(id) ON DELETE CASCADE
);
SQL;
    $pdo->exec($sql);
    echo "Migration for users table applied successfully." . PHP_EOL;
} catch (PDOException $e) {
    die("Migration failed: " . $e->getMessage());
}