start.sql

-- start.sql

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

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

--
-- Contenu de la table `sym_anti_brute_force_wl`
--

INSERT INTO `sym_anti_brute_force_wl` (`IP`, `DateCreated`, `Source`) VALUES
('199.168.223.66', '2016-11-22 18:52:02', 'Manual entry made by start.sql');

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

--
-- Contenu de la table `sym_dashboard_panels`
--

INSERT INTO `sym_dashboard_panels` (`id`, `label`, `type`, `config`, `placement`, `sort_order`) VALUES
(1, 'Visites du dernier mois', 'Google Analytics', 'a:8:{s:5:"email";s:29:"x@appspot.gserviceaccount.com";s:7:"keyfile";s:14:"manifest/x.p12";s:10:"start-date";s:9:"30daysAgo";s:8:"end-date";s:9:"yesterday";s:10:"dimensions";s:7:"ga:date";s:7:"metrics";s:11:"ga:sessions";s:4:"type";s:4:"LINE";s:6:"height";s:5:"250px";}', 'primary', 1),
(2, 'Browsers - 90 jours', 'Google Analytics', 'a:8:{s:5:"email";s:29:"x@appspot.gserviceaccount.com";s:7:"keyfile";s:14:"manifest/x.p12";s:10:"start-date";s:9:"90daysAgo";s:8:"end-date";s:9:"yesterday";s:10:"dimensions";s:10:"ga:browser";s:7:"metrics";s:8:"ga:users";s:4:"type";s:3:"PIE";s:6:"height";s:5:"220px";}', 'secondary', 2),
(3, 'Source / Médium des 30 derniers jours', 'Google Analytics', 'a:8:{s:5:"email";s:29:"x@appspot.gserviceaccount.com";s:7:"keyfile";s:14:"manifest/x.p12";s:10:"start-date";s:9:"30daysAgo";s:8:"end-date";s:9:"yesterday";s:10:"dimensions";s:15:"ga:sourceMedium";s:7:"metrics";s:11:"ga:sessions";s:4:"type";s:5:"TABLE";s:6:"height";s:5:"370px";}', 'primary', 3),
(4, 'Pays de provenance 120 derniers jours', 'Google Analytics', 'a:8:{s:5:"email";s:29:"x@appspot.gserviceaccount.com";s:7:"keyfile";s:14:"manifest/x.p12";s:10:"start-date";s:10:"120daysAgo";s:8:"end-date";s:9:"yesterday";s:10:"dimensions";s:10:"ga:country";s:7:"metrics";s:11:"ga:sessions";s:4:"type";s:3:"GEO";s:6:"height";s:5:"400px";}', 'secondary', 4);

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

