From cd7293bc960879370e013ef1a67274541776bc88 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 29 Oct 2019 09:46:35 +0100
Subject: bin/check-mirrors: correctly cast bits

---
 bin/check-mirrors | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'bin/check-mirrors')

diff --git a/bin/check-mirrors b/bin/check-mirrors
index 3ea1c04..5dc8cfe 100755
--- a/bin/check-mirrors
+++ b/bin/check-mirrors
@@ -64,13 +64,21 @@ if [ $# -eq 0 ]; then
       'country_code' \
       'last_sync' \
       'start' \
-      'stop' \
+      'stop'
+    printf '@%s,' \
       'isos' \
       'ipv4' \
       'ipv6' \
       'active' | \
       sed 's/,$//'
-    printf ');\n'
+    printf ') set '
+    printf '`%s`=CAST(`%s` AS SIGNED),' \
+      'isos' 'isos' \
+      'ipv4' 'ipv4' \
+      'ipv6' 'ipv6' \
+      'active' 'active' | \
+    sed 's/,$//'
+    printf ';\n'
   } | \
     mysql_run_query
 
-- 
cgit v1.2.3-70-g09d2