1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| CREATE TABLE `information` (
`num` int(11) NOT NULL auto_increment,
`nom_prenom` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`date_lieu_naissance` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`date_recrutement` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`diplome_recrutement` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`niveau_scolaire` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`diplome_actuel` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`grade` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`echelon` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`dernier_changement` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`anciennete` varchar(50) character set utf8 collate utf8_bin NOT NULL,
`etat_actuel` varchar(50) character set utf8 collate utf8_bin NOT NULL,
PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; |
Partager