<?php
$dsn = "mysql:host=127.0.0.1;dbname=ibvte;charset=utf8mb4";
$pdo = new PDO($dsn, 'root', '', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);

$pdo->exec("CREATE TABLE IF NOT EXISTS notifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content TEXT,
    image_path VARCHAR(255),
    pdf_path VARCHAR(255),
    is_marquee TINYINT(1) DEFAULT 0,
    status ENUM('active', 'inactive') DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

$pdo->exec("CREATE TABLE IF NOT EXISTS sliders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    description TEXT,
    image_path VARCHAR(255) NOT NULL,
    button_text VARCHAR(100),
    button_link VARCHAR(255),
    status ENUM('active', 'inactive') DEFAULT 'active',
    display_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

try { $pdo->exec("ALTER TABLE student_results ADD COLUMN semester INT DEFAULT 1"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE students ADD COLUMN current_semester INT DEFAULT 1"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE students ADD COLUMN course_duration_years INT DEFAULT 1"); } catch(Exception $e) {}

echo "Done.\n";