CREATE TABLE `demandes` (
  `nom` varchar(14)  NOT NULL,
  `prenom` varchar(14) NOT NULL,
  `adresse` varchar(40) NOT NULL,
  `codepostal` int(5) NOT NULL,
  `ville` varchar(30) NOT NULL,
  `telephone` varchar(14) NOT NULL,
  `mail` varchar(30) NOT NULL,
  `typeclient` enum('entreprise','artisan','association','collectivite','particulier') NOT NULL,
  `secteur` varchar(90) NOT NULL,
  `projet` enum('creation','refonte','boutique','domaine') NOT NULL,
  `date` varchar(20) NOT NULL,
  `reference` int(3) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`reference`)
)  AUTO_INCREMENT=1 ;