buildmaster/mysql-issues.php: show architecture of repository, too

1 files changed, 4 insertions, 0 deletions

diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php
index 16dd986..0604167 100644
--- a/buildmaster/mysql-issues.php
+++ b/buildmaster/mysql-issues.php
@@ -9,6 +9,7 @@ require_once BASE . "/lib/mysql.php";
 
   $result = mysql_run_query(
     "SELECT CONCAT(" .
+    "`r_a`.`name`,\"/\"," .
     "`repositories`.`name`,\"/\"," .
     "`binary_packages`.`pkgname`,\"-\"," .
     "IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
@@ -24,6 +25,7 @@ require_once BASE . "/lib/mysql.php";
     " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
     " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
     " AND `repositories`.`is_on_master_mirror`" .
+    " JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`" .
     " JOIN `dependencies` ON `dependencies`.`dependent`=`binary_packages`.`id`" .
     " JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id`" .
     " AND `dependency_types`.`relevant_for_binary_packages`" .
@@ -60,6 +62,7 @@ require_once BASE . "/lib/mysql.php";
 
   $result = mysql_run_query(
     "SELECT CONCAT(" .
+    "`r_a`.`name`,\"/\"," .
     "`repositories`.`name`,\"/\"," .
     "`binary_packages`.`pkgname`,\"-\"," .
     "IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
@@ -74,6 +77,7 @@ require_once BASE . "/lib/mysql.php";
     " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
     " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
     " AND `repositories`.`is_on_master_mirror`" .
+    " JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`" .
     " JOIN `repository_stabilities` ON `repositories`.`stability`=`repository_stabilities`.`id`" .
     " JOIN `dependencies` ON `dependencies`.`dependent`=`binary_packages`.`id`" .
     " JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id`" .