Bad Derby migration script for AlarmDatabase

The current script for migrating the AlarmDatabase from version 1 to 2 has the following SQL:

ALTER TABLE alarm (
ADD COLUMN collection_id VARCHAR(255),
ADD FOREIGN KEY (component_guid) REFERENCES component(component_guid)
);

which for some reason cannot be used to migrate the Derby database.
Instead it should be:

ALTER TABLE alarm ADD COLUMN collection_id VARCHAR(255);
ALTER TABLE alarm ADD FOREIGN KEY (component_guid) REFERENCES component(component_guid);