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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
|
CREATE TABLE `Eurolinea` (
`IDDossierEurolinea` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Identifiant unique du VO Eurolinea',
`Immatriculation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Marque` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`Famille` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Modele` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Libele du modèle + libelle de la version',
`CodeReferentienVO` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Vin` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`EnergieLibelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`CategorieLibelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`NbPortes` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`NbPlaces` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`GenreLibelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`TypeMine` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PuissanceFiscale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PuissanceDIN` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PuissanxceKW` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Cylindree` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Acceleration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Coffre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`VolumeInterieur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ConsoMoyenne` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ConsoRoute` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ConsoVille` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Hauteur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Largeur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`LibPneu` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Longueur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`NbCylindre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Poids` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Reservoir` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`VitesseMax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Co2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`EmissionCO2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixNeufTTC` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixNeufTTCoptions` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`BoiteLibelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`NbRapports` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Annee` int(11) NOT NULL,
`DateCarteGrise` int(11) NOT NULL,
`Dat1Mec` int(11) NOT NULL,
`Kilometrage` int(11) NOT NULL,
`TypeKilometrage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Couleur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PropPrec` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`DateCT` int(11) NOT NULL,
`DateCTPol` int(11) NOT NULL,
`Accidentee` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixVenteTTC` int(11) NOT NULL,
`PrisPro` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`VOImporte` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`TVARecuperable` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`DateGarantie` int(11) NOT NULL,
`ExtGarantie` int(11) NOT NULL,
`DurGarantie` int(11) NOT NULL,
`Equipements` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Option1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixOption1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Option2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixOption2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Option3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixOption3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Option4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixOption4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Option5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixOption5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Option6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PrixOption6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`CodeSiteEurolinea` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteNom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Civilite` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteContact` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieTetelephone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieTetelephone2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteAdresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteAdresseSuite` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteCodePostal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SocieteVille` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`SiteWeb` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo11` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Photo12` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Contenu de la table `Eurolinea`
--
INSERT INTO `Eurolinea` VALUES('978035', 'AB-110-BA', 'Toyota', 'Aygo', '1.0 VVT-I CONFORT', 'Aygo 1.0 VVT-I CONFORT', '7,44294E+14', 'JTDKG18C90N371167', 'Essence', 'Berline', '5', '4', 'VP', '-', '4', '68', '50', '', '14,2', '139', '', '4,6', '4,1', '5,5', '1465', '1615', '155/65/14', '3410', '3', '800', '35', '157', 'E4', '107', '', '', 'M', '5', 2009, 0, 4062009, 5431, 'R', 'Gris Clair M', '', 0, 0, 'Non', 869000, '0', 'N', 'False', 0, 0, 36, 'ABS, Climatisation, Airbags Frontaux, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978035A', '978035B', '978035C', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978045', '809AHY76', 'Toyota', 'Yaris', '90 D-4D LIMITED EDITION', 'Yaris 90 D-4D LIMITED EDITION', '7,53817E+14', 'VNKKC96300A203591', 'Diesel', 'Berline', '5', '5', 'VP', '-', '5', '90', '66', '', '10,7', '363', '', '4,5', '4', '5,4', '1530', '1695', '185/60/15', '3750', '4', '1055', '42', '175', 'E4', '119', '', '', 'M', '5', 2009, 0, 23032009, 13292, 'R', 'Gris Clair M', '', 0, 0, 'Non', 1129000, '0', 'N', 'False', 0, 0, 36, 'ABS, Aide au stationnement, Climatisation, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978045A', '978045B', '978045C', '978045D', '978045E', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978046', '210EAY78', 'Toyota', 'Yaris', '90 D-4D LUNA', 'Yaris 90 D-4D LUNA', '5,701E+13', 'VNKKC96300A083999', 'Diesel', 'Berline', '5', '5', 'VP', '-', '5', '90', '66', '', '10,7', '363', '', '4,5', '4', '5,4', '1530', '1695', '185/60/15', '3750', '4', '1055', '42', '175', 'E4', '119', '1560000', '1560000', 'M', '5', 2007, 2042007, 2042007, 57296, 'R', 'Gris Clair M', '1', 0, 0, 'Non', 949000, '0', 'N', 'False', 0, 0, 12, 'ABS, Climatisation, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978046A', '978046B', '978046C', '978046D', '978046E', '978046F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978047', '635AHC93', 'Toyota', 'Yaris', '90 D-4D LUNA PACK', 'Yaris 90 D-4D LUNA PACK', '7,53814E+14', 'VNKKC96390A141785', 'Diesel', 'Berline', '5', '5', 'VP', '-', '5', '90', '66', '', '10,7', '363', '', '4,5', '4', '5,4', '1530', '1695', '185/60/15', '3750', '4', '1055', '42', '175', 'E4', '119', '1590000', '1630000', 'M', '5', 2007, 0, 27122007, 30130, 'R', 'Bleu Fonc', '', 0, 0, 'Non', 999000, '0', 'N', 'True', 0, 0, 24, 'ABS, Climatisation, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', 'Peinture m', 'Peinture m', '40000', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978047A', '978047B', '978047C', '978047D', '978047E', '978047F', '978047G', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978048', '636AHC93', 'Toyota', 'Yaris', '90 D-4D LUNA PACK', 'Yaris 90 D-4D LUNA PACK', '7,53814E+14', 'VNKKC96340A141712', 'Diesel', 'Berline', '5', '5', 'VP', '-', '5', '90', '66', '', '10,7', '363', '', '4,5', '4', '5,4', '1530', '1695', '185/60/15', '3750', '4', '1055', '42', '175', 'E4', '119', '1590000', '1630000', 'M', '5', 2007, 0, 27122007, 31000, 'R', 'Bleu Fonc', '', 0, 0, 'Non', 999000, '0', 'N', 'True', 0, 0, 24, 'ABS, Climatisation, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', 'Peinture m', 'Peinture m', '40000', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT PARIS', '', 'Alexis ALLERME', '', '03 03 03 03 03', '', '72 rue prunier', '', '78120', 'Rambouillet', '', '978048A', '978048B', '978048C', '978048D', '978048E', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978050', '202DYM78', 'Toyota', 'Yaris', '90 D-4D SOL', 'Yaris 90 D-4D SOL', '6,0955E+13', 'VNKKC96360A067080', 'Diesel', 'Berline', '5', '5', 'VP', '-', '5', '90', '66', '', '10,7', '272', '', '4,5', '4', '5,4', '1530', '1695', '185/60/15', '3750', '4', '1055', '42', '175', 'E4', '119', '1675000', '1715000', 'M', '5', 2006, 0, 13122006, 78244, 'R', 'Bleu Fonc', '', 0, 0, 'Non', 899000, '0', 'N', 'False', 0, 0, 12, 'ABS, Climatisation Auto, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', 'Peinture m', 'Peinture m', '40000', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978050A', '978050B', '978050C', '978050D', '978050E', '978050F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978060', '910EKW78', 'Toyota', 'Prius', '110H 10EME ANNIVERSAIRE', 'Prius 110H 10EME ANNIVERSAIRE', '7,55607E+14', 'JTDKB20U707757468', 'Electrique', 'Berline', '5', '5', 'VP', '-', '4', '112', '82', '', '10,9', '408', '', '4,3', '4,2', '5', '1490', '1725', '195/55/16', '4450', '4', '1300', '45', '170', 'E4', '104', '2870000', '3072999', 'A', '0', 2008, 0, 24042008, 44715, 'R', 'Bleu Fonc', '', 0, 0, 'Non', 1599000, '0', 'N', 'False', 0, 0, 36, 'ABS, Aide au stationnement, Climatisation Auto, Airbags Frontaux, Airbags de toit, Airbag Lat', 'Peinture m', 'Peinture m', '43000', 'Sellerie cuir beige', '160000', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978060A', '978060B', '978060C', '978060D', '978060E', '978060F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978064', '790EJX78', 'Toyota', 'Prius', '110H LINEA SOL PACK HYBRID IPA', 'Prius 110H LINEA SOL PACK HYBRID IPA', '7,31783E+14', 'JTDKB20U907739893', 'Electrique', 'Berline', '5', '5', 'VP', '-', '4', '112', '82', '', '10,9', '408', '', '4,3', '4,2', '5', '1490', '1725', '195/55/16', '4450', '4', '1300', '45', '170', 'E4', '104', '2945000', '2945000', 'A', '0', 2008, 0, 19032008, 40165, 'R', 'Gris Clair M', '', 0, 0, 'Non', 1649000, '0', 'N', 'False', 0, 0, 36, 'ABS, Aide au stationnement, Climatisation Auto, Airbags Frontaux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978064A', '978064B', '978064C', '978064D', '978064E', '978064F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978066', '782DMC78', 'Toyota', 'Avensis', '115 D-4D PACK GPS', 'Avensis 115 D-4D PACK GPS', '7,27959E+14', 'SB1DW56L40E126710', 'Diesel', 'Berline', '5', '5', 'VP', '-', '7', '116', '85', '', '11,2', '510', '', '5,8', '4,9', '7,5', '1480', '1760', '205/55/16', '4630', '4', '1400', '60', '195', 'E4', '155', '2695000', '2695000', 'M', '5', 2005, 0, 19092005, 59513, 'R', 'Gris Clair', '', 0, 0, 'Non', 1149000, '0', 'N', 'False', 0, 0, 12, 'ABS, Aide au stationnement, Climatisation Auto, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'EUROLINEA', '', 'S', '', '01 01 01 01 01', '', '5 rue des fr', '', '75000', 'PARIS', '', '978066A', '978066B', '978066C', '978066D', '978066E', '978066F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978067', 'AB-154-QK', 'Toyota', 'Avensis', '150 D-4D FAP DYNAMIC', 'Avensis 150 D-4D FAP DYNAMIC', '7,27955E+14', 'SB1BA76L10E003481', 'Diesel', 'Berline', '4', '5', 'VP', '-', '8', '150', '110', '', '8,9', '509', '', '5,5', '4,7', '7', '1480', '1810', '215/50/17', '4695', '4', '1515', '60', '210', 'E5', '147', '', '', 'M', '6', 2009, 0, 29062009, 14154, 'R', 'Gris Moyen M', '', 0, 0, 'Non', 2099000, '0', 'N', 'False', 0, 0, 36, 'ABS, Climatisation Auto, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'EUROLINEA', '', 'S', '', '01 01 01 01 01', '', '5 rue des fr', '', '75000', 'PARIS', '', '978067A', '978067B', '978067C', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978068', '472EHJ78', 'Toyota', 'Avensis', '115 D-4D LINEA SOL', 'Avensis 115 D-4D LINEA SOL', '6,09611E+13', 'SB1EW56L20E131506', 'Diesel', 'Break', '5', '5', 'VP', '-', '7', '116', '85', '', '11,4', '520', '', '6', '5,1', '7,7', '1525', '1760', '205/55/16', '4700', '4', '1430', '60', '195', 'E4', '158', '2510000', '2510000', 'M', '5', 2005, 30112005, 30112005, 82000, 'R', 'Gris Clair', '1', 0, 0, 'Non', 1189000, '0', 'N', 'False', 0, 0, 12, 'ABS, Climatisation Auto, Airbags Frontaux, Airbag de Genoux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978068A', '978068B', '978068C', '978068D', '978068E', '978068F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo');
INSERT INTO `Eurolinea` VALUES('978083', 'AC-125-CC', 'Fiat', 'Punto', '1.3 MULTIJET 16V 90 EMOTION', 'Punto 1.3 MULTIJET 16V 90 EMOTION', '7,30957E+14', 'ZFA19900001547190', 'Diesel', 'Berline', '5', '5', 'VP', '', '5', '90', '66', '', '11,9', '275', '', '4,7', '4', '5,9', '1490', '1687', '205/65/17', '4030', '4', '1145', '45', '175', 'E4', '119', '1735000', '1735000', 'M', '6', 2009, 0, 23022009, 16282, 'R', 'Gris Moyen', '', 0, 0, 'Non', 1199000, '1189000', 'N', 'False', 0, 0, 24, 'ABS, Climatisation Auto, Airbags Frontaux, Airbags de toit, Airbag Lat', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AC', 'AUTOCONTACT', '', 'Patrice ALBICY', 'sta.78@groupebernier.com', '02 02 02 02 02', '', '6 Route nationale 10', '', '33000', 'Bordeaux', '', '978083A', '978083B', '978083C', '978083D', '978083E', '978083F', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo', 'carNonDispo'); |