X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/4f15333b8cc0ae1b0b4089adc2e516ba002b298b..b720e272:/sql/Pg-upgrade2/parts_translation_foreign_keys.sql 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));