/**
  * test rename column
  */
 public function test_rename_column()
 {
     //create it
     $this->adapter->execute_ddl("CREATE TABLE `users` ( name varchar(20) DEFAULT 'abc' NOT NULL);");
     $before = $this->adapter->column_info("users", "name");
     $this->assertEquals('varchar(20)', $before['type']);
     $this->assertEquals('name', $before['field']);
     //rename the name column
     $this->adapter->rename_column('users', 'name', 'new_name');
     $after = $this->adapter->column_info("users", "new_name");
     $this->assertEquals('varchar(20)', $after['type']);
     $this->assertEquals('new_name', $after['field']);
     // assert that we didnt mess up the NOT NULL and DEFAULT
     $this->assertEquals('NO', $after['null']);
     $this->assertEquals('abc', $after['default']);
     $this->remove_table('users');
 }
Beispiel #2
0
 /**
  * Rename a column
  *
  * @param string $tbl_name        the name of the table
  * @param string $column_name     the column name
  * @param string $new_column_name the new column name
  *
  * @return boolean
  */
 public function rename_column($tbl_name, $column_name, $new_column_name)
 {
     return $this->_adapter->rename_column($tbl_name, $column_name, $new_column_name);
 }