CREATE DATABASE IF NOT EXISTS school_notes;

USE school_notes;

CREATE TABLE IF NOT EXISTS notes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    grade VARCHAR(50) NOT NULL,
    subject VARCHAR(100) NOT NULL,
    content TEXT,
    image_url VARCHAR(255),
    type ENUM('text', 'image') NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
