Untitled 3/30/2018 9:18:10 PM

Hata SQL sorgusu: CREATE TABLE `transactions` ( `TransactionID` int(244) NOT NULL AUTO_INCREMENT, `TransactionAmount` int(244) NOT NULL, `TransactionVerifySign` blob NOT NULL, `TransactionUserID` int(244) NOT NULL, `TransactionPlanID` int(244) NOT NULL, `TransactionDate` int(244) NOT NULL, PRIMARY KEY (`TransactionID`), KEY `transuserid` (`TransactionUserID`), KEY `transplanid` (`TransactionPlanID`), CONSTRAINT `transplanid` FOREIGN KEY (`TransactionPlanID`) REFERENCES `plans` (`PlanID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `transuserid` FOREIGN KEY (`TransactionUserID`) REFERENCES `users` (`UserID`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 MySQL çıktısı: Belgeler #1005 - Can't create table `jershyco_1`.`transactions` (errno: 150 "Foreign key constraint is incorrectly formed") (Ayrıntılar…)