X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fparts_translation_foreign_keys.sql;h=fa10e6889b61302829fe77b636a8dd04a7bdad59;hb=97a6f6d623a9810e1d324f44a5f8bcd12294f5d3;hp=77b6a7296664b8949ccbaf28b0f00ef3f9c66ab0;hpb=4f15333b8cc0ae1b0b4089adc2e516ba002b298b;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/parts_translation_foreign_keys.sql b/sql/Pg-upgrade2/parts_translation_foreign_keys.sql index 77b6a7296..fa10e6889 100644 --- a/sql/Pg-upgrade2/parts_translation_foreign_keys.sql +++ b/sql/Pg-upgrade2/parts_translation_foreign_keys.sql @@ -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));