X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/bb8964ddfc59e40b62f6e65f5dd38cea9b7323d0..961ffc4874ff468676848e83d635d17c64489fb7:/sql/Pg-upgrade2/add_fk_to_gl.sql diff --git a/sql/Pg-upgrade2/add_fk_to_gl.sql b/sql/Pg-upgrade2/add_fk_to_gl.sql index 46d30a4bb..461b56605 100644 --- a/sql/Pg-upgrade2/add_fk_to_gl.sql +++ b/sql/Pg-upgrade2/add_fk_to_gl.sql @@ -1,7 +1,6 @@ -- @tag: add_fk_to_gl -- @description: Setzt Datenbank-Fremdschlüssel von gl.department_id auf department.id -- @depends: release_3_0_0 --- @charset: utf-8 -- update all invalid departments in gl: UPDATE gl SET department_id = NULL WHERE department_id NOT IN (SELECT id FROM department);