CALL calculate_maximal_moveable_set(4,2);
CREATE TEMPORARY TABLE `rps` (`id` MEDIUMINT, UNIQUE INDEX (`id`));
INSERT IGNORE INTO `rps` (`id`) SELECT `moveable_bpir`.`to_repository` FROM `moveable_bpir`;
INSERT IGNORE INTO `rps` (`id`) SELECT `binary_packages_in_repositories`.`repository` FROM `moveable_bpir` JOIN `binary_packages_in_repositories` ON `moveable_bpir`.`id`=`binary_packages_in_repositories`.`id`;
INSERT IGNORE INTO `rps` (`id`) SELECT `binary_packages_in_repositories`.`repository` FROM `replaced_bpir` JOIN `binary_packages_in_repositories` ON `replaced_bpir`.`id`=`binary_packages_in_repositories`.`id`;
SELECT "repositories",`architectures`.`name`,`repositories`.`name` FROM `rps` JOIN `repositories` ON `rps`.`id`=`repositories`.`id` JOIN `architectures` ON `repositories`.`architecture`=`architectures`.`id`;
SELECT "mv.id",`moveable_bpir`.`id`,`moveable_bpir`.`to_repository` FROM `moveable_bpir`;
SELECT "mv",CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.",IF(`compressions`.`suffix` IS NULL,"tar.zst",`compressions`.`suffix`)),`r_a`.`name`,`repositories`.`name`,`new_r_a`.`name`,`new_repo`.`name` FROM `moveable_bpir` JOIN `binary_packages_in_repositories` ON `moveable_bpir`.`id`=`binary_packages_in_repositories`.`id` JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` LEFT JOIN `compressions` ON `binary_packages`.`compression`=`compressions`.`id` JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id` JOIN `repositories` AS `new_repo` ON `new_repo`.`id`=`moveable_bpir`.`to_repository` JOIN `architectures` AS `new_r_a` ON `new_repo`.`architecture`=`new_r_a`.`id`;
SELECT "rm.id",`replaced_bpir`.`id` FROM `replaced_bpir`;
SELECT "rm",CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.",IF(`compressions`.`suffix` IS NULL,"tar.zst",`compressions`.`suffix`)),`r_a`.`name`,`repositories`.`name` FROM `replaced_bpir` JOIN `binary_packages_in_repositories` ON `replaced_bpir`.`id`=`binary_packages_in_repositories`.`id` JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` LEFT JOIN `compressions` ON `binary_packages`.`compression`=`compressions`.`id` JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`;