Elgg-Lorea-Hydra/engine/schema/upgrades/2009091901.sql

-- add an additional column to the river table
ALTER TABLE `prefix_river` ADD COLUMN `annotation_id` int(11) NOT NULL AFTER `object_guid`;
ALTER TABLE `prefix_river` ADD KEY `annotation_id` (`annotation_id`);