ALTER TABLE `project_visual_assets`
  ADD COLUMN `aliases_json` JSON NULL,
  ADD COLUMN `allowed_roles_json` JSON NULL,
  ADD COLUMN `detected_from` VARCHAR(160) NULL,
  ADD COLUMN `importance` INT NOT NULL DEFAULT 50,
  ADD COLUMN `visual_lock` LONGTEXT NULL,
  ADD COLUMN `key_objects_json` JSON NULL,
  ADD COLUMN `prompt_block` LONGTEXT NULL,
  ADD COLUMN `anchor_prompt` LONGTEXT NULL,
  ADD COLUMN `reference_images_json` JSON NULL,
  ADD COLUMN `anchor_images_json` JSON NULL,
  ADD COLUMN `render_variants_json` JSON NULL,
  ADD COLUMN `linked_assets_json` JSON NULL,
  ADD COLUMN `reuse_rule` LONGTEXT NULL,
  ADD COLUMN `story_scope` VARCHAR(120) NULL,
  ADD COLUMN `version_note` LONGTEXT NULL,
  ADD COLUMN `notes` LONGTEXT NULL;

CREATE INDEX `pva_project_ownership_idx` ON `project_visual_assets`(`project_id`, `ownership_type`);
CREATE INDEX `pva_project_status_importance_idx` ON `project_visual_assets`(`project_id`, `status`, `importance`);