Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-10-17 10:58:24 +0200
committerErich Eckner <git@eckner.net>2019-10-17 10:58:24 +0200
commit7ea8bac9b1cbe09f425cff4dc22bdb614ae9a65c (patch)
treeb8877592d7b0752bcb85362d261a346f5b4098ce /lib/mysql-functions
parente33ddf9d54ed5906a7dd93075dd1bfae1949856b (diff)
lib/mysql-functions: mysql_retrieve_static_information(): extract $compression_ids__*
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions8
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
)"