From dba29fbf2f6cabe466a1ca7c946dd12beca115f0 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Thu, 24 Nov 2005 16:20:59 +0000 Subject: [PATCH] Merge von 580 aus unstable: Fixed Bug #199 --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 1 - sql/lx-office.sql | 2 +- 2 files changed, 1 insertion(+), 2 deletions(-) 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, -- 2.20.1