-- V46__poster_local_assets.sql
-- 목적: event.poster_url 외부 핫링크(kintex.com imageView.do — 브라우저 안 뜸)를
--       빌드 내장 정적자산(/media/posters/kx-<atchmnflNo>-<fileseq>.jpg)으로 교체.
-- 원천: kintex.com 공개 홍보 포스터(내부 데모용). 크롤·축소(가로≤480, jpg q78, ~16~59KB).
-- 자산: src/frontend/public/media/posters/ → Vite dist 루트 → GET /media/posters/<file>.
-- 멱등: URL 자연키 WHERE 조건 매칭. 재실행 시 이미 교체된 행은 매칭 안 됨(불변).
--       정상/타 URL 및 미크롤 event 는 손대지 않음 → 그라디언트 폴백 유지.
-- 스코프: tenant_id='KINTEX'. V32·V39·V42 가 같은 URL 공유 시 일괄 갱신됨.

UPDATE event SET poster_url = '/media/posters/kx-468958-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=468958&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-468981-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=468981&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469060-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469060&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469082-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469082&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469112-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469112&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469129-6.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469129&fileseq=6';
UPDATE event SET poster_url = '/media/posters/kx-469133-36.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469133&fileseq=36';
UPDATE event SET poster_url = '/media/posters/kx-469147-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469147&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469162-9.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469162&fileseq=9';
UPDATE event SET poster_url = '/media/posters/kx-469163-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469163&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469174-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469174&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469177-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469177&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469185-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469185&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469186-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469186&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469201-3.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469201&fileseq=3';
UPDATE event SET poster_url = '/media/posters/kx-469204-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469204&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469205-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469205&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469207-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469207&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469219-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469219&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469220-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469220&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469230-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469230&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469236-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469236&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469240-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469240&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469244-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469244&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469246-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469246&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469247-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469247&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469249-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469249&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469254-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469254&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469256-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469256&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469262-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469262&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469266-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469266&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469276-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469276&fileseq=1';
UPDATE event SET poster_url = '/media/posters/kx-469277-2.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469277&fileseq=2';
UPDATE event SET poster_url = '/media/posters/kx-469283-1.jpg'
 WHERE tenant_id = 'KINTEX'
   AND poster_url = 'https://www.kintex.com/imageView.do?atchmnflNo=469283&fileseq=1';
