X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=b4f956bbc1b574abc703efcfdad910045e83f269;hb=7ec334735373f140fb8ab48d9cdbe8dedecd99d0;hp=ca5b1d35e52c605fb279f7cd58d95bc23e3b2ca2;hpb=6349623b40ef4b94a6905d96b3b0fa8daaefd178;p=kivitendo-erp.git

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index ca5b1d35e..b4f956bbc 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -112,10 +112,11 @@ CREATE TABLE "defaults" (
         "audittrail" bool default 'f',
         "articlenumber" text,
         "servicenumber" text,
+        "coa" text,
         "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 +286,7 @@ CREATE TABLE "ar" (
 	"paid" numeric (15,5),
 	"datepaid" date,
 	"duedate" date,
+	"deliverydate" date,
 	"invoice" boolean DEFAULT 'f',
 	"shippingpoint" text,
 	"terms" smallint DEFAULT 0,
@@ -453,7 +455,7 @@ CREATE TABLE "shipto" (
 
 CREATE TABLE "project" (
 	"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
-	"projectnumber" text,
+	"projectnumber" text UNIQUE,
 	"description" text,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp
@@ -533,6 +535,7 @@ CREATE TABLE "business" (
         "mtime" timestamp
 );
 
+
 CREATE TABLE "sic" (
 	"code" text,
 	"sictype" character(1),