From 28099f340b36fcde5a42a13328aea6a39de44460 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 9 Mar 2018 11:30:16 +0100
Subject: bin/db-update: columns are separated by space!

---
 bin/db-update | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'bin')

diff --git a/bin/db-update b/bin/db-update
index ca52688..f87000a 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -264,7 +264,7 @@ for source_stability in 'testing' 'staging'; do
   {
     printf 'CREATE TEMPORARY TABLE `replaced_binary_packages` (`id` BIGINT, UNIQUE KEY (`id`));\n'
     printf 'CREATE TEMPORARY TABLE `moved_binary_packages` (`id` BIGINT, `new_repository` MEDIUMINT, UNIQUE KEY (`id`));\n'
-    printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `%s`;\n' \
+    printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `%s` COLUMNS TERMINATED BY " ";\n' \
       "${tmp_dir}/mv.id" 'moved_binary_packages' \
       "${tmp_dir}/rm.id" 'replaced_binary_packages'
     printf 'DELETE `binary_packages` FROM `binary_packages`'
-- 
cgit v1.2.3-54-g00ecf