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

-- Alter datalists to have a primary key
ALTER TABLE `prefix_datalists` DROP KEY `name`;
ALTER TABLE `prefix_datalists` ADD PRIMARY KEY `name` (`name`);