From 6ea53e32d1cece3b28f71e08ae38e7d72359f1a8 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 8 Apr 2019 09:01:58 +0200 Subject: misc/database-layout.dump: removed some obsolete, experimental stored functions --- misc/database-layout.dump | 81 ----------------------------------------------- 1 file changed, 81 deletions(-) (limited to 'misc') 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, -- cgit v1.2.3-54-g00ecf