# +----------------------------------------------------------------------+
# | Copyright (c) 2009 Advisto SAS, service PEEL - contact@peel.fr       |
# +----------------------------------------------------------------------+
# | This file is part of PEEL Modules 6.0,  which is subject to an       |
# | opensource commercial license: you are allowed to customize the code |
# | for your own needs, but you are NOT entitled to distribute this file |
# | More information: http://www.peel.fr/lire/licence-commerciale-71.html|
# +----------------------------------------------------------------------+
# | Author: Advisto SAS, RCS 479 205 452, France, http://www.peel.fr/    |
# +----------------------------------------------------------------------+
# $Id: peel_statistiques.sql 13370 2011-01-01 21:22:20Z gboussin $
#

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

-- 
-- Structure de la table `peel_annee`
-- 

CREATE TABLE `peel_annee` (
  `annee` int(5) NOT NULL default '0',
  PRIMARY KEY  (`annee`),
  UNIQUE KEY `annee` (`annee`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Structure de la table `peel_clics`
-- 

CREATE TABLE `peel_clics` (
  `id_stat_clic` int(6) NOT NULL default '0',
  `annee` int(6) NOT NULL default '0',
  `id_mois` int(6) NOT NULL default '0',
  `nb_clics` int(6) default NULL,
  PRIMARY KEY  (`id_stat_clic`,`annee`,`id_mois`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Structure de la table `peel_mois`
-- 

CREATE TABLE `peel_mois` (
  `id` int(6) NOT NULL,
  `libelle` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Structure de la table `peel_nb_connexion`
-- 

CREATE TABLE `peel_nb_connexion` (
  `ladate` date NOT NULL default '0000-00-00',
  `nb` int(11) default NULL,
  PRIMARY KEY  (`ladate`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Structure de la table `peel_nb_connexions_lien`
-- 

CREATE TABLE `peel_nb_connexions_lien` (
  `la_date` date NOT NULL default '0000-00-00',
  `lien` varchar(200) NOT NULL default '',
  `nb` int(11) default NULL,
  PRIMARY KEY  (`la_date`,`lien`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Structure de la table `peel_recherche`
-- 

CREATE TABLE `peel_recherche` (
  `id` int(6) NOT NULL,
  `recherche` varchar(200) NOT NULL default '',
  `num_mois` int(6) NOT NULL default '0',
  `annee` int(6) NOT NULL default '0',
  `nbfois` int(6) default NULL,
  PRIMARY KEY  (`id`,`recherche`,`num_mois`,`annee`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=506 ;

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

-- 
-- Structure de la table `peel_statistiques_clic`
-- 

CREATE TABLE `peel_statistiques_clic` (
  `id` int(6) NOT NULL,
  `nom_site` varchar(60) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`,`nom_site`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;



-- 
-- Contenu de la table `peel_annee`
-- 

INSERT INTO `peel_annee` VALUES (2005);
INSERT INTO `peel_annee` VALUES (2006);
INSERT INTO `peel_annee` VALUES (2007);
INSERT INTO `peel_annee` VALUES (2008);
INSERT INTO `peel_annee` VALUES (2009);
INSERT INTO `peel_annee` VALUES (2010);
INSERT INTO `peel_annee` VALUES (2011);
INSERT INTO `peel_annee` VALUES (2012);
INSERT INTO `peel_annee` VALUES (2013);
INSERT INTO `peel_annee` VALUES (2014);
INSERT INTO `peel_annee` VALUES (2015);
INSERT INTO `peel_annee` VALUES (2016);
INSERT INTO `peel_annee` VALUES (2017);
INSERT INTO `peel_annee` VALUES (2018);
INSERT INTO `peel_annee` VALUES (2019);
INSERT INTO `peel_annee` VALUES (2020);
INSERT INTO `peel_annee` VALUES (2021);
INSERT INTO `peel_annee` VALUES (2022);
INSERT INTO `peel_annee` VALUES (2023);
INSERT INTO `peel_annee` VALUES (2024);
INSERT INTO `peel_annee` VALUES (2025);
INSERT INTO `peel_annee` VALUES (2026);
INSERT INTO `peel_annee` VALUES (2027);
INSERT INTO `peel_annee` VALUES (2028);
INSERT INTO `peel_annee` VALUES (2029);
INSERT INTO `peel_annee` VALUES (2030);
INSERT INTO `peel_annee` VALUES (2031);
INSERT INTO `peel_annee` VALUES (2032);
INSERT INTO `peel_annee` VALUES (2033);
INSERT INTO `peel_annee` VALUES (2034);
INSERT INTO `peel_annee` VALUES (2035);
INSERT INTO `peel_annee` VALUES (2036);
INSERT INTO `peel_annee` VALUES (2037);
INSERT INTO `peel_annee` VALUES (2038);
INSERT INTO `peel_annee` VALUES (2039);
INSERT INTO `peel_annee` VALUES (2040);
INSERT INTO `peel_annee` VALUES (2041);
INSERT INTO `peel_annee` VALUES (2042);
INSERT INTO `peel_annee` VALUES (2043);
INSERT INTO `peel_annee` VALUES (2044);
INSERT INTO `peel_annee` VALUES (2045);
INSERT INTO `peel_annee` VALUES (2046);
INSERT INTO `peel_annee` VALUES (2047);
INSERT INTO `peel_annee` VALUES (2048);
INSERT INTO `peel_annee` VALUES (2049);
INSERT INTO `peel_annee` VALUES (2050);
INSERT INTO `peel_annee` VALUES (2051);
INSERT INTO `peel_annee` VALUES (2052);
INSERT INTO `peel_annee` VALUES (2053);
INSERT INTO `peel_annee` VALUES (2054);
INSERT INTO `peel_annee` VALUES (2055);
INSERT INTO `peel_annee` VALUES (2056);
INSERT INTO `peel_annee` VALUES (2057);
INSERT INTO `peel_annee` VALUES (2058);
INSERT INTO `peel_annee` VALUES (2059);
INSERT INTO `peel_annee` VALUES (2060);
INSERT INTO `peel_annee` VALUES (2061);
INSERT INTO `peel_annee` VALUES (2062);
INSERT INTO `peel_annee` VALUES (2063);
INSERT INTO `peel_annee` VALUES (2064);
INSERT INTO `peel_annee` VALUES (2065);
INSERT INTO `peel_annee` VALUES (2066);
INSERT INTO `peel_annee` VALUES (2067);
INSERT INTO `peel_annee` VALUES (2068);
INSERT INTO `peel_annee` VALUES (2069);
INSERT INTO `peel_annee` VALUES (2070);
INSERT INTO `peel_annee` VALUES (2071);
INSERT INTO `peel_annee` VALUES (2072);
INSERT INTO `peel_annee` VALUES (2073);
INSERT INTO `peel_annee` VALUES (2074);
INSERT INTO `peel_annee` VALUES (2075);
INSERT INTO `peel_annee` VALUES (2076);
INSERT INTO `peel_annee` VALUES (2077);
INSERT INTO `peel_annee` VALUES (2078);
INSERT INTO `peel_annee` VALUES (2079);
INSERT INTO `peel_annee` VALUES (2080);
INSERT INTO `peel_annee` VALUES (2081);
INSERT INTO `peel_annee` VALUES (2082);
INSERT INTO `peel_annee` VALUES (2083);
INSERT INTO `peel_annee` VALUES (2084);
INSERT INTO `peel_annee` VALUES (2085);
INSERT INTO `peel_annee` VALUES (2086);
INSERT INTO `peel_annee` VALUES (2087);
INSERT INTO `peel_annee` VALUES (2088);
INSERT INTO `peel_annee` VALUES (2089);
INSERT INTO `peel_annee` VALUES (2090);
INSERT INTO `peel_annee` VALUES (2091);
INSERT INTO `peel_annee` VALUES (2092);
INSERT INTO `peel_annee` VALUES (2093);
INSERT INTO `peel_annee` VALUES (2094);
INSERT INTO `peel_annee` VALUES (2095);
INSERT INTO `peel_annee` VALUES (2096);
INSERT INTO `peel_annee` VALUES (2097);
INSERT INTO `peel_annee` VALUES (2098);
INSERT INTO `peel_annee` VALUES (2099);
INSERT INTO `peel_annee` VALUES (2100);
INSERT INTO `peel_annee` VALUES (2101);
INSERT INTO `peel_annee` VALUES (2102);
INSERT INTO `peel_annee` VALUES (2103);
INSERT INTO `peel_annee` VALUES (2104);
INSERT INTO `peel_annee` VALUES (2105);
INSERT INTO `peel_annee` VALUES (2106);
INSERT INTO `peel_annee` VALUES (2107);
INSERT INTO `peel_annee` VALUES (2108);
INSERT INTO `peel_annee` VALUES (2109);
INSERT INTO `peel_annee` VALUES (2110);
INSERT INTO `peel_annee` VALUES (2111);
INSERT INTO `peel_annee` VALUES (2112);
INSERT INTO `peel_annee` VALUES (2113);
INSERT INTO `peel_annee` VALUES (2114);
INSERT INTO `peel_annee` VALUES (2115);
INSERT INTO `peel_annee` VALUES (2116);
INSERT INTO `peel_annee` VALUES (2117);
INSERT INTO `peel_annee` VALUES (2118);
INSERT INTO `peel_annee` VALUES (2119);
INSERT INTO `peel_annee` VALUES (2120);
INSERT INTO `peel_annee` VALUES (2121);
INSERT INTO `peel_annee` VALUES (2122);
INSERT INTO `peel_annee` VALUES (2123);
INSERT INTO `peel_annee` VALUES (2124);
INSERT INTO `peel_annee` VALUES (2125);
INSERT INTO `peel_annee` VALUES (2126);
INSERT INTO `peel_annee` VALUES (2127);
INSERT INTO `peel_annee` VALUES (2128);
INSERT INTO `peel_annee` VALUES (2129);
INSERT INTO `peel_annee` VALUES (2130);
INSERT INTO `peel_annee` VALUES (2131);
INSERT INTO `peel_annee` VALUES (2132);
INSERT INTO `peel_annee` VALUES (2133);
INSERT INTO `peel_annee` VALUES (2134);
INSERT INTO `peel_annee` VALUES (2135);
INSERT INTO `peel_annee` VALUES (2136);
INSERT INTO `peel_annee` VALUES (2137);
INSERT INTO `peel_annee` VALUES (2138);
INSERT INTO `peel_annee` VALUES (2139);
INSERT INTO `peel_annee` VALUES (2140);
INSERT INTO `peel_annee` VALUES (2141);
INSERT INTO `peel_annee` VALUES (2142);
INSERT INTO `peel_annee` VALUES (2143);
INSERT INTO `peel_annee` VALUES (2144);
INSERT INTO `peel_annee` VALUES (2145);
INSERT INTO `peel_annee` VALUES (2146);
INSERT INTO `peel_annee` VALUES (2147);
INSERT INTO `peel_annee` VALUES (2148);
INSERT INTO `peel_annee` VALUES (2149);
INSERT INTO `peel_annee` VALUES (2150);
INSERT INTO `peel_annee` VALUES (2151);
INSERT INTO `peel_annee` VALUES (2152);
INSERT INTO `peel_annee` VALUES (2153);
INSERT INTO `peel_annee` VALUES (2154);
INSERT INTO `peel_annee` VALUES (2155);
INSERT INTO `peel_annee` VALUES (2156);
INSERT INTO `peel_annee` VALUES (2157);
INSERT INTO `peel_annee` VALUES (2158);
INSERT INTO `peel_annee` VALUES (2159);
INSERT INTO `peel_annee` VALUES (2160);
INSERT INTO `peel_annee` VALUES (2161);
INSERT INTO `peel_annee` VALUES (2162);
INSERT INTO `peel_annee` VALUES (2163);
INSERT INTO `peel_annee` VALUES (2164);
INSERT INTO `peel_annee` VALUES (2165);
INSERT INTO `peel_annee` VALUES (2166);
INSERT INTO `peel_annee` VALUES (2167);
INSERT INTO `peel_annee` VALUES (2168);
INSERT INTO `peel_annee` VALUES (2169);
INSERT INTO `peel_annee` VALUES (2170);
INSERT INTO `peel_annee` VALUES (2171);
INSERT INTO `peel_annee` VALUES (2172);
INSERT INTO `peel_annee` VALUES (2173);
INSERT INTO `peel_annee` VALUES (2174);
INSERT INTO `peel_annee` VALUES (2175);
INSERT INTO `peel_annee` VALUES (2176);
INSERT INTO `peel_annee` VALUES (2177);
INSERT INTO `peel_annee` VALUES (2178);
INSERT INTO `peel_annee` VALUES (2179);
INSERT INTO `peel_annee` VALUES (2180);
INSERT INTO `peel_annee` VALUES (2181);
INSERT INTO `peel_annee` VALUES (2182);
INSERT INTO `peel_annee` VALUES (2183);
INSERT INTO `peel_annee` VALUES (2184);
INSERT INTO `peel_annee` VALUES (2185);
INSERT INTO `peel_annee` VALUES (2186);
INSERT INTO `peel_annee` VALUES (2187);
INSERT INTO `peel_annee` VALUES (2188);
INSERT INTO `peel_annee` VALUES (2189);
INSERT INTO `peel_annee` VALUES (2190);
INSERT INTO `peel_annee` VALUES (2191);
INSERT INTO `peel_annee` VALUES (2192);
INSERT INTO `peel_annee` VALUES (2193);
INSERT INTO `peel_annee` VALUES (2194);
INSERT INTO `peel_annee` VALUES (2195);
INSERT INTO `peel_annee` VALUES (2196);
INSERT INTO `peel_annee` VALUES (2197);
INSERT INTO `peel_annee` VALUES (2198);
INSERT INTO `peel_annee` VALUES (2199);
INSERT INTO `peel_annee` VALUES (2200);
INSERT INTO `peel_annee` VALUES (2201);
INSERT INTO `peel_annee` VALUES (2202);
INSERT INTO `peel_annee` VALUES (2203);
INSERT INTO `peel_annee` VALUES (2204);
INSERT INTO `peel_annee` VALUES (2205);

-- 
-- Contenu de la table `peel_mois`
-- 

INSERT INTO `peel_mois` VALUES (1, 'Janvier');
INSERT INTO `peel_mois` VALUES (2, 'Février');
INSERT INTO `peel_mois` VALUES (3, 'Mars');
INSERT INTO `peel_mois` VALUES (4, 'Avril');
INSERT INTO `peel_mois` VALUES (5, 'Mai');
INSERT INTO `peel_mois` VALUES (6, 'Juin');
INSERT INTO `peel_mois` VALUES (7, 'Juillet');
INSERT INTO `peel_mois` VALUES (8, 'Août');
INSERT INTO `peel_mois` VALUES (9, 'Septembre');
INSERT INTO `peel_mois` VALUES (10, 'Octobre');
INSERT INTO `peel_mois` VALUES (11, 'Novembre');
INSERT INTO `peel_mois` VALUES (12, 'Décembre');
