Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

[kivitendo-erp.git] / sql / Pg-upgrade2 / bankaccounts_sortkey_and_obsolete.sql

diff --git a/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql b/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql
index 49baff9..b8bbd3d 100644 (file)
--- 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;