Witam,
słuchajcie, zgłupiałem - nie mogę stworzyć klucza obcego do tabeli:
mam dwie następujace tabele:
CREATE TABLE IF NOT EXISTS `pep_peptides` ( `peptides_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `peptides_name` varchar(30) NOT NULL, `peptides_sequence` varchar(200) NOT NULL, `peptides_Nterm` int(10) UNSIGNED NOT NULL DEFAULT '0', `peptides_Cterm` int(10) UNSIGNED NOT NULL DEFAULT '0', `peptides_user` int(10) UNSIGNED NOT NULL DEFAULT '0', `peptides_active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (`peptides_id`), KEY `peptides_user` (`peptides_user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=153 ;
CREATE TABLE IF NOT EXISTS `pep_users` ( `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `user_name` varchar(10) NOT NULL, `user_realName` varchar(30) NOT NULL, `user_lastName` varchar(30) NOT NULL, `user_pass` varchar(50) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
ALTER TABLE `pep_peptides` ADD FOREIGN KEY (`peptides_user`) REFERENCES `pepsynth`.`pep_users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
google nie boli: http://lubik.info/php-mysql/cannot-add-or-update-a-child-row-czyli-jaki-jest-problem,52.html.
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)