-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : sam. 06 déc. 2025 à 11:55
-- Version du serveur : 11.4.9-MariaDB
-- Version de PHP : 8.3.27

START TRANSACTION;



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

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

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

CREATE TABLE `articles` (
  `id_art` int(11) NOT NULL,
  `titre_art` text NOT NULL,
  `description_art` longtext NOT NULL,
  `image_min_art` text NOT NULL,
  `image_max_art` text NOT NULL,
  `resume_art` text DEFAULT NULL,
  `meta_data_art` text DEFAULT NULL,
  `statut_art` enum('0','1','2') NOT NULL DEFAULT '1',
  `vedette_art` int(11) NOT NULL DEFAULT 10,
  `id_cat` int(11) NOT NULL,
  `code_art` varchar(50) NOT NULL,
  `dossier_art` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `tag_art` text DEFAULT NULL,
  `vue` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `articles`
--

INSERT INTO `articles` (`id_art`, `titre_art`, `description_art`, `image_min_art`, `image_max_art`, `resume_art`, `meta_data_art`, `statut_art`, `vedette_art`, `id_cat`, `code_art`, `dossier_art`, `user_id`, `created_at`, `tag_art`, `vue`) VALUES
(10, 'Test de loterie', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.</p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.\n\nLorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.\n\nLorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.', 'actualites/oeuvres_sociales/test_de_loterie_1681337880/P1681337880.png', 'actualites/oeuvres_sociales/test_de_loterie_1681337880/G1681337880.jpeg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.', '1', 1, 20, 'S6Bukm8zFq', 'actualites/oeuvres_sociales/test_de_loterie_1681337880/', 20, '2023-04-12 22:18:00', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Harum ullam facilis, voluptatem vero eos blanditiis ab tenetur quod facere voluptas quia repudiandae dicta officia eaque. Quas et expedita quaerat ducimus.', 0);

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

--
-- Structure de la table `breaking_new`
--

CREATE TABLE `breaking_new` (
  `id_break` int(11) NOT NULL,
  `libelle_break` varchar(255) NOT NULL,
  `statut` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `breaking_new`
--

INSERT INTO `breaking_new` (`id_break`, `libelle_break`, `statut`, `created_at`, `user_id`) VALUES
(1, 'N’Zerekore : Deux jeunes homosexuels échappent de justesse', '1', '2021-05-03 00:06:56', 1),
(2, 'Kissidougou : la tension monte entre la mairie et les bouchers', '1', '2021-05-03 00:07:38', 0),
(4, 'Lélouma : la direction locale de l’élevage comme un établissement pour retraités', '1', '2021-05-03 10:18:14', 1);

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

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

CREATE TABLE `categories` (
  `id_cat` int(11) NOT NULL,
  `code_cat` varchar(255) NOT NULL,
  `libelle_cat` varchar(255) NOT NULL,
  `description_cat` text DEFAULT NULL,
  `dossier` text NOT NULL,
  `statut_cat` enum('0','1','2') NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `categories`
--

INSERT INTO `categories` (`id_cat`, `code_cat`, `libelle_cat`, `description_cat`, `dossier`, `statut_cat`, `created_at`) VALUES
(16, '9wuoZk0MPe', 'Emplois', 'LES EMPLOIS', 'actualites/emploi', '1', '2022-10-27 09:32:43'),
(17, 'OxggtWNfd0', 'PME', 'LES PME', 'actualites/pme', '1', '2022-10-27 09:36:45'),
(18, 'GrZgTL3Ep5', 'COMMUNIQUÉ', 'LES COMMUNIQUÉES', 'actualites/communiquee', '1', '2022-10-27 09:37:27'),
(19, 'GLxMuBiDOn', 'INTERNET', 'L\'INTERNET', 'actualites/internet', '1', '2022-10-27 09:38:27'),
(20, 'j1HCC9r1MI', 'Oeuvres Sociales', 'Les Œuvres Sociales', 'actualites/oeuvres_sociales', '1', '2022-10-27 15:03:12'),
(22, 'cjxRUtkHIY', 'Gros Lots', 'Gros Lots', 'actualites/gros_lots', '1', '2022-11-11 22:23:32');

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

--
-- Structure de la table `connexions`
--

CREATE TABLE `connexions` (
  `id_con` int(11) NOT NULL,
  `id_use` int(11) NOT NULL,
  `code_con` varchar(255) NOT NULL,
  `date_con` datetime NOT NULL DEFAULT current_timestamp(),
  `date_decon` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `connexions`
--

INSERT INTO `connexions` (`id_con`, `id_use`, `code_con`, `date_con`, `date_decon`) VALUES
(1, 2, 'z4OxCtGTaW', '2021-06-25 12:59:44', NULL),
(2, 2, 'qmSwDZQHez', '2021-06-25 16:23:12', NULL),
(3, 2, 's62Yjebkdm', '2022-09-28 10:49:26', NULL),
(4, 2, 'vymXQw0dPl', '2022-09-24 20:39:06', NULL),
(5, 2, 'AEGSnjFXCM', '2022-10-05 09:30:19', NULL),
(6, 2, '4Oj8kPyFWp', '2022-10-05 11:36:31', NULL),
(7, 2, 'PuOnHLf0P5', '2022-10-07 10:02:41', NULL),
(8, 2, 'LCVtiev1dX', '2022-09-24 20:48:33', NULL),
(9, 2, 'acyaoePIlT', '2022-10-11 11:57:33', NULL),
(10, 2, '6ra2eehM8X', '2022-10-21 10:03:17', NULL),
(11, 2, 'qzXtpgSY5O', '2022-10-21 16:26:12', NULL),
(12, 2, 'TD33tAQmpf', '2022-10-27 10:54:45', NULL),
(13, 2, 'W53BUvVt4P', '2022-10-27 15:32:50', NULL),
(14, 2, 'J5W4rBZP6A', '2022-10-28 10:11:25', NULL),
(15, 2, 'M05utn5cO3', '2022-10-28 10:15:51', NULL),
(16, 2, 'HtZgJImdw1', '2022-10-28 12:15:44', NULL),
(17, 2, '1HtWpQ0CvZ', '2022-10-28 13:10:36', NULL),
(18, 4, 'HkSCPdgoW5', '2022-10-28 15:48:20', NULL),
(19, 2, 'W0fmHmBF2V', '2022-11-01 09:38:07', NULL),
(20, 2, 'nt0Klguyj1', '2022-11-01 09:56:42', NULL),
(21, 3, 'g62JiNy2u8', '2022-11-01 10:13:19', NULL),
(22, 3, 'oRoC5kjwsh', '2022-11-01 10:16:50', NULL),
(23, 3, 'OA3nTQTpdf', '2022-11-01 12:18:35', NULL),
(24, 3, 'GvtNEr6C5c', '2022-11-01 12:29:22', NULL),
(25, 3, 'AhB3gbqKQ6', '2022-11-01 14:42:23', NULL),
(26, 3, 'gLOCBXNiO1', '2022-11-01 14:53:14', NULL),
(27, 3, '5wbwu2HdFx', '2022-11-02 09:18:18', NULL),
(28, 18, 'KWowtE3BRa', '2022-11-03 10:32:47', NULL),
(29, 2, 'uDp0I0h8dJ', '2022-11-03 10:33:14', NULL),
(30, 2, 'Tb7httXFC3', '2022-11-03 15:37:43', NULL),
(31, 18, '5ArBzn3UsS', '2022-11-03 15:37:57', NULL),
(32, 2, 'io6ILcW4w7', '2022-11-03 15:43:15', NULL),
(33, 18, 'ChAUmcExJZ', '2022-11-03 15:45:49', NULL),
(34, 3, 'LNfGxUMK76', '2022-11-03 15:45:50', NULL),
(35, 18, 'hOwCfgPnJh', '2022-11-03 15:47:28', NULL),
(36, 3, '9t9OK50ALS', '2022-11-03 15:48:01', NULL),
(37, 3, 'THJZ0DJbeX', '2022-11-04 08:50:04', NULL),
(38, 3, 'BDchuyrNp9', '2022-11-07 10:34:00', NULL),
(39, 2, '7ncfOIoAiY', '2022-11-08 09:56:14', NULL),
(40, 2, 'MH93ppuElI', '2022-11-11 09:23:20', NULL),
(41, 2, 'DItoJ80Y9c', '2022-11-11 14:55:30', NULL),
(42, 18, 'FiLvDTxSa5', '2022-11-22 08:37:45', NULL),
(43, 20, 'mytKUkCMSL', '2022-11-22 08:42:57', NULL),
(44, 20, '0HmYP36TGC', '2022-11-22 09:49:29', NULL),
(45, 20, 'AuHXR26isg', '2022-11-22 09:49:30', NULL),
(46, 20, 'wFjGL82hwF', '2022-11-22 23:31:50', NULL),
(47, 20, 't8AsmUAGld', '2022-11-22 23:31:50', NULL),
(48, 20, 'n46jeyE6vU', '2022-12-11 18:12:18', NULL),
(49, 20, 'KfcszCf863', '2022-12-11 19:37:30', NULL),
(50, 20, '56USCFgDtt', '2023-04-12 21:32:27', NULL),
(51, 20, 'WR9x8ro8Wg', '2023-08-06 22:14:27', NULL),
(52, 20, 'eOnTvCmqqn', '2023-08-06 23:05:32', NULL),
(53, 20, '3cauGlavL2', '2023-08-21 13:15:04', NULL),
(54, 20, 'JhvCblZIqN', '2023-08-21 14:15:37', NULL);

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

--
-- Structure de la table `contacts`
--

CREATE TABLE `contacts` (
  `id_con` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `email` varchar(255) NOT NULL,
  `telephone` varchar(255) NOT NULL,
  `sujet` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `lu` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Déchargement des données de la table `contacts`
--

INSERT INTO `contacts` (`id_con`, `name`, `email`, `telephone`, `sujet`, `message`, `created_at`, `lu`) VALUES
(1, 'Fidelbb', 'fedler.fidel7@msn.com', '', '', 'Want to instantly tap into\r\nViper to leverage...\r\n\r\n... The World\'s First \"200-In-1\" Free Buyer Traffic App:)\r\n\r\nThis latest from Billy Darr\r\nshows you exactly how\r\n\r\n >> https://automatedtiktoktraffic.blogspot.com/\r\n\r\nOnce you see the potential \r\nwith this, you\'ll want to\r\nscale this even more\r\n\r\nGrab this for 17 bux\r\n\r\n… but act fast because\r\nprice increases with\r\neach sale\r\n\r\n>>> https://automatedtiktoktraffic.blogspot.com/\r\n\r\n\r\n\r\nAutomated TikTok Traffic\r\n\r\nP.S. For the first 35 people \r\nwho grab this today you\'ll get \r\n>>> https://automatedtiktoktraffic.blogspot.com/\r\n\r\n\r\n.\r\n..\r\n..\r\n..\r\n.\r\n..\r\n..\r\n..\r\n.\r\n.\r\n.\r\n..\r\n...\r\n...\r\n..\r\n.\r\n.\r\nUnsuscribe Here =>> https://forms.gle/xUyfSkc355Fmmkf3A', '2021-06-20 01:01:32', '1'),
(2, 'Rod', 'rod.benner@gmail.com', '', '', 'Hi , \r\n\r\nI don’t need to tell you how important it is to optimize every step in your SEO pipeline. \r\n\r\nBut unfortunately, it’s nearly impossible to cut out time or money when it comes to getting good content.\r\n\r\nAt least that’s what I thought until I came across Article Forge...\r\n\r\nBuilt by a team of AI researchers from MIT, Carnegie Mellon, Harvard, Article Forge is an artificial intelligence (AI) powered content writer that uses deep learning models to write entire articles about any topic in less than 60 seconds.\r\n\r\nTheir team trained AI models on millions of articles to teach Article Forge how to draw connections between topics so that each article it writes is relevant, interesting and useful.\r\n\r\nAll their hard work means you just enter a few keywords and Article Forge will write a complete article from scratch making sure every thought flows naturally into the next, resulting in readable, high quality, and unique content.\r\n\r\nPut simply, this is a secret weapon for anyone who needs content.\r\n\r\nI get how impossible that sounds so you need to see how Article Forge writes a complete article in less than 60 seconds! ==>> https://www.articleforge.com/?ref=4a6c79\r\nI had to share this with you because I know this will be a game changer for your business.\r\n\r\nIf you’re writing your own content, Article Forge can take a long and difficult process and turn it into a single button click. \r\n\r\nIf you’re buying content, Article Forge’s flat fee, unlimited articles, and 60 second turnaround will be cheaper and faster than any other content provider. \r\n\r\nEither way, Article Forge will help you take your content creation process to the next level.\r\n\r\nMore importantly, Article Forge offers a free 5-day trial so you can see for yourself how this technology will revolutionize your content pipeline for your niche and your use case. \r\n\r\nSo what are you waiting for? Click here to get your 5-day Free Trial and start generating unlimited unique content ==>> https://www.articleforge.com/?ref=4a6c79\r\n\r\nAnd make sure to thank me later when this tool has changed the way you create content :)\r\n\r\n[Brahma]\r\n', '2021-07-02 15:39:04', '0'),
(3, 'Denise', 'heinig.denise@msn.com', '', '', 'Hello\r\n\r\nOur Medical-Grade Toenail Clippers is the safest and especially recommended for those with troubles with winding nails, hard nails, two nails, nail cracks, deep nails, thickened nails etc..\r\n\r\nGet yours: thepodiatrist.online\r\n\r\nTo your success,\r\n\r\nDenise\r\nUnion des consommateurs de Guinée', '2021-07-30 11:52:16', '0'),
(4, 'Eric', 'eric.jones.z.mail@gmail.com', '', '', 'Cool website!\r\n\r\nMy name’s Eric, and I just found your site - leconsommateurguineen.com - while surfing the net. You showed up at the top of the search results, so I checked you out. Looks like what you’re doing is pretty cool.\r\n \r\nBut if you don’t mind me asking – after someone like me stumbles across leconsommateurguineen.com, what usually happens?\r\n\r\nIs your site generating leads for your business? \r\n \r\nI’m guessing some, but I also bet you’d like more… studies show that 7 out 10 who land on a site wind up leaving without a trace.\r\n\r\nNot good.\r\n\r\nHere’s a thought – what if there was an easy way for every visitor to “raise their handâ€ to get a phone call from you INSTANTLY… the second they hit your site and said, “call me now.â€\r\n\r\nYou can –\r\n  \r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  It lets you know IMMEDIATELY – so that you can talk to that lead while they’re literally looking over your site.\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to try out a Live Demo with Talk With Web Visitor now to see exactly how it works.\r\n\r\nTime is money when it comes to connecting with leads – the difference between contacting someone within 5 minutes versus 30 minutes later can be huge – like 100 times better!\r\n\r\nThat’s why we built out our new SMS Text With Lead feature… because once you’ve captured the visitor’s phone number, you can automatically start a text message (SMS) conversation.\r\n  \r\nThink about the possibilities – even if you don’t close a deal then and there, you can follow up with text messages for new offers, content links, even just “how you doing?â€ notes to build a relationship.\r\n\r\nWouldn’t that be cool?\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to discover what Talk With Web Visitor can do for your business.\r\n\r\nYou could be converting up to 100X more leads today!\r\nEric\r\n\r\nPS: Talk With Web Visitor offers a FREE 14 days trial – and it even includes International Long Distance Calling. \r\nYou have customers waiting to talk with you right now… don’t keep them waiting. \r\nCLICK HERE https://talkwithwebvisitors.com to try Talk With Web Visitor now.\r\n\r\nIf you\'d like to unsubscribe click here http://talkwithwebvisitors.com/unsubscribe.aspx?d=leconsommateurguineen.com\r\n', '2021-08-11 18:28:35', '0'),
(5, 'Christine', 'bernier.christine6@yahoo.com', '', '', 'Hi,\r\n\r\nA lot of people who try to sell anything online simply are not doing a good job of it.\r\n\r\nThis is the main reason why the vast majority of people trying to sell affiliate products simply can\'t make a living off their online marketing.\r\n\r\nIt\'s not because these people are dumb. It\'s not because they are incapable of making money online.\r\n\r\nI hate to break it to you, but the whole idea of “build it and they will comeâ€ is just a pipe dream.  \r\n \r\nIt may have worked 10 years ago. But believe me. It doesn\'t work today.\r\n\r\nClick the link below now to learn the latest sales funnel optimization strategies!\r\n\r\n>>> https://brahma.kartra.com/page/qLb26\r\n\r\nMake it a great day!\r\n\r\nBrahma\r\n\r\n\r\n.\r\n..\r\n..\r\n..\r\n.\r\n..\r\n..\r\n..\r\n.\r\n.\r\n.\r\n..\r\n...\r\n...\r\n..\r\n.\r\n.\r\nUnsuscribe Here =>> https://forms.gle/xUyfSkc355Fmmkf3A', '2021-08-16 15:43:14', '0'),
(6, 'Ruben', 'macias.ruben@googlemail.com', '', '', 'JOIN OUR COMMUNITY OF 69937 PUBLISHERS\r\n\r\nThe Moneytizer maximizes your website\'s advertising revenue. Our Header Bidding technology allows the world\'s largest advertisers to compete for each of your ad spaces. Always get the best CPM with The Moneytizer!\r\n\r\n=>> https://moneytizer-ads.blogspot.com/\r\n\r\n\r\n.\r\n..\r\n..\r\n..\r\n.\r\n..\r\n..\r\n..\r\n.\r\n.\r\n.\r\n..\r\n...\r\n...\r\n..\r\n.\r\n.\r\nUnsuscribe Here =>> https://forms.gle/xUyfSkc355Fmmkf3A', '2021-08-23 13:02:13', '0'),
(7, 'Kathi', 'anton.kathi@gmail.com', '', '', 'Color-changing swimshorts \r\n\r\nDive into the ocean and your swimshorts suddenly change color! These swimshorts ara AMAZING!\r\n\r\nHurry! 50% Off Worldwide For Limited Time Only!\r\n\r\nGet it here: coolshorts.online\r\n\r\nAll the best, \r\n\r\nKathi', '2021-09-06 16:34:12', '0'),
(8, 'Cathern', 'cathern.evergood@yahoo.com', '', '', 'Hello, Union des consommateurs de Guinée!\r\n\r\nWe offer effective organic SEO services for different types of web resources.\r\n\r\nOrganic SEO is a great marketing strategy to gain top 10 Google, especially for the small business websites.\r\n\r\nWith a small investment, you get a permanent customers flow and noticeable increasing of profits.\r\n\r\nThere is no other methods  with such ROI! Try Organic SEO with our experienced SEO experts.\r\n\r\nYou can choose from our standard plans or request a custom SEO plan that will be tailored specifically for your website.\r\n\r\nThe effects of our Organic SEO efforts usually appear within 30 days after we start to work with client\'s site.\r\n\r\nYou can verify this by starting with our SEO plan for £49 - no need to risk.\r\n\r\nOrganic SEO, website optimization for search engines, keyword selection, link building, local SEO, UI/UX optimization, SEO audits, free online SEO advices\r\n\r\nWe work with the sites on any European language\r\n\r\nPlease, follow this link for details: https://www.shrunken.com/organicseoukforecommerce29088  \r\n\r\nThanks for your attention, and we are sorry if you are not interested in this offer', '2021-09-13 04:33:42', '0'),
(9, 'Eric', 'eric.jones.z.mail@gmail.com', '', '', 'Cool website!\r\n\r\nMy name’s Eric, and I just found your site - leconsommateurguineen.com - while surfing the net. You showed up at the top of the search results, so I checked you out. Looks like what you’re doing is pretty cool.\r\n \r\nBut if you don’t mind me asking – after someone like me stumbles across leconsommateurguineen.com, what usually happens?\r\n\r\nIs your site generating leads for your business? \r\n \r\nI’m guessing some, but I also bet you’d like more… studies show that 7 out 10 who land on a site wind up leaving without a trace.\r\n\r\nNot good.\r\n\r\nHere’s a thought – what if there was an easy way for every visitor to “raise their handâ€ to get a phone call from you INSTANTLY… the second they hit your site and said, “call me now.â€\r\n\r\nYou can –\r\n  \r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  It lets you know IMMEDIATELY – so that you can talk to that lead while they’re literally looking over your site.\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to try out a Live Demo with Talk With Web Visitor now to see exactly how it works.\r\n\r\nTime is money when it comes to connecting with leads – the difference between contacting someone within 5 minutes versus 30 minutes later can be huge – like 100 times better!\r\n\r\nThat’s why we built out our new SMS Text With Lead feature… because once you’ve captured the visitor’s phone number, you can automatically start a text message (SMS) conversation.\r\n  \r\nThink about the possibilities – even if you don’t close a deal then and there, you can follow up with text messages for new offers, content links, even just “how you doing?â€ notes to build a relationship.\r\n\r\nWouldn’t that be cool?\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to discover what Talk With Web Visitor can do for your business.\r\n\r\nYou could be converting up to 100X more leads today!\r\nEric\r\n\r\nPS: Talk With Web Visitor offers a FREE 14 days trial – and it even includes International Long Distance Calling. \r\nYou have customers waiting to talk with you right now… don’t keep them waiting. \r\nCLICK HERE https://talkwithwebvisitors.com to try Talk With Web Visitor now.\r\n\r\nIf you\'d like to unsubscribe click here http://talkwithwebvisitors.com/unsubscribe.aspx?d=leconsommateurguineen.com\r\n', '2021-10-21 08:52:30', '0'),
(10, 'Aaliyah', 'info@leconsommateurguineen.com', '', '', 'Hey there\r\n\r\nOur Medical-Grade Toenail Clippers is the safest and especially recommended for those with troubles with winding nails, hard nails, two nails, nail cracks, deep nails, thickened nails etc..\r\n\r\nGet yours: thepodiatrist.store\r\n\r\nCheers,\r\n\r\nAaliyah', '2021-10-24 13:01:08', '0'),
(11, 'Manie', 'sommer.manie@gmail.com', '', '', 'New Multifunction Anti-theft Waterproof Sling Bag\r\n\r\nThe best ever SUPER Sling Bag: Drop-proof/Anti-theft/Scratch-resistant/USB Charging\r\n\r\n50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time\r\n\r\nBuy now: fashiondaily.online\r\n\r\nTo your success, \r\n\r\nManie\r\nUnion des consommateurs de Guinée', '2021-11-03 18:53:48', '0'),
(12, 'Natehalpag', 'DianazeW1968@xd.dogle.info', '', '', 'Между нами говорÑ, рекомендую поиÑкать ответ на Ваш вопроÑ в google.com\r\n здеÑь вы обнаружите <a href=https://tehnoreiting.ru/>tehnoreiting.ru</a>,обзоры, гайды по покупке и многое другое.', '2021-11-06 09:52:10', '0'),
(13, 'Morgan', 'info@fotoplezier.be', '', '', 'Good day \r\n\r\nDo you have time to brush your dog\'s teeth every day?\r\n\r\nLet your dog clean his own teeth with our dog dental care brushing stick. Made of eco-friendly natural rubber, this toothbrush is sturdy. The soft design is safe for your dogs\' gums and helps to clean their teeth and protect them from oral diseases and dental decay. \r\n\r\nAct Now And Receive A Special Discount!\r\n\r\nClick here: https://dogcare.center\r\n\r\nEnjoy, \r\n \r\nMorgan', '2021-11-10 15:26:36', '0'),
(14, 'Genia', 'bracewell.genia@gmail.com', '', '', 'We always struggled to pack before a trip. What to bring, how many or how much of it, etc...\r\nSo we have created this Foldable Travel Bag. It\'s Just So Versatile!\r\n\r\n. Easy to Fold and Unfold\r\n. Large Storage Space\r\n. Portable + Waterproof\r\n\r\n60% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time!\r\n\r\nBuy now: https://ifashiononline.shop\r\n\r\nRegards,\r\n\r\nGenia', '2021-12-04 19:38:16', '0'),
(15, 'Loyd', 'massina.loyd@gmail.com', '', '', 'Hi , \r\n\r\nI don’t need to tell you how important it is to optimize every step in your SEO pipeline. \r\n\r\nBut unfortunately, it’s nearly impossible to cut out time or money when it comes to getting good content.\r\n\r\nAt least that’s what I thought until I came across Article Forge...\r\n\r\nBuilt by a team of AI researchers from MIT, Carnegie Mellon, Harvard, Article Forge is an artificial intelligence (AI) powered content writer that uses deep learning models to write entire articles about any topic in less than 60 seconds.\r\n\r\nTheir team trained AI models on millions of articles to teach Article Forge how to draw connections between topics so that each article it writes is relevant, interesting and useful.\r\n\r\nAll their hard work means you just enter a few keywords and Article Forge will write a complete article from scratch making sure every thought flows naturally into the next, resulting in readable, high quality, and unique content.\r\n\r\nPut simply, this is a secret weapon for anyone who needs content.\r\n\r\nI get how impossible that sounds so you need to see how Article Forge writes a complete article in less than 60 seconds! =>> https://myarticleforge.blogspot.com/\r\n\r\nI had to share this with you because I know this will be a game changer for your business.\r\n\r\nIf you’re writing your own content, Article Forge can take a long and difficult process and turn it into a single button click. \r\n\r\nIf you’re buying content, Article Forge’s flat fee, unlimited articles, and 60 second turnaround will be cheaper and faster than any other content provider. \r\n\r\nEither way, Article Forge will help you take your content creation process to the next level.\r\n\r\nMore importantly, Article Forge offers a free 5-day trial so you can see for yourself how this technology will revolutionize your content pipeline for your niche and your use case. \r\n\r\nSo what are you waiting for? Click here to get your 5-day Free Trial and start generating unlimited unique content =>> https://myarticleforge.blogspot.com/\r\n\r\nAnd make sure to thank me later when this tool has changed the way you create content :)\r\n\r\nBrahma.', '2021-12-20 06:46:13', '0'),
(16, 'Ouida', 'hinkler.ouida@gmail.com', '', '', 'Hi \r\n \r\nPawSafer™ CAN SAFELY TRIM YOUR DOG\'S NAILS IN NO TIME FROM HOME.\r\n\r\nGet it while it\'s still 50% OFF + FREE Shipping\r\n\r\nBuy here: https://pawsafer.shop\r\n \r\nEnjoy, \r\n \r\nOuida', '2022-01-12 20:49:40', '0'),
(17, 'Shelly', 'shelly.zakrzewski@googlemail.com', '', '', 'New Multifunction Anti-theft Waterproof Sling Bag\r\n\r\nThe best ever SUPER Sling Bag: Drop-proof/Anti-theft/Scratch-resistant/USB Charging\r\n\r\n50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time\r\n\r\nBuy now: fashiondaily.online\r\n\r\nBest Wishes, \r\n\r\nShelly\r\nUnion des consommateurs de Guinée', '2022-02-21 23:16:16', '0'),
(18, 'Susana', 'susana.ogilvy@gmail.com', '', '', 'Hi!\r\n\r\nIn just a few hours from now, Tuberank Jeet 4 will be available for purchase. \r\n\r\n=>> https://tuberankjeet4.bizoppsguide.com?traffic_source=cf&cost=0.0\r\n\r\nThis the new and the most powerful version of Tuberank Jeet, the world’s most popular \r\nYouTube traffic and in this release they’ve added some really killer features.\r\n\r\n                                \r\n\r\n                                \r\nRank better on YouTube for traffic getting keywords and also appear on the sidebars of \r\n\r\nother videos in the same niche.\r\n\r\n                                \r\nGet a boost in YouTube traffic in the next 2 days and keep that growth for any time \r\n\r\nperiod you want.\r\n\r\n                                \r\nOptimize your YouTube videos with perfection without having to spend weeks and weeks \r\n\r\nlearning video SEO.\r\n \r\n=>> https://tuberankjeet4.bizoppsguide.com?traffic_source=cf&cost=0.0\r\n                                \r\nGenerate explosive amounts of subscribers and build a list easier driving customers to \r\n\r\nyour offers by tapping into keywords that no one is exploiting.\r\n\r\n                                \r\nIncluded YouTube marketing training gives you all their secret YouTube marketing \r\n\r\nstrategies.\r\n\r\n                                \r\nDiscover golden keywords with massive traffic and reach but with lower competition. \r\n\r\nBlow your competition away!\r\n\r\n                                \r\nStart today and build channels with thousands of visitors and even more without \r\n\r\nbreaking your back with hard work.\r\n\r\n                                \r\nBuild a powerful list even if you don’t have a product with video traffic.\r\n\r\n                                \r\nUse your competition’s videos to get ahead by tapping into their traffic and driving their \r\n\r\nvisitors to yourself.\r\n\r\n                                    \r\n\r\n\r\nIt’s the world’s most popular YouTube rankings and traffic software used by thousands of video \r\nmarketers. When you get it, you get the most robust and the most proven system available \r\nanywhere.\r\n                                \r\nThe best thing is, it’s ridiculously easy to use, and yet all the info is right at your fingertips. No \r\ncomplex charts to analyze or algorithms to crack. Tuberank Jeet gives you everything \r\nstep-by-step and takes the complexity out of rankings.\r\n\r\nIn fact, it actually tells you exactly what you need to do to rank big. No mystery there.\r\n\r\nFrankly, if you’re going to have just one tool for YouTube in 2019, this better be it.\r\n\r\nCheck out the demo and you’ll agree with me.\r\n\r\nWanna bet? Here’s the link.\r\n\r\n=>> https://tuberankjeet4.bizoppsguide.com?traffic_source=cf&cost=0.0\r\n\r\nCheers!\r\nBrahma', '2022-02-25 02:27:06', '0'),
(19, 'Benedict', 'benedict.whitington@gmail.com', '', '', 'Hey,\r\n\r\nHave you ever heard of Deep Learning and AI?\r\n\r\nCombined Deep Learning and AI included in SPD technology is the pinnacle of the natural voice generation breakthrough.\r\n\r\nThis is why now you too can generate stunning human-like speech in all major languages to keep viewers glued to the screen.\r\n\r\n=>> https://getspeechdio.blogspot.com\r\n\r\nNew groundbreaking app uses SPD tech to voice-over your scripts in a ton of voices and a lot of languages & dialects .\r\n\r\nAll it takes are just 3 steps:\r\n\r\nStep 1: Select a language and voice you want to use\r\n\r\nStep 2: Paste your text\r\n\r\nStep 3: Click the create button\r\n\r\nThat’s it – those 3 steps will have you creating your next amazing voice-over in seconds.\r\n\r\n\r\nWatch quick explainer video now\r\n=>> https://getspeechdio.blogspot.com\r\n\r\n', '2022-03-12 14:07:13', '0'),
(20, 'Fawn', 'fawn.noe@outlook.com', '', '', 'Hi,\r\n\r\nWould you believe me if I told you that you can get paid to speak without using your voice? It\'s true! \r\n\r\nYou could be making $50 for every audio file you upload...\r\n\r\nAll it takes is 3 steps...\r\n\r\nStep 1: Create Your Account\r\nCreate your account here\r\n\r\nStep 2: Pick Your Favourite Artist\r\nSelect from thousands of artists and vibe to the music\r\n\r\nStep 3: Get Paid\r\nThat\'s it, for every song you steam...\r\n\r\n=> Click here right now to start instantly\r\n=> https://freespoticash.blogspot.com/\r\n\r\nSincerely,', '2022-04-05 09:22:08', '0'),
(21, 'Monica', 'liz@lizpellegrinlaw.com', '', '', 'World\'s Best Neck Massager Get it Now 50% OFF + Free Shipping!\r\n\r\nWellness Enthusiasts! There has never been a better time to take care of your neck pain! \r\n\r\nOur clinical-grade TENS technology will ensure you have neck relief in as little as 20 minutes.\r\n\r\nGet Yours: https://hineck.online\r\n\r\nSincerely,\r\n\r\nMonica\r\nUnion des consommateurs de Guinée', '2022-04-27 16:37:47', '0'),
(22, 'Karolyn', 'fejeranbooks@gmail.com', '', '', 'Hey \r\n\r\nDon\'t you hate carrying a big bulky backpack when you are only going out for the day? This high quality shoulder bag solves that problem. \r\nCarry enough without bogging yourself down! Perfect for that fishing trip or day hike!\r\n\r\n50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time\r\n\r\nBuy now: https://fashionbag.sale\r\n\r\nThe Best, \r\n\r\nKarolyn', '2022-05-01 13:44:03', '0'),
(23, 'Phyllis', 'info@riversummitgroup.com', '', '', 'Hello there, \r\n\r\nI hope you\'re doing well. I wanted to let you know about our new BANGE backpacks and sling bags that just released.\r\n\r\nThe bags are waterproof and anti-theft, and have a built-in USB cable that can recharge your phone while you\'re on the go.\r\n\r\nBoth bags are made of durable and high-quality materials, and are perfect for everyday use or travel.\r\n\r\nOrder yours now at 50% OFF with FREE Shipping: https://bangeonline.shop\r\n\r\nKind Regards,\r\n\r\nPhyllis', '2022-05-13 14:51:38', '0'),
(24, 'Janet', 'info@globus-co.com', '', '', 'Hey there \r\n\r\nI wanted to reach out and let you know about our new dog harness. It\'s really easy to put on and take off - in just 2 seconds - and it\'s personalized for each dog. \r\nPlus, we offer a lifetime warranty so you can be sure your pet is always safe and stylish.\r\n\r\nWe\'ve had a lot of success with it so far and I think your dog would love it. \r\n\r\nGet yours today with 50% OFF: https://caredogbest.com\r\n\r\nFREE Shipping - TODAY ONLY! \r\n\r\nBest regards, \r\n\r\nJanet', '2022-05-16 19:46:11', '0'),
(25, 'Akilah', 'educate@blackbeautyexpo.com', '', '', 'Hey \r\n\r\nI understand that you are looking for ways to improve your posture and contribute to a healthy lifestyle. I think our product, Medico Postura™ Body Posture Corrector, can be of great help.\r\n\r\nMedico Postura™ helps improve your posture INSTANTLY. It is an easy-to-use device that you can wear at home, work, or even when you are sleeping.\r\n\r\nIt is made of lightweight and breathable fabric, making it comfortable to wear all day long.\r\n\r\nGet it today while it\'s still 60% OFF: https://medicopostura.com   \r\n\r\nFREE Shipping - TODAY ONLY!\r\n\r\nAll the best, \r\n\r\nAkilah', '2022-05-21 17:36:58', '0'),
(26, 'Jasmine', 'properties@petrelliteam.com', '', '', 'New Multifunction Anti-theft Waterproof Sling Bag\r\n\r\nThe best ever SUPER Sling Bag: Drop-proof/Anti-theft/Scratch-resistant/USB Charging\r\n\r\n50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time\r\n\r\nBuy now: https://fashiondaily.shop\r\n\r\nTo your success, \r\n\r\nJasmine\r\nUnion des consommateurs de Guinée', '2022-06-12 17:14:24', '0'),
(27, 'Hayley Coffey', 'zifeho@mailinator.com', '666525250', '', 'Laboriosam sit lab', '2022-09-24 16:18:21', '0'),
(28, 'Alma Mcbride', 'piwujibyre@mailinator.com', '6213568589', '', 'Un message', '2022-10-07 15:41:49', '0'),
(29, 'Shad Nunez', 'culeqos@mailinator.com', '66666223366', 'Deserunt fugiat odit', 'Asperiores dolor num', '2022-10-26 12:07:22', '1'),
(30, 'Wallace Cabrera', 'cecode@mailinator.com', '123456', 'Id cupidatat quia co', 'Velit quis elit del', '2022-11-07 11:23:30', '1');

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

--
-- Structure de la table `gallery`
--

CREATE TABLE `gallery` (
  `id_image` int(11) NOT NULL,
  `name_image` varchar(255) NOT NULL,
  `dossier_image` varchar(255) NOT NULL,
  `description_image` text DEFAULT NULL,
  `size_image` varchar(255) NOT NULL,
  `statut_image` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `gallery`
--

INSERT INTO `gallery` (`id_image`, `name_image`, `dossier_image`, `description_image`, `size_image`, `statut_image`, `created_at`, `user_id`) VALUES
(7, 'slider-02.jpg', 'images/galleries/gallerie1668695564.jpg', 'Minim in veniam rep', '880667', '0', '2022-11-17 14:32:44', 2),
(9, 'g2.jpg', 'images/galleries/gallerie1668697450.jpg', 'Recusandae Reprehen', '536812', '1', '2022-11-17 15:04:10', 2),
(10, 'g1.jpg', 'images/galleries/gallerie1668697473.jpg', 'Rerum nemo laboris i', '63342', '1', '2022-11-17 15:04:33', 2),
(11, 'gallery-img-04.jpg', 'images/galleries/gallerie1668698172.jpg', 'Aut repudiandae qui ', '385827', '1', '2022-11-17 15:16:12', 2),
(12, 'gallery-img-05.jpg', 'images/galleries/gallerie1668698182.jpg', 'Ex aperiam dolor qui', '315432', '1', '2022-11-17 15:16:22', 2),
(13, 'gallery-img-06.jpg', 'images/galleries/gallerie1668698219.jpg', 'Ut quo illo impedit', '228274', '1', '2022-11-17 15:16:59', 2),
(14, 'g5.jpg', 'images/galleries/gallerie1668698269.jpg', 'ccc', '75269', '1', '2022-11-17 15:17:49', 2),
(15, '2.jfif', 'images/galleries/gallerie1668761614.jfif', 'Delectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam u', '12655', '1', '2022-11-18 08:53:34', 2),
(16, 'IMG_9442.JPG', 'images/galleries/gallerie1670792184.JPG', 'les personnels de la société de Mota-Engil avec nos équipes  ', '177993', '1', '2022-12-11 21:56:24', 20),
(17, 'IMG_9439.JPG', 'images/galleries/gallerie1670792305.JPG', 'Equipe', '158612', '1', '2022-12-11 21:58:25', 20),
(19, 'galleri.jpg', 'images/galleries/gallerie1670793161.jpg', 'nos plats', '251656', '1', '2022-12-11 22:12:41', 20),
(20, 'IMG_9448.JPG', 'images/galleries/gallerie1670793332.JPG', 'fruits', '205328', '1', '2022-12-11 22:15:32', 20),
(21, 'IMG-20230724-WA0000.jpg', 'images/galleries/gallerie1691356650.jpg', '', '120431', '1', '2023-08-06 23:17:30', 20),
(22, 'Polish_20230731_150800265.jpg', 'images/galleries/gallerie1691356946.jpg', '', '420801', '1', '2023-08-06 23:22:26', 20),
(23, 'IMG-20230816-WA0008.jpg', 'images/galleries/gallerie1692616545.jpg', '', '168976', '1', '2023-08-21 13:15:45', 20),
(24, 'reduit.jpg', 'images/galleries/gallerie1692616793.jpg', '', '237222', '1', '2023-08-21 13:19:53', 20),
(25, 'REDUIT2.jpg', 'images/galleries/gallerie1692620171.jpg', '', '155938', '1', '2023-08-21 14:16:11', 20),
(26, 'REDUIT3.jpg', 'images/galleries/gallerie1692620368.jpg', '', '210227', '1', '2023-08-21 14:19:28', 20),
(27, 'REDUIT5.jpg', 'images/galleries/gallerie1692620587.jpg', '', '150602', '1', '2023-08-21 14:23:07', 20),
(28, 'Reduit6.jpg', 'images/galleries/gallerie1692620800.jpg', '', '183529', '1', '2023-08-21 14:26:40', 20),
(29, 'reduit8.jpg', 'images/galleries/gallerie1692622642.jpg', '', '144603', '1', '2023-08-21 14:57:22', 20),
(30, 'redui.jpg', 'images/galleries/gallerie1692624827.jpg', '', '243278', '1', '2023-08-21 15:33:47', 20);

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

--
-- Structure de la table `membres_equipe`
--

CREATE TABLE `membres_equipe` (
  `id_mem` int(11) NOT NULL,
  `prenom_mem` varchar(255) NOT NULL,
  `nom_mem` varchar(255) NOT NULL,
  `fonction_mem` varchar(255) NOT NULL,
  `email_mem` varchar(255) NOT NULL,
  `compte_facebook` text NOT NULL,
  `compte_twitter` text NOT NULL,
  `compte_instagram` text NOT NULL,
  `compte_google` text NOT NULL,
  `image_mem` varchar(255) DEFAULT NULL,
  `statut_mem` enum('0','1') NOT NULL DEFAULT '1',
  `user_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `membres_equipe`
--

INSERT INTO `membres_equipe` (`id_mem`, `prenom_mem`, `nom_mem`, `fonction_mem`, `email_mem`, `compte_facebook`, `compte_twitter`, `compte_instagram`, `compte_google`, `image_mem`, `statut_mem`, `user_id`, `created_at`) VALUES
(1, 'Ousmane', 'Barry', 'DG', 'contact@mailinator.com', 'facebook', 'Twitter', 'Instagram', 'Google', 'images/membres/1665154967.png', '1', 1, '2022-10-07 12:06:30'),
(2, 'Abdourahamane', 'Diallo', 'Responsable informatique', 'abdourahamane@gmail.com', 'http://facebook.com?p=Abdourahamane', 'http://twitter.com?p=Abdourahamane', 'http://instagram.com?p=Abdourahamane', 'http://google.com?p=Abdourahamane', 'images/membres/1665153939.jpg', '1', 1, '2022-10-07 14:45:39'),
(5, 'Amadou', 'Diallo', 'Co-fondateur', 'amadou@gmail.com', 'Amadou', 'Amadou', 'Amadou', 'Amadou', 'images/membres/1665154798.png', '1', 1, '2022-10-07 14:59:58'),
(6, 'Houssainatou', 'Ly', 'Chargée de communication digitale', 'husna12@gmail.com', 'husnaly', 'husnaly', 'husnaly', 'husnaly', 'images/membres/1665154915.png', '1', 1, '2022-10-07 15:01:55');

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

--
-- Structure de la table `newletters`
--

CREATE TABLE `newletters` (
  `id_newletter` int(11) NOT NULL,
  `nom_new` varchar(255) NOT NULL,
  `email_new` varchar(255) NOT NULL,
  `statut_new` enum('0','1') NOT NULL DEFAULT '1',
  `created_at_new` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `newletters`
--

INSERT INTO `newletters` (`id_newletter`, `nom_new`, `email_new`, `statut_new`, `created_at_new`) VALUES
(1, '', 'jifeb@mailinator.com', '1', '2022-10-26 13:12:12'),
(2, '', 'jifeb@mailinator.com', '1', '2022-10-26 13:12:40'),
(3, '', 'cizap@mailinator.com', '1', '2022-10-26 13:13:28'),
(4, '', 'supapacema@mailinator.com', '1', '2022-10-26 15:03:09');

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

--
-- Structure de la table `services`
--

CREATE TABLE `services` (
  `id_service` int(11) NOT NULL,
  `titre_service` varchar(255) NOT NULL,
  `slug_service` varchar(255) NOT NULL,
  `icone_service` varchar(255) NOT NULL DEFAULT 'flaticon-free-shipping',
  `image_service` varchar(255) NOT NULL DEFAULT 'images/services/img/services/default.jpg',
  `description_service` longtext NOT NULL,
  `statut` enum('0','1') NOT NULL DEFAULT '1',
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `dossier_service` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `services`
--

INSERT INTO `services` (`id_service`, `titre_service`, `slug_service`, `icone_service`, `image_service`, `description_service`, `statut`, `user_id`, `created_at`, `dossier_service`) VALUES
(1, 'La restauration (Catering) et l’hôtellerie', 'La-restauration-Catering-et-l-h-tellerie', 'flaticon-free-shipping', 'images/services/2.jfif', 'vvvv', '1', 2, '2022-11-17 15:29:01', 'services/la-restauration-catering-et-l-h-tellerie/'),
(2, 'Entretien et Aménagement', 'Entretien-et-Am-nagement', 'flaticon-free-shipping', 'images/services/4.jpg', 'vvv', '1', 2, '2022-11-17 15:30:46', 'services/entretien-et-am-nagement/'),
(3, 'Gestion de Supermarché', 'Gestion-de-Supermarch-', 'flaticon-free-shipping', 'images/services/5.jfif', 'vvv', '1', 2, '2022-11-17 15:31:35', 'services/gestion-de-supermarch-/'),
(4, 'Fourniture d’équipements de protection personnel EPP', 'Fourniture-d-quipements-de-protection-personnel-EPP', 'flaticon-free-shipping', 'images/services/8.jfif', 'vv', '1', 2, '2022-11-17 15:32:07', 'services/fourniture-d-quipements-de-protection-personnel-epp/'),
(5, 'Fourniture d’équipements informatiques', 'Fourniture-d-quipements-informatiques', 'flaticon-free-shipping', 'images/services/7.jfif', 'vv', '1', 2, '2022-11-17 15:32:48', 'services/fourniture-d-quipements-informatiques/'),
(6, 'Prestation de service (imprimé tag et books)', 'Prestation-de-service-imprim-tag-et-books-', 'flaticon-free-shipping', 'images/services/6.jfif', 'vv', '1', 2, '2022-11-17 15:33:38', 'services/prestation-de-service-imprim-tag-et-books-/');

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

--
-- Structure de la table `sliders`
--

CREATE TABLE `sliders` (
  `id_slider` int(11) NOT NULL,
  `titre_slider` varchar(255) NOT NULL,
  `button_slider` varchar(255) NOT NULL,
  `lien_slider` varchar(255) NOT NULL,
  `image_slider` varchar(255) NOT NULL,
  `description_slider` text NOT NULL,
  `code_slider` varchar(255) NOT NULL,
  `dossier_slider` varchar(255) NOT NULL,
  `statut_slider` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `sliders`
--

INSERT INTO `sliders` (`id_slider`, `titre_slider`, `button_slider`, `lien_slider`, `image_slider`, `description_slider`, `code_slider`, `dossier_slider`, `statut_slider`, `created_at`, `user_id`) VALUES
(1, 'Bienvenue chez Délices d\'Eden', '', '', 'images/sliders/2022/11/17/1668682648.jpg', 'Avec Délices d\'Eden tout est fait avec suivi et rigueur avec des professionnels\r\nVous satisfaire est notre ambition', 'XL6mvTtxai', '', '0', '2022-11-17 10:57:28', 2),
(2, 'Bienvenue chez Délices d\'Eden', '', '', 'images/sliders/2022/11/17/1668682849.jpg', 'Avec Délices d\'Eden tout est fait avec suivi et rigueur avec des professionnels\r\nVous satisfaire est notre ambition', 'kDiGOl4DyY', '', '1', '2022-11-17 11:00:49', 2),
(3, 'Bienvenue chez Délices d\'Eden', '', '', 'images/sliders/2022/11/17/1668686619.jpg', 'Avec Délices d\'Eden tout est fait avec suivi et rigueur avec des professionnels\r\nVous satisfaire est notre ambition', 'IWAHcnmCqa', '', '0', '2022-11-17 12:03:39', 2),
(4, 'Bienvenue chez Délices D\'Eden', '', '', 'images/sliders/2022/11/17/1668686640.jpg', 'Avec Délices d\'Eden tout est fait avec suivi et rigueur avec des professionnels\r\nVous satisfaire est notre ambition', 'OSrg7sSmpn', '', '0', '2022-11-17 12:04:00', 2),
(5, 'Bienvenue chez Délices D\'Eden', '', '', 'images/sliders/2022/11/18/1668761691.jpg', 'le service traiteur qui accompagne tous vos événements d\'entreprise !', '7cTEHE9H5e', '', '1', '2022-11-18 08:54:51', 2),
(6, 'L\'excellence au rendez vous', '', '', 'images/sliders/2022/12/11/1670789533.jpg', 'Traiteur d\'entreprise depuis de nombreuses années, avec une équipe professionnelle à votre service.', 'uw4GqSVf4C', '', '1', '2022-12-11 21:12:13', 20),
(7, 'Traiteur d\'entreprise', '', '', 'images/sliders/2022/12/11/1670791890.jpg', ' Notre savoir-faire nous permet d’intervenir sur tout type d’événement d’entreprise et de vous proposer un large choix de prestations pour toutes vos envies.', 'oKYZuK0fiH', 'images/sliders/2022/12/11/', '1', '2022-12-11 21:41:55', 20);

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

--
-- Structure de la table `temoignages`
--

CREATE TABLE `temoignages` (
  `id` int(11) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `prenom` varchar(255) NOT NULL,
  `contenu` text NOT NULL,
  `photo` varchar(255) NOT NULL,
  `profession` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `statut` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `temoignages`
--

INSERT INTO `temoignages` (`id`, `nom`, `prenom`, `contenu`, `photo`, `profession`, `code`, `statut`, `created_at`, `user_id`) VALUES
(1, 'Fugiat elit commod', 'Adipisicing aperiam ', 'Deserunt nisi tempor', 'images/temoignages/1665486879.png', 'Nihil maiores incidi', 'jGOe16TCUq', '0', '2022-10-11 11:14:39', 2),
(2, 'BARRY', 'ALSENY', 'Je joue avec lonagui depuis plusieurs années et j\'apprécie vraiment le site. Tous mes gains ont été crédités sur mon compte. Merci à toute l\'équipe de Lonagui !\"', 'images/temoignages/1665486753.png', 'Nihil maiores incidi', '4TK77OeGDe', '0', '2022-10-11 11:12:33', 2),
(3, 'Philip1', 'Natus omnis fugit t', 'dfd', 'images/temoignages/1665486956.jpg', 'Mollit vitae modi pr', '6g0XmN4cEH', '0', '2022-10-11 11:15:56', 2),
(4, 'Diallo 1', 'ALPHA 12', 'Je joue avec lonagui depuis plusieurs années et j\'apprécie vraiment le site. Tous mes gains ont été crédités sur mon compte. Merci à toute l\'équipe de Lonagui !\"', 'images/temoignages/1668693821.png', 'ETUDIANT 12', 'nSQmvhP2jG', '0', '2022-10-11 12:44:28', 2),
(5, 'SAG', 'GUINEÉ', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam eu sem tempor, varius quam at, luctus dui. Mauris magna metus, dapibus nec turpis vel, semper malesuada ante. Idac bibendum scelerisque non non purus. Suspendisse varius nibh non aliquet.', 'images/temoignages/1668693751.jpg', 'Ingenieur de Mine', 'VXoZH6OhpY', '1', '2022-11-17 12:43:48', 2),
(6, 'DIALLO', 'BACHIR', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam eu sem tempor, varius quam at, luctus dui. Mauris magna metus, dapibus nec turpis vel, semper malesuada ante. Idac bibendum scelerisque non non purus. Suspendisse varius nibh non aliquet.', 'images/temoignages/1668693801.jpg', 'ENSEIGNANT', 'nBvjfKureY', '1', '2022-11-17 13:57:36', 2),
(7, 'DIALLO', 'BACHIR', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam eu sem tempor, varius quam at, luctus dui. Mauris magna metus, dapibus nec turpis vel, semper malesuada ante. Idac bibendum scelerisque non non purus. Suspendisse varius nibh non aliquet.', 'images/temoignages/1668693507.jpg', 'ENSEIGNANT', '2GEb6y6d3O', '1', '2022-11-17 13:58:27', 2),
(8, 'BAH', 'Mdou Saliou', 'Delectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam uDelectus ut ipsam u', 'images/temoignages/1668761519.jpeg', 'Comminuty Manager', 'jKpm5QiCv9', '1', '2022-11-18 08:51:59', 2);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`id_art`);

--
-- Index pour la table `breaking_new`
--
ALTER TABLE `breaking_new`
  ADD PRIMARY KEY (`id_break`);

--
-- Index pour la table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id_cat`);

--
-- Index pour la table `connexions`
--
ALTER TABLE `connexions`
  ADD PRIMARY KEY (`id_con`);

--
-- Index pour la table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id_con`);

--
-- Index pour la table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id_image`);

--
-- Index pour la table `membres_equipe`
--
ALTER TABLE `membres_equipe`
  ADD PRIMARY KEY (`id_mem`);

--
-- Index pour la table `newletters`
--
ALTER TABLE `newletters`
  ADD PRIMARY KEY (`id_newletter`);

--
-- Index pour la table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id_service`);

--
-- Index pour la table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id_slider`);

--
-- Index pour la table `temoignages`
--
ALTER TABLE `temoignages`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `articles`
--
ALTER TABLE `articles`
  MODIFY `id_art` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT pour la table `breaking_new`
--
ALTER TABLE `breaking_new`
  MODIFY `id_break` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `categories`
--
ALTER TABLE `categories`
  MODIFY `id_cat` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT pour la table `connexions`
--
ALTER TABLE `connexions`
  MODIFY `id_con` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT pour la table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id_con` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT pour la table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id_image` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT pour la table `membres_equipe`
--
ALTER TABLE `membres_equipe`
  MODIFY `id_mem` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `newletters`
--
ALTER TABLE `newletters`
  MODIFY `id_newletter` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `services`
--
ALTER TABLE `services`
  MODIFY `id_service` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id_slider` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `temoignages`
--
ALTER TABLE `temoignages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

