X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2d72b516f1fe724cff4efd8fe23c1629c98f36ac..b08a61d7381fd830fdb7fd0c343ce1dcf60776bf:/sql/lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 76267264b..6807f217f 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,
@@ -533,6 +534,7 @@ CREATE TABLE "business" (
         "mtime" timestamp
 );
 
+
 CREATE TABLE "sic" (
 	"code" text,
 	"sictype" character(1),