X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/b8008d65d75998d30cfb038de5f00892d39fd9c3..ea910b8d66ff2add3fab2857ad0bdc74501d6969:/sql/Pg-upgrade-2.1.1-2.1.2.sql diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql index 6946ab202..7cf035580 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -321,5 +321,8 @@ INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SEL -- -- add unqiue constraint to project ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); +-- +-- add column deliverydate to ar +ALTER TABLE ar ADD COLUMN deliverydate date; update defaults set version = '2.1.2';