Sammelcommit Bankerweiterung und Skonto

[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..cdda464 100644 (file)
--- a/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql
+++ b/sql/Pg-upgrade2/bankaccounts_sortkey_and_obsolete.sql
@@ -3,7 +3,8 @@
 -- @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;