diff options
author | Erich Eckner <git@eckner.net> | 2018-02-16 11:14:03 +0100 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-02-16 11:14:03 +0100 |
commit | d2e0ef2a558e27e07150f239d91e4c29ce822426 (patch) | |
tree | f11a28ba418ecd8fae69fa7fcd3bd6a2623a8dfd /bin/db-update | |
parent | d7a7e5cebf55c13ab3522e6ec17e11cba878da73 (diff) | |
download | builder-d2e0ef2a558e27e07150f239d91e4c29ce822426.tar.xz |
bin/mysql-functions: mysql_join_*_* new
Diffstat (limited to 'bin/db-update')
-rwxr-xr-x | bin/db-update | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/db-update b/bin/db-update index e5ea193..b830981 100755 --- a/bin/db-update +++ b/bin/db-update @@ -325,8 +325,8 @@ move_packages() { while read -r package; do while read -r part; do printf 'UPDATE `binary_packages`' - printf ' JOIN `repositories` AS `from_repo` ON `binary_packages`.`repository`=`from_repo`.`id`' - printf ' JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`' + mysql_join_binary_packages_repositories '' 'from_repo' + mysql_join_binary_packages_architectures printf ' SET `binary_packages`.`repository`=(' printf 'SELECT `to_repo`.`id`' printf ' FROM `repositories` as `to_repo`' |