-- 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, '<p>\r\n je ne sais pas</p>\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, '<p>\r\n Un super <strong>produit</strong>,</p>\r\n<p>\r\n Hélas, il est <span style="color: rgb(255, 140, 0);"><u><strong>encore inconnu </strong></u></span>c'est été</p>\r\n<ol>\r\n <li>\r\n un</li>\r\n <li>\r\n bla</li>\r\n <li>\r\n lui</li>\r\n</ol>', '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, '<p>\r\n Mega <span style="font-size: 26px;">cool</span></p>', '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, '<p>\r\n <u>message</u></p>\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, '
\r\n\r\nPetit message de Patrice
\r\n', '2013-03-24 18:07:19', 14, 2),
(2, '
\r\n\r\nPetit message de Patrice et du
\r\n', '2013-03-24 18:16:35', 14, 2),
(3, 'Petit message de Patrice
\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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', '
le plein de soleil , je pifou
\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, 'mùlùmlmùlù
\r\n', '2013-01-27 11:51:03', 1, 2),
(8, 'a voir
\r\n', '2013-01-27 11:52:44', 1, 2),
(9, 'lmk cmlj
\r\n', '2013-01-27 16:24:05', 1, 2),
(10, '
\r\n', '2013-01-27 17:20:20', 1, 2),
(11, 'voici le capture
\r\n', '2013-01-27 17:23:02', 1, 2),
(12, '
\r\n', '2013-02-02 11:28:49', 1, 2),
(13, 'http://localhost/www/site_01_02_2013/WEBPERSO/page_image.php
\r\n', '2013-02-03 09:29:53', 1, 2),
(14, '
\r\n', '2013-02-03 09:32:55', 1, 2),
(15, 'http://localhost/site_01_02_2013/WEBPERSO/page_image.php
\r\n\r\nblalbla
\r\n\r\n
\r\n\r\n
\r\n', '2013-02-03 10:09:46', 1, 2),
(16, 'Un jour sfdsfsdflsemgvdsf
\r\n\r\nefzf e
\r\nfgrggeggrg
\r\n\r\n
\r\n\r\nTaille réelle
\r\n\r\n
\r\n\r\n
\r\n\r\nblbla
\r\n', '2013-02-03 10:10:29', 1, 2),
(17, 'Bonjour,
\r\n\r\nPetit exemple.
\r\n\r\n
\r\n\r\nA+,
\r\n\r\nPatrice
\r\n\r\n
\r\n\r\n
\r\nTaille réelle
', '2013-02-03 10:26:07', 1, 2),
(18, 'essai
\r\n', '2013-02-03 10:39:14', 1, 2),
(19, '
\r\n', '2013-02-09 22:28:05', 1, 2),
(20, '
\r\n', '2013-02-09 22:31:43', 1, 2),
(21, '
\r\n', '2013-02-09 22:33:11', 1, 2),
(22, '
\r\n', '2013-02-09 22:34:05', 1, 2),
(23, 'Salut les petit loup.
\r\n\r\n
\r\n\r\nblmkmkf
\r\n\r\n
\r\n\r\n
\r\n\r\nque dire de plus
\r\n\r\nAu revoir
\r\n\r\nPatrice
\r\n', '2013-02-09 22:49:02', 1, 2),
(24, 'Salut les petit loup.
\r\n\r\n
\r\n\r\nblmkmkf
\r\n\r\n
\r\n\r\n
\r\n\r\nque dire de plus
\r\n\r\nAu revoir
\r\n\r\nPatrice
\r\n', '2013-02-09 22:50:50', 1, 2),
(25, '\r\n\r\nkùezrrrzzezrr
\r\n\r\n
\r\n\r\n
\r\n\r\nque dure en plis
\r\n\r\n Patrice
\r\n\r\n
\r\n', '2013-02-09 22:52:04', 1, 2),
(26, 'Bldfkgjkjrc gg rtrtryery
\r\n\r\n((y(y(yy-ue èi-_ _'( (-'opkéokor
\r\n\r\n
\r\n\r\naqghrfjgtkfktkfkjt
\r\n\r\n
\r\n\r\npuis tg -(y- yuèi
\r\n\r\n
\r\n\r\ntest
Taille réelle
', '2013-02-10 17:53:08', 1, 2),
(28, 'kjkljkjklTaille réelle
', '2013-02-10 18:44:12', 1, 2),
(29, 'kjkljkjklTaille réelle
', '2013-02-10 18:44:32', 1, 2),
(30, 'kjkljkjklTaille réelle
', '2013-02-10 18:44:36', 1, 2),
(31, 'kjkljkjklTaille réelle
', '2013-02-10 18:44:45', 1, 2),
(32, 'kjkljkjklTaille réelle
', '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, 'je réponds
\r\n', '2013-04-01 16:13:16', 8, 33),
(47, 'le peut t'aider
\r\n', '2013-04-01 16:43:13', 9, 33),
(48, 'kklkhjlk
\r\n', '2013-04-01 16:57:24', 8, 33),
(49, 'message qui peut t'aider
\r\n', '2013-04-01 16:59:40', 8, 33),
(50, 'message qui peut t'aider
\r\n', '2013-04-01 17:02:58', 8, 33),
(51, 'message qui peut t'aider
\r\n', '2013-04-01 17:03:50', 8, 33),
(52, 'question et message , blabla
\r\n', '2013-04-01 17:26:38', 12, 33),
(53, 'réponse 1 de last topic
\r\n', '2013-04-01 18:34:42', 12, 33),
(54, 'Réponse 2 de last topic
\r\n', '2013-04-01 18:35:02', 12, 33),
(55, 'Réponse N° 3 de last topic 
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n', '2013-04-01 18:37:51', 12, 33),
(56, 'Réponse N° 3 de last topic
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n', '2013-04-01 18:39:19', 12, 33),
(57, 'derniére minute
\r\n', '2013-04-09 23:07:42', 12, 33),
(58, 'derniére minute
\r\n', '2013-04-09 23:08:39', 12, 33),
(59, 'derniére minute
\r\n', '2013-04-09 23:10:22', 12, 33),
(60, 'pas saisie redondante
\r\n', '2013-04-09 23:38:58', 12, 33),
(61, 'ça marche
\r\n', '2013-04-09 23:39:36', 12, 33),
(62, 'blabla
\r\n', '2013-04-11 10:37:04', 13, 33),
(63, 'blabla
\r\n', '2013-04-11 10:40:04', 14, 33),
(64, 'blabla
\r\n', '2013-04-11 10:41:00', 15, 33),
(65, 'blabla
\r\n', '2013-04-11 10:42:20', 16, 33),
(66, 'blabla
\r\n', '2013-04-11 10:42:26', 17, 33),
(67, 'petit con
\r\n', '2013-08-07 23:51:33', 1, 33),
(68, 'lgklkglmdgk dmlgksmglkslgsk eùmkùmkmk
\r\n', '2013-08-07 23:52:25', 1, 33),
(69, 'ceci est un test
\r\n', '2013-08-07 23:56:40', 1, 33),
(70, 'encore
\r\n', '2013-08-08 10:32:39', 1, 33),
(71, '
\r\n\r\nQuelle belle fille !
\r\n\r\n
\r\n', '2013-08-08 11:45:35', 1, 33),
(72, 'salut mon gars
\r\n', '2013-12-03 21:13:23', 5, 33),
(73, 'youpi
\r\n\r\n
\r\n\r\nfjfd
\r\n', '2013-12-03 21:14:52', 5, 33),
(74, 'dfskflmkllklk
\r\n', '2013-12-12 23:31:50', 2, 33),
(75, 'coucou
\r\n', '2013-12-12 23:32:04', 2, 33),
(76, 'plopôô$^$
\r\n', '2013-12-12 23:32:45', 2, 33),
(77, 'plopôô$^$
\r\n', '2013-12-12 23:32:55', 2, 33),
(78, 'yu vas bien ?
\r\n', '2013-12-18 22:52:22', 5, 33),
(79, 'yu vas bien ?
\r\n', '2013-12-18 22:52:33', 5, 33),
(80, 'yu vas bien ?
\r\n', '2013-12-18 22:52:36', 5, 33),
(81, 'et bien , bravo l'artiste
\r\n', '2014-04-16 22:03:09', 2, 33),
(82, 'bref, pepin le bref
\r\n', '2014-04-16 22:03:40', 2, 33),
(83, 'quel con
\r\n', '2015-08-23 18:40:04', 16, 33),
(84, 'lkjkljklkljkl
\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'arriver !', 'text3', '2013-08-12 18:52:35', '00:00:00'),
(74, 'patoche', 'Eliot viens d'arriver !', 'text3', '2013-08-12 19:02:21', '00:00:00'),
(75, 'patoche', 'Eliot viens d'arriver !', 'text3', '2013-08-12 19:06:24', '00:00:00'),
(76, 'patoche', 'Eliot viens d'arriver !', 'text3', '2013-08-12 19:06:24', '00:00:00'),
(77, 'patoche', 'Eliot viens d'arriver !', 'text3', '2013-08-12 19:06:24', '00:00:00'),
(78, 'patoche', 'Eliot viens d'arriver !', 'text3', '2013-08-12 19:06:25', '00:00:00'),
(79, 'patoche', 'Eliot viens d'arriver !', 'text3', '2013-08-12 19:06:25', '00:00:00'),
(80, 'patoche', 'Eliot viens d'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'tz z'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'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', 'un message qui ne veut rien dire
\r\n\r\n![\\"cool\\"](\\"http://analog-design.net/WORKAREA/WEBSITE/site_29_03_2013/ckeditor/plugins/smiley/images/shades_smile.gif\\" "\\\"cool\\\"")
\r\n', '2013-03-31 18:09:58', 3, 33),
(7, '*ùm*ùm*ùmùm*', 'pîopi^pi^p
\r\n', '2013-04-01 11:23:10', 3, 33),
(8, 'topic debug', 'rien de neuf
\r\n', '2013-04-01 16:06:21', 7, 33),
(9, 'paques', 'question: paques ?
\r\n', '2013-04-01 16:41:34', 7, 33),
(10, 'titre topic', 'contenu du topic
\r\n\r\nllksfjsqklfkfjekzfjklzefe rktmltllmrtl
\r\n', '2013-04-01 16:44:56', 1, 33),
(11, 'nouveau topic', 'message qui vient d'être saisi
\r\n', '2013-04-01 17:23:42', 7, 33),
(12, 'last topic', 'question et message , blabla
\r\n', '2013-04-01 17:26:38', 7, 33),
(13, 'la culture des patates', 'blabla
\r\n', '2013-04-11 10:37:04', 7, 33),
(14, 'la culture des patates', 'blabla
\r\n', '2013-04-11 10:40:04', 7, 33),
(15, 'la culture des patates', 'blabla
\r\n', '2013-04-11 10:41:00', 7, 33),
(16, 'la culture des patates', 'blabla
\r\n', '2013-04-11 10:42:20', 7, 33),
(17, 'la culture des patates', 'blabla
\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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, '<p>\r\n rien</p>\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+');
