Fixed Bug #199

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

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index d2c0bca..18f27aa 100644 (file)
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -370,7 +370,7 @@ CREATE TABLE "oe" (
 );
 
 CREATE TABLE "orderitems" (
-       "trans_id" integer REFERENCES oe (id),
+       "trans_id" integer,
        "parts_id" integer REFERENCES parts (id),
        "description" text,
        "qty" real,
@@ -417,6 +417,8 @@ CREATE TABLE "employee" (
 CREATE TABLE "shipto" (
        "trans_id" integer,
        "shiptoname" character varying(75),
+        "shiptodepartment_1" character varying(75),
+        "shiptodepartment_2" character varying(75),
        "shiptostreet" character varying(75),
        "shiptozipcode" character varying(75),
        "shiptocity" character varying(75),