X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2794f75fd58d78a1229b7b0d62d5fcb958d241b9..487d4f1f6ccd3e22c05469f679bf5d0685914611:/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 5887b357c..068ee2319 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -256,5 +256,8 @@ alter table invoice add column cusordnumber text; -- -- 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';