-- phpMyAdmin SQL Dump
-- version OVH
-- http://www.phpmyadmin.net
--
-- Serveur: sql2.300gp
-- Généré le : Dim 13 Septembre 2015 à 12:11
-- Version du serveur: 4.0.26
-- Version de PHP: 5.3.8


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

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

--
-- Structure de la table `aaaaa`
--

CREATE TABLE IF NOT EXISTS `aaaaa` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `heure` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `aaaaa`
--


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

--
-- Structure de la table `administration`
--

CREATE TABLE IF NOT EXISTS `administration` (
  `id` tinyint(5) NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `identifiant` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `membre` varchar(30) NOT NULL default '',
  `droits` varchar(30) NOT NULL default '',
  `projets` text NOT NULL,
  `heure` varchar(30) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

--
-- Contenu de la table `administration`
--

INSERT INTO `administration` (`id`, `nom`, `prenom`, `identifiant`, `password`, `membre`, `droits`, `projets`, `heure`, `date`) VALUES
(1, 'delpy', 'patrice', 'ffxmph', 'azerty', 'Patrice', 'User', 'EVOLUTION,BIDULLE,P3,essai,dsgsd,P1,P2', '', ''),
(3, 'pipo', 'bilou', 'patrice', 'rainbow', 'Fabien', 'Root', 'EVOLUTION,BIDULLE,P3,essai,dsgsd,P1,P2', '', ''),
(4, 'coco', 'paulo', 'anissa', 'anissa', 'anissa', 'Leader', '', '', ''),
(6, 'blase', 'tartuffe', 'connard', 'azeqsd', '', 'User', 'EVOLUTION', '11:52', '2011-06-26'),
(7, 'alpha', 'beta', 'putoi', 'aqwzsx', '', 'User', 'BIDULLE,P2,essai', '21:01', '2011-06-28'),
(8, 'un', 'deux', 'trois', 'aqwzsx', '', 'Leader', 'essai,P2', '21:03', '2011-06-28'),
(9, 'aeze', 'lkkl', 'fdgg', 'aqwzsx', '', 'User', 'PROJ1,PROJ2,PROJ3', '21:04', '2011-06-28'),
(10, 'pop', 'lmklm', 'pmn', 'aqwzsx', '', 'User', 'PROJ1,PROJ2,PROJ3', '21:05', '2011-06-28'),
(11, 'rfv', 'rfv', 'rfv', 'aqwzsx', '', 'User', 'EVOLUTION,dsgsd', '21:08', '2011-06-28');

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

--
-- Structure de la table `adresses_livraison`
--

CREATE TABLE IF NOT EXISTS `adresses_livraison` (
  `id` int(10) NOT NULL auto_increment,
  `email` varchar(100) NOT NULL default '',
  `identifiant` varchar(30) NOT NULL default '',
  `titre1` varchar(50) NOT NULL default '',
  `nom1` varchar(50) NOT NULL default '',
  `prenom1` varchar(50) NOT NULL default '',
  `adresse1` varchar(100) NOT NULL default '',
  `complement1` varchar(100) NOT NULL default '',
  `cp1` varchar(20) NOT NULL default '',
  `ville1` varchar(80) NOT NULL default '',
  `titre2` varchar(50) NOT NULL default '',
  `nom2` varchar(50) NOT NULL default '',
  `prenom2` varchar(50) NOT NULL default '',
  `adresse2` varchar(100) NOT NULL default '',
  `complement2` varchar(100) NOT NULL default '',
  `cp2` varchar(20) NOT NULL default '',
  `ville2` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

--
-- Contenu de la table `adresses_livraison`
--

INSERT INTO `adresses_livraison` (`id`, `email`, `identifiant`, `titre1`, `nom1`, `prenom1`, `adresse1`, `complement1`, `cp1`, `ville1`, `titre2`, `nom2`, `prenom2`, `adresse2`, `complement2`, `cp2`, `ville2`) VALUES
(1, 'patrice.delpy@sfr.fr', 'ffxmph', 'un', 'charierde', 'laurence', '231 boulevard de metz', '', '81340', 'gaillac', 'deux', 'un', 'uno', 'un', '', '11111', 'un'),
(2, 'essai.rien@free.fr', 'pipo1234', 'maison', 'martin', 'axel', '40 rue cuvier', '', '75000', 'paris', '', '', '', '', '', '', ''),
(3, 'patrice.delpy@onsemi.com', 'personnel', 'un', 'aaa', 'bbb', 'ccc', 'ddd', 'eee', 'fff', 'deux', 'riri', 'lulu', 'bibi', 'coco', 'fafa', 'pipo'),
(5, 'patrice.delpy@hotmail.fr', 'patoche', 'maison', 'delpy', 'patrice', '1, 46 rue du Stade', 'mjkjkl', '81120', 'toulouse', 'boulot', 'poste', 'bigboss', '132, chemin de basso cambo', '', '31000', 'Paris'),
(6, 'bob.sinclar@dst.fr', 'tartuffe', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(11, 'essai@free.fr', 'vincent', 'maison', 'aa', 'bb', 'un petit local', '', '64220', 'bayonne', '', '', '', '', '', '', ''),
(7, 'essai@free.fr', 'patoche', 'maison', 'aa', 'bb', 'un petit local', '', '64220', 'bayonne', '', '', '', '', '', '', ''),
(8, 'p.delpy@yahoo.com', 'moimeme', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(9, 'toto@gmail.fr', 'patoche', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(10, 'ffxmph@onsemi.com', 'patoche', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(12, 'patrice.delpy@cegetel.net', 'lucien', 'bidon', 'blase', 'kiki', '132, rue de la paix', '', '78754', 'paris', '', '', '', '', '', '', '');

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

--
-- Structure de la table `ancien_lave_linge`
--

CREATE TABLE IF NOT EXISTS `ancien_lave_linge` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `marque` varchar(20) NOT NULL default '',
  `id_catalogue` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `modele` varchar(20) NOT NULL default '',
  `chargement` varchar(20) NOT NULL default '',
  `capacite` varchar(10) NOT NULL default '',
  `essorage` varchar(10) NOT NULL default '',
  `classe` varchar(5) NOT NULL default '',
  `stocke` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

--
-- Contenu de la table `ancien_lave_linge`
--

INSERT INTO `ancien_lave_linge` (`id`, `marque`, `id_catalogue`, `fournisseur`, `modele`, `chargement`, `capacite`, `essorage`, `classe`, `stocke`, `prix_ttc`, `prix_ht`) VALUES
(1, 'Aeg', 'ref100', 'bilou', 'NTH82K', 'Hublot', '6', '1200', 'A+', '48H', 479.50, 399.10),
(2, 'Bosch', 'ref200', 'ZNI', 'X28Z-22', 'Frontal', '8', '1600', 'A++', '24H', 721.50, 677.45),
(3, 'Whirlpool', 'ref300', 'Bardou', 'KU78-8', 'Frontal', '6-5', '900', 'A', '24H', 614.10, 581.78),
(4, 'Aeg', 'ref400', 'bilou', 'VV3474', 'Hublot', '6', '1200', 'A+', '48H', 551.50, 399.10),
(8, 'Bosch', 'ref500', 'ZNI', 'P-221', 'Frontal', '8', '1600', 'A++', '24H', 714.20, 677.45),
(9, 'Whirlpool', 'ref600', 'Bardou', 'AAN18-B4F', 'Frontal', '6_5', '900', 'A', '24H', 610.94, 581.78);

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

--
-- Structure de la table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `ide_art` int(1) NOT NULL auto_increment,
  `nom_art` varchar(30) NOT NULL default '',
  `des_art` varchar(80) NOT NULL default '',
  `tail_art` varchar(10) NOT NULL default '',
  `pri_art` float NOT NULL default '0',
  `img_art` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`ide_art`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `articles`
--


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

--
-- Structure de la table `avis`
--

CREATE TABLE IF NOT EXISTS `avis` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `sujet` varchar(50) NOT NULL default '',
  `message` text NOT NULL,
  `date` varchar(20) NOT NULL default '',
  `heure` varchar(20) NOT NULL default '',
  `question` varchar(255) NOT NULL default '',
  `note` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Contenu de la table `avis`
--

INSERT INTO `avis` (`id`, `nom`, `prenom`, `email`, `sujet`, `message`, `date`, `heure`, `question`, `note`) VALUES
(1, 'lulu', 'pifou', 'patrice.delpy@neuf.fr', 'aze', 'Ã©tÃ©', '31-12-2014', '22:41:17', 'oui-oui', '5');

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

--
-- Structure de la table `bloc`
--

CREATE TABLE IF NOT EXISTS `bloc` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `nom_bloc` varchar(30) NOT NULL default '',
  `lien_projet` varchar(30) NOT NULL default '',
  `heure` varchar(30) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  `date_schema` date NOT NULL default '0000-00-00',
  `date_debut` date NOT NULL default '0000-00-00',
  `jours_tache` varchar(30) NOT NULL default '',
  `date_fin` date NOT NULL default '0000-00-00',
  `affectation` varchar(30) NOT NULL default '',
  `owner` varchar(30) NOT NULL default '',
  `notes` text NOT NULL,
  `nb_jours` varchar(30) NOT NULL default '',
  `date_iso` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

--
-- Contenu de la table `bloc`
--

INSERT INTO `bloc` (`id`, `nom_bloc`, `lien_projet`, `heure`, `date`, `date_schema`, `date_debut`, `jours_tache`, `date_fin`, `affectation`, `owner`, `notes`, `nb_jours`, `date_iso`) VALUES
(13, 'LDO', 'EVOLUTION', '23:23', '2011-06-18', '2011-06-14', '2011-06-15', '23', '2011-07-18', 'Julien', '', '								', '', '0000-00-00'),
(11, 'Bloc10', 'EVOLUTION', '23:24', '2011-06-18', '2011-07-01', '2011-07-18', '43', '2011-09-15', 'Anissa', '', '																', '', '0000-00-00'),
(10, 'Bloc3', 'EVOLUTION', '23:25', '2011-06-18', '2011-03-01', '2011-04-12', '60', '2011-07-04', 'Virginie', '', '																', '', '0000-00-00'),
(12, 'SMPS', 'EVOLUTION', '23:24', '2011-06-18', '2011-06-03', '2011-06-06', '5', '2011-06-13', 'Fabien', 'superuser', '																										', '', '0000-00-00'),
(8, 'Bloc1', 'EVOLUTION', '23:25', '2011-06-18', '2011-04-20', '2011-05-20', '14', '2011-06-09', 'Virginie', '', '																																							il faut beau																																																														', '', '0000-00-00'),
(14, 'oscillateur_1p1', 'EVOLUTION', '23:02', '2013-08-10', '2011-06-13', '2011-09-05', '10', '2011-09-19', 'Patrice', '', 'au oulot																																																																																																																																																				', '', '0000-00-00'),
(15, '', '', '21:43', '2011-06-22', '0000-00-00', '0000-00-00', '', '0000-00-00', '', 'admin', '', '', '0000-00-00');

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

--
-- Structure de la table `bost`
--

CREATE TABLE IF NOT EXISTS `bost` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `six` varchar(30) NOT NULL default '',
  `cinq` varchar(30) NOT NULL default '',
  `quatre` varchar(30) NOT NULL default '',
  `trois` varchar(30) NOT NULL default '',
  `deux` varchar(30) NOT NULL default '',
  `un` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `bost`
--


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

--
-- Structure de la table `categorie`
--

CREATE TABLE IF NOT EXISTS `categorie` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `table_article` varchar(30) NOT NULL default '',
  `filtre` text NOT NULL,
  `descriptif` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=58 ;

--
-- Contenu de la table `categorie`
--

INSERT INTO `categorie` (`id`, `table_article`, `filtre`, `descriptif`) VALUES
(3, '0000lave_linge', 'Marque,Modele,Chargement,Capacite en Kg,Classe énergétique,Classe d''efficacité de lavage,Classe d''efficacité de l''essorage,Vitesse d''essorage trs-min,Consommation d''énergie KWh-cycle,Consommation d''eau en l par cycle,Prix', 'TITRE INFORMATIONS PRINCIPALES:,Type de chargement (*),Couleur,CapacitÃ© de lavage en Kg (*),CapacitÃ© variable automatique,DÃ©part diffÃ©rÃ©,Nombres de programmes,Type de programmateur,Vitesse d''essorage trs/min (*),Volume du tambour,Garantie du produit,Classe Ã©nergÃ©tique,Classe d''efficacitÃ© de lavage (*),Classe d''efficacitÃ© de l''essorage (*),Consommation d''Ã©nergie KWh/cycle (*),TITRE BRANCHEMENTS,Secteur,TITRE DISPOSITIF DE SECURITE,Anti-mousse,TITRE CaractÃ©ristiques physiques,H x L xP (en cm)'),
(4, 'lave_vaisselle', 'Marque,Modele,Nombre de couverts,Niveau sonore en décibels,Classe énergétique,Classe d''efficacité de lavage,Classe d''efficacité de l''essorage,Consommation d''eau en l par cycle,Type de pose,Départ différé,Prix', ''),
(5, 'refrigerateur', '', ''),
(6, 'congelateur', '', ''),
(29, 'dev', '', 'TITREINFORMATIONS GENERALES:,Couleur,Chargement(*),Nombre de programmes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRE CONSOMMATIONS:,Consommation_energie_KWh_cycle (*),Classe_efficacite_essorage (*),TITRE DISPOSITIF DE SECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,H x L xP (en cm),Poids (en kg)'),
(37, 'cruchot', '', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRE CONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITRE DISPOSITIF DE SECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(38, 'essai', '', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITRE DISPOSITIF DE SECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(39, 'nada', '', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITREDISPOSITIF DE SECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(40, 'coco', ',,,,,', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITREDISPOSITIFDE SECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(41, 'orange', 'chargement,vitesse_essorage_trs_min,capacite_lavage_kg,consommation_energie_kwh_cycle,classe_efficacite_essorage', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITREDISPOSITIFDESECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(42, 'washer', 'marque,chargement,vitesse_essorage_trs_min,capacite_lavage_kg,consommation_energie_kwh_cycle,classe_efficacite_essorage', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITREDISPOSITIFDESECURITE,Anti-balours,Anti-mousse,TITRECaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(43, 'octobre', 'chargement,vitesse_essorage_trs_min,capacite_lavage_kg,consommation_energie_kwh_cycle,classe_efficacite_essorage', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITRE DISPOSITIF DE SECURITE,Anti-balours,Anti-mousse,TITRE CaractÃ©ristiques physiques,HxLxP(encm),Poids(enkg)'),
(44, 'refrigerateur', 'niveau sonore en db,nombre de couverts,dÃ©part diffÃ©rÃ©,classe Ã©nergÃ©tique,efficacitÃ© de lavage,efficacitÃ© de sÃ©chage,nombre de programmes,consommation d\\''eau,consommation d\\''energie', 'TITRE INFORMATIONS GENERALES:,Niveau sonore en db(*),Nombre de couverts(*),DÃ©part diffÃ©rÃ©(*),Couleur,TITRE CONSOMMATIONS:,Classe Ã©nergÃ©tique(*),EfficacitÃ© de lavage(*),EfficacitÃ© de sÃ©chage(*),TITRE CARACTERISTIQUES PHYSIQUES:,HxLxP(encm),Poids(enkg),Nombre de programmes(*),Consommation d\\''eau(*),Consommation d\\''energie(*)'),
(45, 'frigo', 'niveau sonore en db,nombre de couverts,dÃ©part diffÃ©rÃ©,classe Ã©nergÃ©tique,efficacitÃ© de lavage,efficacitÃ© de sÃ©chage,nombre de programmes,consommation d\\\\\\\\\\\\\\''eau,consommation d\\\\\\\\\\\\\\''energie', 'TITREINFORMATIONS GENERALES:,Niveau sonore en db(*),Nombre de couverts(*),DÃ©part diffÃ©rÃ©(*),Couleur,TITRE CONSOMMATIONS:,Classe Ã©nergÃ©tique(*),EfficacitÃ© de lavage(*),EfficacitÃ© de sÃ©chage(*),TITRE CARACTERISTIQUES PHYSIQUES:,HxLxP(encm),Poids(enkg),Nombre de programmes(*),Consommation d\\\\\\\\\\\\\\''eau(*),Consommation d\\\\\\\\\\\\\\''energie(*)'),
(46, 'refrigerateur', 'consommation_eau', 'TITREINFORMATIONSGENERALES:,Couleur,TITRE CONSOMMATIONS:,Consommation_eau(*),TITRE CARACTERISTIQUES PHYSIQUES:,HxLxP(encm),Poids(enkg)'),
(47, 'pat', '', 'TITREINFORMATIONSGENERALES:,Couleur,TITRECONSOMMATIONS:,TITRE CARACTERISTIQUES PHYSIQUES:,HxLxP(encm),Poids(enkg),Classe d\\''efficacitÃ© de lavage (*),Consommation d\\''eau(*),niveau d\\''Ã©nergie(*)'),
(48, 'lolo', '', 'TITREINFORMATIONSGENERALES:,Couleur,TITRECONSOMMATIONS:,TITRECARACTERISTIQUES PHYSIQUES:,HxLxP(encm),Poids(enkg),Consommation d\\''eau(*),niveau d\\''Ã©nergie(*)'),
(49, 'aqw', '', 'TITREINFORMATIONSGENERALES:,Couleur,TITRECONSOMMATIONS:,TITRECARACTERISTIQUESPHYSIQUES:,HxLxP(encm),Poids(enkg),Consommation eau(*),Niveau energie(*)'),
(50, 'bingo', '', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITREDISPOSITIFDESECURITE,Anti-balours,Anti-mousse,TITRECaractÃ©ristiquesphysiques,HxLxP(encm),Poids(enkg)'),
(51, 'pipo', '', 'TITREINFORMATIONSGENERALES:,Couleur,Chargement(*),Nombredeprogrammes,vitesse_essorage_trs_min(*),Capacite_lavage_Kg(*),TITRECONSOMMATIONS:,Consommation_energie_KWh_cycle(*),Classe_efficacite_essorage(*),TITREDISPOSITIFDESECURITE,Anti-balours,Anti-mousse,TITRECaractÃ©ristiquesphysiques,HxLxP(encm),Poids(enkg)'),
(53, 'lave_linge', 'alpha,beta,gamma,houpla', '');

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

--
-- Structure de la table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `cat_id` int(8) NOT NULL auto_increment,
  `cat_name` varchar(255) NOT NULL default '',
  `cat_description` varchar(255) NOT NULL default '',
  `create_by` varchar(255) NOT NULL default '',
  `date_creation` date NOT NULL default '0000-00-00',
  `heure_creation` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`cat_id`),
  UNIQUE KEY `cat_name_unique` (`cat_name`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

--
-- Contenu de la table `categories`
--

INSERT INTO `categories` (`cat_id`, `cat_name`, `cat_description`, `create_by`, `date_creation`, `heure_creation`) VALUES
(1, 'Programmation', 'infos', '', '0000-00-00', '00:00:00'),
(2, 'Design', 'Discussion sur des problémes rencontrés', '', '0000-00-00', '00:00:00'),
(3, 'Robotique', 'Les fondamentaux', '', '0000-00-00', '00:00:00'),
(4, 'essai', 'blalba', '33', '0000-00-00', '00:00:00'),
(6, 'debug', 'test et évaluation', '33', '2013-03-17', '10:41:00'),
(7, 'patrice catégorie', 'Debug les scrips php du site', '33', '2013-04-01', '11:51:00'),
(8, 'nouvelle categorie', 'blabla', '', '2013-12-18', '23:03:00');

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

--
-- Structure de la table `classement`
--

CREATE TABLE IF NOT EXISTS `classement` (
  `id` int(11) NOT NULL auto_increment,
  `joueur` varchar(30) NOT NULL default '',
  `elo` int(11) NOT NULL default '0',
  `initial` int(11) NOT NULL default '0',
  `parties` int(11) NOT NULL default '0',
  `prior` int(11) NOT NULL default '0',
  `bonus` int(11) NOT NULL default '0',
  `oldrating` int(11) NOT NULL default '0',
  `gcount` int(11) NOT NULL default '0',
  `wins` int(11) NOT NULL default '0',
  `losses` int(11) NOT NULL default '0',
  `draws` int(11) NOT NULL default '0',
  `active` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

--
-- Contenu de la table `classement`
--

INSERT INTO `classement` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
(1, 'alexandre', 817, 750, 9, 9, 0, 842, 9, 3, 6, 0, 1),
(2, 'amokrane', 938, 1050, 80, 50, 0, 903, 80, 26, 54, 0, 1),
(3, 'bertrand', 897, 950, 7, 7, 0, 832, 7, 3, 4, 0, 1),
(4, 'damien', 853, 1000, 15, 15, 0, 890, 15, 5, 10, 0, 1),
(5, 'dominique', 1384, 1100, 118, 50, 0, 1357, 118, 65, 49, 4, 1),
(6, 'emile', 697, 850, 20, 20, 0, 716, 20, 3, 16, 1, 1),
(7, 'fabien', 1235, 1300, 138, 50, 0, 1228, 138, 74, 62, 2, 1),
(8, 'franckdc', 963, 1000, 71, 50, 0, 987, 71, 31, 40, 0, 1),
(9, 'franckv', 1172, 1000, 136, 50, 0, 1195, 136, 64, 68, 4, 1),
(10, 'henrique', 1433, 1300, 145, 50, 0, 1458, 145, 113, 29, 3, 1),
(11, 'joel', 684, 950, 9, 9, 0, 698, 9, 0, 9, 0, 1),
(12, 'laurent', 1229, 1200, 85, 50, 0, 1222, 85, 53, 30, 2, 1),
(13, 'olivier', 1166, 1250, 10, 10, 0, 1131, 10, 5, 5, 0, 1),
(14, 'patrick', 1022, 1000, 31, 31, 0, 1001, 31, 13, 18, 0, 1),
(15, 'remy', 915, 1100, 77, 50, 0, 950, 77, 22, 54, 1, 1),
(16, 'stephaneb', 996, 1000, 14, 14, 0, 1010, 14, 6, 8, 0, 1),
(17, 'stephaner', 917, 1000, 94, 50, 0, 927, 94, 35, 55, 4, 1),
(18, 'thierry', 651, 1000, 5, 5, 0, 650, 5, 0, 4, 1, 1);

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

--
-- Structure de la table `classement_categorie`
--

CREATE TABLE IF NOT EXISTS `classement_categorie` (
  `id` int(11) NOT NULL auto_increment,
  `nom_categorie` varchar(30) NOT NULL default '',
  `position` int(2) NOT NULL default '0',
  `nom_table` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

--
-- Contenu de la table `classement_categorie`
--

INSERT INTO `classement_categorie` (`id`, `nom_categorie`, `position`, `nom_table`) VALUES
(1, 'Lave-linge', 1, 'lave_linge'),
(2, 'Seche-linge', 2, 'bost'),
(3, 'Lave-vaisselle', 3, '');

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

--
-- Structure de la table `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(10) NOT NULL auto_increment,
  `email` varchar(100) NOT NULL default '',
  `login` varchar(50) NOT NULL default '',
  `password` varchar(150) NOT NULL default '',
  `age` varchar(150) NOT NULL default '',
  `telephone` varchar(50) NOT NULL default '',
  `nom` varchar(50) NOT NULL default '',
  `prenom` varchar(50) NOT NULL default '',
  `adresse` varchar(100) NOT NULL default '',
  `complement` varchar(100) NOT NULL default '',
  `cp` varchar(20) NOT NULL default '',
  `ville` varchar(80) NOT NULL default '',
  `date_inscription` varchar(50) NOT NULL default '',
  `username` varchar(200) default NULL,
  `identifiant` varchar(30) NOT NULL default '',
  `civilite` varchar(10) NOT NULL default '',
  `heure` varchar(30) NOT NULL default '',
  `statut_compte` varchar(10) NOT NULL default '',
  `abonnement` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `prenom` (`prenom`),
  FULLTEXT KEY `prenom_2` (`prenom`),
  FULLTEXT KEY `addresse1` (`adresse`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;

--
-- Contenu de la table `clients`
--

INSERT INTO `clients` (`id`, `email`, `login`, `password`, `age`, `telephone`, `nom`, `prenom`, `adresse`, `complement`, `cp`, `ville`, `date_inscription`, `username`, `identifiant`, `civilite`, `heure`, `statut_compte`, `abonnement`) VALUES
(1, 'patrice.delpy@yahoo.fr', 'rainbow', 'tarte', '38', '0561409327', 'delpy de montcuq', 'patrice', '40 rue cuvier', 'Appt 16', '31100', 'toulouse', '06 février 2010', 'laurent', '', 'M', '', 'actif', ''),
(2, 'lui', 'ffxmph', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', 'bloquer', ''),
(3, 'patrice.delpy@toto.fr', '', 'rainbow', '', '0545513232', 'puce', 'bob', 'kljklj', '', '78150', 'paris', '', NULL, '', '', '', 'actif', ''),
(4, 'rien.tutu@orange.fr', 'moimeme', 'rainbow', '', '0545513232', 'durand', 'jacques', 'jkhkj', 'jkh', '31458', 'lyon', '', NULL, '', '', '', 'actif', ''),
(5, 'patrice.delpy@sfr.fr', 'ffxmpa', 'azerty', '', '0545513232', 'bond', 'james', '132, Becker Street', '', '78150', 'Versailles', '03-04-2010', NULL, 'ffxmph', 'M', '23:08', 'actif', ''),
(6, 'patrice.delpy@neuf.com', '', 'rainbow', '', '', 'martin', 'patrice', '40 rue cuvier', 'kljkljkljk hlkh', '31454', 'toukouse-er', '', 'laurence', '', '', '', 'bloquer', ''),
(7, 'pat.delu@free.fr', '', 'rainbow', '', '', '', '', '', '', '', '', '', NULL, 'patrice', '', '', 'actif', ''),
(8, 'patrice.del@tutu.fr', '', 'rainbow', '', '0561409454', 'tartuffe', 'laurence', '1 rue du stade', '', '81120', 'paris', '', NULL, 'moimeme', '3', '', 'actif', ''),
(9, 'patrice.del@tutu.fr', '', 'rainbow', '', '05614151617', 'tartuffe', 'laurence', '1 rue du stade', '', '81120', 'paris saint Lazare', '', NULL, 'moimeme', 'Mlle', '', 'actif', ''),
(10, 'patrice.delpy@onsemi.com', '', 'rainbow', '', '0102030405', 'blase', 'prenom', 'rien', '', '11111', 'tarbes', '27-03-2010', NULL, 'personnel', 'M', '21:35', 'bloquer', ''),
(12, '0000patrice.delpy@sfr.fr', '', 'aqwzsx', '', '0545513232', 'durand', 'vincent', '14 rue des flôts', 'APPT N47', '45120', 'aix', '27-03-2010', NULL, 'turlututu', 'M', '23:26', 'actif', ''),
(17, 'bob.sinclar@dst.fr', '', 'rainbow', '', '0563455132', 'bob', 'sinclar', 'inconne', '', '12345', 'terre', '03-10-2010', NULL, 'tartuffe', 'M', '17:47', 'actif', ''),
(16, 'patrice.delpy@hotmail.fr', '', 'rainbow', '14-6-2000', '0102030405', 'delpy', 'patrice', '1 rue du stade', '', '75210', 'Londres', '09-10-2010', NULL, 'patoche', 'M', '18:59', 'actif', 'oui'),
(25, 'ffxmph@onsemi.com', '', 'rainbow', '--', '0563455132', 'delpy', 'patrice', '1 rue du quai', 'Etage 2 - Porte N16', '31000', 'toulouse', '08-10-2010', NULL, 'patoche', 'M', '17:00', 'actif', 'non'),
(26, 'essai@free.fr', '', 'rainbow', '14-8-1994', '0563455132', 'riri', 'lulu', 'en fin de rue', '', '44250', 'Nice', '10-10-2010', NULL, 'vincent', 'M', '11:57', 'actif', 'non'),
(27, 'patrice.delpy@cegetel.net', '', 'rainbow', '--', '0102030405', 'tom', 'ducon', 'UN petit cochon', '', '12345', 'albi', '10-10-2010', NULL, 'lucien', 'M', '18:08', 'actif', 'oui');

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

--
-- Structure de la table `cochono`
--

CREATE TABLE IF NOT EXISTS `cochono` (
  `id` int(11) NOT NULL auto_increment,
  `titre` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `photo` varchar(255) default NULL,
  `ville` varchar(40) default NULL,
  `pays` enum('Belgique','France','Luxembourg') default NULL,
  `prix` decimal(8,2) NOT NULL default '0.00',
  `dateinsertion` date default NULL,
  `telephone` varchar(15) default NULL,
  `mail` varchar(30) default NULL,
  `patoche` varchar(30) default NULL,
  PRIMARY KEY  (`id`),
  KEY `ville` (`ville`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `cochono`
--


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

--
-- Structure de la table `coco`
--

CREATE TABLE IF NOT EXISTS `coco` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `coco`
--


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

--
-- Structure de la table `commandes`
--

CREATE TABLE IF NOT EXISTS `commandes` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(100) NOT NULL default '',
  `commande` text NOT NULL,
  `heure` varchar(50) NOT NULL default '',
  `date` varchar(50) NOT NULL default '',
  `total_ttc` varchar(20) NOT NULL default '',
  `total_ht` varchar(20) NOT NULL default '',
  `livraison` varchar(100) NOT NULL default '',
  `reglement` varchar(20) NOT NULL default '',
  `frais_livraison` varchar(10) NOT NULL default '',
  `traitement` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=45 ;

--
-- Contenu de la table `commandes`
--

INSERT INTO `commandes` (`id`, `email`, `commande`, `heure`, `date`, `total_ttc`, `total_ht`, `livraison`, `reglement`, `frais_livraison`, `traitement`) VALUES
(12, 'patrice.delpy@sfr.fr', 'PT078-REF78fgd-lave_linge Candy REF78fgd-washer- 1 -799.00-645.00-fdg-hjfld-lave_linge Brandt hjfld-washer- 1 -700.00-645.00', '20:58', '30-09-2010', '1599.45', '1478.12', 'colissimo', 'virement', '10', ''),
(13, 'patrice.delpy@sfr.fr', 'PT078-REF78fgd-lave_linge Candy REF78fgd-washer- 1 -799.00-645.00-fdg-hjfld-lave_linge Brandt hjfld-washer- 1 -700.00-645.00', '21:20', '30-09-2010', '1499', '1290', 'colissimo', 'mandat', '10', ''),
(23, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-1-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-1-549.00-645.00', '11:12', '03-10-2010', '1749', '1745', 'point_relai', 'virement', '10', ''),
(26, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-1-1200.00-1100.00', '18:51', '03-10-2010', '1200', '1100', 'chronopost', 'paypal', '10', ''),
(27, 'patrice.delpy@hotmail.fr', 'XV37K09-REF456-lave_linge Brandt REF456-washer-1-549.00-645.00', '20:12', '04-10-2010', '549', '645', 'ups', 'mandat', '10', ''),
(29, 'patrice.delpy@hotmail.fr', 'fdg-hjfld-lave_linge Brandt hjfld-washer-1-700.00-645.00', '20:44', '04-10-2010', '700', '645', 'ups', 'paypal', '10', ''),
(31, 'patrice.delpy@hotmail.fr', 'fdg-hjfld-lave_linge Brandt hjfld-washer-1-700.00-645.00', '21:19', '04-10-2010', '700', '645', 'ups', 'paypal', '10', ''),
(32, 'patrice.delpy@hotmail.fr', 'fdg-hjfld-lave_linge Brandt hjfld-washer-1-700.00-645.00', '21:42', '04-10-2010', '700', '645', 'ups', 'paypal', '10', ''),
(33, 'patrice.delpy@hotmail.fr', 'PT078-REF78fgd-lave_linge Candy REF78fgd-washer-1-799.00-645.00', '21:59', '04-10-2010', '799', '645', 'gls', 'virement', '10', ''),
(34, 'patrice.delpy@hotmail.fr', 'PT078-REF78fgd-lave_linge Candy REF78fgd-washer-1-799.00-645.00', '22:08', '04-10-2010', '799', '645', 'gls', 'virement', '10', ''),
(35, 'patrice.delpy@hotmail.fr', 'PT078-REF78fgd-lave_linge Candy REF78fgd-washer-1-799.00-645.00', '22:12', '04-10-2010', '799', '645', 'gls', 'virement', '14.98', ''),
(36, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-4-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-2-549.00-645.00', '22:27', '04-10-2010', '5898', '5690', 'point_relai', 'cheque', '14.98', ''),
(38, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-4-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-2-549.00-645.00', '23:05', '04-10-2010', '5898', '5690', 'point_relai', 'cheque', '14.98', ''),
(39, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-4-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-2-549.00-645.00', '23:05', '04-10-2010', '5898', '5690', 'point_relai', 'cheque', '14.98', '3'),
(40, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-4-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-2-549.00-645.00', '23:06', '04-10-2010', '5898', '5690', 'point_relai', 'cheque', '14.98', '4'),
(41, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-4-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-2-549.00-645.00', '23:07', '04-10-2010', '5898', '5690', 'point_relai', 'cheque', '14.98', '2'),
(42, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-4-1200.00-1100.00-XV37K09-REF456-lave_linge Brandt REF456-washer-2-549.00-645.00', '23:23', '04-10-2010', '5898', '5690', 'point_relai', 'cheque', '14.98', '1'),
(43, 'patrice.delpy@hotmail.fr', 'TF785-XXX789-lave_linge Bosh XXX789-washer-14-1200.00-1100.00', '23:30', '04-10-2010', '16800', '15400', 'chronopost', 'paypal', '14.98', '5'),
(44, 'ffxmph@onsemi.com', 'TF785-XXX789-lave_linge Bosh XXX789-washer-1-1200.00-1100.00', '17:01', '08-10-2010', '1200', '1100', 'colissimo', 'cheque', '14.98', '3');

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

--
-- Structure de la table `configuration`
--

CREATE TABLE IF NOT EXISTS `configuration` (
  `id` int(5) NOT NULL auto_increment,
  `debut_saison` varchar(10) NOT NULL default '',
  `fin_saison` varchar(10) NOT NULL default '',
  `debut_zone_estivale` varchar(10) NOT NULL default '',
  `fin_zone_estivale` varchar(10) NOT NULL default '',
  `email_bailleur` varchar(50) NOT NULL default '',
  `gsm` varchar(30) NOT NULL default '',
  `fixe` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Contenu de la table `configuration`
--

INSERT INTO `configuration` (`id`, `debut_saison`, `fin_saison`, `debut_zone_estivale`, `fin_zone_estivale`, `email_bailleur`, `gsm`, `fixe`) VALUES
(1, '15-02-2015', '15-11-2015', '01-06-2015', '01-09-2015', 'patrice.delpy@neuf.fr', '06 38 91 10 47', '05 63 41 13 49');

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

--
-- Structure de la table `correspondance`
--

CREATE TABLE IF NOT EXISTS `correspondance` (
  `id` int(11) NOT NULL auto_increment,
  `categorie` varchar(25) NOT NULL default '',
  `filtre` varchar(255) NOT NULL default '',
  `association` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=29 ;

--
-- Contenu de la table `correspondance`
--

INSERT INTO `correspondance` (`id`, `categorie`, `filtre`, `association`) VALUES
(1, 'papou', 'chargement\r\n', 'chargement\r\n'),
(2, 'papou', 'nombre_de_programmes\r\n', 'nombre de programmes\r\n'),
(3, 'papou', 'vitesse_d\\_essorage_en_trsmin\r\n', 'vitesse d\\''essorage en trsmin\r\n'),
(4, 'papou', 'capacite_de_lavage_en_kg\r\n', 'capacite de lavage en kg\r\n'),
(5, 'aa', 'vitesse_d_explosion', 'vitesse d''explosion'),
(28, 'bost', 'six\r\n', 'six\r\n'),
(27, 'bost', 'cinq\r\n', 'cinq\r\n'),
(26, 'bost', 'quatre\r\n', 'quatre\r\n'),
(25, 'bost', 'trois\r\n', 'trois\r\n'),
(24, 'bost', 'deux\r\n', 'deux\r\n'),
(23, 'bost', 'un\r\n', 'un\r\n');

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

--
-- Structure de la table `cruchot`
--

CREATE TABLE IF NOT EXISTS `cruchot` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

--
-- Contenu de la table `cruchot`
--

INSERT INTO `cruchot` (`id`, `id_catalogue`, `designation`, `reference`, `marque`, `fournisseur`, `garantie`, `dispo`, `prix_ttc`, `prix_ht`, `remise`, `tva`, `descriptif`, `caracteristiques`, `image`, `stock`, `status`, `remarques`, `liens`, `heure`, `date`, `chargement`, `vitesse_essorage_trs_min`, `capacite_lavage_kg`, `consommation_energie_kwh_cycle`, `classe_efficacite_essorage`) VALUES
(1, 'riri', 'Lave linge', 'XZE45-045A0048', 'Whirlpool', 'Calport', '2', '24H', 878.45, 724.99, 'aucune 0.00', 5.50, '																														La simplicitÃ© et le confort avant tout !\r\nGrÃ¢ce au dÃ©part diffÃ©rÃ© , vous programmez votre lessive pour qu''elle soit terminÃ©e et prÃªte Ã  Ãªtre Ã©tendue dÃ¨s votre retour Ã  la maison. IdÃ©al pour limiter le linge froissÃ©, faciliter le repassage et gagner du temps.\r\nLa touche anti-froissage permet d''avoir un linge mieux rÃ©parti sur les parois du tambour, donc moins froissÃ©, grÃ¢ce Ã  un essorage adaptÃ© et Ã  un dÃ©foulage en fin de cycle.	\r\nJ''aime le pinard et les olives vertes. Puis j''Ã©tais malade mais tout est OK.\r\n		\r\n				Quel homme !!.		\r\n		', 'TITREINFORMATIONSGENERALES: & none,Couleur & blanche,Chargement(*) & Hublot,Nombredeprogrammes & 14,vitesse_essorage_trs_min(*) & 1200,Capacite_lavage_Kg(*) & 6.5,TITRE CONSOMMATIONS: & none,Consommation_energie_KWh_cycle(*) & 3.21,Classe_efficacite_essorage(*) & A++,TITRE DISPOSITIF DE SECURITE & none,Anti-balours & oui,Anti-mousse & oui,TITRE CaractÃ©ristiques physiques & none,HxLxP(encm) & 78x41x142,Poids(enkg) & 78,TITRE T1 & vide,a & 1,b & 2,TITRE T2 & vide,c & 3', 'presentation.jpg', '24', 'actif', '																				Accepte les cartes microSDHCâ„¢ jusqu''Ã  16Gb.\r\nGagnant du prix de design Red Dot 2010\r\nMise Ã  jour vers Android 2.1 annoncÃ©e pour le troisiÃ¨me trimestre 2010. \r\n		\r\nEt ta mÃ¨re ... ?.\r\n		', '								Forum consommateurs  $http://www.google.fr	\r\nTest du site les numÃ©riques $http://www.lesnumeriques.com\r\nhebergement $http://www.free.fr	\r\n				\r\n				\r\n				\r\n				\r\n				\r\n				\r\n		', '17:53', '08-08-2010', 'Hublot', '1200', '6.5', '3.21', 'A++'),
(12, 'bob', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '		', 'INFORMATIONSGENERALES: & TITRE\r\nCouleur & 1\r\nChargement(*) & 2\r\nNombredeprogrammes & 3\r\nvitesse_essorage_trs_min(*) & 4\r\nCapacite_lavage_Kg(*) & 5\r\n CONSOMMATIONS: & TITRE\r\nConsommation_energie_KWh_cycle(*) & 6\r\nClasse_efficacite_essorage(*) & 7\r\n DISPOSITIF DE SECURITE & TITRE\r\nAnti-balours & 8\r\nAnti-mousse & 9\r\n CaractÃ©ristiques physiques & TITRE\r\nHxLxP(encm) & 10\r\nPoidsaa(enkg) & 11\r\n		', '', '', 'actif', '		', '		', '21:39', '12-08-2010', '2', '4', '5', '6', '7'),
(9, 'jey', 'appareil', 'aaz', 'Xerox', 'lm', '14', '24H', 1000.00, 750.00, 'aucune 0.00', 5.50, 'que dal										\r\n		\r\n				\r\n		', 'TITRE INFORMATIONSGENERALES: & none\r\nCouleur & vide\r\nChargement(*) & vide\r\nNombredeprogrammes & vide\r\nvitesse_essorage_trs_min(*) & vide\r\nCapacite_lavage_Kg(*) & vide\r\nTITRE CONSOMMATIONS: & none\r\nConsommation_energie_KWh_cycle(*) & vide\r\nClasse_efficacite_essorage(*) & vide\r\nTITRE DISPOSITIF DE SECURITE & none\r\nAnti-balours & vide\r\nAnti-mousse & vide\r\nTITRE CaractÃ©ristiques physiques & none\r\nHxLxP(encm) & vide\r\nPoids(enkg) & vide\r\n\r\n		', '', '4', 'actif', 'bof								\r\n	\r\n		\r\n		', 'bilou										\r\n				\r\n				\r\n		', '22:43', '11-08-2010', 'vide', 'vide', 'vide', 'vide', 'vide'),
(8, '', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '123		', 'message', '', '155', 'actif', '456		', '789	', '16:51', '01-08-2010', 'x', 'x', 'x', 'x', 'x'),
(7, 'REF789ADZ0054', 'una', 'deuxa', 'troisa', 'quatrea', '5', '24H', 3001.00, 2501.00, '', 5.50, 'gg', 'TITREINFORMATIONSGENERALES: & none\r\nCouleur & noire\r\nChargement(*) & sur le devant\r\nNombredeprogrammes & 14\r\nvitesse_essorage_trs_min(*) & 25000\r\nCapacite_lavage_Kg(*) & 7.5\r\nTITRE CONSOMMATIONS: & none\r\nConsommation_energie_KWh_cycle(*) & 4.35\r\nClasse_efficacite_essorage(*) & A++\r\nTITRE DISPOSITIF DE SECURITE & none\r\nAnti-balours & non\r\nAnti-mousse & oui\r\nTITRE CaractÃ©ristiques physiques & none\r\nHxLxP(encm) & 556765\r\nPoids(enkg) & 1547\r\n\r\n		', '', '55', 'actif', 'bbbb	', 'cccc	', '16:42', '01-08-2010', 'sur le devant', '25000', '7.5', '4.35', 'A++'),
(10, 'zorro', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '		', 'INFORMATIONSGENERALES: & TITRE\r\nCouleur & a\r\nChargement(*) & b\r\nNombredeprogrammes & c\r\nvitesse_essorage_trs_min(*) & d\r\nCapacite_lavage_Kg(*) & e\r\n CONSOMMATIONS: & TITRE\r\nConsommation_energie_KWh_cycle(*) & f\r\nClasse_efficacite_essorage(*) & g\r\n DISPOSITIF DE SECURITE & TITRE\r\nAnti-balours & h\r\nAnti-mousse & i\r\n CaractÃ©ristiques physiques & TITRE\r\nHxLxP(encm) & j\r\naaPoids(enkg) & k\r\n\r\n		\r\n\r\n		', '', '', 'actif', '		', '		', '23:17', '11-08-2010', 'b', 'd', 'e', 'f', 'g'),
(11, 'TV', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '		', 'INFORMATIONSGENERALES: & TITRE\r\nCouleur & un\r\nChargement(*) & deux\r\nNombredeprogrammes & trois\r\nvitesse_essorage_trs_min(*) & quatre\r\nCapacite_lavage_Kg(*) & cinq\r\n CONSOMMATIONS: & TITRE\r\nConsommation_energie_KWh_cycle(*) & six\r\nClasse_efficacite_essorage(*) & setp\r\n DISPOSITIF DE SECURITE & TITRE\r\nAnti-balours & huit\r\nAnti-mousse & neuf\r\n CaractÃ©ristiques physiques & TITRE\r\nHxLxP(encm) & dix\r\nPoids(enkg) & douze\r\n		', '', '', 'actif', '		', '		', '20:26', '12-08-2010', 'deux', 'quatre', 'cinq', 'six', 'setp'),
(13, 'aqw', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '		', 'INFORMATIONSGENERALES: & TITRE\r\nCouleur & 1\r\nChargement(*) & 2\r\nNombredeprogrammes & 3\r\nvitesse_essorage_trs_min(*) & 4\r\nCapacite_lavage_Kg(*) & 5\r\n CONSOMMATIONS: & TITRE\r\nConsommation_energie_KWh_cycle(*) & 6\r\nClasse_efficacite_essorage(*) & 7\r\n DISPOSITIF DE SECURITE & TITRE\r\nAnti-balours & 8\r\nAnti-mousse & 9\r\n CaractÃ©ristiques physiques & TITRE\r\nHxLxP(encm) & 10\r\nPoidsaa(enkg) & 11', '', '', 'actif', '		', '		', '21:58', '12-08-2010', '2', '4', '5', '6', '7'),
(14, 'dick', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '		', 'INFORMATIONSGENERALES: & TITRE\r,Couleur & a\r,Chargement(*) & b\r,Nombredeprogrammes & c\r,vitesse_essorage_trs_min(*) & d\r,Capacite_lavage_Kg(*) & e\r, CONSOMMATIONS: & TITRE\r,Consommation_energie_KWh_cycle(*) & f\r,Classe_efficacite_essorage(*) & g\r, DISPOSITIF DE SECURITE & TITRE\r,Anti-balours & h\r,Anti-mousse & i\r, CaractÃ©ristiques physiques & TITRE\r,HxLxP(encm) & j\r,lulu(enkg) & k\r,connard & essai\r,nouveau & TITRE\r,bla du roi & valide\r,fgr & 707\r,fute & ateal 7\r,pipo & 14789', '', '', 'actif', '		', '		', '23:02', '12-08-2010', 'b', 'd', 'e', 'f', 'g'),
(15, 'kiwi', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '&lt;p&gt;\r\n	je ne sais pas&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & a,Chargement(*) & b,Nombredeprogrammes & c,vitesse_essorage_trs_min(*) & d,Capacite_lavage_Kg(*) & e, CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & f,Classe_efficacite_essorage(*) & g, DISPOSITIF DE SECURITE & TITRE,Anti-balours & h,Anti-mousse & i, CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & h,Poids(enkg) & j', '', '', 'actif', '		', '		', '23:16', '16-08-2010', 'b', 'd', 'e', 'f', 'g'),
(16, 'pomme', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '&lt;p&gt;\r\n	Un super &lt;strong&gt;produit&lt;/strong&gt;,&lt;/p&gt;\r\n&lt;p&gt;\r\n	H&amp;eacute;las, il est &lt;span style=&quot;color: rgb(255, 140, 0);&quot;&gt;&lt;u&gt;&lt;strong&gt;encore inconnu &lt;/strong&gt;&lt;/u&gt;&lt;/span&gt;c&amp;#39;est &amp;eacute;t&amp;eacute;&lt;/p&gt;\r\n&lt;ol&gt;\r\n	&lt;li&gt;\r\n		un&lt;/li&gt;\r\n	&lt;li&gt;\r\n		bla&lt;/li&gt;\r\n	&lt;li&gt;\r\n		lui&lt;/li&gt;\r\n&lt;/ol&gt;', 'INFORMATIONSGENERALES: & TITRE,Couleur & a,Chargement(*) & b,Nombredeprogrammes & c,vitesse_essorage_trs_min(*) & d,Capacite_lavage_Kg(*) & e, CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & f,Classe_efficacite_essorage(*) & g, DISPOSITIF DE SECURITE & TITRE,Anti-balours & h,Anti-mousse & i, CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & j,Poids(enkg) & k', '', '', 'actif', '		', '		', '23:24', '16-08-2010', 'b', 'd', 'e', 'f', 'g'),
(17, 'cerise', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '&lt;p&gt;\r\n	Mega &lt;span style=&quot;font-size: 26px;&quot;&gt;cool&lt;/span&gt;&lt;/p&gt;', 'INFORMATIONSGENERALES: & TITRE,Couleur & ,Chargement(*) & ,Nombredeprogrammes & ,vitesse_essorage_trs_min(*) & ,Capacite_lavage_Kg(*) & , CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & ,Classe_efficacite_essorage(*) & , DISPOSITIF DE SECURITE & TITRE,Anti-balours & ,Anti-mousse & , CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '10:56', '17-08-2010', 'vide', 'vide', 'vide', 'vide', 'vide'),
(18, 'citron', '', '', '', '', '', '24H', 0.00, 0.00, 'aucune', 19.60, '&lt;p&gt;\r\n	&lt;u&gt;message&lt;/u&gt;&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE\r,Couleur & \r,Chargement(*) & Frontal\r,Nombredeprogrammes & \r,vitesse_essorage_trs_min(*) & 850\r,Capacite_lavage_Kg(*) & 6.5\r, CONSOMMATIONS: & TITRE\r,Consommation_energie_KWh_cycle(*) & 4\r,Classe_efficacite_essorage(*) & A+\r, DISPOSITIF DE SECURITE & TITRE\r,Anti-balours & \r,Anti-mousse & \r, CaractÃ©ristiques physiques & TITRE\r,HxLxP(encm) & \r,Poids(enkg) &', '', '', 'actif', '		', '		', '10:57', '17-08-2010', 'vide', 'vide', 'vide', 'vide', 'vide');

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

--
-- Structure de la table `datas_membres`
--

CREATE TABLE IF NOT EXISTS `datas_membres` (
  `member_id` mediumint(7) unsigned NOT NULL auto_increment,
  `active` enum('disable','enable') NOT NULL default 'disable',
  `firstname` char(24) NOT NULL default '',
  `lastname` char(24) NOT NULL default '',
  `email` char(32) NOT NULL default '',
  `login` char(16) NOT NULL default '',
  `password` char(16) NOT NULL default '',
  `website` char(32) NOT NULL default '',
  `createdate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`member_id`),
  UNIQUE KEY `login` (`login`),
  KEY `login_2` (`login`),
  KEY `member_id` (`member_id`),
  KEY `active` (`active`),
  KEY `createdate` (`createdate`),
  KEY `email` (`email`),
  KEY `firstname` (`firstname`),
  KEY `lastname` (`lastname`),
  KEY `password` (`password`),
  KEY `website` (`website`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

--
-- Contenu de la table `datas_membres`
--

INSERT INTO `datas_membres` (`member_id`, `active`, `firstname`, `lastname`, `email`, `login`, `password`, `website`, `createdate`) VALUES
(1, 'enable', 'patrice vincent', 'Delpy', 'patrice.delpy@wanadoo.fr', 'admin', 'test', 'underconstruction', '2002-09-24'),
(2, 'enable', 'alain', 'De Monfort', 'gronard@free.fr', 'demo01', 'test', '', '2002-09-24'),
(3, 'enable', 'Edouard', 'couille molle', 'adefinir@free.fr', 'demo02', 'test', '', '2002-09-25'),
(4, 'enable', 'charlie', 'Berlot', 'ra794c@email.sps.mot.com', 'charlie', 'test', '', '2002-09-27'),
(5, 'enable', 'pat', 'blase', 'r2755c@motorola.com', 'pdl', 'pdl', '', '2003-02-12'),
(6, 'enable', 'moi', 'enocre moi', 'pat@free.fr', 'pat', 'pat', '', '2004-02-23');

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

--
-- Structure de la table `debugposts`
--

CREATE TABLE IF NOT EXISTS `debugposts` (
  `post_id` int(8) NOT NULL auto_increment,
  `post_content` text NOT NULL,
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_topic` int(8) NOT NULL default '0',
  `post_by` int(8) NOT NULL default '0',
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

--
-- Contenu de la table `debugposts`
--

INSERT INTO `debugposts` (`post_id`, `post_content`, `post_date`, `post_topic`, `post_by`) VALUES
(1, '<p><img alt="" src="/WORKAREA/WEBSITE/TP/Users/pipo/images/jana-jordan-100508-p05-3k_095.jpg" style="width: 400px; height: 600px;" /></p>\r\n\r\n<p>Petit message de Patrice</p>\r\n', '2013-03-24 18:07:19', 14, 2),
(2, '<p><img alt="" src="/WORKAREA/WEBSITE/TP/Users/pipo/images/jana-jordan-100508-p05-3k_095.jpg" style="width: 400px; height: 600px;" /></p>\r\n\r\n<p>Petit message de Patrice et du</p>\r\n', '2013-03-24 18:16:35', 14, 2),
(3, '<p>Petit message de Patrice</p>\r\n', '2013-03-25 22:09:51', 14, 2);

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

--
-- Structure de la table `droits`
--

CREATE TABLE IF NOT EXISTS `droits` (
  `id` int(11) NOT NULL default '0',
  `heure` varchar(30) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  `fdgg` text,
  `ffxmph` text,
  `connard` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Contenu de la table `droits`
--

INSERT INTO `droits` (`id`, `heure`, `date`, `fdgg`, `ffxmph`, `connard`) VALUES
(1, '', '', 'PROJ1-Root,PROJ2-Root,PROJ3-Leader,', 'P1-User,P2-User,', 'EVOLUTION-Leader,');

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

--
-- Structure de la table `equipe`
--

CREATE TABLE IF NOT EXISTS `equipe` (
  `id` int(11) NOT NULL auto_increment,
  `membre` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

--
-- Contenu de la table `equipe`
--

INSERT INTO `equipe` (`id`, `membre`) VALUES
(1, 'Anissa'),
(2, 'Aurore'),
(3, 'Alexandre'),
(4, 'Fabien'),
(5, 'Julien'),
(6, 'Patrice'),
(7, 'Virginie');

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

--
-- Structure de la table `essai`
--

CREATE TABLE IF NOT EXISTS `essai` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Contenu de la table `essai`
--

INSERT INTO `essai` (`id`, `id_catalogue`, `designation`, `reference`, `marque`, `fournisseur`, `garantie`, `dispo`, `prix_ttc`, `prix_ht`, `remise`, `tva`, `descriptif`, `caracteristiques`, `image`, `stock`, `status`, `remarques`, `liens`, `heure`, `date`, `chargement`, `vitesse_essorage_trs_min`, `capacite_lavage_kg`, `consommation_energie_kwh_cycle`, `classe_efficacite_essorage`) VALUES
(1, 'sigma', '', '', '', '', '', '', 0.00, 0.00, '', 0.00, '', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Structure de la table `evenements`
--

CREATE TABLE IF NOT EXISTS `evenements` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `type` mediumint(4) NOT NULL default '0',
  `id_membre` int(6) NOT NULL default '0',
  `titre` varchar(100) NOT NULL default '',
  `texte` text NOT NULL,
  `heure` varchar(30) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Contenu de la table `evenements`
--

INSERT INTO `evenements` (`id`, `type`, `id_membre`, `titre`, `texte`, `heure`, `date`, `notes`) VALUES
(1, 0, 0, 'toto', 'blabla', '10-14', '22-05-2011', 'rien');

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

--
-- Structure de la table `evolution`
--

CREATE TABLE IF NOT EXISTS `evolution` (
  `playerID` int(11) default NULL,
  `rating` int(11) default NULL,
  `date` int(11) default NULL
) TYPE=MyISAM;

--
-- Contenu de la table `evolution`
--

INSERT INTO `evolution` (`playerID`, `rating`, `date`) VALUES
(10, 1500, 1398376800),
(7, 1100, 1398376800),
(7, 1100, 1398636000),
(10, 1500, 1398636000),
(10, 1500, 1398722400),
(15, 1100, 1398722400),
(7, 1233, 1398808800),
(5, 900, 1398808800),
(17, 750, 1399240800),
(5, 1150, 1399240800),
(7, 1199, 1399240800),
(10, 1533, 1399240800),
(7, 1259, 1399327200),
(15, 949, 1399327200),
(5, 1144, 1400450400),
(10, 1536, 1400450400),
(10, 1537, 1400536800),
(5, 1142, 1400536800),
(7, 1140, 1400536800),
(15, 1185, 1400536800),
(10, 1537, 1400623200),
(7, 1139, 1400623200),
(15, 1073, 1402437600),
(7, 1194, 1402437600),
(7, 1272, 1402524000),
(10, 1444, 1402524000),
(10, 1379, 1402783200),
(7, 1330, 1402783200),
(15, 1214, 1402869600),
(10, 1310, 1402869600),
(7, 1291, 1403128800),
(10, 1348, 1403128800),
(10, 1369, 1403647200),
(15, 1169, 1403647200),
(5, 1193, 1403733600),
(18, 871, 1403733600),
(15, 1140, 1403820000),
(10, 1383, 1403820000),
(10, 1404, 1404252000),
(7, 1266, 1404252000),
(7, 1286, 1404338400),
(15, 1105, 1404338400),
(15, 1081, 1404338400),
(7, 1300, 1404338400),
(7, 1281, 1404684000),
(10, 1422, 1404684000),
(5, 1241, 1404684000),
(15, 1053, 1404684000),
(10, 1385, 1404770400),
(5, 1324, 1404770400),
(10, 1344, 1404856800),
(15, 1116, 1404856800),
(5, 1268, 1404856800),
(7, 1309, 1404856800),
(5, 1233, 1404943200),
(10, 1361, 1404943200),
(12, 1358, 1405029600),
(15, 1090, 1405029600),
(12, 1495, 1405375200),
(5, 1206, 1405375200),
(10, 1336, 1405375200),
(7, 1336, 1405375200),
(4, 968, 1405548000),
(10, 1341, 1405548000),
(7, 1314, 1405893600),
(10, 1362, 1405893600),
(5, 1257, 1405893600),
(10, 1331, 1405893600),
(5, 1229, 1405980000),
(7, 1332, 1405980000),
(5, 1241, 1405980000),
(8, 914, 1405980000),
(10, 1362, 1405980000),
(12, 1307, 1405980000),
(10, 1376, 1406152800),
(5, 1221, 1406152800),
(15, 1070, 1406152800),
(5, 1238, 1406152800),
(10, 1394, 1406152800),
(7, 1312, 1406152800),
(7, 1294, 1406239200),
(10, 1409, 1406239200),
(10, 1420, 1406498400),
(5, 1224, 1406498400),
(7, 1279, 1406584800),
(10, 1433, 1406584800),
(5, 1203, 1406671200),
(7, 1298, 1406671200),
(7, 1269, 1406671200),
(5, 1234, 1406671200),
(7, 1248, 1406757600),
(12, 1397, 1406757600),
(10, 1437, 1406757600),
(15, 1063, 1406757600),
(7, 1260, 1406757600),
(15, 1048, 1406757600),
(10, 1406, 1406757600),
(5, 1270, 1406757600),
(5, 1255, 1406844000),
(10, 1418, 1406844000),
(10, 1429, 1407103200),
(7, 1246, 1407103200),
(4, 968, 1407103200),
(12, 1397, 1407103200),
(10, 1430, 1407103200),
(8, 914, 1407103200),
(12, 1405, 1407103200),
(15, 1041, 1407103200),
(7, 1233, 1407189600),
(10, 1440, 1407189600),
(10, 1443, 1407189600),
(15, 1035, 1407189600),
(9, 1000, 1407276000),
(10, 1445, 1407276000),
(12, 1353, 1407276000),
(10, 1462, 1407276000),
(15, 1021, 1407276000),
(7, 1244, 1407276000),
(8, 1083, 1407276000),
(15, 983, 1407276000),
(8, 1077, 1407362400),
(10, 1465, 1407362400),
(15, 954, 1407362400),
(9, 1191, 1407362400),
(10, 1473, 1407794400),
(7, 1233, 1407794400),
(7, 1223, 1407967200),
(10, 1480, 1407967200),
(7, 1200, 1408917600),
(5, 1276, 1408917600),
(7, 1230, 1408917600),
(5, 1247, 1408917600),
(12, 1318, 1409522400),
(10, 1492, 1409522400),
(4, 830, 1409522400),
(15, 985, 1409522400),
(10, 1499, 1409608800),
(5, 1237, 1409608800),
(2, 940, 1409608800),
(7, 1242, 1409608800),
(7, 1281, 1409695200),
(10, 1468, 1409695200),
(12, 1329, 1409781600),
(15, 977, 1409781600),
(10, 1469, 1409781600),
(2, 940, 1409781600),
(8, 1075, 1410127200),
(10, 1472, 1410127200),
(17, 663, 1410213600),
(15, 989, 1410213600),
(5, 1250, 1410213600),
(8, 1035, 1410213600),
(5, 1231, 1410300000),
(12, 1360, 1410300000),
(2, 838, 1410386400),
(8, 1078, 1410386400),
(5, 1221, 1410386400),
(10, 1479, 1410386400),
(5, 1211, 1410732000),
(10, 1486, 1410732000),
(12, 1371, 1410818400),
(8, 1063, 1410818400),
(5, 1221, 1410818400),
(15, 976, 1410818400),
(15, 1023, 1410818400),
(5, 1181, 1410818400),
(17, 663, 1410818400),
(10, 1486, 1410818400),
(8, 1040, 1410818400),
(13, 1356, 1410818400),
(16, 800, 1410904800),
(14, 1200, 1410904800),
(5, 1187, 1410904800),
(2, 823, 1410904800),
(10, 1486, 1410904800),
(17, 663, 1410904800),
(10, 1488, 1411336800),
(15, 1019, 1411336800),
(10, 1456, 1411423200),
(5, 1229, 1411423200),
(2, 823, 1411509600),
(10, 1456, 1411509600),
(8, 968, 1411509600),
(17, 818, 1411509600),
(5, 1251, 1411509600),
(14, 1014, 1411509600),
(2, 823, 1411596000),
(12, 1373, 1411596000),
(7, 1284, 1411596000),
(17, 818, 1411596000),
(7, 1271, 1411682400),
(10, 1466, 1411682400),
(12, 1313, 1411941600),
(17, 932, 1411941600),
(5, 1270, 1412114400),
(9, 1077, 1412114400),
(12, 1280, 1412114400),
(7, 1297, 1412114400),
(2, 823, 1412200800),
(7, 1299, 1412200800),
(5, 1278, 1412200800),
(15, 1008, 1412200800),
(7, 1320, 1412632800),
(5, 1256, 1412632800),
(9, 1274, 1412632800),
(10, 1431, 1412632800),
(10, 1442, 1412805600),
(9, 1225, 1412805600),
(10, 1452, 1413237600),
(5, 1243, 1413237600),
(7, 1305, 1413324000),
(10, 1464, 1413324000),
(8, 1000, 1413324000),
(17, 886, 1413324000),
(15, 978, 1413410400),
(8, 1034, 1413410400),
(14, 1014, 1413756000),
(10, 1466, 1413756000),
(2, 923, 1413842400),
(5, 1198, 1413842400),
(17, 971, 1413842400),
(10, 1428, 1413842400),
(10, 1430, 1414015200),
(17, 965, 1414015200),
(16, 1107, 1414015200),
(14, 860, 1414015200),
(17, 1028, 1414101600),
(7, 1265, 1414101600),
(7, 1274, 1414364400),
(8, 1021, 1414364400),
(13, 1193, 1414364400),
(10, 1445, 1414364400),
(2, 918, 1414450800),
(10, 1446, 1414450800),
(5, 1222, 1414450800),
(13, 1061, 1414450800),
(8, 1037, 1414450800),
(14, 812, 1414450800),
(13, 1201, 1414450800),
(5, 1187, 1414450800),
(10, 1453, 1414537200),
(5, 1177, 1414537200),
(7, 1297, 1414623600),
(12, 1252, 1414623600),
(14, 945, 1414623600),
(9, 1091, 1414623600),
(12, 1271, 1414623600),
(5, 1157, 1414623600),
(7, 1303, 1415055600),
(15, 969, 1415055600),
(5, 1149, 1415055600),
(10, 1459, 1415055600),
(17, 1051, 1415055600),
(2, 890, 1415055600),
(7, 1289, 1415228400),
(10, 1470, 1415228400),
(12, 1284, 1415228400),
(16, 1028, 1415228400),
(9, 1130, 1415314800),
(15, 949, 1415314800),
(10, 1479, 1416178800),
(7, 1277, 1416178800),
(10, 1445, 1416265200),
(5, 1194, 1416265200),
(15, 941, 1416265200),
(12, 1289, 1416265200),
(2, 882, 1416265200),
(7, 1281, 1416265200),
(5, 1209, 1416351600),
(17, 1032, 1416351600),
(10, 1456, 1416351600),
(12, 1275, 1416351600),
(5, 1172, 1416438000),
(8, 1078, 1416438000),
(10, 1459, 1416783600),
(8, 1072, 1416783600),
(15, 928, 1416783600),
(5, 1182, 1416783600),
(5, 1173, 1416870000),
(10, 1465, 1416870000),
(9, 1121, 1416870000),
(10, 1469, 1416870000),
(17, 1027, 1416956400),
(10, 1471, 1416956400),
(5, 1191, 1417042800),
(8, 1052, 1417042800),
(10, 1439, 1417388400),
(5, 1232, 1417388400),
(9, 1143, 1417388400),
(15, 912, 1417388400),
(9, 1113, 1417474800),
(5, 1250, 1417474800),
(2, 918, 1417474800),
(15, 878, 1417474800),
(8, 1046, 1417474800),
(10, 1442, 1417474800),
(5, 1275, 1417561200),
(12, 1250, 1417561200),
(5, 1288, 1417647600),
(9, 1092, 1417647600),
(5, 1320, 1417734000),
(10, 1414, 1417734000),
(12, 1263, 1417734000),
(9, 1072, 1417734000),
(5, 1339, 1417993200),
(7, 1260, 1417993200),
(5, 1346, 1418079600),
(9, 1061, 1418079600),
(10, 1425, 1418079600),
(7, 1246, 1418079600),
(5, 1329, 1418166000),
(10, 1440, 1418166000),
(9, 1104, 1418166000),
(12, 1227, 1418166000),
(9, 1151, 1418252400),
(10, 1405, 1418252400),
(9, 1159, 1418684400),
(15, 867, 1418684400),
(5, 1311, 1418684400),
(10, 1421, 1418684400),
(9, 1169, 1418770800),
(2, 905, 1418770800),
(17, 1013, 1418770800),
(12, 1238, 1418770800),
(12, 1209, 1418857200),
(9, 1199, 1418857200),
(15, 911, 1418857200),
(17, 972, 1418857200),
(5, 1295, 1418943600),
(10, 1435, 1418943600),
(17, 968, 1420498800),
(10, 1437, 1420498800),
(5, 1268, 1420498800),
(7, 1273, 1420498800),
(10, 1445, 1420585200),
(9, 1188, 1420585200),
(8, 1011, 1420585200),
(17, 1004, 1420585200),
(7, 1290, 1420585200),
(9, 1168, 1420585200),
(15, 941, 1420671600),
(2, 874, 1420671600),
(12, 1181, 1420671600),
(9, 1196, 1420671600),
(7, 1297, 1420671600),
(17, 994, 1420671600),
(7, 1266, 1421103600),
(12, 1214, 1421103600),
(9, 1186, 1421103600),
(10, 1452, 1421103600),
(9, 1166, 1421103600),
(5, 1286, 1421103600),
(9, 1148, 1421190000),
(5, 1301, 1421190000),
(9, 1184, 1421190000),
(5, 1268, 1421190000),
(7, 1225, 1421190000),
(15, 993, 1421190000),
(9, 1211, 1421276400),
(12, 1187, 1421276400),
(2, 852, 1421276400),
(17, 1013, 1421276400),
(7, 1214, 1421276400),
(10, 1460, 1421276400),
(3, 909, 1421622000),
(5, 1274, 1421622000),
(9, 1222, 1421622000),
(17, 999, 1421622000),
(10, 1448, 1421708400),
(9, 1236, 1421708400),
(5, 1235, 1421708400),
(17, 1047, 1421708400),
(9, 1198, 1421794800),
(8, 1056, 1421794800),
(10, 1412, 1421794800),
(17, 1098, 1421794800),
(15, 1037, 1421881200),
(9, 1159, 1421881200),
(2, 901, 1421881200),
(8, 1013, 1421881200),
(10, 1402, 1421881200),
(5, 1246, 1421881200),
(2, 943, 1421967600),
(15, 998, 1421967600),
(13, 1243, 1421967600),
(8, 998, 1421967600),
(10, 1410, 1422226800),
(9, 1148, 1422226800),
(7, 1175, 1422399600),
(15, 1043, 1422399600),
(5, 1255, 1422399600),
(8, 986, 1422399600),
(13, 1260, 1422399600),
(11, 896, 1422399600),
(2, 930, 1422486000),
(7, 1185, 1422486000),
(6, 818, 1422486000),
(12, 1193, 1422486000),
(9, 1170, 1422486000),
(17, 1074, 1422486000),
(18, 650, 1422572400),
(4, 940, 1422572400),
(7, 1209, 1422572400),
(9, 1145, 1422572400),
(2, 919, 1422831600),
(7, 1217, 1422831600),
(12, 1204, 1422831600),
(8, 972, 1422831600),
(5, 1241, 1422918000),
(10, 1421, 1422918000),
(9, 1136, 1422918000),
(10, 1427, 1422918000),
(7, 1231, 1422918000),
(17, 1057, 1422918000),
(7, 1219, 1423004400),
(10, 1436, 1423004400),
(17, 1022, 1423004400),
(8, 1008, 1423004400),
(12, 1199, 1423004400),
(9, 1141, 1423004400),
(13, 1228, 1423090800),
(10, 1446, 1423090800),
(8, 1029, 1423090800),
(2, 895, 1423090800),
(17, 1060, 1423090800),
(9, 1106, 1423090800),
(3, 1168, 1423090800),
(16, 898, 1423090800),
(7, 1225, 1423177200),
(2, 886, 1423177200),
(12, 1164, 1423177200),
(17, 1098, 1423177200),
(15, 1024, 1423522800),
(12, 1181, 1423522800),
(9, 1142, 1423522800),
(5, 1208, 1423522800),
(17, 1091, 1423522800),
(10, 1450, 1423522800),
(10, 1456, 1423609200),
(12, 1172, 1423609200),
(2, 911, 1423609200),
(6, 652, 1423609200),
(9, 1134, 1423782000),
(10, 1461, 1423782000),
(5, 1199, 1423782000),
(17, 1099, 1423782000),
(8, 1048, 1423782000),
(2, 890, 1423782000),
(10, 1430, 1424041200),
(7, 1263, 1424041200),
(17, 1133, 1424041200),
(5, 1167, 1424041200),
(5, 1173, 1424127600),
(7, 1256, 1424127600),
(17, 1159, 1424127600),
(9, 1107, 1424127600),
(10, 1437, 1424300400),
(12, 1162, 1424300400),
(9, 1085, 1424300400),
(5, 1193, 1424300400),
(7, 1291, 1424646000),
(10, 1407, 1424646000),
(9, 1098, 1424646000),
(2, 874, 1424646000),
(5, 1181, 1424732400),
(10, 1416, 1424732400),
(12, 1171, 1424732400),
(11, 829, 1424732400),
(17, 1180, 1424732400),
(9, 1075, 1424732400),
(8, 1086, 1424818800),
(5, 1146, 1424818800),
(2, 864, 1424818800),
(12, 1178, 1424818800),
(7, 1301, 1424905200),
(9, 1062, 1424905200),
(2, 861, 1424905200),
(10, 1417, 1424905200),
(14, 1034, 1424905200),
(3, 960, 1424905200),
(6, 646, 1424905200),
(14, 1036, 1424905200),
(17, 1152, 1424905200),
(5, 1174, 1424905200),
(17, 1136, 1424991600),
(7, 1314, 1424991600),
(12, 1185, 1424991600),
(2, 852, 1424991600),
(10, 1421, 1425250800),
(9, 1055, 1425250800),
(7, 1325, 1425250800),
(17, 1122, 1425250800),
(14, 1009, 1425337200),
(12, 1200, 1425337200),
(10, 1427, 1425337200),
(17, 1113, 1425337200),
(5, 1209, 1425337200),
(7, 1293, 1425337200),
(6, 824, 1425337200),
(3, 781, 1425337200),
(10, 1431, 1425423600),
(9, 1049, 1425423600),
(3, 781, 1425423600),
(12, 1204, 1425423600),
(17, 1148, 1425510000),
(13, 1163, 1425510000),
(1, 987, 1425510000),
(6, 729, 1425510000),
(12, 1235, 1425596400),
(7, 1264, 1425596400),
(17, 1114, 1425596400),
(9, 1084, 1425596400),
(17, 1138, 1426028400),
(9, 1059, 1426028400),
(9, 1033, 1426114800),
(8, 1111, 1426114800),
(12, 1252, 1426201200),
(17, 1118, 1426201200),
(8, 1131, 1426201200),
(9, 1010, 1426201200),
(7, 1268, 1426201200),
(2, 846, 1426201200),
(14, 1073, 1426460400),
(12, 1213, 1426460400),
(9, 1005, 1426460400),
(10, 1434, 1426460400),
(13, 1131, 1426546800),
(7, 1284, 1426546800),
(9, 1049, 1426546800),
(12, 1175, 1426546800),
(9, 1079, 1426546800),
(14, 1034, 1426546800),
(10, 1439, 1426633200),
(17, 1110, 1426633200),
(9, 1035, 1426633200),
(2, 897, 1426633200),
(14, 988, 1426633200),
(16, 1005, 1426633200),
(15, 1007, 1426719600),
(12, 1190, 1426719600),
(10, 1450, 1426719600),
(7, 1270, 1426719600),
(9, 1012, 1426806000),
(17, 1131, 1426806000),
(12, 1197, 1426806000),
(2, 887, 1426806000),
(10, 1418, 1426892400),
(5, 1248, 1426892400),
(14, 973, 1426892400),
(12, 1208, 1426892400),
(1, 1058, 1426892400),
(6, 705, 1426892400),
(9, 1050, 1426892400),
(17, 1095, 1426892400),
(5, 1234, 1427238000),
(10, 1429, 1427238000),
(7, 1280, 1427238000),
(9, 1037, 1427238000),
(6, 690, 1427238000),
(16, 1021, 1427238000),
(14, 995, 1427238000),
(2, 863, 1427238000),
(1, 937, 1427238000),
(17, 1119, 1427238000),
(1, 851, 1427324400),
(14, 1019, 1427324400),
(12, 1227, 1427324400),
(8, 1110, 1427324400),
(12, 1238, 1427324400),
(14, 1005, 1427324400),
(9, 1062, 1427324400),
(15, 980, 1427324400),
(9, 1105, 1427410800),
(7, 1243, 1427410800),
(9, 1108, 1427410800),
(18, 650, 1427410800),
(6, 690, 1427410800),
(8, 1114, 1427410800),
(17, 1128, 1427410800),
(1, 824, 1427410800),
(12, 1239, 1427410800),
(18, 650, 1427410800),
(7, 1230, 1427666400),
(10, 1439, 1427666400),
(17, 1109, 1427752800),
(7, 1247, 1427752800),
(15, 1020, 1427752800),
(8, 1077, 1427752800),
(16, 995, 1427752800),
(12, 1249, 1427752800),
(9, 1101, 1427752800),
(10, 1444, 1427752800),
(5, 1249, 1427839200),
(9, 1083, 1427839200),
(7, 1251, 1427839200),
(2, 856, 1427839200),
(9, 1093, 1427925600),
(1, 800, 1427925600),
(7, 1216, 1427925600),
(8, 1117, 1427925600),
(3, 832, 1427925600),
(6, 656, 1427925600),
(5, 1272, 1427925600),
(12, 1225, 1427925600),
(12, 1240, 1428012000),
(9, 1075, 1428012000),
(17, 1129, 1428012000),
(15, 998, 1428012000),
(9, 1105, 1428357600),
(8, 1087, 1428357600),
(9, 1133, 1428357600),
(17, 1100, 1428357600),
(1, 898, 1428357600),
(8, 1041, 1428357600),
(9, 1116, 1428444000),
(5, 1286, 1428444000),
(4, 963, 1428530400),
(6, 642, 1428530400),
(10, 1452, 1428530400),
(7, 1205, 1428530400),
(2, 891, 1428530400),
(1, 842, 1428530400),
(5, 1298, 1428530400),
(9, 1101, 1428530400),
(7, 1222, 1428616800),
(9, 1081, 1428616800),
(17, 1109, 1428616800),
(11, 786, 1428616800),
(2, 872, 1428616800),
(8, 1057, 1428616800),
(7, 1251, 1428876000),
(5, 1270, 1428876000),
(11, 753, 1428876000),
(8, 1066, 1428876000),
(12, 1201, 1428876000),
(15, 1044, 1428876000),
(12, 1230, 1428962400),
(5, 1242, 1428962400),
(9, 1110, 1428962400),
(17, 1080, 1428962400),
(7, 1255, 1428962400),
(2, 865, 1428962400),
(9, 1157, 1429048800),
(10, 1417, 1429048800),
(5, 1266, 1429048800),
(7, 1230, 1429048800),
(2, 878, 1429048800),
(6, 626, 1429048800),
(7, 1217, 1429135200),
(10, 1427, 1429135200),
(12, 1249, 1429135200),
(9, 1136, 1429135200),
(11, 698, 1429221600),
(2, 898, 1429221600),
(9, 1158, 1429221600),
(17, 1056, 1429221600),
(9, 1190, 1429480800),
(12, 1219, 1429480800),
(7, 1231, 1429480800),
(8, 1049, 1429480800),
(10, 1398, 1429480800),
(5, 1299, 1429480800),
(5, 1328, 1429567200),
(10, 1371, 1429567200),
(17, 1038, 1429567200),
(9, 1205, 1429567200),
(2, 889, 1429567200),
(7, 1237, 1429567200),
(17, 1051, 1429653600),
(12, 1207, 1429653600),
(7, 1258, 1429653600),
(9, 1182, 1429653600),
(6, 612, 1429653600),
(2, 900, 1429653600),
(10, 1381, 1429740000),
(9, 1169, 1429740000),
(7, 1239, 1429740000),
(5, 1345, 1429740000),
(12, 1214, 1429740000),
(2, 890, 1429740000),
(9, 1199, 1429826400),
(7, 1210, 1429826400),
(10, 1392, 1430085600),
(7, 1196, 1430085600),
(6, 606, 1430085600),
(15, 1048, 1430085600),
(10, 1397, 1430172000),
(15, 1041, 1430172000),
(17, 1010, 1430172000),
(2, 935, 1430172000),
(12, 1201, 1430172000),
(10, 1407, 1430172000),
(8, 1088, 1430172000),
(9, 1163, 1430172000),
(9, 1149, 1430258400),
(5, 1356, 1430258400),
(5, 1368, 1430258400),
(7, 1181, 1430258400),
(7, 1207, 1430344800),
(12, 1174, 1430344800),
(2, 911, 1430344800),
(17, 1032, 1430344800),
(2, 890, 1430690400),
(17, 1050, 1430690400),
(7, 1229, 1430690400),
(12, 1150, 1430690400),
(10, 1417, 1430776800),
(7, 1216, 1430776800),
(17, 1042, 1430776800),
(5, 1373, 1430776800),
(8, 1120, 1430863200),
(12, 1119, 1430863200),
(15, 1035, 1430863200),
(10, 1421, 1430863200),
(7, 1201, 1430863200),
(5, 1385, 1430863200),
(7, 1188, 1431295200),
(5, 1395, 1431295200),
(5, 1375, 1431381600),
(10, 1439, 1431381600),
(15, 1075, 1431381600),
(7, 1152, 1431381600),
(17, 1022, 1431468000),
(9, 1167, 1431468000),
(12, 1109, 1431986400),
(5, 1382, 1431986400),
(9, 1158, 1431986400),
(10, 1445, 1431986400),
(5, 1364, 1432072800),
(10, 1461, 1432072800),
(9, 1173, 1432072800),
(14, 988, 1432072800),
(2, 879, 1432072800),
(9, 1181, 1432072800),
(8, 1139, 1432072800),
(17, 1001, 1432072800),
(17, 1038, 1432159200),
(12, 1074, 1432159200),
(12, 1094, 1432159200),
(14, 965, 1432159200),
(7, 1176, 1432159200),
(8, 1113, 1432159200),
(17, 997, 1432245600),
(2, 924, 1432245600),
(11, 698, 1432245600),
(7, 1179, 1432245600),
(12, 1122, 1432245600),
(8, 1084, 1432245600),
(10, 1475, 1432245600),
(5, 1348, 1432245600),
(15, 1055, 1432591200),
(9, 1198, 1432591200),
(9, 1221, 1432677600),
(7, 1155, 1432677600),
(17, 974, 1432677600),
(8, 1104, 1432677600),
(9, 1228, 1432764000),
(2, 914, 1432764000),
(8, 1127, 1432764000),
(15, 1030, 1432764000),
(4, 1057, 1432850400),
(8, 1088, 1432850400),
(4, 1004, 1432850400),
(8, 1112, 1432850400),
(2, 893, 1432850400),
(15, 1049, 1432850400),
(17, 1017, 1432850400),
(7, 1116, 1432850400),
(9, 1267, 1433109600),
(10, 1444, 1433109600),
(8, 1123, 1433109600),
(2, 879, 1433109600),
(17, 996, 1433109600),
(12, 1140, 1433109600),
(12, 1175, 1433196000),
(9, 1235, 1433196000),
(10, 1444, 1433196000),
(11, 698, 1433196000),
(2, 929, 1433196000),
(7, 1073, 1433196000),
(9, 1223, 1433282400),
(10, 1453, 1433282400),
(7, 1094, 1433282400),
(17, 973, 1433282400),
(9, 1187, 1433368800),
(15, 1090, 1433368800),
(17, 1014, 1433368800),
(8, 1085, 1433368800),
(9, 1178, 1433455200),
(10, 1459, 1433455200),
(2, 911, 1433455200),
(7, 1109, 1433455200),
(8, 1033, 1433455200),
(6, 676, 1433455200),
(8, 1085, 1433714400),
(10, 1423, 1433714400),
(1, 817, 1433714400),
(17, 1029, 1433714400),
(6, 667, 1433714400),
(17, 1035, 1433714400),
(2, 950, 1433714400),
(4, 942, 1433714400),
(9, 1164, 1433714400),
(5, 1359, 1433714400),
(12, 1190, 1433800800),
(17, 1017, 1433800800),
(15, 1064, 1433800800),
(7, 1134, 1433800800),
(2, 979, 1433800800),
(4, 898, 1433800800),
(14, 950, 1433800800),
(9, 1176, 1433800800),
(2, 987, 1433887200),
(6, 656, 1433887200),
(17, 1058, 1433887200),
(9, 1139, 1433887200),
(10, 1399, 1433887200),
(5, 1384, 1433887200),
(18, 651, 1433973600),
(6, 655, 1433973600),
(10, 1406, 1433973600),
(7, 1124, 1433973600),
(9, 1168, 1433973600),
(12, 1161, 1433973600),
(17, 1035, 1434060000),
(7, 1145, 1434060000),
(16, 939, 1434060000),
(14, 984, 1434060000),
(6, 649, 1434060000),
(8, 1089, 1434060000),
(12, 1174, 1434319200),
(2, 971, 1434319200),
(5, 1392, 1434319200),
(7, 1134, 1434319200),
(4, 866, 1434405600),
(2, 994, 1434405600),
(12, 1177, 1434492000),
(11, 698, 1434492000),
(7, 1100, 1434492000),
(17, 1071, 1434492000),
(11, 684, 1434492000),
(2, 1003, 1434492000),
(5, 1413, 1434492000),
(10, 1384, 1434492000),
(8, 1122, 1434578400),
(12, 1145, 1434578400),
(8, 1097, 1434664800),
(12, 1169, 1434664800),
(2, 979, 1434664800),
(17, 1093, 1434664800),
(7, 1097, 1434664800),
(15, 1066, 1434664800),
(12, 1194, 1434924000),
(9, 1142, 1434924000),
(4, 909, 1434924000),
(16, 885, 1434924000),
(8, 1115, 1434924000),
(14, 963, 1434924000),
(14, 1005, 1434924000),
(8, 1077, 1434924000),
(2, 959, 1434924000),
(7, 1115, 1434924000),
(12, 1202, 1435010400),
(4, 898, 1435010400),
(14, 981, 1435010400),
(15, 1088, 1435010400),
(5, 1390, 1435010400),
(10, 1406, 1435010400),
(13, 1166, 1435010400),
(17, 1068, 1435010400),
(5, 1370, 1435096800),
(10, 1425, 1435096800),
(10, 1421, 1435096800),
(5, 1373, 1435096800),
(17, 1087, 1435096800),
(2, 938, 1435096800),
(9, 1099, 1435096800),
(16, 950, 1435096800),
(7, 1140, 1435183200),
(9, 1073, 1435183200),
(6, 716, 1435269600),
(15, 1037, 1435269600),
(2, 919, 1435269600),
(17, 1103, 1435269600),
(5, 1379, 1435269600),
(9, 1064, 1435269600),
(9, 1056, 1435269600),
(5, 1384, 1435269600),
(9, 1087, 1435528800),
(17, 1072, 1435528800),
(14, 948, 1435528800),
(16, 989, 1435528800),
(9, 1103, 1435615200),
(14, 929, 1435615200),
(8, 1104, 1435615200),
(17, 1044, 1435615200),
(14, 912, 1435701600),
(9, 1117, 1435701600),
(17, 1023, 1435701600),
(7, 1159, 1435701600),
(16, 973, 1435701600),
(12, 1213, 1435701600),
(10, 1426, 1435788000),
(8, 1096, 1435788000),
(12, 1230, 1435788000),
(9, 1097, 1435788000),
(14, 952, 1435788000),
(17, 985, 1435788000),
(5, 1393, 1435788000),
(7, 1147, 1435788000),
(7, 1161, 1435874400),
(17, 968, 1435874400),
(9, 1123, 1435874400),
(8, 1068, 1435874400),
(14, 935, 1436133600),
(9, 1137, 1436133600),
(8, 1047, 1436133600),
(7, 1179, 1436133600),
(12, 1238, 1436133600),
(17, 957, 1436133600),
(9, 1127, 1436220000),
(5, 1400, 1436220000),
(12, 1258, 1436306400),
(7, 1157, 1436306400),
(9, 1087, 1436306400),
(14, 980, 1436306400),
(7, 1177, 1436392800),
(9, 1065, 1436392800),
(16, 1010, 1436392800),
(8, 1012, 1436392800),
(8, 1064, 1436479200),
(5, 1362, 1436479200),
(9, 1045, 1436479200),
(7, 1194, 1436479200),
(6, 697, 1436479200),
(4, 914, 1436479200),
(8, 1050, 1436911200),
(12, 1269, 1436911200),
(8, 1070, 1436997600),
(17, 934, 1436997600),
(7, 1210, 1437084000),
(8, 1051, 1437084000),
(5, 1387, 1437084000),
(10, 1402, 1437084000),
(17, 963, 1437343200),
(2, 889, 1437343200),
(10, 1412, 1437429600),
(7, 1197, 1437429600),
(14, 1001, 1437429600),
(2, 865, 1437429600),
(8, 1043, 1437429600),
(5, 1392, 1437429600),
(12, 1253, 1437516000),
(5, 1405, 1437516000),
(9, 1003, 1437516000),
(2, 912, 1437516000),
(17, 950, 1437516000),
(7, 1207, 1437516000),
(17, 954, 1437602400),
(9, 998, 1437602400),
(2, 966, 1437602400),
(12, 1211, 1437602400),
(9, 994, 1437688800),
(17, 957, 1437688800),
(10, 1431, 1437948000),
(5, 1384, 1437948000),
(2, 998, 1437948000),
(9, 962, 1437948000),
(7, 1220, 1438034400),
(15, 1021, 1438034400),
(9, 994, 1438034400),
(2, 965, 1438034400),
(10, 1440, 1438120800),
(7, 1208, 1438120800),
(5, 1389, 1438120800),
(8, 1036, 1438120800),
(2, 937, 1438120800),
(9, 1020, 1438120800),
(7, 1244, 1438207200),
(5, 1358, 1438207200),
(10, 1443, 1438207200),
(9, 1015, 1438207200),
(2, 975, 1438207200),
(8, 999, 1438207200),
(17, 992, 1438207200),
(15, 987, 1438207200),
(15, 1015, 1438293600),
(2, 946, 1438293600),
(5, 1341, 1438293600),
(10, 1457, 1438293600),
(17, 964, 1438293600),
(9, 1041, 1438293600),
(2, 982, 1438552800),
(15, 980, 1438552800),
(9, 1063, 1438552800),
(17, 940, 1438552800),
(7, 1253, 1438552800),
(8, 987, 1438552800),
(2, 1011, 1438639200),
(15, 950, 1438639200),
(9, 1084, 1438639200),
(8, 963, 1438639200),
(17, 937, 1438639200),
(10, 1458, 1438639200),
(16, 996, 1438639200),
(12, 1222, 1438639200),
(17, 927, 1438725600),
(12, 1229, 1438725600),
(9, 1101, 1438725600),
(15, 930, 1438725600),
(2, 999, 1438725600),
(7, 1262, 1438725600),
(2, 988, 1438812000),
(7, 1270, 1438812000),
(15, 913, 1438812000),
(9, 1115, 1438812000),
(15, 898, 1438812000),
(9, 1127, 1438812000),
(9, 1163, 1438898400),
(7, 1237, 1438898400),
(9, 1176, 1439157600),
(2, 972, 1439157600),
(7, 1194, 1439157600),
(15, 952, 1439157600),
(2, 999, 1439244000),
(15, 923, 1439244000),
(9, 1202, 1439244000),
(7, 1167, 1439244000),
(9, 1213, 1439416800),
(2, 985, 1439416800),
(9, 1220, 1439416800),
(15, 913, 1439416800),
(15, 903, 1439503200),
(9, 1227, 1439503200),
(9, 1233, 1439762400),
(15, 894, 1439762400),
(15, 886, 1439762400),
(9, 1239, 1439762400),
(15, 878, 1439762400),
(9, 1244, 1439762400),
(9, 1252, 1439848800),
(2, 974, 1439848800),
(2, 936, 1439935200),
(15, 918, 1439935200),
(9, 1222, 1439935200),
(7, 1198, 1439935200),
(7, 1224, 1440021600),
(9, 1195, 1440021600),
(7, 1246, 1440108000),
(9, 1172, 1440108000),
(2, 903, 1440367200),
(15, 950, 1440367200),
(5, 1357, 1440367200),
(7, 1228, 1440367200),
(4, 890, 1440626400),
(14, 1022, 1440626400),
(10, 1433, 1440712800),
(5, 1384, 1440712800),
(3, 897, 1440712800),
(4, 853, 1440712800),
(7, 1235, 1440972000),
(17, 917, 1440972000),
(15, 915, 1440972000),
(2, 938, 1440972000);

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

--
-- Structure de la table `joueurs`
--

CREATE TABLE IF NOT EXISTS `joueurs` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `score` int(10) NOT NULL default '0',
  `partie` varchar(30) NOT NULL default '',
  `date_inscription` date NOT NULL default '0000-00-00',
  `heure_inscription` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

--
-- Contenu de la table `joueurs`
--

INSERT INTO `joueurs` (`id`, `nom`, `prenom`, `score`, `partie`, `date_inscription`, `heure_inscription`) VALUES
(1, 'Foulon', 'Fabien', 1000, '0', '2014-01-04', '18:18:00'),
(2, 'Romeo', 'Dominique', 1000, '0', '2014-01-04', '18:19:00'),
(12, 'Ramond', 'Stephane', 1000, '0', '2014-08-31', '10:06:00'),
(11, 'Fernandes', 'Enrique', 1000, '0', '2014-01-06', '14:42:00'),
(13, 'Bordes', 'Laurent', 1000, '0', '2014-08-31', '10:06:00'),
(14, 'Saphon', 'Remy', 1000, '0', '2014-08-31', '10:10:00');

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

--
-- Structure de la table `lave-linge`
--

CREATE TABLE IF NOT EXISTS `lave-linge` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `alpha` varchar(30) NOT NULL default '',
  `beta` varchar(30) NOT NULL default '',
  `gamma` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `lave-linge`
--

INSERT INTO `lave-linge` (`id`, `id_catalogue`, `designation`, `reference`, `marque`, `fournisseur`, `garantie`, `dispo`, `prix_ttc`, `prix_ht`, `remise`, `tva`, `descriptif`, `caracteristiques`, `image`, `stock`, `status`, `remarques`, `liens`, `heure`, `date`, `alpha`, `beta`, `gamma`) VALUES
(1, 'XV37K09', 'lave_linge', 'REF456', 'Brandt', 'Malrieu', '2', '24H', 549.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Frontal,Nombredeprogrammes & 11,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6.5,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 4,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & oui,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '23:27', '19-08-2010', 'Frontal', '1100', '6.5'),
(2, 'TF785', 'lave_linge', 'XXX789', 'Bosh', 'caltron', '5', '48H', 1200.00, 1100.00, 'aucune', 19.65, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Hublot,Nombredeprogrammes & 14,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 2.45,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & non,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '17:31', '20-08-2010', 'Hublot', '1100', '6'),
(3, 'fdg', 'lave_linge', 'hjfld', 'Brandt', 'pipotron', '4', '72H', 700.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE\r,Couleur & blanche\r,Chargement(*) & Hublot\r,Nombredeprogrammes & 12\r,vitesse_essorage_trs_min(*) & 1200\r,Capacite_lavage_Kg(*) & 6\r,CONSOMMATIONS: & TITRE\r,Consommation_energie_KWh_cycle(*) & 2.14\r,Classe_efficacite_essorage(*) & A+++\r,DISPOSITIFDESECURITE & TITRE\r,Anti-balours & \r,Anti-mousse & \r,CaractÃ©ristiques physiques & TITRE\r,HxLxP(encm) & \r,Poids(enkg) & 57.8Kg', '', '', 'actif', '		', '		', '23:18', '20-08-2010', 'Hublot', '1200', '6'),
(4, 'PT045', 'lave_linge', 'REF464645', 'Candy', 'Malrieu', '2', '24H', 914.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '900', '6'),
(5, 'PT078', 'lave_linge', 'REF78fgd', 'Candy', 'Malrieu', '2', '24H', 799.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '1100', '6');

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

--
-- Structure de la table `lave_linge`
--

CREATE TABLE IF NOT EXISTS `lave_linge` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `alpha` varchar(30) NOT NULL default '',
  `beta` varchar(30) NOT NULL default '',
  `gamma` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `lave_linge`
--

INSERT INTO `lave_linge` (`id`, `id_catalogue`, `designation`, `reference`, `marque`, `fournisseur`, `garantie`, `dispo`, `prix_ttc`, `prix_ht`, `remise`, `tva`, `descriptif`, `caracteristiques`, `image`, `stock`, `status`, `remarques`, `liens`, `heure`, `date`, `alpha`, `beta`, `gamma`) VALUES
(1, 'XV37K09', 'lave_linge', 'REF456', 'Brandt', 'Malrieu', '2', '24H', 549.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Frontal,Nombredeprogrammes & 11,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6.5,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 4,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & oui,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '23:27', '19-08-2010', 'Frontal', '1100', '6.5'),
(2, 'TF785', 'lave_linge', 'XXX789', 'Bosh', 'caltron', '5', '48H', 1200.00, 1100.00, 'aucune', 19.65, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Hublot,Nombredeprogrammes & 14,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 2.45,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & non,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '17:31', '20-08-2010', 'Hublot', '1100', '6'),
(3, 'fdg', 'lave_linge', 'hjfld', 'Brandt', 'pipotron', '4', '72H', 700.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE\r,Couleur & blanche\r,Chargement(*) & Hublot\r,Nombredeprogrammes & 12\r,vitesse_essorage_trs_min(*) & 1200\r,Capacite_lavage_Kg(*) & 6\r,CONSOMMATIONS: & TITRE\r,Consommation_energie_KWh_cycle(*) & 2.14\r,Classe_efficacite_essorage(*) & A+++\r,DISPOSITIFDESECURITE & TITRE\r,Anti-balours & \r,Anti-mousse & \r,CaractÃ©ristiques physiques & TITRE\r,HxLxP(encm) & \r,Poids(enkg) & 57.8Kg', '', '', 'actif', '		', '		', '23:18', '20-08-2010', 'Hublot', '1200', '6'),
(4, 'PT045', 'lave_linge', 'REF464645', 'Candy', 'Malrieu', '2', '24H', 914.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '900', '6'),
(5, 'PT078', 'lave_linge', 'REF78fgd', 'Candy', 'Malrieu', '2', '24H', 799.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique\r,texte_caracteristique\r,		mklÃ¹', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '1100', '6');

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

--
-- Structure de la table `linge`
--

CREATE TABLE IF NOT EXISTS `linge` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `alpha` varchar(30) NOT NULL default '',
  `beta` varchar(30) NOT NULL default '',
  `gamma` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `linge`
--

INSERT INTO `linge` (`id`, `id_catalogue`, `designation`, `reference`, `marque`, `fournisseur`, `garantie`, `dispo`, `prix_ttc`, `prix_ht`, `remise`, `tva`, `descriptif`, `caracteristiques`, `image`, `stock`, `status`, `remarques`, `liens`, `heure`, `date`, `alpha`, `beta`, `gamma`) VALUES
(1, 'XV37K09', 'lave_linge', 'REF456', 'Brandt', 'Malrieu', '2', '24H', 549.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Frontal,Nombredeprogrammes & 11,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6.5,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 4,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & oui,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '23:27', '19-08-2010', 'Frontal', '1100', '6.5'),
(2, 'TF785', 'lave_linge', 'XXX789', 'Bosh', 'caltron', '5', '48H', 1200.00, 1100.00, 'aucune', 19.65, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Hublot,Nombredeprogrammes & 14,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 2.45,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & non,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '17:31', '20-08-2010', 'Hublot', '1100', '6'),
(3, 'fdg', 'lave_linge', 'hjfld', 'Brandt', 'pipotron', '4', '72H', 700.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE\r,Couleur & blanche\r,Chargement(*) & Hublot\r,Nombredeprogrammes & 12\r,vitesse_essorage_trs_min(*) & 1200\r,Capacite_lavage_Kg(*) & 6\r,CONSOMMATIONS: & TITRE\r,Consommation_energie_KWh_cycle(*) & 2.14\r,Classe_efficacite_essorage(*) & A+++\r,DISPOSITIFDESECURITE & TITRE\r,Anti-balours & \r,Anti-mousse & \r,CaractÃ©ristiques physiques & TITRE\r,HxLxP(encm) & \r,Poids(enkg) & 57.8Kg', '', '', 'actif', '		', '		', '23:18', '20-08-2010', 'Hublot', '1200', '6'),
(4, 'PT045', 'lave_linge', 'REF464645', 'Candy', 'Malrieu', '2', '24H', 914.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '900', '6'),
(5, 'PT078', 'lave_linge', 'REF78fgd', 'Candy', 'Malrieu', '2', '24H', 799.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '1100', '6');

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

--
-- Structure de la table `membres`
--

CREATE TABLE IF NOT EXISTS `membres` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `login` varchar(80) NOT NULL default '',
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `statut_compte` varchar(20) NOT NULL default '',
  `cle` varchar(8) NOT NULL default '',
  `avatar` varchar(30) NOT NULL default '',
  `date_inscription` date NOT NULL default '0000-00-00',
  `heure_inscription` time NOT NULL default '00:00:00',
  `date_modification` date NOT NULL default '0000-00-00',
  `heure_modification` time NOT NULL default '00:00:00',
  `signature` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=52 ;

--
-- Contenu de la table `membres`
--

INSERT INTO `membres` (`id`, `login`, `nom`, `prenom`, `password`, `email`, `statut_compte`, `cle`, `avatar`, `date_inscription`, `heure_inscription`, `date_modification`, `heure_modification`, `signature`) VALUES
(1, 'patoche', 'delpy', 'patrice', 'biloute', 'patrice.delpy@free.ff', 'actif', '0d37ef9a', '', '2026-11-20', '21:00:00', '0000-00-00', '00:00:00', ''),
(45, 'cocoaq', 'delpu', 'gdkfk', 'boby', 'patrice.delpy@neuf.fr', 'actif', 'eab4970d', '', '2013-09-25', '20:01:00', '0000-00-00', '00:00:00', ''),
(42, 'ffxmph', 'patrice', 'Delpy', 'Saturn05', 'ffxmph@onsemi.com', 'actif', '4c95de6f', '', '2013-08-13', '18:57:00', '0000-00-00', '00:00:00', ''),
(8, 'coco', 'delpy', 'patrice', 'rainbow', 'patrice.delpy@neuf.fr', 'actif', '416ac2d9', 'no_avatar.jpg', '2003-12-20', '20:25:00', '0000-00-00', '00:00:00', ''),
(33, 'pistache', 'delpy', 'patoche', 'tarte', 'qpatrice.delpy@free.fr', 'actif', '24b91c5e', 'pistache_avatar.jpg', '2013-02-17', '16:15:00', '0000-00-00', '00:00:00', '<p><img alt="angel" height="20" src="http://analog-design.net/WORKAREA/WEBSITE/site_02_12_2013_template/ckeditor/plugins/smiley/images/angel_smile.gif" title="angel" width="20" />&nbsp;&nbsp; le <span style="color:#FF8C00;">plein </span>de <u><span style="font-size:14px;">soleil</span></u><span style="font-size:14px;"> ,&nbsp; je pifou </span></p>\r\n'),
(46, 'coco1789', 'pipo', 'riri', 'aqwzsx', 'patrice.delpy@neuf.fr', 'actif', '0d4ea139', '', '2013-09-25', '20:43:00', '0000-00-00', '00:00:00', ''),
(41, 'essa', 'Delpy', 'Patrice', 'azer', 'patoche@analog-design.net', 'creation', 'ac124567', '', '2013-03-13', '22:08:00', '0000-00-00', '00:00:00', ''),
(49, 'brutus', 'delpy', 'patrice', 'zorro', 'patrice.delpy@free.fr', 'creation', 'adef0278', '', '2013-10-13', '11:19:00', '0000-00-00', '00:00:00', ''),
(48, 'no', 'azer', 'vincent', 'merde', 'zapatrice.delpy@free.fr', 'actif', 'def01467', 'no_avatar.jpg', '2013-09-25', '21:09:00', '0000-00-00', '00:00:00', ''),
(51, 'pipotron', 'DELPY', 'patrice', 'aqwzsx', 'patrice.delpy@free.fr', 'creation', 'cef02456', 'no_avatar.jpg', '2013-12-04', '22:12:00', '0000-00-00', '00:00:00', '');

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

--
-- Structure de la table `nada`
--

CREATE TABLE IF NOT EXISTS `nada` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `nada`
--


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

--
-- Structure de la table `newtable`
--

CREATE TABLE IF NOT EXISTS `newtable` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `heure` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `newtable`
--

INSERT INTO `newtable` (`id`, `date`, `heure`) VALUES
(1, '0000-00-00', ''),
(2, '0000-00-00', ''),
(3, '0000-00-00', ''),
(4, '0000-00-00', ''),
(5, '2011-07-02', '18:29');

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

--
-- Structure de la table `october`
--

CREATE TABLE IF NOT EXISTS `october` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `october`
--


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

--
-- Structure de la table `orange`
--

CREATE TABLE IF NOT EXISTS `orange` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `orange`
--


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

--
-- Structure de la table `panier`
--

CREATE TABLE IF NOT EXISTS `panier` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(100) NOT NULL default '',
  `panier` text NOT NULL,
  `heure` varchar(50) NOT NULL default '',
  `date` varchar(50) NOT NULL default '',
  `titre` varchar(30) NOT NULL default '',
  `total_ttc` decimal(7,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

--
-- Contenu de la table `panier`
--

INSERT INTO `panier` (`id`, `email`, `panier`, `heure`, `date`, `titre`, `total_ttc`) VALUES
(32, 'patrice.delpy@sfr.fr', 'REF78fgd- washer - lave_linge Indesit  - 1 -714.2 -hjfld-washer -lave_linge 3X - 1 - 551.5', '17:53', '09-05-2010', 'tartuffe', 1265.70),
(31, 'patrice.delpy@sfr.fr', 'VXF33F- washer - lave_linge 123 - 1 - 479.5 - AMV4- washer -lave_linge Sony -3 -2164.5', '23:02', '08-05-2010', 'autre', 2644.00),
(30, 'patrice.delpy@sfr.fr', 'NTH82K-washer-pipo-3 -1438.5-X28Z22-washer -lave_linge nul -3-2164.5', '22:38', '08-05-2010', 'laurence', 3603.00),
(33, 'patrice.delpy@sfr.fr', 'REF456- washer- lave_linge Brandt - 3- 2397.81', '21:08', '22-09-2010', 'qw', 2397.00),
(48, 'patrice.delpy@sfr.fr', 'REF78fgd- washer- lave_linge Candy REF78fgd- 2- 799.00- hjfld- washer- lave_linge Brandt hjfld-  1 - 700.00', '22:34', '29-09-2010', 'lulu', 2298.00),
(47, 'patrice.delpy@sfr.fr', 'REF78fgd- washer- lave_linge Candy REF78fgd- 2- 799.00- hjfld- washer- lave_linge Brandt hjfld-  1 - 700.00', '22:30', '29-09-2010', 'kiki', 2298.00),
(46, 'patrice.delpy@sfr.fr', 'REF78fgd- washer- lave_linge Candy REF78fgd- 2- 799.00- hjfld- washer- lave_linge Brandt hjfld-  1 - 700.00', '22:22', '29-09-2010', 'pipo', 2298.00);

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

--
-- Structure de la table `partie`
--

CREATE TABLE IF NOT EXISTS `partie` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `joueur1` varchar(30) NOT NULL default '',
  `joueur2` varchar(30) NOT NULL default '',
  `resultat_partie` varchar(30) NOT NULL default '',
  `score_joueur1` int(10) NOT NULL default '0',
  `score_joueur2` int(10) NOT NULL default '0',
  `date_partie` date NOT NULL default '0000-00-00',
  `heure_partie` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

--
-- Contenu de la table `partie`
--


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

--
-- Structure de la table `parties`
--

CREATE TABLE IF NOT EXISTS `parties` (
  `w_playerID` int(11) default NULL,
  `w_name` varchar(30) NOT NULL default '',
  `b_playerID` int(11) default NULL,
  `b_name` varchar(30) NOT NULL default '',
  `w_brating` int(11) default NULL,
  `w_arating` int(11) default NULL,
  `b_brating` int(11) default NULL,
  `b_arating` int(11) default NULL,
  `result` int(11) default NULL,
  `date` int(11) default NULL
) TYPE=MyISAM;

--
-- Contenu de la table `parties`
--

INSERT INTO `parties` (`w_playerID`, `w_name`, `b_playerID`, `b_name`, `w_brating`, `w_arating`, `b_brating`, `b_arating`, `result`, `date`) VALUES
(10, 'henrique', 7, 'fabien', 1300, 1500, 1300, 1100, 1, 1398376800),
(7, 'fabien', 10, 'henrique', 1100, 1100, 1500, 1500, 2, 1398636000),
(10, 'henrique', 15, 'remy', 1500, 1500, 1100, 1100, 1, 1398722400),
(7, 'fabien', 5, 'dominique', 1100, 1233, 1100, 900, 1, 1398808800),
(17, 'stephaner', 5, 'dominique', 1000, 750, 900, 1150, 2, 1399240800),
(7, 'fabien', 10, 'henrique', 1233, 1199, 1500, 1533, 2, 1399240800),
(7, 'fabien', 15, 'remy', 1199, 1259, 1100, 949, 1, 1399327200),
(5, 'dominique', 10, 'henrique', 1150, 1144, 1533, 1536, 2, 1400450400),
(10, 'henrique', 5, 'dominique', 1536, 1537, 1144, 1142, 1, 1400536800),
(7, 'fabien', 15, 'remy', 1259, 1140, 949, 1185, 2, 1400536800),
(10, 'henrique', 7, 'fabien', 1537, 1537, 1140, 1139, 1, 1400623200),
(15, 'remy', 7, 'fabien', 1185, 1073, 1139, 1194, 2, 1402437600),
(7, 'fabien', 10, 'henrique', 1194, 1272, 1537, 1444, 1, 1402524000),
(10, 'henrique', 7, 'fabien', 1444, 1379, 1272, 1330, 2, 1402783200),
(15, 'remy', 10, 'henrique', 1073, 1214, 1379, 1310, 1, 1402869600),
(7, 'fabien', 10, 'henrique', 1330, 1291, 1310, 1348, 2, 1403128800),
(10, 'henrique', 15, 'remy', 1348, 1369, 1214, 1169, 1, 1403647200),
(5, 'dominique', 18, 'thierry', 1142, 1193, 1000, 871, 1, 1403733600),
(15, 'remy', 10, 'henrique', 1169, 1140, 1369, 1383, 2, 1403820000),
(10, 'henrique', 7, 'fabien', 1383, 1404, 1291, 1266, 1, 1404252000),
(7, 'fabien', 15, 'remy', 1266, 1286, 1140, 1105, 1, 1404338400),
(15, 'remy', 7, 'fabien', 1105, 1081, 1286, 1300, 2, 1404338400),
(7, 'fabien', 10, 'henrique', 1300, 1281, 1404, 1422, 2, 1404684000),
(5, 'dominique', 15, 'remy', 1193, 1241, 1081, 1053, 1, 1404684000),
(10, 'henrique', 5, 'dominique', 1422, 1385, 1241, 1324, 2, 1404770400),
(10, 'henrique', 15, 'remy', 1385, 1344, 1053, 1116, 2, 1404856800),
(5, 'dominique', 7, 'fabien', 1324, 1268, 1281, 1309, 2, 1404856800),
(5, 'dominique', 10, 'henrique', 1268, 1233, 1344, 1361, 2, 1404943200),
(12, 'laurent', 15, 'remy', 1200, 1358, 1116, 1090, 1, 1405029600),
(12, 'laurent', 5, 'dominique', 1358, 1495, 1233, 1206, 1, 1405375200),
(10, 'henrique', 7, 'fabien', 1361, 1336, 1309, 1336, 2, 1405375200),
(4, 'damien', 10, 'henrique', 1000, 968, 1336, 1341, 2, 1405548000),
(7, 'fabien', 10, 'henrique', 1336, 1314, 1341, 1362, 2, 1405893600),
(5, 'dominique', 10, 'henrique', 1206, 1257, 1362, 1331, 1, 1405893600),
(5, 'dominique', 7, 'fabien', 1257, 1229, 1314, 1332, 2, 1405980000),
(5, 'dominique', 8, 'franckdc', 1229, 1241, 1000, 914, 1, 1405980000),
(10, 'henrique', 12, 'laurent', 1331, 1362, 1495, 1307, 1, 1405980000),
(10, 'henrique', 5, 'dominique', 1362, 1376, 1241, 1221, 1, 1406152800),
(15, 'remy', 5, 'dominique', 1090, 1070, 1221, 1238, 2, 1406152800),
(10, 'henrique', 7, 'fabien', 1376, 1394, 1332, 1312, 1, 1406152800),
(7, 'fabien', 10, 'henrique', 1312, 1294, 1394, 1409, 2, 1406239200),
(10, 'henrique', 5, 'dominique', 1409, 1420, 1238, 1224, 1, 1406498400),
(7, 'fabien', 10, 'henrique', 1294, 1279, 1420, 1433, 2, 1406584800),
(5, 'dominique', 7, 'fabien', 1224, 1203, 1279, 1298, 2, 1406671200),
(7, 'fabien', 5, 'dominique', 1298, 1269, 1203, 1234, 2, 1406671200),
(7, 'fabien', 12, 'laurent', 1269, 1248, 1307, 1397, 2, 1406757600),
(10, 'henrique', 15, 'remy', 1433, 1437, 1070, 1063, 1, 1406757600),
(7, 'fabien', 15, 'remy', 1248, 1260, 1063, 1048, 1, 1406757600),
(10, 'henrique', 5, 'dominique', 1437, 1406, 1234, 1270, 2, 1406757600),
(5, 'dominique', 10, 'henrique', 1270, 1255, 1406, 1418, 2, 1406844000),
(10, 'henrique', 7, 'fabien', 1418, 1429, 1260, 1246, 1, 1407103200),
(4, 'damien', 12, 'laurent', 968, 968, 1397, 1397, 2, 1407103200),
(10, 'henrique', 8, 'franckdc', 1429, 1430, 914, 914, 1, 1407103200),
(12, 'laurent', 15, 'remy', 1397, 1405, 1048, 1041, 1, 1407103200),
(7, 'fabien', 10, 'henrique', 1246, 1233, 1430, 1440, 2, 1407189600),
(10, 'henrique', 15, 'remy', 1440, 1443, 1041, 1035, 1, 1407189600),
(9, 'franckv', 10, 'henrique', 1000, 1000, 1443, 1445, 2, 1407276000),
(12, 'laurent', 10, 'henrique', 1405, 1353, 1445, 1462, 2, 1407276000),
(15, 'remy', 7, 'fabien', 1035, 1021, 1233, 1244, 2, 1407276000),
(8, 'franckdc', 15, 'remy', 914, 1083, 1021, 983, 1, 1407276000),
(8, 'franckdc', 10, 'henrique', 1083, 1077, 1462, 1465, 2, 1407362400),
(15, 'remy', 9, 'franckv', 983, 954, 1000, 1191, 2, 1407362400),
(10, 'henrique', 7, 'fabien', 1465, 1473, 1244, 1233, 1, 1407794400),
(7, 'fabien', 10, 'henrique', 1233, 1223, 1473, 1480, 2, 1407967200),
(7, 'fabien', 5, 'dominique', 1223, 1200, 1255, 1276, 2, 1408917600),
(7, 'fabien', 5, 'dominique', 1200, 1230, 1276, 1247, 1, 1408917600),
(12, 'laurent', 10, 'henrique', 1353, 1318, 1480, 1492, 2, 1409522400),
(4, 'damien', 15, 'remy', 968, 830, 954, 985, 2, 1409522400),
(10, 'henrique', 5, 'dominique', 1492, 1499, 1247, 1237, 1, 1409608800),
(2, 'amokrane', 7, 'fabien', 1050, 940, 1230, 1242, 2, 1409608800),
(7, 'fabien', 10, 'henrique', 1242, 1281, 1499, 1468, 1, 1409695200),
(12, 'laurent', 15, 'remy', 1318, 1329, 985, 977, 1, 1409781600),
(10, 'henrique', 2, 'amokrane', 1468, 1469, 940, 940, 1, 1409781600),
(8, 'franckdc', 10, 'henrique', 1077, 1075, 1469, 1472, 2, 1410127200),
(17, 'stephaner', 15, 'remy', 750, 663, 977, 989, 2, 1410213600),
(5, 'dominique', 8, 'franckdc', 1237, 1250, 1075, 1035, 1, 1410213600),
(5, 'dominique', 12, 'laurent', 1250, 1231, 1329, 1360, 2, 1410300000),
(2, 'amokrane', 8, 'franckdc', 940, 838, 1035, 1078, 2, 1410386400),
(5, 'dominique', 10, 'henrique', 1231, 1221, 1472, 1479, 2, 1410386400),
(5, 'dominique', 10, 'henrique', 1221, 1211, 1479, 1486, 2, 1410732000),
(12, 'laurent', 8, 'franckdc', 1360, 1371, 1078, 1063, 1, 1410818400),
(5, 'dominique', 15, 'remy', 1211, 1221, 989, 976, 1, 1410818400),
(15, 'remy', 5, 'dominique', 976, 1023, 1221, 1181, 1, 1410818400),
(17, 'stephaner', 10, 'henrique', 663, 663, 1486, 1486, 2, 1410818400),
(8, 'franckdc', 13, 'olivier', 1063, 1040, 1250, 1356, 2, 1410818400),
(16, 'stephaneb', 14, 'patrick', 1000, 800, 1000, 1200, 2, 1410904800),
(5, 'dominique', 2, 'amokrane', 1181, 1187, 838, 823, 1, 1410904800),
(10, 'henrique', 17, 'stephaner', 1486, 1486, 663, 663, 1, 1410904800),
(10, 'henrique', 15, 'remy', 1486, 1488, 1023, 1019, 1, 1411336800),
(10, 'henrique', 5, 'dominique', 1488, 1456, 1187, 1229, 2, 1411423200),
(2, 'amokrane', 10, 'henrique', 823, 823, 1456, 1456, 2, 1411509600),
(8, 'franckdc', 17, 'stephaner', 1040, 968, 663, 818, 2, 1411509600),
(5, 'dominique', 14, 'patrick', 1229, 1251, 1200, 1014, 1, 1411509600),
(2, 'amokrane', 12, 'laurent', 823, 823, 1371, 1373, 2, 1411596000),
(7, 'fabien', 17, 'stephaner', 1281, 1284, 818, 818, 1, 1411596000),
(7, 'fabien', 10, 'henrique', 1284, 1271, 1456, 1466, 2, 1411682400),
(12, 'laurent', 17, 'stephaner', 1373, 1313, 818, 932, 2, 1411941600),
(5, 'dominique', 9, 'franckv', 1251, 1270, 1191, 1077, 1, 1412114400),
(12, 'laurent', 7, 'fabien', 1313, 1280, 1271, 1297, 2, 1412114400),
(2, 'amokrane', 7, 'fabien', 823, 823, 1297, 1299, 2, 1412200800),
(5, 'dominique', 15, 'remy', 1270, 1278, 1019, 1008, 1, 1412200800),
(7, 'fabien', 5, 'dominique', 1299, 1320, 1278, 1256, 1, 1412632800),
(9, 'franckv', 10, 'henrique', 1077, 1274, 1466, 1431, 1, 1412632800),
(10, 'henrique', 9, 'franckv', 1431, 1442, 1274, 1225, 1, 1412805600),
(10, 'henrique', 5, 'dominique', 1442, 1452, 1256, 1243, 1, 1413237600),
(7, 'fabien', 10, 'henrique', 1320, 1305, 1452, 1464, 2, 1413324000),
(8, 'franckdc', 17, 'stephaner', 968, 1000, 932, 886, 1, 1413324000),
(15, 'remy', 8, 'franckdc', 1008, 978, 1000, 1034, 2, 1413410400),
(14, 'patrick', 10, 'henrique', 1014, 1014, 1464, 1466, 2, 1413756000),
(2, 'amokrane', 5, 'dominique', 823, 923, 1243, 1198, 1, 1413842400),
(17, 'stephaner', 10, 'henrique', 886, 971, 1466, 1428, 1, 1413842400),
(10, 'henrique', 17, 'stephaner', 1428, 1430, 971, 965, 1, 1414015200),
(16, 'stephaneb', 14, 'patrick', 800, 1107, 1014, 860, 1, 1414015200),
(17, 'stephaner', 7, 'fabien', 965, 1028, 1305, 1265, 1, 1414101600),
(7, 'fabien', 8, 'franckdc', 1265, 1274, 1034, 1021, 1, 1414364400),
(13, 'olivier', 10, 'henrique', 1356, 1193, 1430, 1445, 2, 1414364400),
(2, 'amokrane', 10, 'henrique', 923, 918, 1445, 1446, 2, 1414450800),
(5, 'dominique', 13, 'olivier', 1198, 1222, 1193, 1061, 1, 1414450800),
(8, 'franckdc', 14, 'patrick', 1021, 1037, 860, 812, 1, 1414450800),
(13, 'olivier', 5, 'dominique', 1061, 1201, 1222, 1187, 1, 1414450800),
(10, 'henrique', 5, 'dominique', 1446, 1453, 1187, 1177, 1, 1414537200),
(7, 'fabien', 12, 'laurent', 1274, 1297, 1280, 1252, 1, 1414623600),
(14, 'patrick', 9, 'franckv', 812, 945, 1225, 1091, 1, 1414623600),
(12, 'laurent', 5, 'dominique', 1252, 1271, 1177, 1157, 1, 1414623600),
(7, 'fabien', 15, 'remy', 1297, 1303, 978, 969, 1, 1415055600),
(5, 'dominique', 10, 'henrique', 1157, 1149, 1453, 1459, 2, 1415055600),
(17, 'stephaner', 2, 'amokrane', 1028, 1051, 918, 890, 1, 1415055600),
(7, 'fabien', 10, 'henrique', 1303, 1289, 1459, 1470, 2, 1415228400),
(12, 'laurent', 16, 'stephaneb', 1271, 1284, 1107, 1028, 1, 1415228400),
(9, 'franckv', 15, 'remy', 1091, 1130, 969, 949, 1, 1415314800),
(10, 'henrique', 7, 'fabien', 1470, 1479, 1289, 1277, 1, 1416178800),
(10, 'henrique', 5, 'dominique', 1479, 1445, 1149, 1194, 2, 1416265200),
(15, 'remy', 12, 'laurent', 949, 941, 1284, 1289, 2, 1416265200),
(2, 'amokrane', 7, 'fabien', 890, 882, 1277, 1281, 2, 1416265200),
(5, 'dominique', 17, 'stephaner', 1194, 1209, 1051, 1032, 1, 1416351600),
(10, 'henrique', 12, 'laurent', 1445, 1456, 1289, 1275, 1, 1416351600),
(5, 'dominique', 8, 'franckdc', 1209, 1172, 1037, 1078, 2, 1416438000),
(10, 'henrique', 8, 'franckdc', 1456, 1459, 1078, 1072, 1, 1416783600),
(15, 'remy', 5, 'dominique', 941, 928, 1172, 1182, 2, 1416783600),
(5, 'dominique', 10, 'henrique', 1182, 1173, 1459, 1465, 2, 1416870000),
(9, 'franckv', 10, 'henrique', 1130, 1121, 1465, 1469, 2, 1416870000),
(17, 'stephaner', 10, 'henrique', 1032, 1027, 1469, 1471, 2, 1416956400),
(5, 'dominique', 8, 'franckdc', 1173, 1191, 1072, 1052, 1, 1417042800),
(10, 'henrique', 5, 'dominique', 1471, 1439, 1191, 1232, 2, 1417388400),
(9, 'franckv', 15, 'remy', 1121, 1143, 928, 912, 1, 1417388400),
(9, 'franckv', 5, 'dominique', 1143, 1113, 1232, 1250, 2, 1417474800),
(2, 'amokrane', 15, 'remy', 882, 918, 912, 878, 1, 1417474800),
(8, 'franckdc', 10, 'henrique', 1052, 1046, 1439, 1442, 2, 1417474800),
(5, 'dominique', 12, 'laurent', 1250, 1275, 1275, 1250, 1, 1417561200),
(5, 'dominique', 9, 'franckv', 1275, 1288, 1113, 1092, 1, 1417647600),
(5, 'dominique', 10, 'henrique', 1288, 1320, 1442, 1414, 1, 1417734000),
(12, 'laurent', 9, 'franckv', 1250, 1263, 1092, 1072, 1, 1417734000),
(5, 'dominique', 7, 'fabien', 1320, 1339, 1281, 1260, 1, 1417993200),
(5, 'dominique', 9, 'franckv', 1339, 1346, 1072, 1061, 1, 1418079600),
(10, 'henrique', 7, 'fabien', 1414, 1425, 1260, 1246, 1, 1418079600),
(5, 'dominique', 10, 'henrique', 1346, 1329, 1425, 1440, 2, 1418166000),
(9, 'franckv', 12, 'laurent', 1061, 1104, 1263, 1227, 1, 1418166000),
(9, 'franckv', 10, 'henrique', 1104, 1151, 1440, 1405, 1, 1418252400),
(9, 'franckv', 15, 'remy', 1151, 1159, 878, 867, 1, 1418684400),
(5, 'dominique', 10, 'henrique', 1329, 1311, 1405, 1421, 2, 1418684400),
(9, 'franckv', 2, 'amokrane', 1159, 1169, 918, 905, 1, 1418770800),
(17, 'stephaner', 12, 'laurent', 1027, 1013, 1227, 1238, 2, 1418770800),
(12, 'laurent', 9, 'franckv', 1238, 1209, 1169, 1199, 2, 1418857200),
(15, 'remy', 17, 'stephaner', 867, 911, 1013, 972, 1, 1418857200),
(5, 'dominique', 10, 'henrique', 1311, 1295, 1421, 1435, 2, 1418943600),
(17, 'stephaner', 10, 'henrique', 972, 968, 1435, 1437, 2, 1420498800),
(5, 'dominique', 7, 'fabien', 1295, 1268, 1246, 1273, 2, 1420498800),
(10, 'henrique', 9, 'franckv', 1437, 1445, 1199, 1188, 1, 1420585200),
(8, 'franckdc', 17, 'stephaner', 1046, 1011, 968, 1004, 2, 1420585200),
(7, 'fabien', 9, 'franckv', 1273, 1290, 1188, 1168, 1, 1420585200),
(15, 'remy', 2, 'amokrane', 911, 941, 905, 874, 1, 1420671600),
(12, 'laurent', 9, 'franckv', 1209, 1181, 1168, 1196, 2, 1420671600),
(7, 'fabien', 17, 'stephaner', 1290, 1297, 1004, 994, 1, 1420671600),
(7, 'fabien', 12, 'laurent', 1297, 1266, 1181, 1214, 2, 1421103600),
(9, 'franckv', 10, 'henrique', 1196, 1186, 1445, 1452, 2, 1421103600),
(9, 'franckv', 5, 'dominique', 1186, 1166, 1268, 1286, 2, 1421103600),
(9, 'franckv', 5, 'dominique', 1166, 1148, 1286, 1301, 2, 1421190000),
(9, 'franckv', 5, 'dominique', 1148, 1184, 1301, 1268, 1, 1421190000),
(7, 'fabien', 15, 'remy', 1266, 1225, 941, 993, 2, 1421190000),
(9, 'franckv', 12, 'laurent', 1184, 1211, 1214, 1187, 1, 1421276400),
(2, 'amokrane', 17, 'stephaner', 874, 852, 994, 1013, 2, 1421276400),
(7, 'fabien', 10, 'henrique', 1225, 1214, 1452, 1460, 2, 1421276400),
(3, 'bertrand', 5, 'dominique', 950, 909, 1268, 1274, 2, 1421622000),
(9, 'franckv', 17, 'stephaner', 1211, 1222, 1013, 999, 1, 1421622000),
(10, 'henrique', 9, 'franckv', 1460, 1448, 1222, 1236, 3, 1421708400),
(5, 'dominique', 17, 'stephaner', 1274, 1235, 999, 1047, 2, 1421708400),
(9, 'franckv', 8, 'franckdc', 1236, 1198, 1011, 1056, 2, 1421794800),
(10, 'henrique', 17, 'stephaner', 1448, 1412, 1047, 1098, 2, 1421794800),
(15, 'remy', 9, 'franckv', 993, 1037, 1198, 1159, 1, 1421881200),
(2, 'amokrane', 8, 'franckdc', 852, 901, 1056, 1013, 1, 1421881200),
(10, 'henrique', 5, 'dominique', 1412, 1402, 1235, 1246, 3, 1421881200),
(2, 'amokrane', 15, 'remy', 901, 943, 1037, 998, 1, 1421967600),
(13, 'olivier', 8, 'franckdc', 1201, 1243, 1013, 998, 1, 1421967600),
(10, 'henrique', 9, 'franckv', 1402, 1410, 1159, 1148, 1, 1422226800),
(7, 'fabien', 15, 'remy', 1214, 1175, 998, 1043, 2, 1422399600),
(5, 'dominique', 8, 'franckdc', 1246, 1255, 998, 986, 1, 1422399600),
(13, 'olivier', 11, 'joel', 1243, 1260, 950, 896, 1, 1422399600),
(2, 'amokrane', 7, 'fabien', 943, 930, 1175, 1185, 2, 1422486000),
(6, 'emile', 12, 'laurent', 850, 818, 1187, 1193, 2, 1422486000),
(9, 'franckv', 17, 'stephaner', 1148, 1170, 1098, 1074, 1, 1422486000),
(18, 'thierry', 4, 'damien', 871, 650, 830, 940, 2, 1422572400),
(7, 'fabien', 9, 'franckv', 1185, 1209, 1170, 1145, 1, 1422572400),
(2, 'amokrane', 7, 'fabien', 930, 919, 1209, 1217, 2, 1422831600),
(12, 'laurent', 8, 'franckdc', 1193, 1204, 986, 972, 1, 1422831600),
(5, 'dominique', 10, 'henrique', 1255, 1241, 1410, 1421, 2, 1422918000),
(9, 'franckv', 10, 'henrique', 1145, 1136, 1421, 1427, 2, 1422918000),
(7, 'fabien', 17, 'stephaner', 1217, 1231, 1074, 1057, 1, 1422918000),
(7, 'fabien', 10, 'henrique', 1231, 1219, 1427, 1436, 2, 1423004400),
(17, 'stephaner', 8, 'franckdc', 1057, 1022, 972, 1008, 2, 1423004400),
(12, 'laurent', 9, 'franckv', 1204, 1199, 1136, 1141, 3, 1423004400),
(13, 'olivier', 10, 'henrique', 1260, 1228, 1436, 1446, 2, 1423090800),
(8, 'franckdc', 2, 'amokrane', 1008, 1029, 919, 895, 1, 1423090800),
(17, 'stephaner', 9, 'franckv', 1022, 1060, 1141, 1106, 1, 1423090800),
(3, 'bertrand', 16, 'stephaneb', 909, 1168, 1028, 898, 1, 1423090800),
(7, 'fabien', 2, 'amokrane', 1219, 1225, 895, 886, 1, 1423177200),
(12, 'laurent', 17, 'stephaner', 1199, 1164, 1060, 1098, 2, 1423177200),
(15, 'remy', 12, 'laurent', 1043, 1024, 1164, 1181, 2, 1423522800),
(9, 'franckv', 5, 'dominique', 1106, 1142, 1241, 1208, 1, 1423522800),
(17, 'stephaner', 10, 'henrique', 1098, 1091, 1446, 1450, 2, 1423522800),
(10, 'henrique', 12, 'laurent', 1450, 1456, 1181, 1172, 1, 1423609200),
(2, 'amokrane', 6, 'emile', 886, 911, 818, 652, 1, 1423609200),
(9, 'franckv', 10, 'henrique', 1142, 1134, 1456, 1461, 2, 1423782000),
(5, 'dominique', 17, 'stephaner', 1208, 1199, 1091, 1099, 3, 1423782000),
(8, 'franckdc', 2, 'amokrane', 1029, 1048, 911, 890, 1, 1423782000),
(10, 'henrique', 7, 'fabien', 1461, 1430, 1225, 1263, 2, 1424041200),
(17, 'stephaner', 5, 'dominique', 1099, 1133, 1199, 1167, 1, 1424041200),
(5, 'dominique', 7, 'fabien', 1167, 1173, 1263, 1256, 3, 1424127600),
(17, 'stephaner', 9, 'franckv', 1133, 1159, 1134, 1107, 1, 1424127600),
(10, 'henrique', 12, 'laurent', 1430, 1437, 1172, 1162, 1, 1424300400),
(9, 'franckv', 5, 'dominique', 1107, 1085, 1173, 1193, 2, 1424300400),
(7, 'fabien', 10, 'henrique', 1256, 1291, 1437, 1407, 1, 1424646000),
(9, 'franckv', 2, 'amokrane', 1085, 1098, 890, 874, 1, 1424646000),
(5, 'dominique', 10, 'henrique', 1193, 1181, 1407, 1416, 2, 1424732400),
(12, 'laurent', 11, 'joel', 1162, 1171, 896, 829, 1, 1424732400),
(17, 'stephaner', 9, 'franckv', 1159, 1180, 1098, 1075, 1, 1424732400),
(8, 'franckdc', 5, 'dominique', 1048, 1086, 1181, 1146, 1, 1424818800),
(2, 'amokrane', 12, 'laurent', 874, 864, 1171, 1178, 2, 1424818800),
(7, 'fabien', 9, 'franckv', 1291, 1301, 1075, 1062, 1, 1424905200),
(2, 'amokrane', 10, 'henrique', 864, 861, 1416, 1417, 2, 1424905200),
(14, 'patrick', 3, 'bertrand', 945, 1034, 1168, 960, 1, 1424905200),
(6, 'emile', 14, 'patrick', 652, 646, 1034, 1036, 2, 1424905200),
(17, 'stephaner', 5, 'dominique', 1180, 1152, 1146, 1174, 2, 1424905200),
(17, 'stephaner', 7, 'fabien', 1152, 1136, 1301, 1314, 2, 1424991600),
(12, 'laurent', 2, 'amokrane', 1178, 1185, 861, 852, 1, 1424991600),
(10, 'henrique', 9, 'franckv', 1417, 1421, 1062, 1055, 1, 1425250800),
(7, 'fabien', 17, 'stephaner', 1314, 1325, 1136, 1122, 1, 1425250800),
(14, 'patrick', 12, 'laurent', 1036, 1009, 1185, 1200, 2, 1425337200),
(10, 'henrique', 17, 'stephaner', 1421, 1427, 1122, 1113, 1, 1425337200),
(5, 'dominique', 7, 'fabien', 1174, 1209, 1325, 1293, 1, 1425337200),
(6, 'emile', 3, 'bertrand', 646, 824, 960, 781, 1, 1425337200),
(10, 'henrique', 9, 'franckv', 1427, 1431, 1055, 1049, 1, 1425423600),
(3, 'bertrand', 12, 'laurent', 781, 781, 1200, 1204, 2, 1425423600),
(17, 'stephaner', 13, 'olivier', 1113, 1148, 1228, 1163, 1, 1425510000),
(1, 'alexandre', 6, 'emile', 750, 987, 824, 729, 1, 1425510000),
(12, 'laurent', 7, 'fabien', 1204, 1235, 1293, 1264, 1, 1425596400),
(17, 'stephaner', 9, 'franckv', 1148, 1114, 1049, 1084, 2, 1425596400),
(17, 'stephaner', 9, 'franckv', 1114, 1138, 1084, 1059, 1, 1426028400),
(9, 'franckv', 8, 'franckdc', 1059, 1033, 1086, 1111, 2, 1426114800),
(12, 'laurent', 17, 'stephaner', 1235, 1252, 1138, 1118, 1, 1426201200),
(8, 'franckdc', 9, 'franckv', 1111, 1131, 1033, 1010, 1, 1426201200),
(7, 'fabien', 2, 'amokrane', 1264, 1268, 852, 846, 1, 1426201200),
(14, 'patrick', 12, 'laurent', 1009, 1073, 1252, 1213, 1, 1426460400),
(9, 'franckv', 10, 'henrique', 1010, 1005, 1431, 1434, 2, 1426460400),
(13, 'olivier', 7, 'fabien', 1163, 1131, 1268, 1284, 2, 1426546800),
(9, 'franckv', 12, 'laurent', 1005, 1049, 1213, 1175, 1, 1426546800),
(9, 'franckv', 14, 'patrick', 1049, 1079, 1073, 1034, 1, 1426546800),
(10, 'henrique', 17, 'stephaner', 1434, 1439, 1118, 1110, 1, 1426633200),
(9, 'franckv', 2, 'amokrane', 1079, 1035, 846, 897, 2, 1426633200),
(14, 'patrick', 16, 'stephaneb', 1034, 988, 898, 1005, 2, 1426633200),
(15, 'remy', 12, 'laurent', 1024, 1007, 1175, 1190, 2, 1426719600),
(10, 'henrique', 7, 'fabien', 1439, 1450, 1284, 1270, 1, 1426719600),
(9, 'franckv', 17, 'stephaner', 1035, 1012, 1110, 1131, 2, 1426806000),
(12, 'laurent', 2, 'amokrane', 1190, 1197, 897, 887, 1, 1426806000),
(10, 'henrique', 5, 'dominique', 1450, 1418, 1209, 1248, 2, 1426892400),
(14, 'patrick', 12, 'laurent', 988, 973, 1197, 1208, 2, 1426892400),
(1, 'alexandre', 6, 'emile', 987, 1058, 729, 705, 1, 1426892400),
(9, 'franckv', 17, 'stephaner', 1012, 1050, 1131, 1095, 1, 1426892400),
(5, 'dominique', 10, 'henrique', 1248, 1234, 1418, 1429, 2, 1427238000),
(7, 'fabien', 9, 'franckv', 1270, 1280, 1050, 1037, 1, 1427238000),
(6, 'emile', 16, 'stephaneb', 705, 690, 1005, 1021, 2, 1427238000),
(14, 'patrick', 2, 'amokrane', 973, 995, 887, 863, 1, 1427238000),
(1, 'alexandre', 17, 'stephaner', 1058, 937, 1095, 1119, 2, 1427238000),
(1, 'alexandre', 14, 'patrick', 937, 851, 995, 1019, 2, 1427324400),
(12, 'laurent', 8, 'franckdc', 1208, 1227, 1131, 1110, 1, 1427324400),
(12, 'laurent', 14, 'patrick', 1227, 1238, 1019, 1005, 1, 1427324400),
(9, 'franckv', 15, 'remy', 1037, 1062, 1007, 980, 1, 1427324400),
(9, 'franckv', 7, 'fabien', 1062, 1105, 1280, 1243, 1, 1427410800),
(9, 'franckv', 18, 'thierry', 1105, 1108, 650, 650, 1, 1427410800),
(6, 'emile', 8, 'franckdc', 690, 690, 1110, 1114, 2, 1427410800),
(17, 'stephaner', 1, 'alexandre', 1119, 1128, 851, 824, 1, 1427410800),
(12, 'laurent', 18, 'thierry', 1238, 1239, 650, 650, 1, 1427410800),
(7, 'fabien', 10, 'henrique', 1243, 1230, 1429, 1439, 2, 1427666400),
(17, 'stephaner', 7, 'fabien', 1128, 1109, 1230, 1247, 2, 1427752800),
(15, 'remy', 8, 'franckdc', 980, 1020, 1114, 1077, 1, 1427752800),
(16, 'stephaneb', 12, 'laurent', 1021, 995, 1239, 1249, 2, 1427752800),
(9, 'franckv', 10, 'henrique', 1108, 1101, 1439, 1444, 2, 1427752800),
(5, 'dominique', 9, 'franckv', 1234, 1249, 1101, 1083, 1, 1427839200),
(7, 'fabien', 2, 'amokrane', 1247, 1251, 863, 856, 1, 1427839200),
(9, 'franckv', 1, 'alexandre', 1083, 1093, 824, 800, 1, 1427925600),
(7, 'fabien', 8, 'franckdc', 1251, 1216, 1077, 1117, 2, 1427925600),
(3, 'bertrand', 6, 'emile', 781, 832, 690, 656, 1, 1427925600),
(5, 'dominique', 12, 'laurent', 1249, 1272, 1249, 1225, 1, 1427925600),
(12, 'laurent', 9, 'franckv', 1225, 1240, 1093, 1075, 1, 1428012000),
(17, 'stephaner', 15, 'remy', 1109, 1129, 1020, 998, 1, 1428012000),
(9, 'franckv', 8, 'franckdc', 1075, 1105, 1117, 1087, 1, 1428357600),
(9, 'franckv', 17, 'stephaner', 1105, 1133, 1129, 1100, 1, 1428357600),
(1, 'alexandre', 8, 'franckdc', 800, 898, 1087, 1041, 1, 1428357600),
(9, 'franckv', 5, 'dominique', 1133, 1116, 1272, 1286, 2, 1428444000),
(4, 'damien', 6, 'emile', 940, 963, 656, 642, 1, 1428530400),
(10, 'henrique', 7, 'fabien', 1444, 1452, 1216, 1205, 1, 1428530400),
(2, 'amokrane', 1, 'alexandre', 856, 891, 898, 842, 1, 1428530400),
(5, 'dominique', 9, 'franckv', 1286, 1298, 1116, 1101, 1, 1428530400),
(7, 'fabien', 9, 'franckv', 1205, 1222, 1101, 1081, 1, 1428616800),
(17, 'stephaner', 11, 'joel', 1100, 1109, 829, 786, 1, 1428616800),
(2, 'amokrane', 8, 'franckdc', 891, 872, 1041, 1057, 2, 1428616800),
(7, 'fabien', 5, 'dominique', 1222, 1251, 1298, 1270, 1, 1428876000),
(11, 'joel', 8, 'franckdc', 786, 753, 1057, 1066, 2, 1428876000),
(12, 'laurent', 15, 'remy', 1240, 1201, 998, 1044, 2, 1428876000),
(12, 'laurent', 5, 'dominique', 1201, 1230, 1270, 1242, 1, 1428962400),
(9, 'franckv', 17, 'stephaner', 1081, 1110, 1109, 1080, 1, 1428962400),
(7, 'fabien', 2, 'amokrane', 1251, 1255, 872, 865, 1, 1428962400),
(9, 'franckv', 10, 'henrique', 1110, 1157, 1452, 1417, 1, 1429048800),
(5, 'dominique', 7, 'fabien', 1242, 1266, 1255, 1230, 1, 1429048800),
(2, 'amokrane', 6, 'emile', 865, 878, 642, 626, 1, 1429048800),
(7, 'fabien', 10, 'henrique', 1230, 1217, 1417, 1427, 2, 1429135200),
(12, 'laurent', 9, 'franckv', 1230, 1249, 1157, 1136, 1, 1429135200),
(11, 'joel', 2, 'amokrane', 753, 698, 878, 898, 2, 1429221600),
(9, 'franckv', 17, 'stephaner', 1136, 1158, 1080, 1056, 1, 1429221600),
(9, 'franckv', 12, 'laurent', 1158, 1190, 1249, 1219, 1, 1429480800),
(7, 'fabien', 8, 'franckdc', 1217, 1231, 1066, 1049, 1, 1429480800),
(10, 'henrique', 5, 'dominique', 1427, 1398, 1266, 1299, 2, 1429480800),
(5, 'dominique', 10, 'henrique', 1299, 1328, 1398, 1371, 1, 1429567200),
(17, 'stephaner', 9, 'franckv', 1056, 1038, 1190, 1205, 2, 1429567200),
(2, 'amokrane', 7, 'fabien', 898, 889, 1231, 1237, 2, 1429567200),
(17, 'stephaner', 12, 'laurent', 1038, 1051, 1219, 1207, 3, 1429653600),
(7, 'fabien', 9, 'franckv', 1237, 1258, 1205, 1182, 1, 1429653600),
(6, 'emile', 2, 'amokrane', 626, 612, 889, 900, 2, 1429653600),
(10, 'henrique', 9, 'franckv', 1371, 1381, 1182, 1169, 1, 1429740000),
(7, 'fabien', 5, 'dominique', 1258, 1239, 1328, 1345, 2, 1429740000),
(12, 'laurent', 2, 'amokrane', 1207, 1214, 900, 890, 1, 1429740000),
(9, 'franckv', 7, 'fabien', 1169, 1199, 1239, 1210, 1, 1429826400),
(10, 'henrique', 7, 'fabien', 1381, 1392, 1210, 1196, 1, 1430085600),
(6, 'emile', 15, 'remy', 612, 606, 1044, 1048, 2, 1430085600),
(10, 'henrique', 15, 'remy', 1392, 1397, 1048, 1041, 1, 1430172000),
(17, 'stephaner', 2, 'amokrane', 1051, 1010, 890, 935, 2, 1430172000),
(12, 'laurent', 10, 'henrique', 1214, 1201, 1397, 1407, 2, 1430172000),
(8, 'franckdc', 9, 'franckv', 1049, 1088, 1199, 1163, 1, 1430172000),
(9, 'franckv', 5, 'dominique', 1163, 1149, 1345, 1356, 2, 1430258400),
(5, 'dominique', 7, 'fabien', 1356, 1368, 1196, 1181, 1, 1430258400),
(7, 'fabien', 12, 'laurent', 1181, 1207, 1201, 1174, 1, 1430344800),
(2, 'amokrane', 17, 'stephaner', 935, 911, 1010, 1032, 2, 1430344800),
(2, 'amokrane', 17, 'stephaner', 911, 890, 1032, 1050, 2, 1430690400),
(7, 'fabien', 12, 'laurent', 1207, 1229, 1174, 1150, 1, 1430690400),
(10, 'henrique', 7, 'fabien', 1407, 1417, 1229, 1216, 1, 1430776800),
(17, 'stephaner', 5, 'dominique', 1050, 1042, 1368, 1373, 2, 1430776800),
(8, 'franckdc', 12, 'laurent', 1088, 1120, 1150, 1119, 1, 1430863200),
(15, 'remy', 10, 'henrique', 1041, 1035, 1417, 1421, 2, 1430863200),
(7, 'fabien', 5, 'dominique', 1216, 1201, 1373, 1385, 2, 1430863200),
(7, 'fabien', 5, 'dominique', 1201, 1188, 1385, 1395, 2, 1431295200),
(5, 'dominique', 10, 'henrique', 1395, 1375, 1421, 1439, 2, 1431381600),
(15, 'remy', 7, 'fabien', 1035, 1075, 1188, 1152, 1, 1431381600),
(17, 'stephaner', 9, 'franckv', 1042, 1022, 1149, 1167, 2, 1431468000),
(12, 'laurent', 5, 'dominique', 1119, 1109, 1375, 1382, 2, 1431986400),
(9, 'franckv', 10, 'henrique', 1167, 1158, 1439, 1445, 2, 1431986400),
(5, 'dominique', 10, 'henrique', 1382, 1364, 1445, 1461, 2, 1432072800),
(9, 'franckv', 14, 'patrick', 1158, 1173, 1005, 988, 1, 1432072800),
(2, 'amokrane', 9, 'franckv', 890, 879, 1173, 1181, 2, 1432072800),
(8, 'franckdc', 17, 'stephaner', 1120, 1139, 1022, 1001, 1, 1432072800),
(17, 'stephaner', 12, 'laurent', 1001, 1038, 1109, 1074, 1, 1432159200),
(12, 'laurent', 14, 'patrick', 1074, 1094, 988, 965, 1, 1432159200),
(7, 'fabien', 8, 'franckdc', 1152, 1176, 1139, 1113, 1, 1432159200),
(17, 'stephaner', 2, 'amokrane', 1038, 997, 879, 924, 2, 1432245600),
(11, 'joel', 7, 'fabien', 698, 698, 1176, 1179, 2, 1432245600),
(12, 'laurent', 8, 'franckdc', 1094, 1122, 1113, 1084, 1, 1432245600),
(10, 'henrique', 5, 'dominique', 1461, 1475, 1364, 1348, 1, 1432245600),
(15, 'remy', 9, 'franckv', 1075, 1055, 1181, 1198, 2, 1432591200),
(9, 'franckv', 7, 'fabien', 1198, 1221, 1179, 1155, 1, 1432677600),
(17, 'stephaner', 8, 'franckdc', 997, 974, 1084, 1104, 2, 1432677600),
(9, 'franckv', 2, 'amokrane', 1221, 1228, 924, 914, 1, 1432764000),
(8, 'franckdc', 15, 'remy', 1104, 1127, 1055, 1030, 1, 1432764000),
(4, 'damien', 8, 'franckdc', 963, 1057, 1127, 1088, 1, 1432850400),
(4, 'damien', 8, 'franckdc', 1057, 1004, 1088, 1112, 2, 1432850400),
(2, 'amokrane', 15, 'remy', 914, 893, 1030, 1049, 2, 1432850400),
(17, 'stephaner', 7, 'fabien', 974, 1017, 1155, 1116, 1, 1432850400),
(9, 'franckv', 10, 'henrique', 1228, 1267, 1475, 1444, 1, 1433109600),
(8, 'franckdc', 2, 'amokrane', 1112, 1123, 893, 879, 1, 1433109600),
(17, 'stephaner', 12, 'laurent', 1017, 996, 1122, 1140, 2, 1433109600),
(12, 'laurent', 9, 'franckv', 1140, 1175, 1267, 1235, 1, 1433196000),
(10, 'henrique', 11, 'joel', 1444, 1444, 698, 698, 1, 1433196000),
(2, 'amokrane', 7, 'fabien', 879, 929, 1116, 1073, 1, 1433196000),
(9, 'franckv', 10, 'henrique', 1235, 1223, 1444, 1453, 2, 1433282400),
(7, 'fabien', 17, 'stephaner', 1073, 1094, 996, 973, 1, 1433282400),
(9, 'franckv', 15, 'remy', 1223, 1187, 1049, 1090, 2, 1433368800),
(17, 'stephaner', 8, 'franckdc', 973, 1014, 1123, 1085, 1, 1433368800),
(9, 'franckv', 10, 'henrique', 1187, 1178, 1453, 1459, 2, 1433455200),
(2, 'amokrane', 7, 'fabien', 929, 911, 1094, 1109, 2, 1433455200),
(8, 'franckdc', 6, 'emile', 1085, 1033, 606, 676, 2, 1433455200),
(8, 'franckdc', 10, 'henrique', 1033, 1085, 1459, 1423, 1, 1433714400),
(1, 'alexandre', 17, 'stephaner', 842, 817, 1014, 1029, 2, 1433714400),
(6, 'emile', 17, 'stephaner', 676, 667, 1029, 1035, 2, 1433714400),
(2, 'amokrane', 4, 'damien', 911, 950, 1004, 942, 1, 1433714400),
(9, 'franckv', 5, 'dominique', 1178, 1164, 1348, 1359, 2, 1433714400),
(12, 'laurent', 17, 'stephaner', 1175, 1190, 1035, 1017, 1, 1433800800),
(15, 'remy', 7, 'fabien', 1090, 1064, 1109, 1134, 2, 1433800800),
(2, 'amokrane', 4, 'damien', 950, 979, 942, 898, 1, 1433800800),
(14, 'patrick', 9, 'franckv', 965, 950, 1164, 1176, 2, 1433800800),
(2, 'amokrane', 6, 'emile', 979, 987, 667, 656, 1, 1433887200),
(17, 'stephaner', 9, 'franckv', 1017, 1058, 1176, 1139, 1, 1433887200),
(10, 'henrique', 5, 'dominique', 1423, 1399, 1359, 1384, 2, 1433887200),
(18, 'thierry', 6, 'emile', 650, 651, 656, 655, 3, 1433973600),
(10, 'henrique', 7, 'fabien', 1399, 1406, 1134, 1124, 1, 1433973600),
(9, 'franckv', 12, 'laurent', 1139, 1168, 1190, 1161, 1, 1433973600),
(17, 'stephaner', 7, 'fabien', 1058, 1035, 1124, 1145, 2, 1434060000),
(16, 'stephaneb', 14, 'patrick', 995, 939, 950, 984, 2, 1434060000),
(6, 'emile', 8, 'franckdc', 655, 649, 1085, 1089, 2, 1434060000),
(12, 'laurent', 2, 'amokrane', 1161, 1174, 987, 971, 1, 1434319200),
(5, 'dominique', 7, 'fabien', 1384, 1392, 1145, 1134, 1, 1434319200),
(4, 'damien', 2, 'amokrane', 898, 866, 971, 994, 2, 1434405600),
(12, 'laurent', 11, 'joel', 1174, 1177, 698, 698, 1, 1434492000),
(7, 'fabien', 17, 'stephaner', 1134, 1100, 1035, 1071, 2, 1434492000),
(11, 'joel', 2, 'amokrane', 698, 684, 994, 1003, 2, 1434492000),
(5, 'dominique', 10, 'henrique', 1392, 1413, 1406, 1384, 1, 1434492000),
(8, 'franckdc', 12, 'laurent', 1089, 1122, 1177, 1145, 1, 1434578400),
(8, 'franckdc', 12, 'laurent', 1122, 1097, 1145, 1169, 2, 1434664800),
(2, 'amokrane', 17, 'stephaner', 1003, 979, 1071, 1093, 2, 1434664800),
(7, 'fabien', 15, 'remy', 1100, 1097, 1064, 1066, 3, 1434664800),
(12, 'laurent', 9, 'franckv', 1169, 1194, 1168, 1142, 1, 1434924000),
(4, 'damien', 16, 'stephaneb', 866, 909, 939, 885, 1, 1434924000),
(8, 'franckdc', 14, 'patrick', 1097, 1115, 984, 963, 1, 1434924000),
(14, 'patrick', 8, 'franckdc', 963, 1005, 1115, 1077, 1, 1434924000),
(2, 'amokrane', 7, 'fabien', 979, 959, 1097, 1115, 2, 1434924000),
(12, 'laurent', 4, 'damien', 1194, 1202, 909, 898, 1, 1435010400),
(14, 'patrick', 15, 'remy', 1005, 981, 1066, 1088, 2, 1435010400),
(5, 'dominique', 10, 'henrique', 1413, 1390, 1384, 1406, 2, 1435010400),
(13, 'olivier', 17, 'stephaner', 1131, 1166, 1093, 1068, 1, 1435010400),
(5, 'dominique', 10, 'henrique', 1390, 1370, 1406, 1425, 2, 1435096800),
(10, 'henrique', 5, 'dominique', 1425, 1421, 1370, 1373, 3, 1435096800),
(17, 'stephaner', 2, 'amokrane', 1068, 1087, 959, 938, 1, 1435096800),
(9, 'franckv', 16, 'stephaneb', 1142, 1099, 885, 950, 2, 1435096800),
(7, 'fabien', 9, 'franckv', 1115, 1140, 1099, 1073, 1, 1435183200),
(6, 'emile', 15, 'remy', 649, 716, 1088, 1037, 1, 1435269600),
(2, 'amokrane', 17, 'stephaner', 938, 919, 1087, 1103, 2, 1435269600),
(5, 'dominique', 9, 'franckv', 1373, 1379, 1073, 1064, 1, 1435269600),
(9, 'franckv', 5, 'dominique', 1064, 1056, 1379, 1384, 2, 1435269600),
(9, 'franckv', 17, 'stephaner', 1056, 1087, 1103, 1072, 1, 1435528800),
(14, 'patrick', 16, 'stephaneb', 981, 948, 950, 989, 2, 1435528800),
(9, 'franckv', 14, 'patrick', 1087, 1103, 948, 929, 1, 1435615200),
(8, 'franckdc', 17, 'stephaner', 1077, 1104, 1072, 1044, 1, 1435615200),
(14, 'patrick', 9, 'franckv', 929, 912, 1103, 1117, 2, 1435701600),
(17, 'stephaner', 7, 'fabien', 1044, 1023, 1140, 1159, 2, 1435701600),
(16, 'stephaneb', 12, 'laurent', 989, 973, 1202, 1213, 2, 1435701600),
(10, 'henrique', 8, 'franckdc', 1421, 1426, 1104, 1096, 1, 1435788000),
(12, 'laurent', 9, 'franckv', 1213, 1230, 1117, 1097, 1, 1435788000),
(14, 'patrick', 17, 'stephaner', 912, 952, 1023, 985, 1, 1435788000),
(5, 'dominique', 7, 'fabien', 1384, 1393, 1159, 1147, 1, 1435788000),
(7, 'fabien', 17, 'stephaner', 1147, 1161, 985, 968, 1, 1435874400),
(9, 'franckv', 8, 'franckdc', 1097, 1123, 1096, 1068, 1, 1435874400),
(14, 'patrick', 9, 'franckv', 952, 935, 1123, 1137, 2, 1436133600),
(8, 'franckdc', 7, 'fabien', 1068, 1047, 1161, 1179, 2, 1436133600),
(12, 'laurent', 17, 'stephaner', 1230, 1238, 968, 957, 1, 1436133600),
(9, 'franckv', 5, 'dominique', 1137, 1127, 1393, 1400, 2, 1436220000),
(12, 'laurent', 7, 'fabien', 1238, 1258, 1179, 1157, 1, 1436306400),
(9, 'franckv', 14, 'patrick', 1127, 1087, 935, 980, 2, 1436306400),
(7, 'fabien', 9, 'franckv', 1157, 1177, 1087, 1065, 1, 1436392800),
(16, 'stephaneb', 8, 'franckdc', 973, 1010, 1047, 1012, 1, 1436392800),
(8, 'franckdc', 5, 'dominique', 1012, 1064, 1400, 1362, 1, 1436479200),
(9, 'franckv', 7, 'fabien', 1065, 1045, 1177, 1194, 2, 1436479200),
(6, 'emile', 4, 'damien', 716, 697, 898, 914, 2, 1436479200),
(8, 'franckdc', 12, 'laurent', 1064, 1050, 1258, 1269, 2, 1436911200),
(8, 'franckdc', 17, 'stephaner', 1050, 1070, 957, 934, 1, 1436997600),
(7, 'fabien', 8, 'franckdc', 1194, 1210, 1070, 1051, 1, 1437084000),
(5, 'dominique', 10, 'henrique', 1362, 1387, 1426, 1402, 1, 1437084000),
(17, 'stephaner', 2, 'amokrane', 934, 963, 919, 889, 1, 1437343200),
(10, 'henrique', 7, 'fabien', 1402, 1412, 1210, 1197, 1, 1437429600),
(14, 'patrick', 2, 'amokrane', 980, 1001, 889, 865, 1, 1437429600),
(8, 'franckdc', 5, 'dominique', 1051, 1043, 1387, 1392, 2, 1437429600),
(12, 'laurent', 5, 'dominique', 1269, 1253, 1392, 1405, 2, 1437516000),
(9, 'franckv', 2, 'amokrane', 1045, 1003, 865, 912, 2, 1437516000),
(17, 'stephaner', 7, 'fabien', 963, 950, 1197, 1207, 2, 1437516000),
(17, 'stephaner', 9, 'franckv', 950, 954, 1003, 998, 3, 1437602400),
(2, 'amokrane', 12, 'laurent', 912, 966, 1253, 1211, 1, 1437602400),
(9, 'franckv', 17, 'stephaner', 998, 994, 954, 957, 3, 1437688800),
(10, 'henrique', 5, 'dominique', 1412, 1431, 1405, 1384, 1, 1437948000),
(2, 'amokrane', 9, 'franckv', 966, 998, 994, 962, 1, 1437948000),
(7, 'fabien', 15, 'remy', 1207, 1220, 1037, 1021, 1, 1438034400),
(9, 'franckv', 2, 'amokrane', 962, 994, 998, 965, 1, 1438034400),
(10, 'henrique', 7, 'fabien', 1431, 1440, 1220, 1208, 1, 1438120800),
(5, 'dominique', 8, 'franckdc', 1384, 1389, 1043, 1036, 1, 1438120800),
(2, 'amokrane', 9, 'franckv', 965, 937, 994, 1020, 2, 1438120800),
(7, 'fabien', 5, 'dominique', 1208, 1244, 1389, 1358, 1, 1438207200),
(10, 'henrique', 9, 'franckv', 1440, 1443, 1020, 1015, 1, 1438207200),
(2, 'amokrane', 8, 'franckdc', 937, 975, 1036, 999, 1, 1438207200),
(17, 'stephaner', 15, 'remy', 957, 992, 1021, 987, 1, 1438207200),
(15, 'remy', 2, 'amokrane', 987, 1015, 975, 946, 1, 1438293600),
(5, 'dominique', 10, 'henrique', 1358, 1341, 1443, 1457, 2, 1438293600),
(17, 'stephaner', 9, 'franckv', 992, 964, 1015, 1041, 2, 1438293600),
(2, 'amokrane', 15, 'remy', 946, 982, 1015, 980, 1, 1438552800),
(9, 'franckv', 17, 'stephaner', 1041, 1063, 964, 940, 1, 1438552800),
(7, 'fabien', 8, 'franckdc', 1244, 1253, 999, 987, 1, 1438552800),
(2, 'amokrane', 15, 'remy', 982, 1011, 980, 950, 1, 1438639200),
(9, 'franckv', 8, 'franckdc', 1063, 1084, 987, 963, 1, 1438639200),
(17, 'stephaner', 10, 'henrique', 940, 937, 1457, 1458, 2, 1438639200),
(16, 'stephaneb', 12, 'laurent', 1010, 996, 1211, 1222, 2, 1438639200),
(17, 'stephaner', 12, 'laurent', 937, 927, 1222, 1229, 2, 1438725600),
(9, 'franckv', 15, 'remy', 1084, 1101, 950, 930, 1, 1438725600),
(2, 'amokrane', 7, 'fabien', 1011, 999, 1253, 1262, 2, 1438725600),
(2, 'amokrane', 7, 'fabien', 999, 988, 1262, 1270, 2, 1438812000),
(15, 'remy', 9, 'franckv', 930, 913, 1101, 1115, 2, 1438812000),
(15, 'remy', 9, 'franckv', 913, 898, 1115, 1127, 2, 1438812000),
(9, 'franckv', 7, 'fabien', 1127, 1163, 1270, 1237, 1, 1438898400),
(9, 'franckv', 2, 'amokrane', 1163, 1176, 988, 972, 1, 1439157600),
(7, 'fabien', 15, 'remy', 1237, 1194, 898, 952, 2, 1439157600),
(2, 'amokrane', 15, 'remy', 972, 999, 952, 923, 1, 1439244000),
(9, 'franckv', 7, 'fabien', 1176, 1202, 1194, 1167, 1, 1439244000),
(9, 'franckv', 2, 'amokrane', 1202, 1213, 999, 985, 1, 1439416800),
(9, 'franckv', 15, 'remy', 1213, 1220, 923, 913, 1, 1439416800),
(15, 'remy', 9, 'franckv', 913, 903, 1220, 1227, 2, 1439503200),
(9, 'franckv', 15, 'remy', 1227, 1233, 903, 894, 1, 1439762400),
(15, 'remy', 9, 'franckv', 894, 886, 1233, 1239, 2, 1439762400),
(15, 'remy', 9, 'franckv', 886, 878, 1239, 1244, 2, 1439762400),
(9, 'franckv', 2, 'amokrane', 1244, 1252, 985, 974, 1, 1439848800),
(2, 'amokrane', 15, 'remy', 974, 936, 878, 918, 2, 1439935200),
(9, 'franckv', 7, 'fabien', 1252, 1222, 1167, 1198, 2, 1439935200),
(7, 'fabien', 9, 'franckv', 1198, 1224, 1222, 1195, 1, 1440021600),
(7, 'fabien', 9, 'franckv', 1224, 1246, 1195, 1172, 1, 1440108000),
(2, 'amokrane', 15, 'remy', 936, 903, 918, 950, 2, 1440367200),
(5, 'dominique', 7, 'fabien', 1341, 1357, 1246, 1228, 1, 1440367200),
(4, 'damien', 14, 'patrick', 914, 890, 1001, 1022, 2, 1440626400),
(10, 'henrique', 5, 'dominique', 1458, 1433, 1357, 1384, 2, 1440712800),
(3, 'bertrand', 4, 'damien', 832, 897, 890, 853, 1, 1440712800),
(7, 'fabien', 17, 'stephaner', 1228, 1235, 927, 917, 1, 1440972000),
(15, 'remy', 2, 'amokrane', 950, 915, 903, 938, 2, 1440972000);

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

--
-- Structure de la table `phpwc_users`
--

CREATE TABLE IF NOT EXISTS `phpwc_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(32) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `level` enum('1','2','3','4','5') NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `id` (`id`),
  KEY `level` (`level`),
  KEY `password` (`password`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Contenu de la table `phpwc_users`
--

INSERT INTO `phpwc_users` (`id`, `username`, `password`, `level`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '5');

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

--
-- Structure de la table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
  `post_id` int(8) NOT NULL auto_increment,
  `post_content` text NOT NULL,
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_topic` int(8) NOT NULL default '0',
  `post_by` int(8) NOT NULL default '0',
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM AUTO_INCREMENT=85 ;

--
-- Contenu de la table `posts`
--

INSERT INTO `posts` (`post_id`, `post_content`, `post_date`, `post_topic`, `post_by`) VALUES
(1, 'Ã¹mkÃ¹mkmkÃ¹mmÃ¹', '2013-01-20 16:36:11', 1, 1),
(2, 'mlklmkll', '2013-01-20 16:36:20', 1, 1),
(3, 'opjopjpoj', '2013-01-20 16:36:41', 1, 1),
(4, 'passe pas', '2013-01-20 16:38:06', 2, 1),
(5, 'lÃ¹mmlmÃ¹m', '2013-01-20 16:38:31', 2, 1),
(6, 'et puis voila', '2013-01-20 16:38:54', 2, 1),
(7, '<p>m&ugrave;l&ugrave;mlm&ugrave;l&ugrave;</p>\r\n', '2013-01-27 11:51:03', 1, 2),
(8, '<p>a voir</p>\r\n', '2013-01-27 11:52:44', 1, 2),
(9, '<h2><strike><em><strong>lmk cmlj</strong></em></strike></h2>\r\n', '2013-01-27 16:24:05', 1, 2),
(10, '<p><img alt="" src="/kcfinder-2.51/upload/images/jana-jordan-100508-p05-3k_023.jpg" style="width: 400px; height: 600px;" /></p>\r\n', '2013-01-27 17:20:20', 1, 2),
(11, '<p>voici le capture<img alt="" src="/kcfinder-2.51/upload/images/avatar.jpg" style="width: 100px; height: 100px;" /></p>\r\n', '2013-01-27 17:23:02', 1, 2),
(12, '<p><img alt="" src="/kcfinder-2.51/upload/images/48.jpg"  /></p>\r\n', '2013-02-02 11:28:49', 1, 2),
(13, '<p><a href="http://localhost/www/site_01_02_2013/WEBPERSO/page_image.php">http://localhost/www/site_01_02_2013/WEBPERSO/page_image.php</a></p>\r\n', '2013-02-03 09:29:53', 1, 2),
(14, '<p><img alt="" src="/kcfinder-2.51/upload/images/50.jpg" style="width: 300px; height: 450px;" /></p>\r\n', '2013-02-03 09:32:55', 1, 2),
(15, '<p>http://localhost/site_01_02_2013/WEBPERSO/page_image.php</p>\r\n\r\n<p>blalbla</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2013-02-03 10:09:46', 1, 2),
(16, '<p>Un jour sfdsfsdflsemgvdsf</p>\r\n\r\n<p>efzf e<br />\r\nfgrggeggrg</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a href="http://localhost/site_01_02_2013/WEBPERSO/page_image.php">Taille réelle</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>blbla</p>\r\n', '2013-02-03 10:10:29', 1, 2),
(17, '<p>Bonjour,</p>\r\n\r\n<p>Petit exemple.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>A+,</p>\r\n\r\n<p>Patrice<img alt="" src="/kcfinder-2.51/upload/images/21%281%29.jpg" style="width: 400px; height: 267px;" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n<p><a href="http://localhost/site_01_02_2013/WEBPERSO/page_image.php">Taille réelle</a></p>', '2013-02-03 10:26:07', 1, 2),
(18, '<p>essai<img alt="" src="/kcfinder-2.51/upload/images/10.jpg" style="width: 125px; height: 188px;" /></p>\r\n', '2013-02-03 10:39:14', 1, 2),
(19, '<p><img alt="" src="/kcfinder-2.51/upload/images/7.jpg" style="width: 1280px; height: 1920px;" /></p>\r\n', '2013-02-09 22:28:05', 1, 2),
(20, '<p><img alt="" src="/kcfinder-2.51/upload/images/10.jpg" style="width: 1280px; height: 1920px;" /></p>\r\n', '2013-02-09 22:31:43', 1, 2),
(21, '<p><img alt="" src="/kcfinder-2.51/upload/images/miniature_31.jpg"  /></p>\r\n', '2013-02-09 22:33:11', 1, 2),
(22, '<p><img alt="" src="/kcfinder-2.51/upload/images/miniature_31.jpg" style="width: 1280px; height: 1920px;" /></p>\r\n', '2013-02-09 22:34:05', 1, 2),
(23, '<p>Salut les petit loup.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>blmkmkf</p>\r\n\r\n<p><img alt="" src="/kcfinder-2.51/upload/images/miniature_53.jpg" style="width: 1920px; height: 1280px;" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;">que dire de plus</p>\r\n\r\n<p>Au revoir</p>\r\n\r\n<p>Patrice</p>\r\n', '2013-02-09 22:49:02', 1, 2),
(24, '<p>Salut les petit loup.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>blmkmkf</p>\r\n\r\n<p><img alt="" src="/kcfinder-2.51/upload/images/miniature_53.jpg" style="width: 1920px; height: 1280px;" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;">que dire de plus</p>\r\n\r\n<p>Au revoir</p>\r\n\r\n<p>Patrice</p>\r\n', '2013-02-09 22:50:50', 1, 2),
(25, '<ul>\r\n	<li>kjkljkljkjklkhj</li>\r\n</ul>\r\n\r\n<p style="margin-left: 40px;">k&ugrave;ezrrrzzezrr</p>\r\n\r\n<p><img alt="" src="/kcfinder-2.51/upload/images/miniature_29%281%29.jpg" style="width: 1280px; height: 1920px;" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>que dure en plis</p>\r\n\r\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Patrice</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2013-02-09 22:52:04', 1, 2),
(26, '<p>Bldfkgjkjrc gg rtrtryery</p>\r\n\r\n<p>((y(y(yy-ue &egrave;i-_ _&#39;( (-&#39;opk&eacute;okor</p>\r\n\r\n<p><img alt="" src=/kcfinder-2.51/upload/images/miniature_1.jpg /></p>\r\n\r\n<p>aqghrfjgtkfktkfkjt</p>\r\n\r\n<p><img alt="" src=/kcfinder-2.51/upload/images/miniature_2.jpg /></p>\r\n\r\n<p>puis tg -(y- yu&egrave;i</p>\r\n\r\n<p><img alt="" src=/kcfinder-2.51/upload/images/miniature_3.jpg ', '2013-02-10 17:30:28', 1, 2),
(27, '<p>&nbsp;</p>\r\n\r\n<p>test<img alt="" src=/kcfinder-2.51/upload/images/miniature_40.jpg <p><a href="../../kcfinder-2.51/upload/images/">Taille réelle</a></p>', '2013-02-10 17:53:08', 1, 2),
(28, '<p>kjkljkjkl<img alt="" src=/kcfinder-2.51/upload/images/miniature_1.jpg <p><a href="page_image.php?image=1.jpg">Taille rÃ©elle</a></p>', '2013-02-10 18:44:12', 1, 2),
(29, '<p>kjkljkjkl<img alt="" src=/kcfinder-2.51/upload/images/miniature_1.jpg <p><a href="page_image.php?image=1.jpg">Taille rÃ©elle</a></p>', '2013-02-10 18:44:32', 1, 2),
(30, '<p>kjkljkjkl<img alt="" src=/kcfinder-2.51/upload/images/miniature_1.jpg <p><a href="page_image.php?image=1.jpg">Taille rÃ©elle</a></p>', '2013-02-10 18:44:36', 1, 2),
(31, '<p>kjkljkjkl<img alt="" src=/kcfinder-2.51/upload/images/miniature_1.jpg <p><a href="page_image.php?image=1.jpg">Taille rÃ©elle</a></p>', '2013-02-10 18:44:45', 1, 2),
(32, '<p>kjkljkjkl<img alt="" src=/kcfinder-2.51/upload/images/miniature_1.jpg <p><a href="page_image.php?image=1.jpg">Taille rÃ©elle</a></p>', '2013-02-10 18:44:54', 1, 2),
(33, 'Comment piloter les modules Selectronic ', '2013-02-17 17:04:27', 3, 33),
(34, 'llmjlk', '2013-02-17 17:52:34', 4, 33),
(35, '', '2013-02-17 17:53:18', 4, 2),
(36, '', '2013-02-17 17:55:35', 4, 2),
(37, '', '2013-02-17 18:06:27', 4, 2),
(38, '', '2013-02-17 18:06:36', 4, 2),
(39, '', '2013-02-17 18:06:54', 4, 2),
(40, '', '2013-02-17 18:12:23', 4, 2),
(41, '', '2013-02-17 18:13:17', 4, 2),
(42, '', '2013-03-17 10:16:56', 4, 2),
(43, '', '2013-03-17 10:17:30', 4, 2),
(44, '', '2013-03-17 10:18:07', 4, 2),
(45, 'description', '2013-03-17 10:45:20', 5, 33),
(46, '<p>je r&eacute;ponds</p>\r\n', '2013-04-01 16:13:16', 8, 33),
(47, '<p>le peut t&#39;aider</p>\r\n', '2013-04-01 16:43:13', 9, 33),
(48, '<p>kklkhjlk</p>\r\n', '2013-04-01 16:57:24', 8, 33),
(49, '<p>message qui peut t&#39;aider</p>\r\n', '2013-04-01 16:59:40', 8, 33),
(50, '<p>message qui peut t&#39;aider</p>\r\n', '2013-04-01 17:02:58', 8, 33),
(51, '<p>message qui peut t&#39;aider</p>\r\n', '2013-04-01 17:03:50', 8, 33),
(52, '<p>question et message , blabla</p>\r\n', '2013-04-01 17:26:38', 12, 33),
(53, '<p>r&eacute;ponse 1 de last topic</p>\r\n', '2013-04-01 18:34:42', 12, 33),
(54, '<p>R&eacute;ponse 2 de last topic</p>\r\n', '2013-04-01 18:35:02', 12, 33),
(55, '<p style="margin-left: 80px;">R&eacute;ponse N&deg; 3 de <span style="color:#FF8C00;"><span style="font-size: 18px;"><span style="font-family: arial,helvetica,sans-serif;">last topic</span></span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img alt="heart" height="20" src="http://analog-design.net/WORKAREA/WEBSITE/site_29_03_2013/ckeditor/plugins/smiley/images/heart.gif" title="heart" width="20" /></p>\r\n\r\n<p style="margin-left: 80px;">&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;">&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;">&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;"><img alt="" src="/WORKAREA/WEBSITE/TP/Users/pistache/images/pic010_29-5-12.jpg" style="width: 400px; height: 600px;" /></p>\r\n', '2013-04-01 18:37:51', 12, 33),
(56, '<p style="margin-left: 80px;">R&eacute;ponse N&deg; 3 de <span style="color:#FF8C00;"><span style="font-size: 18px;"><span style="font-family: arial,helvetica,sans-serif;">last topic</span></span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img alt="heart" height="20" src="http://analog-design.net/WORKAREA/WEBSITE/site_29_03_2013/ckeditor/plugins/smiley/images/heart.gif" title="heart" width="20" /></p>\r\n\r\n<p style="margin-left: 80px;">&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;">&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;">&nbsp;</p>\r\n\r\n<p style="margin-left: 80px;"><img alt="" src="/WORKAREA/WEBSITE/TP/Users/pistache/images/pic010_29-5-12.jpg" style="width: 400px; height: 600px;" /></p>\r\n', '2013-04-01 18:39:19', 12, 33),
(57, '<p>derni&eacute;re minute</p>\r\n', '2013-04-09 23:07:42', 12, 33),
(58, '<p>derni&eacute;re minute</p>\r\n', '2013-04-09 23:08:39', 12, 33),
(59, '<p>derni&eacute;re minute</p>\r\n', '2013-04-09 23:10:22', 12, 33),
(60, '<p>pas saisie redondante</p>\r\n', '2013-04-09 23:38:58', 12, 33),
(61, '<p>&ccedil;a marche</p>\r\n', '2013-04-09 23:39:36', 12, 33),
(62, '<p>blabla</p>\r\n', '2013-04-11 10:37:04', 13, 33),
(63, '<p>blabla</p>\r\n', '2013-04-11 10:40:04', 14, 33),
(64, '<p>blabla</p>\r\n', '2013-04-11 10:41:00', 15, 33),
(65, '<p>blabla</p>\r\n', '2013-04-11 10:42:20', 16, 33),
(66, '<p>blabla</p>\r\n', '2013-04-11 10:42:26', 17, 33),
(67, '<p>petit con</p>\r\n', '2013-08-07 23:51:33', 1, 33),
(68, '<p>lgklkglmdgk dmlgksmglkslgsk e&ugrave;mk&ugrave;mkmk</p>\r\n', '2013-08-07 23:52:25', 1, 33),
(69, '<p>ceci est un test</p>\r\n', '2013-08-07 23:56:40', 1, 33),
(70, '<p>encore</p>\r\n', '2013-08-08 10:32:39', 1, 33),
(71, '<p><img alt="" src="/WORKAREA/WEBSITE/TP/Users/pistache/images/pic019_29-5-12.jpg" style="width: 474px; height: 600px;" /></p>\r\n\r\n<p>Quelle belle fille !</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2013-08-08 11:45:35', 1, 33),
(72, '<p>salut mon gars</p>\r\n', '2013-12-03 21:13:23', 5, 33),
(73, '<p>youpi<img alt="" src="/WORKAREA/WEBSITE/TP/Users/images/MET-ART_AF_449_0027.jpg" style="width: 399px; height: 600px;" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>fjfd</p>\r\n', '2013-12-03 21:14:52', 5, 33),
(74, '<p>dfskflmkllklk</p>\r\n', '2013-12-12 23:31:50', 2, 33),
(75, '<p>coucou</p>\r\n', '2013-12-12 23:32:04', 2, 33),
(76, '<p>plop&ocirc;&ocirc;$^$<img alt="" src="/WORKAREA/WEBSITE/site_02_12_2013_template/Users/Store/images/Carrie_Minter.jpg" style="width: 600px; height: 398px;" /></p>\r\n', '2013-12-12 23:32:45', 2, 33),
(77, '<p>plop&ocirc;&ocirc;$^$<img alt="" src="/WORKAREA/WEBSITE/site_02_12_2013_template/Users/Store/images/Carrie_Minter.jpg" style="width: 600px; height: 398px;" /></p>\r\n', '2013-12-12 23:32:55', 2, 33),
(78, '<p>yu vas bien ?</p>\r\n', '2013-12-18 22:52:22', 5, 33),
(79, '<p>yu vas bien ?</p>\r\n', '2013-12-18 22:52:33', 5, 33),
(80, '<p>yu vas bien ?</p>\r\n', '2013-12-18 22:52:36', 5, 33),
(81, '<p>et bien , bravo l&#39;artiste</p>\r\n', '2014-04-16 22:03:09', 2, 33),
(82, '<p>bref, pepin le bref</p>\r\n', '2014-04-16 22:03:40', 2, 33),
(83, '<p>quel con</p>\r\n', '2015-08-23 18:40:04', 16, 33),
(84, '<p><span style="color:#FFD700;"><span style="font-family: georgia,serif;"><span style="font-size: 14px;">lkjk<u>ljklkljkl</u></span></span></span></p>\r\n', '2015-08-23 18:43:38', 3, 33);

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

--
-- Structure de la table `powerball`
--

CREATE TABLE IF NOT EXISTS `powerball` (
  `id` int(10) unsigned NOT NULL default '0',
  `nom` varchar(20) default NULL,
  `prenom` varchar(20) default NULL,
  `main_gauche` int(10) default NULL,
  `main_droite` int(10) default NULL,
  `endurance` int(10) default NULL,
  PRIMARY KEY  (`id`),
  KEY `endurance` (`endurance`),
  KEY `id` (`id`),
  KEY `main_droite` (`main_droite`),
  KEY `main_gauche` (`main_gauche`),
  KEY `nom` (`nom`),
  KEY `prenom` (`prenom`)
) TYPE=MyISAM;

--
-- Contenu de la table `powerball`
--

INSERT INTO `powerball` (`id`, `nom`, `prenom`, `main_gauche`, `main_droite`, `endurance`) VALUES
(3, 'Pepy', 'Marc', 11880, 13064, 5475),
(4, 'Sarr', 'Kassim', 8683, 12560, 4681),
(2, 'Jarrige', 'Nicolas', 11697, 13692, 4773),
(1, 'delpy', 'patrice', 10448, 8710, 0),
(7, 'Bruvier', 'Damien', 9356, 12052, 5007),
(6, 'Besse', 'Patrice', 10717, 12400, 4680),
(5, 'Boulet', 'Guy', 12274, 12835, 5506),
(8, 'Turpin', 'Pierre', 7420, 11514, 4428),
(9, 'Pauly', 'Matthieu', 7573, 11103, 0),
(10, 'Delbreil', 'Jean Noel', 7183, 10750, 0),
(11, 'Ahmed', 'Hamada', 0, 10576, 0),
(12, 'Marlier', 'Gabriel', 0, 10441, 0),
(13, 'Flouron', 'Yves', 5674, 11583, 0),
(14, 'Foulon', 'Fabien', 0, 9422, 0),
(15, 'Lance', 'Philippe', 0, 10847, 0),
(16, 'Ramond', 'Stephane', 8190, 11444, 0),
(17, 'Pareilleux', 'Christophe', 0, 9131, 0),
(18, 'Meunier', 'Philippe', 0, 9066, 0),
(19, 'Lee', 'Nicolas', 0, 8687, 0),
(20, 'Rolland', 'Eric', 0, 7856, 0),
(21, 'Bousquet', 'Thierry', 0, 6463, 0),
(22, 'Boitard', 'Fabien', 6588, 11096, 0),
(23, 'Alcouffe', 'Benoit', 5838, 8719, 0),
(24, 'Delatre', 'Marion', 0, 7632, 0),
(25, 'Robin', 'Thierry', 0, 9592, 0);

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

--
-- Structure de la table `PROJ1`
--

CREATE TABLE IF NOT EXISTS `PROJ1` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `heure` varchar(30) NOT NULL default '',
  `fdgg` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `PROJ1`
--


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

--
-- Structure de la table `PROJ2`
--

CREATE TABLE IF NOT EXISTS `PROJ2` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `heure` varchar(30) NOT NULL default '',
  `fdgg` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `PROJ2`
--

INSERT INTO `PROJ2` (`id`, `date`, `heure`, `fdgg`) VALUES
(3, '0000-00-00', '', NULL),
(4, '0000-00-00', '', NULL),
(5, '0000-00-00', '', 'User');

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

--
-- Structure de la table `PROJ3`
--

CREATE TABLE IF NOT EXISTS `PROJ3` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `heure` varchar(30) NOT NULL default '',
  `fdgg` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `PROJ3`
--

INSERT INTO `PROJ3` (`id`, `date`, `heure`, `fdgg`) VALUES
(1, '0000-00-00', '', NULL),
(2, '0000-00-00', '', NULL),
(3, '0000-00-00', '', NULL),
(4, '0000-00-00', '', NULL),
(5, '0000-00-00', '', 'User');

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

--
-- Structure de la table `projet`
--

CREATE TABLE IF NOT EXISTS `projet` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `nom_projet` varchar(30) NOT NULL default '',
  `famille` varchar(30) NOT NULL default '',
  `owner` varchar(30) NOT NULL default '',
  `status` varchar(30) NOT NULL default '',
  `heure` varchar(50) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `debut` date NOT NULL default '0000-00-00',
  `fin` date NOT NULL default '0000-00-00',
  `duree` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;

--
-- Contenu de la table `projet`
--

INSERT INTO `projet` (`id`, `nom_projet`, `famille`, `owner`, `status`, `heure`, `date`, `debut`, `fin`, `duree`) VALUES
(1, 'EVOLUTION', 'Power management', 'superuser', 'actif', '21:46', '2011-06-18', '2011-04-11', '2011-10-11', '6'),
(2, 'BIDULLE', 'Audio', 'superuser', 'inactif', '17:51', '2011-05-01', '0000-00-00', '0000-00-00', ''),
(11, 'P3', 'Autre', '', 'actif', '23:28', '2011-06-25', '2011-06-16', '2011-08-16', '2'),
(4, 'essai', 'Power management', '', 'actif', '11:48', '2011-06-13', '2011-04-29', '2011-06-29', '2'),
(5, 'dsgsd', 'Power management', '', 'actif', '22:44', '2011-06-11', '2011-06-20', '2011-12-20', '6'),
(9, 'P1', 'Power management', '', 'actif', '23:27', '2011-06-25', '2011-09-05', '2012-02-05', '5'),
(10, 'P2', 'Audio', '', 'actif', '23:28', '2011-06-25', '2011-10-03', '2011-12-03', '2'),
(12, 'debug', 'Power management', 'admin', 'actif', '10:26', '2011-07-03', '2011-07-04', '2011-09-04', '2'),
(13, 'aaaaa', 'Power management', 'admin', 'actif', '10:33', '2011-07-03', '2011-07-04', '2011-08-04', '1'),
(14, 'PROJ1', 'Power management', 'admin', 'actif', '11:07', '2011-07-03', '2011-07-01', '2011-08-01', '1'),
(15, 'PROJ2', 'Power management', 'admin', 'actif', '11:10', '2011-07-03', '2011-07-06', '2011-08-06', '1'),
(16, 'PROJ3', 'Power management', 'admin', 'actif', '11:10', '2011-07-03', '2011-07-21', '2011-08-21', '1');

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

--
-- Structure de la table `raspberry`
--

CREATE TABLE IF NOT EXISTS `raspberry` (
  `id` int(10) NOT NULL default '0',
  `password` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Contenu de la table `raspberry`
--

INSERT INTO `raspberry` (`id`, `password`) VALUES
(0, '123456');

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

--
-- Structure de la table `refrigerateur`
--

CREATE TABLE IF NOT EXISTS `refrigerateur` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `consommation_eau` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `refrigerateur`
--


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

--
-- Structure de la table `reservation`
--

CREATE TABLE IF NOT EXISTS `reservation` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `telephone` varchar(15) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `occupant` varchar(30) NOT NULL default '',
  `message` text NOT NULL,
  `tarif` text NOT NULL,
  `date` varchar(20) NOT NULL default '',
  `heure` varchar(20) NOT NULL default '',
  `debut` varchar(10) default NULL,
  `depart` varchar(10) default NULL,
  `note` text NOT NULL,
  `statut` varchar(15) default NULL,
  `avis` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

--
-- Contenu de la table `reservation`
--

INSERT INTO `reservation` (`id`, `nom`, `prenom`, `telephone`, `email`, `occupant`, `message`, `tarif`, `date`, `heure`, `debut`, `depart`, `note`, `statut`, `avis`) VALUES
(10, 'delpy', 'patrice', '0563455132', 'patrice.delpy@free.fr', '', '', '', '2014-11-15', '23:08', '14-07-2015', '31-07-2015', '', 'reserver', ''),
(11, 'blase', 'vincent', '0563455132', 'patrice.delpy@free.fr', '', '', '', '2014-11-16', '17:55', '06-06-2015', '13-06-2015', 'commentaire', 'terminer', ''),
(12, 'aqw', 'zsx', '0563455132', 'patrice.delpy@onsemi.com', '', 'blabla', '', '2014-11-17', '22:33', '12-09-2015', '19-09-2015', '', 'terminer', ''),
(13, 'zorro', 'balou', '0563455132', 'patrice.delpy@onsemi.com', '', 'blabla\r\ndfsdgg\r\ndfsf', '', '2014-11-17', '22:47', '04-04-2015', '11-04-2015', '', 'terminer', ''),
(14, 'kkhk', 'kjhkjh', '0563455132', 'patrice.delpy@onsemi.com', '', 'blabla\r\ndfsdgg\r\ndfsf', '', '2014-11-17', '22:58', '18-04-2015', '25-04-2015', '', 'terminer', ''),
(15, 'essai', 'blase', '000054', 'patrice.delpy@neuf.fr', '', 'kkk', '', '2014-11-22', '23:08', '07-03-2015', '14-03-2015', '', 'terminer', ''),
(16, 'aze', 'qsd', '55555', 'patrice.delpy@neuf.fr', '', 'lmlm', '', '2014-11-23', '17:46', '09-05-2015', '16-05-2015', '', 'terminer', ''),
(17, 'kk', 'kk', '00', 'patrice.delpy@neuf.fr', '', 'lmlm', '', '2014-11-23', '18:31', '20-06-2015', '27-06-2015', '', 'terminer', ''),
(18, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', '', 'ùùm', '', '2014-11-26', '22:57', '23-05-2015', '30-05-2015', '', 'terminer', ''),
(19, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', '', 'ï¿½ï¿½m', '', '2014-11-26', '22:59', '15-08-2015', '29-08-2015', '', 'reserver', ''),
(20, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', '', 'ùùm', '', '2014-11-26', '23:02', '10-10-2015', '24-10-2015', '', 'terminer', ''),
(21, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', '', 'ùùm', '', '2014-11-26', '23:03', '21-03-2015', '28-03-2015', '', 'reserver', ''),
(22, 'trucmuche', 'robert', '0102030405', 'patrice.delpy@free.fr', '12348978', 'alphonse\r\nbis', '', '2014-12-23', '18:42', '04-04-2015', '18-04-2015', '', 'louer', ''),
(23, 'delpy', 'replouf', '0563455132', 'patrice.delpy@free.fr', '', 'gkdk', 'Du 23-02-2015 au 28-02-2015\r\n\r\n5 jours(s): soit 140 Euros ( 28 Euros /jour sachant que la semaine est au tarif de 200 Euros)\r\n\r\nSoit un montant total de : 140 Euros\r\n\r\n\r\n', '2014-12-23', '22:18', '23-02-2015', '28-02-2015', '', 'reserver', ''),
(24, 'aqwzsx', 'qsdfgh', '0563455132', 'patrice.delpy@free.fr', '5', 'nada', 'Du 21-03-2015 au 28-03-2015\r\n\r\n1 semaine(s): ( 200)\r\n\r\nSoit un montant total de : 200 Euros\r\n\r\n\r\n', '2014-12-24', '17:04', '21-03-2015', '28-03-2015', '', 'reserver', ''),
(25, 'wxc', 'TYG', '0000000', 'patrice.delpy@free.fr', '17', 'DSGSG\r\nZQFQF', 'Du 24-03-2015 au 31-03-2015\r\n\r\n4 jours(s): soit 112 Euros ( 28 Euros /jour sachant que la semaine est au tarif de 200 Euros)\r\n\r\n3 jours(s): soit 84 Euros ( 28 Euros /jour sachant que la semaine est au tarif de 200 Euros)\r\n\r\nSoit un montant total de : 196 Euros\r\n\r\n\r\n', '2014-12-24', '17:32', '24-03-2015', '31-03-2015', '', 'reserver', ''),
(26, 'bob', 'kames', '0563455132', 'patrice.delpy@free.fr', '2', 'kkl', 'Du 02-05-2015 au 09-05-2015\r\n\r\n1 semaine(s): ( 300)\r\n\r\nSoit un montant total de : 300 Euros\r\n\r\n\r\n', '2014-12-24', '18:08', '02-05-2015', '09-05-2015', '', 'reserver', ''),
(27, 'bob', 'kames', '0563455132', 'patrice.delpy@free.fr', '4', 'kkl', 'Du 16-02-2015 au 18-02-2015\r\n\r\n2 jours(s): soit 56 Euros ( 28 Euros /jour sachant que la semaine est au tarif de 200 Euros)\r\n\r\nSoit un montant total de : 56 Euros\r\n\r\n\r\n', '2014-12-24', '18:33', '16-02-2015', '18-02-2015', '', 'reserver', ''),
(28, 'zoulou', 'tintin', '0563455132', 'patrice.delpy@free.fr', '3', 'kjkjkl', 'Du 07-03-2015 au 14-03-2015\r\n\r\n1 semaine(s): ( 200)\r\n\r\nSoit un montant total de : 200 Euros\r\n\r\n\r\n', '2014-12-24', '18:37', '07-03-2015', '14-03-2015', 'chien', 'louer', ''),
(29, 'zoulou', 'voltaire', '0102030405', 'patrice.delpy@free.fr', '4', '11 au 18 mai 2015', 'Du 11-05-2015 au 18-05-2015\r\n\r\n5 jours(s): soit 210 Euros ( 42 Euros /jour sachant que la semaine est au tarif de 300 Euros)\r\n\r\n2 jours(s): soit 84 Euros ( 42 Euros /jour sachant que la semaine est au tarif de 300 Euros)\r\n\r\nSoit un montant total de : 294 Euros\r\n\r\n\r\n', '2014-12-24', '22:45', '11-05-2015', '18-05-2015', '', 'terminer', ''),
(30, 'zoulou', 'voltaire', '0102030405', 'patrice.delpy@free.fr', '3', '1 au 9 mai 2015', 'Du 01-05-2015 au 09-05-2015\r\n\r\n1 jours(s): soit 42 Euros ( 42 Euros /jour sachant que la semaine est au tarif de 300 Euros)\r\n\r\n1 semaine(s): ( 300)\r\n\r\nSoit un montant total de : 342 Euros\r\n\r\n\r\n', '2014-12-25', '00:14', '01-05-2015', '09-05-2015', '', 'reserver', ''),
(31, 'delpy', 'patrice', '0563455132', 'patrice.delpy@free.fr', '3', '23 au 30 mai 2015', 'Du 23-05-2015 au 30-05-2015\r\n\r\n1 semaine(s): ( 300)\r\n\r\nSoit un montant total de : 300 Euros\r\n\r\n\r\n', '2014-12-25', '09:49', '23-05-2015', '30-05-2015', '', 'reserver', ''),
(32, 'delpy', 'blase', '0545', 'patrice.delpy@free.fr', '5', '02 au 11 mai', 'Du 02-05-2015 au 11-05-2015\r\n\r\n1 semaine(s): ( 300)\r\n\r\n2 jours(s): soit 84 Euros ( 42 Euros /jour sachant que la semaine est au tarif de 300 Euros)\r\n\r\nSoit un montant total de : 384 Euros\r\n\r\n\r\n', '2014-12-25', '09:56', '02-05-2015', '11-05-2015', '', 'reserver', ''),
(33, 'zoulou', 'replouf', '0563455132', 'patrice.delpy@free.fr', '8', 'joueux noel ', 'Du 04-05-2015 au 11-05-2015\r\n\r\n5 jours(s): soit 210 Euros ( 42 Euros /jour sachant que la semaine est au tarif de 300 Euros)\r\n\r\n2 jours(s): soit 84 Euros ( 42 Euros /jour sachant que la semaine est au tarif de 300 Euros)\r\n\r\nSoit un montant total de : 294 Euros\r\n\r\n\r\n', '2014-12-25', '10:01', '04-05-2015', '11-05-2015', '', 'annuler', ''),
(34, 'charrie', 'Stephanie', '0563455132', 'patrice.delpy@free.fr', '4', 'rien pour le moment', 'Du 02-05-2015 au 16-05-2015\r\n\r\n2 semaine(s): ( 300 300)\r\n\r\nSoit un montant total de : 600 Euros\r\n\r\n\r\n', '2014-12-31', '11:18', '02-05-2015', '16-05-2015', 'aucun', 'reserver', ''),
(35, 'charrie', 's', '0102030405', 'patrice.delpy@free.fr', '4', 'nouveau test\r\n9 au 16 mai', 'Du 09-05-2015 au 23-05-2015\r\n\r\n2 semaine(s): ( 300 300)\r\n\r\nSoit un montant total de : 600 Euros\r\n\r\n\r\n', '2014-12-31', '11:21', '09-05-2015', '23-05-2015', 'aucun', 'reserver', ''),
(36, 'coco', 'cucu', '0563455132', 'patrice.delpy@free.fr', '8', '23 - 30 mai', 'Du 23-05-2015 au 30-05-2015\r\n\r\n1 semaine(s): ( 300)\r\n\r\nSoit un montant total de : 300 Euros\r\n\r\n\r\n', '2014-12-31', '12:08', '23-05-2015', '30-05-2015', 'aucun', 'reserver', 'demande faite'),
(37, 'hollande', 'francois', '0563', 'patrice.delpy@free.fr', '7', '02 au 30 mai', 'Du 02-05-2015 au 30-05-2015\r\n\r\n4 semaine(s): ( 300 300 300 300)\r\n\r\nSoit un montant total de : 1200 Euros\r\n\r\n\r\n', '2014-12-31', '17:12', '02-05-2015', '30-05-2015', 'aucun', 'louer', 'demande faite');

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

--
-- Structure de la table `tarif`
--

CREATE TABLE IF NOT EXISTS `tarif` (
  `id` int(11) NOT NULL auto_increment,
  `annee` varchar(10) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  `ts` varchar(30) NOT NULL default '',
  `tarif` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=197 ;

--
-- Contenu de la table `tarif`
--

INSERT INTO `tarif` (`id`, `annee`, `date`, `ts`, `tarif`) VALUES
(157, '2015', ' 14-02-2015', '1423868400', '200'),
(158, '2015', ' 21-02-2015', '1424473200', '200'),
(159, '2015', ' 28-02-2015', '1425078000', '200'),
(160, '2015', ' 07-03-2015', '1425682800', '200'),
(161, '2015', ' 14-03-2015', '1426287600', '200'),
(162, '2015', ' 21-03-2015', '1426892400', '200'),
(163, '2015', ' 28-03-2015', '1427497200', '200'),
(164, '2015', ' 04-04-2015', '1428098400', '200'),
(165, '2015', ' 11-04-2015', '1428703200', '300'),
(166, '2015', ' 18-04-2015', '1429308000', '300'),
(167, '2015', ' 25-04-2015', '1429912800', '300'),
(168, '2015', ' 02-05-2015', '1430517600', '300'),
(169, '2015', ' 09-05-2015', '1431122400', '300'),
(170, '2015', ' 16-05-2015', '1431727200', '300'),
(171, '2015', ' 23-05-2015', '1432332000', '300'),
(172, '2015', ' 30-05-2015', '1432936800', '350'),
(173, '2015', ' 06-06-2015', '1433541600', '350'),
(174, '2015', ' 13-06-2015', '1434146400', '400'),
(175, '2015', ' 20-06-2015', '1434751200', '450'),
(176, '2015', ' 27-06-2015', '1435356000', '600'),
(177, '2015', ' 04-07-2015', '1435960800', '700'),
(178, '2015', ' 11-07-2015', '1436565600', '800'),
(179, '2015', ' 18-07-2015', '1437170400', '900'),
(180, '2015', ' 25-07-2015', '1437775200', '900'),
(181, '2015', ' 01-08-2015', '1438380000', '900'),
(182, '2015', ' 08-08-2015', '1438984800', '900'),
(183, '2015', ' 15-08-2015', '1439589600', '750'),
(184, '2015', ' 22-08-2015', '1440194400', '650'),
(185, '2015', ' 29-08-2015', '1440799200', '350'),
(186, '2015', ' 05-09-2015', '1441404000', '350'),
(187, '2015', ' 12-09-2015', '1442008800', '300'),
(188, '2015', ' 19-09-2015', '1442613600', '300'),
(189, '2015', ' 26-09-2015', '1443218400', '250'),
(190, '2015', ' 03-10-2015', '1443823200', '200'),
(191, '2015', ' 10-10-2015', '1444428000', '200'),
(192, '2015', ' 17-10-2015', '1445032800', '200'),
(193, '2015', ' 24-10-2015', '1445637600', '200'),
(194, '2015', ' 31-10-2015', '1446246000', '200'),
(195, '2015', ' 07-11-2015', '1446850800', '200'),
(196, '2015', ' 14-11-2015', '1447455600', '200');

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

--
-- Structure de la table `tchat`
--

CREATE TABLE IF NOT EXISTS `tchat` (
  `id` int(1) NOT NULL auto_increment,
  `login` varchar(30) NOT NULL default '',
  `mess` varchar(80) NOT NULL default '',
  `destinataires` text NOT NULL,
  `date_mess` datetime NOT NULL default '0000-00-00 00:00:00',
  `heure_mess` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=277 ;

--
-- Contenu de la table `tchat`
--

INSERT INTO `tchat` (`id`, `login`, `mess`, `destinataires`, `date_mess`, `heure_mess`) VALUES
(47, 'alpha', 'bof', '', '2013-08-09 00:09:14', '00:00:00'),
(46, 'alpha', 'bof', '', '2013-08-09 00:09:11', '00:00:00'),
(45, 'alpha', 'bof', '', '2013-08-09 00:07:56', '00:00:00'),
(44, 'alpha', 'bof', '', '2013-08-09 00:07:55', '00:00:00'),
(43, 'alpha', 'bof', '', '2013-08-09 00:07:52', '00:00:00'),
(42, 'alpha', 'bof', '', '2013-08-09 00:06:32', '00:00:00'),
(41, 'alpha', 'bof', '', '2013-08-09 00:06:31', '00:00:00'),
(40, 'alpha', 'bof', '', '2013-08-09 00:05:45', '00:00:00'),
(39, 'alpha', 'bof', '', '2013-08-09 00:05:39', '00:00:00'),
(38, 'alpha', 'bof', '', '2013-08-09 00:03:24', '00:00:00'),
(37, 'alpha', 'bof', '', '2013-08-09 00:03:23', '00:00:00'),
(36, 'alpha', 'bof', '', '2013-08-09 00:03:22', '00:00:00'),
(35, 'alpha', 'bof', '', '2013-08-09 00:03:20', '00:00:00'),
(34, 'alpha', 'bof', '', '2013-08-09 00:03:19', '00:00:00'),
(33, 'alpha', 'bof', '', '2013-08-09 00:03:18', '00:00:00'),
(32, 'alpha', 'bof', '', '2013-08-09 00:03:16', '00:00:00'),
(31, 'alpha', 'bof', '', '2013-08-09 00:00:30', '00:00:00'),
(28, 'alpha', 'bof', '', '2013-08-08 23:54:38', '00:00:00'),
(29, 'alpha', 'bof', '', '2013-08-08 23:55:33', '00:00:00'),
(30, 'alpha', 'bof', '', '2013-08-08 23:55:37', '00:00:00'),
(48, 'alpha', 'bof', '', '2013-08-09 00:09:46', '00:00:00'),
(49, 'alpha', 'bof', '', '2013-08-09 00:10:51', '00:00:00'),
(50, 'alpha', 'bof', '', '2013-08-09 00:14:50', '00:00:00'),
(51, 'alpha', 'bof', '', '2013-08-09 00:18:32', '00:00:00'),
(52, 'alpha', 'bof', '', '2013-08-09 00:19:35', '00:00:00'),
(53, 'alpha', 'bof', '', '2013-08-09 00:21:36', '00:00:00'),
(54, 'alpha', 'bof', '', '2013-08-09 00:23:30', '00:00:00'),
(55, 'alpha', 'bof', '', '2013-08-09 00:24:09', '00:00:00'),
(56, 'alpha', 'bof', '', '2013-08-09 00:26:00', '00:00:00'),
(57, 'tartuff', 'plouf', '', '2013-08-09 00:27:43', '00:00:00'),
(58, 'gloup', 'dick', '', '2013-08-09 00:28:00', '00:00:00'),
(59, 'connard', 'zobby', '', '2013-08-09 00:28:25', '00:00:00'),
(60, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:11:52', '00:00:00'),
(61, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:16:21', '00:00:00'),
(62, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:18:43', '00:00:00'),
(63, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:20:55', '00:00:00'),
(64, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:22', '00:00:00'),
(65, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:24', '00:00:00'),
(66, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:24', '00:00:00'),
(67, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:24', '00:00:00'),
(68, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:31', '00:00:00'),
(69, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:31', '00:00:00'),
(70, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:31', '00:00:00'),
(71, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:24:32', '00:00:00'),
(72, 'patoche', 'coco', 'text3,text4,text5', '2013-08-12 18:25:33', '00:00:00'),
(73, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 18:52:35', '00:00:00'),
(74, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:02:21', '00:00:00'),
(75, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:06:24', '00:00:00'),
(76, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:06:24', '00:00:00'),
(77, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:06:24', '00:00:00'),
(78, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:06:25', '00:00:00'),
(79, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:06:25', '00:00:00'),
(80, 'patoche', 'Eliot viens d&#039;arriver !', 'text3', '2013-08-12 19:10:00', '00:00:00'),
(81, 'patoche', 'petit essai', '', '2013-08-12 19:13:04', '00:00:00'),
(82, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 19:13:37', '00:00:00'),
(83, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:30', '00:00:00'),
(84, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:30', '00:00:00'),
(85, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:31', '00:00:00'),
(86, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:31', '00:00:00'),
(87, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:32', '00:00:00'),
(88, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:33', '00:00:00'),
(89, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:33', '00:00:00'),
(90, 'patoche', 'cretin mkmlklmklmk', '', '2013-08-12 22:02:34', '00:00:00'),
(91, 'connard', 'essai', '', '2013-08-12 22:13:56', '00:00:00'),
(92, 'blog', 'turte', '', '2013-08-12 22:14:17', '00:00:00'),
(93, 'patoche', 'bougy', 'text4', '2013-08-12 22:18:29', '00:00:00'),
(94, 'patoche', 'khjkhjhjhjhkhk', 'text5', '2013-08-12 22:18:48', '00:00:00'),
(95, 'patoche', 'ouf', 'text2', '2013-08-12 22:19:11', '00:00:00'),
(96, 'patoche', 'ouf', 'text2', '2013-08-12 22:20:09', '00:00:00'),
(97, 'patoche', 'bienvenue', 'text1,text2,text3', '2013-08-12 22:20:25', '00:00:00'),
(98, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:24', '00:00:00'),
(99, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:25', '00:00:00'),
(100, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:25', '00:00:00'),
(101, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:25', '00:00:00'),
(102, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:26', '00:00:00'),
(103, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:26', '00:00:00'),
(104, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:26', '00:00:00'),
(105, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:26', '00:00:00'),
(106, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:27', '00:00:00'),
(107, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:27', '00:00:00'),
(108, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:27', '00:00:00'),
(109, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:28', '00:00:00'),
(110, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:53', '00:00:00'),
(111, 'patoche', 'ouf', 'text2', '2013-08-12 22:22:53', '00:00:00'),
(112, 'patoche', 'bienvenue', 'text1,text2,text3', '2013-08-12 22:22:59', '00:00:00'),
(113, 'patoche', 'efslfmjslmfjfÃ¹lzejfmlfjm\r\n', '', '2013-08-12 22:23:52', '00:00:00'),
(114, 'patoche', 'omjopoop\r\n', '', '2013-08-12 22:23:59', '00:00:00'),
(115, 'patoche', 'omjopoop\r\n', '', '2013-08-12 22:25:32', '00:00:00'),
(116, 'patoche', 'omjopoop\r\n', '', '2013-08-12 22:26:01', '00:00:00'),
(117, 'patoche', 'omjopoop\r\n', '', '2013-08-12 22:29:18', '00:00:00'),
(118, 'patoche', 'abruti', '', '2013-08-12 22:30:06', '00:00:00'),
(119, 'patoche', 'youpi Ã§a fonctionne !', '', '2013-08-12 22:30:42', '00:00:00'),
(120, 'patoche', 'moop', '', '2013-08-12 22:30:53', '00:00:00'),
(121, 'patoche', 'fric', '', '2013-08-12 22:31:15', '00:00:00'),
(122, 'patoche', 'mlklkkl', '', '2013-08-12 22:31:30', '00:00:00'),
(123, 'patoche', 'lojljo', '', '2013-08-12 22:32:04', '00:00:00'),
(124, 'patoche', 'biehdh', '', '2013-08-12 22:32:23', '00:00:00'),
(125, 'patoche', 'iooiiooii', '', '2013-08-12 22:32:37', '00:00:00'),
(126, 'patoche', 'delpy', '', '2013-08-12 22:33:06', '00:00:00'),
(127, 'patoche', 'l\r\n', '', '2013-08-12 22:33:29', '00:00:00'),
(128, 'patoche', '65465465465465', '', '2013-08-12 22:33:35', '00:00:00'),
(129, 'patoche', 'cretino', 'text3', '2013-08-12 22:39:16', '00:00:00'),
(130, 'patoche', 'bravo', 'text1', '2013-08-12 22:40:27', '00:00:00'),
(131, 'patoche', 'aqwzsx', '', '2013-08-12 22:40:42', '00:00:00'),
(132, 'patoche', 'tgf', '', '2013-08-12 22:40:57', '00:00:00'),
(133, 'patoche', 'akoha', 'text5', '2013-08-12 22:41:19', '00:00:00'),
(134, 'patoche', 'azerty', 'text4,text5,text1', '2013-08-12 22:42:09', '00:00:00'),
(135, 'patoche', 'allo', '', '2013-08-12 22:44:14', '00:00:00'),
(136, 'patoche', 'pchit', '', '2013-08-12 22:44:33', '00:00:00'),
(137, 'patoche', 'kjlkjkjkl', '', '2013-08-12 22:44:55', '00:00:00'),
(138, 'patoche', 'lkkljlkklkkkkljkljkljkljlljklk', '', '2013-08-12 22:45:20', '00:00:00'),
(139, 'patoche', '645665556454545645456445464', '', '2013-08-12 22:45:36', '00:00:00'),
(140, 'patoche', 'mÃ¹klkl', '', '2013-08-12 22:45:41', '00:00:00'),
(141, 'patoche', 'jgjkghkjgjgjgjgjhjg', '', '2013-08-12 22:45:50', '00:00:00'),
(142, 'patoche', 'jgjkghkjgjgjgjgjhjg', '', '2013-08-12 22:46:56', '00:00:00'),
(143, 'patoche', 'jgjkghkjgjgjgjgjhjg', '', '2013-08-12 22:47:13', '00:00:00'),
(144, 'patoche', 'lldmlgpdgl^g$fksqfess\r\nefs', '', '2013-08-12 22:48:07', '00:00:00'),
(145, 'patoche', 'ojoijihiuiog', '', '2013-08-12 22:48:21', '00:00:00'),
(146, 'patoche', 'shfhshghdg', '', '2013-08-12 22:48:37', '00:00:00'),
(147, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:57:24', '00:00:00'),
(148, 'patoche', 'connard', '', '2013-08-12 22:58:04', '00:00:00'),
(149, 'patoche', 'ghkjhk', '', '2013-08-12 22:58:32', '00:00:00'),
(150, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:50', '00:00:00'),
(151, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:52', '00:00:00'),
(152, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:52', '00:00:00'),
(153, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:53', '00:00:00'),
(154, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:54', '00:00:00'),
(155, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:54', '00:00:00'),
(156, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:55', '00:00:00'),
(157, 'patoche', 'kjkljkkklhkhkl', '', '2013-08-12 22:58:55', '00:00:00'),
(158, 'patoche', 'zorro\r\n', '', '2013-08-12 22:59:51', '00:00:00'),
(159, 'patoche', 'petit con', '', '2013-08-12 23:00:06', '00:00:00'),
(160, 'patoche', 'zorro\r\n', '', '2013-08-12 23:05:46', '00:00:00'),
(161, 'patoche', 'zorro\r\n', '', '2013-08-12 23:05:47', '00:00:00'),
(162, 'patoche', 'zorro\r\n', '', '2013-08-12 23:05:48', '00:00:00'),
(163, 'patoche', 'zebra', '', '2013-08-12 23:06:09', '00:00:00'),
(164, 'patoche', 'outain de merde', '', '2013-08-12 23:08:21', '00:00:00'),
(165, 'patoche', 'zebra', '', '2013-08-12 23:09:25', '00:00:00'),
(166, 'patoche', 'zebra', '', '2013-08-12 23:09:27', '00:00:00'),
(167, 'patoche', 'petit con', '', '2013-08-12 23:09:35', '00:00:00'),
(168, 'patoche', 'petit con', '', '2013-08-12 23:09:43', '00:00:00'),
(169, 'patoche', 'petit con', '', '2013-08-12 23:09:44', '00:00:00'),
(170, 'patoche', 'petit con', '', '2013-08-12 23:09:51', '00:00:00'),
(171, 'patoche', 'outain de merde', '', '2013-08-12 23:10:00', '00:00:00'),
(172, 'patoche', 'outain de merde', '', '2013-08-12 23:10:00', '00:00:00'),
(173, 'patoche', 'outain de merde', '', '2013-08-12 23:12:28', '00:00:00'),
(174, 'patoche', 'dgd', '', '2013-08-12 23:18:12', '00:00:00'),
(175, 'patoche', 'bien voyons', '', '2013-08-12 23:18:32', '00:00:00'),
(176, 'patoche', 'dgkc', '', '2013-08-12 23:22:07', '00:00:00'),
(177, 'patoche', 'saloperie 65465465456545456465465464', '', '2013-08-12 23:22:23', '00:00:00'),
(178, 'patoche', 'mÃ¹lÃ¹mmlmÃ¹mÃ¹Ã¹mlmÃ¹lÃ¹m', '', '2013-08-12 23:22:38', '00:00:00'),
(179, 'patoche', 'dgkc', '', '2013-08-12 23:22:43', '00:00:00'),
(180, 'patoche', 'dgkc', '', '2013-08-12 23:22:44', '00:00:00'),
(181, 'patoche', 'kldfjkljfkjfkjkjkljkjljlk', '', '2013-08-12 23:22:58', '00:00:00'),
(182, 'patoche', 'okjoj', '', '2013-08-12 23:23:05', '00:00:00'),
(183, 'patoche', 'cretinis', '', '2013-08-12 23:23:15', '00:00:00'),
(184, 'patoche', 'lmklklklklklmlmm\r\nfgdggs\r\ndsfff\r\nqsfqf', '', '2013-08-12 23:23:29', '00:00:00'),
(185, 'patoche', 'A revoir les enfants', '', '2013-08-12 23:23:45', '00:00:00'),
(186, 'patoche', 'a voir mais ya une blÃ©me', '', '2013-08-12 23:24:03', '00:00:00'),
(187, 'patoche', 'problÃ©me', '', '2013-08-12 23:24:22', '00:00:00'),
(188, 'patoche', 'A revoir les enfants', '', '2013-08-12 23:24:31', '00:00:00'),
(189, 'patoche', 'A revoir les enfants', '', '2013-08-12 23:24:32', '00:00:00'),
(190, 'patoche', 'ya u', '', '2013-08-12 23:24:39', '00:00:00'),
(191, 'patoche', 'gdsdf', '', '2013-08-12 23:26:33', '00:00:00'),
(192, 'patoche', 'lkk\r\n', '', '2013-08-12 23:26:40', '00:00:00'),
(193, 'patoche', 'kklm', '', '2013-08-12 23:26:47', '00:00:00'),
(194, 'patoche', 'gdsdf', '', '2013-08-12 23:26:51', '00:00:00'),
(195, 'patoche', 'mmÃ¹mÃ¹mmmÃ¹lÃ¹', '', '2013-08-12 23:26:56', '00:00:00'),
(196, 'patoche', 'Ã¹m', '', '2013-08-12 23:27:04', '00:00:00'),
(197, 'patoche', 'jhghgjhg', '', '2013-08-12 23:27:13', '00:00:00'),
(198, 'patoche', 'jhkjhjk', '', '2013-08-12 23:27:18', '00:00:00'),
(199, 'patoche', 'kjhkj', '', '2013-08-12 23:27:21', '00:00:00'),
(200, 'patoche', 'kjhjk', '', '2013-08-12 23:27:24', '00:00:00'),
(201, 'patoche', 'ppp', '', '2013-08-12 23:27:32', '00:00:00'),
(202, 'patoche', 'hg', '', '2013-08-12 23:27:41', '00:00:00'),
(203, 'patoche', 'gj', '', '2013-08-12 23:27:48', '00:00:00'),
(204, 'patoche', 'hgj', '', '2013-08-12 23:27:55', '00:00:00'),
(205, 'patoche', 'fhfgc', '', '2013-08-12 23:28:00', '00:00:00'),
(206, 'patoche', 'y', '', '2013-08-12 23:28:07', '00:00:00'),
(207, 'patoche', 'g', '', '2013-08-12 23:28:12', '00:00:00'),
(208, 'patoche', 'q', '', '2013-08-12 23:28:17', '00:00:00'),
(209, 'patoche', 'e', '', '2013-08-12 23:28:20', '00:00:00'),
(210, 'patoche', 'jjj', '', '2013-08-12 23:28:25', '00:00:00'),
(211, 'patoche', 'io^p', '', '2013-08-12 23:28:32', '00:00:00'),
(212, 'patoche', 'iiiii', '', '2013-08-12 23:28:37', '00:00:00'),
(213, 'patoche', 'gjk', '', '2013-08-12 23:28:42', '00:00:00'),
(214, 'patoche', 'g estrz&#039;tz z&#039;t', '', '2013-08-12 23:28:52', '00:00:00'),
(215, 'patoche', 'e', '', '2013-08-12 23:29:14', '00:00:00'),
(216, 'patoche', 'e', '', '2013-08-12 23:29:16', '00:00:00'),
(217, 'patoche', 'mlk', '', '2013-08-12 23:29:26', '00:00:00'),
(218, 'patoche', 'mlk', '', '2013-08-12 23:29:32', '00:00:00'),
(219, 'patoche', 'mlk', '', '2013-08-12 23:29:34', '00:00:00'),
(220, 'patoche', 'mlk', '', '2013-08-12 23:29:36', '00:00:00'),
(221, 'patoche', 'mlk', '', '2013-08-12 23:29:38', '00:00:00'),
(222, 'patoche', 'mlk', '', '2013-08-12 23:37:22', '00:00:00'),
(223, 'patoche', 'connard', '', '2013-08-12 23:37:39', '00:00:00'),
(224, 'patoche', 'bidule', '', '2013-08-12 23:37:59', '00:00:00'),
(225, 'patoche', 'pas de rebond', '', '2013-08-12 23:38:51', '00:00:00'),
(226, 'patoche', 'bien', '', '2013-08-12 23:39:13', '00:00:00'),
(227, 'patoche', 'ok', '', '2013-08-12 23:39:22', '00:00:00'),
(228, 'patoche', 'hkjhkjh', '', '2013-08-12 23:39:29', '00:00:00'),
(229, 'patoche', 'que passa', '', '2013-08-12 23:39:46', '00:00:00'),
(230, 'patoche', 'lkj', '', '2013-08-12 23:39:56', '00:00:00'),
(231, 'patoche', 'jlk', '', '2013-08-12 23:40:07', '00:00:00'),
(232, 'patoche', 'klkjl', '', '2013-08-12 23:40:14', '00:00:00'),
(233, 'patoche', 'kkk', '', '2013-08-12 23:40:21', '00:00:00'),
(234, 'patoche', 'ljkl', '', '2013-08-12 23:40:50', '00:00:00'),
(235, 'patoche', 'ya de la roumba', '', '2013-08-12 23:41:05', '00:00:00'),
(236, 'patoche', 'j', '', '2013-08-12 23:41:12', '00:00:00'),
(237, 'patoche', 'jlk', '', '2013-08-12 23:41:19', '00:00:00'),
(238, 'patoche', 'tintin', '', '2013-08-12 23:44:33', '00:00:00'),
(239, 'patoche', '*\r\nÃ¹*\r\nÃ¹', '', '2013-08-12 23:52:19', '00:00:00'),
(240, 'patoche', 'Ã¹Ã¹\r\n', '', '2013-08-12 23:52:25', '00:00:00'),
(241, 'patoche', 'Ã¹Ã¹\r\n', '', '2013-08-12 23:54:41', '00:00:00'),
(242, 'patoche', 'ml', '', '2013-08-12 23:54:51', '00:00:00'),
(243, 'patoche', '^::', '', '2013-08-12 23:55:01', '00:00:00'),
(244, 'patoche', 'll', '', '2013-08-12 23:55:05', '00:00:00'),
(245, 'patoche', 'mmÃ¹', '', '2013-08-12 23:56:58', '00:00:00'),
(246, 'patoche', 'bravo', 'text5', '2013-08-13 00:09:53', '00:00:00'),
(247, 'patoche', 'stupide', 'text2', '2013-08-13 00:10:57', '00:00:00'),
(248, 'patoche', 'pipo', 'text2', '2013-08-13 00:14:30', '00:00:00'),
(249, 'patoche', 'salut les gars !', 'text3', '2013-08-13 17:52:17', '00:00:00'),
(250, 'patoche', 'impressionnant', 'text1,text2', '2013-08-13 17:52:34', '00:00:00'),
(251, 'patoche', 'je sais quelle star', 'text5', '2013-08-13 17:53:55', '00:00:00'),
(252, 'patoche', 'blem', 'text3', '2013-08-13 17:54:10', '00:00:00'),
(253, 'patoche', 'et ho', 'text1', '2013-08-13 17:54:21', '00:00:00'),
(254, 'patoche', 'cretine', 'text3', '2013-08-13 18:11:44', '00:00:00'),
(255, 'patoche', 'bravo', 'text5', '2013-08-13 18:12:10', '00:00:00'),
(256, 'patoche', 'ya quelqu&#039;un', 'text2', '2013-08-13 18:12:39', '00:00:00'),
(257, 'patoche', 'ytrytr', 'text3', '2013-08-13 18:13:01', '00:00:00'),
(258, 'patoche', 'ytryy', 'text1,text2,text3,text4,text5', '2013-08-13 18:13:20', '00:00:00'),
(259, 'lolo', 'coco', 'text4', '2013-10-08 22:14:02', '00:00:00'),
(260, 'lolo', 'coco', 'text4', '2013-10-08 22:15:19', '00:00:00'),
(261, 'lolo', 'coco', 'text4', '2013-10-08 22:15:21', '00:00:00'),
(262, 'lolo', 'zoroo', 'text1', '2013-10-08 22:18:37', '00:00:00'),
(263, 'lolo', 'mlklklk', 'text2', '2013-10-08 22:29:11', '00:00:00'),
(264, 'lolo', 'bravo', 'text2', '2013-10-08 22:30:53', '00:00:00'),
(265, 'text3', 'connard', 'plouf', '2013-10-10 21:34:59', '00:00:00'),
(266, 'text3', 'aqwzx', 'plouf', '2013-10-10 21:36:09', '00:00:00'),
(267, 'plouf', 'je ne sais pas', 'plouf', '2013-10-10 21:38:04', '00:00:00'),
(268, 'plouf', 'jmljkljlm', 'plouf', '2013-10-10 21:38:16', '00:00:00'),
(269, 'plouf', '9446', 'plouf', '2013-10-10 21:38:26', '00:00:00'),
(270, 'pistache', 'coco', 'pistache', '2013-10-10 21:55:41', '00:00:00'),
(271, 'pistache', 'salut', 'plouf,pistache,no', '2013-10-10 21:56:21', '00:00:00'),
(272, 'no', 'reponse', 'pistache,no', '2013-10-10 21:56:42', '00:00:00'),
(273, '', 'lmjml', 'plouf', '2014-04-16 22:05:56', '00:00:00'),
(274, '', 'un jour de plus ...', 'plouf', '2014-04-16 22:06:13', '00:00:00'),
(275, '', 'cretin', 'plouf', '2015-08-23 18:44:24', '00:00:00'),
(276, '', 'kljkjkkljl', 'plouf', '2015-08-23 18:44:44', '00:00:00');

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

--
-- Structure de la table `test01`
--

CREATE TABLE IF NOT EXISTS `test01` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `consommation_d_eau_et_production_d_energie_par_jour` varchar(30) NOT NULL default '',
  `ouverture_par_l_une_des_poignee` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `test01`
--


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

--
-- Structure de la table `test02`
--

CREATE TABLE IF NOT EXISTS `test02` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `consommation_d_eau_et_production_d_energie_par_jour` varchar(30) NOT NULL default '',
  `ouverture_par_l_une_des_poignee` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Contenu de la table `test02`
--


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

--
-- Structure de la table `topics`
--

CREATE TABLE IF NOT EXISTS `topics` (
  `topic_id` int(8) NOT NULL auto_increment,
  `topic_subject` varchar(255) NOT NULL default '',
  `topic_content` text NOT NULL,
  `topic_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `topic_cat` int(8) NOT NULL default '0',
  `topic_by` int(8) NOT NULL default '0',
  PRIMARY KEY  (`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

--
-- Contenu de la table `topics`
--

INSERT INTO `topics` (`topic_id`, `topic_subject`, `topic_content`, `topic_date`, `topic_cat`, `topic_by`) VALUES
(1, 'langage C', 'Cours sur les pointeurs\r\n\r\nefsgeermlgjzvj eopfjoazff$\r\nze\r\nzfzef\r\nf\r\ngrh\r\n\r\negrg(rthtjtjtr', '2013-01-20 16:36:11', 1, 1),
(2, 'Filtrage', 'les filtres elliptiques\r\n\r\nJe voudrais avoir des infos pour un TD.\r\n\r\nMerci', '2013-01-20 16:38:06', 2, 2),
(3, 'Les moteurs pas à pas', 'Comment piloter les modules Selectronic ', '2013-02-17 17:04:27', 3, 33),
(4, 'pipo', 'llmjlk', '2013-02-17 17:52:34', 4, 33),
(5, 'topic bidon', 'description', '2013-03-17 10:45:20', 6, 33),
(6, 'cuisson des tarte', '<p><u>un message qui ne veut rien dire</u></p>\r\n\r\n<p><img alt=\\"cool\\" height=\\"20\\" src=\\"http://analog-design.net/WORKAREA/WEBSITE/site_29_03_2013/ckeditor/plugins/smiley/images/shades_smile.gif\\" title=\\"cool\\" width=\\"20\\" /></p>\r\n', '2013-03-31 18:09:58', 3, 33),
(7, '*ùm*ùm*ùmùm*', '<p>p&icirc;opi^pi^p</p>\r\n', '2013-04-01 11:23:10', 3, 33),
(8, 'topic debug', '<p>rien de neuf</p>\r\n', '2013-04-01 16:06:21', 7, 33),
(9, 'paques', '<p>question: paques ?</p>\r\n', '2013-04-01 16:41:34', 7, 33),
(10, 'titre topic', '<p>contenu du topic</p>\r\n\r\n<p>llksfjsqklfkfjekzfjklzefe rktmltllmrtl</p>\r\n', '2013-04-01 16:44:56', 1, 33),
(11, 'nouveau topic', '<p>message qui vient d&#39;&ecirc;tre saisi</p>\r\n', '2013-04-01 17:23:42', 7, 33),
(12, 'last topic', '<p>question et message , blabla</p>\r\n', '2013-04-01 17:26:38', 7, 33),
(13, 'la culture des patates', '<p>blabla</p>\r\n', '2013-04-11 10:37:04', 7, 33),
(14, 'la culture des patates', '<p>blabla</p>\r\n', '2013-04-11 10:40:04', 7, 33),
(15, 'la culture des patates', '<p>blabla</p>\r\n', '2013-04-11 10:41:00', 7, 33),
(16, 'la culture des patates', '<p>blabla</p>\r\n', '2013-04-11 10:42:20', 7, 33),
(17, 'la culture des patates', '<p>blabla</p>\r\n', '2013-04-11 10:42:26', 7, 33);

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

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(8) NOT NULL auto_increment,
  `user_name` varchar(30) NOT NULL default '',
  `user_pass` varchar(255) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `user_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_level` int(8) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name_unique` (`user_name`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`user_id`, `user_name`, `user_pass`, `user_email`, `user_date`, `user_level`) VALUES
(1, 'pat', 'f1eb08c4e3f8a5ab5761723b1210ad4c30e41dc7', 'pat@free.fr', '2013-01-20 16:28:40', 1),
(2, 'paul', '', '', '0000-00-00 00:00:00', 1);

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

--
-- Structure de la table `user_online`
--

CREATE TABLE IF NOT EXISTS `user_online` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(30) NOT NULL default '',
  `connexion` varchar(30) NOT NULL default '',
  `session` varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

--
-- Contenu de la table `user_online`
--

INSERT INTO `user_online` (`id`, `login`, `connexion`, `session`, `time`) VALUES
(1, 'ffxmph', 'offline', 'none', 0),
(3, 'plouf', 'online', '0', 0),
(4, 'pistache', 'offline', '0', 0),
(5, 'connard', 'offline', 'none', 0),
(6, 'cocoaq', 'offline', 'none', 0),
(7, 'coco1789', 'offline', 'none', 0),
(8, 'zorro', 'offline', 'none', 0),
(9, 'no', 'offline', 'none', 0),
(10, 'brutus', 'offline', 'none', 0),
(11, 'pipoton', 'offline', 'none', 0),
(12, 'pipotron', 'offline', 'none', 0);

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

--
-- Structure de la table `washer`
--

CREATE TABLE IF NOT EXISTS `washer` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `id_catalogue` varchar(20) NOT NULL default '',
  `designation` varchar(50) NOT NULL default '',
  `reference` varchar(20) NOT NULL default '',
  `marque` varchar(20) NOT NULL default '',
  `fournisseur` varchar(20) NOT NULL default '',
  `garantie` varchar(30) NOT NULL default '',
  `dispo` varchar(20) NOT NULL default '',
  `prix_ttc` decimal(7,2) NOT NULL default '0.00',
  `prix_ht` decimal(7,2) NOT NULL default '0.00',
  `remise` varchar(20) NOT NULL default '',
  `tva` decimal(5,2) NOT NULL default '0.00',
  `descriptif` text NOT NULL,
  `caracteristiques` text NOT NULL,
  `image` varchar(20) NOT NULL default '',
  `stock` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `remarques` text NOT NULL,
  `liens` text NOT NULL,
  `heure` varchar(20) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `chargement` varchar(30) NOT NULL default '',
  `vitesse_essorage_trs_min` varchar(30) NOT NULL default '',
  `capacite_lavage_kg` varchar(30) NOT NULL default '',
  `consommation_energie_kwh_cycle` varchar(30) NOT NULL default '',
  `classe_efficacite_essorage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

--
-- Contenu de la table `washer`
--

INSERT INTO `washer` (`id`, `id_catalogue`, `designation`, `reference`, `marque`, `fournisseur`, `garantie`, `dispo`, `prix_ttc`, `prix_ht`, `remise`, `tva`, `descriptif`, `caracteristiques`, `image`, `stock`, `status`, `remarques`, `liens`, `heure`, `date`, `chargement`, `vitesse_essorage_trs_min`, `capacite_lavage_kg`, `consommation_energie_kwh_cycle`, `classe_efficacite_essorage`) VALUES
(1, 'XV37K09', 'lave_linge', 'REF456', 'Brandt', 'Malrieu', '2', '24H', 549.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Frontal,Nombredeprogrammes & 11,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6.5,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 4,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & oui,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '23:27', '19-08-2010', 'Frontal', '1100', '6.5', '4', 'A++'),
(2, 'TF785', 'lave_linge', 'XXX789', 'Bosh', 'caltron', '5', '48H', 1200.00, 1100.00, 'aucune', 19.65, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE,Couleur & blanche,Chargement(*) & Hublot,Nombredeprogrammes & 14,vitesse_essorage_trs_min(*) & 1100,Capacite_lavage_Kg(*) & 6,CONSOMMATIONS: & TITRE,Consommation_energie_KWh_cycle(*) & 2.45,Classe_efficacite_essorage(*) & A++,DISPOSITIFDESECURITE & TITRE,Anti-balours & oui,Anti-mousse & non,CaractÃ©ristiques physiques & TITRE,HxLxP(encm) & ,Poids(enkg) & ', '', '', 'actif', '		', '		', '17:31', '20-08-2010', 'Hublot', '1100', '6', '2.45', 'A++'),
(3, 'fdg', 'lave_linge', 'hjfld', 'Brandt', 'pipotron', '4', '72H', 700.00, 645.00, 'aucune', 19.60, '&lt;p&gt;\r\n	rien&lt;/p&gt;\r\n', 'INFORMATIONSGENERALES: & TITRE\r,Couleur & blanche\r,Chargement(*) & Hublot\r,Nombredeprogrammes & 12\r,vitesse_essorage_trs_min(*) & 1200\r,Capacite_lavage_Kg(*) & 6\r,CONSOMMATIONS: & TITRE\r,Consommation_energie_KWh_cycle(*) & 2.14\r,Classe_efficacite_essorage(*) & A+++\r,DISPOSITIFDESECURITE & TITRE\r,Anti-balours & \r,Anti-mousse & \r,CaractÃ©ristiques physiques & TITRE\r,HxLxP(encm) & \r,Poids(enkg) & 57.8Kg', '', '', 'actif', '		', '		', '23:18', '20-08-2010', 'Hublot', '1200', '6', '2.14', 'A+++'),
(4, 'PT045', 'lave_linge', 'REF464645', 'Candy', 'Malrieu', '2', '24H', 914.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '900', '6', '4.1', 'A+'),
(5, 'PT078', 'lave_linge', 'REF78fgd', 'Candy', 'Malrieu', '2', '24H', 799.00, 645.00, 'aucune', 19.60, 'texte_descriptif', 'texte_caracteristique', '', '', 'actif', 'texte_remarque', 'texte_lien', '23:27', '30-08-2010', 'Frontal', '1100', '6', '4.1', 'A+');
