X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Facc_trans_id_uniqueness.pl;h=1b8e5cadb02bcb2f49ab985ba3247163b062ebc7;hb=32ddb71c1b2a113b297e729817dda69a1afa203c;hp=9c0c4595a1239204b9cd300d33ce2c13500c299c;hpb=7f224f6e7d50a0e3d9e644f15b05c0804d348a66;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/acc_trans_id_uniqueness.pl b/sql/Pg-upgrade2/acc_trans_id_uniqueness.pl index 9c0c4595a..1b8e5cadb 100644 --- a/sql/Pg-upgrade2/acc_trans_id_uniqueness.pl +++ b/sql/Pg-upgrade2/acc_trans_id_uniqueness.pl @@ -47,10 +47,10 @@ SQL do_query($query, 0); - my %entries_by_trans_id; + my %skipped_acc_trans_ids; foreach my $entry (@entries) { - if (!$entries_by_trans_id{ $entry->{trans_id} }) { - $entries_by_trans_id{ $entry->{trans_id} } = []; + if (!$skipped_acc_trans_ids{ $entry->{acc_trans_id} }) { + $skipped_acc_trans_ids{ $entry->{acc_trans_id} } = 1; } else { my $mtime = $entry->{mtime} ? "= '$entry->{mtime}'" : 'IS NULL'; $query = <