From 94e6f6afd08dbb88c90fecdc71aab5c112108888 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 4 Jul 2019 14:50:46 +0200
Subject: misc/database-layout.dump: update `blacklist_packages` according to
 1b7d5c5699c30a31729d07746a1e0b96a4410e9f

---
 misc/database-layout.dump | 36 ++++++++++++++++++++----------------
 1 file changed, 20 insertions(+), 16 deletions(-)

(limited to 'misc')

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index fe963d4..309e9e1 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -7,6 +7,7 @@ INSERT IGNORE INTO `bl`(`arch`,`pkgbase`)
 	FROM `blacklist`
 	JOIN `architectures`
 	ON `architectures`.`name`=`blacklist`.`arch`;
+CREATE TEMPORARY TABLE `available_install_targets` (`architecture` SMALLINT,`install_target` BIGINT,UNIQUE KEY `content`(`architecture`,`install_target`),KEY (`architecture`),KEY (`install_target`));
 REPEAT
 DELETE
 	FROM `bl_copy`;
@@ -23,6 +24,21 @@ DELETE
 INSERT IGNORE INTO `bl_copy` (`arch`,`pkgbase`)
 	SELECT `bl`.`arch`, `bl`.`pkgbase`
 	FROM `bl`;
+DELETE
+	FROM `available_install_targets`;
+INSERT IGNORE INTO `available_install_targets` (`architecture`,`install_target`)SELECT `architectures`.`id`,`install_target_providers`.`install_target`
+	FROM `install_target_providers`
+	JOIN `binary_packages`
+	ON `install_target_providers`.`package`=`binary_packages`.`id`
+	JOIN `build_assignments`
+	ON `binary_packages`.`build_assignment`=`build_assignments`.`id`
+	JOIN `package_sources`
+	ON `build_assignments`.`package_source`=`package_sources`.`id`
+	JOIN `architectures`
+	ON (`architectures`.`id`=`binary_packages`.`architecture` OR `binary_packages`.`architecture`=1 OR `architectures`.`id`=1)
+	LEFT JOIN `bl_copy`
+	ON `bl_copy`.`pkgbase`=`package_sources`.`pkgbase` AND (`bl_copy`.`arch`=`build_assignments`.`architecture` OR `bl_copy`.`arch`=1)
+	WHERE `bl_copy`.`pkgbase` IS NULL;
 INSERT IGNORE INTO `bl` (`arch`,`pkgbase`)
 	SELECT `a_bp`.`architecture`,`a_ps`.`pkgbase`
 	FROM `package_sources` AS `a_ps`
@@ -40,22 +56,9 @@ INSERT IGNORE INTO `bl` (`arch`,`pkgbase`)
 	ON `dependencies`.`depending_on`=`itp_dummy`.`install_target`
 	JOIN `binary_packages` AS `itp_bp_dummy`
 	ON `itp_dummy`.`package`=`itp_bp_dummy`.`id` AND (`itp_bp_dummy`.`architecture`=`a_ba`.`architecture` OR `a_ba`.`architecture`=1 OR `itp_bp_dummy`.`architecture`=1)
-	LEFT JOIN (
-SELECT DISTINCT `install_target_providers`.`install_target`,`architectures`.`id` AS `architecture`
-	FROM `install_target_providers`
-	JOIN `binary_packages`
-	ON `install_target_providers`.`package`=`binary_packages`.`id`
-	JOIN `build_assignments`
-	ON `binary_packages`.`build_assignment`=`build_assignments`.`id`
-	JOIN `package_sources`
-	ON `build_assignments`.`package_source`=`package_sources`.`id`
-	JOIN `architectures`
-	ON (`architectures`.`id`=`binary_packages`.`architecture` OR `binary_packages`.`architecture`=1 OR `architectures`.`id`=1)
-	LEFT JOIN `bl_copy`
-	ON `bl_copy`.`pkgbase`=`package_sources`.`pkgbase` AND (`bl_copy`.`arch`=`build_assignments`.`architecture` OR `bl_copy`.`arch`=1)
-	WHERE `bl_copy`.`pkgbase` IS NULL) AS `itp_query`
-	ON `itp_query`.`install_target`=`dependencies`.`depending_on` AND `itp_query`.`architecture`=`a_ba`.`architecture`
-	WHERE `itp_query`.`install_target` IS NULL;
+	LEFT JOIN `available_install_targets`
+	ON `available_install_targets`.`install_target`=`dependencies`.`depending_on` AND `available_install_targets`.`architecture`=`a_ba`.`architecture`
+	WHERE `available_install_targets`.`install_target` IS NULL;
 UNTIL ROW_COUNT()=0
 END REPEAT;
 SELECT `architectures`.`name`,`bl`.`pkgbase`
@@ -64,6 +67,7 @@ SELECT `architectures`.`name`,`bl`.`pkgbase`
 	ON `architectures`.`id`=`bl`.`arch`;
 DROP TEMPORARY TABLE `bl`;
 DROP TEMPORARY TABLE `bl_copy`;
+DROP TEMPORARY TABLE `available_install_targets`;
 END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci
 calculate_maximal_moveable_set	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `calculate_maximal_moveable_set`(IN `arch_id` MEDIUMINT,IN `from_stability` MEDIUMINT)
 BEGIN
-- 
cgit v1.2.3-54-g00ecf