lib/mysql-functions: mysql_retrieve_static_information(): extract $compression_ids__*

1 files changed, 8 insertions, 0 deletions

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
   )"