0xn0l

📂 /home/brightbrai/public_html/school/api

✎ EDIT: setup_db.php ← BACK

<?php
require_once 'config.php';

header('Content-Type: text/plain');

echo "Starting Database Setup...\n";

$tables = [
    "school_profile" => "CREATE TABLE IF NOT EXISTS school_profile (
        id INT PRIMARY KEY AUTO_INCREMENT,
        name VARCHAR(255),
        address TEXT,
        contact VARCHAR(50),
        email VARCHAR(100),
        logoUrl TEXT
    )",
    "students" => "CREATE TABLE IF NOT EXISTS students (
        id VARCHAR(50) PRIMARY KEY,
        grNo VARCHAR(50),
        firstName VARCHAR(100),
        lastName VARCHAR(100),
        gender VARCHAR(20),
        fatherName VARCHAR(100),
        dateOfAdmission DATE,
        currentClass VARCHAR(50),
        section VARCHAR(50),
        status VARCHAR(20)
    )",
    "staff" => "CREATE TABLE IF NOT EXISTS staff (
        id VARCHAR(50) PRIMARY KEY,
        name VARCHAR(255),
        role VARCHAR(100),
        email VARCHAR(100),
        phone VARCHAR(50),
        status VARCHAR(20),
        salary DECIMAL(10, 2),
        joiningDate DATE,
        timetable TEXT
    )",
    "fee_records" => "CREATE TABLE IF NOT EXISTS fee_records (
        id VARCHAR(50) PRIMARY KEY,
        studentId VARCHAR(50),
        amount DECIMAL(10, 2),
        dueDate DATE,
        status VARCHAR(20),
        type VARCHAR(50),
        month VARCHAR(20)
    )",
    "exams" => "CREATE TABLE IF NOT EXISTS exams (
        id VARCHAR(50) PRIMARY KEY,
        title VARCHAR(255),
        startDate DATE,
        endDate DATE,
        status VARCHAR(20)
    )",
    "attendance" => "CREATE TABLE IF NOT EXISTS attendance (
        id VARCHAR(50) PRIMARY KEY,
        studentId VARCHAR(50),
        date DATE,
        status VARCHAR(20)
    )"
];

foreach ($tables as $name => $sql) {
    try {
        // Drop table if it exists to ensure new schema is applied
        $pdo->exec("DROP TABLE IF EXISTS $name");
        $pdo->exec($sql);
        echo "Table '$name' created.\n";
    } catch (PDOException $e) {
        echo "Error creating table '$name': " . $e->getMessage() . "\n";
    }
}

// Insert default profile if empty
$stmt = $pdo->query("SELECT COUNT(*) FROM school_profile");
if ($stmt->fetchColumn() == 0) {
    $pdo->exec("INSERT INTO school_profile (name, address, contact, email) VALUES ('My School', 'School Address', '123-456-789', 'admin@school.com')");
    echo "Default school profile inserted.\n";
}

echo "\nSetup Complete!";
?>

0xn0l - 0011000001111000011011100011000001101100