From d482851e1d8edce7fc2e80bdaf47a4defa70da36 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 17 Jan 2013 16:12:43 +0100 Subject: [PATCH] Doppelter foreign key auf oe wieder entfernt --- SL/DB/MetaSetup/Order.pm | 5 ----- sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql | 1 - 2 files changed, 6 deletions(-) diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm index de072ec70..05512cd63 100644 --- a/SL/DB/MetaSetup/Order.pm +++ b/SL/DB/MetaSetup/Order.pm @@ -83,11 +83,6 @@ __PACKAGE__->meta->setup( key_columns => { employee_id => 'id' }, }, - employee_obj => { - class => 'SL::DB::Employee', - key_columns => { employee_id => 'id' }, - }, - globalproject => { class => 'SL::DB::Project', key_columns => { globalproject_id => 'id' }, diff --git a/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql b/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql index 2e2e8c971..ac92ca4e6 100644 --- a/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql +++ b/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql @@ -19,7 +19,6 @@ ALTER TABLE oe ADD FOREIGN KEY (cp_id) REFERENCES co ALTER TABLE oe ADD FOREIGN KEY (delivery_customer_id) REFERENCES customer (id); ALTER TABLE oe ADD FOREIGN KEY (delivery_vendor_id) REFERENCES vendor (id); ALTER TABLE oe ADD FOREIGN KEY (department_id) REFERENCES department (id); -ALTER TABLE oe ADD FOREIGN KEY (employee_id) REFERENCES employee (id); ALTER TABLE oe ADD FOREIGN KEY (language_id) REFERENCES language (id); ALTER TABLE oe ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id); ALTER TABLE oe ADD FOREIGN KEY (shipto_id) REFERENCES shipto (shipto_id); -- 2.20.1