function user_update_7020

Add changed field to users table.

Related topics

File

modules/user/user.install, line 937

Code

function user_update_7020() {
    // The "changed" column was renamed to "access" in system_update_136(), and
    // the "changed" index on "access" column may persist on old MySQL databases.
    if (db_index_exists('users', 'changed')) {
        if (!db_index_exists('users', 'access')) {
            db_add_index('users', 'access', array(
                'access',
            ));
        }
        db_drop_index('users', 'changed');
    }
    $spec = array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
        'description' => 'Timestamp for when user was changed.',
    );
    $keys = array(
        'indexes' => array(
            'changed' => array(
                'changed',
            ),
        ),
    );
    // In some cases sites have added the changed field themselves e.g. via a
    // contrib or custom module. Ensure the field uses core's new schema.
    if (db_field_exists('users', 'changed')) {
        db_change_field('users', 'changed', 'changed', $spec, $keys);
    }
    else {
        db_add_field('users', 'changed', $spec, $keys);
        // Set the initial value for existing users.
        db_update('users')->expression('changed', 'created')
            ->execute();
    }
}