From 66f7ff40ffa875b06f9df02cd0e732f36af05a15 Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Mon, 29 Jul 2013 15:22:30 +0200
Subject: [PATCH] steuerfilterung.pl: mit "keine Steuer" zurecht kommen

---
 sql/Pg-upgrade2/steuerfilterung.pl | 1 +
 1 file changed, 1 insertion(+)

diff --git a/sql/Pg-upgrade2/steuerfilterung.pl b/sql/Pg-upgrade2/steuerfilterung.pl
index 1b454e3b0..655d28f5e 100644
--- 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;
   }
-- 
2.20.1