-- ResellBD Step 27: LLM-generated content is suggestion-only, never live catalog writes.
-- Apply only to the NEW ResellBD database after migrations 001-018.
SET NAMES utf8mb4;
ALTER TABLE ai_product_queue
  ADD COLUMN ai_suggested_title VARCHAR(240) NULL,
  ADD COLUMN ai_suggested_description TEXT NULL,
  ADD COLUMN ai_category_suggestion VARCHAR(190) NULL,
  ADD COLUMN ai_content_status ENUM('not_generated','suggested','error') NOT NULL DEFAULT 'not_generated',
  ADD COLUMN ai_content_model VARCHAR(120) NULL,
  ADD COLUMN ai_content_generated_at DATETIME NULL;
CREATE TABLE IF NOT EXISTS ai_content_runs (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 queue_id BIGINT UNSIGNED NOT NULL,
 requested_by BIGINT UNSIGNED NULL,
 status ENUM('success','error') NOT NULL,
 model VARCHAR(120) NULL,
 prompt_version VARCHAR(32) NOT NULL DEFAULT 'bn-product-v1',
 input_hash CHAR(64) NOT NULL,
 message VARCHAR(1000) NULL,
 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY(id), KEY idx_ai_content_queue_created(queue_id,created_at),
 CONSTRAINT fk_ai_content_queue FOREIGN KEY(queue_id) REFERENCES ai_product_queue(id) ON DELETE CASCADE ON UPDATE CASCADE,
 CONSTRAINT fk_ai_content_actor FOREIGN KEY(requested_by) REFERENCES users(id) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;