9 lines
243 B
SQL
9 lines
243 B
SQL
|
ALTER TABLE image_assets
|
||
|
|
ADD COLUMN content_hash VARCHAR(64);
|
||
|
|
|
||
|
|
CREATE INDEX idx_image_assets_tenant_content_hash_active
|
||
|
|
ON image_assets (tenant_id, content_hash)
|
||
|
|
WHERE content_hash IS NOT NULL
|
||
|
|
AND status = 'active'
|
||
|
|
AND deleted_at IS NULL;
|