X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fsteuerfilterung.pl;h=655d28f5e5ae50873b285624db1c7317aa6d3b45;hb=0395c0364adb8fde7442c6b11ab064e406fd7776;hp=1b454e3b0f4305ddba0643e408d19b021052741d;hpb=44e8084a0fc69c9e9afea5531186eb28a1b2473a;p=kivitendo-erp.git

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;
   }