photo-migration.sql

insert into image (
  id,
  name,
  description,
  album_id,
  album_position,
  path,
  type,
  size,
  url,
  width,
  height,
  created_at,
  updated_at
)
select
  photo.id,
  photo.name,
  photo.description,
  photo.album_id,
  photo.album_position,
  CONCAT(photo_image.path, photo_image.filename),
  if(mime_type is null or mime_type = '', 'image/jpeg', mime_type),
  file_size,
  CONCAT('https://**********.cloudfront.net/', photo_image.path, photo_image.filename),
  photo_image.width,
  photo_image.height,
  photo.created_at,
  photo.updated_at
FROM photo
JOIN photo_image on photo.original_image_id = photo_image.id
GROUP BY (CONCAT(photo_image.path, photo_image.filename));