diff options
| author | Erich Eckner <git@eckner.net> | 2018-03-27 09:22:45 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-03-27 09:22:45 +0200 |
| commit | 9e7bb62bb58ca3a50e35fa8b814ce16b6973ab18 (patch) | |
| tree | f35cf25f3a9f275ecabc16373e19c580f37a3e8c | |
| parent | 9e37d9e6cd70e6e7ddc4b48d7056c45342555ad6 (diff) | |
| download | builder-9e7bb62bb58ca3a50e35fa8b814ce16b6973ab18.tar.xz | |
bin/return-assignment: remove duplicate files from table instead of failing
| -rwxr-xr-x | bin/return-assignment | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/bin/return-assignment b/bin/return-assignment index 6af8c84..6447dce 100755 --- a/bin/return-assignment +++ b/bin/return-assignment @@ -470,7 +470,7 @@ trigger_mirror_refreshs printf 'UPDATE `pkg_files`' printf ' SET `pkg_files`.`name_hash`=sha2(`pkg_files`.`name`,512),' printf ' `pkg_files`.`absolute_name_hash`=sha2(concat(`pkg_files`.`path`,`pkg_files`.`name`),512);\n' - printf 'ALTER TABLE `pkg_files` ADD UNIQUE INDEX `absolute_name_hash` (`absolute_name_hash`);\n' + printf 'ALTER IGNORE TABLE `pkg_files` ADD UNIQUE INDEX `absolute_name_hash` (`absolute_name_hash`);\n' printf 'INSERT IGNORE INTO `files` (`path`,`name`,`name_hash`,`absolute_name_hash`)' printf ' SELECT ' printf '`pkg_files`.`%s`,' \ |