ci 动态创建数据库

private function crBoxLogTb(){
    //如数据配置文件有配置表前缀，这里会自动追加
    $table      = 'log_'.date('Y_m_d');
    $isExist    = $this->db->table_exists($table);
    if($isExist){return $table;}

    //表字段
    $fields = array(
        'id'            => array(
            'type'              => 'INT',
            'constraint'        => 11,
            'unsigned'          => TRUE,
            'auto_increment'    => TRUE,
            'comment'           => "自增ID"
        ),

        'uid'           => array(
            'type'              => 'BIGINT',
            'constraint'        => '20',
            'comment'           => "用户ID"
        ),

        'log_id'        => array(
            'type'              => 'INT',
            'constraint'        => 11,
            'unsigned'          => TRUE,
            'comment'           => "日志描述id"
        ),

        'addtime'       => array(
            'type'              => 'INT',
            'constraint'        => 11,
            'unsigned'          => TRUE,
            'comment'           => "添加时间"
        ),
    );

    //索引
    $indexF           = array('uid',);

    //表引擎、别名
    $attributes         = array('ENGINE' => 'InnoDB','COMMENT'=>"'用户、游客登陆表'");

    //主键
    $primary            = 'id';

    //加载数据库工厂类
    $this->myforge   = $this->load->dbforge($this->db, TRUE);

    $this->myforge->add_field($fields);
    $this->myforge->add_key($primary, TRUE);
    $this->myforge->add_key($indexF);
    $this->myforge->create_table($table, TRUE,$attributes);

    $isExist    = $this->db->table_exists($table);
    if($isExist){return $table;}

    return false;
}

转载于:https://my.oschina.net/u/3268486/blog/1841275