From 7ea8bac9b1cbe09f425cff4dc22bdb614ae9a65c Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 17 Oct 2019 10:58:24 +0200 Subject: lib/mysql-functions: mysql_retrieve_static_information(): extract $compression_ids__* --- lib/mysql-functions | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/lib/mysql-functions b/lib/mysql-functions index df7de67..9e56319 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -1444,6 +1444,14 @@ mysql_retrieve_static_information() { printf '`repository_stabilities`.`name`,"=",' printf '`repository_stabilities`.`id`)' printf ' FROM `repository_stabilities`;\n' + printf 'SELECT REPLACE(CONCAT(' + printf '"compression_ids__",' + printf 'REPLACE(' + printf '`compressions`.`suffix`,".","_"' + printf '),"=",' + printf '`compressions`.`id`' + printf '),"-","_")' + printf ' FROM `compressions`' } | \ mysql_run_query )" -- cgit v1.2.3-70-g09d2