X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/4fd8bdbfb46b8b63a7d05457959b98c4956d1dbd..46bc75c8:/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql diff --git a/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql b/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql index 3df341430..a3eaf4d75 100644 --- a/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql +++ b/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql @@ -2,3 +2,4 @@ -- @description: Aktualisierung der Spalte tax.id, wenn tax.taxkey = 0 ist. -- @depends: UPDATE tax SET id = 0 WHERE taxkey = 0; +UPDATE taxkeys SET tax_id = 0 WHERE taxkey_id = 0;