Advertisement
rodro1

Session CI Migration class

Aug 24th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. class Migration_Create_Sessions extends CI_Migration {
  2.  
  3.   public function up()
  4.   {
  5.     $fields = array(
  6.       'session_id VARCHAR(40) DEFAULT \'0\' NOT NULL',
  7.       'ip_address VARCHAR(45) DEFAULT \'0\' NOT NULL',
  8.       'user_agent VARCHAR(120) NOT NULL',
  9.       'last_activity INT(10) unsigned DEFAULT 0 NOT NULL',
  10.       'user_data text NOT NULL'
  11.     );
  12.  
  13.     $this->dbforge->add_field($fields);
  14.     $this->dbforge->add_key('session_id', TRUE);
  15.     $this->dbforge->create_table('ci_sessions');
  16.   $this->db->query('ALTER TABLE `ci_sessions` ADD KEY `last_activity_idx` (`last_activity`)');  
  17.   }
  18.  
  19.   public function down()
  20.   {
  21.     $this->dbforge->drop_table('ci_sessions');
  22.   }
  23.  
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement