-- called by /home/master/builder/work/intentions/intention.6
-- : #!/bin/sh
-- : # called by /home/master/builder/bin/db-update
-- : [ -n "${base_dir}" ] || . /home/master/builder/lib/load-configuration
-- : mysql_run_query >> "/home/master/builder/work/tmp.db-update.permanent.C6144Tgq6v/rm"
-- :  <<END_OF_MYSQL_QUERY
-- : CREATE TEMPORARY TABLE \`replaced_bpir\` (\`id\` BIGINT, UNIQUE KEY (\`id\`));
-- : CREATE TEMPORARY TABLE \`moved_bpir\` (\`id\` BIGINT, \`new_repository\` MEDIUMINT, UNIQUE KEY (\`id\`));
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-07-15T21:45:56.whVMjE.infile.1" INTO TABLE \`moved_bpir\` COLUMNS TERMINATED BY " ";
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-07-15T21:45:56.whVMjE.infile.2" INTO TABLE \`replaced_bpir\` COLUMNS TERMINATED BY " ";
-- : DELETE \`binary_packages_in_repositories\` FROM \`binary_packages_in_repositories\` JOIN \`replaced_bpir\` ON \`binary_packages_in_repositories\`.\`id\`=\`replaced_bpir\`.\`id\`;
-- : SELECT CONCAT("pool/",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\`))) FROM \`binary_packages\` JOIN \`architectures\` ON \`binary_packages\`.\`architecture\`=\`architectures\`.\`id\` LEFT JOIN \`compressions\` ON \`binary_packages\`.\`compression\`=\`compressions\`.\`id\` WHERE NOT EXISTS (SELECT 1 FROM \`binary_packages_in_repositories\` WHERE \`binary_packages_in_repositories\`.\`package\`=\`binary_packages\`.\`id\`);
-- : DELETE \`binary_packages\` FROM \`binary_packages\` WHERE NOT EXISTS (SELECT 1 FROM \`binary_packages_in_repositories\` WHERE \`binary_packages_in_repositories\`.\`package\`=\`binary_packages\`.\`id\`);
-- : UPDATE \`binary_packages_in_repositories\` JOIN \`moved_bpir\` ON \`binary_packages_in_repositories\`.\`id\`=\`moved_bpir\`.\`id\` SET \`binary_packages_in_repositories\`.\`repository\`=\`moved_bpir\`.\`new_repository\`,\`binary_packages_in_repositories\`.\`last_moved\`=NOW() WHERE \`binary_packages_in_repositories\`.\`repository\`!=\`moved_bpir\`.\`new_repository\`;
-- : END_OF_MYSQL_QUERY
-- : rm "/home/master/builder/work/intentions/intention.6"
2	i686	2	testing
4	pentium4	2	testing
2	i686	3	staging
4	pentium4	3	staging
3	i486	3	staging