-- Store product and category images as binary inside their own rows. Run once on fashion_shop.
-- (The old `url` column stays, so sample-data photos that are web links keep working.)
ALTER TABLE product_images
  MODIFY url VARCHAR(500) NULL,
  ADD COLUMN mime VARCHAR(100) NULL AFTER url,
  ADD COLUMN sha1 CHAR(40) NULL AFTER mime,
  ADD COLUMN image_data LONGBLOB NULL AFTER sha1,
  ADD COLUMN thumb_data MEDIUMBLOB NULL AFTER image_data;

ALTER TABLE categories
  ADD COLUMN image_mime VARCHAR(100) NULL AFTER image_url,
  ADD COLUMN image_sha1 CHAR(40) NULL AFTER image_mime,
  ADD COLUMN image_data MEDIUMBLOB NULL AFTER image_sha1;