website/database_migrations/create_images_table.sql

-- Create images table for WYSIWYG editor
-- This table stores uploaded images for the image gallery

CREATE TABLE IF NOT EXISTS images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    filename VARCHAR(255) NOT NULL,
    original_name VARCHAR(255) NOT NULL,
    file_size INT NOT NULL,
    mime_type VARCHAR(100),
    uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    uploaded_by INT,
    INDEX idx_uploaded_at (uploaded_at),
    INDEX idx_uploaded_by (uploaded_by)
);

-- Add foreign key constraint if users table exists
-- ALTER TABLE images ADD CONSTRAINT fk_images_user FOREIGN KEY (uploaded_by) REFERENCES users(id) ON DELETE SET NULL;