function password_policy_update_7202 in Password Policy 7.2

Delete not used item for table "password_policy_history".

If upgrading from 1.x, this should have been already done in 1.x and is not repeated here.

File

./password_policy.install, line 193

Install functions for Password Policy module.

Code

function password_policy_update_7202() {
  if (db_field_exists('password_policy_history', 'hid')) {
    $query = db_select('password_policy_history', 'p');
    $query
      ->leftJoin('users', 'u', 'p.uid = u.uid');
    $query
      ->isNull('u.uid');
    $query
      ->fields('p', array(
      'uid',
      'hid',
    ));
    foreach ($query
      ->execute() as $record) {
      db_delete('password_policy_history')
        ->condition('uid', $record->uid)
        ->condition('hid', $record->hid)
        ->execute();
    }
  }
}