From: Philip Reetz <p.reetz@linet-services.de>
Date: Tue, 11 Oct 2005 09:37:42 +0000 (+0000)
Subject: Fixed Bug #199
X-Git-Tag: release-2.4.0^2~506
X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/commitdiff_plain/43cbbf5af8859d6c3309d43a64eb7b9495b73b6a?ds=inline

Fixed Bug #199
---

diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql
index 476e4020b..7ff54927a 100644
--- a/sql/Pg-upgrade-2.1.1-2.1.2.sql
+++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql
@@ -170,7 +170,6 @@ alter table acc_trans add foreign key (chart_id) references chart (id);
 alter table invoice add foreign key (parts_id) references parts (id);
 alter table ar add foreign key (customer_id) references customer (id);
 alter table ap add foreign key (vendor_id) references vendor (id);
-alter table orderitems add foreign key (trans_id) references oe (id);
 alter table orderitems add foreign key (parts_id) references parts (id);
 
 --Modify the possible length of bank account numbers
diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 3be0a8546..18f27aae7 100644
--- 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,