Vor Fremdschlüsselzuweisung trans_id verwaiste Einträge in orderitems löschen

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 0de00c5d38001d9cf5fd136e48ab29d376a81f8d..ed1b01795b4d87a0e0e35e6849d47b06dd00f2d0 100644 (file)
--- a/sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql
+++ b/sql/Pg-upgrade2/orderitems_delivery_order_items_invoice_foreign_keys.sql
@@ -10,6 +10,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);