X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fbankaccounts_sortkey_and_obsolete.sql;h=b8bbd3d25f7a78c15883e3c108d54828fffa539c;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hp=49baff90e00e00397f4699fbddedc1f960cd47b5;hpb=28fee2e2ebc6746bcfeb47c0318e79789ba1c850;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql b/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql
index 49baff90e..b8bbd3d25 100644
--- a/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql
+++ b/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql
@@ -1,9 +1,9 @@
 -- @tag: bankaccounts_sortkey_and_obsolete
 -- @description: Bankkonto - Sortierreihenfolge und Ungültig
 -- @depends: release_3_2_0
--- @encoding: utf-8
 
-ALTER TABLE bank_accounts ADD COLUMN obsolete BOOLEAN;
+-- default false needed so that get_all_sorted( query => [ obsolete => 0 ] ) works
+ALTER TABLE bank_accounts ADD COLUMN obsolete BOOLEAN NOT NULL DEFAULT false;
 
 ALTER TABLE bank_accounts ADD COLUMN sortkey INTEGER;
 CREATE SEQUENCE tmp_counter;