public function DatabaseSchema_sqlite::dropField

public DatabaseSchema_sqlite::dropField($table, $field)

Drop a field.

Parameters

$table: The table to be altered.

$field: The field to be dropped.

Return value

TRUE if the field was successfully dropped, FALSE if there was no field by that name to begin with.

Overrides DatabaseSchema::dropField

File

includes/database/sqlite/schema.inc, line 471

Database schema code for SQLite databases.

Class

DatabaseSchema_sqlite

Code

public function dropField($table, $field) {
  if (!$this->fieldExists($table, $field)) {
    return FALSE;
  }

  $old_schema = $this->introspectSchema($table);
  $new_schema = $old_schema;

  unset($new_schema['fields'][$field]);
  foreach ($new_schema['indexes'] as $index => $fields) {
    foreach ($fields as $key => $field_name) {
      if ($field_name == $field) {
        unset($new_schema['indexes'][$index][$key]);
      }
    }
    // If this index has no more fields then remove it.
    if (empty($new_schema['indexes'][$index])) {
      unset($new_schema['indexes'][$index]);
    }
  }
  $this->alterTable($table, $old_schema, $new_schema);
  return TRUE;
}