Trigger module - broken DB index, no Primary key

The {trigger_assignments} table has a broken index declaration, and lacks a primary key

Re-rolling the part of the patch here: http://drupal.org/node/164532 that was for the Action module (prior to re-naming).