connect 'jdbc:derby:testdb;create=false'; DROP TABLE appartement_temp; CREATE TABLE appartement_temp ( id int, dateoffre varchar(12), nbrpersones int, nbrpieces int, loyer varchar(255), remarque varchar(9000), adresse varchar(9000), npa varchar(10), localite varchar(255), cuisine smallint, cuisine_partagee smallint, cuisine_agencee smallint, cuisine_rechaudpossible smallint, meuble smallint, tranquilite smallint, balcon smallint, vue smallint, bus smallint, proprietaire_prive smallint, stationnement smallint, gerance smallint, metrom1 smallint, salle_bain smallint, salle_bain_partagee smallint, salle_bain_douche smallint, salle_bain_baignore smallint, PRIMARY KEY (id) ); INSERT INTO appartement_temp 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); DROP TABLE appartement; CREATE TABLE appartement ( id int, dateoffre varchar(12), nbrpersones int, nbrpieces int, loyer decimal, remarque varchar(9000), adresse varchar(9000), npa int, localite varchar(255), cuisine smallint, cuisine_partagee smallint, cuisine_agencee smallint, cuisine_rechaudpossible smallint, meuble smallint, tranquilite smallint, balcon smallint, vue smallint, bus smallint, proprietaire_prive smallint, stationnement smallint, gerance smallint, metrom1 smallint, salle_bain smallint, salle_bain_partagee smallint, salle_bain_douche smallint, salle_bain_baignore smallint, PRIMARY KEY (id) ); INSERT INTO appartement SELECT id, dateoffre, nbrpersones, nbrpieces, CAST(loyer AS DECIMAL), remarque, adresse, CAST(npa AS INT), localite, cuisine, cuisine_partagee, cuisine_agencee, cuisine_rechaudpossible, meuble, tranquilite, balcon, vue, bus, proprietaire_prive, stationnement, gerance, metrom1, salle_bain, salle_bain_partagee, salle_bain_douche, salle_bain_baignore FROM appartement_temp; DROP TABLE appartement_temp; CREATE INDEX index_appartement_dateoffre_asc ON appartement (dateoffre ASC); CREATE INDEX index_appartement_dateoffre_desc ON appartement (dateoffre DESC); CREATE INDEX index_appartement_nbrpersones_asc ON appartement (nbrpersones ASC); CREATE INDEX index_appartement_nbrpersones_desc ON appartement (nbrpersones DESC); CREATE INDEX index_appartement_nbrpieces_asc ON appartement (nbrpieces ASC); CREATE INDEX index_appartement_nbrpieces_desc ON appartement (nbrpieces DESC); CREATE INDEX index_appartement_loyer_asc ON appartement (loyer ASC); CREATE INDEX index_appartement_loyer_desc ON appartement (loyer DESC); CREATE INDEX index_appartement_remarque_asc ON appartement (remarque ASC); CREATE INDEX index_appartement_remarque_desc ON appartement (remarque DESC); CREATE INDEX index_appartement_adresse_asc ON appartement (adresse ASC); CREATE INDEX index_appartement_adresse_desc ON appartement (adresse DESC); CREATE INDEX index_appartement_npa_asc ON appartement (npa ASC); CREATE INDEX index_appartement_npa_desc ON appartement (npa DESC); CREATE INDEX index_appartement_localite_asc ON appartement (localite ASC); CREATE INDEX index_appartement_localite_desc ON appartement (localite DESC); CREATE INDEX index_appartement_cuisine_asc ON appartement (cuisine ASC); CREATE INDEX index_appartement_cuisine_desc ON appartement (cuisine DESC); CREATE INDEX index_appartement_cuisine_partagee_asc ON appartement (cuisine_partagee ASC); CREATE INDEX index_appartement_cuisine_partagee_desc ON appartement (cuisine_partagee DESC); CREATE INDEX index_appartement_cuisine_agencee_asc ON appartement (cuisine_agencee ASC); CREATE INDEX index_appartement_cuisine_agencee_desc ON appartement (cuisine_agencee DESC); CREATE INDEX index_appartement_cuisine_rechaudpossible_asc ON appartement (cuisine_rechaudpossible ASC); CREATE INDEX index_appartement_cuisine_rechaudpossible_desc ON appartement (cuisine_rechaudpossible DESC); CREATE INDEX index_appartement_meuble_asc ON appartement (meuble ASC); CREATE INDEX index_appartement_meuble_desc ON appartement (meuble DESC); CREATE INDEX index_appartement_tranquilite_asc ON appartement (tranquilite ASC); CREATE INDEX index_appartement_tranquilite_desc ON appartement (tranquilite DESC); CREATE INDEX index_appartement_balcon_asc ON appartement (balcon ASC); CREATE INDEX index_appartement_balcon_desc ON appartement (balcon DESC); CREATE INDEX index_appartement_vue_asc ON appartement (vue ASC); CREATE INDEX index_appartement_vue_desc ON appartement (vue DESC); CREATE INDEX index_appartement_bus_asc ON appartement (bus ASC); CREATE INDEX index_appartement_bus_desc ON appartement (bus DESC); CREATE INDEX index_appartement_proprietaire_prive_asc ON appartement (proprietaire_prive ASC); CREATE INDEX index_appartement_proprietaire_prive_desc ON appartement (proprietaire_prive DESC); CREATE INDEX index_appartement_stationnement_asc ON appartement (stationnement ASC); CREATE INDEX index_appartement_stationnement_desc ON appartement (stationnement DESC); CREATE INDEX index_appartement_gerance_asc ON appartement (gerance ASC); CREATE INDEX index_appartement_gerance_desc ON appartement (gerance DESC); CREATE INDEX index_appartement_metrom1_asc ON appartement (metrom1 ASC); CREATE INDEX index_appartement_metrom1_desc ON appartement (metrom1 DESC); CREATE INDEX index_appartement_salle_bain_asc ON appartement (salle_bain ASC); CREATE INDEX index_appartement_salle_bain_desc ON appartement (salle_bain DESC); CREATE INDEX index_appartement_salle_bain_partagee_asc ON appartement (salle_bain_partagee ASC); CREATE INDEX index_appartement_salle_bain_partagee_desc ON appartement (salle_bain_partagee DESC); CREATE INDEX index_appartement_salle_bain_douche_asc ON appartement (salle_bain_douche ASC); CREATE INDEX index_appartement_salle_bain_douche_desc ON appartement (salle_bain_douche DESC); CREATE INDEX index_appartement_salle_bain_baignore_asc ON appartement (salle_bain_baignore ASC); CREATE INDEX index_appartement_salle_bain_baignore_desc ON appartement (salle_bain_baignore DESC);