player table -> id, username, password
bank table -> id, player_id, slot, item, amount
Code:
CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` int(9) DEFAULT NULL,
`username` varchar(12) DEFAULT NULL,
`password` char(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `player_bank` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`player_id` int(11) unsigned NOT NULL,
`slot` smallint(3) NOT NULL,
`item` smallint(5) NOT NULL,
`amount` int(11) NOT NULL,
PRIMARY KEY (`id`,`player_id`),
KEY `FK__players` (`player_id`),
CONSTRAINT `player_bank_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
remember mysql is a RELATIONAL database.
http://www.anchor.com.au/hosting/sup...tionalDatabase Some very good explanations and examples