www
21 lines
959 B
SQL
21 lines
959 B
SQL
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`);
|