function trigger_update_7000
7.x trigger.install | trigger_update_7000() |
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
- drupal-7.x/
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'));
}