From 212723c1605958bbb7df0351b778bc76b7e1bdf9 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 28 Feb 2007 14:12:45 +0000 Subject: [PATCH] =?utf8?q?Ung=C3=BCltige=20Steuerschl=C3=BCssel=20in=20den?= =?utf8?q?=20Kontenrahmendefinitionen=20und=20daraus=20resultierende=20fal?= =?utf8?q?sche=20Eintr=C3=A4ge=20in=20anderen=20Tabellen=20werden=20korrig?= =?utf8?q?iert.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/invalid_taxkeys_2.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/Pg-upgrade2/invalid_taxkeys_2.sql diff --git a/sql/Pg-upgrade2/invalid_taxkeys_2.sql b/sql/Pg-upgrade2/invalid_taxkeys_2.sql new file mode 100644 index 000000000..5dab783d1 --- /dev/null +++ b/sql/Pg-upgrade2/invalid_taxkeys_2.sql @@ -0,0 +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; -- 2.20.1