diff options
| author | Erich Eckner <git@eckner.net> | 2018-10-29 15:53:56 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-10-29 15:53:56 +0100 |
| commit | f175baf39675a72426d63b620d968eeaa44648b2 (patch) | |
| tree | 5606535e2d99ff4a41f73f51b673e485b34b0a17 | |
| parent | d3c4edc3470a2f66ddf93f3c7cb468d075272d90 (diff) | |
| download | archweb32-f175baf39675a72426d63b620d968eeaa44648b2.tar.xz | |
buildmaster/mysql-issues.php: show architecture of repository, too
| -rw-r--r-- | buildmaster/mysql-issues.php | 4 |
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`" . |