2 -- @description: Setzt Datenbank-Fremdschlüssel von gl.department_id auf department.id
3 -- @depends: release_3_0_0
5 -- update all invalid departments in gl:
6 UPDATE gl SET department_id = NULL WHERE department_id NOT IN (SELECT id FROM department);
9 ALTER TABLE gl ALTER department_id DROP DEFAULT;
11 -- set foreign key constraint:
12 ALTER TABLE gl ADD FOREIGN KEY (department_id) REFERENCES department(id);