Description
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);