-- http://www.phpmyadmin.net
--
-- Client :  worldwidaone.mysql.db
-- Généré le :  Ven 24 Juin 2016 à 01:03
-- Version du serveur :  5.5.46-0+deb7u1-log
-- Version de PHP :  5.4.45-0+deb7u3




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

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

--
-- Structure de la table `actions`
--

CREATE TABLE IF NOT EXISTS `actions` (
  `aid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Primary Key: Unique actions ID.',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The object that that action acts on (node, user, comment, system or custom types.)',
  `callback` varchar(255) NOT NULL DEFAULT '' COMMENT 'The callback function that executes when the action runs.',
  `parameters` longblob NOT NULL COMMENT 'Parameters to be passed to the callback function.',
  `label` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Label of the action.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores action information.';

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

--
-- Structure de la table `authmap`
--

CREATE TABLE IF NOT EXISTS `authmap` (
  `aid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique authmap ID.',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'User’s users.uid.',
  `authname` varchar(128) NOT NULL DEFAULT '' COMMENT 'Unique authentication name.',
  `module` varchar(128) NOT NULL DEFAULT '' COMMENT 'Module which is controlling the authentication.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores distributed authentication mapping.';

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

--
-- Structure de la table `batch`
--

CREATE TABLE IF NOT EXISTS `batch` (
  `bid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique batch ID.',
  `token` varchar(64) NOT NULL COMMENT 'A string token generated against the current user’s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.',
  `timestamp` int(11) NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.',
  `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores details about batches (processes that run in...';

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

--
-- Structure de la table `block`
--

CREATE TABLE IF NOT EXISTS `block` (
  `bid` int(11) NOT NULL COMMENT 'Primary Key: Unique block ID.',
  `module` varchar(64) NOT NULL DEFAULT '' COMMENT 'The module from which the block originates; for example, ’user’ for the Who’s Online block, and ’block’ for any custom blocks.',
  `delta` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Unique ID for block within a module.',
  `theme` varchar(64) NOT NULL DEFAULT '' COMMENT 'The theme under which the block settings apply.',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Block enabled status. (1 = enabled, 0 = disabled)',
  `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'Block weight within region.',
  `region` varchar(64) NOT NULL DEFAULT '' COMMENT 'Theme region within which the block is set.',
  `custom` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate how users may control visibility of the block. (0 = Users cannot control, 1 = On by default, but can be hidden, 2 = Hidden by default, but can be shown)',
  `visibility` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate how to show blocks on pages. (0 = Show on all pages except listed pages, 1 = Show only on listed pages, 2 = Use custom PHP code to determine visibility)',
  `pages` text NOT NULL COMMENT 'Contents of the "Pages" block; contains either a list of paths on which to include/exclude the block or PHP code, depending on "visibility" setting.',
  `title` varchar(64) NOT NULL DEFAULT '' COMMENT 'Custom title for the block. (Empty string will use block default title, <none> will remove the title, text will cause block to use specified title.)',
  `cache` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Binary flag to indicate block cache mode. (-2: Custom cache, -1: Do not cache, 1: Cache per role, 2: Cache per user, 4: Cache per page, 8: Block cache global) See DRUPAL_CACHE_* constants in ../includes/common.inc for more detailed information.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores block settings, such as region and visibility...';

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

--
-- Structure de la table `blocked_ips`
--

CREATE TABLE IF NOT EXISTS `blocked_ips` (
  `iid` int(10) unsigned NOT NULL COMMENT 'Primary Key: unique ID for IP addresses.',
  `ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP addresses.';

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

--
-- Structure de la table `block_custom`
--

CREATE TABLE IF NOT EXISTS `block_custom` (
  `bid` int(10) unsigned NOT NULL COMMENT 'The block’s block.bid.',
  `body` longtext COMMENT 'Block contents.',
  `info` varchar(128) NOT NULL DEFAULT '' COMMENT 'Block description.',
  `format` varchar(255) DEFAULT NULL COMMENT 'The filter_format.format of the block body.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores contents of custom-made blocks.';

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

--
-- Structure de la table `block_node_type`
--

CREATE TABLE IF NOT EXISTS `block_node_type` (
  `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
  `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
  `type` varchar(32) NOT NULL COMMENT 'The machine-readable name of this type from node_type.type.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up display criteria for blocks based on content types';

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

--
-- Structure de la table `block_role`
--

CREATE TABLE IF NOT EXISTS `block_role` (
  `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
  `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
  `rid` int(10) unsigned NOT NULL COMMENT 'The user’s role ID from users_roles.rid.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up access permissions for blocks based on user roles';

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

--
-- Structure de la table `cache`
--

CREATE TABLE IF NOT EXISTS `cache` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...';

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

--
-- Structure de la table `cache_block`
--

CREATE TABLE IF NOT EXISTS `cache_block` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the Block module to store already built...';

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

--
-- Structure de la table `cache_bootstrap`
--

CREATE TABLE IF NOT EXISTS `cache_bootstrap` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for data required to bootstrap Drupal, may be...';

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

--
-- Structure de la table `cache_field`
--

CREATE TABLE IF NOT EXISTS `cache_field` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...';

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

--
-- Structure de la table `cache_filter`
--

CREATE TABLE IF NOT EXISTS `cache_filter` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the Filter module to store already...';

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

--
-- Structure de la table `cache_form`
--

CREATE TABLE IF NOT EXISTS `cache_form` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the form system to store recently built...';

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

--
-- Structure de la table `cache_image`
--

CREATE TABLE IF NOT EXISTS `cache_image` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table used to store information about image...';

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

--
-- Structure de la table `cache_menu`
--

CREATE TABLE IF NOT EXISTS `cache_menu` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the menu system to store router...';

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

--
-- Structure de la table `cache_page`
--

CREATE TABLE IF NOT EXISTS `cache_page` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table used to store compressed pages for anonymous...';

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

--
-- Structure de la table `cache_path`
--

CREATE TABLE IF NOT EXISTS `cache_path` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for path alias lookup.';

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

--
-- Structure de la table `cache_token`
--

CREATE TABLE IF NOT EXISTS `cache_token` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for token information.';

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

--
-- Structure de la table `cache_views`
--

CREATE TABLE IF NOT EXISTS `cache_views` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...';

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

--
-- Structure de la table `cache_views_data`
--

CREATE TABLE IF NOT EXISTS `cache_views_data` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '1' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for views to store pre-rendered queries,...';

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

--
-- Structure de la table `client`
--

CREATE TABLE IF NOT EXISTS `client` (
  `name` varchar(60) NOT NULL,
  `email` text NOT NULL,
  `datecomande` date NOT NULL,
  `totalcomande` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `client`
--

INSERT INTO `client` (`name`, `email`, `datecomande`, `totalcomande`) VALUES
('joe', 'welcome@goes', '2013-11-26', 0),
('mart', 'deliver', '2013-11-26', 0),
('jo', 'welcome@goes', '2013-11-26', 0),
('art', 'deliver', '2013-11-26', 0),
('Laith Jubair', 'work@hotmail.com', '2013-11-26', 0),
('wer', '', '2013-11-26', 0),
('wewr', '', '2013-11-26', 0),
('Axelor', 'jé', '2013-11-26', 0),
('ASUSTeK', 'hlkhélk', '2013-11-26', 0),
('Administrator', 'dfgfdgfgfd', '2013-11-26', 0),
('qser', 'sdsd', '2013-11-20', 12);

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

--
-- Structure de la table `clientopenerp`
--

CREATE TABLE IF NOT EXISTS `clientopenerp` (
  `id` int(255) NOT NULL,
  `date` date NOT NULL,
  `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `attente_expedition` int(255) NOT NULL,
  `valeur_moyenne` float(10,2) NOT NULL,
  `rapport_annulation` float(10,5) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `clientopenerp`
--

INSERT INTO `clientopenerp` (`id`, `date`, `user`, `attente_expedition`, `valeur_moyenne`, `rapport_annulation`) VALUES
(21, '2012-12-17', 'Jean Bon', 7, 1190.09, 0.07645),
(20, '2012-12-01', 'Anne Aunime', 18, 2081.16, 0.04006),
(6, '2012-12-01', 'ASUStek', 12, 3043.65, 0.13793),
(7, '2012-12-06', 'Leclerc', 12, 3043.65, 0.13793),
(8, '2012-12-08', 'Subprime SÃ RL', 12, 3043.65, 0.13793),
(9, '2012-12-08', 'Subprime SÃ RL', 12, 3043.65, 0.13793),
(10, '2012-12-08', 'Albert le vert', 12, 3043.65, 0.13793),
(11, '2012-12-11', 'Fabien Dupont', 14, 2821.70, 0.13333),
(13, '2012-12-11', 'Albert le vert', 14, 2821.70, 0.12903),
(16, '2012-12-11', 'Albert le vert', 17, 2529.80, 0.12121),
(17, '2012-12-11', 'Axelor', 18, 2443.67, 0.11765),
(18, '2012-12-11', 'Albert le vert', 19, 2442.15, 0.11429),
(19, '2012-12-11', 'Albert le vert', 20, 2366.60, 0.11111),
(22, '2012-12-13', 'Jean Bon', 18, 3768.11, 0.16830),
(23, '2012-12-07', 'Sam Enerve', 20, 3061.56, 0.18462),
(24, '2012-12-17', 'Sam Enerve', 17, 4594.16, 0.10093),
(25, '2012-12-04', 'Subprime SARL', 19, 2806.51, 0.01817),
(26, '2012-12-15', 'Subprime SARL', 13, 280.95, 0.10329),
(27, '2012-12-02', 'Albert le vert', 14, 560.57, 0.07014),
(28, '2012-12-14', 'Anne Aunime', 11, 3992.37, 0.06001),
(29, '2012-12-11', 'Subprime SARL', 9, 1953.60, 0.19856),
(30, '2012-12-17', 'Albert le vert', 21, 1028.43, 0.04246),
(31, '2012-12-07', 'Albert le vert', 13, 457.53, 0.06766),
(32, '2012-12-15', 'Anne Aunime', 9, 3230.73, 0.01995),
(33, '2012-12-01', 'Albert le vert', 17, 3657.51, 0.12776),
(34, '2012-12-15', 'Jean Bon', 14, 2064.47, 0.15688),
(35, '2012-12-18', 'Sam Enerve', 4, 1431.03, 0.02170),
(36, '2012-12-16', 'Sam Enerve', 12, 2280.12, 0.03270),
(37, '2012-12-16', 'Anne Aunime', 18, 4868.27, 0.10416),
(38, '2012-12-10', 'Sam Enerve', 0, 4867.36, 0.02891),
(39, '2012-12-05', 'Jean Bon', 19, 1957.66, 0.19152),
(40, '2012-12-16', 'Jean Bon', 0, 1625.59, 0.05804),
(41, '2012-12-02', 'Sam Enerve', 14, 1442.43, 0.07054),
(42, '2012-12-14', 'Sam Enerve', 13, 500.09, 0.15205),
(43, '2012-12-08', 'Jean Bon', 5, 3884.87, 0.10568),
(44, '2012-12-15', 'Jean Bon', 9, 4537.43, 0.00996),
(45, '2012-12-01', 'Sam Enerve', 4, 2613.29, 0.10333),
(46, '2012-12-16', 'Subprime SARL', 4, 3343.80, 0.02549),
(47, '2012-12-03', 'Subprime SARL', 8, 1879.04, 0.19227),
(48, '2012-12-14', 'Jean Bon', 3, 1731.92, 0.12215),
(49, '2012-12-17', 'Albert le vert', 20, 2373.39, 0.10187),
(50, '2012-12-04', 'Sam Enerve', 21, 2553.37, 0.10832),
(51, '2012-12-02', 'Subprime SARL', 1, 4228.65, 0.18795),
(52, '2012-12-07', 'Albert le vert', 3, 4580.93, 0.17950),
(53, '2012-12-10', 'Anne Aunime', 1, 2660.14, 0.07526),
(54, '2012-12-03', 'Anne Aunime', 4, 1683.00, 0.00147),
(55, '2012-12-04', 'Jean Bon', 15, 156.52, 0.00792),
(56, '2012-12-15', 'Subprime SARL', 5, 4399.33, 0.11641),
(57, '2012-12-02', 'Anne Aunime', 11, 3201.05, 0.16309),
(58, '2012-12-09', 'Subprime SARL', 16, 3766.20, 0.01329),
(59, '2012-12-15', 'Albert le vert', 19, 3228.21, 0.16340),
(60, '2012-12-05', 'Subprime SARL', 7, 1649.13, 0.02321),
(61, '2012-12-05', 'Albert le vert', 17, 3658.01, 0.08485),
(62, '2012-12-08', 'Jean Bon', 18, 3945.35, 0.06883),
(63, '2012-12-01', 'Sam Enerve', 1, 2642.98, 0.13806),
(64, '2012-12-11', 'Sam Enerve', 2, 2756.91, 0.01762),
(65, '2012-12-02', 'Albert le vert', 1, 1200.13, 0.08478),
(66, '2012-12-10', 'Jean Bon', 6, 3832.47, 0.09832),
(67, '2012-12-05', 'Sam Enerve', 14, 2257.25, 0.05618),
(68, '2012-12-17', 'Anne Aunime', 12, 2506.91, 0.05929),
(69, '2012-12-16', 'Sam Enerve', 20, 3877.26, 0.05632),
(70, '2012-12-15', 'Jean Bon', 2, 1416.28, 0.16186),
(71, '2012-12-12', 'Subprime SARL', 3, 2963.61, 0.08288),
(72, '2012-12-05', 'Sam Enerve', 10, 4911.72, 0.05000),
(73, '2012-12-07', 'Jean Bon', 9, 1404.35, 0.12166),
(74, '2012-12-14', 'Subprime SARL', 4, 1664.07, 0.17142),
(75, '2012-12-04', 'Anne Aunime', 7, 235.27, 0.04026),
(76, '2012-12-11', 'Albert le vert', 10, 2169.92, 0.14738),
(77, '2012-12-10', 'Jean Bon', 13, 2090.58, 0.04791),
(78, '2012-12-15', 'Subprime SARL', 19, 4992.73, 0.01206),
(79, '2012-12-06', 'Jean Bon', 3, 3105.16, 0.12476),
(80, '2012-12-18', 'Albert le vert', 21, 2605.14, 0.11111),
(81, '2012-12-18', 'Albert le vert', 22, 2526.23, 0.10811),
(82, '2012-12-18', 'Albert le vert', 22, 2526.23, 0.10526),
(83, '2012-12-18', 'Albert le vert', 22, 2526.23, 0.10526),
(84, '2012-12-18', 'Albert le vert', 23, 2457.81, 0.10526);

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

--
-- Structure de la table `commandpdt`
--

CREATE TABLE IF NOT EXISTS `commandpdt` (
  `id` int(11) NOT NULL,
  `dateDuJour` date NOT NULL,
  `dateCreation` date NOT NULL,
  `produits` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `commandpdt`
--

INSERT INTO `commandpdt` (`id`, `dateDuJour`, `dateCreation`, `produits`) VALUES
(1, '2013-12-16', '2013-12-16', 32),
(2, '2013-05-14', '2013-05-14', 87),
(3, '2013-01-17', '2013-01-14', 66),
(4, '2013-07-26', '2013-07-21', 40),
(5, '2013-09-18', '2013-09-15', 13),
(6, '2013-11-27', '2013-11-22', 89),
(18, '2013-11-08', '2013-11-06', 5),
(20, '2012-03-12', '2012-03-09', 41),
(115, '2011-12-09', '2011-12-10', 50),
(24, '2013-02-15', '2013-02-08', 37),
(25, '2013-01-15', '2013-01-12', 20),
(26, '2013-09-17', '2013-09-15', 78),
(27, '2013-05-02', '2013-05-01', 185),
(28, '2013-06-22', '2013-06-18', 50),
(29, '2013-07-09', '2013-07-08', 112),
(30, '2013-11-02', '2013-11-02', 101),
(114, '2011-11-22', '2011-12-25', 79),
(110, '2011-11-15', '2011-11-15', 17),
(112, '2011-11-23', '2011-10-25', 85),
(113, '2011-12-13', '2011-12-10', 78),
(108, '2011-11-13', '2011-11-11', 60),
(107, '2011-11-03', '2011-11-11', 60),
(38, '2013-02-13', '2013-02-11', 52),
(106, '2011-11-16', '2011-11-14', 178),
(40, '2013-03-05', '2013-03-03', 20),
(41, '2012-07-20', '2012-07-20', 51),
(42, '2012-11-05', '2012-11-02', 39),
(43, '2012-05-09', '2012-05-04', 66),
(44, '2012-12-11', '2012-12-07', 49),
(45, '2012-11-07', '2012-11-06', 48),
(46, '2012-09-06', '2012-09-01', 104),
(47, '2012-10-20', '2012-10-15', 73),
(48, '2012-01-15', '2012-01-11', 80),
(105, '2011-11-03', '2011-11-10', 58),
(109, '2011-11-03', '2011-11-11', 60),
(51, '2012-02-22', '2012-02-18', 47),
(52, '2012-02-18', '2012-02-15', 64),
(53, '2012-03-05', '2012-03-01', 142),
(54, '2012-04-19', '2012-04-14', 89),
(55, '2012-04-16', '2012-04-13', 61),
(56, '2012-01-09', '2012-01-07', 89),
(57, '2012-01-13', '2012-01-09', 28),
(58, '2012-03-17', '2012-03-12', 12),
(59, '2012-08-18', '2012-08-15', 35),
(60, '2012-10-16', '2012-10-14', 15),
(61, '2012-02-11', '2012-02-06', 101),
(62, '2012-04-22', '2012-04-17', 52),
(63, '2012-01-14', '2012-01-09', 62),
(64, '2012-09-09', '2012-09-09', 132),
(65, '2012-01-11', '2012-01-09', 117),
(66, '2012-01-06', '2012-01-04', 21),
(67, '2012-05-04', '2012-05-01', 61),
(68, '2012-03-12', '2012-03-10', 108),
(69, '2012-04-16', '2012-04-16', 52),
(70, '2012-08-19', '2012-08-16', 61),
(71, '2012-09-23', '2012-09-21', 3),
(72, '2012-06-14', '2012-06-09', 98),
(73, '2012-02-08', '2012-02-05', 105),
(74, '2012-02-22', '2012-02-19', 137),
(75, '2012-01-10', '2012-01-05', 147),
(76, '2012-06-12', '2012-06-07', 120),
(77, '2012-05-07', '2012-05-05', 88),
(78, '2012-09-20', '2012-09-19', 82),
(79, '2012-04-25', '2012-04-21', 106),
(80, '2012-06-10', '2012-06-07', 15),
(81, '2012-12-11', '2012-12-09', 28),
(82, '2012-07-13', '2012-07-10', 87),
(83, '2012-05-15', '2012-05-12', 69),
(84, '2012-04-12', '2012-04-10', 83),
(85, '2012-10-20', '2012-10-18', 96),
(86, '2012-07-20', '2012-07-15', 117),
(87, '2012-06-08', '2012-06-04', 117),
(88, '2012-12-15', '2012-12-14', 92),
(89, '2012-06-09', '2012-06-05', 134),
(90, '2013-01-22', '2013-01-19', 137),
(91, '2012-03-20', '2012-03-17', 113),
(92, '2013-01-11', '2013-01-10', 149),
(93, '2012-09-07', '2012-09-05', 42),
(94, '2012-09-10', '2012-09-09', 28),
(95, '2013-11-22', '2013-11-18', 108),
(96, '2012-12-08', '2012-12-07', 137),
(97, '2012-08-12', '2012-08-07', 127),
(98, '2012-05-11', '2012-05-06', 40),
(99, '2012-03-22', '2012-03-18', 145),
(100, '2012-04-12', '2012-04-11', 51),
(101, '2012-06-10', '2012-06-09', 131),
(102, '2013-12-18', '2013-12-18', 121),
(104, '2012-12-18', '2012-12-18', 200);

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

--
-- Structure de la table `comment`
--

CREATE TABLE IF NOT EXISTS `comment` (
  `cid` int(11) NOT NULL COMMENT 'Primary Key: Unique comment ID.',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT 'The comment.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment.',
  `nid` int(11) NOT NULL DEFAULT '0' COMMENT 'The node.nid to which this comment is a reply.',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'The users.uid who authored the comment. If set to 0, this comment was created by an anonymous user.',
  `subject` varchar(64) NOT NULL DEFAULT '' COMMENT 'The comment title.',
  `hostname` varchar(128) NOT NULL DEFAULT '' COMMENT 'The author’s host name.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'The time that the comment was created, as a Unix timestamp.',
  `changed` int(11) NOT NULL DEFAULT '0' COMMENT 'The time that the comment was last edited, as a Unix timestamp.',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'The published status of a comment. (0 = Not Published, 1 = Published)',
  `thread` varchar(255) NOT NULL COMMENT 'The vancode representation of the comment’s place in a thread.',
  `name` varchar(60) DEFAULT NULL COMMENT 'The comment author’s name. Uses users.name if the user is logged in, otherwise uses the value typed into the comment form.',
  `mail` varchar(64) DEFAULT NULL COMMENT 'The comment author’s e-mail address from the comment form, if user is anonymous, and the ’Anonymous users may/must leave their contact information’ setting is turned on.',
  `homepage` varchar(255) DEFAULT NULL COMMENT 'The comment author’s home page address from the comment form, if user is anonymous, and the ’Anonymous users may/must leave their contact information’ setting is turned on.',
  `language` varchar(12) NOT NULL DEFAULT '' COMMENT 'The languages.language of this comment.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores comments and associated data.';

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

--
-- Structure de la table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `cid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique category ID.',
  `category` varchar(255) NOT NULL DEFAULT '' COMMENT 'Category name.',
  `recipients` longtext NOT NULL COMMENT 'Comma-separated list of recipient e-mail addresses.',
  `reply` longtext NOT NULL COMMENT 'Text of the auto-reply message.',
  `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'The category’s weight.',
  `selected` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate whether or not category is selected by default. (1 = Yes, 0 = No)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contact form category settings.';

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

--
-- Structure de la table `context`
--

CREATE TABLE IF NOT EXISTS `context` (
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'The primary identifier for a context.',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT 'Description for this context.',
  `tag` varchar(255) NOT NULL DEFAULT '' COMMENT 'Tag for this context.',
  `conditions` text COMMENT 'Serialized storage of all context condition settings.',
  `reactions` text COMMENT 'Serialized storage of all context reaction settings.',
  `condition_mode` int(11) DEFAULT '0' COMMENT 'Condition mode for this context.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Storage for normal (user-defined) contexts.';

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

--
-- Structure de la table `continents`
--

CREATE TABLE IF NOT EXISTS `continents` (
  `code` char(2) NOT NULL COMMENT 'Continent code',
  `name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Contenu de la table `continents`
--

INSERT INTO `continents` (`code`, `name`) VALUES
('AF', 'Africa'),
('AN', 'Antarctica'),
('AS', 'Asia'),
('EU', 'Europe'),
('NA', 'North America'),
('OC', 'Oceania'),
('SA', 'South America');

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

--
-- Structure de la table `countries`
--

CREATE TABLE IF NOT EXISTS `countries` (
  `country_id` int(11) NOT NULL,
  `code` char(2) NOT NULL COMMENT 'Two-letter country code (ISO 3166-1 alpha-2)',
  `name` varchar(64) NOT NULL COMMENT 'English country name',
  `full_name` varchar(128) NOT NULL COMMENT 'Full English country name',
  `iso3` char(3) NOT NULL COMMENT 'Three-letter country code (ISO 3166-1 alpha-3)',
  `number` smallint(3) unsigned zerofill NOT NULL COMMENT 'Three-digit country number (ISO 3166-1 numeric)',
  `continent_code` char(2) NOT NULL,
  `display_order` int(3) NOT NULL DEFAULT '900'
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Contenu de la table `countries`
--

INSERT INTO `countries` (`country_id`, `code`, `name`, `full_name`, `iso3`, `number`, `continent_code`, `display_order`) VALUES
(1, 'AD', 'Andorra', 'Principality of Andorra', 'AND', 020, 'EU', 7),
(2, 'AE', 'United Arab Emirates', 'United Arab Emirates', 'ARE', 784, 'AS', 232),
(3, 'AF', 'Afghanistan', 'Islamic Republic of Afghanistan', 'AFG', 004, 'AS', 3),
(4, 'AG', 'Antigua and Barbuda', 'Antigua and Barbuda', 'ATG', 028, 'NA', 11),
(5, 'AI', 'Anguilla', 'Anguilla', 'AIA', 660, 'NA', 9),
(6, 'AL', 'Albania', 'Republic of Albania', 'ALB', 008, 'EU', 4),
(7, 'AM', 'Armenia', 'Republic of Armenia', 'ARM', 051, 'AS', 13),
(8, 'AN', 'Netherlands Antilles', 'Netherlands Antilles', 'ANT', 530, 'NA', 157),
(9, 'AO', 'Angola', 'Republic of Angola', 'AGO', 024, 'AF', 8),
(10, 'AQ', 'Antarctica', 'Antarctica (the territory South of 60 deg S)', 'ATA', 010, 'AN', 10),
(11, 'AR', 'Argentina', 'Argentine Republic', 'ARG', 032, 'SA', 12),
(12, 'AS', 'American Samoa', 'American Samoa', 'ASM', 016, 'OC', 6),
(13, 'AT', 'Austria', 'Republic of Austria', 'AUT', 040, 'EU', 16),
(14, 'AU', 'Australia', 'Commonwealth of Australia', 'AUS', 036, 'OC', 15),
(15, 'AW', 'Aruba', 'Aruba', 'ABW', 533, 'NA', 14),
(16, 'AX', 'Åland', 'Åland Islands', 'ALA', 248, 'EU', 246),
(17, 'AZ', 'Azerbaijan', 'Republic of Azerbaijan', 'AZE', 031, 'AS', 17),
(18, 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH', 070, 'EU', 29),
(19, 'BB', 'Barbados', 'Barbados', 'BRB', 052, 'NA', 21),
(20, 'BD', 'Bangladesh', 'People''s Republic of Bangladesh', 'BGD', 050, 'AS', 20),
(21, 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL', 056, 'EU', 23),
(22, 'BF', 'Burkina Faso', 'Burkina Faso', 'BFA', 854, 'AF', 37),
(23, 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR', 100, 'EU', 36),
(24, 'BH', 'Bahrain', 'Kingdom of Bahrain', 'BHR', 048, 'AS', 19),
(25, 'BI', 'Burundi', 'Republic of Burundi', 'BDI', 108, 'AF', 38),
(26, 'BJ', 'Benin', 'Republic of Benin', 'BEN', 204, 'AF', 25),
(27, 'BL', 'Saint Barthélemy', 'Saint Barthelemy', 'BLM', 652, 'NA', 185),
(28, 'BM', 'Bermuda', 'Bermuda', 'BMU', 060, 'NA', 26),
(29, 'BN', 'Brunei Darussalam', 'Brunei Darussalam', 'BRN', 096, 'AS', 35),
(30, 'BO', 'Bolivia', 'Republic of Bolivia', 'BOL', 068, 'SA', 28),
(31, 'BR', 'Brazil', 'Federative Republic of Brazil', 'BRA', 076, 'SA', 32),
(32, 'BS', 'Bahamas', 'Commonwealth of the Bahamas', 'BHS', 044, 'NA', 18),
(33, 'BT', 'Bhutan', 'Kingdom of Bhutan', 'BTN', 064, 'AS', 27),
(34, 'BV', 'Bouvet Island', 'Bouvet Island (Bouvetoya)', 'BVT', 074, 'AN', 31),
(35, 'BW', 'Botswana', 'Republic of Botswana', 'BWA', 072, 'AF', 30),
(36, 'BY', 'Belarus', 'Republic of Belarus', 'BLR', 112, 'EU', 22),
(37, 'BZ', 'Belize', 'Belize', 'BLZ', 084, 'NA', 24),
(38, 'CA', 'Canada', 'Canada', 'CAN', 124, 'NA', 2),
(39, 'CC', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'CCK', 166, 'AS', 48),
(40, 'CD', 'Congo (Kinshasa)', 'Democratic Republic of the Congo', 'COD', 180, 'AF', 51),
(41, 'CF', 'Central African Republic', 'Central African Republic', 'CAF', 140, 'AF', 43),
(42, 'CG', 'Congo (Brazzaville)', 'Republic of the Congo', 'COG', 178, 'AF', 52),
(43, 'CH', 'Switzerland', 'Swiss Confederation', 'CHE', 756, 'EU', 214),
(44, 'CI', 'Côte d''Ivoire', 'Republic of Cote d''Ivoire', 'CIV', 384, 'AF', 55),
(45, 'CK', 'Cook Islands', 'Cook Islands', 'COK', 184, 'OC', 53),
(46, 'CL', 'Chile', 'Republic of Chile', 'CHL', 152, 'SA', 45),
(47, 'CM', 'Cameroon', 'Republic of Cameroon', 'CMR', 120, 'AF', 40),
(48, 'CN', 'China', 'People''s Republic of China', 'CHN', 156, 'AS', 46),
(49, 'CO', 'Colombia', 'Republic of Colombia', 'COL', 170, 'SA', 49),
(50, 'CR', 'Costa Rica', 'Republic of Costa Rica', 'CRI', 188, 'NA', 54),
(51, 'CU', 'Cuba', 'Republic of Cuba', 'CUB', 192, 'NA', 57),
(52, 'CV', 'Cape Verde', 'Republic of Cape Verde', 'CPV', 132, 'AF', 41),
(53, 'CX', 'Christmas Island', 'Christmas Island', 'CXR', 162, 'AS', 47),
(54, 'CY', 'Cyprus', 'Republic of Cyprus', 'CYP', 196, 'AS', 58),
(55, 'CZ', 'Czech Republic', 'Czech Republic', 'CZE', 203, 'EU', 59),
(56, 'DE', 'Germany', 'Federal Republic of Germany', 'DEU', 276, 'EU', 82),
(57, 'DJ', 'Djibouti', 'Republic of Djibouti', 'DJI', 262, 'AF', 61),
(58, 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK', 208, 'EU', 60),
(59, 'DM', 'Dominica', 'Commonwealth of Dominica', 'DMA', 212, 'NA', 62),
(60, 'DO', 'Dominican Republic', 'Dominican Republic', 'DOM', 214, 'NA', 63),
(61, 'DZ', 'Algeria', 'People''s Democratic Republic of Algeria', 'DZA', 012, 'AF', 5),
(62, 'EC', 'Ecuador', 'Republic of Ecuador', 'ECU', 218, 'SA', 64),
(63, 'EE', 'Estonia', 'Republic of Estonia', 'EST', 233, 'EU', 69),
(64, 'EG', 'Egypt', 'Arab Republic of Egypt', 'EGY', 818, 'AF', 65),
(65, 'EH', 'Western Sahara', 'Western Sahara', 'ESH', 732, 'AF', 242),
(66, 'ER', 'Eritrea', 'State of Eritrea', 'ERI', 232, 'AF', 68),
(67, 'ES', 'Spain', 'Kingdom of Spain', 'ESP', 724, 'EU', 207),
(68, 'ET', 'Ethiopia', 'Federal Democratic Republic of Ethiopia', 'ETH', 231, 'AF', 70),
(69, 'FI', 'Finland', 'Republic of Finland', 'FIN', 246, 'EU', 74),
(70, 'FJ', 'Fiji', 'Republic of the Fiji Islands', 'FJI', 242, 'OC', 73),
(71, 'FK', 'Falkland Islands', 'Falkland Islands (Malvinas)', 'FLK', 238, 'SA', 71),
(72, 'FM', 'Micronesia', 'Federated States of Micronesia', 'FSM', 583, 'OC', 144),
(73, 'FO', 'Faroe Islands', 'Faroe Islands', 'FRO', 234, 'EU', 72),
(74, 'FR', 'France', 'French Republic', 'FRA', 250, 'EU', 75),
(75, 'GA', 'Gabon', 'Gabonese Republic', 'GAB', 266, 'AF', 79),
(76, 'GB', 'United Kingdom', 'United Kingdom of Great Britain & Northern Ireland', 'GBR', 826, 'EU', 233),
(77, 'GD', 'Grenada', 'Grenada', 'GRD', 308, 'NA', 87),
(78, 'GE', 'Georgia', 'Georgia', 'GEO', 268, 'AS', 81),
(79, 'GF', 'French Guiana', 'French Guiana', 'GUF', 254, 'SA', 76),
(80, 'GG', 'Guernsey', 'Bailiwick of Guernsey', 'GGY', 831, 'EU', 91),
(81, 'GH', 'Ghana', 'Republic of Ghana', 'GHA', 288, 'AF', 83),
(82, 'GI', 'Gibraltar', 'Gibraltar', 'GIB', 292, 'EU', 84),
(83, 'GL', 'Greenland', 'Greenland', 'GRL', 304, 'NA', 86),
(84, 'GM', 'Gambia', 'Republic of the Gambia', 'GMB', 270, 'AF', 80),
(85, 'GN', 'Guinea', 'Republic of Guinea', 'GIN', 324, 'AF', 92),
(86, 'GP', 'Guadeloupe', 'Guadeloupe', 'GLP', 312, 'NA', 88),
(87, 'GQ', 'Equatorial Guinea', 'Republic of Equatorial Guinea', 'GNQ', 226, 'AF', 67),
(88, 'GR', 'Greece', 'Hellenic Republic Greece', 'GRC', 300, 'EU', 85),
(89, 'GS', 'South Georgia and South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'SGS', 239, 'AN', 206),
(90, 'GT', 'Guatemala', 'Republic of Guatemala', 'GTM', 320, 'NA', 90),
(91, 'GU', 'Guam', 'Guam', 'GUM', 316, 'OC', 89),
(92, 'GW', 'Guinea-Bissau', 'Republic of Guinea-Bissau', 'GNB', 624, 'AF', 93),
(93, 'GY', 'Guyana', 'Co-operative Republic of Guyana', 'GUY', 328, 'SA', 94),
(94, 'HK', 'Hong Kong', 'Hong Kong Special Administrative Region of China', 'HKG', 344, 'AS', 99),
(95, 'HM', 'Heard and McDonald Islands', 'Heard Island and McDonald Islands', 'HMD', 334, 'AN', 96),
(96, 'HN', 'Honduras', 'Republic of Honduras', 'HND', 340, 'NA', 98),
(97, 'HR', 'Croatia', 'Republic of Croatia', 'HRV', 191, 'EU', 56),
(98, 'HT', 'Haiti', 'Republic of Haiti', 'HTI', 332, 'NA', 95),
(99, 'HU', 'Hungary', 'Republic of Hungary', 'HUN', 348, 'EU', 100),
(100, 'ID', 'Indonesia', 'Republic of Indonesia', 'IDN', 360, 'AS', 103),
(101, 'IE', 'Ireland', 'Ireland', 'IRL', 372, 'EU', 106),
(102, 'IL', 'Israel', 'State of Israel', 'ISR', 376, 'AS', 108),
(103, 'IM', 'Isle of Man', 'Isle of Man', 'IMN', 833, 'EU', 107),
(104, 'IN', 'India', 'Republic of India', 'IND', 356, 'AS', 102),
(105, 'IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory (Chagos Archipelago)', 'IOT', 086, 'AS', 33),
(106, 'IQ', 'Iraq', 'Republic of Iraq', 'IRQ', 368, 'AS', 105),
(107, 'IR', 'Iran', 'Islamic Republic of Iran', 'IRN', 364, 'AS', 104),
(108, 'IS', 'Iceland', 'Republic of Iceland', 'ISL', 352, 'EU', 101),
(109, 'IT', 'Italy', 'Italian Republic', 'ITA', 380, 'EU', 109),
(110, 'JE', 'Jersey', 'Bailiwick of Jersey', 'JEY', 832, 'EU', 112),
(111, 'JM', 'Jamaica', 'Jamaica', 'JAM', 388, 'NA', 110),
(112, 'JO', 'Jordan', 'Hashemite Kingdom of Jordan', 'JOR', 400, 'AS', 113),
(113, 'JP', 'Japan', 'Japan', 'JPN', 392, 'AS', 111),
(114, 'KE', 'Kenya', 'Republic of Kenya', 'KEN', 404, 'AF', 115),
(115, 'KG', 'Kyrgyzstan', 'Kyrgyz Republic', 'KGZ', 417, 'AS', 120),
(116, 'KH', 'Cambodia', 'Kingdom of Cambodia', 'KHM', 116, 'AS', 39),
(117, 'KI', 'Kiribati', 'Republic of Kiribati', 'KIR', 296, 'OC', 116),
(118, 'KM', 'Comoros', 'Union of the Comoros', 'COM', 174, 'AF', 50),
(119, 'KN', 'Saint Kitts and Nevis', 'Federation of Saint Kitts and Nevis', 'KNA', 659, 'NA', 187),
(120, 'KP', 'Korea, North', 'Democratic People''s Republic of Korea', 'PRK', 408, 'AS', 117),
(121, 'KR', 'Korea, South', 'Republic of Korea', 'KOR', 410, 'AS', 118),
(122, 'KW', 'Kuwait', 'State of Kuwait', 'KWT', 414, 'AS', 119),
(123, 'KY', 'Cayman Islands', 'Cayman Islands', 'CYM', 136, 'NA', 42),
(124, 'KZ', 'Kazakhstan', 'Republic of Kazakhstan', 'KAZ', 398, 'AS', 114),
(125, 'LA', 'Laos', 'Lao People''s Democratic Republic', 'LAO', 418, 'AS', 121),
(126, 'LB', 'Lebanon', 'Lebanese Republic', 'LBN', 422, 'AS', 123),
(127, 'LC', 'Saint Lucia', 'Saint Lucia', 'LCA', 662, 'NA', 188),
(128, 'LI', 'Liechtenstein', 'Principality of Liechtenstein', 'LIE', 438, 'EU', 127),
(129, 'LK', 'Sri Lanka', 'Democratic Socialist Republic of Sri Lanka', 'LKA', 144, 'AS', 208),
(130, 'LR', 'Liberia', 'Republic of Liberia', 'LBR', 430, 'AF', 125),
(131, 'LS', 'Lesotho', 'Kingdom of Lesotho', 'LSO', 426, 'AF', 124),
(132, 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU', 440, 'EU', 128),
(133, 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX', 442, 'EU', 129),
(134, 'LV', 'Latvia', 'Republic of Latvia', 'LVA', 428, 'EU', 122),
(135, 'LY', 'Libya', 'Libyan Arab Jamahiriya', 'LBY', 434, 'AF', 126),
(136, 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR', 504, 'AF', 150),
(137, 'MC', 'Monaco', 'Principality of Monaco', 'MCO', 492, 'EU', 146),
(138, 'MD', 'Moldova', 'Republic of Moldova', 'MDA', 498, 'EU', 145),
(139, 'ME', 'Montenegro', 'Republic of Montenegro', 'MNE', 499, 'EU', 148),
(140, 'MF', 'Saint Martin (French part)', 'Saint Martin', 'MAF', 663, 'NA', 189),
(141, 'MG', 'Madagascar', 'Republic of Madagascar', 'MDG', 450, 'AF', 132),
(142, 'MH', 'Marshall Islands', 'Republic of the Marshall Islands', 'MHL', 584, 'OC', 138),
(143, 'MK', 'Macedonia', 'Republic of Macedonia', 'MKD', 807, 'EU', 131),
(144, 'ML', 'Mali', 'Republic of Mali', 'MLI', 466, 'AF', 136),
(145, 'MM', 'Myanmar', 'Union of Myanmar', 'MMR', 104, 'AS', 152),
(146, 'MN', 'Mongolia', 'Mongolia', 'MNG', 496, 'AS', 147),
(147, 'MO', 'Macau', 'Macao Special Administrative Region of China', 'MAC', 446, 'AS', 130),
(148, 'MP', 'Northern Mariana Islands', 'Commonwealth of the Northern Mariana Islands', 'MNP', 580, 'OC', 165),
(149, 'MQ', 'Martinique', 'Martinique', 'MTQ', 474, 'NA', 139),
(150, 'MR', 'Mauritania', 'Islamic Republic of Mauritania', 'MRT', 478, 'AF', 140),
(151, 'MS', 'Montserrat', 'Montserrat', 'MSR', 500, 'NA', 149),
(152, 'MT', 'Malta', 'Republic of Malta', 'MLT', 470, 'EU', 137),
(153, 'MU', 'Mauritius', 'Republic of Mauritius', 'MUS', 480, 'AF', 141),
(154, 'MV', 'Maldives', 'Republic of Maldives', 'MDV', 462, 'AS', 135),
(155, 'MW', 'Malawi', 'Republic of Malawi', 'MWI', 454, 'AF', 133),
(156, 'MX', 'Mexico', 'United Mexican States', 'MEX', 484, 'NA', 143),
(157, 'MY', 'Malaysia', 'Malaysia', 'MYS', 458, 'AS', 134),
(158, 'MZ', 'Mozambique', 'Republic of Mozambique', 'MOZ', 508, 'AF', 151),
(159, 'NA', 'Namibia', 'Republic of Namibia', 'NAM', 516, 'AF', 153),
(160, 'NC', 'New Caledonia', 'New Caledonia', 'NCL', 540, 'OC', 158),
(161, 'NE', 'Niger', 'Republic of Niger', 'NER', 562, 'AF', 161),
(162, 'NF', 'Norfolk Island', 'Norfolk Island', 'NFK', 574, 'OC', 164),
(163, 'NG', 'Nigeria', 'Federal Republic of Nigeria', 'NGA', 566, 'AF', 162),
(164, 'NI', 'Nicaragua', 'Republic of Nicaragua', 'NIC', 558, 'NA', 160),
(165, 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD', 528, 'EU', 156),
(166, 'NO', 'Norway', 'Kingdom of Norway', 'NOR', 578, 'EU', 166),
(167, 'NP', 'Nepal', 'State of Nepal', 'NPL', 524, 'AS', 155),
(168, 'NR', 'Nauru', 'Republic of Nauru', 'NRU', 520, 'OC', 154),
(169, 'NU', 'Niue', 'Niue', 'NIU', 570, 'OC', 163),
(170, 'NZ', 'New Zealand', 'New Zealand', 'NZL', 554, 'OC', 159),
(171, 'OM', 'Oman', 'Sultanate of Oman', 'OMN', 512, 'AS', 167),
(172, 'PA', 'Panama', 'Republic of Panama', 'PAN', 591, 'NA', 171),
(173, 'PE', 'Peru', 'Republic of Peru', 'PER', 604, 'SA', 174),
(174, 'PF', 'French Polynesia', 'French Polynesia', 'PYF', 258, 'OC', 77),
(175, 'PG', 'Papua New Guinea', 'Independent State of Papua New Guinea', 'PNG', 598, 'OC', 172),
(176, 'PH', 'Philippines', 'Republic of the Philippines', 'PHL', 608, 'AS', 175),
(177, 'PK', 'Pakistan', 'Islamic Republic of Pakistan', 'PAK', 586, 'AS', 168),
(178, 'PL', 'Poland', 'Republic of Poland', 'POL', 616, 'EU', 177),
(179, 'PM', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'SPM', 666, 'NA', 190),
(180, 'PN', 'Pitcairn', 'Pitcairn Islands', 'PCN', 612, 'OC', 176),
(181, 'PR', 'Puerto Rico', 'Commonwealth of Puerto Rico', 'PRI', 630, 'NA', 179),
(182, 'PS', 'Palestine', 'Occupied Palestinian Territory', 'PSE', 275, 'AS', 170),
(183, 'PT', 'Portugal', 'Portuguese Republic', 'PRT', 620, 'EU', 178),
(184, 'PW', 'Palau', 'Republic of Palau', 'PLW', 585, 'OC', 169),
(185, 'PY', 'Paraguay', 'Republic of Paraguay', 'PRY', 600, 'SA', 173),
(186, 'QA', 'Qatar', 'State of Qatar', 'QAT', 634, 'AS', 180),
(187, 'RE', 'Reunion', 'Reunion', 'REU', 638, 'AF', 181),
(188, 'RO', 'Romania', 'Romania', 'ROU', 642, 'EU', 182),
(189, 'RS', 'Serbia', 'Republic of Serbia', 'SRB', 688, 'EU', 197),
(190, 'RU', 'Russian Federation', 'Russian Federation', 'RUS', 643, 'EU', 183),
(191, 'RW', 'Rwanda', 'Republic of Rwanda', 'RWA', 646, 'AF', 184),
(192, 'SA', 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'SAU', 682, 'AS', 195),
(193, 'SB', 'Solomon Islands', 'Solomon Islands', 'SLB', 090, 'OC', 203),
(194, 'SC', 'Seychelles', 'Republic of Seychelles', 'SYC', 690, 'AF', 198),
(195, 'SD', 'Sudan', 'Republic of Sudan', 'SDN', 736, 'AF', 209),
(196, 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE', 752, 'EU', 213),
(197, 'SG', 'Singapore', 'Republic of Singapore', 'SGP', 702, 'AS', 200),
(198, 'SH', 'Saint Helena', 'Saint Helena', 'SHN', 654, 'AF', 186),
(199, 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN', 705, 'EU', 202),
(200, 'SJ', 'Svalbard and Jan Mayen Islands', 'Svalbard & Jan Mayen Islands', 'SJM', 744, 'EU', 211),
(201, 'SK', 'Slovakia', 'Slovakia (Slovak Republic)', 'SVK', 703, 'EU', 201),
(202, 'SL', 'Sierra Leone', 'Republic of Sierra Leone', 'SLE', 694, 'AF', 199),
(203, 'SM', 'San Marino', 'Republic of San Marino', 'SMR', 674, 'EU', 193),
(204, 'SN', 'Senegal', 'Republic of Senegal', 'SEN', 686, 'AF', 196),
(205, 'SO', 'Somalia', 'Somali Republic', 'SOM', 706, 'AF', 204),
(206, 'SR', 'Suriname', 'Republic of Suriname', 'SUR', 740, 'SA', 210),
(207, 'ST', 'Sao Tome and Principe', 'Democratic Republic of Sao Tome and Principe', 'STP', 678, 'AF', 194),
(208, 'SV', 'El Salvador', 'Republic of El Salvador', 'SLV', 222, 'NA', 66),
(209, 'SY', 'Syria', 'Syrian Arab Republic', 'SYR', 760, 'AS', 215),
(210, 'SZ', 'Swaziland', 'Kingdom of Swaziland', 'SWZ', 748, 'AF', 212),
(211, 'TC', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'TCA', 796, 'NA', 228),
(212, 'TD', 'Chad', 'Republic of Chad', 'TCD', 148, 'AF', 44),
(213, 'TF', 'French Southern Lands', 'French Southern Territories', 'ATF', 260, 'AN', 78),
(214, 'TG', 'Togo', 'Togolese Republic', 'TGO', 768, 'AF', 221),
(215, 'TH', 'Thailand', 'Kingdom of Thailand', 'THA', 764, 'AS', 219),
(216, 'TJ', 'Tajikistan', 'Republic of Tajikistan', 'TJK', 762, 'AS', 217),
(217, 'TK', 'Tokelau', 'Tokelau', 'TKL', 772, 'OC', 222),
(218, 'TL', 'Timor-Leste', 'Democratic Republic of Timor-Leste', 'TLS', 626, 'AS', 220),
(219, 'TM', 'Turkmenistan', 'Turkmenistan', 'TKM', 795, 'AS', 227),
(220, 'TN', 'Tunisia', 'Tunisian Republic', 'TUN', 788, 'AF', 225),
(221, 'TO', 'Tonga', 'Kingdom of Tonga', 'TON', 776, 'OC', 223),
(222, 'TR', 'Turkey', 'Republic of Turkey', 'TUR', 792, 'AS', 226),
(223, 'TT', 'Trinidad and Tobago', 'Republic of Trinidad and Tobago', 'TTO', 780, 'NA', 224),
(224, 'TV', 'Tuvalu', 'Tuvalu', 'TUV', 798, 'OC', 229),
(225, 'TW', 'Taiwan', 'Taiwan', 'TWN', 158, 'AS', 216),
(226, 'TZ', 'Tanzania', 'United Republic of Tanzania', 'TZA', 834, 'AF', 218),
(227, 'UA', 'Ukraine', 'Ukraine', 'UKR', 804, 'EU', 231),
(228, 'UG', 'Uganda', 'Republic of Uganda', 'UGA', 800, 'AF', 230),
(229, 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'UMI', 581, 'OC', 234),
(230, 'US', 'United States of America', 'United States of America', 'USA', 840, 'NA', 1),
(231, 'UY', 'Uruguay', 'Eastern Republic of Uruguay', 'URY', 858, 'SA', 236),
(232, 'UZ', 'Uzbekistan', 'Republic of Uzbekistan', 'UZB', 860, 'AS', 237),
(233, 'VA', 'Vatican City', 'Holy See (Vatican City State)', 'VAT', 336, 'EU', 97),
(234, 'VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'VCT', 670, 'NA', 191),
(235, 'VE', 'Venezuela', 'Bolivarian Republic of Venezuela', 'VEN', 862, 'SA', 239),
(236, 'VG', 'Virgin Islands, British', 'British Virgin Islands', 'VGB', 092, 'NA', 34),
(237, 'VI', 'Virgin Islands, U.S.', 'United States Virgin Islands', 'VIR', 850, 'NA', 235),
(238, 'VN', 'Vietnam', 'Socialist Republic of Vietnam', 'VNM', 704, 'AS', 240),
(239, 'VU', 'Vanuatu', 'Republic of Vanuatu', 'VUT', 548, 'OC', 238),
(240, 'WF', 'Wallis and Futuna Islands', 'Wallis and Futuna', 'WLF', 876, 'OC', 241),
(241, 'WS', 'Samoa', 'Independent State of Samoa', 'WSM', 882, 'OC', 192),
(242, 'YE', 'Yemen', 'Yemen', 'YEM', 887, 'AS', 243),
(243, 'YT', 'Mayotte', 'Mayotte', 'MYT', 175, 'AF', 142),
(244, 'ZA', 'South Africa', 'Republic of South Africa', 'ZAF', 710, 'AF', 205),
(245, 'ZM', 'Zambia', 'Republic of Zambia', 'ZMB', 894, 'AF', 244),
(246, 'ZW', 'Zimbabwe', 'Republic of Zimbabwe', 'ZWE', 716, 'AF', 245);

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

--
-- Structure de la table `ctools_css_cache`
--

CREATE TABLE IF NOT EXISTS `ctools_css_cache` (
  `cid` varchar(128) NOT NULL COMMENT 'The CSS ID this cache object belongs to.',
  `filename` varchar(255) DEFAULT NULL COMMENT 'The filename this CSS is stored in.',
  `css` longtext COMMENT 'CSS being stored.',
  `filter` tinyint(4) DEFAULT NULL COMMENT 'Whether or not this CSS needs to be filtered.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A special cache used to store CSS that must be non-volatile.';

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

--
-- Structure de la table `ctools_object_cache`
--

CREATE TABLE IF NOT EXISTS `ctools_object_cache` (
  `sid` varchar(64) NOT NULL COMMENT 'The session ID this cache object belongs to.',
  `name` varchar(128) NOT NULL COMMENT 'The name of the object this cache is attached to.',
  `obj` varchar(32) NOT NULL COMMENT 'The type of the object this cache is attached to; this essentially represents the owner so that several sub-systems can use this cache.',
  `updated` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The time this cache was created or updated.',
  `data` longblob COMMENT 'Serialized data being stored.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A special cache used to store objects that are being...';

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

--
-- Structure de la table `date_formats`
--

CREATE TABLE IF NOT EXISTS `date_formats` (
  `dfid` int(10) unsigned NOT NULL COMMENT 'The date format identifier.',
  `format` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The date format string.',
  `type` varchar(64) NOT NULL COMMENT 'The date format type, e.g. medium.',
  `locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Whether or not this format can be modified.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores configured date formats.';

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

--
-- Structure de la table `date_format_locale`
--

CREATE TABLE IF NOT EXISTS `date_format_locale` (
  `format` varchar(100) NOT NULL COMMENT 'The date format string.',
  `type` varchar(64) NOT NULL COMMENT 'The date format type, e.g. medium.',
  `language` varchar(12) NOT NULL COMMENT 'A languages.language for this format to be used with.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores configured date formats for each locale.';

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

--
-- Structure de la table `date_format_type`
--

CREATE TABLE IF NOT EXISTS `date_format_type` (
  `type` varchar(64) NOT NULL COMMENT 'The date format type, e.g. medium.',
  `title` varchar(255) NOT NULL COMMENT 'The human readable name of the format type.',
  `locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Whether or not this is a system provided format.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores configured date format types.';

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

--
-- Structure de la table `drupal_actions`
--

CREATE TABLE IF NOT EXISTS `drupal_actions` (
  `aid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Primary Key: Unique actions ID.',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The object that that action acts on (node, user, comment, system or custom types.)',
  `callback` varchar(255) NOT NULL DEFAULT '' COMMENT 'The callback function that executes when the action runs.',
  `parameters` longblob NOT NULL COMMENT 'Parameters to be passed to the callback function.',
  `label` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Label of the action.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores action information.';

--
-- Contenu de la table `drupal_actions`
--

INSERT INTO `drupal_actions` (`aid`, `type`, `callback`, `parameters`, `label`) VALUES
('comment_publish_action', 'comment', 'comment_publish_action', '', 'Publish comment'),
('comment_save_action', 'comment', 'comment_save_action', '', 'Save comment'),
('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment'),
('node_make_sticky_action', 'node', 'node_make_sticky_action', '', 'Make content sticky'),
('node_make_unsticky_action', 'node', 'node_make_unsticky_action', '', 'Make content unsticky'),
('node_promote_action', 'node', 'node_promote_action', '', 'Promote content to front page'),
('node_publish_action', 'node', 'node_publish_action', '', 'Publish content'),
('node_save_action', 'node', 'node_save_action', '', 'Save content'),
('node_unpromote_action', 'node', 'node_unpromote_action', '', 'Remove content from front page'),
('node_unpublish_action', 'node', 'node_unpublish_action', '', 'Unpublish content'),
('pathauto_node_update_action', 'node', 'pathauto_node_update_action', '', 'Update node alias'),
('pathauto_taxonomy_term_update_action', 'taxonomy_term', 'pathauto_taxonomy_term_update_action', '', 'Update taxonomy term alias'),
('pathauto_user_update_action', 'user', 'pathauto_user_update_action', '', 'Update user alias'),
('system_block_ip_action', 'user', 'system_block_ip_action', '', 'Ban IP address of current user'),
('user_block_user_action', 'user', 'user_block_user_action', '', 'Block current user');

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

--
-- Structure de la table `drupal_authmap`
--

CREATE TABLE IF NOT EXISTS `drupal_authmap` (
  `aid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique authmap ID.',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'User’s users.uid.',
  `authname` varchar(128) NOT NULL DEFAULT '' COMMENT 'Unique authentication name.',
  `module` varchar(128) NOT NULL DEFAULT '' COMMENT 'Module which is controlling the authentication.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores distributed authentication mapping.';

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

--
-- Structure de la table `drupal_batch`
--

CREATE TABLE IF NOT EXISTS `drupal_batch` (
  `bid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique batch ID.',
  `token` varchar(64) NOT NULL COMMENT 'A string token generated against the current user’s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.',
  `timestamp` int(11) NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.',
  `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores details about batches (processes that run in...';

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

--
-- Structure de la table `drupal_block`
--

CREATE TABLE IF NOT EXISTS `drupal_block` (
  `bid` int(11) NOT NULL COMMENT 'Primary Key: Unique block ID.',
  `module` varchar(64) NOT NULL DEFAULT '' COMMENT 'The module from which the block originates; for example, ’user’ for the Who’s Online block, and ’block’ for any custom blocks.',
  `delta` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Unique ID for block within a module.',
  `theme` varchar(64) NOT NULL DEFAULT '' COMMENT 'The theme under which the block settings apply.',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Block enabled status. (1 = enabled, 0 = disabled)',
  `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'Block weight within region.',
  `region` varchar(64) NOT NULL DEFAULT '' COMMENT 'Theme region within which the block is set.',
  `custom` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate how users may control visibility of the block. (0 = Users cannot control, 1 = On by default, but can be hidden, 2 = Hidden by default, but can be shown)',
  `visibility` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Flag to indicate how to show blocks on pages. (0 = Show on all pages except listed pages, 1 = Show only on listed pages, 2 = Use custom PHP code to determine visibility)',
  `pages` text NOT NULL COMMENT 'Contents of the "Pages" block; contains either a list of paths on which to include/exclude the block or PHP code, depending on "visibility" setting.',
  `title` varchar(64) NOT NULL DEFAULT '' COMMENT 'Custom title for the block. (Empty string will use block default title, <none> will remove the title, text will cause block to use specified title.)',
  `cache` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Binary flag to indicate block cache mode. (-2: Custom cache, -1: Do not cache, 1: Cache per role, 2: Cache per user, 4: Cache per page, 8: Block cache global) See DRUPAL_CACHE_* constants in ../includes/common.inc for more detailed information.'
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='Stores block settings, such as region and visibility...';

--
-- Contenu de la table `drupal_block`
--

INSERT INTO `drupal_block` (`bid`, `module`, `delta`, `theme`, `status`, `weight`, `region`, `custom`, `visibility`, `pages`, `title`, `cache`) VALUES
(1, 'system', 'main', 'bartik', 1, 0, 'content', 0, 0, '', '', -1),
(2, 'search', 'form', 'bartik', 1, -1, 'sidebar_first', 0, 0, '', '<none>', -1),
(3, 'node', 'recent', 'seven', 1, 10, 'dashboard_main', 0, 0, '', '', -1),
(4, 'user', 'login', 'bartik', 1, 0, 'sidebar_first', 0, 0, '', '', -1),
(5, 'system', 'navigation', 'bartik', 1, 0, 'sidebar_first', 0, 0, '', '', -1),
(6, 'system', 'powered-by', 'bartik', 1, 10, 'footer', 0, 0, '', '', -1),
(7, 'system', 'help', 'bartik', 1, 0, 'help', 0, 0, '', '', -1),
(8, 'system', 'main', 'seven', 1, 0, 'content', 0, 0, '', '', -1),
(9, 'system', 'help', 'seven', 1, 0, 'help', 0, 0, '', '', -1),
(10, 'user', 'login', 'seven', 1, 10, 'content', 0, 0, '', '', -1),
(11, 'user', 'new', 'seven', 1, 0, 'dashboard_sidebar', 0, 0, '', '', -1),
(12, 'search', 'form', 'seven', 1, -10, 'dashboard_sidebar', 0, 0, '', '<none>', -1),
(13, 'comment', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(14, 'node', 'syndicate', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(15, 'node', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(16, 'shortcut', 'shortcuts', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(17, 'system', 'management', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(18, 'system', 'user-menu', 'bartik', 0, 0, '-1', 0, 0, '', 'User login', -1),
(19, 'system', 'main-menu', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(20, 'user', 'new', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(21, 'user', 'online', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(22, 'comment', 'recent', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', 1),
(23, 'node', 'syndicate', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(24, 'shortcut', 'shortcuts', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(25, 'system', 'powered-by', 'seven', 0, 10, '-1', 0, 0, '', '', -1),
(26, 'system', 'navigation', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(27, 'system', 'management', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(28, 'system', 'user-menu', 'seven', 0, 0, '-1', 0, 0, '', 'User login', -1),
(29, 'system', 'main-menu', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(30, 'user', 'online', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', -1),
(31, 'comment', 'recent', 'ipress', 0, -16, '-1', 0, 0, '', '', 1),
(32, 'node', 'recent', 'ipress', 0, 0, '-1', 0, 0, '', '', 1),
(33, 'node', 'syndicate', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(34, 'search', 'form', 'ipress', 1, -1, 'search_form', 0, 0, '', '<none>', -1),
(35, 'shortcut', 'shortcuts', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(36, 'system', 'help', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(37, 'system', 'main', 'ipress', 1, 0, 'content', 0, 0, '', '', -1),
(38, 'system', 'main-menu', 'ipress', 1, 0, 'main_menu', 0, 0, '', '<none>', -1),
(39, 'system', 'management', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(40, 'system', 'navigation', 'ipress', 0, -12, '-1', 0, 0, '', '', -1),
(41, 'system', 'powered-by', 'ipress', 0, -8, '-1', 0, 0, '', '', -1),
(42, 'system', 'user-menu', 'ipress', 0, 0, '-1', 0, 0, '', 'User login', -1),
(43, 'user', 'login', 'ipress', 1, -17, 'sidebar_second', 0, 0, '', '', -1),
(44, 'user', 'new', 'ipress', 0, 0, '-1', 0, 0, '', '', 1),
(45, 'user', 'online', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(46, 'block', '1', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(47, 'block', '1', 'ipress', 1, 0, 'ads_banner_right', 0, 0, '', '<none>', -1),
(48, 'block', '1', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(49, 'blog', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(50, 'blog', 'recent', 'ipress', 1, -19, 'sidebar_second', 0, 0, '', '', 1),
(51, 'blog', 'recent', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', 1),
(52, 'context_ui', 'editor', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(53, 'context_ui', 'editor', 'ipress', 0, 0, '-1', 0, 0, '', '', 1),
(54, 'context_ui', 'editor', 'seven', 0, 0, '-1', 0, 0, '', '', 1),
(55, 'views', 'ipress_blocks-block', 'ipress', 1, 0, 'left_bar', 0, 0, '', '<none>', -1),
(56, 'views', 'ipress_blocks-block', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(57, 'views', 'ipress_blocks-block', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(58, 'views', 'ipress_blocks-block_1', 'ipress', 1, 0, 'right_bar', 0, 0, '', '<none>', -1),
(59, 'views', 'ipress_blocks-block_1', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(60, 'views', 'ipress_blocks-block_1', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(61, 'views', 'ipress_blocks-top_news', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(62, 'views', 'ipress_blocks-top_news', 'ipress', 0, 0, '-1', 0, 0, '', '<none>', -1),
(63, 'views', 'ipress_blocks-top_news', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(64, 'views', 'ipress_blocks-post_of_the_day', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(65, 'views', 'ipress_blocks-block_music', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(66, 'views', 'ipress_blocks-post_of_the_day', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(67, 'views', 'ipress_blocks-block_music', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(68, 'views', 'ipress_blocks-post_of_the_day', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(69, 'views', 'ipress_blocks-block_music', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(70, 'views', 'ipress_blocks-top_1_music', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(71, 'views', 'ipress_blocks-top_1_music', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(72, 'views', 'ipress_blocks-top_1_music', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(73, 'views', 'ed71e802979487af45aafa3eb66675fb', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(74, 'views', '1936635ada32a619bf90765da35386a5', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(75, 'views', '04fd750c426e6a8a06c5e00db3b02330', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(76, 'views', '1936635ada32a619bf90765da35386a5', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(77, 'views', 'ed71e802979487af45aafa3eb66675fb', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(78, 'views', '04fd750c426e6a8a06c5e00db3b02330', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(79, 'views', '1936635ada32a619bf90765da35386a5', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(80, 'views', 'ed71e802979487af45aafa3eb66675fb', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(81, 'views', '04fd750c426e6a8a06c5e00db3b02330', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(82, 'block', '2', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(83, 'block', '2', 'ipress', 0, 0, '-1', 0, 0, '', '<none>', -1),
(84, 'block', '2', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(85, 'views', '1b6c69e4e82a11c6def4aefcc7281e4f', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(86, 'views', '1b6c69e4e82a11c6def4aefcc7281e4f', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(87, 'views', 'dd4fbbb79c038e52dc3b207f30e9893e', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(88, 'views', 'dd4fbbb79c038e52dc3b207f30e9893e', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(89, 'views', '1b6c69e4e82a11c6def4aefcc7281e4f', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(90, 'views', 'dd4fbbb79c038e52dc3b207f30e9893e', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(91, 'block', '3', 'bartik', 0, 0, '-1', 0, 0, '', 'Videos', -1),
(92, 'block', '3', 'ipress', 1, -18, 'sidebar_first', 0, 0, '', 'Videos', -1),
(93, 'block', '3', 'seven', 0, 0, '-1', 0, 0, '', 'Videos', -1),
(94, 'calendar_block', 'calendar', 'bartik', 0, 0, '-1', 0, 0, '', 'Calendar', 1),
(95, 'calendar_block', 'calendar', 'ipress', 1, -17, 'sidebar_first', 0, 0, '', 'Calendar', 1),
(96, 'calendar_block', 'calendar', 'seven', 0, 0, '-1', 0, 0, '', 'Calendar', 1),
(97, 'views', '41ceb72ed8fea5a0d7fc8864b1005759', 'ipress', 1, -16, 'sidebar_first', 0, 0, '', '', -1),
(98, 'views', '41ceb72ed8fea5a0d7fc8864b1005759', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(99, 'views', '41ceb72ed8fea5a0d7fc8864b1005759', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(100, 'views', 'ipress_widget-popular_tags', 'ipress', 1, -15, 'sidebar_first', 0, 0, '', '', -1),
(101, 'views', 'ipress_widget-popular_tags', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(102, 'views', 'ipress_widget-popular_tags', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(103, 'block', '4', 'bartik', 0, 0, '-1', 0, 0, '', 'Like Us', -1),
(104, 'block', '4', 'ipress', 1, -14, 'sidebar_first', 0, 0, '', 'Like Us', -1),
(105, 'block', '4', 'seven', 0, 0, '-1', 0, 0, '', 'Like Us', -1),
(106, 'block', '5', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(107, 'block', '5', 'ipress', 1, -22, 'sidebar_second', 0, 0, '', '<none>', -1),
(108, 'block', '5', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(109, 'block', '6', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(110, 'block', '6', 'ipress', 1, -21, 'sidebar_second', 0, 0, '', '<none>', -1),
(111, 'block', '6', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(112, 'views', 'b1a825f988fe8beba337b47c221d7a8a', 'ipress', 1, 0, '', 0, 0, '', '', -1),
(113, 'views', 'b1a825f988fe8beba337b47c221d7a8a', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(114, 'views', 'b1a825f988fe8beba337b47c221d7a8a', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(115, 'views', '49b8453f3f5249857b30e93a649dbd9f', 'ipress', 0, 0, '-1', 0, 0, '', '', -1),
(116, 'views', 'ipress_blocks-block_2', 'ipress', 1, -20, 'sidebar_second', 0, 0, '', '', -1),
(117, 'views', 'ipress_blocks-block_2', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(118, 'views', 'ipress_blocks-block_2', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(119, 'widget', 'widget_twitter', 'bartik', 0, 0, '-1', 0, 0, '', 'IpressTwitter', 1),
(120, 'widget', 'widget_twitter', 'ipress', 1, -18, 'sidebar_second', 0, 0, '', 'IpressTwitter', 1),
(121, 'widget', 'widget_twitter', 'seven', 0, 0, '-1', 0, 0, '', 'IpressTwitter', 1),
(122, 'block', '7', 'bartik', 0, 0, '-1', 0, 0, '', 'About iPress', -1),
(123, 'block', '7', 'ipress', 1, -21, 'footer_col_one', 0, 0, '', 'About iPress', -1),
(124, 'block', '7', 'seven', 0, 0, '-1', 0, 0, '', 'About iPress', -1),
(125, 'views', 'dd1b0192aa3950772eba26ac8436680c', 'ipress', 1, -20, 'footer_col_three', 0, 0, '', '', -1),
(126, 'views', 'dd1b0192aa3950772eba26ac8436680c', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(127, 'views', 'dd1b0192aa3950772eba26ac8436680c', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(128, 'views', 'ipress_widget-block_categories', 'ipress', 1, -21, 'footer_col_two', 0, 0, '', '', -1),
(129, 'views', 'ipress_widget-block_categories', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(130, 'views', 'ipress_widget-block_categories', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(131, 'widget', 'widget_flickr', 'bartik', 0, 0, '-1', 0, 0, '', 'Flickr Photos', 1),
(132, 'widget', 'widget_flickr', 'ipress', 1, 0, 'footer_col_four', 0, 0, '', 'Flickr Photos', 1),
(133, 'widget', 'widget_flickr', 'seven', 0, 0, '-1', 0, 0, '', 'Flickr Photos', 1),
(134, 'block', '8', 'bartik', 0, 0, '-1', 0, 1, 'contact', '<none>', -1),
(135, 'block', '8', 'ipress', 1, 0, 'content', 0, 1, 'contact', '<none>', -1),
(136, 'block', '8', 'seven', 0, 0, '-1', 0, 1, 'contact', '<none>', -1);

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

--
-- Structure de la table `drupal_blocked_ips`
--

CREATE TABLE IF NOT EXISTS `drupal_blocked_ips` (
  `iid` int(10) unsigned NOT NULL COMMENT 'Primary Key: unique ID for IP addresses.',
  `ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP addresses.';

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

--
-- Structure de la table `drupal_block_custom`
--

CREATE TABLE IF NOT EXISTS `drupal_block_custom` (
  `bid` int(10) unsigned NOT NULL COMMENT 'The block’s block.bid.',
  `body` longtext COMMENT 'Block contents.',
  `info` varchar(128) NOT NULL DEFAULT '' COMMENT 'Block description.',
  `format` varchar(255) DEFAULT NULL COMMENT 'The filter_format.format of the block body.'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='Stores contents of custom-made blocks.';

--
-- Contenu de la table `drupal_block_custom`
--

INSERT INTO `drupal_block_custom` (`bid`, `body`, `info`, `format`) VALUES
(1, '<a href="#" title="ADS"><img src="./sites/all/themes/ipress/images/ads.jpg" alt="ADS"></a>', 'ADS banner right', 'full_html'),
(2, '<div class="ads_block mbf"><a href=""><img src="./sites/all/themes/ipress/images/ads3.png" alt=""></a></div>', 'ADS center home page', 'full_html'),
(3, '<iframe src="http://player.vimeo.com/video/13897659?color=E84A4A" height="180"></iframe>', 'Video sidebar', 'full_html'),
(4, '<div class="bg_light"><iframe src="http://www.facebook.com/plugins/likebox.php?href=http%3A%2F%2Fwww.facebook.com%2Fenvato&amp;width=313&amp;height=300&amp;show_faces=true&amp;colorscheme=light&amp;stream=false&amp;border_color&amp;header=true&amp;appId=138798126277575" height="292"></iframe></div>', 'Ipress block Like Us', 'full_html'),
(5, '<ul class="counter clearfix">\r\n	<li class="twitter"><a href="#"><i class="fa fa-twitter"></i></a><span> 2545 \r\n		Followes </span></li>\r\n	<li class="facebook"><a href="#"><i class="fa fa-facebook"></i></a><span> 1317\r\n		Likes </span></li>\r\n	<li class="dribbble"><a href="#"><i class="fa fa-dribbble"></i></a><span> 325\r\n		Followes </span></li>\r\n	<li class="rss"><a href="#"><i class="fa fa-rss"></i></a><span> 27\r\n		Subscribers </span></li>\r\n</ul>', 'Ipress block Social sidebar', 'full_html'),
(6, '<div class="ads_widget clearfix"><a href="#"><img src="./sites/all/themes/ipress/images/ads2.jpg" alt="#"></a><a href="#" class="lefter mt"><img src="./sites/all/themes/ipress/images/ads3.jpg" alt="#"></a><a href="#" class="righter mt"><img src="./sites/all/themes/ipress/images/ads3.jpg" alt="#"></a></div>', 'Ipress block ADS sidebar second', 'full_html'),
(7, '<p> iPress is a magazine/blog/ad/review template. Nunc montes odio phasellus dignissim, aenean, nec augue velit integer elementum ut montes quis integer cursus, est purus, lectus duis, scelerisque tincidunt ultricies phasellus elementum turpis tristique.<br>\r\n	Email: <a href="contact.html">information@ipress.com</a></p>', 'About iPress', 'full_html'),
(8, '<p> Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. \r\nNemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. </p>\r\n<div class="mbf">\r\n	<iframe height="300" src="https://maps.google.com/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=New+York,+NY,+United+States&amp;aq=0&amp;oq=New+yok&amp;sll=37.0625,-95.677068&amp;sspn=41.224889,86.044922&amp;ie=UTF8&amp;hq=&amp;hnear=New+York&amp;t=m&amp;z=10&amp;ll=40.714353,-74.005973&amp;output=embed"></iframe>\r\n</div>', 'Content contact', 'full_html');

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

--
-- Structure de la table `drupal_block_node_type`
--

CREATE TABLE IF NOT EXISTS `drupal_block_node_type` (
  `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
  `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
  `type` varchar(32) NOT NULL COMMENT 'The machine-readable name of this type from node_type.type.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up display criteria for blocks based on content types';

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

--
-- Structure de la table `drupal_block_role`
--

CREATE TABLE IF NOT EXISTS `drupal_block_role` (
  `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
  `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
  `rid` int(10) unsigned NOT NULL COMMENT 'The user’s role ID from users_roles.rid.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up access permissions for blocks based on user roles';

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

--
-- Structure de la table `drupal_cache`
--

CREATE TABLE IF NOT EXISTS `drupal_cache` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...';

--
-- Contenu de la table `drupal_cache`
--

INSERT INTO `drupal_cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('context', 0x[encoded data, 32528 characters], 0, 1411405323, 1),
('ctools_plugin_files:context:plugins', 0x613a303a7b7d, 0, 1411405138, 1);
INSERT INTO `drupal_cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('ctools_plugin_files:ctools:content_types', 0x[encoded data, 23178 characters], 0, 1396104363, 1),
('ctools_plugin_type_info', 0x[encoded data, 7492 characters], 0, 1396104363, 1);
INSERT INTO `drupal_cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('entity_info:en', 0x[encoded data, 34464 characters], 0, 1411405135, 1),
('filter_formats:en', 0x613a333a7b733a31333a2266696c74657265645f68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a31333a2266696c74657265645f68746d6c223b733a343a226e616d65223b733a31333a2246696c74657265642048544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2230223b7d733a393a2266756c6c5f68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b733a343a226e616d65223b733a393a2246756c6c2048544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2231223b7d733a31303a22706c61696e5f74657874223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a31303a22706c61696e5f74657874223b733a343a226e616d65223b733a31303a22506c61696e2074657874223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a323a223130223b7d7d, 0, 1396104363, 1),
('filter_list_format', 0x[encoded data, 7402 characters], 0, 1411405135, 1),
('image_effects:en', 0x[encoded data, 5316 characters], 0, 1411405135, 1);
INSERT INTO `drupal_cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('image_styles', 0x[encoded data, 5688 characters], 0, 1411405135, 1),
('node_types:en', 0x4f3a383a22737464436c617373223a323a7b733a353a227479706573223b613a343a7b733a343a22626c6f67223b4f3a383a22737464436c617373223a31343a7b733a343a2274797065223b733a343a22626c6f67223b733a343a226e616d65223b733a31303a22426c6f6720656e747279223b733a343a2262617365223b733a343a22626c6f67223b733a363a226d6f64756c65223b733a343a22626c6f67223b733a31313a226465736372697074696f6e223b733a35383a2255736520666f72206d756c74692d7573657220626c6f67732e20457665727920757365722067657473206120706572736f6e616c20626c6f672e223b733a343a2268656c70223b733a303a22223b733a393a226861735f7469746c65223b733a313a2231223b733a31313a227469746c655f6c6162656c223b733a353a225469746c65223b733a363a22637573746f6d223b733a313a2230223b733a383a226d6f646966696564223b733a313a2231223b733a363a226c6f636b6564223b733a313a2231223b733a383a2264697361626c6564223b623a303b733a393a226f7269675f74797065223b733a343a22626c6f67223b733a31363a2264697361626c65645f6368616e676564223b623a303b7d733a373a2261727469636c65223b4f3a383a22737464436c617373223a31343a7b733a343a2274797065223b733a373a2261727469636c65223b733a343a226e616d65223b733a373a2241727469636c65223b733a343a2262617365223b733a31323a226e6f64655f636f6e74656e74223b733a363a226d6f64756c65223b733a343a226e6f6465223b733a31313a226465736372697074696f6e223b733a38393a22557365203c656d3e61727469636c65733c2f656d3e20666f722074696d652d73656e73697469766520636f6e74656e74206c696b65206e6577732c2070726573732072656c6561736573206f7220626c6f6720706f7374732e223b733a343a2268656c70223b733a303a22223b733a393a226861735f7469746c65223b733a313a2231223b733a31313a227469746c655f6c6162656c223b733a353a225469746c65223b733a363a22637573746f6d223b733a313a2231223b733a383a226d6f646966696564223b733a313a2231223b733a363a226c6f636b6564223b733a313a2230223b733a383a2264697361626c6564223b733a313a2230223b733a393a226f7269675f74797065223b733a373a2261727469636c65223b733a31363a2264697361626c65645f6368616e676564223b623a303b7d733a343a2270616765223b4f3a383a22737464436c617373223a31343a7b733a343a2274797065223b733a343a2270616765223b733a343a226e616d65223b733a31303a2242617369632070616765223b733a343a2262617365223b733a31323a226e6f64655f636f6e74656e74223b733a363a226d6f64756c65223b733a343a226e6f6465223b733a31313a226465736372697074696f6e223b733a37373a22557365203c656d3e62617369632070616765733c2f656d3e20666f7220796f75722073746174696320636f6e74656e742c207375636820617320616e202741626f75742075732720706167652e223b733a343a2268656c70223b733a303a22223b733a393a226861735f7469746c65223b733a313a2231223b733a31313a227469746c655f6c6162656c223b733a353a225469746c65223b733a363a22637573746f6d223b733a313a2231223b733a383a226d6f646966696564223b733a313a2231223b733a363a226c6f636b6564223b733a313a2230223b733a383a2264697361626c6564223b733a313a2230223b733a393a226f7269675f74797065223b733a343a2270616765223b733a31363a2264697361626c65645f6368616e676564223b623a303b7d733a363a22736f6369616c223b4f3a383a22737464436c617373223a31343a7b733a343a2274797065223b733a363a22736f6369616c223b733a343a226e616d65223b733a363a22536f6369616c223b733a343a2262617365223b733a31323a226e6f64655f636f6e74656e74223b733a363a226d6f64756c65223b733a343a226e6f6465223b733a31313a226465736372697074696f6e223b733a303a22223b733a343a2268656c70223b733a303a22223b733a393a226861735f7469746c65223b733a313a2231223b733a31313a227469746c655f6c6162656c223b733a353a225469746c65223b733a363a22637573746f6d223b733a313a2231223b733a383a226d6f646966696564223b733a313a2231223b733a363a226c6f636b6564223b733a313a2230223b733a383a2264697361626c6564223b733a313a2230223b733a393a226f7269675f74797065223b733a363a22736f6369616c223b733a31363a2264697361626c65645f6368616e676564223b623a303b7d7d733a353a226e616d6573223b613a343a7b733a373a2261727469636c65223b733a373a2241727469636c65223b733a343a2270616765223b733a31303a2242617369632070616765223b733a343a22626c6f67223b733a31303a22426c6f6720656e747279223b733a363a22736f6369616c223b733a363a22536f6369616c223b7d7d, 0, 1396104363, 1),
('plugins:context:plugins', 0x[encoded data, 19170 characters], 0, 1411405138, 1);
INSERT INTO `drupal_cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('schema', 0x[encoded data, 167412 characters], 0, 1396104363, 1);
INSERT INTO `drupal_cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('schema:runtime:', 0x[encoded data, 18216 characters], 0, 1396104316, 1),
('schema:runtime:1', 0x[encoded data, 30058 characters], 0, 1411405135, 1);
