-- MySQL dump 10.9
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	4.1.14-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `appartement`
--

DROP TABLE IF EXISTS `appartement`;
CREATE TABLE `appartement` (
  `id` int(11) NOT NULL default '0',
  `dateoffre` varchar(12) default NULL,
  `nbrpersones` int(11) default NULL,
  `nbrpieces` int(11) default NULL,
  `loyer` decimal(6,2) default NULL,
  `remarque` varchar(255) default NULL,
  `adresse` varchar(255) default NULL,
  `npa` varchar(10) default NULL,
  `localite` varchar(255) default NULL,
  `cuisine` tinyint(1) default NULL,
  `cuisine_partagee` tinyint(1) default NULL,
  `cuisine_agencee` tinyint(1) default NULL,
  `cuisine_rechaudpossible` tinyint(1) default NULL,
  `meuble` tinyint(1) default NULL,
  `tranquilite` tinyint(1) default NULL,
  `balcon` tinyint(1) default NULL,
  `vue` tinyint(1) default NULL,
  `bus` tinyint(1) default NULL,
  `proprietaire_prive` tinyint(1) default NULL,
  `stationnement` tinyint(1) default NULL,
  `gerance` tinyint(1) default NULL,
  `metrom1` tinyint(1) default NULL,
  `salle_bain` tinyint(1) default NULL,
  `salle_bain_partagee` tinyint(1) default NULL,
  `salle_bain_douche` tinyint(1) default NULL,
  `salle_bain_baignore` tinyint(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `appartement`
--


/*!40000 ALTER TABLE `appartement` DISABLE KEYS */;
LOCK TABLES `appartement` WRITE;
INSERT INTO `appartement` VALUES (7942,'06.09.2004',1,1,'370.00','TV à disposition','av. Victor Ruffy','1012','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,0,1,1,0,NULL),(7989,'21.09.2004',1,2,'980.00','ou dès le 01.11.04','Rte de Crissier','1020','Renens VD',0,NULL,NULL,NULL,0,0,1,0,0,0,0,1,1,0,NULL,NULL,NULL),(7826,'22.09.2004',1,3,'1380.00','','Ch. de Devin','1000','Lausanne 21',0,NULL,NULL,NULL,1,1,0,0,1,1,1,0,0,0,NULL,NULL,NULL),(7990,'22.09.2004',1,1,'690.00','Event. pour 2 personnes','Rue du Lac','1020','Renens VD',0,NULL,NULL,NULL,1,0,1,1,1,0,0,0,1,0,NULL,NULL,NULL),(7992,'22.09.2004',1,2,'625.00','','route de Genève 79','1004','Lausanne',0,NULL,NULL,NULL,0,0,0,1,1,0,0,1,1,0,NULL,NULL,NULL),(7994,'22.09.2004',1,1,'550.00','','ch. du Corjon','1020','Renens VD',1,1,0,0,1,1,1,1,0,0,0,0,0,1,1,0,NULL),(7995,'22.09.2004',1,4,'1600.00','','Av. de Morges','1004','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,1,0,0,0,NULL,NULL,NULL),(7996,'22.09.2004',1,1,'475.00','','Avenue de Morges','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,1,0,1,1,1,0,NULL),(7999,'22.09.2004',1,1,'490.00','','ch. des cèdres','1023','Crissier',1,1,0,0,1,1,0,1,1,0,0,0,1,1,1,0,NULL),(8000,'22.09.2004',1,2,'930.00','','rte de Vevey','1009','Pully',0,NULL,NULL,NULL,0,1,1,0,1,0,0,0,0,0,NULL,NULL,NULL),(8001,'22.09.2004',1,1,'680.00','','av. Victor Ruffy','1012','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8003,'22.09.2004',1,1,'600.00','','av. de Béthusy 30','1005','Lausanne',1,1,0,0,0,1,0,1,1,0,0,0,1,1,1,0,NULL),(8004,'22.09.2004',1,1,'600.00','Pour étudiante de préférence','av. Druey','1004','Lausanne',1,1,0,0,0,0,0,0,1,0,0,0,1,1,1,0,NULL),(8006,'22.09.2004',1,1,'700.00','2 chambres à louer.\nY COMPRIS DEMI-PENSION (petit déjeuner et repas du soir)\nEtudiants/es sérieux\n','ch. de Fenix','1095','Lutry',0,NULL,NULL,NULL,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8007,'22.09.2004',1,1,'550.00','2 chambres à louer','Av. de la Poste 25','1020','Renens VD',1,1,0,0,0,1,0,0,1,0,0,0,0,1,1,0,NULL),(8009,'23.09.2004',1,1,'610.00','','Rue du Lac','1020','Renens VD',0,NULL,NULL,NULL,1,0,1,1,1,0,0,0,1,0,NULL,NULL,NULL),(8011,'23.09.2004',1,1,'500.00','pour ETUDIANTE non fumeuse\naimer les chats','ch. de Champrilly','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,0,1,1,0,NULL),(8014,'23.09.2004',3,3,'1400.00','','av. de la Dôle','1005','Lausanne',0,NULL,NULL,NULL,1,0,1,0,1,0,0,1,1,0,NULL,NULL,NULL),(8015,'23.09.2004',2,2,'1080.00','','av. de Sévery','1004','Lausanne',0,NULL,NULL,NULL,0,1,1,0,1,0,0,1,1,0,NULL,NULL,NULL),(8016,'23.09.2004',1,2,'700.00','ou dès le 15.10.2004','ch. de Fontadel','1008','Prilly',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8017,'23.09.2004',1,1,'550.00','possibilité de prendre petit-déjeuner et repas','route du Vignoble','1175','Lavigny',0,NULL,NULL,NULL,1,0,0,0,0,1,1,0,0,0,NULL,NULL,NULL),(8018,'23.09.2004',1,2,'600.00','','rue de l\'Industrie','1020','Renens VD',0,NULL,NULL,NULL,0,1,0,1,1,0,0,1,0,0,NULL,NULL,NULL),(8019,'24.09.2004',1,1,'500.00','avoir un moyen de locomotion\n(13 kms de l\'Université, 10 kms de Morges)\ndans villa\nPossibilité de cuisiner et de partager la jouissance du salon et du jardin\npour étudiante non fumeuse\nCohabitation avec famille monoparentale (2 enfants de 4 et 14 ans) +\n1','Au Village','1127','Clarmont',1,1,0,0,1,1,1,0,0,0,0,0,0,0,NULL,NULL,NULL),(8020,'24.09.2004',1,1,'500.00','','av. de Lavaux 66','1009','Pully',1,1,0,0,1,1,0,1,1,0,0,1,0,1,1,0,NULL),(8021,'24.09.2004',1,1,'550.00','appart. type villa\ntrès confortable, terrasse, jardin\n12 min. de l\'Uni en voiture\npossible par train','Rapille-Dessous 26','1312','Eclépens',1,1,0,0,1,1,0,0,0,0,0,0,0,1,1,0,NULL),(8023,'24.09.2004',4,4,'2110.00','','rte de la Plaine 8','1022','Chavannes-près-Renens',0,NULL,NULL,NULL,0,1,1,1,1,0,0,1,1,0,NULL,NULL,NULL),(8024,'24.09.2004',1,1,'415.00','','chemin du Risoux','1003','Lausanne',1,1,0,0,0,1,0,0,1,0,0,0,0,1,1,0,NULL),(8025,'24.09.2004',1,2,'650.00','sous-location','av. des Figuiers','1007','Lausanne',0,NULL,NULL,NULL,1,1,1,0,1,1,0,0,1,0,NULL,NULL,NULL),(8027,'27.09.2004',1,1,'400.00','NON FUMEUR','Bois de Vaux','1007','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,1,1,1,0,NULL),(8029,'27.09.2004',1,1,'670.00','','rue St-.Martin','1005','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8031,'27.09.2004',1,1,'480.00','pour étudiant(e) non fumeur(se)','av. d\'Epenex','1024','Ecublens VD',1,1,0,0,1,0,0,0,1,0,0,0,1,1,1,0,NULL),(8032,'27.09.2004',1,2,'850.00','jusqu\'à fin juillet 2005 ou jusqu\'en octobre 2005\nsous-location','av. de Chailly','1012','Lausanne',0,NULL,NULL,NULL,1,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL),(8034,'27.09.2004',1,1,'420.00','pour le 1.10.2004 ou à convenir','ch. de la condémine','1304','Cossonay-Ville',1,1,0,0,1,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL),(8035,'27.09.2004',2,2,'920.00','','place de la Gare 12','1020','Renens VD',0,NULL,NULL,NULL,0,1,1,1,1,0,0,1,0,0,NULL,NULL,NULL),(8036,'27.09.2004',1,1,'600.00','','rue de Bassenges','1024','Ecublens VD',1,1,0,0,0,1,0,0,0,0,0,0,1,1,1,0,NULL),(8038,'27.09.2004',1,1,'650.00','','ch. de Veilloud','1024','Ecublens VD',0,NULL,NULL,NULL,1,1,1,1,1,0,0,1,1,0,NULL,NULL,NULL),(8041,'28.09.2004',1,2,'900.00','39m2','Av. Ramuz','1009','Pully',0,NULL,NULL,NULL,0,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8043,'28.09.2004',1,2,'770.00','','Av. de la Gare','1022','Chavannes-près-Renens',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8045,'29.09.2004',1,2,'506.00','','Rue Centrale','1003','Lausanne',0,NULL,NULL,NULL,0,0,1,0,1,0,0,1,1,0,NULL,NULL,NULL),(8046,'29.09.2004',1,1,'450.00','2e chambre = 550.-','Bergières','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,0,1,1,0,NULL),(8049,'29.09.2004',1,1,'600.00','','Rte de Roman','1027','Lonay',1,1,0,0,1,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL),(8050,'29.09.2004',1,1,'418.00','','Jean-Louis de Bon','1006','Lausanne',1,1,0,0,0,0,1,0,1,0,0,0,0,1,1,0,NULL),(7719,'29.09.2004',1,1,'500.00','dans maison individuelle\naccès au jardin','Baumettes','1008','Prilly',1,1,0,0,1,1,0,0,1,1,0,0,0,1,1,0,NULL),(8052,'30.09.2004',1,1,'500.00','four micro-onde\nfrigo\npour étudiant(e) non fumeur(se)\n','ch. de la Violette','1030','Bussigny-près-Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,1,1,0,0,0,NULL,NULL,NULL),(8053,'30.09.2004',1,1,'750.00','jardin\npour étudiante','rue du Petit Port 13','1025','St-Sulpice VD',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8056,'30.09.2004',1,1,'650.00','','ch. du Devin 81','1012','Lausanne',1,1,0,0,1,1,1,0,0,0,0,0,0,1,1,0,NULL),(8057,'30.09.2004',1,1,'630.00','','chemin du Furet','1018','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8059,'30.09.2004',1,1,'575.00','','ch. de la Lande','1008','Prilly',1,1,0,0,1,1,1,1,0,0,0,0,0,1,1,0,NULL),(8060,'01.10.2004',1,1,'630.00','','route de Berne','1010','Lausanne 10 Distribution',0,NULL,NULL,NULL,1,0,1,0,1,0,0,0,0,0,NULL,NULL,NULL),(7336,'01.10.2004',1,1,'450.00','possibilité de faire la lessive librement, prise de TV, \nbus pour St-François au bas de l\'immeuble\nappartement partagé (5 pièces 1/2)','','1094','Paudex',1,1,0,0,1,1,1,1,1,0,0,0,0,1,1,0,NULL),(8064,'04.10.2004',1,1,'450.00','','chemin de villard','1007','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,1,1,0,1,0,NULL,NULL,NULL),(7823,'05.10.2004',1,1,'600.00','réchaud - frigo\njardin - lac à 150 m.\nTV - internet \n','ch. du Grèbe','1028','Préverenges',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(7849,'05.10.2004',1,1,'400.00','Etudiant du CHUV. NON-FUMEUR','Ch. du Chêne','1052','Le Mont-sur-Lausanne',1,1,0,0,1,1,0,0,0,0,1,0,0,0,NULL,NULL,NULL),(7703,'05.10.2004',1,1,'500.00','','Ch. de Mallieu','1009','Pully',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8065,'05.10.2004',1,1,'580.00','Dans villa, kitchenette, non-fumeur, discret','Ch. des Airelles','1020','Renens VD',0,NULL,NULL,NULL,1,0,0,0,1,0,0,0,1,1,1,0,NULL),(8066,'05.10.2004',1,1,'600.00','dans villa. Meublée ou non. \nADSL compris.\nPossibilité de faire du baby sitting','Ch. du Grand Clos','1092','Belmont-sur-Lausanne',0,NULL,NULL,NULL,1,0,1,1,0,1,0,0,0,0,NULL,NULL,NULL),(8067,'05.10.2004',1,1,'500.00','','rte du Chasseur','1008','Prilly',1,1,0,0,1,1,0,0,1,0,0,0,1,1,1,0,NULL),(8071,'05.10.2004',1,1,'550.00','Il y a 2 chambres à louer pour 5 à  6 mois\nFrigo\npour étudiants Suisse uniquement\nla 2ème est à fr. 600.--\n\n','Bosquets','1024','Ecublens VD',1,0,0,1,1,0,0,0,0,0,0,0,1,1,1,0,NULL),(8072,'05.10.2004',1,1,'650.00','','rue du Mont Tendre','1007','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,1,0,0,1,0,NULL,NULL,NULL),(8075,'05.10.2004',1,2,'850.00','','Pontaise','1018','Lausanne',0,NULL,NULL,NULL,1,1,0,0,0,0,0,0,1,0,NULL,NULL,NULL),(8076,'05.10.2004',1,1,'500.00','','Piscine','1020','Renens VD',0,NULL,NULL,NULL,1,0,0,1,1,0,0,0,1,0,NULL,NULL,NULL),(8077,'05.10.2004',1,1,'600.00','réchaud - frigo\njardin - lac à 150 m.\nTV - internet \n','ch. du Grèbe','1028','Préverenges',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8078,'05.10.2004',1,1,'550.00','','ch. des Eterpeys 17','1010','Lausanne 10 Distribution',1,1,0,0,1,1,1,1,1,0,0,0,0,1,1,0,NULL),(8079,'05.10.2004',1,2,'706.00','','ch. de Bonne Espérance 18','1006','Lausanne',0,NULL,NULL,NULL,1,1,1,1,0,0,0,0,0,0,NULL,NULL,NULL),(8080,'05.10.2004',1,1,'410.00','','ch. de Perrovray 4','1033','Cheseaux-sur-Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8083,'05.10.2004',1,1,'475.00','','av. du Tir Fédéral 32','1023','Crissier',1,1,0,0,0,0,1,0,1,0,0,0,1,1,1,0,NULL),(8084,'05.10.2004',1,1,'550.00','','av. de la dôle 4','1005','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8085,'05.10.2004',1,1,'575.00','','av. de la Dôle 5','1007','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8087,'05.10.2004',1,2,'1010.00','','Général-Guisan 56','1400','Yverdon-les-Bains',0,NULL,NULL,NULL,1,1,1,0,1,0,0,1,0,0,NULL,NULL,NULL),(8088,'05.10.2004',1,1,'460.00','chambre mansardée\nil y a 2 chambres à louer','ch. de la Rosière','1012','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,0,1,1,0,NULL),(7884,'05.10.2004',1,1,'550.00','','rue César Roux','1005','Lausanne',1,1,0,0,1,0,0,1,1,0,0,1,1,0,NULL,NULL,NULL),(7510,'05.10.2004',1,1,'500.00','jardin, terrasse, TV\nnon fumeur(se)','Croix de Rive 1','1028','Préverenges',1,1,0,0,1,0,0,0,0,0,0,0,0,1,1,0,NULL),(8090,'06.10.2004',2,2,'1190.00','Avoir un véhicule \n(15 min. en voiture environ de l\'Université)','rue du Four 4','1303','Penthaz',0,NULL,NULL,NULL,0,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL),(8092,'06.10.2004',1,1,'400.00','si possible pas le week-end','Av. Riant-Mont','1004','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,1,1,1,0,NULL),(8093,'06.10.2004',1,1,'500.00','','Av. de Florimont','1006','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8094,'06.10.2004',1,1,'500.00','','Grand Vigne','1302','Vufflens-la-Ville',1,1,0,0,1,1,0,0,0,1,1,0,0,0,NULL,NULL,NULL),(8095,'06.10.2004',1,1,'550.00','2 chats et 2 serpents dans l\'appart.','Jean Pavillard','1009','Pully',1,1,0,0,0,1,1,0,1,0,1,0,0,0,NULL,NULL,NULL),(8096,'06.10.2004',1,2,'1000.00','','Rue du Centre','1025','St-Sulpice VD',0,NULL,NULL,NULL,1,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8098,'06.10.2004',1,1,'320.00','Non-fumeur. 30 min. en train jusqu\'à Renens + 5 min. TSOL jusqu\'à UNIL/EPFL','La Foule','1322','Croy',0,NULL,NULL,NULL,1,0,0,0,0,1,1,0,0,1,1,0,NULL),(8100,'06.10.2004',1,1,'610.00','','Rte Neuve','1024','Ecublens VD',0,NULL,NULL,NULL,1,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8101,'06.10.2004',1,1,'800.00','possibilité de garder le mobilier','Ch. des Fleurettes','1007','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(7807,'07.10.2004',1,1,'500.00','Dans maison familiale. 2 chambres à louer. la 2ème chambre est 400.-/mois.\nLocation : 10 mois minimum.\nCaution : 500.- (400.- pour la 2eme)','Ch. des Sorbiers','1012','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8104,'07.10.2004',1,2,'785.00','','Av. de Longemalle','1020','Renens VD',0,NULL,NULL,NULL,0,0,1,0,1,0,0,1,1,0,NULL,NULL,NULL),(8105,'07.10.2004',4,4,'1703.00','','Ch. des Croix-Rouges','1007','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,1,1,1,0,NULL,NULL,NULL),(8106,'07.10.2004',1,1,'450.00','dans quartier calme\npour étudiant(e) non fumeur(se)\ndès le 1er septembre ou à convenir','av. Verdeil','1005','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8109,'07.10.2004',1,1,'700.00','','rte Cantonale','1025','St-Sulpice VD',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,1,0,NULL,NULL,NULL),(8110,'07.10.2004',3,3,'1300.00','sous-location','Beau-Val 16','1012','Lausanne',0,NULL,NULL,NULL,1,0,0,0,0,1,0,0,0,0,NULL,NULL,NULL),(8112,'07.10.2004',2,2,'950.00','ou pour le 01.12.2004','Grand Record','1030','Bussigny-près-Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8113,'07.10.2004',1,1,'600.00','LEB','rue de Bourg 28','1037','Etagnières',1,1,0,0,0,1,0,1,0,0,0,0,0,1,1,0,NULL),(8054,'07.10.2004',1,1,'470.00','Il y a 14 chambres indépendantes à louer\nles prix sont entre fr. 470.-- à fr. 610.--/par mois','chemin de Montolivet','1006','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8068,'08.10.2004',1,1,'500.00','','Ch. de Boston','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,1,1,1,0,NULL),(8114,'08.10.2004',1,1,'450.00','','rue du Villars 19','1024','Ecublens VD',1,1,0,0,1,0,0,0,1,1,0,0,1,1,1,0,NULL),(8115,'08.10.2004',1,1,'720.00','28 m2\nbus no 57','jardins de la Venoge','1028','Préverenges',0,NULL,NULL,NULL,0,0,1,0,1,0,0,1,0,0,NULL,NULL,NULL),(8089,'08.10.2004',1,1,'500.00','','Chablière','1004','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8037,'11.10.2004',1,1,'500.00','non fumeur(se)\nligne bus 33','Grand Vigne','1008','Prilly',1,1,0,0,1,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8117,'11.10.2004',1,1,'950.00','','Rue des Alpes','1023','Crissier',0,NULL,NULL,NULL,1,0,1,0,1,1,1,0,0,0,NULL,NULL,NULL),(8118,'11.10.2004',1,1,'550.00','','Ch. du Devin','1012','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,1,0,0,0,NULL,NULL,NULL),(8119,'11.10.2004',2,2,'750.00','','avenue de la Concorde','1022','Chavannes-près-Renens',0,NULL,NULL,NULL,0,1,1,1,1,0,0,1,1,0,NULL,NULL,NULL),(8120,'11.10.2004',1,1,'550.00','accès buanderie\npetit frigo privé\nPC avec internet\n','Ch. Neuf','1028','Préverenges',1,1,1,0,1,1,0,0,1,1,0,1,0,0,NULL,NULL,NULL),(8121,'11.10.2004',2,2,'795.00','','ch. des Glycines','1024','Ecublens VD',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8122,'11.10.2004',1,1,'420.00','Event. meublé à convenir.','Ch. de la Roche','1020','Renens VD',0,NULL,NULL,NULL,0,0,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8123,'11.10.2004',1,1,'710.00','','rue du Maupas','1004','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8124,'11.10.2004',1,1,'740.00','','chemin des Rosiers','1004','Lausanne',0,NULL,NULL,NULL,0,1,1,0,1,0,0,1,1,0,NULL,NULL,NULL),(8125,'11.10.2004',1,4,'1770.00','','av. du Censuy  24','1020','Renens VD',0,NULL,NULL,NULL,0,0,0,1,1,0,0,1,1,0,NULL,NULL,NULL),(8126,'11.10.2004',1,2,'850.00','pour étudiant(e) non fumeur(se)','ch. de Monteiron 9','1026','Denges',0,NULL,NULL,NULL,1,1,1,1,1,1,1,0,0,0,NULL,NULL,NULL),(8127,'11.10.2004',1,1,'460.00','','av. du 24 Janvier','1020','Renens VD',1,1,0,0,1,0,1,0,1,0,0,1,0,1,1,0,NULL),(8128,'11.10.2004',1,1,'420.00','','ch. de Florissant','1020','Renens VD',1,1,0,0,1,1,0,0,1,0,0,0,1,1,1,0,NULL),(7755,'12.10.2004',1,2,'920.00','sous-location min. 1 an\n','Chandolin','1005','Lausanne',0,NULL,NULL,NULL,1,1,1,1,1,1,0,0,0,0,NULL,NULL,NULL),(8130,'12.10.2004',1,2,'780.00','2 chambres à louer (une chambre est louée jusqu\'à fin novembre)','Rte de Crissier','1020','Renens VD',1,1,0,0,0,0,0,0,1,0,0,0,1,1,1,0,NULL),(8131,'12.10.2004',1,4,'1650.00','','Borde','1018','Lausanne',0,NULL,NULL,NULL,0,0,0,1,1,1,0,0,0,0,NULL,NULL,NULL),(8132,'13.10.2004',1,1,'600.00','','Ch. de la Cocarde','1024','Ecublens VD',0,NULL,NULL,NULL,0,1,0,0,1,1,0,0,1,0,NULL,NULL,NULL),(8133,'13.10.2004',1,1,'523.00','','Pré-du-Marché','1004','Lausanne',0,NULL,NULL,NULL,0,1,0,1,1,0,0,1,1,0,NULL,NULL,NULL),(8135,'13.10.2004',1,3,'923.00','sous-location','Ch. de Montelly','1007','Lausanne',0,NULL,NULL,NULL,1,1,1,0,0,0,0,0,1,0,NULL,NULL,NULL),(8051,'15.10.2004',1,1,'400.00','dans villa','ch. des Fleurs','1023','Crissier',1,1,0,0,1,1,0,0,1,0,1,0,0,1,1,0,NULL),(8136,'15.10.2004',1,1,'530.00','petit-déj. compris','Av. de Chailly','1012','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,1,0,0,1,1,0,NULL),(8137,'15.10.2004',1,1,'500.00','','av. de Préfaully','1020','Renens VD',1,1,0,0,1,1,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8138,'15.10.2004',1,2,'1100.00','','Av. Tir Fédéral','1024','Ecublens VD',0,NULL,NULL,NULL,1,0,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8140,'15.10.2004',1,4,'1500.00','','Av. du Léman','1005','Lausanne',0,NULL,NULL,NULL,0,0,0,0,0,0,0,1,0,0,NULL,NULL,NULL),(8141,'15.10.2004',1,1,'450.00','pour ETUDIANTE n\'étant pas là le week-end','av. des Huttins','1008','Prilly',1,1,0,0,1,0,0,0,1,0,0,0,0,1,1,0,NULL),(8142,'15.10.2004',1,1,'300.00','pour étudiant(e) non fumeur(se)','rue du Plan','1023','Crissier',1,1,0,0,1,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(7949,'15.10.2004',1,1,'550.00','proximité métro UNIL','ch. du Couchant 25','1007','Lausanne',1,1,0,0,1,1,1,0,1,0,0,0,1,1,1,0,NULL),(8143,'18.10.2004',1,2,'980.00','','Av. de la Sallaz','1010','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8144,'18.10.2004',1,2,'560.00','','Av. de France','1004','Lausanne',1,1,0,0,1,0,0,0,0,0,0,0,0,1,1,0,NULL),(8146,'18.10.2004',1,1,'460.00','','Av. Yverdon','1004','Lausanne',1,1,0,0,0,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8147,'18.10.2004',1,1,'550.00','Petit studio. 20 min à pied UNIL/EPFL. Prise internet. Dans villa','Rue de Renges','1024','Ecublens VD',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8148,'18.10.2004',1,1,'500.00','600.--avec services\n500.-- sans service e','Plaines du Loup','1018','Lausanne',0,NULL,NULL,NULL,1,0,0,0,1,0,0,0,1,1,1,0,NULL),(8150,'18.10.2004',1,1,'300.00','+ 7 à 8 heures par mois de ménage','av. Jomini 20','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,0,1,1,0,NULL),(8151,'18.10.2004',1,1,'580.00','','chemin de la Roche 1','1020','Renens VD',0,NULL,NULL,NULL,0,0,1,1,1,0,0,1,0,0,NULL,NULL,NULL),(8152,'18.10.2004',1,1,'470.00','','Clos-de-Bulle 9','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,0,0,1,1,1,0,NULL),(8153,'18.10.2004',1,1,'500.00','','chemin du Mont-Robert','1020','Renens VD',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8155,'18.10.2004',1,1,'550.00','aussi pour du court terme (pour dépanner)\npour étudiante non fumeuse','rue du Midi','1020','Renens VD',1,1,0,0,1,1,0,1,1,0,0,0,1,1,1,0,NULL),(8156,'18.10.2004',1,1,'460.00','Coin cuisine à partager\nNettoyage une fois par semaine\n\n','rue César Roux','1005','Lausanne',1,1,0,0,1,0,1,0,1,0,0,0,0,1,1,0,NULL),(7945,'18.10.2004',2,2,'450.00','chambre indépendante de 2 pièces (50 m2)\npour 1 à 2 personnes (fr. 550.-- pour 2 personnes)\n9 min. en bus de Lausanne, bus n° 9','ch. des Plateires','1009','Pully',0,NULL,NULL,NULL,1,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8044,'18.10.2004',1,1,'600.00','','Av. de la Sallaz','1010','Lausanne 10 Distribution',1,1,0,0,1,1,1,1,1,0,0,0,0,1,1,0,NULL),(7933,'19.10.2004',1,1,'550.00','','Ch. des Boracles','1008','Prilly',1,1,0,0,1,1,0,0,1,0,1,0,0,0,NULL,NULL,NULL),(8157,'19.10.2004',1,1,'560.00','','rue du Maupas 17','1004','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8158,'19.10.2004',1,1,'440.00','','ch. de Pierrefleur','1004','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8159,'19.10.2004',1,1,'300.00','Petite chambre, utilisation éventuelle de la cuisine','','1094','Paudex',0,NULL,NULL,NULL,1,1,0,1,1,1,0,0,0,1,1,0,1),(8160,'19.10.2004',1,1,'600.00','si chambre meublée + fr. 150.--','av. de valmont','1010','Lausanne',1,1,0,0,0,1,1,1,1,0,0,0,1,0,NULL,NULL,NULL),(8161,'19.10.2004',1,1,'650.00','','av. de Montchoisi 18 b','1006','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8162,'19.10.2004',1,1,'550.00','','av. Vinet','1004','Lausanne',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8163,'19.10.2004',1,1,'330.00','four à micro-ondes','ch. de Rovéréaz','1012','Lausanne',0,NULL,NULL,NULL,1,0,0,0,1,1,0,0,0,1,1,0,NULL),(8164,'19.10.2004',1,1,'350.00','pour étudiant(e) sérieux, non fumeur, désirant partager vie de famille\npouvons proposer petit déjeuner et le souper (prix à discuter)','ch. de Nant','1805','Jongny',0,NULL,NULL,NULL,1,0,0,0,1,1,0,0,0,1,1,0,NULL),(8165,'19.10.2004',1,2,'890.00','','rue des Alpes 47','1023','Crissier',0,NULL,NULL,NULL,1,0,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8166,'19.10.2004',1,1,'600.00','','rue du Battoir 22','1036','Sullens',1,1,0,0,1,1,0,0,1,1,0,0,1,0,NULL,NULL,NULL),(8167,'19.10.2004',1,1,'600.00','','Grandvignes','1030','Bussigny-près-Lausanne',0,NULL,NULL,NULL,1,1,1,0,1,1,0,0,0,0,NULL,NULL,NULL),(8168,'19.10.2004',1,1,'585.00','','Av. de la Gare','1005','Lausanne',0,NULL,NULL,NULL,0,1,0,0,0,0,0,1,0,0,NULL,NULL,NULL),(8170,'20.10.2004',1,1,'500.00','','Ch. Neuf','1028','Préverenges',1,1,0,0,1,1,0,0,1,0,1,0,0,1,1,0,NULL),(8171,'20.10.2004',1,1,'750.00','','Av. Tir Fédéral','1024','Ecublens VD',0,NULL,NULL,NULL,1,0,0,0,0,0,0,1,1,0,NULL,NULL,NULL),(8173,'20.10.2004',1,2,'700.00','sous-location.','Mont-Goulin','1008','Prilly',0,NULL,NULL,NULL,1,0,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8174,'20.10.2004',1,1,'450.00','','ch. du Martinet','1007','Lausanne',1,1,0,0,1,0,1,0,1,0,0,0,1,1,1,0,NULL),(8175,'20.10.2004',1,2,'1450.00','','Av. de France','1004','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8176,'20.10.2004',1,2,'740.00','','Isabelle de Montolieu','1010','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,1,1,0,0,NULL,NULL,NULL),(8177,'20.10.2004',1,2,'800.00','sous-location','Echelettes','1004','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,1,0,0,0,NULL,NULL,NULL),(8178,'21.10.2004',1,2,'1020.00','','Rte de Neuchâtel','1008','Prilly',0,NULL,NULL,NULL,1,0,0,0,1,1,0,0,1,0,NULL,NULL,NULL),(8179,'21.10.2004',1,1,'565.00','','av. de Tivoli 19b','1007','Lausanne',0,NULL,NULL,NULL,0,0,1,0,0,0,0,1,1,0,NULL,NULL,NULL),(8180,'22.10.2004',1,1,'500.00','Frigo + plaques-four dans le studio.\nNon-fumeur(se)\nDans villa.','Grand-Pré','1026','Echandens-Denges',0,NULL,NULL,NULL,1,1,0,0,1,0,1,0,0,0,NULL,NULL,NULL),(8181,'22.10.2004',1,1,'560.00','','av. de Riant Mont 8','1004','Lausanne',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8182,'22.10.2004',1,1,'500.00','2 chambres à louer dans une villa\navoir un moyen de transport','La Condemenaz','1040','St-Barthélemy VD',1,1,0,0,1,0,0,0,0,0,1,0,0,0,NULL,NULL,NULL),(7960,'25.10.2004',1,2,'870.00','lit double\n(peut convenir aussi pour un couple)','rue Marterey','1005','Lausanne',0,NULL,NULL,NULL,1,0,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8183,'26.10.2004',1,1,'650.00','','Rue St-Martin','1005','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,1,1,1,0,NULL,NULL,NULL),(8184,'26.10.2004',1,1,'600.00','','Av. du Château','1008','Prilly',0,NULL,NULL,NULL,1,1,0,1,1,0,0,0,0,0,NULL,NULL,NULL),(8185,'26.10.2004',1,1,'600.00','non fumeuse','Warnery','1007','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8186,'26.10.2004',1,3,'1390.00','','rue de la Pontaie','1018','Lausanne',1,1,0,0,0,0,0,1,1,0,0,0,0,1,1,0,NULL),(8187,'26.10.2004',1,4,'1580.00','inscription jusqu\'au 29.10.04','Ch. de la Cocarde','1024','Ecublens VD',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8189,'26.10.2004',1,1,'840.00','','Passage de Montriond','1006','Lausanne',0,NULL,NULL,NULL,1,0,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8190,'27.10.2004',1,1,'660.00','','ch. de la Venoge 3','1028','Préverenges',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,0,0,NULL,NULL,NULL),(8191,'27.10.2004',1,1,'600.00','jardin\n','ch. de l\'Ochettaz','1025','St-Sulpice VD',1,1,0,0,1,1,0,0,1,0,0,0,0,1,1,0,NULL),(8192,'27.10.2004',1,1,'489.00','visites samedi 30.10.04 et lundi 08.11.04 à 20h.','Rue du Village','1020','Renens VD',0,NULL,NULL,NULL,0,1,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8193,'27.10.2004',1,1,'500.00','','Av. des Oisieaux','1018','Lausanne',1,1,0,0,0,0,0,0,1,0,1,0,0,1,1,0,NULL),(8194,'27.10.2004',1,2,'850.00','sous-location pour 1 à 2 personnes\nvideo, dvd, \ninternet haut débit','ch. du Liaudoz','1009','Pully',0,NULL,NULL,NULL,1,1,0,1,1,1,1,0,0,0,NULL,NULL,NULL),(8195,'27.10.2004',1,1,'460.00','','ch. des Retraites','1004','Lausanne',1,1,0,0,1,0,0,0,1,0,0,1,1,1,1,0,NULL),(8197,'27.10.2004',1,1,'690.00','','rue de l\'Industrie 11','1020','Renens VD',0,NULL,NULL,NULL,0,0,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8198,'27.10.2004',1,1,'500.00','5 min. du TSOL','ch. du Mottey','1020','Renens VD',1,1,0,0,1,0,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8188,'28.10.2004',2,2,'1065.00','au plus tard fin juin 2005','rue de l\'Eglise anglaise','1006','Lausanne',1,0,1,0,1,0,0,0,1,1,1,0,1,1,0,0,1),(8199,'28.10.2004',1,2,'1250.00','','Av. de France','1004','Lausanne',0,NULL,NULL,NULL,1,1,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8200,'28.10.2004',1,1,'625.00','dans villa','Ch. des Charmilles','1008','Prilly',0,NULL,NULL,NULL,1,1,0,0,1,1,0,0,0,0,NULL,NULL,NULL),(8201,'28.10.2004',1,2,'670.00','','Av. Jomini','1004','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,0,1,1,0,NULL,NULL,NULL),(8202,'28.10.2004',1,1,'795.00','','Recordon','1004','Lausanne',0,NULL,NULL,NULL,0,0,0,0,1,0,1,1,0,0,NULL,NULL,NULL),(8203,'28.10.2004',1,1,'990.00','','Prairie','1007','Lausanne',0,NULL,NULL,NULL,1,0,0,0,0,1,1,0,1,0,NULL,NULL,NULL),(8204,'28.10.2004',1,1,'550.00','2 chambres à louer à fr. 550.-- et une 2ème à fr. 450.--','av. des Alpes  24','1006','Lausanne',1,1,0,0,0,1,0,0,1,0,0,1,0,1,1,0,NULL),(8205,'28.10.2004',2,2,'930.00','ou si illimité reprise de bail','av. de l\'Eglise Anglaise 5','1006','Lausanne',1,0,1,0,0,1,0,0,1,0,0,0,0,0,NULL,NULL,NULL),(8206,'28.10.2004',2,2,'932.00','joli appartement\nsous-location','av. de France 41','1004','Lausanne',0,NULL,NULL,NULL,1,0,0,0,1,0,0,0,1,0,NULL,NULL,NULL),(8207,'28.10.2004',1,4,'1400.00','','Aloys-Fauquez 131','1018','Lausanne',0,NULL,NULL,NULL,0,0,1,1,0,0,0,0,0,0,NULL,NULL,NULL),(7991,'28.10.2004',1,1,'400.00','télévision dans la chambre\nparlons français, englais, italien\ntrain régional','Ch. du Saux','1131','Tolochenaz',1,1,0,0,1,1,1,1,1,0,0,0,0,1,1,0,NULL),(8196,'29.10.2004',1,1,'690.00','','Rue de Genève 75','1004','Lausanne',0,NULL,NULL,NULL,1,1,1,0,1,0,0,0,0,0,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `appartement` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;