11 lines
367 B
SQL
11 lines
367 B
SQL
ALTER TABLE `notification`
|
|
ADD COLUMN `participant_id` INT UNSIGNED NULL DEFAULT NULL AFTER `shipcall_id`,
|
|
ADD INDEX `FK_NOTIFICATION_PARTICIPANT_idx` (`participant_id` ASC) VISIBLE;
|
|
;
|
|
ALTER TABLE `notification`
|
|
ADD CONSTRAINT `FK_NOTIFICATION_PARTICIPANT`
|
|
FOREIGN KEY (`participant_id`)
|
|
REFERENCES `participant` (`id`)
|
|
ON DELETE RESTRICT
|
|
ON UPDATE RESTRICT;
|