-- phpMyAdmin SQL Dump
-- version 2.11.10
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Sam 06 Novembre 2010 à 11:59
-- Version du serveur: 5.0.84
-- Version de PHP: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

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

--
-- Structure de la table `content_field_entity_address`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_address` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_address_value` longtext,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_address`
--

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

--
-- Structure de la table `content_field_entity_city`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_city` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_city_value` longtext,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_city`
--

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

--
-- Structure de la table `content_field_entity_contactperson`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_contactperson` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_contactperson_value` longtext,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_contactperson`
--

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

--
-- Structure de la table `content_field_entity_faxnumber`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_faxnumber` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_faxnumber_value` varchar(255) default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_faxnumber`
--

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

--
-- Structure de la table `content_field_entity_longdesc`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_longdesc` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_longdesc_value` longtext,
  `field_entity_longdesc_format` int(10) unsigned default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_longdesc`
--

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

--
-- Structure de la table `content_field_entity_mail`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_mail` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_mail_email` varchar(255) default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_mail`
--

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

--
-- Structure de la table `content_field_entity_npa`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_npa` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_npa_value` int(11) default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_npa`
--

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

--
-- Structure de la table `content_field_entity_phonenumber`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_phonenumber` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `delta` int(10) unsigned NOT NULL default '0',
  `field_entity_phonenumber_value` varchar(255) default NULL,
  PRIMARY KEY  (`vid`,`delta`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_phonenumber`
--

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

--
-- Structure de la table `content_field_entity_phonenumber_more`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_phonenumber_more` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `delta` int(10) unsigned NOT NULL default '0',
  `field_entity_phonenumber_more_value` varchar(100) default NULL,
  PRIMARY KEY  (`vid`,`delta`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_phonenumber_more`
--

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

--
-- Structure de la table `content_field_entity_picture`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_picture` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_picture_fid` int(11) default NULL,
  `field_entity_picture_list` tinyint(4) default NULL,
  `field_entity_picture_data` text,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_picture`
--

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

--
-- Structure de la table `content_field_entity_region`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_region` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_region_value` int(11) default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_region`
--

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

--
-- Structure de la table `content_field_entity_shortdesc`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_shortdesc` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_shortdesc_value` longtext,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_shortdesc`
--

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

--
-- Structure de la table `content_field_entity_website`
--

CREATE TABLE IF NOT EXISTS `content_field_entity_website` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_entity_website_url` varchar(2048) default NULL,
  `field_entity_website_title` varchar(255) default NULL,
  `field_entity_website_attributes` mediumtext,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_entity_website`
--

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

--
-- Structure de la table `content_field_event_city`
--

CREATE TABLE IF NOT EXISTS `content_field_event_city` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `delta` int(10) unsigned NOT NULL default '0',
  `field_event_city_value` longtext,
  PRIMARY KEY  (`vid`,`delta`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_event_city`
--

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

--
-- Structure de la table `content_field_fetch_news`
--

CREATE TABLE IF NOT EXISTS `content_field_fetch_news` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_fetch_news_value` longtext,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_field_fetch_news`
--

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

--
-- Structure de la table `content_type_entity`
--

CREATE TABLE IF NOT EXISTS `content_type_entity` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_type_entity`
--

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

--
-- Structure de la table `content_type_hosting`
--

CREATE TABLE IF NOT EXISTS `content_type_hosting` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_hosting_category_value` int(11) default NULL,
  `field_hosting_room_view_value` longtext,
  `field_hosting_additional_value` longtext,
  `field_hosting_additional_format` int(10) unsigned default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_type_hosting`
--

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

--
-- Structure de la table `content_type_longdesc`
--

CREATE TABLE IF NOT EXISTS `content_type_longdesc` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `field_desc_hosting_nid_nid` int(10) unsigned default NULL,
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`),
  KEY `field_desc_hosting_nid_nid` (`field_desc_hosting_nid_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `content_type_longdesc`
--

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

--
-- Structure de la table `node`
--

CREATE TABLE IF NOT EXISTS `node` (
  `nid` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `type` varchar(32) NOT NULL default '',
  `language` varchar(12) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `uid` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '1',
  `created` int(11) NOT NULL default '0',
  `changed` int(11) NOT NULL default '0',
  `comment` int(11) NOT NULL default '0',
  `promote` int(11) NOT NULL default '0',
  `moderate` int(11) NOT NULL default '0',
  `sticky` int(11) NOT NULL default '0',
  `tnid` int(10) unsigned NOT NULL default '0',
  `translate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nid`),
  UNIQUE KEY `vid` (`vid`),
  KEY `node_changed` (`changed`),
  KEY `node_created` (`created`),
  KEY `node_moderate` (`moderate`),
  KEY `node_promote_status` (`promote`,`status`),
  KEY `node_status_type` (`status`,`type`,`nid`),
  KEY `node_title_type` (`title`,`type`(4)),
  KEY `node_type` (`type`(4)),
  KEY `uid` (`uid`),
  KEY `tnid` (`tnid`),
  KEY `translate` (`translate`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=801 ;

--
-- Contenu de la table `node`
--

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

--
-- Structure de la table `node_revisions`
--

CREATE TABLE IF NOT EXISTS `node_revisions` (
  `nid` int(10) unsigned NOT NULL default '0',
  `vid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `body` longtext NOT NULL,
  `teaser` longtext NOT NULL,
  `log` longtext NOT NULL,
  `timestamp` int(11) NOT NULL default '0',
  `format` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=801 ;

--
-- Contenu de la table `node_revisions`
--

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