summaryrefslogtreecommitdiff
path: root/bin/db-update
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-03-09 11:30:16 +0100
committerErich Eckner <git@eckner.net>2018-03-09 11:30:16 +0100
commit28099f340b36fcde5a42a13328aea6a39de44460 (patch)
tree5d152b2d6f13d163af38f38fcc36b705bc654223 /bin/db-update
parent07de651e7222691c5eabef6ac156ab0f33fc3314 (diff)
downloadbuilder-28099f340b36fcde5a42a13328aea6a39de44460.tar.xz
bin/db-update: columns are separated by space!
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`'