-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lun 09 Novembre 2009 à 09:32
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de données: `garage`
--
CREATE DATABASE `garage` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `garage`;

-- --------------------------------------------------------

--
-- Structure de la table `tblclients`
--

CREATE TABLE IF NOT EXISTS `tblclients` (
  `numClient` int(11) NOT NULL DEFAULT '0',
  `civ` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `prenom` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `nom` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `dateNaissance` datetime DEFAULT NULL,
  `adresse` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `numVille` int(11) DEFAULT NULL,
  `telProf` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `telPriv` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `fax` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `tblclients`
--

INSERT INTO `tblclients` (`numClient`, `civ`, `prenom`, `nom`, `dateNaissance`, `adresse`, `numVille`, `telProf`, `telPriv`, `fax`) VALUES
(1, 'Mme', 'Carole', 'Bouquet', '1957-08-08 00:00:00', '8, Bd de la ramée', 4, '0561381813', '0562458714', NULL),
(2, 'Mme', 'Josianne', 'Balasko', '1955-12-31 00:00:00', '307, rue Calme', 3, '0562467849', '0561392487', NULL),
(3, 'Mle', 'Juliette', 'Binoche', '1955-12-31 00:00:00', '148, Av  des Planches', 8, '0523894562', '0619430945', '0562784254'),
(4, 'Mle', 'Isabelle', 'Adjani', '1955-06-27 00:00:00', '23, rue du Port', 10, '0634613493', '0562529463', NULL),
(5, 'Mme', 'Fanny', 'Ardant', '1949-03-22 00:00:00', '46, place du marché', 13, '0562757834', NULL, '0562757843'),
(6, 'Mme', 'Emmanuelle', 'Béart', '1965-08-14 00:00:00', '31, Bd de la Ramée', 6, '0561243967', '0561401836', NULL),
(7, 'Mle', 'Julia', 'Roberts', '1967-10-28 00:00:00', '92, chemin du Touch', 1, '0562935427', '0561486203', NULL),
(8, 'Mme', 'Kim', 'Bassinger', '1963-12-08 00:00:00', '27, Bd de la Ramée', 5, '0561038500', NULL, '0562466733'),
(9, 'Mle', 'Cameron', 'Diaz', '1972-08-30 00:00:00', '164, rue du téméraire', 4, '0561024358', NULL, NULL),
(10, 'Mme', 'Miou', 'Miou', '1950-02-20 00:00:00', '102, rue de la République', 3, '0562939495', '0561218456', NULL),
(11, 'Mle', 'Romane', 'Bohringer', NULL, '66, rue Descartes', 20, '0645983165', '0562014784', NULL),
(12, 'Mme', 'Sophie', 'Marceau', '1966-11-17 00:00:00', '13, av de Provence', 8, '0561374812', '0561277013', NULL),
(13, 'Mme', 'Isabelle', 'Huppert', NULL, '36, av de l''église', 23, '0647092453', '0562442700', NULL),
(14, 'M.', 'Jean-hugues', 'Anglade', NULL, '10, place Jeanne D''Arc', 2, '0561033663', '0561484259', NULL),
(15, 'M.', 'Daniel', 'Auteuil', '1950-06-24 00:00:00', '1, rue de la Sauvegarde', 19, '0561390288', NULL, '0562375849'),
(16, 'M.', 'Michel', 'Blanc', NULL, '89, place de la Nation', 1, '0639939410', '0561255412', NULL),
(17, 'M.', 'Alain', 'Chabat', '1958-11-24 00:00:00', '33, route des sciences', 5, '0561439256', '0561473625', NULL),
(18, 'M.', 'Georges', 'Clooney', '1961-05-06 00:00:00', '15, place Dupuy', 4, '0562349254', '0561294268', NULL),
(19, 'Mme', 'Marie-Anne', 'Chazel', NULL, '94, rue des saltimbanques', 2, '0506271459', '0506294186', NULL),
(20, 'M.', 'Christian', 'Clavier', NULL, '148, allée du ponant', 24, NULL, '0561358279', NULL),
(21, 'M.', 'Alain', 'Delon', '1935-11-08 00:00:00', '5, rue d''Indochine', 14, '0561824538', '0561326179', NULL),
(22, 'M.', 'Gérard', 'Depardieu', NULL, '77, chemin du Touch', 10, '0562379513', NULL, '0562493627');

-- --------------------------------------------------------

--
-- Structure de la table `tblcompetences`
--

CREATE TABLE IF NOT EXISTS `tblcompetences` (
  `NumModele` int(11) NOT NULL DEFAULT '0',
  `NumEmploye` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`NumEmploye`,`NumModele`),
  KEY `NumEmploye` (`NumEmploye`),
  KEY `NumModele` (`NumModele`),
  KEY `NumEmploye_2` (`NumEmploye`),
  KEY `NumModele_2` (`NumModele`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `tblcompetences`
--

INSERT INTO `tblcompetences` (`NumModele`, `NumEmploye`) VALUES
(6, 53),
(9, 53),
(19, 53),
(21, 53),
(2, 56),
(6, 56),
(17, 56),
(25, 56),
(4, 58),
(15, 58),
(16, 58),
(24, 58),
(3, 59),
(8, 59),
(12, 59),
(19, 59),
(6, 61),
(10, 61),
(26, 61),
(7, 62),
(11, 62),
(14, 62),
(22, 62),
(28, 62),
(5, 65),
(6, 65),
(13, 65),
(23, 65),
(5, 67),
(9, 67),
(20, 67),
(3, 69),
(23, 69);

-- --------------------------------------------------------

--
-- Structure de la table `tblemployes`
--

CREATE TABLE IF NOT EXISTS `tblemployes` (
  `NumEmploye` int(11) NOT NULL AUTO_INCREMENT,
  `Nom` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Prenom` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Categorie` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Salaire` double DEFAULT NULL,
  PRIMARY KEY (`NumEmploye`),
  KEY `Nom` (`Nom`),
  KEY `Nom_2` (`Nom`,`Prenom`),
  KEY `NumEmploye` (`NumEmploye`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;

--
-- Contenu de la table `tblemployes`
--

INSERT INTO `tblemployes` (`NumEmploye`, `Nom`, `Prenom`, `Categorie`, `Salaire`) VALUES
(53, 'lelac', 'Clément', 'Mécano', 2500),
(54, 'Faust-Pazen', 'Hervé', 'Assistant', 1000),
(55, 'Surplace', 'Cloé', 'Assistant', 1200),
(56, 'matelot', 'Zoé', 'Mécano', 2000),
(57, 'd''oleron', 'Marie-Reine', 'Assistant', 1300),
(58, 'torinque', 'Rony', 'Mécano', 2130),
(59, 'pechala', 'Line', 'Mécano', 1950),
(60, 'ocecourge', 'Benoit', 'Assistant', 1500),
(61, 'cisseulman', 'José', 'Mécano', 2310),
(62, 'patry', 'Honoré', 'Mécano', 2400),
(63, 'lafilo', 'Sophie', 'Assistant', 1300),
(64, 'sonvieupor', 'Marcelle', 'Assistant', 1400),
(65, 'sonaylet', 'Martine', 'Mécano', 2400),
(66, 'voidedon', 'Rémi', 'Assistant', 1350),
(67, 'octet', 'Mégane', 'Mécano', 2500),
(68, 'oneret', 'Patrick', 'Assistant', 1400),
(69, 'plasme', 'Hector', 'Mécano', 2600),
(71, 'Menvussa', 'Gérard', 'Mécano', 2300),
(72, 'Dinissié', 'Denis', 'Assistant', 1700);

-- --------------------------------------------------------

--
-- Structure de la table `tblindisponibilites`
--

CREATE TABLE IF NOT EXISTS `tblindisponibilites` (
  `NumIndispo` int(11) NOT NULL AUTO_INCREMENT,
  `NumEmploye` int(11) DEFAULT NULL,
  `TypeIndispo` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `DebIndispo` datetime DEFAULT NULL,
  `FinIndispo` datetime DEFAULT NULL,
  PRIMARY KEY (`NumIndispo`),
  KEY `DebIndispo` (`DebIndispo`),
  KEY `FinIndispo` (`FinIndispo`),
  KEY `NumEmploye` (`NumEmploye`),
  KEY `NumIndispo` (`NumIndispo`),
  KEY `NumEmploye_2` (`NumEmploye`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Contenu de la table `tblindisponibilites`
--

INSERT INTO `tblindisponibilites` (`NumIndispo`, `NumEmploye`, `TypeIndispo`, `DebIndispo`, `FinIndispo`) VALUES
(1, 53, 'Congé', '2006-02-22 00:00:00', '2006-02-26 00:00:00'),
(2, 54, 'Congé', '2006-03-05 00:00:00', '2006-03-05 00:00:00'),
(3, 54, 'Formation', '2006-03-15 00:00:00', '2006-03-17 00:00:00'),
(4, 57, 'Congé', '2006-02-22 00:00:00', '2006-02-23 00:00:00'),
(5, 57, 'Congé', '2006-03-08 00:00:00', '2006-03-09 00:00:00'),
(6, 57, 'Congé', '2006-03-22 00:00:00', '2006-03-23 00:00:00'),
(7, 58, 'Congé', '2006-03-08 00:00:00', '2006-03-12 00:00:00'),
(8, 61, 'Congé', '2006-04-02 00:00:00', '2006-04-02 00:00:00'),
(9, 61, 'Congé', '2006-06-21 00:00:00', '2006-07-02 00:00:00'),
(10, 63, 'Congé', '2006-07-15 00:00:00', '2006-07-30 00:00:00'),
(11, 64, 'Congé', '2006-05-14 00:00:00', '2006-05-14 00:00:00'),
(12, 65, 'Congé', '2006-05-14 00:00:00', '2006-05-14 00:00:00'),
(13, 67, 'Congé', '2006-04-12 00:00:00', '2006-04-16 00:00:00'),
(14, 67, 'Congé', '2006-07-15 00:00:00', '2006-07-16 00:00:00'),
(15, 68, 'Formation', '2006-03-15 00:00:00', '2006-03-17 00:00:00'),
(16, 68, 'Congé', '2006-05-14 00:00:00', '2006-05-21 00:00:00'),
(17, 69, 'Formation', '2006-03-29 00:00:00', '2006-04-02 00:00:00'),
(18, 69, 'Congé', '2006-04-06 00:00:00', '2006-04-09 00:00:00'),
(19, 66, 'Formation', '2006-02-25 00:00:00', '2006-03-03 00:00:00');

-- --------------------------------------------------------

--
-- Structure de la table `tblintervenants`
--

CREATE TABLE IF NOT EXISTS `tblintervenants` (
  `NumIntervention` int(11) NOT NULL DEFAULT '0',
  `NumEmploye` int(11) NOT NULL DEFAULT '0',
  `Debut` datetime DEFAULT NULL,
  `Fin` datetime DEFAULT NULL,
  PRIMARY KEY (`NumIntervention`,`NumEmploye`),
  KEY `NumEmploye` (`NumEmploye`),
  KEY `NumIntervention` (`NumIntervention`),
  KEY `DateDebut` (`Debut`),
  KEY `DateFin` (`Fin`),
  KEY `NumEmploye_2` (`NumEmploye`),
  KEY `NumIntervention_2` (`NumIntervention`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `tblintervenants`
--

INSERT INTO `tblintervenants` (`NumIntervention`, `NumEmploye`, `Debut`, `Fin`) VALUES
(1, 54, '2006-02-26 09:00:00', '2006-02-26 12:00:00'),
(1, 59, '2006-02-25 09:00:00', '2006-02-25 18:00:00'),
(2, 57, '2006-02-24 14:00:00', '2006-02-24 18:00:00'),
(2, 59, '2006-02-23 09:00:00', '2006-02-24 12:00:00'),
(3, 60, '2006-04-09 09:00:00', '2006-04-09 12:00:00'),
(3, 65, '2006-04-06 14:00:00', '2006-04-08 18:00:00'),
(4, 62, '2006-05-14 09:00:00', '2006-05-14 12:00:00'),
(4, 66, '2006-02-14 14:00:00', '2006-05-14 18:00:00'),
(5, 56, '2006-02-22 09:00:00', '2006-02-25 12:00:00'),
(5, 60, '2006-02-23 09:00:00', '2006-02-25 18:00:00'),
(6, 53, '2006-03-03 14:00:00', '2006-03-04 12:00:00'),
(6, 57, '2006-03-04 14:00:00', '2006-03-04 18:00:00'),
(7, 55, '2006-04-09 14:00:00', '2006-04-09 18:00:00'),
(7, 65, '2006-04-09 09:00:00', '2006-04-09 12:00:00'),
(8, 54, '2006-05-12 09:00:00', '2006-05-12 18:00:00'),
(8, 62, '2006-05-11 14:00:00', '2006-05-12 12:00:00'),
(9, 59, '2006-02-22 09:00:00', '2006-02-22 12:00:00'),
(9, 60, '2006-02-22 14:00:00', '2006-02-22 18:00:00'),
(10, 63, '2006-04-09 14:00:00', '2006-04-09 18:00:00'),
(10, 67, '2006-04-08 09:00:00', '2006-04-09 12:00:00'),
(11, 59, '2006-03-09 09:00:00', '2006-03-11 18:00:00'),
(11, 64, '2006-03-09 09:00:00', '2006-03-17 12:00:00'),
(11, 53, '2006-03-08 14:00:00', '2006-03-16 18:00:00'),
(12, 55, '2006-05-05 09:00:00', '2006-05-05 18:00:00'),
(12, 56, '2006-05-03 09:00:00', '2006-05-05 12:00:00'),
(13, 64, '2006-05-12 14:00:00', '2006-05-12 18:00:00');

-- --------------------------------------------------------

--
-- Structure de la table `tblinterventions`
--

CREATE TABLE IF NOT EXISTS `tblinterventions` (
  `numIntervention` int(11) NOT NULL DEFAULT '0',
  `numVehicule` int(11) DEFAULT NULL,
  `typeIntervention` char(3) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `debInterv` datetime DEFAULT NULL,
  `finInterv` datetime DEFAULT NULL,
  `kmVehicule` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `tblinterventions`
--

INSERT INTO `tblinterventions` (`numIntervention`, `numVehicule`, `typeIntervention`, `debInterv`, `finInterv`, `kmVehicule`) VALUES
(1, 3, 'EN', '2006-02-25 09:00:00', '2006-02-26 12:00:00', 102735),
(2, 21, 'EN', '2006-02-23 09:00:00', '2006-02-24 18:00:00', 124682),
(3, 25, 'RN', '2006-04-06 14:00:00', '2006-04-09 12:00:00', 13108),
(4, 10, 'EN', '2006-05-14 09:00:00', '2006-05-14 18:00:00', 987),
(5, 6, 'RN', '2006-02-22 09:00:00', '2006-02-25 18:00:00', 31450),
(6, 14, 'EN', '2006-03-03 14:00:00', '2006-03-04 18:00:00', 46721),
(7, 1, 'EN', '2006-04-09 09:00:00', '2006-04-09 18:00:00', 55649),
(8, 17, 'EN', '2006-05-11 14:00:00', '2006-05-12 18:00:00', 15204),
(9, 22, 'EN', '2006-02-22 09:00:00', '2006-02-22 18:00:00', 7960),
(10, 2, 'ERN', '2006-04-08 09:00:00', '2006-04-09 18:00:00', 83674),
(11, 28, 'RN', '2006-03-08 14:00:00', '2006-03-17 12:00:00', 7237),
(12, 20, 'ERN', '2006-05-03 09:00:00', '2006-05-05 18:00:00', 52582),
(13, 8, 'NS', '2006-05-12 14:00:00', '2006-05-12 18:00:00', 17846),
(14, 1, 'RN', '2006-05-10 14:00:00', '2006-05-12 12:00:00', 60103),
(15, 20, 'NS', '2006-06-25 09:00:00', '2006-06-25 12:00:00', 55948);

-- --------------------------------------------------------

--
-- Structure de la table `tblmarques`
--

CREATE TABLE IF NOT EXISTS `tblmarques` (
  `NumMarque` int(11) NOT NULL AUTO_INCREMENT,
  `Marque` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Nationalite` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`NumMarque`),
  KEY `Marque` (`Marque`),
  KEY `Nationalite` (`Nationalite`),
  KEY `NumMarque` (`NumMarque`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Contenu de la table `tblmarques`
--

INSERT INTO `tblmarques` (`NumMarque`, `Marque`, `Nationalite`) VALUES
(1, 'Lamborghini', 'Italie'),
(2, 'Audi', 'Allemagne'),
(3, 'rolls-royce', 'Grande-Bretagne'),
(4, 'bmw', 'Allemagne'),
(5, 'cadillac', 'Etats-Unis'),
(6, 'chrysler', 'Etats-Unis'),
(7, 'ferrari', 'Italie'),
(8, 'honda', 'Japon'),
(9, 'jaguar', 'Grande-Bretagne'),
(10, 'alfa-romeo', 'Italie'),
(11, 'lexus', 'Japon'),
(12, 'lotus', 'Grande-Bretagne'),
(13, 'maserati', 'Italie'),
(14, 'mercedes', 'Allemagne'),
(15, 'peugeot', 'France'),
(16, 'porsche', 'Allemagne'),
(17, 'renault', 'France'),
(18, 'saab', 'Suède'),
(19, 'toyota', 'Japon'),
(20, 'venturi', 'France'),
(21, 'volvo', 'Suède');

-- --------------------------------------------------------

--
-- Structure de la table `tblmodeles`
--

CREATE TABLE IF NOT EXISTS `tblmodeles` (
  `NumModele` int(11) NOT NULL AUTO_INCREMENT,
  `NumMarque` int(11) DEFAULT NULL,
  `Modele` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`NumModele`),
  KEY `NumMarque` (`NumMarque`),
  KEY `Modele` (`Modele`),
  KEY `NumMarque_2` (`NumMarque`),
  KEY `NumModele` (`NumModele`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Contenu de la table `tblmodeles`
--

INSERT INTO `tblmodeles` (`NumModele`, `NumMarque`, `Modele`) VALUES
(2, 1, 'Diablo'),
(3, 2, 'Série 5'),
(4, 10, 'NSX'),
(5, 14, 'Classe C'),
(6, 17, 'Safrane'),
(7, 20, '400 GT'),
(8, 12, 'Esprit'),
(9, 15, '605'),
(10, 19, 'Prévia'),
(11, 7, '550 Maranello'),
(12, 3, 'Bentley-Continental'),
(13, 10, 'Spider'),
(14, 13, 'Evoluzione'),
(15, 16, 'Carrera'),
(16, 16, 'Boxter'),
(17, 21, 'S 80'),
(18, 6, '300 M'),
(19, 4, 'M 3'),
(20, 9, 'XJ 8'),
(21, 15, '406 Coupé'),
(22, 20, '300 Atlantic'),
(23, 14, 'Classe E'),
(24, 11, 'GS 300'),
(25, 5, 'Séville'),
(26, 18, '95 Cabriolet'),
(27, 2, 'TT Coupé'),
(28, 7, 'F 355');

-- --------------------------------------------------------

--
-- Structure de la table `tblvehicules`
--

CREATE TABLE IF NOT EXISTS `tblvehicules` (
  `NumVehicule` int(11) NOT NULL AUTO_INCREMENT,
  `NumClient` int(11) DEFAULT '0',
  `NumModele` int(11) DEFAULT '0',
  `NumImmat` varchar(9) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `Annee` int(11) DEFAULT NULL,
  PRIMARY KEY (`NumVehicule`),
  KEY `NumModele` (`NumModele`),
  KEY `Annee` (`Annee`),
  KEY `Annee_2` (`Annee`),
  KEY `NumClient` (`NumClient`),
  KEY `NumImmat` (`NumImmat`),
  KEY `NumModele_2` (`NumModele`),
  KEY `NumVehicule` (`NumVehicule`),
  KEY `NumClient_2` (`NumClient`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Contenu de la table `tblvehicules`
--

INSERT INTO `tblvehicules` (`NumVehicule`, `NumClient`, `NumModele`, `NumImmat`, `Annee`) VALUES
(1, 2, 6, '6784XY31', 1992),
(2, 9, 20, '659YT31', 1993),
(3, 17, 8, '9243VF31', 1987),
(4, 6, 12, '398AAH31', 1998),
(5, 16, 23, '5307ZZ31', 1998),
(6, 20, 6, '3853XF31', 1997),
(7, 7, 8, '945AAA31', 1998),
(8, 16, 14, '8365VZ31', 1986),
(9, 13, 15, '3087YX31', 1992),
(10, 20, 22, '941ABA31', 1999),
(11, 9, 16, '1572AAL31', 1998),
(12, 14, 20, '6025ZS31', 1997),
(13, 19, 17, '5205ZA31', 1997),
(14, 22, 21, '754XD31', 1992),
(15, 4, 19, '6254ABA31', 1999),
(16, 16, 21, '98ZF31', 1997),
(17, 12, 11, '456RD31', 1976),
(18, 1, 2, '7973SJ31', 1982),
(19, 18, 21, '3904TT31', 1985),
(20, 22, 2, '1234ZA31', 1997),
(21, 3, 19, '8429UV31', 1985),
(22, 8, 19, '9999ZZ31', 1998),
(23, 7, 25, '6824TY31', 1985),
(24, 3, 9, '9365ZV31', 1998),
(25, 13, 5, '642AAD31', 1998),
(26, 3, 10, '5389YA31', 1993),
(27, 10, 7, '421AAA31', 1998),
(28, 10, 3, '6478AAZ31', 1999);

-- --------------------------------------------------------

--
-- Structure de la table `tblvilles`
--

CREATE TABLE IF NOT EXISTS `tblvilles` (
  `NUMVILLE` int(11) NOT NULL DEFAULT '0',
  `CODPOST` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `VILLE` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`NUMVILLE`),
  KEY `CODPOST` (`CODPOST`),
  KEY `NUMVILLE` (`NUMVILLE`),
  KEY `VILLE` (`VILLE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `tblvilles`
--

INSERT INTO `tblvilles` (`NUMVILLE`, `CODPOST`, `VILLE`) VALUES
(1, '31170', 'TOURNEFEUILLE'),
(2, '31700', 'BLAGNAC'),
(3, '31770', 'COLOMIERS'),
(4, '31100', 'TOULOUSE'),
(5, '31150', 'FENOUILLET'),
(6, '31130', 'BALMA'),
(7, '31520', 'RAMONVILLE SAINT-AGNE'),
(8, '31470', 'FONSORBES'),
(9, '31490', 'BRAX'),
(10, '31400', 'TOULOUSE'),
(11, '31700', 'CORNEBARRIEU'),
(12, '31240', 'L''UNION'),
(13, '31270', 'CUGNAUX'),
(14, '31000', 'TOULOUSE'),
(15, '31840', 'AUSSONNE'),
(16, '31240', 'SAINT-JEAN'),
(17, '31600', 'MURET'),
(18, '31200', 'TOULOUSE'),
(19, '31500', 'TOULOUSE'),
(20, '31840', 'SEILH'),
(21, '31880', 'LA SALVETAT SAINT-GILLES'),
(22, '31790', 'SAINT-JORY'),
(23, '31300', 'TOULOUSE'),
(24, '31820', 'PIBRAC'),
(25, '31160', 'CASTELBIAGUE'),
(26, '31450', 'MONTBRUN LAURAGUAIS'),
(27, '31810', 'VERNET'),
(28, '31140', 'SAINT-ALBAN'),
(29, '31290', 'SAINT-ROME'),
(30, '31830', 'PLAISANCE DU TOUCH'),
(31, '31620', 'FRONTON'),
(32, '31120', 'PORTET SUR GARONNE'),
(33, '31330', 'GRENADE'),
(34, '31490', 'LEGUEVIN'),
(35, '31670', 'LABEGE');