MyFleetGirls Delete Old Version Resources

delete_of_map_image_2nd.sql

DELETE FROM map_image_2nd
WHERE EXISTS (
    SELECT 1
    FROM map_image_2nd AS m
    WHERE map_image_2nd.area_id = m.area_id
    AND map_image_2nd.info_no = m.info_no
    AND map_image_2nd.suffix = m.suffix
    AND map_image_2nd.version < m.version
);

delete_of_ship_image.sql

DELETE FROM ship_image
WHERE EXISTS (
    SELECT 1
    FROM ship_image AS s
    WHERE ship_image.id = s.id
    AND ship_image.version < s.version
);

delete_of_ship_image_2nd.sql

DELETE FROM ship_image_2nd
WHERE EXISTS (
    SELECT 1
    FROM ship_image_2nd AS s
    WHERE ship_image_2nd.id = s.id
    AND ship_image_2nd.kind = s.kind
    AND ship_image_2nd.version < s.version
);

delete_of_ship_sound.sql

DELETE FROM ship_sound
WHERE EXISTS (
    SELECT 1
    FROM ship_sound AS s
    WHERE ship_sound.ship_id = s.ship_id
    AND ship_sound.sound_id = s.sound_id
    AND ship_sound.version < s.version
);