Elgg-Lorea-Hydra/engine/lib/upgrades/2012041801-1.8.3-multiple_user_tokens-852225f7fd89f6c5.php

<?php
/**
 * Elgg 1.8.3 upgrade 2012041801
 * multiple_user_tokens
 *
 * Fixes https://github.com/elgg/elgg/issues/4291
 * Removes the unique index on users_apisessions for user_guid and site_guid
 */

$db_prefix = elgg_get_config('dbprefix');
$q = "ALTER TABLE {$db_prefix}users_apisessions DROP INDEX user_guid,
	ADD INDEX user_guid (user_guid, site_guid)";
update_data($q);