SELECT REPLACE(CONCAT("architecture_ids__",`architectures`.`name`,"=",`architectures`.`id`),"-","_") FROM `architectures`;
SELECT REPLACE(CONCAT("repository_ids__",`architectures`.`name`,"_",`repositories`.`name`,"=",`repositories`.`id`),"-","_") FROM `repositories` JOIN `architectures` ON `repositories`.`architecture`=`architectures`.`id`;
SELECT CONCAT("repo_names=\"",REPLACE(GROUP_CONCAT(`git_repositories`.`name`),","," "),"\"") FROM `git_repositories` GROUP BY "1";
SELECT CONCAT("repo_paths__",`git_repositories`.`name`,"=","\"",`git_repositories`.`directory`,"\";repo_heads__",`git_repositories`.`name`,"=","\"",`git_repositories`.`head`,"\"") FROM `git_repositories`;
SELECT CONCAT("repository_stability_ids__",`repository_stabilities`.`name`,"=",`repository_stabilities`.`id`) FROM `repository_stabilities`;