-- Phase 5: async image processing queue
CREATE TABLE IF NOT EXISTS image_processing_jobs (
    id              BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    uploaded_file_id BIGINT UNSIGNED NOT NULL,
    status          ENUM('pending','processing','completed','failed') NOT NULL DEFAULT 'pending',
    thumbnail_path  VARCHAR(500) NULL,
    error_message   VARCHAR(1000) NULL,
    retry_count     INT UNSIGNED NOT NULL DEFAULT 0,
    created_at      TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    processed_at     TIMESTAMP NULL,
    PRIMARY KEY (id),
    INDEX idx_status_created (status, created_at),
    INDEX idx_uploaded_file (uploaded_file_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
