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=a6e0a7f493d24aec0eebede85eeaa5e724bd2e11;hp=ed1b01795b4d87a0e0e35e6849d47b06dd00f2d0;hpb=6f266e929ff3eaefc84c34b46fa452c50eecbcf4;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 ed1b01795..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;