diff options
| author | Erich Eckner <git@eckner.net> | 2018-03-09 11:30:16 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-03-09 11:30:16 +0100 |
| commit | 28099f340b36fcde5a42a13328aea6a39de44460 (patch) | |
| tree | 5d152b2d6f13d163af38f38fcc36b705bc654223 | |
| parent | 07de651e7222691c5eabef6ac156ab0f33fc3314 (diff) | |
| download | builder-28099f340b36fcde5a42a13328aea6a39de44460.tar.xz | |
bin/db-update: columns are separated by space!
| -rwxr-xr-x | bin/db-update | 2 |
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`' |