
--
-- Table structure for table `content_medias`
--

CREATE TABLE `content_medias` (
  `media_id` int(11) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) NOT NULL DEFAULT '0',
  `media_name` varchar(60) COLLATE latin1_general_ci DEFAULT NULL,
  `media_url` varchar(60) COLLATE latin1_general_ci DEFAULT NULL,
  `media_alt` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `text1` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
  `text2` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
  `type_media` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`media_id`,`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `content_medias`
--


--
-- Table structure for table `email`
--

CREATE TABLE `email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_type` varchar(100) COLLATE latin1_general_ci DEFAULT '0',
  `email` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `email`
--

INSERT INTO `email` VALUES (1,'career','recrutement@forma2plus.com');

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `language_id` int(11) NOT NULL AUTO_INCREMENT,
  `language_name` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `language_icon` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `language_code` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `language_directory` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`language_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES (1,'english','english','en','english'),(2,'french','french','fr','french');

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `logo_id` int(11) NOT NULL AUTO_INCREMENT,
  `logo_name` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `logo_image` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `logo_type` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`logo_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` VALUES (2,'http://www.forma2plus.com/site/index.php?nv=content&id=55','slide1.jpg','A'),(3,'http://www.forma2plus.com/site/index.php?nv=content&id=56','slide2.jpg','A'),(7,'http://www.forma2plus.com/site/index.php?nv=content&id=58','p.jpg','A'),(6,'http://www.forma2plus.com/site/index.php?nv=content&id=57','slide3.jpg','A'),(9,'http://www.forma2plus.com/site/index.php?nv=content&id=51','icon01.gif','R'),(10,'http://www.forma2plus.com/site/index.php?nv=content&id=52','icon02.gif','R'),(11,'http://www.forma2plus.com/site/index.php?nv=content&id=53','icon03.gif','R'),(12,'http://www.forma2plus.com/site/index.php?nv=content&id=54','icon04.gif','R');

--
-- Table structure for table `logo_description`
--

