1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
CREATE TABLE `unites` (
`id_unite` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_joueur` int(10) unsigned NOT NULL,
`fantassin_masse_arme` mediumint(8) unsigned NOT NULL,
`fantassin_vouge` mediumint(8) unsigned NOT NULL,
`fantassin_fleau` mediumint(8) unsigned NOT NULL,
`fantassin_pique` mediumint(8) unsigned NOT NULL,
`fantassin_hallebarde` mediumint(8) unsigned NOT NULL,
`archer` mediumint(8) unsigned NOT NULL,
`archer_long` mediumint(8) unsigned NOT NULL,
`arbaletrier` mediumint(8) unsigned NOT NULL,
`cavalier_epee` mediumint(8) unsigned NOT NULL,
`arquebusier` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`id_unite`),
KEY `id_joueur` (`id_joueur`),
CONSTRAINT `unites_ibfk_1` FOREIGN KEY (`id_joueur`) REFERENCES `joueurs` (`id_joueur`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; |
Partager