ALTER TABLE assignments
  DROP PRIMARY KEY;

ALTER TABLE assignments
  ADD COLUMN id INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

ALTER TABLE assignments
  ADD UNIQUE KEY uq_assignments_event_slot_child (event_id, event_slot_id, child_id);