1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
CREATE TABLE IF NOT EXISTS `t_adh` (
`code_adh` int(11) NOT NULL AUTO_INCREMENT,
`noms_adh` varchar(20) NOT NULL,
`prenoms_adh` varchar(50) NOT NULL,
`nomcomplet_adh` varchar(70) NOT NULL,
`lien_adh` varchar(30) NOT NULL,
`date_adh` date NOT NULL,
`sexe_adh` varchar(1) NOT NULL,
`nature_pi_adh` varchar(30) CHARACTER SET utf16 NOT NULL,
`numpiece_adh` int(11) NOT NULL,
`dateetabli_adh` date NOT NULL,
`numtel_adh` varchar(10) NOT NULL,
`code_identif_adh` varchar(20) NOT NULL,
`code_indem_adh` varchar(10) NOT NULL,
`use_adh` varchar(15) NOT NULL,
`date_enr_adh` date NOT NULL,
`horo_adh` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`host_adh` varchar(15) NOT NULL,
`pap_adh` varchar(30) NOT NULL,
`ville_adh` varchar(40) NOT NULL,
`vi_qua_adh` varchar(50) NOT NULL,
`posi_age_adh` varchar(20) CHARACTER SET utf32 NOT NULL,
PRIMARY KEY (`code_adh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
Partager