From 3f4a45a96efc9e44bc3cd58874128dc36cc667cf Mon Sep 17 00:00:00 2001 From: Udo Spallek Date: Fri, 13 Jul 2007 11:44:51 +0000 Subject: [PATCH] =?utf8?q?Bloeder=20Bug:=20eine=20zu=20gefr=C3=A4=C3=9Fige?= =?utf8?q?=20INSERT=20legt=20zu=20allen=20Konten=20taxkeys=20an,=20was=20a?= =?utf8?q?ber=20nicht=20sein=20soll,=20weil=20dubletten=20erzeugt=20werden?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/USTVA_at.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/Pg-upgrade2/USTVA_at.pl b/sql/Pg-upgrade2/USTVA_at.pl index dc2d7f378..071e41ef2 100644 --- a/sql/Pg-upgrade2/USTVA_at.pl +++ b/sql/Pg-upgrade2/USTVA_at.pl @@ -468,8 +468,8 @@ sub do_insert_taxkeys { "ALTER TABLE taxkeys DROP COLUMN pos_ustva;", "ALTER TABLE taxkeys ADD COLUMN pos_ustva text;", - "INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) - SELECT id, 0, 0, NULL, '01.01.1970' FROM chart WHERE charttype='A';", +# "INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) +# SELECT id, 0, 0, NULL, '01.01.1970' FROM chart WHERE charttype='A';", "UPDATE chart SET taxkey_id = 0 WHERE taxkey_id ISNULL;", "UPDATE taxkeys SET pos_ustva='000' WHERE chart_id IN (SELECT id FROM chart WHERE accno IN (4010, 4015, 4020, 4025, 4030, 4035, 4040, 4045, 4050, 4310, 4315, 4320, 4322, 4325, 4330, 4335, 4340, 4345, 4350, 4450, 4029, 4329));", "UPDATE taxkeys SET pos_ustva='011' WHERE chart_id IN (SELECT id FROM chart WHERE accno IN (4029, 4329));", -- 2.20.1