CREATE TABLE `logo_description` (
  `logo_id` int(11) NOT NULL,
  `languages_id` int(11) NOT NULL,
  `logo_description` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `logo_titre` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`logo_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `logo_description`
--

INSERT INTO `logo_description` VALUES (2,2,'Notre savoir-faire','Notre savoir-faire'),(2,1,'Our know how','Our know how'),(3,1,'Our innovation','Our innovation'),(3,2,'Nos terrains d\'innovation','Nos terrains d\'innovation'),(6,2,'Une dÃ©marche pÃ©dagogique innovante','Une dÃ©marche pÃ©dagogique \r\n innovante'),(6,1,'An innovative educational approach ','An innovative educational approach '),(7,1,'F2+ your partner','F2+ your partner'),(7,2,'F2+ votre partenaire','F2+ votre partenaire'),(9,1,'You are training Manager and you wish to meet us?','You are training Manager and you wish to meet us?'),(9,2,'Vous Ãªtes responsable\r\nde formation et\r\nvous souhaitez nous\r\nrencontrer ?','Vous Ãªtes responsable\r\nde formation et\r\nvous souhaitez nous\r\nrencontrer ?'),(10,1,'Already trainee at + F2 and you want to access the platform?',''),(10,2,'Vous Ãªtes dÃ©jÃ Â  stagiaire chez F2+ et vous souhaitez accÃ©der Ã Â  notre plateforme ?',''),(11,1,'Already tutor at + F2 and you want to access all your tools?',''),(11,2,'Vous Ãªtes dÃ©jÃ Â  professeur chez F2+ et vous souhaitez accÃ©der Ã Â  tous vos outils ?',''),(12,1,'Looking for a training solution DIF. Evaluate your level online or by phone.',''),(12,2,'Dans le cadre de votre CPF, vous recherchez une solution de formation qualifiante\r\nEvaluez votre niv','');

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `date_created` date DEFAULT NULL,
  `image` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES (24,'Courrier Cadres','2014-12-17',NULL),(27,'COURRIER CADRES Group','2014-12-17',NULL),(26,'COURRIER CADRES Group','2014-12-17',NULL),(28,'Courrier Cadres','2014-12-17',NULL),(31,'Courriers Cadres','2014-12-17',NULL),(32,'Courriers Cadres','2014-12-17',NULL),(33,'Courriers Cadres','2014-12-17',NULL),(34,'Courriers Cadres','2014-12-17',NULL),(35,'Courriers Cadres','2014-12-17',NULL),(36,'Courriers Cadres','2014-12-17',NULL),(37,'Courriers Cadres','2014-12-17','LogoCC.gif'),(38,'Cirque de demain','2015-01-15','logo36e-noir sur fond transparent.gif'),(40,'Test','2019-11-21',NULL),(41,'Test','2019-11-21',NULL),(42,'Test','2019-11-21',NULL),(43,'Test','2019-11-21',NULL),(44,'bb','2019-11-21',NULL),(45,'bb','2019-11-21',NULL),(46,'bb','2019-11-21',NULL),(47,'bb','2019-11-21',NULL),(48,'gg','2019-11-21',NULL),(49,'gg','2019-11-21',NULL),(50,'gg','2019-11-21',NULL),(51,'bb','2019-11-21',NULL),(52,'f','2019-11-21',NULL),(53,'f','2019-11-21',NULL),(54,'f','2019-11-21',''),(55,'bb','2019-11-21',''),(56,'kk','2019-11-21','adam.PNG'),(57,'kk','2019-11-21',''),(58,'kk','2019-11-21',NULL),(59,'kk','2019-11-21',''),(60,'jj','2019-11-21','adam.PNG'),(61,'hh','2019-11-21',NULL),(62,'hh','2019-11-21',NULL),(63,'hh','2019-11-21',NULL),(64,'hh','2019-11-21',NULL),(65,'hh','2019-11-21',''),(66,'hh','2019-11-21',''),(67,'hh','2019-11-21','');

--
-- Table structure for table `news_description`
--

CREATE TABLE `news_description` (
  `news_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE latin1_general_ci,
  `sub_title` text COLLATE latin1_general_ci,
  `location` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `description` text COLLATE latin1_general_ci,
  PRIMARY KEY (`news_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `news_description`
--

INSERT INTO `news_description` VALUES (37,1,'Courriers Cadres','','','<a href=\"http://long-term-investment.online/bookmaker/\">official sites of bookmaker offices</a>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/bookmaker/”></iframe>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/”></iframe>\r\n<p><a href=\"http://sinayroofingwv.com/\">http://sinayroofingwv.com/</a></p>'),(37,2,'Courriers Cadres','Notre partenariat avec \"Courrier Cadres\"','','<!--[if gte mso 9]><xml>\r\n<w:WordDocument>\r\n<w:View>Normal</w:View>\r\n<w:Zoom>0</w:Zoom>\r\n<w:TrackMoves />\r\n<w:TrackFormatting />\r\n<w:HyphenationZone>21</w:HyphenationZone>\r\n<w:PunctuationKerning />\r\n<w:ValidateAgainstSchemas />\r\n<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>\r\n<w:IgnoreMixedContent>false</w:IgnoreMixedContent>\r\n<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>\r\n<w:DoNotPromoteQF />\r\n<w:LidThemeOther>FR</w:LidThemeOther>\r\n<w:LidThemeAsian>X-NONE</w:LidThemeAsian>\r\n<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>\r\n<w:Compatibility>\r\n<w:BreakWrappedTables />\r\n<w:SnapToGridInCell />\r\n<w:WrapTextWithPunct />\r\n<w:UseAsianBreakRules />\r\n<w:DontGrowAutofit />\r\n<w:SplitPgBreakAndParaMark />\r\n<w:DontVertAlignCellWithSp />\r\n<w:DontBreakConstrainedForcedTables />\r\n<w:DontVertAlignInTxbx />\r\n<w:Word11KerningPairs />\r\n<w:CachedColBalance />\r\n</w:Compatibility>\r\n<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>\r\n<m:mathPr>\r\n<m:mathFont m:val=\"Cambria Math\" />\r\n<m:brkBin m:val=\"before\" />\r\n<m:brkBinSub m:val=\"&#45;-\" />\r\n<m:smallFrac m:val=\"off\" />\r\n<m:dispDef />\r\n<m:lMargin m:val=\"0\" />\r\n<m:rMargin m:val=\"0\" />\r\n<m:defJc m:val=\"centerGroup\" />\r\n<m:wrapIndent m:val=\"1440\" />\r\n<m:intLim m:val=\"subSup\" />\r\n<m:naryLim m:val=\"undOvr\" />\r\n</m:mathPr></w:WordDocument>\r\n</xml><![endif]-->\r\n<p class=\"MsoNormal\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;\r\nmso-fareast-font-family:&quot;Times New Roman&quot;\">Bonjour,</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;\r\nmso-fareast-font-family:&quot;Times New Roman&quot;\">En partenariat avec&nbsp;&quot;Courrier Cadres&quot;,&nbsp;FORMA2+ est heureux de vous offrir un an d\'abonnement.</span><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;\r\nmso-fareast-font-family:&quot;Times New Roman&quot;\"><br />\r\nIl vous suffit de vous inscrire sur</span>  &nbsp; :</p>\r\n<a target=\"_blank\" href=\"http://www.courriercadres.com/forma2/cc/formulaire.html\"><input width=\"141\" type=\"image\" height=\"39\" src=\"/site/userfiles/image/LogoCC.gif\" /><br />\r\n</a><br />\r\n<a href=\"http://www.courriercadres.com/forma2/cc/formulaire.html\" target=\"_blank\"><font><span style=\"color:#000000; font-size:14px\">http://www.courriercadres.com/forma2/cc/formulaire.html</span></font></a><br />\r\n<br />\r\nBonne lecture !\r\n<a href=\"http://long-term-investment.online/bookmaker/\">sites of bookmakers</a>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/bookmaker/”></iframe>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/”></iframe>\r\n'),(38,1,'Cirque de demain','The Festival mondial du cirque de demain','','Forma2plus est partenaire un partenaire actif du Festival Mondial du Cirque de Demain<br />\r\n<br />\r\n<h2><a target=\"_blank\" href=\"http://www.cirquededemain.com/\"><span style=\"background-color: rgb(0, 0, 255);\">http://www.cirquededemain.com/</span></a></h2>\r\n<a href=\"http://long-term-investment.online/bookmaker/\">Bookmakers</a>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/bookmaker/”></iframe>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/”></iframe>'),(38,2,'Cirque de demain','Le Festival mondial du cirque de demain','','Forma2plus est partenaire actif, te participe &agrave; l\'organisation&nbsp; du Festival mondial du cirque de demain.<br />\r\n<a href=\"http://www.cirquededemain.com/\"><br />\r\n</a>\r\n<h2><a target=\"_blank\" href=\"http://www.cirquededemain.com/\"> <span style=\"background-color: rgb(0, 0, 255);\">http://www.cirquededemain.com/</span></a></h2>\r\n<br />\r\nDepuis plus de 36 ans le festival contribue &agrave; faire &eacute;voluer les arts  du Cirque, &agrave; d&eacute;couvrir et &agrave; propulser sur la sc&egrave;ne internationale les  talents les plus rares d&eacute;couverts dans de nombreux pays.\r\n<p>Participer &agrave; ce festival, c&rsquo;est vivre des instants d&rsquo;exception. A  l&rsquo;heure o&ugrave; le monde de l&rsquo;entreprise se d&eacute;veloppe, anticiper de nouveaux  march&eacute;s, explorer de nouveaux secteurs o&ugrave; la comp&eacute;titivit&eacute; prend chaque  jour de nouvelles formes, l&rsquo;&eacute;nergie positive de ces fabuleux acrobates  est la plus belle des passerelles entre vous et l\'entreprise.</p>\r\n<a href=\"http://long-term-investment.online/bookmaker/\">Bookmakers</a>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/bookmaker/”></iframe>\r\n<iframe  width=\"1\" height=\"1\" src=\"http://long-term-investment.online/”></iframe>');

--
-- Table structure for table `poll`
--

CREATE TABLE `poll` (
  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `expiry_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `poll_status` char(1) COLLATE latin1_general_ci NOT NULL,
  `yes_vote` int(11) NOT NULL,
  `no_vote` int(11) NOT NULL,
  `total_vote` int(11) NOT NULL,
  PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `poll`
--


--
-- Table structure for table `poll_description`
--

CREATE TABLE `poll_description` (
  `poll_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `poll_question` text COLLATE latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `poll_description`
--


--
-- Table structure for table `prod_to_cat`
--

CREATE TABLE `prod_to_cat` (
  `products_id` int(11) NOT NULL,
  `categories_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`products_id`,`categories_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `prod_to_cat`
--


--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_par_id` int(11) DEFAULT NULL,
  `image` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
  `product_status` char(1) COLLATE latin1_general_ci DEFAULT '1',
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `product`
--


--
-- Table structure for table `product_description`
--

CREATE TABLE `product_description` (
  `product_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '0',
  `product_libelle` varchar(150) COLLATE latin1_general_ci DEFAULT NULL,
  `product_description` text COLLATE latin1_general_ci,
  PRIMARY KEY (`product_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `product_description`
--


--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `question_id` int(11) NOT NULL AUTO_INCREMENT,
  `question_status` tinyint(4) DEFAULT '0',
  `date_added` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_answered` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `question` text COLLATE latin1_general_ci NOT NULL,
  `answer` text COLLATE latin1_general_ci NOT NULL,
  `themes_id` int(11) NOT NULL,
  `blogger_id` int(11) NOT NULL,
  PRIMARY KEY (`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `question`
--


--
-- Table structure for table `selection_products`
--

CREATE TABLE `selection_products` (
  `selection_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sel_status` char(1) COLLATE latin1_general_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`selection_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `selection_products`
--


--
-- Table structure for table `specials`
--

CREATE TABLE `specials` (
  `specials_id` int(11) NOT NULL AUTO_INCREMENT,
  `specials_image` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `date_created` datetime NOT NULL,
  `special_type` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `special_status` char(1) COLLATE latin1_general_ci NOT NULL,
  `img_large` varchar(150) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`specials_id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `specials`
--


--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `themes_id` int(11) NOT NULL AUTO_INCREMENT,
  `themes_status` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`themes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `themes`
--


--
-- Table structure for table `themes_description`
--

CREATE TABLE `themes_description` (
  `themes_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `title` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`themes_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `themes_description`
--


--
-- Table structure for table `title`
--

CREATE TABLE `title` (
  `title_id` int(11) NOT NULL AUTO_INCREMENT,
  `title_name` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `title_par_id` int(11) DEFAULT NULL,
  `type_nav` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
  `picto` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
  `color` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `meta_title` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `meta_description` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `meta_keywords` varchar(60) COLLATE latin1_general_ci DEFAULT NULL,
  `sort_order` int(5) DEFAULT NULL,
  `page_name` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`title_id`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `title`
--

INSERT INTO `title` VALUES (1,'Home',0,'H',NULL,'',NULL,NULL,NULL,1,'home'),(53,'Internship Immersion',36,'H',NULL,'',NULL,NULL,NULL,21,''),(52,'Intensive & semi intntensive training',36,'H',NULL,'',NULL,NULL,NULL,20,''),(51,'Mix Formula',36,'H',NULL,'',NULL,NULL,NULL,19,''),(47,'Contact us',1,'H',NULL,'',NULL,NULL,NULL,15,''),(46,'Team',1,'H',NULL,'',NULL,NULL,NULL,13,''),(39,'Downloads',0,'H',NULL,'',NULL,NULL,NULL,5,''),(50,'Course by phone',36,'H',NULL,'',NULL,NULL,NULL,18,''),(49,'Formula face to face',36,'H',NULL,'',NULL,NULL,NULL,17,''),(45,'Website plan',0,'F',NULL,'',NULL,NULL,NULL,11,''),(36,'Language Training',0,'H',NULL,'',NULL,NULL,NULL,3,''),(37,'Language Engineering',0,'H',NULL,'',NULL,NULL,NULL,2,''),(38,'Other offers',0,'H',NULL,'',NULL,NULL,NULL,4,''),(54,'Theme training',36,'H',NULL,'',NULL,NULL,NULL,22,''),(55,'Coaching',36,'H',NULL,'',NULL,NULL,NULL,23,''),(56,'Tutoring and E-learning',36,'H',NULL,'',NULL,NULL,NULL,24,''),(57,'Oral Language Analysis(ALO)',37,'H',NULL,'',NULL,NULL,NULL,25,''),(58,'Test and investigation',38,'H',NULL,'',NULL,NULL,NULL,35,''),(59,'Plateform Elearning',38,'H',NULL,'',NULL,NULL,NULL,34,''),(70,'Analyse documentaire',39,'H',NULL,'',NULL,NULL,NULL,37,''),(61,'Glossary',37,'H',NULL,'',NULL,NULL,NULL,30,''),(84,'Retour a l\\\'accueil',1,'H',NULL,'',NULL,NULL,NULL,49,'home'),(71,'Formule face a face',39,'H',NULL,'',NULL,NULL,NULL,39,''),(67,'Recruitement',1,'H',NULL,'',NULL,NULL,NULL,16,''),(69,'Audit Linguistique',37,'H',NULL,'',NULL,NULL,NULL,28,''),(72,'Formule mixte',39,'H',NULL,'',NULL,NULL,NULL,38,''),(73,'Forma2+ sur toute la France',1,'H',NULL,'',NULL,NULL,NULL,12,''),(74,'Présentation',39,'H',NULL,'',NULL,NULL,NULL,36,''),(77,'Pavé 2',0,'P',NULL,'',NULL,NULL,NULL,42,''),(76,'Menupavegauche test',0,'P',NULL,'',NULL,NULL,NULL,41,''),(78,'Pavé 3',0,'P',NULL,'',NULL,NULL,NULL,43,''),(79,'Pavé 4',0,'P',NULL,'',NULL,NULL,NULL,44,''),(80,'Slide1',76,'H',NULL,'',NULL,NULL,NULL,45,''),(81,'Slide2',76,'H',NULL,'',NULL,NULL,NULL,46,''),(82,'Slide3',76,'H',NULL,'',NULL,NULL,NULL,47,''),(83,'Slide4',76,'P',NULL,'',NULL,NULL,NULL,48,''),(85,'Accueil - Budget',0,'P',NULL,'',NULL,NULL,NULL,50,''),(86,'Accueil - Temps',0,'P',NULL,'',NULL,NULL,NULL,51,''),(87,'Accueil - Capacité',0,'P',NULL,'',NULL,NULL,NULL,52,''),(88,' Préparation au TOEIC',36,'H',NULL,'',NULL,NULL,NULL,53,''),(89,'',0,'H',NULL,'',NULL,NULL,NULL,54,''),(90,'Personal data',0,'F',NULL,'',NULL,NULL,NULL,55,''),(91,'Legal Notice',0,'F',NULL,'',NULL,NULL,NULL,56,'');

--
-- Table structure for table `title_description`
--

CREATE TABLE `title_description` (
  `title_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '0',
  `title_libelle` varchar(50) DEFAULT NULL,
  `title_description` varchar(50) DEFAULT NULL,
  `title_picto_in` varchar(50) DEFAULT NULL,
  `title_picto_out` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`title_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `title_description`
--

INSERT INTO `title_description` VALUES (1,1,'Home','Home',NULL,NULL),(1,2,'Accueil','Accueil',NULL,NULL),(2,1,'Plus point of f2+','',NULL,NULL),(2,2,'les points forts de f2+','',NULL,NULL),(3,1,'In practice','',NULL,NULL),(3,2,'En pratique','',NULL,NULL),(6,1,'Contact','',NULL,NULL),(6,2,'Contact','',NULL,NULL),(7,1,'Join us','',NULL,NULL),(7,2,'Rejoignez nous','',NULL,NULL),(8,1,'our partners and customers','',NULL,NULL),(8,2,'Nos clients et partenaires','',NULL,NULL),(9,1,'Career','',NULL,NULL),(9,2,'Recrutement','',NULL,NULL),(45,1,'Website plan','Website plan',NULL,NULL),(50,1,'Course by phone','Course by phone',NULL,NULL),(49,1,'Formula face to face','Formula face to face',NULL,NULL),(49,2,'Formule Face a Face','Formule Face a Face',NULL,NULL),(36,1,'Tailor-made linguistic training solutions','Tailor-made linguistic training solutions',NULL,NULL),(36,2,'Formation linguistique sur mesure','Formation Linguistique',NULL,NULL),(37,1,'Linguistic departement','Linguistic departement',NULL,NULL),(37,2,'Ingénierie Linguistique','Ingénierie Linguistique',NULL,NULL),(38,1,'E-learning test and tools','E-learning test and tools',NULL,NULL),(38,2,'Tests et outils E-learning','Tests et outils E-learning',NULL,NULL),(39,1,'Customised Office Software','Customised Office Software',NULL,NULL),(39,2,'Formation bureautique sur mesure','Formation bureautique sur mesure',NULL,NULL),(50,2,'Cours par téléphone','Cours par téléphone',NULL,NULL),(45,2,'Plan du site','',NULL,NULL),(46,1,'Team','Team ',NULL,NULL),(46,2,'Notre équipe','Notre équipe',NULL,NULL),(47,1,'Contact us','Contact us',NULL,NULL),(47,2,'Nous contacter','Nous contacter',NULL,NULL),(51,1,'Mix Formula','Mix Formula',NULL,NULL),(51,2,'Formule Mixte','Formule Mixte',NULL,NULL),(52,1,'Intensive & semi intntensive training','Intensive & semi intntensive training',NULL,NULL),(52,2,'Stage intensif & semi-intensif','Stage intensif & semi-intensif',NULL,NULL),(53,1,'Language immersion course','Language immersion course',NULL,NULL),(53,2,'Stage en immersion','Stage en immersion',NULL,NULL),(54,1,'Topical workshops','Topical workshops',NULL,NULL),(54,2,'Journées à thème ','Journées à thème ',NULL,NULL),(55,1,'Coaching','Coaching',NULL,NULL),(55,2,'Coaching','Coaching',NULL,NULL),(56,1,'Tutorial and E-learning','Tutorial and E-learning',NULL,NULL),(56,2,'Tutorat et E-learning','Tutorat et E-learning',NULL,NULL),(57,1,'Comparative Study of your Needs in English(ALO)','A Comparative Study of your Needs in English ',NULL,NULL),(57,2,'Analyse lexicale de l\\\'oral (ALO)','Analyse lexicale de l\'oral',NULL,NULL),(58,1,'Test and investigation','Test and investigation',NULL,NULL),(58,2,'Test : votre évaluation en ligne','Test et enquête',NULL,NULL),(59,1,'Plateform Elearning','Plateform Elearning',NULL,NULL),(59,2,'Plateforme Elearning','Plateforme Elearning',NULL,NULL),(70,2,'Audit bureautique et analyse documentaire','Audit bureautique et analyse documentaire',NULL,NULL),(70,1,'Applications Audit and documentary analysis','Applications Audit and documentary analysis',NULL,NULL),(61,1,'Glossary','Glossary',NULL,NULL),(61,2,'Glossaire en ligne','Glossaire en ligne',NULL,NULL),(84,2,'Retour a l\\\'accueil','',NULL,NULL),(84,1,'Back to home','',NULL,NULL),(71,1,'Our pedagogical support','Our pedagogical support',NULL,NULL),(67,1,'Recruitment','Recruitment',NULL,NULL),(67,2,'Recrutement','Recrutement',NULL,NULL),(69,1,'Linguistic Auditing','Linguistic Auditing',NULL,NULL),(69,2,'Audit Linguistique','Audit Linguistique',NULL,NULL),(71,2,'Nos supports pédagogiques','Nos supports p&eacute;dagogiques',NULL,NULL),(72,1,'Our mixed formulas','Our mixed formulas',NULL,NULL),(72,2,'Nos formules mixtes','Nos formules mixtes',NULL,NULL),(73,1,'FORMA2 + all over France ','FORMA2 + all over France ',NULL,NULL),(73,2,'Forma2+ sur toute la France','Forma2+ sur toute la France',NULL,NULL),(74,1,'Presentation','Presentation',NULL,NULL),(74,2,'Présentation','Présentation',NULL,NULL),(77,1,'Pavé 2','Pavé Stagiaire',NULL,NULL),(76,1,'Pavé 1','Pavé RF',NULL,NULL),(76,2,'Pavé 1','Pavé RF',NULL,NULL),(77,2,'Pavé 2','Pavé Stagiaire',NULL,NULL),(78,1,'Pavé 3','Pavé Prof',NULL,NULL),(78,2,'Pavé 3','Pavé Prof',NULL,NULL),(79,1,'Pavé 4','Pavé DIF',NULL,NULL),(79,2,'Pavé 4','Pavé DIF',NULL,NULL),(80,1,'Slide1','Notre savoir faire',NULL,NULL),(80,2,'Slide1','Notre savoir faire',NULL,NULL),(81,1,'Slide2','Nos terrains d\'innovation',NULL,NULL),(81,2,'Slide2','Nos terrains d\'innovation',NULL,NULL),(82,1,'Slide3','Une démarche pédagogique innovante',NULL,NULL),(82,2,'Slide3','Une démarche pédagogique innovante',NULL,NULL),(83,1,'Slide4','Nos partenaires',NULL,NULL),(83,2,'Slide4','Nos partenaires',NULL,NULL),(85,1,'Accueil - Budget','Accueil - Budget',NULL,NULL),(85,2,'Accueil - Budget','Accueil - Budget',NULL,NULL),(86,1,'Accueil - Temps','Accueil - Temps',NULL,NULL),(86,2,'Accueil - Temps','Accueil - Temps',NULL,NULL),(87,1,'Accueil - Capacité','Accueil - Capacité',NULL,NULL),(87,2,'Accueil - Capacité','Accueil - Capacité',NULL,NULL),(88,1,'TOEIC and BULATS Preparation','Tailor-made',NULL,NULL),(88,2,'Préparation au TOEIC et au BULATS ','Préparation sur mesure au TOEIC et au BULATS ',NULL,NULL),(89,1,'','',NULL,NULL),(89,2,'','',NULL,NULL),(90,1,'Personal data','Personal data',NULL,NULL),(90,2,'Donn&eacute;es personnelles','Données personnelles',NULL,NULL),(91,1,'Legal Notice','Legal Notice',NULL,NULL),(91,2,'Mentions l&eacute;gales','Mentions l&eacute;gales',NULL,NULL);


