X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/921adf5b31fe273406ef57fc411aa680be4544e7..72539cb39a3d19f930a8e0e41e46bf41afe9a8f1:/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,