X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2d72b516f1fe724cff4efd8fe23c1629c98f36ac..86be28e9b1744d86e2db534c3d2b005eb5f144f5:/sql/lx-office.sql diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 76267264b..ffcf8ca36 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -115,7 +115,7 @@ CREATE TABLE "defaults" ( "itime" timestamp DEFAULT now(), "mtime" timestamp ); -INSERT INTO defaults (version,audittrail) VALUES ('2.1.2', 't'); +INSERT INTO defaults (version,audittrail) VALUES ('2.2.0', 't'); CREATE TABLE audittrail ( "trans_id" int, @@ -285,6 +285,7 @@ CREATE TABLE "ar" ( "paid" numeric (15,5), "datepaid" date, "duedate" date, + "deliverydate" date, "invoice" boolean DEFAULT 'f', "shippingpoint" text, "terms" smallint DEFAULT 0,