function system_update_7042

Upgrade the {url_alias} table and create a cache bin for path aliases.

Related topics

File

modules/system/system.install, line 2419

Code

function system_update_7042() {
    // update_fix_d7_requirements() adds 'fake' source and alias columns to
    // allow bootstrap to run without fatal errors. Remove those columns now
    // so that we can rename properly.
    db_drop_field('url_alias', 'source');
    db_drop_field('url_alias', 'alias');
    // Drop indexes.
    db_drop_index('url_alias', 'src_language_pid');
    db_drop_unique_key('url_alias', 'dst_language_pid');
    // Rename the fields, and increase their length to 255 characters.
    db_change_field('url_alias', 'src', 'source', array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
    ));
    db_change_field('url_alias', 'dst', 'alias', array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
    ));
    // Add indexes back. We replace the unique key with an index since it never
    // provided any meaningful unique constraint ('pid' is a primary key).
    db_add_index('url_alias', 'source_language_pid', array(
        'source',
        'language',
        'pid',
    ));
    db_add_index('url_alias', 'alias_language_pid', array(
        'alias',
        'language',
        'pid',
    ));
    // Now that the URL aliases are correct, we can rebuild the whitelist.
    drupal_path_alias_whitelist_rebuild();
}