X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fadd_fk_to_gl.sql;h=461b56605681cf34abc7eee0af87c0b490699f47;hb=2a0cbd885790174fa0f212e6661b30362650a42c;hp=46d30a4bb053dac52fe5c7b1db3842c6fbe298b9;hpb=bb8964ddfc59e40b62f6e65f5dd38cea9b7323d0;p=kivitendo-erp.git 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);