summaryrefslogtreecommitdiff
path: root/bin/db-update
diff options
context:
space:
mode:
Diffstat (limited to 'bin/db-update')
-rwxr-xr-xbin/db-update2
1 files changed, 1 insertions, 1 deletions
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`'