X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Forderitems_delivery_order_items_invoice_foreign_keys.sql;h=ab620273a52e7c74bee047850ff90406c7b3fe4b;hb=371ab59da0ebb21a8438cab732530e1cf5f9471c;hp=0de00c5d38001d9cf5fd136e48ab29d376a81f8d;hpb=b632cee8434442efd8ae3962126c34123172daac;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql b/sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql
index 0de00c5d3..ab620273a 100644
--- a/sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql
+++ b/sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql
@@ -1,7 +1,6 @@
 -- @tag: orderitems_delivery_order_items_invoice_foreign_keys
 -- @description: Fremdschlüssel für Tabellen oderitems, delivery_order_items, invoice
 -- @depends: release_3_0_0
--- @charset: utf-8
 UPDATE orderitems           SET pricegroup_id = NULL WHERE pricegroup_id = 0;
 UPDATE delivery_order_items SET pricegroup_id = NULL WHERE pricegroup_id = 0;
 UPDATE invoice              SET pricegroup_id = NULL WHERE pricegroup_id = 0;
@@ -10,6 +9,8 @@ UPDATE orderitems           SET project_id = NULL WHERE project_id NOT IN (SELEC
 UPDATE delivery_order_items SET project_id = NULL WHERE project_id NOT IN (SELECT id FROM project);
 UPDATE invoice              SET project_id = NULL WHERE project_id NOT IN (SELECT id FROM project);
 
+DELETE FROM orderitems WHERE trans_id NOT IN (SELECT id FROM oe);
+
 ALTER TABLE orderitems           ADD FOREIGN KEY (trans_id)        REFERENCES oe            (id);
 ALTER TABLE orderitems           ADD FOREIGN KEY (project_id)      REFERENCES project       (id);
 ALTER TABLE orderitems           ADD FOREIGN KEY (pricegroup_id)   REFERENCES pricegroup    (id);