You are here

public function DatabaseSchema_sqlite::dropField in Drupal 7

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;
}