CREATE TABLE `avia_brevets` ( `b_id_num` tinyint(3) unsigned NOT NULL, `b_id_alpha` tinyint(3) unsigned NOT NULL, `b_nom` varchar(30) NOT NULL, `b_prenom` varchar(20) NOT NULL, `b_num` varchar(5) NOT NULL, UNIQUE KEY `b_idx` (`b_id_num`,`b_id_alpha`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8