SWAMPy

✎ CARVE FLESH

EDITING: 003_fix_absolute_image_urls.sql

-- Backfill existing product/variant/payment-proof image URLs from absolute
-- (domain-baked) URLs to relative paths, matching the fix in FileUpload.php.
--
-- Any row that already looks relative (starts with "assets/uploads/") is
-- left untouched. Any row that's absolute but contains "assets/uploads/"
-- gets everything from that point onward kept, and the old domain/scheme
-- stripped off.

UPDATE product_images
SET image_url = SUBSTRING(image_url, LOCATE('assets/uploads/', image_url))
WHERE image_url LIKE '%assets/uploads/%'
  AND image_url NOT LIKE 'assets/uploads/%';

UPDATE payment_proofs
SET image_url = SUBSTRING(image_url, LOCATE('assets/uploads/', image_url))
WHERE image_url LIKE '%assets/uploads/%'
  AND image_url NOT LIKE 'assets/uploads/%';

-- Only run if the variant_images table exists (added in migration 002).
UPDATE variant_images
SET image_url = SUBSTRING(image_url, LOCATE('assets/uploads/', image_url))
WHERE image_url LIKE '%assets/uploads/%'
  AND image_url NOT LIKE 'assets/uploads/%';

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📄 001_add_password_reset_columns.sql	SQL	254 B	2026-07-15 09:17	EDIT
📄 002_add_variant_images.sql	SQL	710 B	2026-07-15 09:17	EDIT
📄 003_fix_absolute_image_urls.sql	SQL	1021 B	2026-07-15 09:17	EDIT
📄 004_addresses_nullable_user_id.sql	SQL	599 B	2026-07-15 09:17	EDIT