Выполняем запрос:
ALTER TABLE `cms3_fields_controller` ADD CONSTRAINT `FK_rel to field` FOREIGN KEY (`field_id`) REFERENCES `cms3_object_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ALTER TABLE `cms3_fields_controller` ADD CONSTRAINT `FK_rel to field` FOREIGN KEY (`field_id`) REFERENCES `cms3_object_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `FK_rel to field group` FOREIGN KEY (`group_id`) REFERENCES `cms3_object_field_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
На что получаем ответ от MySQL:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `cms3_fields_controller` ADD CONSTRAINT `FK_rel to field` FOREIGN KEY (' at line 3
Apache/2.2.17 (Debian), Версия сервера: 5.1.56
Может кто-нибудь знает как побороть?
