Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-04-08 09:01:58 +0200
committerErich Eckner <git@eckner.net>2019-04-08 09:01:58 +0200
commit6ea53e32d1cece3b28f71e08ae38e7d72359f1a8 (patch)
tree4b756d80dc086db5aa25a78a4097497ebe096a7c /misc/database-layout.dump
parent12874f08c8bc78b7449f46d05bd06c786ed697b0 (diff)
misc/database-layout.dump: removed some obsolete, experimental stored functions
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump81
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,