Drupal核心从7.56升级至7.59：运行update.php的数据库变更咨询

Hey there! Let's break down exactly what running update.php will do to your Drupal database now that you've upgraded core files from 7.56 to 7.59. Even though your status report shows the latest version and the site runs, these database changes are tied to critical security and performance fixes in the incremental releases (7.57, 7.58, 7.59):

Drupal 7.57 Specific Changes #

• Core version sync: Runs system_update_7080 to update all core module and theme version records in the system table to 7.57. This ensures Drupal's internal registry recognizes all core components are on the correct version.
• Field query performance boost: Executes field_sql_storage_update_7006 which adds a new index (field_data__entity_type_bundle) to the field_config_instance table. This speeds up database queries that filter fields by entity type and bundle, a big win for sites with lots of custom fields.

Drupal 7.58 Specific Changes #

• Core version bump: Runs system_update_7081 to update core component versions in the system table to 7.58.
• Session security hardening: Implements user_update_7017 which modifies the sessions table to store session IDs in a longer, more secure format. This fixes a session fixation vulnerability by making session IDs far harder to guess or manipulate.

Drupal 7.59 Specific Changes #

• Final core version sync: Executes system_update_7082 to set all core modules and themes to version 7.59 in the system table.
• File duplicate prevention: Runs file_update_7012 which adds a new uri_hash column to the file_managed table. This column stores a hash of each file's URI, letting Drupal efficiently detect duplicate uploads and block certain file-related security risks.

Quick Notes #

• These updates are non-destructive (always back up your database first, though!) — they modify tables/columns/indexes but won't delete your content or configuration.
• Skipping update.php leaves your database in an outdated state, even if the site seems to run. This could expose you to unpatched vulnerabilities or cause unexpected behavior later on.

内容的提问来源于stack exchange，提问作者Tusar