projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
AccTransCorrections: single-dbh
[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
-- @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;
ALTER TABLE bank_accounts ADD COLUMN sortkey INTEGER;
CREATE SEQUENCE tmp_counter;