1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
CREATE TABLE `ville_statistique` (
`idVille` int(10) unsigned NOT NULL,
`race_0` tinyint(3) unsigned NOT NULL default '0',
`race_1` tinyint(3) unsigned NOT NULL default '0',
`race_2` tinyint(3) unsigned NOT NULL default '0',
`race_3` tinyint(3) unsigned NOT NULL default '0',
`sexe_0` tinyint(3) unsigned NOT NULL default '0',
`sexe_1` tinyint(3) unsigned NOT NULL default '0',
`metier_A` tinyint(3) unsigned NOT NULL default '0',
`metier_B` tinyint(3) unsigned NOT NULL default '0',
`metier_C` tinyint(3) unsigned NOT NULL default '0',
`metier_D` tinyint(3) unsigned NOT NULL default '0',
`metier_E` tinyint(3) unsigned NOT NULL default '0',
`total` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`idVille`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='statistique de la population d''une ville'; |