From da2df61a078d3f7496a9e74f6540bb2e05f60541 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 19 Jul 2019 15:50:04 +0200 Subject: [PATCH] =?utf8?q?Mahnungs-Tabelle:=20Fremdschl=C3=BCsselverkn?= =?utf8?q?=C3=BCpfung=20auf=20Rechnungstabelle=20Part=202?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql b/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql index e84892e8a..37fb3e7d9 100644 --- a/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql +++ b/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql @@ -6,6 +6,7 @@ WHERE NOT EXISTS ( SELECT ar.id FROM ar WHERE ar.id = dunning.trans_id + LIMIT 1 ); ALTER TABLE dunning -- 2.20.1