Проблема с внешним ключом

CREATE TABLE all_events
(
    event_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name_event VARCHAR (256) NOT NULL,
    DATE VARCHAR (64) NOT NULL,
    location VARCHAR (128) NOT NULL     
);

CREATE TABLE all_fightings
(
    fightind_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    Name_event VARCHAR (256) NOT NULL,
    Fighter_1 VARCHAR (64) NOT NULL,
    Fighter_2 VARCHAR (64) NOT NULL,
    Winner VARCHAR (64) NOT NULL,
    Weight VARCHAR (64) NOT NULL,
    Method VARCHAR (64) NOT NULL,
    Stroke VARCHAR (64) NOT NULL,
    Round VARCHAR (64) NOT NULL,
    TIME VARCHAR (64) NOT NULL     
)

ALTER TABLE all_fighting ADD all_events_id INT NOT NULL;
ALTER TABLE all_fighting 
ADD FOREIGN KEY (all_events_id) REFERENCES all_events(event_id) ON DELETE CASCADE;

LTER TABLE all_fighting 
ADD FOREIGN KEY (all_events_id) REFERENCES all_events(event_id) ON DELETE CASCADE;

CREATE TABLE all_events
(
    name_event VARCHAR (256) NOT NULL PRIMARY KEY,
    DATE VARCHAR (64) NOT NULL,
    location VARCHAR (128) NOT NULL    
);
 
ALTER TABLE all_fighting 
ADD FOREIGN KEY (name_event) REFERENCES all_events(name_event) ON DELETE CASCADE;