From f175baf39675a72426d63b620d968eeaa44648b2 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 29 Oct 2018 15:53:56 +0100 Subject: buildmaster/mysql-issues.php: show architecture of repository, too --- buildmaster/mysql-issues.php | 4 ++++ 1 file changed, 4 insertions(+) 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`" . -- cgit v1.2.3