steuerfilterung.pl: mit "keine Steuer" zurecht kommen

diff --git a/sql/Pg-upgrade2/steuerfilterung.pl b/sql/Pg-upgrade2/steuerfilterung.pl
index 1b454e3b0f4305ddba0643e408d19b021052741d..655d28f5e5ae50873b285624db1c7317aa6d3b45 100644 (file)
--- a/sql/Pg-upgrade2/steuerfilterung.pl
+++ b/sql/Pg-upgrade2/steuerfilterung.pl
@@ -30,6 +30,7 @@ sub run {
       $categories .= 'E' if $::form->{"expense_$i"};
       $self->db_query(qq|UPDATE tax SET chart_categories = ? WHERE id = ?|, bind => [ $categories, $tax_id ]);
     }
+    $self->db_query(qq|UPDATE tax SET chart_categories = 'ALQCIE' WHERE chart_categories IS NULL|);
     $self->db_query(qq|ALTER TABLE tax ALTER COLUMN chart_categories SET NOT NULL|);
     return 1;
   }