function vcardfield_update_7003 in VCard Field 7

Implements hook_update_N(). Add middle name field

File

./vcardfield.install, line 184

Code

function vcardfield_update_7003(&$sandbox) {
  $fields = field_info_fields();
  foreach ($fields as $field_name => $field) {
    if ($field['type'] == 'vcardfield' && $field['storage']['type'] == 'field_sql_storage') {
      $schema = vcardfield_field_schema($field);
      foreach ($field['storage']['details']['sql'] as $type => $table_info) {
        foreach ($table_info as $table_name => $columns) {
          $column_name = _field_sql_storage_columnname($field_name, 'middle_name');
          if (!db_field_exists($table_name, $column_name)) {
            db_add_field($table_name, $column_name, $schema['columns']['middle_name']);
            db_add_index($table_name, $column_name, array(
              $column_name,
            ));
          }
        }
      }
    }
  }
  field_cache_clear();
}