function library_update_6203 in Library 6.2

File

./library.install, line 253

@author Jess Straatmann library.install Install and uninstall all required databases. Also do incremental database updates.

Code

function library_update_6203() {
  $ret = array();
  if (module_exists('patron')) {

    //Insert patron uids into transactions table
    $ret[] = update_sql("UPDATE {library_transactions} lt JOIN {library_patrons} lp on lt.patron_id = lp.nid SET lt.patron_id = lp.patron_uid");

    //Schema update to transactions table
    db_drop_index($ret, 'library_transactions', 'patron_id');
    $spec = array(
      'description' => t('The associated patron user.'),
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    );
    db_change_field($ret, 'library_transactions', 'patron_id', 'uid', $spec);
    db_add_index($ret, 'library_transactions', 'uid', array(
      'uid',
    ));
  }
  return $ret;
}