<?php
$createTablesMySql = array(
    "
        CREATE TABLE IF NOT EXISTS classes (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(50) NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",


    "
        CREATE TABLE IF NOT EXISTS class_students (
            class_id INT NOT NULL,
            student_id INT NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (class_id, student_id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",

    "
        CREATE TABLE IF NOT EXISTS teacher_classes (
            teacher_id INT NOT NULL,
            class_id INT NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (teacher_id, class_id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",

    "
        CREATE TABLE IF NOT EXISTS parents_students (
            student_id INT NOT NULL,
            parent_id INT NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (student_id, parent_id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",

    "
        CREATE TABLE IF NOT EXISTS event_class_bind (
            id INT AUTO_INCREMENT PRIMARY KEY,
            event_id INT NOT NULL,
            class_id INT NOT NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",

    "
        CREATE TABLE IF NOT EXISTS subjects (
            id INT AUTO_INCREMENT PRIMARY KEY,
            subject VARCHAR(255) NOT NULL,
            type VARCHAR(255) DEFAULT NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",

    "
        CREATE TABLE IF NOT EXISTS teacher_subjects (
            teacher_id INT NOT NULL,
            subject_id INT NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (teacher_id, subject_id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",


);