X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/bb8964ddfc59e40b62f6e65f5dd38cea9b7323d0..78c8e7ac6600a975f31242165c81e537ce28bc07:/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);