Add Column
Current Schema
CREATE TABLE variant_media (
id INTEGER PRIMARY KEY AUTOINCREMENT,
variant_id INTEGER NOT NULL,
media_file_id INTEGER NOT NULL,
is_primary INTEGER DEFAULT 0,
display_order INTEGER DEFAULT 0,
created_at TEXT NOT NULL,
FOREIGN KEY (variant_id) REFERENCES product_variants(id) ON DELETE CASCADE,
FOREIGN KEY (media_file_id) REFERENCES media_files(id) ON DELETE CASCADE,
UNIQUE(variant_id, media_file_id)
)