Tak wygląda kod tej bazy:
DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identifier', `username` varchar(32) NOT NULL DEFAULT '', `password` varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `ID` (`id`), KEY `login` (`username`), KEY `password` (`password`), CONSTRAINT `password` FOREIGN KEY (`password`) REFERENCES `realmd`.`account` (`sha_pass_hash`), CONSTRAINT `ID` FOREIGN KEY (`id`) REFERENCES `realmd`.`account` (`id`), CONSTRAINT `Login` FOREIGN KEY (`username`) REFERENCES `realmd`.`account` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account System';
Z góry dziękuje za pomoc.