ALTER TABLE `player_vehicles` ADD CONSTRAINT FK_playervehicles_players FOREIGN KEY (citizenid) REFERENCES `players` (citizenid) ON DELETE CASCADE ON UPDATE CASCADE; Everything that says optional can ...