X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Finvalid_taxkeys_2.sql;h=5dab783d13f212f592a40cb74641592ff9b4b32c;hb=e4b4e4d3dd4b1e85212b9e061ff4c659ed02d8b8;hp=f5f72c79ec82bf9a7d363a879317b8b0612a2895;hpb=28ae03226a30c6f647aa8532809f8e80abaae20b;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/invalid_taxkeys_2.sql b/sql/Pg-upgrade2/invalid_taxkeys_2.sql
index f5f72c79e..5dab783d1 100644
--- a/sql/Pg-upgrade2/invalid_taxkeys_2.sql
+++ b/sql/Pg-upgrade2/invalid_taxkeys_2.sql
@@ -1,4 +1,9 @@
 -- @tag: invalid_taxkeys_2
 -- @description: Ungültige Steuerschlüssel in den Kontenrahmendefinitionen und daraus resultierende falsche Einträge in anderen Tabellen werden korrigiert.
 -- @depends: release_2_4_2
+SET datestyle = 'German';
+
+INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate)
+       SELECT id, 0, 0, 0, '01.01.1970' FROM chart WHERE taxkey_id ISNULL;
+
 UPDATE chart SET taxkey_id = 0 WHERE taxkey_id ISNULL;