Re: problem adding foreign key...

[patrick wallin]

I have same problem but the "mysql_membership" is an automatic created table for ASP.NET (login).

The following will return an error (1005) such as cannot create table due to foreign key:

use KeywordPreviewer;

DROP TABLE IF EXISTS UserInfo;

CREATE TABLE UserInfo (
UserInfoID int not null,
MembershipID varchar(36) not null,
CompanyName varchar(255),
AddressLineOne varchar(255),
AddressLineTwo varchar(255),
AddressLineThree varchar(255),
AddressLineFour varchar(255),
WebsiteAddress varchar(255),
EmailAddress varchar(255),
PhoneNumber varchar(255),
CellNumber varchar(255),
TollNumber varchar(255),
PRIMARY KEY (UserInfoID),
INDEX (MembershipID),
CONSTRAINT FOREIGN KEY (MembershipID) REFERENCES mysql_membership (PKID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I read your message that I would have to add unique key for PKID in mysql_membership. Should I do it even the table is special for login?