<?php
class Migration_Create_Sessions extends CI_Migration{
public function up()
{
$fields = array(
"session_id varchar(40) DEFAULT '0' NOT NULL",
"ip_address varchar(45) DEFAULT '0' NOT NULL",
"user_agent varchar(120) NOT NULL",
"last_activity int(10) unsigned DEFAULT 0 NOT NULL",
"user_data text DEFAULT '' NOT NULL"
);
$this->dbforge->add_field($fields);
$this->dbforge->add_Key('session_id',true);
$this->dbforge->create_table('ci_sessions');
$this->db->query('ALTER TABLE `ci_sessions` ADD KEY `last_activity_idx` (`last_activity`) ');
}
public function down()
{
$this->dbforge->drop_table('ci_sessions');
}
}
CI session数据表 迁移类,注意外键要手动写。
最新推荐文章于 2024-03-18 17:59:28 发布