Club Drupal

        'binary' => TRUE,

    // Retrieve a list of duplicate files with the same filepath. Only the

    // most-recently uploaded of these will be moved to the new {file_managed}

    // table (and all references will be updated to point to it), since

    // duplicate file URIs are not allowed in Drupal 7.

    // Since the Drupal 6 to 7 upgrade path leaves the {files} table behind

    // after it's done, custom or contributed modules which need to migrate

    // file references of their own can use a similar query to determine the

    // file IDs that duplicate filepaths were mapped to.

    $sandbox['duplicate_filepath_fids_to_use'] = db_query("SELECT filepath, MAX(fid) FROM {files} GROUP BY filepath HAVING COUNT(*) > 1")->fetchAllKeyed();

      // If this file has a duplicate filepath, replace it with the

      // most-recently uploaded file that has the same filepath.

      if (isset($sandbox['duplicate_filepath_fids_to_use'][$file['filepath']]) && $record->fid != $sandbox['duplicate_filepath_fids_to_use'][$file['filepath']]) {

        $file = db_select('files', 'f')

          ->fields('f', array('fid', 'uid', 'filename', 'filepath', 'filemime', 'filesize', 'status', 'timestamp'))

          ->condition('f.fid', $sandbox['duplicate_filepath_fids_to_use'][$file['filepath']])

          ->execute()

          ->fetchAssoc();

      }

/**

 * Convert the 'format' column in {date_format_locale} to case sensitive varchar.

 */

function system_update_7080() {

  $spec = array(

    'description' => 'The date format string.',

    'type' => 'varchar',

    'length' => 100,

    'not null' => TRUE,

    'binary' => TRUE,

  );

  db_change_field('date_format_locale', 'format', 'format', $spec);

}