-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 18, 2019 at 05:38 AM
-- Server version: 10.0.23-MariaDB-0ubuntu0.15.04.1
-- PHP Version: 5.6.4-4ubuntu6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `db345307_ria`
--

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

--
-- Table structure for table `agence`
--

DROP TABLE IF EXISTS `agence`;
CREATE TABLE `agence` (
  `nagence` int(11) NOT NULL DEFAULT '1',
  `cagence` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lnomagence` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcp` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ladr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llocalite` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltel` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltel2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lfax` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lgsm` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lemail` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lwebsite` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `ltva` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lrc` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lbanque1` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpaysfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitrefr` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ldescfr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyfr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `nrole` int(4) DEFAULT NULL,
  `lpaysnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitrenl` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ldescnl` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeynl` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lpaysen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitreen` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ldescen` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyen` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lpaysde` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitrede` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ldescde` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyde` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cisopays` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cdeviseref` varchar(3) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lipi` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `qcss` int(2) NOT NULL DEFAULT '1',
  `dmod` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `lraisonsociale` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ladrsiege` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcpsiege` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llocalitesiege` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpayssiege` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llieurc` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcapitalsocial` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lnomgerant` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lprenomgerant` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lresponsablepub` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lhebergeur` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lorgdelivcartepro` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llieudelivcartepro` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lnomcaissegarantie` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lmontantgarantie` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lnomassurance` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lrefcontratassurance` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lbanque2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lkeywordregionmetaen` text COLLATE utf8_bin,
  `lkeywordregionen` text COLLATE utf8_bin,
  `lkeywordtypmetaen` text COLLATE utf8_bin,
  `lkeywordtypen` text COLLATE utf8_bin,
  `lkeywordtypmandaten` text COLLATE utf8_bin,
  `lkeywordregionmetafr` text COLLATE utf8_bin,
  `lkeywordregionfr` text COLLATE utf8_bin,
  `lkeywordtypmetafr` text COLLATE utf8_bin,
  `lkeywordtypfr` text COLLATE utf8_bin,
  `lkeywordtypmandatfr` text COLLATE utf8_bin,
  `llongitude` double DEFAULT NULL,
  `llatitude` double DEFAULT NULL,
  `ltitrees` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ldesces` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyes` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lpayses` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpaysit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpayssk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpayscs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpaysru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpayszh` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitreit` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ltitresk` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ltitrecs` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ltitreru` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ltitrezh` varchar(120) COLLATE utf8_bin DEFAULT NULL,
  `ldescit` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ldescsk` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ldesccs` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ldescru` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ldesczh` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyit` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeysk` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeycs` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyru` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lkeyzh` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `mlongitude` double DEFAULT NULL,
  `mlatitude` double DEFAULT NULL,
  `lfacebook` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lgoogleplus` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `llinkedin` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `linstragram` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ltwitter` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lintraneturl` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lformesociale` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `lsiret` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ddatedelivcartepro` date DEFAULT NULL,
  `lmediateur` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `agence`
--
--
-- Table structure for table `bien`
--

DROP TABLE IF EXISTS `bien`;
CREATE TABLE `bien` (
  `nbien` int(11) NOT NULL DEFAULT '0',
  `cagence` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `cbien` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT 'ind',
  `mprix` int(11) DEFAULT NULL,
  `ctyp` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `ndept` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `nannee` int(11) DEFAULT NULL,
  `qsurfterrain` int(11) DEFAULT NULL,
  `cetat` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `qchambres` int(11) DEFAULT NULL,
  `qpieces` int(11) DEFAULT NULL,
  `qsurfhab` int(11) DEFAULT NULL,
  `qsurfsejour` int(11) DEFAULT NULL,
  `cregion` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT 'ind',
  `cenvironnement` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `ctypmandat` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT 'ind',
  `ndisponibilite` int(11) DEFAULT NULL,
  `ladr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcp` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llocalite` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cisopays` varchar(3) COLLATE utf8_bin DEFAULT NULL,
  `nnatmandat` int(11) DEFAULT NULL,
  `cnaturebien` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `netageappart` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `netagetot` int(11) DEFAULT NULL,
  `lplan` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lvue` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `qsdb` int(11) DEFAULT NULL,
  `qsdd` int(11) DEFAULT NULL,
  `qgarages` int(11) DEFAULT NULL,
  `qparking` int(11) DEFAULT NULL,
  `bpiscine` int(11) NOT NULL DEFAULT '0',
  `bcave` int(11) NOT NULL DEFAULT '0',
  `bascenceur` int(11) NOT NULL DEFAULT '0',
  `bvuesurmer` int(11) NOT NULL DEFAULT '0',
  `btennis` int(11) DEFAULT '0',
  `nanneerenov` int(11) DEFAULT NULL,
  `cchauf` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `ntypcuisine` int(11) DEFAULT NULL,
  `mrevcad` int(11) DEFAULT NULL,
  `mcharge` int(11) DEFAULT NULL,
  `mprecimmo` int(11) DEFAULT NULL,
  `cstyle` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `dcre` datetime DEFAULT NULL,
  `dmod` date DEFAULT NULL,
  `qbureau` int(11) DEFAULT NULL,
  `qsurfterrasse` int(11) DEFAULT NULL,
  `mcommission` int(11) DEFAULT NULL,
  `ddisponibilite` datetime DEFAULT NULL,
  `qmurmitoy` int(11) DEFAULT NULL,
  `sfilename` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ctypmeta` varchar(4) COLLATE utf8_bin DEFAULT NULL,
  `sfilenameegg` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `bcoupdecoeur` int(11) DEFAULT '0',
  `bnouveaute` int(11) DEFAULT '0',
  `bdefilement` int(11) DEFAULT '0',
  `bprestige` int(11) DEFAULT '0',
  `baffaire` int(11) DEFAULT '0',
  `bvisite180` int(11) DEFAULT '0',
  `bcacherprix` int(11) DEFAULT '0',
  `dtransaction` datetime DEFAULT NULL,
  `llongitude` double DEFAULT NULL,
  `llatitude` double DEFAULT NULL,
  `lusername` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `nprospectpropr` int(11) DEFAULT NULL,
  `bactif` int(11) DEFAULT NULL,
  `mlongitude` double DEFAULT NULL,
  `mlatitude` double DEFAULT NULL,
  `cclasseenergie` varchar(1) COLLATE utf8_bin DEFAULT NULL,
  `cclasseges` varchar(1) COLLATE utf8_bin DEFAULT NULL,
  `cmethodecalcdpe` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `qconsoenergie` int(11) DEFAULT NULL,
  `qemissionges` int(11) DEFAULT NULL,
  `bvuemer` int(11) DEFAULT NULL,
  `bneuf` int(11) DEFAULT NULL,
  `nbiendepend` int(11) DEFAULT NULL,
  `cdevise` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `lpassword` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `lemail` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lnomsociete` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lprenom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `sfilenames` varchar(5000) COLLATE utf8_bin DEFAULT NULL,
  `tcommissionvendeur` double DEFAULT NULL,
  `mcommissionvendeur` int(11) DEFAULT NULL,
  `mcommissionacquereur` int(11) DEFAULT NULL,
  `bbaisseprix` int(11) DEFAULT '0',
  `coriginebien` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `qconsoenergiemin` int(11) DEFAULT NULL,
  `cclasseenergiemin` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `lcustom1` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `lcustom2` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `lcustom3` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `lcustom4` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `lcustom5` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `cregionpeb` varchar(1) COLLATE utf8_bin DEFAULT NULL,
  `mprixeur` int(11) DEFAULT NULL,
  `mprixusd` int(11) DEFAULT NULL,
  `mprixmur` int(11) DEFAULT NULL,
  `qwc` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `bien`
--

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

--
-- Table structure for table `biencrit`
--

DROP TABLE IF EXISTS `biencrit`;
CREATE TABLE `biencrit` (
  `nprospect` int(11) NOT NULL DEFAULT '0',
  `lcomment` mediumtext COLLATE utf8_bin,
  `lsql` mediumtext COLLATE utf8_bin,
  `dcre` datetime DEFAULT NULL,
  `dmod` datetime DEFAULT NULL,
  `lnom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lprenom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lemail` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `brelanceauto` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `biendesc`
--

DROP TABLE IF EXISTS `biendesc`;
CREATE TABLE `biendesc` (
  `nbien` int(11) NOT NULL DEFAULT '0',
  `clangue` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT 'fr',
  `ltypmeta` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregion` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lnaturebien` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lenvironnement` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldisponibilite` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lstyle` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandat` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `letat` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lchauf` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypcuisine` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `ltyp` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitre` varchar(2000) COLLATE utf8_bin DEFAULT NULL,
  `lannonce` mediumtext COLLATE utf8_bin,
  `lannonceweb` mediumtext COLLATE utf8_bin,
  `lhtml` longtext COLLATE utf8_bin,
  `lascii` longtext COLLATE utf8_bin,
  `lnearestlocalite` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `ltypurl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetaurl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionurl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetaurl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandaturl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llocaliteurl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lgeourl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lgeo` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitreurl` varchar(2000) COLLATE utf8_bin DEFAULT NULL,
  `lregionmeta` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lurlext` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `biendesc`
--

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

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `cartId` int(11) NOT NULL,
  `cookieId` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `nbien` int(11) NOT NULL DEFAULT '0',
  `qty` int(11) DEFAULT NULL,
  `dcre` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `cart`
--

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

--
-- Table structure for table `detail`
--

DROP TABLE IF EXISTS `detail`;
CREATE TABLE `detail` (
  `ndetail` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ldetailfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailde` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ntypdetail` int(11) NOT NULL DEFAULT '0',
  `nordre` int(4) UNSIGNED DEFAULT NULL,
  `binternet` int(11) DEFAULT NULL,
  `ldetailes` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailcs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ldetailzh` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cunite` varchar(25) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `detail`
--

INSERT INTO `detail` (`ndetail`, `ldetailfr`, `ldetailen`, `ldetailde`, `ldetailnl`, `ntypdetail`, `nordre`, `binternet`, `ldetailes`, `ldetailit`, `ldetailsk`, `ldetailcs`, `ldetailru`, `ldetailzh`, `cunite`) VALUES
(12, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 2, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(21, 'Piscine', 'Swimming Pool', NULL, 'Zwembad', 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(22, 'Jardin', 'Garden', NULL, 'Tuin', 1, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(23, 'Parc', 'Park', NULL, 'Park', 1, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(24, 'Arboré', 'Wooded Area', NULL, 'Gehesen', 1, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(26, 'Cour', 'Courtyard', NULL, 'Hof', 1, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(29, 'Potager', 'Vegetable garden', NULL, 'Groententuin', 1, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(30, 'Box à chevaux', 'Horse Stables', NULL, 'Paarden Box', 69, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(31, 'Atelier', 'Workshop', NULL, 'Werkplaats', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(32, 'Abri', 'Shelter', NULL, 'Schuilplaats', 69, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(54, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 2, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(55, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 2, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(218, 'Chaufferie', 'Boiler Room', NULL, 'Verwarming kamer', 3, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(219, 'Allée privée', 'Private driveway', NULL, 'Particuliere laan', 1, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(220, 'Barbecue', 'Barbecue', NULL, 'Barbecue', 1, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(222, 'Port', 'Port', NULL, 'Haven', 4, 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(223, 'Centre ville', 'Town Centre', NULL, 'Centrum', 4, 38, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(226, 'Puits', 'Wells', NULL, 'Put', 1, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(233, 'Centre commercial', 'Commercial Centre', NULL, 'Winkelcentrum', 4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(237, 'Cloturé', 'Fenced', NULL, 'Afrasteerd', 1, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(240, 'Ascenseur', 'Lift', NULL, 'Lift', 20, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(241, 'Concierge/Gardien', 'Caretaker', NULL, 'Conciërge/huisbewaarder', 20, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(246, 'Parking', 'Car Park', NULL, 'Parkeerplaats', 4, 32, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(247, 'Mer', 'Sea', NULL, 'Zee', 4, 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(255, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(258, 'Grange', 'Barn', NULL, 'Schuur', 69, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(260, 'Terrasse', 'Terrace', NULL, 'Terras', 3, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(284, 'Air conditionné', 'Air Conditioning', NULL, 'Geconditioneerde lucht', 20, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(285, 'Sauna', 'Sauna', NULL, 'Sauna', 20, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(287, 'Porte blindée', 'Armoured Door', NULL, 'Gepantserde deur', 20, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(288, 'Double vitrage', 'Double Glazing', NULL, 'Dubbele beglazing', 20, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(289, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 2, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(290, 'Véranda', 'Veranda', NULL, 'Veranda', 2, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(292, 'Jacuzzi', 'Jacuzzi', NULL, 'Jacuzzi', 20, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(502, 'Placards', 'Cupboards', NULL, 'Kasten', 20, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(505, 'Internet haut débit', 'Broadband Internet', NULL, 'Internet hoge snelheden', 51, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(506, 'Centrale téléphonique', 'Telephone Exchange', NULL, 'Telefooncentrale', 51, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(507, 'Alarme', 'Alarm', NULL, 'Alarm', 51, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(508, 'Internet par cable TV', 'TV Cable Internet', NULL, 'Internet per tv kabel', 51, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(509, 'Interphone', 'Interphone', NULL, 'Intercom', 51, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(510, 'Videophone', 'Videophone', NULL, 'Videophone', 51, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(511, 'Câble TV', 'Cable TV', NULL, 'Kabel TV', 51, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(526, 'Lino', 'Lino', NULL, 'Lino', 53, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(527, 'Carrelage', 'Tiled Floor', NULL, 'Betegelen', 53, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(528, 'Marbre', 'Marble', NULL, 'Marmer', 53, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(529, 'Parquet', 'Laminate Flooring', NULL, 'Gelamineerde bevloering', 53, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(530, 'Tapis', 'Carpets', NULL, 'Tapijt', 53, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(531, 'Sous-sol', 'Basement', NULL, 'Kelder', 54, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(532, 'Rez', 'Ground Level', NULL, 'Gelijkvloers', 54, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(533, '1ère étage', 'First Floor', NULL, 'Eerte Verdieping', 54, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(534, '2ème étage', 'Second Floor', NULL, 'Tweede Verdieping', 54, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(535, '3ème étage', 'Third Floor', NULL, 'Derde Verdieping', 54, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(536, '4ème étage', 'Fourth Floor', NULL, 'Vierde Verdieping', 54, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(537, '5ème étage', 'Fifth Floor', NULL, 'Vijfde Verdieping', 54, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(538, '6ème étage', 'Sixth Floor', NULL, 'Zesde Verdieping', 54, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(539, 'Grenier', 'Attic', NULL, 'Zolder', 54, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(541, 'Frigo', 'Fridge', NULL, 'Koelkast', 55, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(542, 'Congélateur', 'Freezer', NULL, 'Diepvrieskast', 55, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(545, 'Cuisinière au gaz', 'Gas Cooker', NULL, 'Gas fornuis', 55, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(546, 'Four', 'Oven', NULL, 'Oven', 55, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(540, 'Meubles de cuisine', 'Kitchen Furniture', NULL, 'Keuken meubelen', 55, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(503, 'Cheminée(s)', 'Fireplace(s)', NULL, 'Schoorsteen', 20, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(547, 'Four à micro-ondes', 'Microwave', NULL, 'Microgolfoven', 55, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(548, 'Lave vaisselle', 'Dishwasher', NULL, 'Vaatwasmachine', 55, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(549, 'Lave linge', 'Washing Machine', NULL, 'Wasmachine', 55, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(550, 'Séchoir', 'Dryer', NULL, 'Droogtoestel', 55, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(552, 'Ligne numérique', 'Digital Phoneline', NULL, 'Numerieke lijn', 51, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(555, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 2, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(557, 'Cuisine', 'Kitchen', NULL, 'Keuken', 2, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(561, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 2, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(562, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 2, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(563, 'Garage(s)', 'Garage(s)', NULL, 'Garage(s)', 3, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(564, 'Cave', 'Cellar', NULL, 'Kelder', 3, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(565, 'Buanderie', 'Laundry Room', NULL, 'Washok', 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(566, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 2, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(568, 'Conciergerie', 'Concierge Service', NULL, 'Ambt van huisbewaarder', 3, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(570, 'Coffre-fort', 'Safe', NULL, 'Brandkast', 20, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(571, 'Bois', 'Wood', NULL, 'Hout', 1, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(572, 'Terrain de tennis', 'Tennis Court', NULL, 'Tennis hof', 1, 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(573, 'Balcon', 'Balcony', NULL, 'Balkon', 3, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(574, 'Ecurie', 'Stables', NULL, 'Stal', 3, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(576, 'Office', 'Office', NULL, 'Zetel', 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(577, 'Remise', 'Storage area', NULL, 'Korting', 3, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(578, 'Cellier', 'Storeroom', NULL, 'Kelder', 3, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(579, 'Parking', 'Parking', NULL, 'Parkeerplaats', 3, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(581, 'Tennis', 'Tennis', NULL, 'Tennis', 20, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(582, 'Fitness', 'Fitness', NULL, 'Fitness', 20, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(583, 'Réseau informatique', 'IT Network', NULL, 'Informaticanetwerk', 51, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(584, 'Antenne parabolique', 'Satellite Dish', NULL, 'Satelliet antenne', 51, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(585, 'Téléphone', 'Telephone', NULL, 'Telefoon', 51, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(586, 'Surgélateur', 'Freezer', NULL, 'Diepvriezer', 55, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(587, 'Cuisinière électrique', 'Electric Cooker', NULL, 'Elektrisch fornuis', 55, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(588, 'Cuisinière vitrocéramique', 'Ceramic Cooker', NULL, 'Keramisch kookvlak fornhuis', 55, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(589, 'Hotte aspirante', 'Extractor Fan', NULL, 'Wasemkap', 55, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(590, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 2, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(593, 'Mosaïque', 'Mosaic', NULL, 'Mozaïek', 53, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(596, 'Chape', 'Coating', NULL, 'Deklaag', 53, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(597, 'Laminé', 'Laminate', NULL, 'Gewalst', 53, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(598, 'Plancher', 'Floor', NULL, 'Plakenvloer', 53, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(599, 'Enduit plâtre', 'Plaster Coating', NULL, 'Bepleistering', 58, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(600, 'Carrelage', 'Tiled Floor', NULL, 'Betegelen', 58, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(601, 'Papier-peint', 'Wall-paper', NULL, 'Behangselpapier', 58, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(602, 'Fibre', 'Fibre', NULL, 'Vezel', 58, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(603, 'Tissu', 'Fabric', NULL, 'Stof', 58, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(604, 'Tapis', 'Carpets', NULL, 'Tapijt', 58, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(605, 'Brique', 'Brick', NULL, 'Baksteen', 58, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(606, 'Crépi', 'Roughcast', NULL, 'Pleisterlaag', 58, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(607, 'Mozaïque', 'Mosaic', NULL, 'Mozaïek', 58, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(608, 'Marbre', 'Marble', NULL, 'Marmer', 58, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(609, 'Ecole', 'School', NULL, 'School', 4, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(610, 'Université', 'University', NULL, 'Universiteit', 4, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(611, 'Gare', 'Station', NULL, 'Station', 4, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(612, 'Piste de ski', 'Ski Track', NULL, 'Ski piste', 4, 49, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(613, 'Piste de randonnée', 'Hiking Trail', NULL, 'Tochtpad', 4, 48, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(614, 'Piste de VTT', 'Mountain Bike Track', NULL, 'VTT pad', 4, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(615, 'Chemin de promenade', 'Pathway', NULL, 'Wandelpad', 4, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(616, 'Club sportif', 'Sports Club', NULL, 'Sport club', 4, 40, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(617, 'Station de taxi', 'Taxi Station', NULL, 'Taxistation', 4, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(618, 'Aéroport', 'Airport', NULL, 'Luchthaven', 4, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(619, 'Super marché', 'Supermarket', NULL, 'Supermarkt', 4, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(620, 'Centre religieux', 'Religious Centre', NULL, 'Religieus centrum', 4, 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(621, 'Autoroute', 'Motorway', NULL, 'Autoweg', 4, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(622, 'Loggia', 'Loggia', NULL, 'Loggia', 2, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(623, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 2, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(592, 'Friteuse', 'Fryer', NULL, 'Friteuse', 55, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(591, 'Grill', 'Grill', NULL, 'Grill', 55, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(629, 'Dégagée', 'Open View', NULL, 'Losgemaakt', 61, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(630, 'Vue sur mer', 'Sea View', NULL, 'Zicht over zee', 61, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(631, 'Vue sur port', 'Port View', NULL, 'Zicht over haven', 61, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(632, 'Vue sur piste de ski', 'Ski Station View', NULL, 'Zicht over ski piste', 61, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(633, 'Vue sur montagne', 'Mountain View', NULL, 'Zicht over berg', 61, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(634, 'Petit déjeuner', 'Breakfast', NULL, 'Ontbijt', 62, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(635, 'Demi-pension', 'Half-Board', NULL, 'Half-pension', 62, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(636, 'Pension complète', 'Full-Board', NULL, 'Vol pension', 62, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(637, 'Draps fournis', 'Sheets Provided', NULL, 'Geleverde lakens', 62, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(638, 'Ménage', 'Housekeeping', NULL, 'Huihouden', 62, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(639, 'Laverie', 'Launderette', NULL, 'Wasserij', 62, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(640, 'Gardien d\'enfant la journée', 'Day Babby Sitter', NULL, 'Dagkinderbewaarder', 62, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(641, 'Gardien d\'enfant le soir', 'Night Babby Sitter', NULL, 'Nachtkinderbewaarder', 62, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(642, 'Restaurant', 'Restaurant', NULL, 'Restaurant', 4, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(643, 'Café/bar', 'Café / bar', NULL, 'Café / bar', 4, 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(644, 'Cinéma', 'Cinema', NULL, 'Bioscoop', 4, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(645, 'Lac', 'Lake', NULL, 'Meer', 4, 44, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(646, 'Tennis', 'Tennis', NULL, 'Tennis', 4, 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(647, 'Golf', 'Golf', NULL, 'Golf', 4, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(648, 'Escalade', 'Climbing', NULL, 'Klimmen', 4, 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(649, 'Rafting', 'Rafting', NULL, 'Rafting', 4, 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(650, 'Plongée', 'Diving', NULL, 'Duiking', 4, 51, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(651, 'Pêche', 'Fishing', NULL, 'Visserij', 4, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(652, 'Discothèque', 'Nightclub', NULL, 'Discotheek', 4, 41, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(653, 'Kayak', 'Kayak', NULL, 'Kajak', 4, 43, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(654, 'Equitation', 'Horse Riding', NULL, 'Paardrijden', 4, 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(655, 'Monument historique', 'Historical monument', NULL, 'Historisch gebouw', 4, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(656, 'Piscine', 'Swimming Pool', NULL, 'Zwembad', 4, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(657, 'Hôpital', 'Hospital', NULL, 'Ziekenhuis', 4, 31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(659, 'Français', 'French', NULL, 'Frans', 63, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(660, 'Néerlandais', 'Dutch', NULL, 'Nederlands', 63, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(661, 'Anglais', 'English', NULL, 'Engels', 63, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(662, 'Allemand', 'German', NULL, 'Duits', 63, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(663, 'Espagnol', 'Spanish', NULL, 'Spaans', 63, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(664, 'Portugais', 'Portuguese', NULL, 'Portugese', 63, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(665, 'Italien', 'Italian', NULL, 'Italiaan', 63, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(666, 'Luxembourgeois', 'From Luxembourg', NULL, 'Luxemburger', 63, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(667, 'Vue sur parc', 'Park View', NULL, 'Zicht over park', 61, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(668, 'Télévision', 'TV', NULL, 'Televisie', 51, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(673, 'Salon TV', 'TV Room', NULL, 'TV kamer', 2, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(674, 'Vestiaire', 'Cloakroom', NULL, 'Kleedkamer', 2, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(675, 'Bar', 'Bar', NULL, 'Saloon', 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(676, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 2, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(677, 'Palier', 'Level', NULL, 'Trapportaal', 2, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(678, 'Jardin d\'hiver', 'Winter Garden', NULL, 'Winter tuin', 3, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(679, 'Etable', 'Cowshed', NULL, 'Stal', 69, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(681, 'Débarras', 'Storage Room', NULL, 'Berghok', 3, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(682, 'Poulailler', 'Hen House', NULL, 'Kippenhok', 3, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(683, 'Pigeonnier', 'Pigeonhole', NULL, 'Duiventil', 69, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(684, 'Etang', 'Pond', NULL, 'Vijver', 1, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(685, 'Terrain de pétanque', 'Pétanque area', NULL, 'Petanque terrein', 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(686, 'Boisé', 'Wooded', NULL, 'Bebost', 1, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(687, 'Portail', 'Gate', NULL, 'Portaal', 1, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(688, 'Verger', 'Orchard', NULL, 'Boomgaard', 1, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(690, 'Serre', 'Greenhouse', NULL, 'Broeikas', 1, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(691, 'Mobilier de jardin', 'Garden Furniture', NULL, 'Tuin meubelen', 20, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(692, 'Monte charge', 'Hoist', NULL, 'Goederenlift', 20, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(693, 'Thermostat', 'Thermostat', NULL, 'Thermostaat', 51, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(694, 'Dolby suround', 'Dolby suround', NULL, 'Dolby suround', 51, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(695, 'Eclairage jardin', 'Garden light', NULL, 'Tuin verlichting', 51, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(696, 'Porte de garage électrique', 'Electric Garage Doors', NULL, 'Elektrische garagedeur', 51, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(697, 'Portail électrique', 'Electric Gate', NULL, 'Elektrisch portaal', 51, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(700, 'Pierre naturelle', 'Natural Stone', NULL, 'Natureel steen', 53, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(701, 'Dallage', 'Paving', NULL, 'Bevloering', 53, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(702, 'Peinture', 'Painting', NULL, 'Schilderij', 58, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(703, 'Patine', 'Patina', NULL, 'Patio', 58, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(704, 'Bois-lambris', 'Thatched Roof', NULL, 'Hout-lambrizering', 58, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(705, 'Entresol', 'Mezzanine', NULL, 'Tussenverdieping', 54, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(706, 'Bus', 'Bus', NULL, 'Bus', 4, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(707, 'Tram', 'Tram', NULL, 'Tram', 4, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(708, 'Métro', 'Subway', NULL, 'Metro', 4, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(710, 'Théâtre', 'Theatre', NULL, 'Theater', 4, 54, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(711, 'Musée', 'Museum', NULL, 'Museum', 4, 47, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(712, 'Vue panoramique', 'Panoramic View', NULL, 'Panoramarijke landschap', 61, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(713, 'Vue sur jardin', 'Garden View', NULL, 'Zicht over tuin', 61, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(714, 'Vue sur piscine', 'Swimming Pool View', NULL, 'Zicht over zwembad', 61, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(715, 'Accès handicapé', 'Access for disabled', NULL, 'Toegang voor mindervaliden', 62, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(716, 'Entretien jardin', 'Garden maintenance', NULL, 'Tuin onderhoud', 62, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(717, 'Entretien piscine', 'Swimming pool maintenance', NULL, 'Zwembad onderhoud', 62, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(718, 'Nurserie', 'Nursery', NULL, 'Babykamer', 62, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(719, 'Russe', 'Russian', NULL, 'Rus', 63, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(721, 'Crèche', 'Day Nursery', NULL, 'Krib', 4, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(722, 'Tapis de pierres', 'Stone Floor', NULL, 'Steentapijt', 53, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(723, 'Linoléum', 'Linoleum', NULL, 'Linoléum', 53, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(725, 'Insert', 'Wood Burning Stove', NULL, 'Insert', 20, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(726, 'Ardoises', 'Roof Slates', NULL, 'Leien', 66, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(727, 'Tuiles', 'Tiles', NULL, 'Dakpannen', 66, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(728, 'Zinc', 'Zinc', NULL, 'Zink', 66, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(729, 'Aluminium', 'Aluminium', NULL, 'Aluminium', 66, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(730, 'Bitumé', 'Tarmaced', NULL, 'Geasfalteerd', 66, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(731, 'Chaume', 'Thatched Roof', NULL, 'Stoppel', 66, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(732, 'Tôle ondulée', 'Corrugated Iron', NULL, 'golfplaatijzer', 66, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(733, 'PVC', 'PVC', NULL, 'PVC', 66, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(734, 'Volets électriques', 'Electric shutters', NULL, 'Elektrische blinden', 51, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(736, 'Tente solaire', 'Solar tent', NULL, 'Zonnetent', 20, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(746, 'Bois', 'Wood', NULL, 'Hout', 68, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(747, 'PVC', 'PVC', NULL, 'PVC', 68, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(748, 'Aluminium', 'Aluminium', NULL, 'Aluminium', 68, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(749, 'Volet', 'Shutter', NULL, 'Blinden', 20, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(751, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 2, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(753, 'WC pour handicapé', 'WC for disabled', NULL, 'Toilet voor mindervaliden', 3, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(754, 'Local bicyclette', 'Bicycle Room', NULL, 'Fietskamer', 3, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(755, 'Escalier de secours', 'Fire Escape', NULL, 'Hulp trappen', 20, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(757, 'Adoucisseur d\'eau', 'Water Softening Device', NULL, 'Apparaat om water te verzachten', 20, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(760, 'DVD', 'DVD', NULL, 'DVD', 51, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(761, 'Hifi', 'Hifi', NULL, 'Hifi', 51, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(762, 'Métal', 'Metal', NULL, 'Metaal', 68, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2001, 'Sauna', 'Sauna', NULL, 'Sauna', 3, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2005, 'Fax', 'Fax', NULL, 'Fax', 51, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2006, 'Lingerie', 'Laundry', NULL, 'Linenkamer', 3, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2021, 'Grenier aménageable', 'Convertible Attic', NULL, 'In te richten zolder', 3, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2022, 'Grenier', 'Attic', NULL, 'Zolder', 3, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2024, 'Gîte', 'Cottage', NULL, 'Onderdak', 3, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2025, 'Maison de gardien', 'Caretaker\'s House', NULL, 'Huisbewaarder huis', 69, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2026, 'Chapelle', 'Chapel', NULL, 'Kapel', 69, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2027, 'Préau', 'Covered Area', NULL, 'Binnenplaats', 69, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2028, 'Vue sur forêt/bois', 'Forest View', NULL, 'Zicht over vorst/woud', 61, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2029, 'Gare TGV', 'TGV Station', NULL, 'TGV station', 4, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2030, 'Commerces', 'Shops', NULL, 'Handel', 4, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2031, 'Four à pain', 'Bread Oven', NULL, 'Bood-oven', 69, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2032, 'Lavoir', 'Wash House', NULL, 'Wasserij', 3, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2033, 'Pierres apparentes', 'Exposed stones', NULL, 'Zichtbare stenen', 58, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2034, 'Chaux', 'Whitewashed', NULL, 'Kalk', 58, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(1000, 'Coup de Coeur', 'Featured', NULL, 'Coup de coeur', 100, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(1001, 'Nouveauté', 'New', NULL, 'Nieuw', 100, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2035, 'Parquet flottant', 'Floating Floor', NULL, 'Drijvend gelamineerde bevloering', 53, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2036, 'Réception', 'Reception', NULL, 'Receptie', 2, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2037, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 2, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2051, 'Salon', 'Lounge', NULL, 'Zitkamer', 2, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2055, 'Tout à l\'égout', 'Water sewage', NULL, 'Waterafvoersystemen', 20, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2056, 'Séjour', 'Living room', NULL, 'Woonkamer', 2, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2057, 'Chenil', 'Kennel', NULL, 'Hondehok', 3, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2075, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 70, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2123, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 70, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2136, 'Moquette', 'Carpet', NULL, 'Kamerbreed tapijt', 53, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2137, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 70, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2140, 'Cave à provision', 'Provision Cellar', NULL, 'Provisiekamer', 76, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2143, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 70, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2146, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 70, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2148, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 70, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2151, 'Loggia', 'Loggia', NULL, 'Loggia', 70, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2190, 'Salle(s) de Jeux', 'Playroom(s)', NULL, 'Speelzalen', 72, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2191, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 72, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2192, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 72, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2193, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 72, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2160, 'Salon', 'Lounge', NULL, 'Zitkamer', 70, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2144, 'Cuisine', 'Kitchen', NULL, 'Keuken', 70, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2154, 'Vestiaire', 'Dressing Room(s)', NULL, 'Kleedkamer', 70, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2155, 'Bar', 'Bar', NULL, 'Saloon', 70, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2156, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 70, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2150, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 70, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2142, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 70, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2083, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 70, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2152, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 70, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2149, 'Office', 'Office', NULL, 'Zetel', 70, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2157, 'Palier', 'Level', NULL, 'Trapportaal', 70, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2159, 'Réception', 'Reception', NULL, 'Receptie', 70, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2158, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 70, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2147, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 70, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2074, 'Salle(s) de Jeux', 'Playroom(s)', NULL, 'Speelzalen', 70, 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2153, 'Salon TV', 'TV Room', NULL, 'TV kamer', 70, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2179, 'Palier', 'Level', NULL, 'Trapportaal', 71, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2170, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 71, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2168, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 71, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2184, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 71, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2182, 'Salon', 'Lounge', NULL, 'Zitkamer', 71, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2183, 'Séjour', 'Living Room', NULL, 'Woonkamer', 71, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2162, 'Salle(s) de Jeux', 'Playroom(s)', NULL, 'Speelzalen', 71, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2187, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 71, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2166, 'Cuisine', 'Kitchen', NULL, 'Keuken', 71, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2173, 'Loggia', 'Loggia', NULL, 'Loggia', 71, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2189, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 71, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2186, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 71, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2163, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 71, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2177, 'Bar', 'Bar', NULL, 'Saloon', 71, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2185, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 71, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2172, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 71, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2178, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 71, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2188, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 71, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2165, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 71, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2171, 'Office', 'Office', NULL, 'Zetel', 71, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2181, 'Réception', 'Reception', NULL, 'Receptie', 71, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2180, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 71, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2169, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 71, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2175, 'Salon TV', 'TV Room', NULL, 'TV kamer', 71, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2176, 'Vestiaire', 'Cloakroom', NULL, 'Kleedkamer', 71, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2164, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 71, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2194, 'Cuisine', 'Kitchen', NULL, 'Keuken', 72, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2196, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 72, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2197, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 72, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2198, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 72, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2199, 'Office', 'Office', NULL, 'Zetel', 72, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2200, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 72, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2201, 'Loggia', 'Loggia', NULL, 'Loggia', 72, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2202, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 72, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2203, 'Salon TV', 'TV Room', NULL, 'TV kamer', 72, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2204, 'Vestiaire', 'Cloakroom', NULL, 'Kleedkamer', 72, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2205, 'Bar', 'Bar', NULL, 'Saloon', 72, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2206, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 72, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2207, 'Palier', 'Level', NULL, 'Trapportaal', 72, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2208, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 72, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2209, 'Réception', 'Reception', NULL, 'Receptie', 72, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2210, 'Salon', 'Lounge', NULL, 'Zitkamer', 72, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2211, 'Séjour', 'Living Room', NULL, 'Woonkamer', 72, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2212, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 72, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2213, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 72, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2214, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 72, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2215, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 72, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2216, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 72, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2217, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 72, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2218, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 73, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2219, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 73, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2220, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 73, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2221, 'Cuisine', 'Kitchen', NULL, 'Keuken', 73, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2223, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 73, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2224, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 73, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2225, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 73, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2226, 'Office', 'Office', NULL, 'Zetel', 73, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2227, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 73, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2228, 'Loggia', 'Loggia', NULL, 'Loggia', 73, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2229, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 73, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2230, 'Salon TV', 'TV Room', NULL, 'TV kamer', 73, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2231, 'Vestiaire', 'Cloakroom', NULL, 'Kleedkamer', 73, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2232, 'Bar', 'Bar', NULL, 'Saloon', 73, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2233, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 73, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2234, 'Palier(s)', 'Level(s)', NULL, 'Trapportaal', 73, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2235, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 73, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2236, 'Réception', 'Reception', NULL, 'Receptie', 73, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2237, 'Salon', 'Lounge', NULL, 'Zitkamer', 73, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2238, 'Séjour', 'Living Room', NULL, 'Woonkamer', 73, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2239, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 73, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2240, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 73, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2241, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 73, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2242, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 73, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2243, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 73, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2244, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 73, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2245, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 74, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2246, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 74, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2247, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 74, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2248, 'Cuisine(s)', 'Kitchen(s)', NULL, 'Keuken', 74, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2250, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 74, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2251, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 74, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2252, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 74, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2253, 'Office', 'Office', NULL, 'Zetel', 74, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2254, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 74, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2255, 'Loggia', 'Loggia', NULL, 'Loggia', 74, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2256, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 74, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2257, 'Salon TV', 'TV Room', NULL, 'TV kamer', 74, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2258, 'Vestiaire(s)', 'Cloakroom(s)', NULL, 'Kleedkamers', 74, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2259, 'Bar', 'Bar', NULL, 'Saloon', 74, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2260, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 74, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2261, 'Palier', 'Level', NULL, 'Trapportaal', 74, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2262, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 74, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2263, 'Réception', 'Reception', NULL, 'Receptie', 74, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2264, 'Salon(s)', 'Lounge(s)', NULL, 'Zitkamer(s)', 74, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2265, 'Séjour', 'Living room', NULL, 'Woonkamer', 74, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2266, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 74, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2267, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 74, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2268, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 74, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2269, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 74, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2270, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 74, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2271, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 74, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2272, 'Salle(s) de Jeux', 'Playroom(s)', NULL, 'Speelzalen', 75, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2273, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 75, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2274, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 75, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2275, 'Salle de Jeux', 'Playroom', NULL, 'Speelzaal', 75, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2276, 'Cuisine', 'Kitchen', NULL, 'Keuken', 75, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2278, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 75, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2279, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 75, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2280, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 75, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2281, 'Office', 'Office', NULL, 'Zetel', 75, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2282, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 75, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2283, 'Loggia', 'Loggia', NULL, 'Loggia', 75, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2284, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 75, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2285, 'Salon TV', 'TV Room', NULL, 'TV kamer', 75, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2286, 'Vestiaire', 'Cloakroom', NULL, 'Kleedkamer', 75, 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2287, 'Bar', 'Bar', NULL, 'Saloon', 75, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2288, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 75, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2289, 'Palier', 'Level', NULL, 'Trapportaal', 75, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2290, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 75, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2291, 'Réception(s)', 'Reception Room(s)', NULL, 'Recepties', 75, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2292, 'Salon(s)', 'Lounge(s)', NULL, 'Zitkamer(s)', 75, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2293, 'Séjour', 'Living Room', NULL, 'Woonkamer', 75, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2294, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 75, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2295, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 75, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2296, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 75, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2297, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 75, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2298, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 75, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2299, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 75, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2300, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 76, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2301, 'Grenier aménagé', 'Converted Attic', NULL, 'Ingericht zolder', 76, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2303, 'Cuisine(s)', 'Kitchen(s)', NULL, 'Keuken', 76, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2306, 'Salle(s) de douche(s)', 'Shower Room(s)', NULL, 'Doucheruimtes', 76, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2308, 'Office', 'Office', NULL, 'Zetel', 76, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2309, 'Espace petit déjeuner', 'Breakfast Area', NULL, 'Ontbijt ruimte', 76, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2310, 'Loggia', 'Loggia', NULL, 'Loggia', 76, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2311, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 76, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2312, 'Salon TV', 'TV Room', NULL, 'TV kamer', 76, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2313, 'Vestiaire', 'Cloakroom', NULL, 'Kleedkamer', 76, 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2314, 'Bar', 'Bar', NULL, 'Saloon', 76, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2315, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 76, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2316, 'Palier', 'Level', NULL, 'Trapportaal', 76, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2317, 'Salle de bain pour handicapé', 'Bathroom for disabled', NULL, 'Badkamer voor mindervaliden', 76, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2318, 'Réception(s)', 'Reception Room(s)', NULL, 'Recepties', 76, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2319, 'Salon(s)', 'Lounge(s)', NULL, 'Zitkamer(s)', 76, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2320, 'Séjour(s)', 'Living Room(s)', NULL, 'Woonkamers', 76, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2322, 'Lingerie(s)', 'Laundry', NULL, 'Linenkamers', 76, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2323, 'Veranda(s)', 'Veranda(s)', NULL, 'Veranda(s)', 76, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2324, 'Bureau(x)', 'Study Room(s)', NULL, 'Kantoren', 76, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2325, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 76, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2326, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 76, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2327, 'Cave', 'Cellar', NULL, 'Kelder', 76, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2302, 'Salle(s) de jeux', 'Playroom(s)', NULL, 'Speelzalen', 76, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2305, 'Salle(s) de bains', 'Bathroom(s)', NULL, 'Badkamer(s)', 76, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2307, 'Chambre(s)', 'Bedroom(s)', NULL, 'Slaapkamer', 76, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2328, 'Cave à vin', 'Wine Cellar', NULL, 'Wijnkelder', 76, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2329, 'Bois-Metal', 'Wood and Metal', NULL, 'Hout-metaal', 68, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2380, 'Fosse septique', 'Septic Tank', NULL, '', 20, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2381, 'WC', 'WC', NULL, '', 70, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2382, 'Bois-Aluminium', 'Wood and Aluminium', NULL, '', 68, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3480, 'Consommation énergétique (en énergie primaire)', 'Energy consumption', NULL, 'Consommation énergétique (en énergie primaire)', 155, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'KWHep/m²an'),
(3481, 'Emission de gaz à effet de serre', 'Greenhouse gases emission', NULL, 'Emission de gaz à effet de serre', 155, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Kgco2/m²an'),
(3490, 'Prix en baisse', 'Price reduced', NULL, '', 100, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3520, 'Accès mer', 'Sea access', NULL, 'Toegang tot de zee', 1, 40, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3516, 'Béton', 'Concrete', NULL, 'Beton', 66, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3517, 'Terrain en pleine propriété', 'Freehold', NULL, 'Vrij eigendom', 1, 41, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3485, 'Bien non soumis au DPE', 'Property not subject to EPC', NULL, 'Bien non soumis au DPE', 155, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3483, 'Méthode de calcul: COMFIE-DPE', 'Calculation method: COMFIE-EPC', NULL, 'Méthode de calcul: COMFIE-DPE', 155, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3484, 'Méthode de calcul: DEL6-DPE', 'Calculation method: DEL6-EPC', NULL, 'Méthode de calcul: DEL6-DPE', 155, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3514, 'Capacité d\'accueil', 'Max occupancy', NULL, 'Hosten capaciteit', 157, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3515, 'Nombre de jours min. de réservation', 'Min. rental period (days)', NULL, 'Min. huurperiode (dagen)', 157, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(2383, 'Loisirs', 'Recreation', NULL, '', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `detail` (`ndetail`, `ldetailfr`, `ldetailen`, `ldetailde`, `ldetailnl`, `ntypdetail`, `nordre`, `binternet`, `ldetailes`, `ldetailit`, `ldetailsk`, `ldetailcs`, `ldetailru`, `ldetailzh`, `cunite`) VALUES
(2384, 'Plat', 'Flat', NULL, '', 1, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2385, 'Viabilisé', 'Serviced', NULL, '', 1, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2386, 'Borné', 'Marked boundaries', NULL, '', 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2387, 'Tout à l\'Egout', 'Water sewage', NULL, '', 1, 31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2390, 'Toilettes sèches', 'Dry toilets', NULL, '', 20, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2400, 'Eolienne', 'Wind Mill', NULL, '', 20, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2406, 'Chaudière', 'Boiler', NULL, '', 115, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2407, 'Chauffeau électrique', 'Electric water heater', NULL, '', 115, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2408, 'Chauffeau gaz', 'Gas water heater', NULL, '', 115, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2409, 'Géothermie', 'Geothermal', NULL, '', 115, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2410, 'Panneaux Solaires', 'Solar Panels', NULL, '', 115, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2411, 'Eolienne', 'Wind Mill', NULL, '', 115, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2576, 'Fibre de coco', 'Coconut Fibre', NULL, '', 53, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2470, 'WC', 'WC', NULL, '', 123, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2471, 'Bar', 'Bar', NULL, '', 123, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2472, 'Dressing', 'Dressing Room', NULL, 'Kledingkamer', 123, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2473, 'Lingerie', 'Laundry', NULL, '', 123, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2474, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 123, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2475, 'Office', 'Office', NULL, '', 123, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2476, 'Pallier', 'Level', NULL, '', 123, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2477, 'Réception', 'Reception', NULL, '', 123, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2478, 'Salle(s) de bain pour handicapé', 'Bathroom for disabled', NULL, '', 123, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2479, 'Salle(s) de douche', 'Shower room(s)', NULL, '', 123, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2480, 'Salle(s) de jeux', 'Playroom(s)', NULL, '', 123, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2481, 'Salon de TV', 'TV Room', NULL, '', 123, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2482, 'Appartement', 'Apartment', NULL, '', 69, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2483, 'Studio', 'Studio', NULL, '', 69, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2484, 'Maison d\'amis', 'Guest House', NULL, '', 69, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2485, 'Pièces annexes', 'Annexes', NULL, '', 69, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2486, 'Appartement d\'amis', 'Guest Apartment', NULL, '', 69, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2487, 'Appartement de gardien', 'House keeper\'s Apartment', NULL, '', 69, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2488, 'Pièce(s)', 'Room(s)', NULL, '', 69, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2489, 'Gîte 1', 'Cottage 1', NULL, '', 69, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2490, 'Gîte 2', 'Cottage 2', NULL, '', 69, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2504, 'Façade', 'Facade', NULL, '', 1, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2505, 'Vue', 'View', NULL, '', 1, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2506, 'Aspect', 'Aspect', NULL, '', 1, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2507, 'C.O.S', 'C.O.S', NULL, '', 1, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2508, 'En Pente', 'Slope', NULL, '', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2509, 'Fosse Septique', 'Septic Tank', NULL, '', 1, 32, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2512, 'Pierre', 'Stone', NULL, '', 125, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2513, 'Aggloméré', 'Concrete Blocks', NULL, '', 125, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2440, 'Appartement', 'Apartment', NULL, '', 121, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2441, 'Chambre(s)', 'Bedroom(s)', NULL, '', 121, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2442, 'Salle(s) de bain', 'Bathroom(s)', NULL, '', 121, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2443, 'Salle(s) de douche', 'Shower Room(s)', NULL, '', 121, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2444, 'Cuisine', 'Kitchen', NULL, '', 121, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2445, 'Séjour', 'Living Room', NULL, '', 121, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2446, 'WC', 'WC', NULL, '', 121, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2447, 'Pièce(s)', 'Room(s)', NULL, '', 121, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2454, 'Aménageable', 'Convertible', NULL, '', 75, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2456, 'Hall d\'entrée', 'Entry Hall', NULL, '', 123, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2457, 'Vestiaire', 'Cloakroom', NULL, '', 123, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2458, 'Séjour', 'Living room', NULL, '', 123, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2459, 'Salon', 'Lounge', NULL, '', 123, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2460, 'Salle à manger', 'Dining Room', NULL, '', 123, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2461, 'Cuisine', 'Kitchen', NULL, '', 123, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2462, 'Arrière-cuisine', 'Scullery', NULL, '', 123, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2463, 'Bureau(x)', 'Study Room(s)', NULL, '', 123, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2464, 'Salle de jeux', 'Playroom', NULL, '', 123, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2465, 'Chambres(s)', 'Bedroom(s)', NULL, '', 123, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2466, 'Salle(s) de bain', 'Bathroom(s)', NULL, '', 123, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2467, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, '', 123, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2468, 'Loggia', 'Loggia', NULL, 'Loggia', 123, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2469, 'Véranda', 'Véranda', NULL, '', 123, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2510, 'Constructible', 'Building Land', NULL, '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2511, 'Demande CU en cours', 'Urbanism planning certificate in progress', NULL, '', 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2514, 'Brique', 'Brick', NULL, '', 125, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2515, 'Tuiles', 'Tiles', NULL, '', 125, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2516, 'Bois', 'Wood', NULL, '', 125, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2517, 'Béton', 'Concrete', NULL, '', 125, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2518, 'Ossature bois', 'Wooden Frame Work', NULL, '', 125, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2519, 'Pré-fabriquée', 'Prefabricated', NULL, '', 125, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2520, 'Ecole Primaire', 'Elementary School', NULL, '', 4, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2521, 'Ecole Maternelle', 'Nursery school', NULL, '', 4, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2522, 'Collège', 'Secondary School', NULL, '', 4, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2523, 'Lycée', 'Lycée', NULL, '', 4, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2524, 'Ramassage Scolaire', 'School Bus Service', NULL, '', 4, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2530, 'Compteur Eau', 'Water meter', NULL, '', 127, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2531, 'Compteur Electricité', 'Electricity Meter', NULL, '', 127, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2532, 'Autre(s)', 'Other(s)', NULL, '', 127, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2533, 'Eau à Raccorder', 'Water to connect', NULL, '', 127, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2534, 'EDF à Raccorder', 'Electricity to connect', NULL, '', 127, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2535, 'Eau du Puits', 'Well water', NULL, '', 127, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2536, 'Eau de Source', 'Spring water', NULL, '', 127, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2537, 'ADSL', 'ADSL', NULL, '', 127, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2538, 'Hot Spot Wifi', 'Wifi Hot Spot', NULL, '', 127, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2539, 'Gaz de Ville', 'Town Gas', NULL, '', 127, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2540, 'Tout à l\'Egout', 'Water sewage', NULL, '', 127, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2541, 'Fosse Septique', 'Septic Tank', NULL, '', 127, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2542, 'Câble', 'Cable', NULL, '', 127, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2551, 'Loyer', 'Rent', NULL, '', 14, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2553, 'Sèche-Linge', 'Dryer', NULL, '', 55, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2554, 'Stores Electriques', 'Electric shutters', NULL, '', 68, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2555, 'Volets', 'Shuters', NULL, '', 68, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2556, 'Digicode', 'Digicode', NULL, '', 51, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2557, 'Surveillance Vidéo', 'Video surveillance', NULL, '', 51, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2558, 'Stores Electrique', 'Electric Shutters', NULL, '', 51, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2572, 'Bio-climatique', 'Bio-climatic', NULL, '', 125, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2573, 'Ecologique', 'Ecological', NULL, '', 125, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2574, 'Panneaux Solaires', 'Solar Panels', NULL, '', 20, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2575, 'Agricole', 'Agricultural', NULL, '', 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2577, 'Entrée', 'Hall', NULL, '', 132, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2578, 'Chambre(s)', 'Bedroom(s)', NULL, '', 132, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2579, 'Salon', 'Lounge', NULL, '', 132, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2580, 'Salle à manger', 'Dining Room', NULL, '', 132, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2581, 'Cuisine', 'Kitchen', NULL, '', 132, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2582, 'Kitchenette', 'Kitchenette', NULL, '', 132, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2583, 'Salle(s) de bain', 'Bathroom(s)', NULL, '', 132, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2584, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, '', 132, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2585, 'Dressing(s)', 'Dressing Room', NULL, 'Kledingkamer', 132, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2525, 'Garage(s)', 'Garage(s)', NULL, '', 126, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2526, 'En sous sol', 'At basement Level', NULL, '', 126, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2527, 'Extérieur(s)', 'Exterior', NULL, '', 126, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2586, 'Bureau(x)', 'Study Room(s)', NULL, '', 132, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2587, 'Débarras', 'Storage Room', NULL, '', 132, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2588, 'Grenier', 'Attic', NULL, '', 132, 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2589, 'Sous-sol', 'Basement', NULL, '', 132, 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2590, 'Cave', 'Cellar', NULL, '', 132, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2591, 'Préau', 'Covered Area', NULL, '', 132, 31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2592, 'Concierge/Gardien', 'Caretaker', NULL, '', 132, 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2593, 'Ascenseur', 'Lift', NULL, '', 132, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2594, 'Digicode', 'Digicode', NULL, '', 132, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2595, 'Situation dans l\'immeuble', 'Location within the building', NULL, '', 132, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2596, 'Quartier', 'Neighbourhood', NULL, '', 132, 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2597, 'Métro', 'Subway', NULL, '', 132, 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2598, 'Station', 'Station', NULL, '', 132, 38, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2599, 'RER', 'RER', NULL, '', 132, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2600, 'Vue sur cour', 'Courtyard View', NULL, '', 132, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2601, 'Vue sur rue', 'Street View', NULL, '', 132, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2602, 'Chauffage électrique', 'Electric Heating', NULL, '', 132, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2603, 'Chauffe eau électrique personnel', 'Individual Electric water heater', NULL, '', 132, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2604, 'Chauffage central', 'Central Heating', NULL, '', 132, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2605, 'Chauffe eau central', 'Central water heater', NULL, '', 132, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2606, 'Parc', 'Park', NULL, '', 4, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2607, 'Marché plein air', 'Open-air  Market', NULL, '', 4, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2608, 'Laverie', 'Launderette', NULL, '', 4, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2609, 'Kiosque à journaux', 'Newspaper kiosk', NULL, '', 4, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2610, 'Club de gym', 'Gym Club', NULL, '', 4, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2611, 'Pharmacie', 'Chemist', NULL, '', 4, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2612, 'Interphone', 'Interphone', NULL, '', 132, 32, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2613, 'Epicerie', 'Grocery', NULL, '', 4, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2614, 'Chauffage au gaz', 'Gas Heating', NULL, '', 132, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2615, 'Chauffe eau personnel au gaz', 'Individual Gas water heater', NULL, '', 132, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2616, 'Porte blindée', 'Armoured Door', NULL, '', 132, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2617, 'Terrasse', 'Terrace', NULL, '', 132, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2618, 'Placard(s)', 'Cupboard(s)', NULL, '', 132, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2619, 'Balcon', 'Balcony', NULL, '', 132, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2620, 'Jardin', 'Garden', NULL, '', 132, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2621, 'WC', 'WC', NULL, '', 132, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2622, 'Prairie', 'Meadow', NULL, '', 1, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2623, 'Séjour', 'Living Room', NULL, '', 132, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2680, 'Visite virtuelle', 'Virtual tours', NULL, '', 153, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2709, 'Pourcentage loué', 'Percentage rented', NULL, '', 14, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '%'),
(2720, 'Terrain de front', 'Foreground', NULL, '', 1, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2721, 'Terrain de fond', 'Background', NULL, '', 1, 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2723, 'Largeur du terrain à rue', 'Breadth of the land to street', NULL, '', 1, 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'm'),
(2724, 'Profondeur du terrain', 'Depth of land', NULL, '', 1, 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'm'),
(2728, 'Possibilité de raccordement électricité', 'Possibility to connect electricity', NULL, '', 1, 38, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2730, 'Obligation de construire', 'Obligation to build', NULL, '', 1, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2712, 'Rente mensuelle', 'Monthly Income', NULL, '', 151, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '€'),
(2713, 'Rente indexée', 'Indexed Annuity', NULL, '', 151, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2714, 'Rente réversible', 'Reversible Annuity', NULL, '', 151, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2715, 'Rente en pleine propriété', 'Freehold Annuity', NULL, '', 151, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2716, 'Nbr de têtes', 'No. of heads', NULL, '', 151, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2717, 'Age du vendeur 1', 'Age of seller 1', NULL, '', 151, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ans'),
(2718, 'Age du vendeur 2', 'Age of seller 2', NULL, '', 151, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ans'),
(2719, 'Durée maximale', 'Maximum duration', NULL, '', 151, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mois'),
(3631, 'Viager libre', 'Viager libre', NULL, 'Viager libre', 151, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'x'),
(3632, 'Viager occupé', 'Viager occupé', NULL, 'Viager occupé', 151, 101, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'x'),
(3633, 'Charges forfaitaires mensuelles', 'Charges forfaitaires mensuelles', NULL, 'Charges forfaitaires mensuelles', 151, 110, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'x'),
(3634, 'Charges prévis. mensuelles et régul. annuelle', 'Charges prévis. mensuelles et régul. annuelle', NULL, 'Charges prévis. mensuelles et régul. annuelle', 151, 111, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'x'),
(3635, 'Charges remboursées annuellement par locataire', 'Charges remboursées annuellement par locataire', NULL, 'Charges remboursées annuellement par locataire', 151, 112, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'x'),
(3580, 'Option à la une', '', NULL, '', 153, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2625, 'Obtenir certificat SAFER', 'Get SAFER certificate', NULL, '', 104, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2626, 'Préparer Promesse de Vente', 'Prepare provisional sale agreement', NULL, '', 133, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2627, 'Signature Promesse de Vente', 'Sign provisional sale agreement', NULL, '', 133, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2628, 'Préparer Compromis de Vente', 'Prepared signed offer', NULL, '', 133, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2629, 'Signer Compromis de Vente', 'Sign the offer', NULL, '', 133, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2630, 'Envoyer dossier complet au Notaire', 'Send complete file to notary', NULL, '', 133, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2631, 'Prendre RDV avec Notaire', 'Make an appointment with notary', NULL, '', 133, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2632, 'Communiquer RDV Acte Authentique', 'Share Authentic Act appointment', NULL, '', 133, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2633, 'Facturation Commission', 'Invoice commission', NULL, '', 133, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2634, 'Encaissement Commission', 'Collect commission', NULL, '', 133, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2635, 'Envoyer Rapport d\'Activité au Propriétaire', 'Send activity report to owner', NULL, '', 133, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2138, 'Hall d\'entrée', 'Entry Hall', NULL, 'Inkomhal', 70, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'm²'),
(3219498, 'Pièce hexagonale', '', NULL, '', 70, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3482, 'Méthode de calcul: 3CL-DPE', 'Calculation method: 3CL-EPC', NULL, 'Méthode de calcul: 3CL-DPE', 155, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(722886, 'Cuve à Fioul', '', NULL, '', 70, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'l'),
(2161, 'Séjour', 'Living Room', NULL, 'Woonkamer', 70, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2139, 'Salle à manger', 'Dining Room', NULL, 'Eetkamer', 70, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2141, 'Arrière-cuisine', 'Scullery', NULL, 'Achterkant keuken', 70, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(7716676, 'Dégagement', '', NULL, '', 71, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2174, 'Mezzanine', 'Mezzanine', NULL, 'Insteekkamer', 71, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3571, 'Nbre de lots', 'Nbre de lots', NULL, 'Nbre de lots', 170, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3572, 'Charges annuelles courantes (budget prévisionnel)', 'Charges annuelles courantes (budget prévisionnel)', NULL, 'Charges annuelles courantes (budget prévisionnel)', 170, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '€'),
(3573, 'Procéd. de sauvegarde - OUI', 'Procéd. de sauvegarde - OUI', NULL, 'Procéd. de sauvegarde - OUI', 170, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3574, 'Procéd. de sauvegarde - NON', 'Procéd. de sauvegarde - NON', NULL, 'Procéd. de sauvegarde - NON', 170, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3575, 'Procéd.: désignat° mandataire AD HOC', 'Procéd.: désignat° mandataire AD HOC', NULL, 'Procéd.: désignat° mandataire AD HOC', 170, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3576, 'Procéd.: désignat° administrateur provisoire', 'Procéd.: désignat° administrateur provisoire', NULL, 'Procéd.: désignat° administrateur provisoire', 170, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3577, 'Procéd.: désignat° expert', 'Procéd.: désignat° expert', NULL, 'Procéd.: désignat° expert', 170, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(3486, 'DPE vierge', 'DPE vierge', NULL, 'DPE vierge', 155, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(3570, 'Bien soumis au régime de copropriété', 'Bien soumis au régime de copropriété', NULL, 'Bien soumis au régime de copropriété', 170, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-'),
(525, 'Revenu locatif mensuel', 'Rental Income', NULL, 'Verhuren inkomen', 14, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(10402, 'double vitrage', '', NULL, '', 68, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(2321, 'Salle(s) d\'eau', 'Shower Room(s)', NULL, 'Waskamer', 76, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(10403, 'garage', '', NULL, '', 76, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(10404, 'atelier', '', NULL, '', 76, 31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(10405, 'buanderie', '', NULL, '', 76, 32, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
(10406, '', '', NULL, '', 76, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '');

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

--
-- Table structure for table `detailbien`
--

DROP TABLE IF EXISTS `detailbien`;
CREATE TABLE `detailbien` (
  `ndetailbien` int(11) NOT NULL,
  `ndetail` int(11) NOT NULL DEFAULT '0',
  `ldetailbienfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `nbien` int(11) NOT NULL DEFAULT '0',
  `lcommentfr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lcommenten` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lcommentde` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lcommentnl` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cagence` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `qnombre` int(11) DEFAULT '0',
  `lcommentes` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcommentit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcommentsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcommentcs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcommentru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcommentzh` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


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

--
-- Table structure for table `disponibilite`
--

DROP TABLE IF EXISTS `disponibilite`;
CREATE TABLE `disponibilite` (
  `ndisponibilite` int(11) NOT NULL,
  `ldisponibilitefr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibiliteen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibilitenl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibilitees` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibiliteit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibilitede` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibilitesk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibilitecs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibiliteru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ldisponibilitezh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `disponibilite`
--

INSERT INTO `disponibilite` (`ndisponibilite`, `ldisponibilitefr`, `ldisponibiliteen`, `ldisponibilitenl`, `ldisponibilitees`, `ldisponibiliteit`, `ldisponibilitede`, `ldisponibilitesk`, `ldisponibilitecs`, `ldisponibiliteru`, `ldisponibilitezh`) VALUES
(1, 'A l\'acte', '', '', '', '', '', '', '', '', ''),
(2, 'Après travaux', '', '', '', '', '', '', '', '', ''),
(3, 'Date à convenir', '', '', '', '', '', '', '', '', ''),
(4, 'Deux mois après compromis', '', '', '', '', '', '', '', '', ''),
(5, 'Fin de location', '', '', '', '', '', '', '', '', ''),
(0, 'Immédiate', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `email`
--

DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
  `nemail` int(255) NOT NULL,
  `cpolit` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `lnom` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lprenom` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ltel` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lsubject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lmessage` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ljsonpost` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ljsonget` longtext COLLATE utf8_unicode_ci NOT NULL,
  `lemailcustomer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lemailto` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lipfrom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `demail` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `environnement`
--

DROP TABLE IF EXISTS `environnement`;
CREATE TABLE `environnement` (
  `cenvironnement` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `lenvironnementfr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementnl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementes` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementde` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementsk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementcs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lenvironnementzh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `environnement`
--

INSERT INTO `environnement` (`cenvironnement`, `lenvironnementfr`, `lenvironnementen`, `lenvironnementnl`, `lenvironnementes`, `lenvironnementit`, `lenvironnementde`, `lenvironnementsk`, `lenvironnementcs`, `lenvironnementru`, `lenvironnementzh`) VALUES
('bois', 'Bois', '', '', '', '', '', '', '', '', ''),
('brg', 'Bourg', '', '', '', '', '', '', '', '', ''),
('cpis', 'Campagne isolée', '', '', '', '', '', '', '', '', ''),
('cpni', 'Campagne non-isolée', '', '', '', '', '', '', '', '', ''),
('cbrg', 'Centre bourg', '', '', '', '', '', '', '', '', ''),
('clos', 'Clos privé', '', '', '', '', '', '', '', '', ''),
('A', 'Residential Complex', '', '', '', '', '', '', '', '', ''),
('loti', 'Lotissement', '', '', '', '', '', '', '', '', ''),
('parc', 'Parc', '', '', '', '', '', '', '', '', ''),
('plag', 'Plage', '', '', '', '', '', '', '', '', ''),
('morc', 'Lacated in a morcellement', '', '', '', '', '', '', '', '', ''),
('urb', 'Urbain', '', '', '', '', '', '', '', '', ''),
('com', 'Zone commerciale', '', '', '', '', '', '', '', '', ''),
('res', 'Zone Résidentielle', '', '', '', '', '', '', '', '', ''),
('forêt', 'Forêt', '', '', '', '', '', '', '', '', ''),
('forÃªt', 'ForÃªt', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `etat`
--

DROP TABLE IF EXISTS `etat`;
CREATE TABLE `etat` (
  `cetat` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `letatfr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letaten` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatnl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letates` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatde` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatsk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatcs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `letatzh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `etat`
--

INSERT INTO `etat` (`cetat`, `letatfr`, `letaten`, `letatnl`, `letates`, `letatit`, `letatde`, `letatsk`, `letatcs`, `letatru`, `letatzh`) VALUES
('0', 'Non précisé', '', '', '', '', '', '', '', '', ''),
('---', 'A rénover entièrement', '', '', '', '', '', '', '', '', ''),
('--', 'A rénover', '', '', '', '', '', '', '', '', ''),
('-', 'A rafraîchir', '', '', '', '', '', '', '', '', ''),
('+', 'Bon', '', '', '', '', '', '', '', '', ''),
('++', 'Très bon', '', '', '', '', '', '', '', '', ''),
('+++', 'Excellent', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `gis`
--

DROP TABLE IF EXISTS `gis`;
CREATE TABLE `gis` (
  `cid` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `ctype` varchar(1) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `nlevel` int(11) DEFAULT NULL,
  `cinsee` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lnommaj` varchar(80) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lnommin` varchar(80) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `cidparent` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `larticlelong` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `larticle` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `cadditional1` varchar(25) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `cadditional2` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lcoordinates` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `llongitude` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `llatitude` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lwebsite` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lcp` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `laltitude` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `npopulation` int(11) DEFAULT NULL,
  `nbbiensregpol` int(11) DEFAULT NULL,
  `nbbienscdepartement` int(11) DEFAULT NULL,
  `nbbienscarrondissement` int(11) DEFAULT NULL,
  `nbbiensccanton` int(11) DEFAULT NULL,
  `nbbiensccommune` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `htmlpage`
--

DROP TABLE IF EXISTS `htmlpage`;
CREATE TABLE `htmlpage` (
  `clangue` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr',
  `ltitre` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusermod` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusercre` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nhtmlpage` int(11) NOT NULL,
  `nordre` int(20) DEFAULT NULL,
  `dcre` date DEFAULT NULL,
  `dmod` date DEFAULT NULL,
  `lcontent` longtext COLLATE utf8_unicode_ci,
  `nhtmlpageparent` int(11) NOT NULL DEFAULT '0',
  `lurl` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ctypmenu` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lsection` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lurlv4` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lfriendlyurl` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cagence` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lmetatitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lmetakey` text COLLATE utf8_unicode_ci,
  `lmetadesc` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `htmlpage2`
--

DROP TABLE IF EXISTS `htmlpage2`;
CREATE TABLE `htmlpage2` (
  `clangue` varchar(2) NOT NULL DEFAULT 'fr',
  `ltitre` varchar(100) DEFAULT NULL,
  `cusermod` varchar(10) DEFAULT NULL,
  `cusercre` varchar(10) DEFAULT NULL,
  `nhtmlpage` int(11) NOT NULL DEFAULT '1',
  `nordre` int(20) DEFAULT NULL,
  `dcre` date DEFAULT NULL,
  `dmod` date DEFAULT NULL,
  `lcontent` longtext,
  `nhtmlpageparent` int(11) NOT NULL DEFAULT '0',
  `lurl` varchar(200) DEFAULT NULL,
  `ctypmenu` varchar(25) DEFAULT NULL,
  `lsection` varchar(200) DEFAULT NULL,
  `lfriendlyurl` varchar(250) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `htmlpage_backup20190301164038`
--
-- --------------------------------------------------------

--
-- Table structure for table `langue`
--

DROP TABLE IF EXISTS `langue`;
CREATE TABLE `langue` (
  `clangue` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT 'fr',
  `llangue` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `laccueil` varchar(100) COLLATE utf8_bin DEFAULT 'Bienvenue sur notre site',
  `bweb` int(1) NOT NULL DEFAULT '0',
  `nhtmlpage` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `langue`
--

INSERT INTO `langue` (`clangue`, `llangue`, `laccueil`, `bweb`, `nhtmlpage`) VALUES
('cs', 'Tchèque', '', 0, 0),
('de', 'Allemand', '', 0, 0),
('en', 'Anglais', '', 0, 11202),
('es', 'Espagnol', '', 0, 0),
('fr', 'Français', '', 0, 10202),
('it', 'Italien', '', 0, 0),
('nl', 'Néerlandais', '', 0, 0),
('ru', 'Russe', '', 0, 0),
('sk', 'Slovaque', '', 0, 0),
('zh', 'Chinois', '', 0, 0);

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

--
-- Table structure for table `lexique`
--

DROP TABLE IF EXISTS `lexique`;
CREATE TABLE `lexique` (
  `cregion` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ind',
  `ctypmandat` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ind',
  `ctyp` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `clangue` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr',
  `lgeo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `llocalite` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lgeourl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lregion` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lregionurl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lregionmeta` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lregionmetaurl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypmandat` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypmandaturl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypmeta` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypmetaurl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltyp` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypurl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qtotalbiens` bigint(21) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `mails`
--

DROP TABLE IF EXISTS `mails`;
CREATE TABLE `mails` (
  `cpolit` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nmails` int(255) NOT NULL,
  `lnom` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lprenom` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lcontent` longtext COLLATE utf8_unicode_ci NOT NULL,
  `lemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ltel` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `dmail` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `membre`
--

DROP TABLE IF EXISTS `membre`;
CREATE TABLE `membre` (
  `nmembre` int(255) NOT NULL,
  `lprenom` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnom` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ladr` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnumadr` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lcp` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `llocalite` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltel` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lemail` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lpassword` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bisactif` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `natmandat`
--

DROP TABLE IF EXISTS `natmandat`;
CREATE TABLE `natmandat` (
  `nnatmandat` int(11) NOT NULL,
  `lnatmandatfr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandaten` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatnl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandates` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatde` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatsk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatcs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnatmandatzh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `natmandat`
--

INSERT INTO `natmandat` (`nnatmandat`, `lnatmandatfr`, `lnatmandaten`, `lnatmandatnl`, `lnatmandates`, `lnatmandatit`, `lnatmandatde`, `lnatmandatsk`, `lnatmandatcs`, `lnatmandatru`, `lnatmandatzh`) VALUES
(0, 'Aucun', '', '', '', '', '', '', '', '', ''),
(4, 'Co-exclusif', '', '', '', '', '', '', '', '', ''),
(3, 'Collaboration', '', '', '', '', '', '', '', '', ''),
(1, 'Exclusif', '', '', '', '', '', '', '', '', ''),
(2, 'Non-exclusif', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `naturebien`
--

DROP TABLE IF EXISTS `naturebien`;
CREATE TABLE `naturebien` (
  `cnaturebien` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `lnaturebienfr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebienen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebiennl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebienes` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebienit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebiende` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebiensk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebiencs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebienru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnaturebienzh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `naturebien`
--

INSERT INTO `naturebien` (`cnaturebien`, `lnaturebienfr`, `lnaturebienen`, `lnaturebiennl`, `lnaturebienes`, `lnaturebienit`, `lnaturebiende`, `lnaturebiensk`, `lnaturebiencs`, `lnaturebienru`, `lnaturebienzh`) VALUES
('bur', 'Bureaux', '', '', '', '', '', '', '', '', ''),
('com', 'Commerciale', '', '', '', '', '', '', '', '', ''),
('ind', 'Industriel', '', '', '', '', '', '', '', '', ''),
('res', 'Résidentiel', '', '', '', '', '', '', '', '', ''),
('vac', 'Vacances', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `nnews` int(255) NOT NULL,
  `ltitre` longtext COLLATE utf8_unicode_ci,
  `lcontent` longtext COLLATE utf8_unicode_ci,
  `lprenom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dpub` date DEFAULT NULL,
  `clangue` varchar(2) COLLATE utf8_unicode_ci DEFAULT 'fr',
  `bpub` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `originebien`;
CREATE TABLE `originebien` (
  `coriginebien` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `loriginebienfr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebienen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebiennl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebienes` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebienit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebiende` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebiensk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebiencs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebienru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `loriginebienzh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `originebien`
--

--
-- Table structure for table `pays`
--

DROP TABLE IF EXISTS `pays`;
CREATE TABLE `pays` (
  `cisopays` varchar(3) COLLATE utf8_bin NOT NULL DEFAULT '',
  `pays` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `devise` varchar(10) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `pdf`
--

DROP TABLE IF EXISTS `pdf`;
CREATE TABLE `pdf` (
  `npdf` int(11) NOT NULL DEFAULT '0',
  `ltitre` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `sfilename` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `nbien` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `photo`
--

DROP TABLE IF EXISTS `photo`;
CREATE TABLE `photo` (
  `nphoto` int(11) NOT NULL DEFAULT '0',
  `nbien` int(11) DEFAULT '0',
  `cagence` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ltitrefr` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `ltitreen` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `ltitrenl` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `ltitrede` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescfr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescen` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescde` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescnl` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `sfilename` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `nwidth` int(11) DEFAULT NULL,
  `nheight` int(11) DEFAULT NULL,
  `nordre` int(4) DEFAULT NULL,
  `bweb` int(11) DEFAULT NULL,
  `nangle` int(11) NOT NULL DEFAULT '0',
  `lshortdesces` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescit` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescsk` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdesccs` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdescru` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lshortdesczh` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `bexportweb` int(11) DEFAULT NULL,
  `dmod` datetime DEFAULT NULL,
  `dcre` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `photo`
--
-- --------------------------------------------------------

--
-- Table structure for table `polit`
--

DROP TABLE IF EXISTS `polit`;
CREATE TABLE `polit` (
  `cpolit` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lpolitfr` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `lpoliten` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `lpolitnl` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `lpolitde` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `lpolites` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpolitit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpolitsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpolitcs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpolitru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpolitzh` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltitrees` text COLLATE utf8_bin,
  `lkeyes` text COLLATE utf8_bin,
  `ldesces` longtext COLLATE utf8_bin,
  `ltitreit` text COLLATE utf8_bin,
  `lkeyit` text COLLATE utf8_bin,
  `ldescit` longtext COLLATE utf8_bin,
  `ltitresk` text COLLATE utf8_bin,
  `lkeysk` text COLLATE utf8_bin,
  `ldescsk` longtext COLLATE utf8_bin,
  `ltitrecs` text COLLATE utf8_bin,
  `lkeycs` text COLLATE utf8_bin,
  `ldesccs` longtext COLLATE utf8_bin,
  `ltitreru` text COLLATE utf8_bin,
  `lkeyru` text COLLATE utf8_bin,
  `ldescru` longtext COLLATE utf8_bin,
  `ltitrezh` text COLLATE utf8_bin,
  `lkeyzh` text COLLATE utf8_bin,
  `ldesczh` longtext COLLATE utf8_bin
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `polit`
--

INSERT INTO `polit` (`cpolit`, `lpolitfr`, `lpoliten`, `lpolitnl`, `lpolitde`, `lpolites`, `lpolitit`, `lpolitsk`, `lpolitcs`, `lpolitru`, `lpolitzh`, `ltitrees`, `lkeyes`, `ldesces`, `ltitreit`, `lkeyit`, `ldescit`, `ltitresk`, `lkeysk`, `ldescsk`, `ltitrecs`, `lkeycs`, `ldesccs`, `ltitreru`, `lkeyru`, `ldescru`, `ltitrezh`, `lkeyzh`, `ldesczh`) VALUES
('Indivi', 'Indivision', 'Indivision', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Sucess', 'Succession', 'Succession', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mr & Mlle', 'Mr et Melle', 'Mr & Miss', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mr & Mme', 'Monsieur et Madame', 'Mr & Mrs', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mr', 'Monsieur', 'Mr', 'Mijneer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mtr', 'Maître', 'Master', 'Meester', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mme', 'Madame', 'Mrs', 'Mevrouw', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mlle', 'Mademoiselle', 'Miss', 'Mevrouw', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `preference`
--

DROP TABLE IF EXISTS `preference`;
CREATE TABLE `preference` (
  `ndbversion` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL DEFAULT '0',
  `dlastphotosync` datetime DEFAULT NULL,
  `dlastimport` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `preference`
--

INSERT INTO `preference` (`ndbversion`, `id`, `dlastphotosync`, `dlastimport`) VALUES
(75, 0, NULL, '2019-08-18 07:34:47');

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

--
-- Table structure for table `prospect`
--

DROP TABLE IF EXISTS `prospect`;
CREATE TABLE `prospect` (
  `lnom` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lprenom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lnomsociete` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lemail` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lpassword` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `nprospect` int(11) NOT NULL DEFAULT '0',
  `ltel` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltel2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lgsm` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `dcre` datetime DEFAULT NULL,
  `ladr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcp` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `llocalite` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cisopays` varchar(3) COLLATE utf8_bin DEFAULT NULL,
  `ncategorie` int(11) DEFAULT NULL,
  `cagence` varchar(10) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `prospect`
--
-- --------------------------------------------------------

--
-- Table structure for table `prospectbien`
--

DROP TABLE IF EXISTS `prospectbien`;
CREATE TABLE `prospectbien` (
  `nrelation` int(11) NOT NULL DEFAULT '0',
  `nprospect` int(11) NOT NULL DEFAULT '0',
  `nbien` int(11) NOT NULL DEFAULT '0',
  `ntyprelation` int(11) NOT NULL DEFAULT '0',
  `ddebut` datetime DEFAULT NULL,
  `dfin` datetime DEFAULT NULL,
  `lrem` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lusername` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `bannulation` int(11) DEFAULT NULL,
  `bconfirmed` int(11) DEFAULT NULL,
  `dfinpublication` datetime DEFAULT NULL,
  `lvisite` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `prospectbien`
--

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

--
-- Table structure for table `region`
--

DROP TABLE IF EXISTS `region`;
CREATE TABLE `region` (
  `cregion` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lregionfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionde` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `qtotalbiens` int(11) DEFAULT NULL,
  `cregionmeta` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'ind',
  `lregiones` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregioncs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionzh` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lcp` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `llocalite` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `mlatitude` double DEFAULT NULL,
  `mlongitude` double DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `region`
--

INSERT INTO `region` (`cregion`, `lregionfr`, `lregionen`, `lregionde`, `lregionnl`, `qtotalbiens`, `cregionmeta`, `lregiones`, `lregionit`, `lregionsk`, `lregioncs`, `lregionru`, `lregionzh`, `lcp`, `llocalite`, `mlatitude`, `mlongitude`) VALUES
('05', 'Bretagne', 'Bretagne', NULL, 'Bretagne', 17, 'ctro', NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL),
('06', 'Centre', 'Centre', NULL, 'Centre', 1, 'ctro', NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL);

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

--
-- Table structure for table `regionmeta`
--

DROP TABLE IF EXISTS `regionmeta`;
CREATE TABLE `regionmeta` (
  `cregionmeta` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lregionmetafr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetaen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetade` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetanl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `qtotalbiens` int(11) DEFAULT NULL,
  `lregionmetaes` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetait` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetask` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetacs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetaru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lregionmetazh` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `regionmeta`
--

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

--
-- Table structure for table `style`
--

DROP TABLE IF EXISTS `style`;
CREATE TABLE `style` (
  `cstyle` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `lstylefr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstyleen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstylenl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstylees` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstyleit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstylede` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstylesk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstylecs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstyleru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lstylezh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `style`
--

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

--
-- Table structure for table `taux`
--

DROP TABLE IF EXISTS `taux`;
CREATE TABLE `taux` (
  `cdevise` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `mtaux` double(22,12) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taux`
--

INSERT INTO `taux` (`cdevise`, `mtaux`) VALUES
('BEF', 40.339900000000),
('DEM', 1.955830000000),
('EUR', 1.000000000000),
('FRF', 6.559570000000),
('LIV', 0.800000000000),
('LUF', 40.339900000000),
('NLG', 2.203710000000),
('USD', 2.000000000000),
('MUR', 40.000000000000),
('KES', 109.916000000000);

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

--
-- Table structure for table `trancheprix`
--

DROP TABLE IF EXISTS `trancheprix`;
CREATE TABLE `trancheprix` (
  `ntrancheprix` int(11) DEFAULT NULL,
  `mmin` int(11) DEFAULT NULL,
  `mmax` int(11) DEFAULT NULL,
  `ctypmandat` char(8) COLLATE utf8_bin DEFAULT NULL,
  `cusercre` char(50) COLLATE utf8_bin DEFAULT NULL,
  `dcre` datetime DEFAULT NULL,
  `cusermod` char(50) COLLATE utf8_bin DEFAULT NULL,
  `dmod` datetime DEFAULT NULL,
  `ltrancheprix` char(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `typ`
--

DROP TABLE IF EXISTS `typ`;
CREATE TABLE `typ` (
  `ctyp` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ltypfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypde` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `qtotalbiens` int(11) DEFAULT '0',
  `ctypmeta` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `ltypes` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypcs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypzh` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `typ`
--

INSERT INTO `typ` (`ctyp`, `ltypfr`, `ltypen`, `ltypde`, `ltypnl`, `qtotalbiens`, `ctypmeta`, `ltypes`, `ltypit`, `ltypsk`, `ltypcs`, `ltypru`, `ltypzh`) VALUES
('ma', 'Maison', 'House', NULL, 'Huis', 13, 'mai', NULL, NULL, NULL, NULL, NULL, NULL),
('manc', 'Maison ancienne', 'Old house', NULL, 'Oud huis', 2, 'mai', NULL, NULL, NULL, NULL, NULL, NULL),
('ter', 'Terrain à batir', 'Building Land', NULL, 'Bouwgrond', 3, 'terr', NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `typchauf`
--

DROP TABLE IF EXISTS `typchauf`;
CREATE TABLE `typchauf` (
  `cchauf` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `lchauffr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufnl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufes` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufde` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufsk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufcs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lchaufzh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `typchauf`
--

INSERT INTO `typchauf` (`cchauf`, `lchauffr`, `lchaufen`, `lchaufnl`, `lchaufes`, `lchaufit`, `lchaufde`, `lchaufsk`, `lchaufcs`, `lchaufru`, `lchaufzh`) VALUES
('-', 'Aucun', '', '', '', '', '', '', '', '', ''),
('BOIS', 'Bois', '', '', '', '', '', '', '', '', ''),
('BF', 'Bois et Fuel', '', '', '', '', '', '', '', '', ''),
('CHA', 'Charbon', '', '', '', '', '', '', '', '', ''),
('COL', 'Collectif', '', '', '', '', '', '', '', '', ''),
('ELEC', 'Electricité', '', '', '', '', '', '', '', '', ''),
('FUEL', 'Fuel', '', '', '', '', '', '', '', '', ''),
('FG', 'Fuel et Gaz', '', '', '', '', '', '', '', '', ''),
('GAZ', 'Gaz', '', '', '', '', '', '', '', '', ''),
('INS', 'Insert', '', '', '', '', '', '', '', '', ''),
('nd', 'Non défini', '', '', '', '', '', '', '', '', ''),
('PC', 'Pompe à chaleur', '', '', '', '', '', '', '', '', ''),
('SOL', 'Solaire', '', '', '', '', '', '', '', '', ''),
('Gaz+ball', 'Gaz ,ballon inclus', '', '', '', '', '', '', '', '', ''),
('BE', 'Bois et Electricité', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `typcuisine`
--

DROP TABLE IF EXISTS `typcuisine`;
CREATE TABLE `typcuisine` (
  `ntypcuisine` int(11) NOT NULL,
  `ltypcuisinefr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisineen` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisinenl` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisinees` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisineit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisinede` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisinesk` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisinecs` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisineru` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltypcuisinezh` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `typcuisine`
--

INSERT INTO `typcuisine` (`ntypcuisine`, `ltypcuisinefr`, `ltypcuisineen`, `ltypcuisinenl`, `ltypcuisinees`, `ltypcuisineit`, `ltypcuisinede`, `ltypcuisinesk`, `ltypcuisinecs`, `ltypcuisineru`, `ltypcuisinezh`) VALUES
(6, 'Aménagée', '', '', '', '', '', '', '', '', ''),
(8, 'Américaine', '', '', '', '', '', '', '', '', ''),
(1, 'Equipée', '', '', '', '', '', '', '', '', ''),
(7, 'Equipée et aménagée', '', '', '', '', '', '', '', '', ''),
(3, 'Equipement de base', '', '', '', '', '', '', '', '', ''),
(9, 'Kitchenette', '', '', '', '', '', '', '', '', ''),
(4, 'Sans', '', '', '', '', '', '', '', '', ''),
(10, 'Super équipée', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `typdetail`
--

DROP TABLE IF EXISTS `typdetail`;
CREATE TABLE `typdetail` (
  `ntypdetail` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ltypdetailfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailde` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `nordre` int(4) DEFAULT NULL,
  `ltypdetailes` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailcs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypdetailzh` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `typdetail`
--

INSERT INTO `typdetail` (`ntypdetail`, `ltypdetailfr`, `ltypdetailen`, `ltypdetailde`, `ltypdetailnl`, `nordre`, `ltypdetailes`, `ltypdetailit`, `ltypdetailsk`, `ltypdetailcs`, `ltypdetailru`, `ltypdetailzh`) VALUES
(1, 'Terrain', 'Land', NULL, 'Grond', 13, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Pièces diverses', 'Other rooms', NULL, 'Verschillende kamers', 7, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Services', 'Services', NULL, 'Diensten', 25, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 'Equipements divers', 'Other equipment', NULL, 'Andere uitrusting', 21, NULL, NULL, NULL, NULL, NULL, NULL),
(51, 'Equipements Electrique', 'Electrical equipment', NULL, 'Elektrische uitrusting', 22, NULL, NULL, NULL, NULL, NULL, NULL),
(55, 'Equipements de Cuisine', 'Kitchen equipment', NULL, 'Uitrusting van keuken', 20, NULL, NULL, NULL, NULL, NULL, NULL),
(66, 'Toiture', 'Roof', NULL, 'Dakwerk', 9, NULL, NULL, NULL, NULL, NULL, NULL),
(69, 'Dépendances', 'Outbuildings', NULL, 'Bijgebouw', 10, NULL, NULL, NULL, NULL, NULL, NULL),
(70, 'Rez de chaussée', 'Ground floor', NULL, 'Gelijkvloers', 4, NULL, NULL, NULL, NULL, NULL, NULL),
(71, '1er étage', 'First floor', NULL, 'Eerste verdieping', 5, NULL, NULL, NULL, NULL, NULL, NULL),
(72, '2ème étage', 'Second floor', NULL, 'Tweede verdieping', 6, NULL, NULL, NULL, NULL, NULL, NULL),
(75, 'Grenier', 'Attic', NULL, 'Zolder', 8, NULL, NULL, NULL, NULL, NULL, NULL),
(103, 'Diagnostic immobilier', 'Real estate diagnosis', NULL, 'Diagnostic immobilier', 2, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 'Préparation publicitaire', 'Advertising preparation', NULL, 'Préparation publicitaire', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(104, 'Constitution du dossier', 'File constitution', NULL, 'Elaboration du dossier', 3, NULL, NULL, NULL, NULL, NULL, NULL),
(111, 'Cadastre', 'Land Register', NULL, '', 15, NULL, NULL, NULL, NULL, NULL, NULL),
(114, 'Servitude', 'Easement', NULL, '', 14, NULL, NULL, NULL, NULL, NULL, NULL),
(117, 'Loi SRU', 'SRU Law', NULL, '', 17, NULL, NULL, NULL, NULL, NULL, NULL),
(119, 'Complément d\'Adresse', 'Full Address', NULL, '', 1, NULL, NULL, NULL, NULL, NULL, NULL),
(155, 'DPE', 'EPC (Energy Performance Certificates)', NULL, 'DPE', 11, NULL, NULL, NULL, NULL, NULL, NULL),
(157, 'Divers', 'Miscellaneous', NULL, 'Divers', 31, NULL, NULL, NULL, NULL, NULL, NULL),
(170, 'Loi ALUR - Infos générales', 'Loi ALUR - Infos générales', NULL, 'Loi ALUR - Infos générales', 12, NULL, NULL, NULL, NULL, NULL, NULL),
(120, 'Origine de propriété', 'Property origin', NULL, '', 28, NULL, NULL, NULL, NULL, NULL, NULL),
(122, 'Piscine', 'Swimming pool', NULL, '', 23, NULL, NULL, NULL, NULL, NULL, NULL),
(124, 'Urbanisme', 'Urbanism', NULL, '', 18, NULL, NULL, NULL, NULL, NULL, NULL),
(125, 'Type de construction', 'Type of building', NULL, '', 2, NULL, NULL, NULL, NULL, NULL, NULL),
(127, 'Voierie & Réseaux Divers', 'Connectings', NULL, '', 16, NULL, NULL, NULL, NULL, NULL, NULL),
(128, 'Panneau', 'Sign', NULL, '', 29, NULL, NULL, NULL, NULL, NULL, NULL),
(132, 'Détails Appartement', 'Appartment\'s details', NULL, '', 3, NULL, NULL, NULL, NULL, NULL, NULL),
(116, 'Chaudière', 'Boiler', NULL, '', 38, NULL, NULL, NULL, NULL, NULL, NULL),
(68, 'Fenêtres', 'Windows', NULL, 'Vensters', 39, NULL, NULL, NULL, NULL, NULL, NULL),
(123, 'Rez de jardin', 'Garden level', NULL, '', 40, NULL, NULL, NULL, NULL, NULL, NULL),
(115, 'Production eau chaude', 'Hot water production', NULL, '', 37, NULL, NULL, NULL, NULL, NULL, NULL),
(118, 'Déclaration', 'Statement', NULL, '', 41, NULL, NULL, NULL, NULL, NULL, NULL),
(121, 'Rez de piscine', 'Swimming pool level', NULL, '', 42, NULL, NULL, NULL, NULL, NULL, NULL),
(73, '3ème étage', '3th floor', NULL, 'Derde verdieping', 43, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'Pièces habitables', 'Living Rooms', NULL, 'Bewoonbare kamers', 44, NULL, NULL, NULL, NULL, NULL, NULL),
(74, '4ème étage', '4th floor', NULL, 'Vierde verdieping', 45, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 'Vue', 'Views', NULL, 'Zicht', 34, NULL, NULL, NULL, NULL, NULL, NULL),
(53, 'Sol', 'Floor', NULL, 'Grond', 46, NULL, NULL, NULL, NULL, NULL, NULL),
(58, 'Revêtement mural', 'Wall Covering', NULL, 'Muurbekleding', 47, NULL, NULL, NULL, NULL, NULL, NULL),
(62, 'Services divers', 'Other services', NULL, 'Verschillende diensten', 48, NULL, NULL, NULL, NULL, NULL, NULL),
(63, 'Langues parlées', 'Spoken languages', NULL, 'Gesproken talen', 50, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 'Données Financières', 'Financial data', NULL, 'Financiele gegevens', 19, NULL, NULL, NULL, NULL, NULL, NULL),
(126, 'Parking', 'Parking', NULL, '', 27, NULL, NULL, NULL, NULL, NULL, NULL),
(100, 'Options Web', 'Web options', NULL, 'Web opties', 24, NULL, NULL, NULL, NULL, NULL, NULL),
(190, 'Infos sur location', 'Infos s/ location', NULL, 'Infos s/ location', 32, NULL, NULL, NULL, NULL, NULL, NULL),
(76, 'Sous Sol', 'Basement', NULL, 'Kelderverdieping', 35, NULL, NULL, NULL, NULL, NULL, NULL),
(133, 'Suivi du dossier', 'File follow up', NULL, '', 4, NULL, NULL, NULL, NULL, NULL, NULL),
(151, 'Viager', 'Life Annuity', NULL, '', 30, NULL, NULL, NULL, NULL, NULL, NULL),
(153, 'Options Immoweb', 'Immoweb Options', NULL, '', 26, NULL, NULL, NULL, NULL, NULL, NULL),
(10040, 'Diagnostique radon', '', NULL, '', 33, NULL, NULL, NULL, NULL, NULL, NULL),
(54, 'Descriptif par étage', 'Description floor by floor', NULL, 'Werktekening per verdieping', 49, NULL, NULL, NULL, NULL, NULL, NULL),
(110, 'Rightmove infos', 'Rightmove infos', NULL, 'RightMove', 36, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `typmandat`
--

DROP TABLE IF EXISTS `typmandat`;
CREATE TABLE `typmandat` (
  `ctypmandat` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ltypmandatfr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandaten` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatde` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `qtotalbiens` int(11) DEFAULT '0',
  `ltypmandates` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatit` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatsk` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatcs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmandatzh` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ctypmandatmeta` varchar(8) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `typmandat`
--

INSERT INTO `typmandat` (`ctypmandat`, `ltypmandatfr`, `ltypmandaten`, `ltypmandatde`, `ltypmandatnl`, `qtotalbiens`, `ltypmandates`, `ltypmandatit`, `ltypmandatsk`, `ltypmandatcs`, `ltypmandatru`, `ltypmandatzh`, `ctypmandatmeta`) VALUES
('l', 'Location non meublée', 'Unfurnished rental', NULL, 'Niet gemeubeld verhuring', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('lm', 'Location meublée', 'Furnished rental', NULL, 'Gemeubeld verhuring', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('ls', 'Location saisonnière', 'Seasonal rental', NULL, 'Seizoenverhuring', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('vi', 'Viager', 'Life annuity', NULL, 'Lijfrente', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('v', 'Bien A Vendre', 'Property for Sale', NULL, 'Verkoop', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `typmeta`
--

DROP TABLE IF EXISTS `typmeta`;
CREATE TABLE `typmeta` (
  `ctypmeta` varchar(4) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ltypmetafr` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetaen` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetade` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetanl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `qtotalbiens` int(11) DEFAULT '0',
  `ltypmetaes` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetait` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetask` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetacs` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetaru` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltypmetazh` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `typmeta`
--

INSERT INTO `typmeta` (`ctypmeta`, `ltypmetafr`, `ltypmetaen`, `ltypmetade`, `ltypmetanl`, `qtotalbiens`, `ltypmetaes`, `ltypmetait`, `ltypmetask`, `ltypmetacs`, `ltypmetaru`, `ltypmetazh`) VALUES
('appt', 'Appartement', 'Apartment', NULL, 'Appartement', 0, NULL, NULL, NULL, NULL, NULL, NULL),
('chat', 'Château, propriété', 'Chateau, Manor House', NULL, 'Kasteel, eigendom', 0, NULL, NULL, NULL, NULL, NULL, NULL),
('loft', 'Loft,duplex', 'Loft,duplex', NULL, 'Loft,duplex', 0, NULL, NULL, NULL, NULL, NULL, NULL),
('mai', 'Maison', 'House', NULL, 'Huis', 15, NULL, NULL, NULL, NULL, NULL, NULL),
('comm', 'Locaux Commerciaux', 'Business Premises', NULL, 'Handelsoppervlakte', 0, NULL, NULL, NULL, NULL, NULL, NULL),
('park', 'Parking', 'Parking', NULL, 'Parkeerterrein', 0, NULL, NULL, NULL, NULL, NULL, NULL),
('terr', 'Terrain', 'Land', NULL, 'Bouwgrond', 3, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `typrelation`
--

DROP TABLE IF EXISTS `typrelation`;
CREATE TABLE `typrelation` (
  `ntyprelation` int(11) NOT NULL DEFAULT '0',
  `ltyprelationfr` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `brendezvous` int(11) DEFAULT NULL,
  `ltyprelationnl` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltyprelationen` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `typrelation`
--

INSERT INTO `typrelation` (`ntyprelation`, `ltyprelationfr`, `brendezvous`, `ltyprelationnl`, `ltyprelationen`) VALUES
(102, 'Rdv Notaire', 1, '', 'Notary Apptmt'),
(101, 'Rdv a l\'agence', 1, '', 'Apptmt at agency'),
(12, 'Renseignement', 0, '', 'Information'),
(15, 'Téléphone', 0, '', 'Telephone'),
(10, 'Annonce', 0, '', 'Ad'),
(18, 'Biens exclus', 0, '', 'Excluded properties'),
(23, 'Signature compromis', 1, '', 'Signed offer'),
(14, 'Visite', 1, '', 'Visit'),
(20, 'Changement de Prix', 0, 'Prijs verandering', 'Price changes'),
(21, 'Changement de statut', 0, 'Prijs verandering', 'Status change'),
(30, 'Changement de négociateur', 0, '', 'Salesman change'),
(31, 'Chang. statut pub. Web', 0, '', 'Publication status change'),
(17, 'Relance', 0, '', 'Dunn'),
(60, 'Changement de mandat', 0, '', 'Mandate change'),
(40, 'Changement de profil de réception de mails', 0, '', 'Mail profile change'),
(42, 'Envoi de voeux d\'anniversaire', 0, '', 'Happy birthday'),
(41, 'Envoi de rapports d\'activité', 0, '', 'Activity report sent by email'),
(50, 'Publication d\'annonces', 0, '', 'Adverts publishing'),
(2357688, 'Contact tél ', 1, '', ''),
(16, 'Expertise', 1, '', 'Expertise'),
(22, 'Message interne', 1, 'Message interne', 'Internal message'),
(24, 'Signature acte', 1, '', 'Deed of sale'),
(25, 'Rapport activité', 0, '', 'Activity Report'),
(1, 'Offre', 0, '', 'Offer'),
(5, 'Propriétaire', 0, '', 'Owner'),
(107, 'Phoning', 0, '', 'Phoning'),
(109, 'E-mail envoyé', 0, '', 'E-mail sent'),
(108, 'E-mail reçu', 0, '', 'E-mail received'),
(26, 'Notes', 0, '', 'Notes');

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

--
-- Table structure for table `utilisateur`
--

DROP TABLE IF EXISTS `utilisateur`;
CREATE TABLE `utilisateur` (
  `lusername` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lnom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lprenom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lfonction` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cusercre` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `dcre` datetime DEFAULT NULL,
  `cusermod` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `dmod` datetime DEFAULT NULL,
  `cpolit` char(1) COLLATE utf8_bin DEFAULT NULL,
  `ltel` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lfax` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltel2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lgsm` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lemail` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `nprivilege` float DEFAULT NULL,
  `lpassword` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `cagence` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `lnomsociete` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpasswordh` varchar(100) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `utilisateur`
--

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

--
-- Table structure for table `video`
--

DROP TABLE IF EXISTS `video`;
CREATE TABLE `video` (
  `photo` int(11) NOT NULL DEFAULT '0',
  `nbien` int(11) NOT NULL DEFAULT '0',
  `cagence` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ltitrefr` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltitreen` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltitrenl` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ltitrede` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescfr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescde` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescnl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sfilename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `nwidth` int(11) DEFAULT NULL,
  `nheight` int(11) DEFAULT NULL,
  `nordre` int(4) DEFAULT NULL,
  `bweb` int(11) DEFAULT NULL,
  `nangle` int(11) NOT NULL DEFAULT '0',
  `lshortdesces` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescsk` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdesccs` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescru` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdesczh` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dmod` datetime DEFAULT NULL,
  `dcre` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `videourl`
--

DROP TABLE IF EXISTS `videourl`;
CREATE TABLE `videourl` (
  `nvideourl` int(11) NOT NULL DEFAULT '0',
  `nbien` int(11) NOT NULL DEFAULT '0',
  `lurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `nordre` int(4) DEFAULT NULL,
  `lshortdescfr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescde` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescnl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdesces` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescsk` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdesccs` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdescru` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lshortdesczh` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dmod` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dcre` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `visiteur`
--

DROP TABLE IF EXISTS `visiteur`;
CREATE TABLE `visiteur` (
  `nvisiteur` int(11) NOT NULL DEFAULT '0',
  `cpolit` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `lnom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lprenom` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `ltel` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lgsm` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lemail` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `bactif` smallint(5) DEFAULT NULL,
  `lcomment` mediumtext COLLATE utf8_bin,
  `cusercre` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `dcre` datetime DEFAULT NULL,
  `dmod` datetime DEFAULT NULL,
  `cusermod` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `clangue` varchar(2) COLLATE utf8_bin DEFAULT NULL,
  `brelanceauto` int(11) DEFAULT NULL,
  `lusername` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `lpassword` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cagence` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `ctypmandat` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ctyp` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cregion` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lcp` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT '',
  `qchambres` int(11) NOT NULL DEFAULT '0',
  `qsurfterrain` int(11) NOT NULL DEFAULT '0',
  `qsurfhab` int(11) NOT NULL DEFAULT '0',
  `mprix1min` int(11) NOT NULL DEFAULT '0',
  `mprix1max` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `visiteurbien`
--

DROP TABLE IF EXISTS `visiteurbien`;
CREATE TABLE `visiteurbien` (
  `nvisiteur` int(11) NOT NULL DEFAULT '0',
  `nbien` int(11) NOT NULL DEFAULT '0',
  `dcre` datetime DEFAULT '0000-00-00 00:00:00',
  `dmod` datetime DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `webagence`
--

DROP TABLE IF EXISTS `webagence`;
CREATE TABLE `webagence` (
  `cagence` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cwebsite` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `webparam`
--

DROP TABLE IF EXISTS `webparam`;
CREATE TABLE `webparam` (
  `lattribname` char(25) COLLATE utf8_bin NOT NULL DEFAULT '*',
  `lattribvalue` longtext CHARACTER SET utf8,
  `clangue` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '*',
  `ltooltip` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  `lfieldnamefr` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `ctypparam` varchar(10) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agence`
--
ALTER TABLE `agence`
  ADD PRIMARY KEY (`cagence`);

--
-- Indexes for table `bien`
--
ALTER TABLE `bien`
  ADD PRIMARY KEY (`nbien`),
  ADD UNIQUE KEY `nbien` (`nbien`),
  ADD KEY `cbien` (`cbien`),
  ADD KEY `cregion` (`cregion`),
  ADD KEY `ctypmandat` (`ctypmandat`),
  ADD KEY `indx_bien_lusername` (`lusername`),
  ADD KEY `ctyp` (`ctyp`),
  ADD KEY `qchambres` (`qchambres`),
  ADD KEY `bactif` (`bactif`),
  ADD KEY `bneuf` (`bneuf`),
  ADD KEY `bcoupdecoeur` (`bcoupdecoeur`);

--
-- Indexes for table `biencrit`
--
ALTER TABLE `biencrit`
  ADD PRIMARY KEY (`nprospect`);

--
-- Indexes for table `biendesc`
--
ALTER TABLE `biendesc`
  ADD PRIMARY KEY (`nbien`,`clangue`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`cartId`),
  ADD UNIQUE KEY `id` (`cartId`),
  ADD UNIQUE KEY `nbiencookieId` (`nbien`,`cookieId`);

--
-- Indexes for table `detail`
--
ALTER TABLE `detail`
  ADD PRIMARY KEY (`ndetail`),
  ADD KEY `ntypdetail` (`ntypdetail`);

--
-- Indexes for table `detailbien`
--
ALTER TABLE `detailbien`
  ADD PRIMARY KEY (`ndetailbien`),
  ADD KEY `ndetail` (`ndetail`),
  ADD KEY `nbien` (`nbien`);

--
-- Indexes for table `disponibilite`
--
ALTER TABLE `disponibilite`
  ADD PRIMARY KEY (`ndisponibilite`);

--
-- Indexes for table `email`
--
ALTER TABLE `email`
  ADD PRIMARY KEY (`nemail`);

--
-- Indexes for table `environnement`
--
ALTER TABLE `environnement`
  ADD PRIMARY KEY (`cenvironnement`);

--
-- Indexes for table `etat`
--
ALTER TABLE `etat`
  ADD PRIMARY KEY (`cetat`);

--
-- Indexes for table `gis`
--
ALTER TABLE `gis`
  ADD UNIQUE KEY `gis_x` (`cid`),
  ADD KEY `lnommaj` (`lnommaj`),
  ADD KEY `cidparent` (`cidparent`),
  ADD KEY `ctype` (`ctype`);

--
-- Indexes for table `htmlpage`
--
ALTER TABLE `htmlpage`
  ADD PRIMARY KEY (`nhtmlpage`),
  ADD KEY `clangue` (`clangue`);

--
-- Indexes for table `htmlpage2`
--
ALTER TABLE `htmlpage2`
  ADD PRIMARY KEY (`nhtmlpage`);

--
-- Indexes for table `langue`
--
ALTER TABLE `langue`
  ADD PRIMARY KEY (`clangue`);

--
-- Indexes for table `mails`
--
ALTER TABLE `mails`
  ADD PRIMARY KEY (`nmails`);

--
-- Indexes for table `membre`
--
ALTER TABLE `membre`
  ADD PRIMARY KEY (`nmembre`);

--
-- Indexes for table `natmandat`
--
ALTER TABLE `natmandat`
  ADD PRIMARY KEY (`nnatmandat`);

--
-- Indexes for table `naturebien`
--
ALTER TABLE `naturebien`
  ADD PRIMARY KEY (`cnaturebien`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`nnews`);

--
-- Indexes for table `originebien`
--
ALTER TABLE `originebien`
  ADD PRIMARY KEY (`coriginebien`);

--
-- Indexes for table `pdf`
--
ALTER TABLE `pdf`
  ADD PRIMARY KEY (`npdf`);

--
-- Indexes for table `photo`
--
ALTER TABLE `photo`
  ADD PRIMARY KEY (`nphoto`),
  ADD KEY `nbien` (`nbien`),
  ADD KEY `nangle` (`nangle`);

--
-- Indexes for table `polit`
--
ALTER TABLE `polit`
  ADD PRIMARY KEY (`cpolit`);

--
-- Indexes for table `preference`
--
ALTER TABLE `preference`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `prospect`
--
ALTER TABLE `prospect`
  ADD PRIMARY KEY (`nprospect`);

--
-- Indexes for table `prospectbien`
--
ALTER TABLE `prospectbien`
  ADD UNIQUE KEY `nrelation` (`nrelation`),
  ADD KEY `ntyprelation` (`ntyprelation`),
  ADD KEY `nprospect` (`nprospect`),
  ADD KEY `nbien` (`nbien`);

--
-- Indexes for table `region`
--
ALTER TABLE `region`
  ADD PRIMARY KEY (`cregion`),
  ADD KEY `cregionmeta` (`cregionmeta`);

--
-- Indexes for table `regionmeta`
--
ALTER TABLE `regionmeta`
  ADD PRIMARY KEY (`cregionmeta`);

--
-- Indexes for table `style`
--
ALTER TABLE `style`
  ADD PRIMARY KEY (`cstyle`);

--
-- Indexes for table `taux`
--
ALTER TABLE `taux`
  ADD PRIMARY KEY (`cdevise`);


DROP TABLE IF EXISTS `testimonials`;
CREATE TABLE `testimonials` (
  `ntestimonials` int(255) NOT NULL,
  `ltitre` longtext COLLATE utf8_unicode_ci,
  `lcontent` longtext COLLATE utf8_unicode_ci,
  `lprenom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lnom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dpub` date DEFAULT NULL,
  `clangue` varchar(2) COLLATE utf8_unicode_ci DEFAULT 'fr',
  `bpub` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;




ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`ntestimonials`);

--
-- Indexes for table `typ`
--
ALTER TABLE `typ`
  ADD PRIMARY KEY (`ctyp`),
  ADD KEY `ctyp` (`ctyp`);

--
-- Indexes for table `typchauf`
--
ALTER TABLE `typchauf`
  ADD PRIMARY KEY (`cchauf`);

--
-- Indexes for table `typcuisine`
--
ALTER TABLE `typcuisine`
  ADD PRIMARY KEY (`ntypcuisine`);

--
-- Indexes for table `typdetail`
--
ALTER TABLE `typdetail`
  ADD PRIMARY KEY (`ntypdetail`);

--
-- Indexes for table `typmandat`
--
ALTER TABLE `typmandat`
  ADD PRIMARY KEY (`ctypmandat`);

--
-- Indexes for table `typmeta`
--
ALTER TABLE `typmeta`
  ADD PRIMARY KEY (`ctypmeta`),
  ADD KEY `indx_typmeta_ctypmeta` (`ctypmeta`);

--
-- Indexes for table `typrelation`
--
ALTER TABLE `typrelation`
  ADD PRIMARY KEY (`ntyprelation`);

--
-- Indexes for table `utilisateur`
--
ALTER TABLE `utilisateur`
  ADD PRIMARY KEY (`lusername`);

--
-- Indexes for table `video`
--
ALTER TABLE `video`
  ADD PRIMARY KEY (`photo`),
  ADD KEY `nbien` (`nbien`),
  ADD KEY `nangle` (`nangle`);

--
-- Indexes for table `videourl`
--
ALTER TABLE `videourl`
  ADD PRIMARY KEY (`nvideourl`),
  ADD KEY `nbien` (`nbien`);

--
-- Indexes for table `visiteur`
--
ALTER TABLE `visiteur`
  ADD PRIMARY KEY (`nvisiteur`);

--
-- Indexes for table `visiteurbien`
--
ALTER TABLE `visiteurbien`
  ADD PRIMARY KEY (`nvisiteur`,`nbien`);

--
-- Indexes for table `webagence`
--
ALTER TABLE `webagence`
  ADD PRIMARY KEY (`cagence`);

--
-- Indexes for table `webparam`
--
ALTER TABLE `webparam`
  ADD PRIMARY KEY (`clangue`,`lattribname`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `cartId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
--
-- AUTO_INCREMENT for table `detailbien`
--
ALTER TABLE `detailbien`
  MODIFY `ndetailbien` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1398;
--
-- AUTO_INCREMENT for table `htmlpage`
--
ALTER TABLE `htmlpage`
  MODIFY `nhtmlpage` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26797;
--
-- AUTO_INCREMENT for table `membre`
--
ALTER TABLE `membre`
  MODIFY `nmembre` int(255) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `nnews` int(255) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `ntestimonials` int(255) NOT NULL AUTO_INCREMENT;
/*!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 */;
