function trigger_update_7000 in Drupal 7

Alter the "hook" field and drop the "op field" of {trigger_assignments}.

Increase the length of the "hook" field to 78 characters and adds operation names to the hook names, and drops the "op" field.

File

modules/trigger/trigger.install, line 63

Install, update and uninstall functions for the trigger module.

Code

function trigger_update_7000() {
  db_drop_primary_key('trigger_assignments');
  db_change_field('trigger_assignments', 'hook', 'hook', array(
    'type' => 'varchar',
    'length' => 78,
    'not null' => TRUE,
    'default' => '',
    'description' => 'Primary Key: The name of the internal Drupal hook; for example, node_insert.',
  ));
  $result = db_query("SELECT hook, op, aid FROM {trigger_assignments} WHERE op <> ''");
  foreach ($result as $record) {
    db_update('trigger_assignments')
      ->fields(array(
      'hook' => $record->hook . '_' . $record->op,
    ))
      ->condition('hook', $record->hook)
      ->condition('op', $record->op)
      ->condition('aid', $record->aid)
      ->execute();
  }
  db_drop_field('trigger_assignments', 'op');
  db_add_primary_key('trigger_assignments', array(
    'hook',
    'aid',
  ));
}