title: mysql refference key issue, phpmyadmin error code 150
body: <p>I am trying to create two table as below,</p>
  
  <pre><code>--
  -- Table structure for table `users`
  --
  
  CREATE TABLE IF NOT EXISTS `users` (   `Id` int(11) NOT NULL
  AUTO_INCREMENT,   `UserType` varchar(32) DEFAULT NULL,   `FirstName`
  varchar(64) DEFAULT NULL,   `LastName` varchar(64) DEFAULT NULL,  
  `Email` varchar(64) DEFAULT NULL,   `CompanyName` varchar(64) DEFAULT
  NULL,   `Telephone` varchar(64) DEFAULT NULL,   `Country` varchar(64)
  DEFAULT NULL,   `Website` varchar(64) DEFAULT NULL,   `JobTitle`
  varchar(64) DEFAULT NULL,   `Active` int(1) DEFAULT NULL,   `Notes`
  text,   `DateOfRegistration` datetime DEFAULT NULL,   PRIMARY KEY
  (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  
  --
  -- Table structure for table `login`
  --
  
  CREATE TABLE IF NOT EXISTS `login` (   `Id` int(11) NOT NULL,  
  `Username` varchar(64) NOT NULL,   `Email` varchar(64) NOT NULL,  
  `Password` varchar(64) NOT NULL,   `FailedAttemptCount` int(2) NOT
  NULL,   `LastLogin` datetime NOT NULL,   `UserLevel` int(1) NOT NULL, 
  `IsVerified` int(1) NOT NULL DEFAULT '0',   `VerificationKey`
  varchar(256) NOT NULL,   `VerifiKeyCreated` datetime NOT NULL,  
  PRIMARY KEY (`Id`),   FOREIGN KEY (`Id`) REFERENCES users.Id,   UNIQUE
  KEY `username` (`Username`),   UNIQUE KEY `Email` (`Email`) )
  ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>I want to add a foreign key i.e. login.Id references users.Id, but I am getting error(code 150) in phpmyadmin.</p>
  
  <p>Thanks in advance for your help!</p>
  
  <p>Best Regards,
  Rajib</p>