-- phpMyAdmin SQL Dump
-- version OVH
-- http://www.phpmyadmin.net
--
-- Client: mysql51-91.perso
-- Généré le : Jeu 27 Mars 2014 à 09:50
-- Version du serveur: 5.1.66
-- Version de PHP: 5.3.8

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 utf8 */;

--
-- Base de données: `tourismefizipds`
--

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

--
-- Structure de la table `ot_pontrieux_izi_actualites_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_actualites_2011` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `resume` text NOT NULL,
  `texte` text NOT NULL,
  `date_edition` datetime NOT NULL,
  `date_debut` datetime NOT NULL,
  `date_fin` datetime NOT NULL,
  `programme` int(10) NOT NULL,
  `affiche` int(10) NOT NULL,
  `ordre` int(10) NOT NULL,
  `une` int(10) NOT NULL,
  `papa` int(10) NOT NULL,
  `t0` text NOT NULL,
  `t1` text NOT NULL,
  `t2` text NOT NULL,
  `t3` text NOT NULL,
  `t4` text NOT NULL,
  `t5` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `ot_pontrieux_izi_agenda_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_agenda_2011` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `resume` text NOT NULL,
  `texte` text NOT NULL,
  `date_edition` datetime NOT NULL,
  `date_debut` datetime NOT NULL,
  `date_fin` datetime NOT NULL,
  `affiche` varchar(10) NOT NULL,
  `papa` int(11) NOT NULL,
  `rubrique` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `date_debut` (`date_debut`,`date_fin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `ot_pontrieux_izi_articles_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_articles_2011` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `resume` text NOT NULL,
  `texte` text NOT NULL,
  `src` text NOT NULL,
  `date_edition` datetime NOT NULL,
  `date_debut` datetime NOT NULL,
  `date_fin` datetime NOT NULL,
  `programme` varchar(10) NOT NULL,
  `affiche` char(10) NOT NULL,
  `ordre` int(20) NOT NULL,
  `papa` int(20) NOT NULL,
  `langue` int(10) NOT NULL,
  `id_langue_ori` int(10) NOT NULL,
  `structure` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113 ;

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

--
-- Structure de la table `ot_pontrieux_izi_diaporama_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_diaporama_2011` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `sous_titre` text NOT NULL,
  `lien` text NOT NULL,
  `src` text NOT NULL,
  `affiche` varchar(10) NOT NULL,
  `ordre` int(10) NOT NULL,
  `t1` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

--
-- Structure de la table `ot_pontrieux_izi_document_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_document_2011` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `rubrique` int(2) NOT NULL,
  `pdf` text NOT NULL,
  `titre` text NOT NULL,
  `ordre` int(3) NOT NULL,
  `affiche` int(2) NOT NULL,
  `minipdf` text NOT NULL,
  `pagepdf` int(10) NOT NULL,
  `descriptif` text NOT NULL,
  `une` int(2) NOT NULL,
  `date_publication` date NOT NULL,
  `date_modif` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Structure de la table `ot_pontrieux_izi_document_type_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_document_type_2011` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ordre` int(2) NOT NULL,
  `titre` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `ot_pontrieux_izi_lang_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_lang_2011` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `langue` text NOT NULL,
  `code` varchar(3) NOT NULL,
  `picto` text NOT NULL,
  `ordre` int(20) NOT NULL,
  `affiche` varchar(10) NOT NULL,
  `tr_office_tourisme` text NOT NULL,
  `tr_suivez_nous` text NOT NULL,
  `tr_notez_le` text NOT NULL,
  `tr_voir_tout_agenda` text NOT NULL,
  `tr_meteo` text NOT NULL,
  `tr_prev_meteo` text NOT NULL,
  `tr_documents` text NOT NULL,
  `tr_nos_partenaires` text NOT NULL,
  `tr_plus_infos` text NOT NULL,
  `tr_contactez_nous` text NOT NULL,
  `tr_envoyez_mail` text NOT NULL,
  `tr_page_suivante` text NOT NULL,
  `tr_page_precedente` text NOT NULL,
  `tr_parlez_en` text NOT NULL,
  `tr_abonnez_vous` text NOT NULL,
  `tr_cliquez_carte` text NOT NULL,
  `tr_choisissez_mois` text NOT NULL,
  `tr_titre_meubles` text NOT NULL,
  `tr_soustitre_meubles` text NOT NULL,
  `tr_votrerecherche` text NOT NULL,
  `tr_tous` text NOT NULL,
  `tr_toutes` text NOT NULL,
  `tr_par_classement` text NOT NULL,
  `tr_par_commune` text NOT NULL,
  `tr_capacite_minimale` text NOT NULL,
  `tr_capacite_maximale` text NOT NULL,
  `tr_nombre_chambre` text NOT NULL,
  `tr_maison` text NOT NULL,
  `tr_services` text NOT NULL,
  `tr_infos_tarifs` text NOT NULL,
  `tr_y_aller` text NOT NULL,
  `tr_envie_de` text NOT NULL,
  `tr_se_restaurer` text NOT NULL,
  `tr_rester` text NOT NULL,
  `tr_sortir` text NOT NULL,
  `tr_plus_dinformations` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Structure de la table `ot_pontrieux_izi_lien_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_lien_2011` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` int(2) NOT NULL,
  `nom` text NOT NULL,
  `description` text NOT NULL,
  `url` text NOT NULL,
  `src` text NOT NULL,
  `format` int(11) NOT NULL,
  `ordre` int(10) NOT NULL,
  `affiche` int(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `ordre` (`ordre`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

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

--
-- Structure de la table `ot_pontrieux_izi_user_2011`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_izi_user_2011` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_user_nom` text NOT NULL,
  `site_user` varchar(255) NOT NULL,
  `site_user_password` varchar(255) NOT NULL,
  `site_user_mail` text NOT NULL,
  `site_user_type` int(10) NOT NULL,
  `site_user_valide` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `site_user` (`site_user`,`site_user_password`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_agenda_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_agenda_en` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `datedebut` date NOT NULL,
  `datefin` date NOT NULL,
  `horaires` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `GmapLatitude` text NOT NULL,
  `GmapLongitude` text NOT NULL,
  `categorie` text NOT NULL,
  `tarifs` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `siteweb` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `mail` text NOT NULL,
  `photos` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1104 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_agenda_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_agenda_fr` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `datedebut` date NOT NULL,
  `datefin` date NOT NULL,
  `horaires` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `GmapLatitude` text NOT NULL,
  `GmapLongitude` text NOT NULL,
  `categorie` text NOT NULL,
  `tarifs` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `siteweb` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `mail` text NOT NULL,
  `photos` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1353 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_bar_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_bar_en` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` text NOT NULL,
  `title` text NOT NULL,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `mail` text NOT NULL,
  `siteweb` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `photos` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_bar_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_bar_fr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` text NOT NULL,
  `title` text NOT NULL,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `mail` text NOT NULL,
  `siteweb` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `photos` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_camping_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_camping_en` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `capacite` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `ouvertureaccueil` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `nbreemplacements` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `chaines` text NOT NULL,
  `categorie` text NOT NULL,
  `labelsmarquescertifications` text NOT NULL,
  `languesparlees` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_camping_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_camping_fr` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `capacite` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `ouvertureaccueil` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `nbreemplacements` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `chaines` text NOT NULL,
  `categorie` text NOT NULL,
  `labelsmarquescertifications` text NOT NULL,
  `languesparlees` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_chambredhotes_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_chambredhotes_en` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifnuit` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_chambredhotes_en_2013`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_chambredhotes_en_2013` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifnuit` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_chambredhotes_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_chambredhotes_fr` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifnuit` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_chambredhotes_fr_2013`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_chambredhotes_fr_2013` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifnuit` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_hotel_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_hotel_en` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `confort` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `ouvertureaccueil` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `nbrechambres` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `chaines` text NOT NULL,
  `categorie` text NOT NULL,
  `labelsmarquescertifications` text NOT NULL,
  `languesparlees` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_hotel_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_hotel_fr` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `confort` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `ouvertureaccueil` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `nbrechambres` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `chaines` text NOT NULL,
  `categorie` text NOT NULL,
  `labelsmarquescertifications` text NOT NULL,
  `languesparlees` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_meubles_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_meubles_en` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  `insolite` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=636 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_meubles_en_2013`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_meubles_en_2013` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  `insolite` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=350 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_meubles_en_old`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_meubles_en_old` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_meubles_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_meubles_fr` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  `insolite` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=722 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_meubles_fr_2013`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_meubles_fr_2013` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `tarifnuitn1` text NOT NULL,
  `tarifsemainen1` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  `insolite` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=493 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_meubles_fr_old`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_meubles_fr_old` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `Published` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  `nom` text NOT NULL,
  `longitude` text NOT NULL,
  `latitude` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `photos` text NOT NULL,
  `equipements` text NOT NULL,
  `modepaiement` text NOT NULL,
  `tarifs` text NOT NULL,
  `tarifsemaine` text NOT NULL,
  `animaux` text NOT NULL,
  `handicap` text NOT NULL,
  `services` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `descriptifcommercialot` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `siteweb` text NOT NULL,
  `mail` text NOT NULL,
  `categorie` text NOT NULL,
  `languesparlees` text NOT NULL,
  `classementlabel` text NOT NULL,
  `nombrechambres` text NOT NULL,
  `descriptifconfort` text NOT NULL,
  `typehabitation` text NOT NULL,
  `typelabel` text NOT NULL,
  `capacitemaxi` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=89 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_restaurant_en`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_restaurant_en` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `updated` datetime NOT NULL,
  `published` datetime NOT NULL,
  `title` text NOT NULL,
  `nom` text NOT NULL,
  `SyndicObjectName` text NOT NULL,
  `type` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `tarifs` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `mail` text NOT NULL,
  `siteweb` text NOT NULL,
  `photos` text NOT NULL,
  `categorie` text NOT NULL,
  `labelsmarquescertifications` text NOT NULL,
  `classementguides` text NOT NULL,
  `ouvertureaccueil` text NOT NULL,
  `handicap` text NOT NULL,
  `nombremaxicouvert` text NOT NULL,
  `t1` text NOT NULL,
  `t2` text NOT NULL,
  `t3` text NOT NULL,
  `t4` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;

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

--
-- Structure de la table `ot_pontrieux_tourinsoft_restaurant_fr`
--

CREATE TABLE IF NOT EXISTS `ot_pontrieux_tourinsoft_restaurant_fr` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `SyndicObjectID` text NOT NULL,
  `updated` datetime NOT NULL,
  `published` datetime NOT NULL,
  `title` text NOT NULL,
  `nom` text NOT NULL,
  `SyndicObjectName` text NOT NULL,
  `type` text NOT NULL,
  `ObjectTypeName` text NOT NULL,
  `descriptifcommercialgeneral` text NOT NULL,
  `adresse1` text NOT NULL,
  `adresse2` text NOT NULL,
  `adresse3` text NOT NULL,
  `codepostal` text NOT NULL,
  `commune` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `tarifs` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `mail` text NOT NULL,
  `siteweb` text NOT NULL,
  `photos` text NOT NULL,
  `categorie` text NOT NULL,
  `labelsmarquescertifications` text NOT NULL,
  `classementguides` text NOT NULL,
  `ouvertureaccueil` text NOT NULL,
  `handicap` text NOT NULL,
  `nombremaxicouvert` text NOT NULL,
  `t1` text NOT NULL,
  `t2` text NOT NULL,
  `t3` text NOT NULL,
  `t4` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

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