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