Kundenquelle (Leads) eingeführt

[kivitendo-erp.git] / sql / lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index ca5b1d3..6807f21 100644 (file)
--- 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,
@@ -453,7 +454,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 +534,7 @@ CREATE TABLE "business" (
         "mtime" timestamp
 );
 
+
 CREATE TABLE "sic" (
        "code" text,
        "sictype" character(1),