]> wagnertech.de Git - kivitendo-erp.git/blobdiff - sql/Pg-upgrade2/parts_translation_foreign_keys.sql
Fremschlüssel für »unit« in Tabellen orderitems, delivery_order_items, invoice
[kivitendo-erp.git] / sql / Pg-upgrade2 / parts_translation_foreign_keys.sql
index 77b6a7296664b8949ccbaf28b0f00ef3f9c66ab0..fa10e6889b61302829fe77b636a8dd04a7bdad59 100644 (file)
@@ -1,7 +1,6 @@
 -- @tag: parts_translation_foreign_keys
 -- @description: Fremdschlüsseldefinitionen für parts, translation
 -- @depends: release_3_0_0
--- @charset: utf-8
 
 UPDATE parts SET partsgroup_id   = NULL WHERE (partsgroup_id   IS NOT NULL) AND (partsgroup_id   NOT IN (SELECT id FROM partsgroup));
 UPDATE parts SET payment_id      = NULL WHERE (payment_id      IS NOT NULL) AND (payment_id      NOT IN (SELECT id FROM payment_terms));