epic-ts

[kivitendo-erp.git] / sql / Pg-upgrade2 / orderitems_delivery_order_items_invoice_foreign_keys.sql

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 0de00c5..ab62027 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
@@ -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);