-- version OVH
-- http://www.phpmyadmin.net
--
-- Serveur: sql2.300gp
-- Généré le : Jeu 11 Décembre 2014 à 23:21
-- 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 ;

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

--
-- 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=5 ;

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

INSERT INTO `avis` (`id`, `nom`, `prenom`, `email`, `sujet`, `message`, `date`, `heure`, `question`, `note`) VALUES
(1, 'delpy', 'patrice', 'patrice.delpy@free.fr', 'mon opinion', 'blabla', '03-11-2014', '19:42:25', 'non-non', '4'),
(2, 'delpylkljlk', 'patrice', 'patrice.delpy@free.fr', 'aasdkfkk', 'ddslfdslgfjl', '03-11-2014', '21:33:36', 'oui-oui', '5'),
(3, 'delpylkljlk', 'patrice', 'patrice.delpy@free.fr', 'aasdkfkk', 'ddslfdslgfjl', '03-11-2014', '21:41:26', 'non-oui', '3'),
(4, 'blase', 'vincent', 'patrice.delpy@free.fr', 'coucou', 'dlgglmdl', '04-11-2014', '19:12:20', 'oui-non', '2');

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

--
-- 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_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 `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 `correspondance`
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Structure de la table `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 ;

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

--
-- 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=83 ;

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

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

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

--
-- 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 `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 '',
  `message` 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,
  `statut` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=22 ;

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

INSERT INTO `reservation` (`id`, `nom`, `prenom`, `telephone`, `email`, `message`, `date`, `heure`, `debut`, `depart`, `statut`) VALUES
(10, 'delpy', 'patrice', '0563455132', 'patrice.delpy@free.fr', '', '2014-11-15', '23:08', '14-07-2015', '31-07-2015', 'libre'),
(11, 'blase', 'vincent', '0563455132', 'patrice.delpy@free.fr', '', '2014-11-16', '17:55', '06-06-2015', '13-06-2015', 'libre'),
(12, 'aqw', 'zsx', '0563455132', 'patrice.delpy@onsemi.com', 'blabla', '2014-11-17', '22:33', '12-09-2015', '19-09-2015', 'libre'),
(13, 'zorro', 'balou', '0563455132', 'patrice.delpy@onsemi.com', 'blabla\r\ndfsdgg\r\ndfsf', '2014-11-17', '22:47', '04-04-2015', '11-04-2015', 'libre'),
(14, 'kkhk', 'kjhkjh', '0563455132', 'patrice.delpy@onsemi.com', 'blabla\r\ndfsdgg\r\ndfsf', '2014-11-17', '22:58', '18-04-2015', '25-04-2015', 'libre'),
(15, 'essai', 'blase', '000054', 'patrice.delpy@neuf.fr', 'kkk', '2014-11-22', '23:08', '07-03-2015', '14-03-2015', 'libre'),
(16, 'aze', 'qsd', '55555', 'patrice.delpy@neuf.fr', 'lmlm', '2014-11-23', '17:46', '09-05-2015', '16-05-2015', 'libre'),
(17, 'kk', 'kk', '00', 'patrice.delpy@neuf.fr', 'lmlm', '2014-11-23', '18:31', '20-06-2015', '27-06-2015', 'libre'),
(18, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', 'ùùm', '2014-11-26', '22:57', '23-05-2015', '30-05-2015', 'libre'),
(19, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', 'ùùm', '2014-11-26', '22:59', '15-08-2015', '29-08-2015', 'libre'),
(20, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', 'ùùm', '2014-11-26', '23:02', '10-10-2015', '24-10-2015', 'libre'),
(21, 'aa', 'jj', '54', 'patrice.delpy@onsemi.com', 'ùùm', '2014-11-26', '23:03', '21-03-2015', '28-03-2015', 'libre');

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

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

CREATE TABLE IF NOT EXISTS `tarif` (
  `id` int(11) NOT NULL auto_increment,
  `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=237 ;

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

INSERT INTO `tarif` (`id`, `date`, `ts`, `tarif`) VALUES
(235, ' 07-11-2015', '1446850800', '200'),
(234, ' 31-10-2015', '1446246000', '200'),
(233, ' 24-10-2015', '1445637600', '200'),
(232, ' 17-10-2015', '1445032800', '200'),
(231, ' 10-10-2015', '1444428000', '200'),
(230, ' 03-10-2015', '1443823200', '200'),
(229, ' 26-09-2015', '1443218400', '250'),
(228, ' 19-09-2015', '1442613600', '300'),
(227, ' 12-09-2015', '1442008800', '300'),
(226, ' 05-09-2015', '1441404000', '350'),
(225, ' 29-08-2015', '1440799200', '350'),
(224, ' 22-08-2015', '1440194400', '650'),
(223, ' 15-08-2015', '1439589600', '750'),
(222, ' 08-08-2015', '1438984800', '900'),
(221, ' 01-08-2015', '1438380000', '900'),
(220, ' 25-07-2015', '1437775200', '900'),
(219, ' 18-07-2015', '1437170400', '900'),
(218, ' 11-07-2015', '1436565600', '800'),
(217, ' 04-07-2015', '1435960800', '700'),
(216, ' 27-06-2015', '1435356000', '600'),
(215, ' 20-06-2015', '1434751200', '450'),
(214, ' 13-06-2015', '1434146400', '400'),
(213, ' 06-06-2015', '1433541600', '350'),
(212, ' 30-05-2015', '1432936800', '350'),
(211, ' 23-05-2015', '1432332000', '300'),
(210, ' 16-05-2015', '1431727200', '300'),
(209, ' 09-05-2015', '1431122400', '300'),
(208, ' 02-05-2015', '1430517600', '300'),
(207, ' 25-04-2015', '1429912800', '300'),
(206, ' 18-04-2015', '1429308000', '300'),
(205, ' 11-04-2015', '1428703200', '300'),
(204, ' 04-04-2015', '1428098400', '200'),
(203, ' 28-03-2015', '1427497200', '200'),
(202, ' 21-03-2015', '1426892400', '200'),
(201, ' 14-03-2015', '1426287600', '200'),
(200, ' 07-03-2015', '1425682800', '200'),
(199, ' 28-02-2015', '1425078000', '200'),
(198, ' 21-02-2015', '1424473200', '200'),
(197, ' 14-02-2015', '1423868400', '200'),
(236, ' 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=275 ;

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

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

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

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

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

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


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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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