ALTER TABLE RESIDENCE_YEAR CHANGE COLUMN KEY_RESIDENCE_MANAGEMENT_UNIT KEY_UNIT int(11) NOT NULL;
ALTER TABLE RESIDENCE_MONTH CHANGE COLUMN KEY_RESIDENCE_YEAR KEY_YEAR int(11) NOT NULL;