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