Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/buildmaster/mysql-issues.php
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-31 15:58:14 +0200
committerErich Eckner <git@eckner.net>2018-05-31 15:58:14 +0200
commitf1a6d7ddc580b913ba35532b4c701bfd8e320a16 (patch)
tree321095ee035fd715d0ff7f8a90c6686578f169e6 /buildmaster/mysql-issues.php
parent53d6d755fdb2515d49ed9dcb15192b36331d65cc (diff)
buildmaster/mysql-issues.php, buildmaster/status.php, buildmaster/to-delete.php: read `is_to_be_deleted` and `last_moves` from `binary_packages_in_repositories`
Diffstat (limited to 'buildmaster/mysql-issues.php')
-rw-r--r--buildmaster/mysql-issues.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php
index e6e557d..684c44c 100644
--- a/buildmaster/mysql-issues.php
+++ b/buildmaster/mysql-issues.php
@@ -17,7 +17,7 @@
"`binary_packages`.`sub_pkgrel`,\"-\"," .
"`architectures`.`name`) AS `pkgfile`," .
"`install_targets`.`name` AS `install_target`," .
- "IF(`binary_packages`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`," .
+ "IF(`binary_packages_in_repositories`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`," .
"`subst_r`.`name` AS `subst_repository`," .
"`subst_buildlist_bp`.`id` AS `subst_buildlist`" .
" FROM `binary_packages`" .
@@ -48,7 +48,7 @@
")" .
$ignore .
" ORDER BY " .
- "`binary_packages`.`is_to_be_deleted`," .
+ "`binary_packages_in_repositories`.`is_to_be_deleted`," .
"`repositories`.`name`," .
"`binary_packages`.`pkgname`," .
"`install_targets`.`name`"
@@ -69,7 +69,7 @@
"`architectures`.`name`) AS `pkgfile`," .
"`install_targets`.`name` AS `install_target`," .
"`repository_stabilities`.`name` AS `stability`," .
- "IF(`binary_packages`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`" .
+ "IF(`binary_packages_in_repositories`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`" .
" FROM `binary_packages`" .
" JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" .
" JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" .
@@ -94,7 +94,7 @@
" AND `repositories`.`stability`=`repository_stability_relations`.`less_stable`" .
")" .
$ignore .
- " ORDER BY `is_to_be_deleted`,`binary_packages`.`pkgname`,`install_targets`.`name`"
+ " ORDER BY `binary_packages_in_repositories`.`is_to_be_deleted`,`binary_packages`.`pkgname`,`install_targets`.`name`"
);
$stability_issues = array();