<?php
require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';
$db = DB();

$db->query("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
)");

$db->query("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 {
    $db->query("ALTER TABLE student_results ADD COLUMN semester INT DEFAULT 1");
} catch(Exception $e) {}

try {
    $db->query("ALTER TABLE students ADD COLUMN current_semester INT DEFAULT 1");
} catch(Exception $e) {}

echo "Tables created successfully.\n";