Lieferdatum in Rechnungen.

[mfinanz.git] / sql / lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index ca5b1d35e52c605fb279f7cd58d95bc23e3b2ca2..9caa7bd04f995fab042af741b1ea949be8502827 100644 (file)
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -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