MIgrations file for ci_sessions - issue creating a relabelled key as required by CI session library - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22) +--- Thread: MIgrations file for ci_sessions - issue creating a relabelled key as required by CI session library (/showthread.php?tid=47518) |
MIgrations file for ci_sessions - issue creating a relabelled key as required by CI session library - El Forum - 12-12-2011 [eluser]Ollie Rattue[/eluser] Just started playing with the migrations library. First table to create is the ci_sessions table as defined in the user guide at http://ellislab.com/codeigniter/user-guide/libraries/sessions.html as follows: Code: CREATE TABLE IF NOT EXISTS `ci_sessions` ( So I write my definition in application/migrations/001_add_ci_sessions: Code: <?php defined('BASEPATH') OR exit('No direct script access allowed'); The problem is this line: Code: KEY `last_activity_idx` (`last_activity`) The field has been relabelled `last_activity_idx`. It doesn't look like it is possible to do this using the db_forge library - see http://=http://ellislab.com/codeigniter/user-guide/database/forge.html#add_key]http://ellislab.com/codeigniter/user-guide/database/forge.html#add_key So how do I do this? Surely the migrations library is capable of migration a CI predefined schema MIgrations file for ci_sessions - issue creating a relabelled key as required by CI session library - El Forum - 08-02-2012 [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. |