From 3922a3c19a5150eee19a89957a0e616797e71a2b Mon Sep 17 00:00:00 2001 From: Andreas Rudin Date: Thu, 16 Jul 2020 15:48:05 +0200 Subject: [PATCH] Zeile 'drop table temp_taxkey_conversions;' vor 'END IF;' --- sql/Pg-upgrade2/konjunkturpaket_2020.sql | 23 ++++++++++++----------- 1 file changed, 12 insertions(+), 11 deletions(-) diff --git a/sql/Pg-upgrade2/konjunkturpaket_2020.sql b/sql/Pg-upgrade2/konjunkturpaket_2020.sql index 71a7421ec..86cdad547 100644 --- a/sql/Pg-upgrade2/konjunkturpaket_2020.sql +++ b/sql/Pg-upgrade2/konjunkturpaket_2020.sql @@ -49,14 +49,14 @@ IF ( select coa from defaults ) ~ 'DATEV' THEN -- (13, 0.19, 0.16, null, null); -create temp table temp_taxkey_conversions (taxkey int, old_rate numeric, old_chart text, new_rate numeric, new_chart text); - -IF ( select coa from defaults ) = 'Germany-DATEV-SKR03EU' THEN - insert into temp_taxkey_conversions (taxkey, old_rate, old_chart, new_rate, new_chart) - values (9, 0.19, '1576', 0.16, '1575'), - (8, 0.07, '1571', 0.05, '1568'), - (3, 0.19, '1776', 0.16, '1575'), - (2, 0.07, '1771', 0.05, '1775'); + create temp table temp_taxkey_conversions (taxkey int, old_rate numeric, old_chart text, new_rate numeric, new_chart text); + + IF ( select coa from defaults ) = 'Germany-DATEV-SKR03EU' THEN + insert into temp_taxkey_conversions (taxkey, old_rate, old_chart, new_rate, new_chart) + values (9, 0.19, '1576', 0.16, '1575'), + (8, 0.07, '1571', 0.05, '1568'), + (3, 0.19, '1776', 0.16, '1575'), + (2, 0.07, '1771', 0.05, '1775'); --1776 => 19% --1775 => 16% --1775 => 5% @@ -199,11 +199,12 @@ IF ( select coa from defaults ) = 'Germany-DATEV-SKR03EU' THEN -- RAISE NOTICE 'inserted 2 taxkeys for chart % with taxkey %', (select accno from chart where id = current_taxkey.chart_id), current_taxkey.taxkey_id; END LOOP; -- -END IF; -- DATEV coa -END $$; + drop table temp_taxkey_conversions; -drop table temp_taxkey_conversions; +END IF; + +END $$; -- select * from taxkeys where startdate >= '2020-01-01'; -- rollback; -- 2.20.1