From d83aecc92e8bbb847b49fc2be4ba4facd1f17795 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 31 May 2018 10:43:48 +0200
Subject: lib/mysql-functions: add table names to query

---
 lib/mysql-functions | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/mysql-functions b/lib/mysql-functions
index b637afc..0aad61a 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -684,7 +684,14 @@ mysql_sanity_check() {
       "${temp_dir}/master-mirror-listing"
 
     {
-      printf 'SELECT `r_a`.`name`,`repositories`.`name`,`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architectures`.`name`'
+      printf 'SELECT `r_a`.`name`,`repositories`.`name`,'
+      printf '`binary_packages`.`%s`,' \
+        'pkgname' \
+        'epoch' \
+        'pkgver' \
+        'pkgrel' \
+        'sub_pkgrel'
+      printf '`architectures`.`name`'
       printf ' FROM `binary_packages`'
       mysql_join_binary_packages_architectures
       mysql_join_binary_packages_binary_packages_in_repositories
-- 
cgit v1.2.3-70-g09d2