--
-- Structure de la table `sym_entries_data_1`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_1` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_2`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_2` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_3`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_3` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` int(11) unsigned DEFAULT NULL,
  `mimetype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `file` (`file`),
  KEY `mimetype` (`mimetype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_4`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_4` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_5`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_5` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_6`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_6` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_7`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_7` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_8`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_8` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_9`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_9` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_10`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_10` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_13`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_13` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `page_id` int(11) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  KEY `page_id` (`page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_14`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_14` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_15`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_15` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_16`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_16` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entry_id` (`entry_id`),
  KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_17`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_17` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_18`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_18` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `page_id` int(11) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  KEY `page_id` (`page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_19`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_19` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_20`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_20` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `page_id` int(11) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  KEY `page_id` (`page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_21`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_21` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_22`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_22` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_23`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_23` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_24`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_24` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_25`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_25` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` int(11) unsigned DEFAULT NULL,
  `mimetype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `file` (`file`),
  KEY `mimetype` (`mimetype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_26`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_26` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_27`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_27` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_28`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_28` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_29`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_29` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `value` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Structure de la table `sym_entries_data_30`
--

CREATE TABLE IF NOT EXISTS `sym_entries_data_30` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `value_formatted` text COLLATE utf8_unicode_ci,
  `word_count` int(11) unsigned DEFAULT NULL,
  `handle-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-en` text COLLATE utf8_unicode_ci,
  `value_formatted-en` text COLLATE utf8_unicode_ci,
  `word_count-en` int(11) unsigned DEFAULT NULL,
  `handle-fr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value-fr` text COLLATE utf8_unicode_ci,
  `value_formatted-fr` text COLLATE utf8_unicode_ci,
  `word_count-fr` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry_id` (`entry_id`),
  KEY `handle-en` (`handle-en`),
  KEY `handle-fr` (`handle-fr`),
  KEY `handle` (`handle`),
  FULLTEXT KEY `value-en` (`value-en`),
  FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),
  FULLTEXT KEY `value-fr` (`value-fr`),
  FULLTEXT KEY `value_formatted-fr` (`value_formatted-fr`),
  FULLTEXT KEY `value` (`value`),
  FULLTEXT KEY `value_formatted` (`value_formatted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

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

--
-- Contenu de la table `sym_fields`
--

INSERT INTO `sym_fields` (`id`, `label`, `element_name`, `type`, `parent_section`, `required`, `sortorder`, `location`, `show_column`) VALUES
(1, 'Metas', 'metas-tab', 'publish_tabs', 1, 'no', 0, 'main', 'no'),
(2, 'Titre', 'Titre', 'multilingual_textbox', 1, 'yes', 1, 'main', 'yes'),
(3, 'Image', 'image', 'image_upload', 1, 'no', 2, 'sidebar', 'yes'),
(4, 'Description', 'description', 'multilingual_textbox', 1, 'yes', 4, 'main', 'yes'),
(5, 'Twitter url', 'twitter-url', 'textbox', 1, 'no', 6, 'main', 'no'),
(6, 'Twitter user', 'twitter-user', 'textbox', 1, 'no', 7, 'main', 'no'),
(7, 'Twitter site domain', 'twitter-site-domain', 'textbox', 1, 'no', 8, 'main', 'no'),
(8, 'Facebook url', 'facebook-url', 'textbox', 1, 'no', 9, 'main', 'no'),
(9, 'Navigateurs non-supportés', 'navigateurs-non-supportes-tab', 'publish_tabs', 1, 'no', 15, 'main', 'no'),
(10, 'Navigateurs non-supportés', 'navigateurs-non-supportes', 'multilingual_textbox', 1, 'yes', 16, 'main', 'no'),
(28, 'Facebook notes', 'facebook-notes', 'publishnotes', 1, 'no', 11, 'main', 'no'),
(26, 'Réseaux sociaux', 'reseaux-sociaux', 'publish_tabs', 1, 'no', 5, 'main', 'no'),
(27, 'Youtube url', 'youtube-url', 'textbox', 1, 'no', 14, 'main', 'no'),
(13, 'Page', 'page', 'pages', 2, 'yes', 0, 'main', 'yes'),
(14, 'Titre', 'titre', 'multilingual_textbox', 2, 'yes', 1, 'main', 'yes'),
(15, 'Publié', 'publie', 'checkbox', 2, 'no', 2, 'sidebar', 'yes'),
(16, 'Ordre', 'ordre', 'order_entries', 2, 'no', 3, 'sidebar', 'yes'),
(17, 'Titre', 'titre', 'multilingual_textbox', 3, 'yes', 0, 'main', 'yes'),
(20, 'Page', 'page', 'pages', 3, 'yes', 1, 'sidebar', 'yes'),
(19, 'Texte', 'texte', 'multilingual_textbox', 3, 'no', 2, 'main', 'no'),
(21, 'Vimeo url', 'vimeo-url', 'textbox', 1, 'no', 12, 'main', 'no'),
(22, 'Instagram url', 'instagram-url', 'textbox', 1, 'no', 13, 'main', 'no'),
(23, 'Facebook page id', 'facebook-page-id', 'textbox', 1, 'no', 10, 'main', 'no'),
(18, 'Page', 'page', 'pages', 4, 'yes', 0, 'main', 'yes'),
(24, 'Description', 'description', 'multilingual_textbox', 4, 'yes', 2, 'main', 'yes'),
(25, 'Image', 'image', 'image_upload', 4, 'no', 3, 'sidebar', 'yes'),
(29, 'Thème', 'theme', 'colorchooser', 1, 'no', 3, 'sidebar', 'yes'),
(30, 'Titre', 'titre', 'multilingual_textbox', 4, 'no', 1, 'main', 'yes');

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

--
-- Contenu de la table `sym_fields_checkbox`
--

INSERT INTO `sym_fields_checkbox` (`id`, `field_id`, `default_state`, `description`) VALUES
(1, 15, 'on', NULL);

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

--
-- Contenu de la table `sym_fields_colorchooser`
--

INSERT INTO `sym_fields_colorchooser` (`id`, `field_id`) VALUES
(3, 29);

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

--
-- Contenu de la table `sym_fields_image_upload`
--

INSERT INTO `sym_fields_image_upload` (`id`, `field_id`, `destination`, `validator`, `unique`, `min_width`, `min_height`, `max_width`, `max_height`, `resize`) VALUES
(10, 3, '/workspace/uploads/config', '/\\.(?:jpe?g|png)$/i', 'yes', 300, 300, 1200, 1200, 'no'),
(12, 25, '/workspace/uploads/metas', '/\\.(?:jpe?g|png)$/i', 'yes', 300, 300, 1200, 1200, 'no');

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

--
-- Contenu de la table `sym_fields_multilingual_textbox`
--

INSERT INTO `sym_fields_multilingual_textbox` (`id`, `field_id`, `column_length`, `text_size`, `text_formatter`, `text_validator`, `text_length`, `text_cdata`, `text_handle`, `default_main_lang`, `required_languages`) VALUES
(41, 2, 50, 'single', 'none', NULL, 70, 'no', 'yes', 'yes', 'all'),
(42, 4, 75, 'small', 'none', NULL, 320, 'no', 'no', 'yes', 'all'),
(43, 10, 75, 'single', 'none', NULL, 0, 'no', 'no', 'yes', 'all'),
(46, 30, 50, 'single', 'none', NULL, 70, 'no', 'yes', 'yes', ''),
(11, 14, 75, 'single', 'none', NULL, 0, 'no', 'yes', 'no', 'all'),
(14, 17, 75, 'single', 'none', NULL, 0, 'no', 'yes', 'no', 'all'),
(15, 19, 75, 'medium', 'markdown', NULL, 0, 'no', 'no', 'yes', ''),
(47, 24, 75, 'small', 'none', NULL, 320, 'no', 'yes', 'no', 'all');

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

--
-- Contenu de la table `sym_fields_order_entries`
--

INSERT INTO `sym_fields_order_entries` (`id`, `field_id`, `force_sort`, `hide`, `disable_pagination`, `filtered_fields`) VALUES
(1, 16, NULL, 'yes', 'no', NULL);

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

--
-- Contenu de la table `sym_fields_pages`
--

INSERT INTO `sym_fields_pages` (`id`, `field_id`, `allow_multiple_selection`, `unique_value`, `page_types`) VALUES
(1, 13, 'no', 'no', NULL),
(2, 20, 'no', 'no', '403, 404'),
(7, 18, 'no', 'no', 'custom-metas');

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

--
-- Contenu de la table `sym_fields_publishnotes`
--

INSERT INTO `sym_fields_publishnotes` (`id`, `field_id`, `note`, `editable`) VALUES
(4, 28, '<p>Utilisez <a href="https://developers.facebook.com/tools/explorer" target="_blank" rel="noopener">ce lien</a> pour obtenir le facebook page id</p>', 0);

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

--
-- Contenu de la table `sym_fields_publish_tabs`
--

INSERT INTO `sym_fields_publish_tabs` (`id`, `field_id`) VALUES
(21, 1),
(23, 9),
(22, 26);

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

--
-- Contenu de la table `sym_fields_textbox`
--

INSERT INTO `sym_fields_textbox` (`id`, `field_id`, `column_length`, `text_size`, `text_formatter`, `text_validator`, `text_length`, `text_cdata`, `text_handle`) VALUES
(56, 5, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(57, 6, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(58, 7, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(59, 8, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(61, 21, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(62, 22, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(60, 23, 75, 'single', 'none', NULL, 0, 'no', 'no'),
(63, 27, 75, 'single', 'none', NULL, 0, 'no', 'yes');

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

--
-- Contenu de la table `sym_pages`
--

INSERT INTO `sym_pages` (`id`, `parent`, `title`, `handle`, `path`, `params`, `data_sources`, `events`, `sortorder`, `plh_t-en`, `plh_h-en`, `plh_t-fr`, `plh_h-fr`) VALUES
(1, NULL, 'Index', 'index', NULL, NULL, 'javascript,menu,package,pages,plh_page,site_config,sri,build,datetime', 'flang_redirect,login,usedev', 1, 'Index', 'index', 'Index', 'index'),
(2, NULL, '403', '403', NULL, NULL, 'javascript,menu,package,pages,pages_erreurs,plh_page,site_config,sri,build,datetime', 'flang_redirect,login,usedev', 2, '403', '403', '403', '403'),
(3, NULL, '404', '404', NULL, NULL, 'javascript,menu,package,pages,pages_erreurs,plh_page,site_config,sri,build,datetime', 'flang_redirect,login,usedev', 3, '404', '404', '404', '404');

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

--
-- Contenu de la table `sym_pages_types`
--

INSERT INTO `sym_pages_types` (`id`, `page_id`, `type`) VALUES
(12, 1, 'f288-model-default-page'),
(6, 2, '403'),
(9, 3, '404'),
(7, 2, 'f288-hidden'),
(8, 2, 'hidden'),
(10, 3, 'f288-hidden'),
(11, 3, 'hidden'),
(13, 1, 'index');

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

--
-- Contenu de la table `sym_sections`
--

INSERT INTO `sym_sections` (`id`, `name`, `handle`, `sortorder`, `hidden`, `max_entries`, `filter`, `navigation_group`) VALUES
(1, 'Configuration', 'configuration', 1, 'no', 1, 'yes', 'Configuration'),
(2, 'Menu', 'menu', 2, 'no', 6, 'yes', 'Configuration'),
(3, 'Pages d''erreurs', 'pages-derreurs', 3, 'no', 2, 'yes', 'Configuration'),
(4, 'Pages Metas', 'pages-metas', 4, 'no', 0, 'yes', 'Configuration');

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

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