MIgrations file for ci_sessions - issue creating a relabelled key as required by CI session library

[eluser]Unknown[/eluser]
Hate to revive an old thread but here is a solution. Just add this at the end of your up function after you call create_table:

Code:

$this->db->query('ALTER TABLE `ci_sessions` ADD KEY `last_activity_idx` (`last_activity`)');

Ghetto, but it works.