MySQL Forums
Forum List  »  InnoDB

Cannot add foreign key constraint (1215)
Posted by: Eric Stein
Date: July 11, 2013 02:51PM

Hi,
I'm trying to create a foreign key constraint on a new table, but I keep seeing an error. I don't see what the problem is. Can anybody help me out? At least, how do I get more information to debug this?

If this is the wrong forum, can somebody please point me to the right one? Also, I don't see how to add tags (like <pre> or
), so sorry for the formatting. I can edit the post if somebody tells me how to mark it up correctly.

Thanks,
Eric Stein

CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `email` varchar(75) NOT NULL,
  `password` varchar(128) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `last_login` datetime NOT NULL,
  `date_joined` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8$$			

CREATE TABLE `tastypie_apikey` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `user_id` integer NOT NULL UNIQUE,
    `key` varchar(255) NOT NULL,
    `created` datetime NOT NULL
);

0 row(s) affected Records: 0  Duplicates: 0  Warnings: 0

ALTER TABLE `tastypie_apikey` 
ADD CONSTRAINT `user_id_refs_id_56bfdb62` 
FOREIGN KEY (`user_id`) 
REFERENCES `auth_user` (`id`);

Error Code: 1215. Cannot add foreign key constraint



Edited 1 time(s). Last edit at 07/11/2013 02:53PM by Eric Stein.

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot add foreign key constraint (1215)
44363
July 11, 2013 02:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.