bin/check-mirrors: correctly cast bits

1 files changed, 10 insertions, 2 deletions

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