<?php
$createTablesMySql = array(
    "
        CREATE TABLE IF NOT EXISTS schedules (
            id INT AUTO_INCREMENT PRIMARY KEY,
            class_id INT NOT NULL,
            teacher_id INT NOT NULL,
            title VARCHAR(100) NOT NULL,
            subject_id INT DEFAULT NULL,
            day_of_week INT NOT NULL,
            schedule_date DATE NOT NULL,
            starts TIME NOT NULL,
            ends TIME NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    ",


);