Files
gupi-osint-board/migrations/040_edge_to_edge_clipping_cards.sql

9 lines
252 B
SQL

UPDATE osint.exhibits AS exhibit
SET height = 220,
updated_at = NOW()
FROM osint.document_exhibits AS document
WHERE document.exhibit_id = exhibit.id
AND document.capture_kind_id = 'clipping'
AND exhibit.width = 220
AND exhibit.height = 272;