-- Create disciplinary_logs table
CREATE TABLE disciplinary_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    staff_id INT NOT NULL,
    date DATE NOT NULL,
    issued_by VARCHAR(255) NOT NULL,
    disciplinary_level VARCHAR(255) NOT NULL,
    details TEXT NOT NULL,
    image_links TEXT NOT NULL,
    last_edited_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (staff_id) REFERENCES staff_members(id) ON DELETE CASCADE
);
