ALTER TABLE `event_payment` ADD `registration_id` INT(10) NULL, ADD KEY `fk_event_payment_registration_id` (`registration_id`), ADD CONSTRAINT `fk_event_payment_registration_id` FOREIGN KEY (`registration_id`) REFERENCES `event_registration` (`registration_id`) ON UPDATE CASCADE;