php - 使用 dbForge 插入查询未插入默认值

Question

我试图将默认值插入到新创建的表中，但是创建的表没有任何值。创建表后如何使用 dbForge 插入值？

我的 Controller 代码如下:

    $fields = array('id' => 
                    array('type' => 'INT','constraint' => 11,
                    'unsigned' => TRUE,'auto_increment' => TRUE),
                    'home_bg' => array('type' => 'VARCHAR','constraint' => '200',),
                    'login_bg' => array('type' => 'VARCHAR','constraint' => '200',),
                    'other_bg' => array('type' =>'VARCHAR','constraint' => '200',),
                    'uploaded_on' => array('type' => 'DATE',),);
    $this->dbforge->add_field($fields);
    $this->dbforge->add_key('id', TRUE);
    $this->dbforge->create_table('pr_backgrounds', TRUE);

Answer 1

试试这个

     $fields = array(
                            'id' => array(
                                             'type' => 'INT',
                                             'constraint' => 11,
                                             'unsigned' => TRUE,
                                             'auto_increment' => TRUE
                                         ),
                            'home_bg' => array(
                                                     'type' => 'VARCHAR',
                                                     'constraint' => '200',
                                              ),
                            'other_bg' => array(
                                                     'type' =>'VARCHAR',
                                                     'constraint' => '200',
                                              ),
                            'uploaded_on' => array(
                                                     'type' => 'DATE'
                                              ),
                    );

        $this->dbforge->add_field($fields);
        $this->dbforge->add_key('id', TRUE);
        $this->dbforge->create_table('ipn_log', TRUE);