DROP TABLE IF EXISTS `internet`; CREATE TABLE `internet` ( `clef` int(10) unsigned zerofill NOT NULL auto_increment, `message` varchar(255) default NULL, `email` varchar(255) default NULL, `sexe` int(1) default NULL, `age` int(3) default NULL, `departement` int(3) default NULL, `region_origine` int(3) default NULL, `pays_origine` int(3) default NULL, `personne` int(1) default NULL, `demande` varchar(50) default NULL, `themes` varchar(50) default NULL, `pathologie1` int(2) default NULL, `situation1` int(2) default NULL, `pathologie2` int(2) default NULL, `situation2` int(2) default NULL, `risque_datant` int(2) default NULL, `situation_depistage` int(2) default NULL, `pratique` int(2) default NULL, `preservatif` int(2) default NULL, `type_relation` int(2) default NULL, `contexte_risque` varchar(50) default NULL, `remarques` text, PRIMARY KEY (`clef`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;