summaryrefslogtreecommitdiff
path: root/buildmaster/mysql-issues.php
diff options
context:
space:
mode:
Diffstat (limited to 'buildmaster/mysql-issues.php')
-rw-r--r--buildmaster/mysql-issues.php4
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`" .