ALTER TABLE `tabla_a`
  ADD PRIMARY KEY (`ID`);

ALTER TABLE `tabla_b`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `relation` (`a_id`);

ALTER TABLE `tabla_b`
  ADD CONSTRAINT `r_id` FOREIGN KEY (`a_id`) REFERENCES `tabla_a` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;