db->field_exists('user_gridmap_default_band', 'users')) { $fields = array( 'user_gridmap_default_band varchar(10) default NULL', ); $this->dbforge->add_column('users', $fields); } if (!$this->db->field_exists('user_gridmap_confirmation', 'users')) { $fields = array( 'user_gridmap_confirmation varchar(3) default NULL', ); $this->dbforge->add_column('users', $fields); } $data = array( 'user_gridmap_default_band' => 'All', 'user_gridmap_confirmation' => 'QL', ); $this->db->update('users', $data); } public function down() { $this->dbforge->drop_column('users', 'user_gridmap_default_band'); $this->dbforge->drop_column('users', 'user_gridmap_confirmation'); } }