misc/database-layout.dump: removed some obsolete, experimental stored functions

1 files changed, 0 insertions, 81 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 89e558f..cf2c5e7 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -61,42 +61,6 @@ SELECT `architectures`.`name`,`bl`.`pkgbase`
 DROP TEMPORARY TABLE `bl`;
 DROP TEMPORARY TABLE `bl_copy`;
 END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci
-calculate_dependencies_of_package_upto_first_built_one	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `calculate_dependencies_of_package_upto_first_built_one`(IN `target_pkgbase` VARCHAR(64))
-BEGIN
-INSERT IGNORE INTO `relevant_binary_packages` (`id`)
-	SELECT `binary_packages`.`id`
-	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` AND `repositories`.`name`="build-list"
-	JOIN `build_assignments`
-	ON `binary_packages`.`build_assignment`=`build_assignments`.`id`
-	JOIN `package_sources`
-	ON `build_assignments`.`package_source`=`package_sources`.`id`
-	WHERE `package_sources`.`pkgbase`=`target_pkgbase`;
-REPEAT
-INSERT IGNORE INTO `relevant_binary_packages_copy` (`id`)
-	SELECT `relevant_binary_packages`.`id`
-	FROM `relevant_binary_packages`;
-INSERT IGNORE INTO `relevant_binary_packages` (`id`)
-	SELECT `install_target_providers`.`package`
-	FROM `relevant_binary_packages_copy`
-	JOIN `binary_packages`
-	ON `relevant_binary_packages_copy`.`id`=`binary_packages`.`id`
-	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`.`name`="build-list"
-	JOIN `dependencies`
-	ON `binary_packages`.`id`=`dependencies`.`dependent`
-	JOIN `dependency_types`
-	ON `dependencies`.`dependency_type`=`dependency_types`.`id` AND `dependency_types`.`relevant_for_building`
-	JOIN `install_target_providers`
-	ON `dependencies`.`depending_on`=`install_target_providers`.`install_target`;
-UNTIL ROW_COUNT()=0
-END REPEAT;
-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 `from_stability` MEDIUMINT)
 BEGIN
 DECLARE row_count_saved INT DEFAULT 0;
@@ -542,51 +506,6 @@ SELECT CONCAT(IF(`impact`.`and`,"(and) ","(or) "),`impact`.`name`," ",IF(`impact
 	WHERE `cause`.`relevant` AND `impact`.`relevant`;
 DROP TEMPORARY TABLE `knot_names`;
 END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci
-show_broken_packages_and_dependencies	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `show_broken_packages_and_dependencies`()
-BEGIN
-CREATE TEMPORARY TABLE `broken_packages_and_dependencies` (`id` BIGINT, UNIQUE KEY (`id`));
-CREATE TEMPORARY TABLE `broken_packages_and_dependencies_old` (`id` BIGINT, UNIQUE KEY (`id`));
-INSERT IGNORE INTO `broken_packages_and_dependencies` (`id`)
-	SELECT `build_assignments`.`id`
-	FROM `binary_packages`
-	JOIN `build_assignments`
-	ON `binary_packages`.`build_assignment`=`build_assignments`.`id` AND `build_assignments`.`is_broken`
-	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`.`name`="build-list";
-REPEAT
-INSERT IGNORE INTO `broken_packages_and_dependencies_old` (`id`)
-	SELECT `broken_packages_and_dependencies`.`id`
-	FROM `broken_packages_and_dependencies`;
-INSERT IGNORE INTO `broken_packages_and_dependencies` (`id`)
-	SELECT `new_bp`.`build_assignment`
-	FROM `broken_packages_and_dependencies_old`
-	JOIN `binary_packages` AS `old_bp`
-	ON `broken_packages_and_dependencies_old`.`id`=`old_bp`.`build_assignment`
-	JOIN `dependencies`
-	ON `old_bp`.`id`=`dependencies`.`dependent`
-	JOIN `dependency_types`
-	ON `dependencies`.`dependency_type`=`dependency_types`.`id` AND `dependency_types`.`relevant_for_building`
-	JOIN `install_target_providers`
-	ON `dependencies`.`depending_on`=`install_target_providers`.`install_target`
-	JOIN `binary_packages` AS `new_bp`
-	ON `install_target_providers`.`package`=`new_bp`.`id`
-	JOIN `binary_packages_in_repositories` AS `new_bpir`
-	ON `new_bp`.`id`=`new_bpir`.`package`
-	JOIN `repositories` AS `new_repo`
-	ON `new_bpir`.`repository`=`new_repo`.`id` AND `new_repo`.`name` IN ("build-list","deletion-list");
-UNTIL ROW_COUNT()=0
-END REPEAT;
-SELECT `package_sources`.`pkgbase`,`package_sources`.`git_revision`,`package_sources`.`mod_git_revision`,`upstream_repositories`.`name`
-	FROM `build_assignments`
-	JOIN `package_sources`
-	ON `build_assignments`.`package_source`=`package_sources`.`id`
-	JOIN `upstream_repositories`
-	ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`
-	JOIN `broken_packages_and_dependencies`
-	ON `broken_packages_and_dependencies`.`id`=`build_assignments`.`id`;
-END	utf8mb4	utf8mb4_unicode_ci	utf8mb4_unicode_ci
 allowed_email_actions	CREATE TABLE `allowed_email_actions` (
 	 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 	 `gpg_key` bigint(20) NOT NULL,