-- https://www.phpmyadmin.net/
--
-- Hôte : mysql-underwriting.alwaysdata.net
-- Généré le : ven. 15 nov. 2024 à 19:44
-- Version du serveur : 10.4.34-MariaDB
-- Version de PHP : 7.4.33

START TRANSACTION;



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

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

--
-- Structure de la table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` bigint(20) NOT NULL,
  `vendeur_id` int(11) NOT NULL,
  `categorie_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `contact` varchar(30) NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `radius` decimal(3,2) NOT NULL,
  `image_annonce` text NOT NULL DEFAULT 'https://underwriting.alwaysdata.net/api-slim/v4/public/uploads/localisation-iphone.jpg',
  `image_thumb` varchar(255) DEFAULT NULL,
  `video_annonce` text DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `deleted_at` datetime NOT NULL DEFAULT '2024-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `campaigns` (`id`, `vendeur_id`, `categorie_id`, `title`, `description`, `contact`, `latitude`, `longitude`, `radius`, `image_annonce`, `image_thumb`, `video_annonce`, `start_date`, `end_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 'Ma camp 1', 'description 1', '', 0.39649280, 9.46667520, 1.00, 'https://underwriting.alwaysdata.net/api-slim/v4/public/uploads/localisation-iphone.jpg', 'https://underwriting.alwaysdata.net/api-images/uploads/1729840831241bgandza.jpg', '', '2024-10-06', '2024-10-13', '2024-10-13 23:07:05', '2024-10-13 23:07:05', '2024-01-01 00:00:00'),
(2, 2, 2, 'Ma camp 2', 'description 2', '', 0.40372510, 9.45476100, 3.00, 'https://underwriting.alwaysdata.net/api-slim/v4/public/uploads/localisation-iphone.jpg', 'https://underwriting.alwaysdata.net/api-images/uploads/1729840831241bgandza.jpg', '', '2024-10-06', '2024-10-13', '2024-10-13 23:07:05', '2024-10-13 23:07:05', '2024-01-01 00:00:00'),
(3, 3, 1, 'Promo : 3 bouteilles à 500 f cfa ', 'Promotion : 3 bouteilles à 500 f cfa.', '', 0.42907550, 9.43053020, 1.50, 'https://underwriting.alwaysdata.net/api-slim/v4/public/uploads/localisation-iphone.jpg', 'https://underwriting.alwaysdata.net/api-images/uploads/1729840831241bgandza.jpg', '', '2024-10-11', '2024-10-18', '2024-10-13 23:07:05', '2024-10-13 23:07:05', '2024-01-01 00:00:00'),
(8, 1, 3, 'PIZZA', 'tet', '0444141414', 0.42919650, 9.43049610, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1728854375386capture2.png', 'https://underwriting.alwaysdata.net/api-images/uploads/1729840831241bgandza.jpg', '', '2024-10-17', '2024-10-30', '2024-10-13 23:08:36', '2024-10-13 22:08:38', '2024-01-01 00:00:00'),
(9, 1, 2, 'Ok pour ', 'ok pour today', '0444141414', 0.42409650, 9.43049610, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1728854375386capture2.png', 'https://underwriting.alwaysdata.net/api-images/uploads/1729840831241bgandza.jpg', '', '2024-10-22', '2024-10-29', '2024-10-13 23:20:26', '2024-10-13 22:20:26', '2024-01-01 00:00:00'),
(10, 14, 5, 'PROMOTION 2024', 'Promotion ANDZA à Nzeng-Ayong', '02028080', 0.42907170, 9.43048110, 1.50, 'https://underwriting.alwaysdata.net/api-images/uploads/1730280012377bgandza.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730280012377bgandza.jpg', '', '2024-10-29', '2024-11-05', '2024-10-25 09:23:15', '2024-10-30 10:21:38', '2024-01-01 00:00:00'),
(11, 14, 3, 'TITRE 2', 'TEST 2222', '074121212', 0.45192820, 9.42611510, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1729843362517webtoyotaprado2024900x430.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1729843362517webtoyotaprado2024900x430.jpg', '', '2024-10-25', '2024-10-30', '2024-10-25 10:03:59', '2024-10-29 09:47:23', '2024-01-01 00:00:00'),
(12, 14, 6, 'Promotion IPhone ', 'Iphone xr 64Gb en promotion', '077717171', 0.40042510, 9.45694620, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/17299357321741000001855.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17299357321741000001855.jpg', '', '2024-10-26', '2024-11-09', '2024-10-26 11:43:24', '2024-10-29 09:43:39', '2024-01-01 00:00:00'),
(13, 14, 9, 'DESTOCKAGE ELECTRA', 'Electra fait son déstockage  ', '066303030', 0.42907110, 9.43048570, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730109385336exesssselectrademenagement900x430.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730109385336exesssselectrademenagement900x430.jpg', '', '2024-10-28', '2024-11-09', '2024-10-28 10:58:38', '2024-10-28 10:58:39', '2024-01-01 00:00:00'),
(14, 14, 6, 'NOUVEAU DESCTOCKAGE ', 'Nouveau déstockage chez electra', '062121212', 0.42902770, 9.43051540, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730109712923exesselectrademenagement1280x774.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730109712923exesselectrademenagement1280x774.jpg', '', '2024-10-28', '2024-11-04', '2024-10-28 11:03:35', '2024-10-28 11:03:35', '2024-01-01 00:00:00'),
(15, 16, 1, 'Promo test ', 'Je vous confirme que c\'est vrai. yaura de la nourriture ', '066128364', 0.41664000, 9.45426020, 5.00, 'https://underwriting.alwaysdata.net/api-slim/v4/public/uploads/localisation-iphone.jpg', NULL, '', '2024-10-28', '2024-11-02', '2024-10-28 17:57:24', '2024-10-28 17:57:24', '2024-01-01 00:00:00'),
(21, 14, 6, 'iunzegub', 'vezcze ecezeve\r\nvzevezv\r\nvez', '02028080', 0.42907480, 9.43047670, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730283543637exesiteinternettoyotaprado20242560x697.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730283543637exesiteinternettoyotaprado20242560x697.jpg', 'https://underwriting.alwaysdata.net/api-images/uploads/1730283543637rackkham.mp4', '2024-10-30', '2024-11-05', '2024-10-30 11:20:15', '2024-10-30 11:20:18', '2024-01-01 00:00:00'),
(22, 15, 6, 'Mon titre modifié ', 'Ceci est un test avec van’s ', '062363636', 0.42907370, 9.43047390, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/17302933138591000003126.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17302933138591000003126.jpg', NULL, '2024-10-28', '2024-11-06', '2024-10-30 14:01:14', '2024-10-30 14:03:09', '2024-01-01 00:00:00'),
(29, 15, 6, 'cezccee', 'czceczcezc', '07525252', 0.42907380, 9.43047980, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730378464476exeemailingelectra2demenagement.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730378464476exeemailingelectra2demenagement.jpg', NULL, '2024-10-31', '2024-11-02', '2024-10-31 13:41:28', '2024-10-31 13:41:28', '2024-01-01 00:00:00'),
(30, 15, 6, 'cezcecezczecec', 'czec zeccezc ezczecez eztrbtrb', '02028080', 0.42907410, 9.43047760, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730379280079exesiteinternettoyotaprado20242560x697.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730379280079exesiteinternettoyotaprado20242560x697.jpg', NULL, '2024-10-31', '2024-11-06', '2024-10-31 13:55:24', '2024-10-31 13:55:24', '2024-01-01 00:00:00'),
(31, 15, 6, 'MON TITRE', 'Ce document est un testjkhihoih oihioh oizh,oi', '02028080', 0.42907200, 9.43048460, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730379561076exesiteinternettoyotaprado20242560x697.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730379561076exesiteinternettoyotaprado20242560x697.jpg', NULL, '2024-10-31', '2024-11-05', '2024-10-31 14:00:03', '2024-10-31 14:00:04', '2024-01-01 00:00:00'),
(32, 20, 1, '2 Pizzas achetés 1 offerte', 'Restaurant sitié au Primtemps. \r\nNous vous garantisons des Pizza de tres bonne qualité, vous ne seriez pas decu. Bonne appetit d\'avance', '077748596', -0.69795840, 8.76216320, 1.50, 'https://underwriting.alwaysdata.net/api-images/uploads/17307266462451d28c51cfab73dfcd0e3fad6824f4e86.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17307266462451d28c51cfab73dfcd0e3fad6824f4e86.jpg', NULL, '2024-11-04', '2024-11-14', '2024-11-04 14:27:52', '2024-11-04 14:27:53', '2024-01-01 00:00:00'),
(33, 20, 2, 'Appartement a louer de Lux', 'Appartement de 2 chambres, avec vue sur la mer. Grad jardin pour vos soirée d\'affaire et nous mettons a votre disposition de vehicule de location. ', '04253641', -0.69795840, 8.76216320, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730728219397canap.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730728219397canap.jpg', NULL, '2024-11-04', '2024-11-09', '2024-11-04 14:57:18', '2024-11-04 14:57:18', '2024-01-01 00:00:00'),
(34, 20, 1, '15% sur shawarma avec livraison', 'Nous vous offrons des réductions sur nos shawarma, profitez au maximum ', '04253641', -0.69795840, 8.76216320, 1.70, 'https://underwriting.alwaysdata.net/api-images/uploads/1730729848209503b9952fffc44143981d6b6a1b953cd1.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730729848209503b9952fffc44143981d6b6a1b953cd1.jpg', NULL, '2024-11-04', '2024-11-09', '2024-11-04 15:21:24', '2024-11-04 15:48:56', '2024-01-01 00:00:00'),
(35, 20, 2, 'Maison a louer Okala', 'maison tres bien entretenu en moins de 5mn de la route', '04253641', -0.69795840, 8.76216320, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730731471380appartementsalouersaintemilionvinscompagnie.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730731471380appartementsalouersaintemilionvinscompagnie.jpg', NULL, '2024-11-04', '2024-11-07', '2024-11-04 15:46:31', '2024-11-04 15:46:32', '2024-01-01 00:00:00'),
(36, 20, 3, 'montre feminin', 'Montre discret tres jolie, de couleur rose. ', '077859641', -0.69795840, 8.76216320, 1.70, 'https://underwriting.alwaysdata.net/api-images/uploads/1730731814343152.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730731814343152.jpg', NULL, '2024-11-04', '2024-11-07', '2024-11-04 15:54:29', '2024-11-04 15:54:29', '2024-01-01 00:00:00'),
(37, 20, 1, 'Shawarma à 2.000 cfa avc livraison ', 'Commande et viens récupérer ton shawarma.  Nous livrons a 1.000 cfa et sur place à 2.000 cfa très bon ', '04253641', -0.71795900, 8.74656790, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730750628634503b9952fffc44143981d6b6a1b953cd1.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730750628634503b9952fffc44143981d6b6a1b953cd1.jpg', NULL, '2024-11-04', '2024-11-06', '2024-11-04 21:06:30', '2024-11-04 21:06:31', '2024-01-01 00:00:00'),
(38, 21, 1, 'Mangue', 'Délicieux ', '074567867', -0.71602840, 8.73715150, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730753817788screenshot20241020085354.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730753817788screenshot20241020085354.jpg', NULL, '2024-11-04', '2024-11-07', '2024-11-04 21:59:15', '2024-11-04 21:59:15', '2024-01-01 00:00:00'),
(39, 20, 1, 'Hamburger de choix', 'Hamburger de taille, si tu manger tu va encore et encore en demander ', '077968574', -0.69795840, 8.76216320, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/17308815473615d6435372498720ba5f33695fce715ca.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17308815473615d6435372498720ba5f33695fce715ca.jpg', NULL, '2024-11-06', '2024-11-10', '2024-11-06 09:27:10', '2024-11-06 09:27:11', '2024-01-01 00:00:00'),
(40, 20, 3, 'Talon Louis Viton', 'Talon de trs bonne qualité, elle met vos pieds en valeur et donnera envie a vos proches d\'avoir les-meme. garantie 2 mois lors de l\'achat ', '077415296', -0.69795840, 8.76216320, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730890507254153.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730890507254153.jpg', NULL, '2024-11-06', '2024-11-08', '2024-11-06 11:57:34', '2024-11-11 11:48:27', '2024-11-11 11:48:27'),
(41, 20, 2, 'Studio meublé', 'Studio meublé situé a NZENG, dans la barriere avec une grande terrase. Les grilles de securité et wifi.', '077859674', -0.69795840, 8.76216320, 1.40, 'https://underwriting.alwaysdata.net/api-images/uploads/17308907766924flandresapparthotel.jpeg', 'https://underwriting.alwaysdata.net/api-images/thumb/17308907766924flandresapparthotel.jpeg', NULL, '2024-11-06', '2024-11-09', '2024-11-06 12:01:47', '2024-11-06 12:01:47', '2024-01-01 00:00:00'),
(42, 20, 3, 'Chaussure Nike', 'Chaussure pour jouer au basket, pointure 43 et 44.', '07560539', -0.69886920, 8.76792520, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730902160177d94388a6capturedecran20240320a10.16.56.png', 'https://underwriting.alwaysdata.net/api-images/thumb/1730902160177d94388a6capturedecran20240320a10.16.56.png', NULL, '2024-11-06', '2024-11-09', '2024-11-06 15:10:08', '2024-11-06 15:10:08', '2024-01-01 00:00:00'),
(43, 20, 3, 'Chaussure Nike Femme', 'Chaussure très élégant pour balade ', '04253641', -0.69886920, 8.76792520, 1.50, 'https://underwriting.alwaysdata.net/api-images/uploads/1730902227388fc6eac25049d7e7545294629ad9b7c3d.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730902227388fc6eac25049d7e7545294629ad9b7c3d.jpg', NULL, '2024-11-06', '2024-11-09', '2024-11-06 15:11:35', '2024-11-06 15:11:35', '2024-01-01 00:00:00'),
(44, 20, 3, 'Chaussure JORDAN24 -25% ', 'Chaussure de marque de luxe. Tres confortable dans votre pieds toute les personnes font se larracher. Pointure 41 / 42 / 43 /44.\r\nIl a aussi la couleur noir ', '074526341', -0.69795840, 8.76216320, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730904971191f86aff8ed64c6a36b3e4230500d1df57.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730904971191f86aff8ed64c6a36b3e4230500d1df57.jpg', NULL, '2024-11-06', '2024-11-10', '2024-11-06 15:58:14', '2024-11-06 15:58:15', '2024-01-01 00:00:00'),
(45, 20, 2, 'Miason lux', 'Chambre a AKANDA', '04253641', -0.69795840, 8.76216320, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730905240813appartementhaussmanniende70m2marionalbergedecorationimg22c11bb7042a79564922016284bfd.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730905240813appartementhaussmanniende70m2marionalbergedecorationimg22c11bb7042a79564922016284bfd.jpg', 'https://underwriting.alwaysdata.net/api-images/uploads/1730905240813appartementdeluxesituyoaakanda.mp4', '2024-11-06', '2024-11-09', '2024-11-06 16:02:55', '2024-11-06 16:02:58', '2024-01-01 00:00:00'),
(46, 20, 1, 'Menu restau', 'Menu', '07560539', -0.69795840, 8.76216320, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1730905467261d0c0df49de201425a1983be7250955ad.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1730905467261d0c0df49de201425a1983be7250955ad.jpg', NULL, '2024-11-06', '2024-11-09', '2024-11-06 16:04:54', '2024-11-06 16:04:55', '2024-01-01 00:00:00'),
(47, 14, 9, 'MOTEUR TOYOTA', 'Je vends un moteur Toyota pour HILUX. \r\nCeux qui sont chauds suis dispo. ', '02303030', 0.40045290, 9.45686550, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1731078613811pngclipartautomotiveenginepartcarcarsparepartscarautopart.png', 'https://underwriting.alwaysdata.net/api-images/thumb/1731078613811pngclipartautomotiveenginepartcarcarsparepartscarautopart.png', NULL, '2024-11-08', '2024-11-12', '2024-11-08 16:13:20', '2024-11-08 16:13:21', '2024-01-01 00:00:00'),
(48, 14, 9, 'MOTEUR HORS-BORD', 'Moteur HORS-BORD à vendre: \r\n1.500.000 F CFA. Venez vite', '02303030', 0.40044460, 9.45687480, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1731079425482capturedyocran20240105182708.png', 'https://underwriting.alwaysdata.net/api-images/thumb/1731079425482capturedyocran20240105182708.png', NULL, '2024-11-08', '2024-11-13', '2024-11-08 16:26:33', '2024-11-08 16:26:33', '2024-01-01 00:00:00'),
(49, 14, 9, 'LAND CRUISER PRADO 250', 'venez prendre votre voiture de rêve.\r\nLe prix est super pour toute personne nantie.', '02303030', 0.40046150, 9.45687490, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/17310811507712024041801tw610.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17310811507712024041801tw610.jpg', NULL, '2024-11-08', '2024-11-12', '2024-11-08 16:54:29', '2024-11-08 16:54:30', '2024-01-01 00:00:00'),
(51, 14, 9, 'FJCruiser', 'Toyota FJCRUISER 2018. En promotion jusqu\'au 31 Janvier2025.\r\nVenez vite!', '02303030', 0.41615360, 9.47650560, 2.00, 'https://underwriting.alwaysdata.net/api-images/uploads/17311054798692024041801tw610.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17311054798692024041801tw610.jpg', NULL, '2024-11-08', '2024-11-13', '2024-11-08 23:39:11', '2024-11-08 23:39:12', '2024-01-01 00:00:00'),
(52, 20, 3, 'Chaussure nike', 'Ghhashhs', '04253641', -0.71650780, 8.73830830, 1.00, 'https://underwriting.alwaysdata.net/api-images/uploads/1731108241572d94388a6capturedecran20240320a10.16.56.png', 'https://underwriting.alwaysdata.net/api-images/thumb/1731108241572d94388a6capturedecran20240320a10.16.56.png', NULL, '2024-11-09', '2024-11-11', '2024-11-09 00:24:47', '2024-11-09 00:26:54', '2024-11-09 00:26:54'),
(53, 20, 3, 'Solde de sac à mains ', 'Viens choisir ton sac à mains ou fait toi livrer à moins de 1h. ', '077362814', -0.72354670, 8.77464310, 1.20, 'https://underwriting.alwaysdata.net/api-images/uploads/1731150148632accessoiresdemode.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/1731150148632accessoiresdemode.jpg', NULL, '2024-11-09', '2024-11-13', '2024-11-09 12:04:19', '2024-11-09 12:04:19', '2024-01-01 00:00:00'),
(54, 14, 9, 'YOUTUZ', 'Ceci est un test de notifications', '02303030', 0.40038450, 9.45685190, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17311594991442024041801tw610.jpg', 'https://underwriting.alwaysdata.net/api-images/thumb/17311594991442024041801tw610.jpg', NULL, '2024-11-09', '2024-11-14', '2024-11-09 14:39:34', '2024-11-09 14:39:35', '2024-01-01 00:00:00'),
(55, 14, 9, 'TEST 01', 'ceci est un test de notif', '02303030', 0.38010880, 9.51255040, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17311604184142024041801tw610.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17311604184142024041801tw610.jpg', NULL, '2024-11-09', '2024-11-12', '2024-11-09 14:54:22', '2024-11-09 14:54:22', '2024-01-01 00:00:00'),
(56, 15, 9, 'TOYOTA HILUX 2023', 'TOYOTA HILUX 2023 en promotion chez nous.\r\nVenez vite et partez avec votre voiture.', '04404040', 0.38010880, 9.51255040, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17312375727172023hiluxgrsportmainshots1.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17312375727172023hiluxgrsportmainshots1.jpg', NULL, '2024-11-10', '2024-11-14', '2024-11-10 12:21:04', '2024-11-10 12:21:04', '2024-01-01 00:00:00'),
(57, 15, 9, 'HILUX 2019', 'HILUX 2019', '04404040', 0.38010880, 9.51255040, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17312500137862023hiluxgrsportmainshots1.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17312500137862023hiluxgrsportmainshots1.jpg', NULL, '2024-11-10', '2024-11-13', '2024-11-10 15:47:30', '2024-11-10 15:47:30', '2024-01-01 00:00:00'),
(58, 15, 9, 'TEDST', 'fr\'jigu giu\'higjgrg g\'guhii', '02303030', 0.40045300, 9.45690930, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17312598507352023hiluxgrsportmainshots1.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17312598507352023hiluxgrsportmainshots1.jpg', NULL, '2024-11-10', '2024-11-15', '2024-11-10 18:31:26', '2024-11-10 18:31:27', '2024-01-01 00:00:00'),
(59, 15, 9, 'Test home', 'Ceci est un test de publication d\'une campagne.', '077713142', 0.40041410, 9.45683990, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17312759461101000005907.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17312759461101000005907.jpg', NULL, '2024-11-10', '2024-11-15', '2024-11-10 23:00:03', '2024-11-10 23:00:03', '2024-01-01 00:00:00'),
(60, 23, 9, 'Gucjtxdh', 'Xybinj', '45860', 0.40045836, 9.45680976, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731277887310img1259.png', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731277887310img1259.png', NULL, '2024-11-10', '2024-11-14', '2024-11-10 23:32:42', '2024-11-10 23:32:42', '2024-01-01 00:00:00'),
(61, 20, 1, 'Remis de 15% hamburger ', 'de Lundi à vendredi faite commander vos hamburger avec une remise de 15% et la livraison est offerte. ', '07560539', -0.69795840, 8.76216320, 1.60, 'https://my-freelance.alwaysdata.net/api-images/uploads/17313209626695d6435372498720ba5f33695fce715ca.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17313209626695d6435372498720ba5f33695fce715ca.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 11:37:26', '2024-11-11 11:37:27', '2024-01-01 00:00:00'),
(62, 20, 3, 'Casquette ', 'Casquette de marque star ', '077967485', -0.69795840, 8.76216320, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731321523820121.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731321523820121.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 11:40:41', '2024-11-11 11:40:42', '2024-01-01 00:00:00'),
(63, 20, 6, 'Samsung S20 ', 'Samsung S20 a un prix tres reduit. Commander et soyez livré en moins de 1h', '077859674', -0.69795840, 8.76216320, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731322256110151.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731322256110151.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 11:52:30', '2024-11-11 11:52:31', '2024-01-01 00:00:00'),
(64, 20, 3, 'Montre en Titane', 'Montre de luxe en titane', '0749685', -0.69795840, 8.76216320, 1.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731322359777131.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731322359777131.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 11:53:41', '2024-11-11 11:53:41', '2024-01-01 00:00:00'),
(65, 20, 3, 'Caquette blanche', 'Casquette blanche pour impression. \r\ncommander 50 a un prix de 3.000 CFA ', '07560539', -0.69795840, 8.76216320, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731329655465135.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731329655465135.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 13:56:38', '2024-11-11 13:56:39', '2024-01-01 00:00:00'),
(66, 24, 3, 'Bretelle foler la chemise', 'Bretele pour retenir la chemise dans le pantalon.\r\nvendu a 5.500  CFA', '077859623', -0.69795840, 8.76216320, 1.80, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731332675643143.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731332675643143.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 14:47:58', '2024-11-11 14:47:58', '2024-01-01 00:00:00'),
(67, 24, 4, 'Promo de Lunette ', 'Lunette de vue a promotion', '04253641', -0.69795840, 8.76216320, 1.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/173133332023018.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/173133332023018.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 14:56:08', '2024-11-11 14:56:10', '2024-01-01 00:00:00'),
(68, 24, 3, 'Montre a 35.000 CFA ', 'Montre de lux', '07560539', -0.69795840, 8.76216320, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731333561521113.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731333561521113.jpg', NULL, '2024-11-11', '2024-11-14', '2024-11-11 14:59:57', '2024-11-11 14:59:58', '2024-01-01 00:00:00'),
(69, 15, 7, 'Mon test', 'Ce test est', '077999', 0.42904890, 9.43047510, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17313337964171000004653.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17313337964171000004653.jpg', NULL, '2024-11-11', '2024-11-16', '2024-11-11 15:04:23', '2024-11-11 15:04:24', '2024-01-01 00:00:00'),
(70, 24, 3, 'Chemise blanche africaine', 'Chemise africaine blanche taille XL / L / M\r\nPrix a 25.000 CFA avec la livraison', '07560539', -0.69795840, 8.76544000, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731404428426chemise.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731404428426chemise.jpg', NULL, '2024-11-12', '2024-11-15', '2024-11-12 10:41:35', '2024-11-12 10:41:36', '2024-01-01 00:00:00'),
(71, 24, 7, '222', 'ssss', '04253641', -0.69795840, 8.76544000, 1.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17314046402984b8f7ee512229952e3c681baca9cd5c8.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17314046402984b8f7ee512229952e3c681baca9cd5c8.jpg', NULL, '2024-11-12', '2024-11-13', '2024-11-12 10:44:30', '2024-11-12 10:44:50', '2024-11-12 10:44:50'),
(72, 24, 3, 'Chemise africaine croisé de luxe', 'Chemise classe, africain de luxe et faites en pagnes.\r\nCouleur: Rouge / Blanc / Noir \r\nTaille: M / L / XL / XXL\r\nPrix: 30.000 CFA\r\nlivraison: 1ier livraisonj gratuit', '07560539', -0.69795840, 8.76544000, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731405132558133b692b14e7386024baf0b5c12f90dc.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731405132558133b692b14e7386024baf0b5c12f90dc.jpg', NULL, '2024-11-12', '2024-11-14', '2024-11-12 10:55:48', '2024-11-12 10:55:48', '2024-01-01 00:00:00'),
(73, 24, 7, 'cherche cuisinier braiseur', 'BAR-RESTAURANT À OKALA en face du ballon\r\nd’or, cherche cuisinier braiseur complet sachant faire la cuisine africaine\r\net la braise de 9h00 à\r\n22h30, salaire 130.000\r\nFCFA, pas sérieux s’abstenir', '074526341', -0.69795840, 8.76544000, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731405479331a527cf2401539357f3fff85c31943627.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731405479331a527cf2401539357f3fff85c31943627.jpg', NULL, '2024-11-12', '2024-11-19', '2024-11-12 11:04:04', '2024-11-12 11:04:04', '2024-01-01 00:00:00'),
(74, 24, 7, 'Recrute mécaniciens', 'PME DE LA PLACE recrute mécaniciens\r\nautomobiles, avec ou\r\nsans expérience', '066418919', -0.69795840, 8.76544000, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/173140676413844584df8f60f03630dddbe99d2392dd1.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/173140676413844584df8f60f03630dddbe99d2392dd1.jpg', NULL, '2024-11-12', '2024-11-15', '2024-11-12 11:20:38', '2024-11-12 11:20:39', '2024-01-01 00:00:00'),
(75, 24, 3, 'Chemise super classe ', 'Chemise africaine blanche et gris  avec un prix de 25.000 CFA\r\ntaille XL / M / L\r\ncouleur : blanche / rouge / noir', '0749685', -0.69795840, 8.76544000, 1.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/17314083750320cc4fca50b96fb3c725da2020a3e91a1.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/17314083750320cc4fca50b96fb3c725da2020a3e91a1.jpg', NULL, '2024-11-12', '2024-11-15', '2024-11-12 11:48:09', '2024-11-12 11:48:10', '2024-01-01 00:00:00'),
(76, 25, 6, 'Promo sur ensemble des appa', 'Promo sur l\'ensemble des appareils à 15%.', '077859632', -0.71690000, 8.78740000, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731423684003db0b8d1c88854f9e1c6bde673c837ea7.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731423684003db0b8d1c88854f9e1c6bde673c837ea7.jpg', NULL, '2024-11-12', '2024-11-15', '2024-11-12 16:03:31', '2024-11-12 16:03:32', '2024-01-01 00:00:00'),
(77, 24, 6, '10 % de réduction ', 'Offre réservée à tout nouveau client qui réalise sa première commande sur le site', '04253641', -0.69795840, 8.76216320, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731423888529db0b8d1c88854f9e1c6bde673c837ea7.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731423888529db0b8d1c88854f9e1c6bde673c837ea7.jpg', NULL, '2024-11-12', '2024-11-15', '2024-11-12 16:08:43', '2024-11-12 16:08:43', '2024-01-01 00:00:00'),
(78, 24, 5, 'Orchestre en Live', 'Viens deguster et ecouter de la bonne musique en live.\r\nBoisson sobraga à 1.000 CFA et Cocktail à partir de 5.000 CFA ', '07560539', -0.69795840, 8.76216320, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731487993071db0f009bcd1526046cc26c3e2aa49500.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731487993071db0f009bcd1526046cc26c3e2aa49500.jpg', NULL, '2024-11-13', '2024-11-16', '2024-11-13 10:01:59', '2024-11-13 10:01:59', '2024-01-01 00:00:00'),
(79, 24, 9, 'Barquette en vente à 200 cfa ', 'En lot de 100', '0749685', -0.71682970, 8.73741620, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731621687931screenshot20241030085833chrome.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731621687931screenshot20241030085833chrome.jpg', NULL, '2024-11-14', '2024-11-19', '2024-11-14 23:03:43', '2024-11-14 23:03:44', '2024-01-01 00:00:00'),
(80, 20, 3, 'Basket en promo', 'Basket pour le sport ,basket-ball???? et pour les balades ', '07560539', -0.71683530, 8.73741380, 1.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731680142694d94388a6capturedecran20240320a10.16.56.png', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731680142694d94388a6capturedecran20240320a10.16.56.png', NULL, '2024-11-15', '2024-11-18', '2024-11-15 15:17:43', '2024-11-15 15:17:44', '2024-01-01 00:00:00'),
(81, 20, 3, 'Sac à mains ', 'Sac en promo', '07560539', -0.71683530, 8.73741380, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731680283115accessoiresdemode.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731680283115accessoiresdemode.jpg', NULL, '2024-11-15', '2024-11-18', '2024-11-15 15:18:42', '2024-11-15 15:18:43', '2024-01-01 00:00:00'),
(82, 20, 2, 'Studio à 100.000 cfa', 'Maison avec une chambre ', '07560539', -0.71683530, 8.73741380, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731680432586screenshot20241107195228facebook.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731680432586screenshot20241107195228facebook.jpg', NULL, '2024-11-15', '2024-11-18', '2024-11-15 15:21:33', '2024-11-15 15:21:33', '2024-01-01 00:00:00'),
(83, 24, 3, 'Robe de mariage a 500.000 cfa', 'Mariage', '077362514', -0.71681330, 8.73741610, 2.00, 'https://my-freelance.alwaysdata.net/api-images/uploads/1731680603697screenshot20240507170214.jpg', 'https://my-freelance.alwaysdata.net/api-images/thumb/1731680603697screenshot20240507170214.jpg', NULL, '2024-11-15', '2024-11-18', '2024-11-15 15:24:46', '2024-11-15 15:24:46', '2024-01-01 00:00:00');

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

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

CREATE TABLE `categories` (
  `id_categorie` int(11) NOT NULL,
  `libelle_cat` varchar(150) NOT NULL,
  `image` text NOT NULL DEFAULT 'https://underwriting.alwaysdata.net/assets/images/hotel-booking/hotel-icon/1.png',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `deleted_at` datetime NOT NULL DEFAULT '2024-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id_categorie`, `libelle_cat`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Restaurant', 'https://underwriting.alwaysdata.net/assets/images/restaurant_icone.png', '2024-10-11 12:09:14', '2024-10-11 12:09:14', '2024-01-01 00:00:00'),
(2, 'Hôtellerie', 'https://underwriting.alwaysdata.net/assets/images/hotel_icone.png', '2024-10-11 12:09:14', '2024-10-11 12:09:14', '2024-01-01 00:00:00'),
(3, 'Mode', 'https://underwriting.alwaysdata.net/assets/images/mode_icone.png', '2024-10-11 12:09:44', '2024-10-11 12:09:44', '2024-01-01 00:00:00'),
(4, 'Beauté et bien-être', 'https://underwriting.alwaysdata.net/assets/images/aute_icone.png', '2024-10-11 12:09:44', '2024-10-11 12:09:44', '2024-01-01 00:00:00'),
(5, 'Événements et loisirs', 'https://underwriting.alwaysdata.net/assets/images/loisir_icone.png', '2024-10-11 12:10:06', '2024-10-11 12:10:06', '2024-01-01 00:00:00'),
(6, 'High-tech', 'https://underwriting.alwaysdata.net/assets/images/hightech_icone.png', '2024-10-11 12:10:06', '2024-10-11 12:10:06', '2024-01-01 00:00:00'),
(7, 'Emploi', 'https://underwriting.alwaysdata.net/assets/images/emploi_icone.png', '2024-10-11 12:10:06', '2024-10-11 12:10:06', '2024-01-01 00:00:00'),
(8, 'Épicerie et supermarché', 'https://underwriting.alwaysdata.net/assets/images/supermarche_icone.png', '2024-10-11 12:10:06', '2024-10-11 12:10:06', '2024-01-01 00:00:00'),
(9, 'Services professionnels', 'https://underwriting.alwaysdata.net/assets/images/servicepro_icone.png', '2024-10-11 12:10:06', '2024-10-11 12:10:06', '2024-01-01 00:00:00');

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

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

CREATE TABLE `clients` (
  `id_client` bigint(20) NOT NULL,
  `cookie_client` varchar(150) NOT NULL,
  `token_fcm` text NOT NULL,
  `lat` decimal(10,8) NOT NULL,
  `lon` decimal(11,8) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `deleted_at` datetime NOT NULL DEFAULT '2024-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `clients` (`id_client`, `cookie_client`, `token_fcm`, `lat`, `lon`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Tr8XEtLzSL1729965425289', 'eTjcFNhORpPdJBgdW-2Zpi:APA91bHmQwFdhgkeUnQRLFXhK9dAkrV0Sm9X7JHJUosG1LaN1Bu-tO1TvXPv9ZMwduioaJzG7UbhRdlR3JnFl69qoweXD1wcf_KCGaGyjemcHahGiJVRzaSIUimIvCf2HX2rvcx8NtPx', 0.40304640, 9.46667520, '2024-10-26 19:57:05', '2024-10-26 19:57:05', '2024-01-01 00:00:00'),
(2, '6TOBTqPiHt1729966350766', 'fRjF39MxGvTqy7jy_s3G2T:APA91bFmMNvp3_t4UK0g8I3zNtsX6ir2xhxb8yWCUFhK9NtYWsJ4girDcjeGak22H3_4SAwATLzUTvwygDa_GWzx7NWPj6uH1a0PNH_v1MDvYrUg0TqR2XE', 0.40043890, 9.45684210, '2024-10-26 20:12:30', '2024-11-08 14:49:52', '2024-01-01 00:00:00'),
(3, 'eCjQv77p351729966649692', 'eIQ5poLs80PLxC_U6c0o4K:APA91bHpC3sCSJe9MpCeOY1LO5GnpYI5mZC4ehfo9IaLWd_n__2vddEOFGs2sZ4ET1q06SEwNJ2RoFrfnScNXpYHdkrHVY_DxTr7uBnIvGXgagbqeoXIiA4', 0.40048470, 9.45695990, '2024-10-26 20:17:30', '2024-10-28 23:06:43', '2024-01-01 00:00:00'),
(4, 'oMYlim2bDl1730029744414', 'c_mEPxdpjzCYB1eH7p7DuG:APA91bHczBiNy6aNMovhbzBfRp4iTyplpU4XVC8WBcAuyegnQ_L4qm0zhFC-F_jV6DQgLQTxyeQbK6TiDNzTPuoVWCmIKCYmygKHKuTC1aeZND9jXHH_B3U', 0.39970000, 9.45630000, '2024-10-27 12:49:04', '2024-11-10 00:37:51', '2024-01-01 00:00:00'),
(5, '3YbumLPJK71730029920565', 'eQnzNz3x0nzOLShW61U-ae:APA91bEPr1cPrH8qZr7vjuHgvk-y5MFyUyl1vTdCeuElgVYoaH3vcirwuc7WwclHV2sYa-RCKxGHAgOiNqBMGSD-TNZc_ADeGj0Yxn01n5yWfqgJOjuTM5k', 0.41664980, 9.45427260, '2024-10-27 12:52:00', '2024-11-05 16:03:43', '2024-01-01 00:00:00'),
(6, 'JNkmlCGgwV1730103346475', 'dwKfnOdyI-nSp0l7ra_vpZ:APA91bGs-whqr30ESZEdgNsQIIirvAS3nUDCGlfZcUeQZbTmrus4h8pxA-QXndBvdfXioaxjLmiYUUF4nL6uxVwrO0x5CM0bW4Snl1yKBorHlnEHwH_9zBw', 0.43581440, 9.42407680, '2024-10-28 09:15:45', '2024-10-28 12:04:25', '2024-01-01 00:00:00'),
(7, 'S3XvIoeMoL1730121906128', 'fj_rEBbwEEXNA70v45XN5E:APA91bHKB3d_5EL5sPKpuG6XIiMGnkNLPqNpWYA-ddgJ-179hA28DfbGrumYhlP9CypWLP-t4JKSBfiI28LwalSfUSntWJTDjiT1SqjMqFq53xBWQa1qQmE', 0.42902810, 9.43051750, '2024-10-28 14:25:05', '2024-10-28 15:06:43', '2024-01-01 00:00:00'),
(8, 'ft0VOrYueB1730193458327', 'eZc6B7zb1aJ1GdUfHxRdwh:APA91bFITKORBjqeJ70Zwp3v2kOjZ8cK3wq2vLUL-fINfaPSOWwDZK1OOjL_Uw65_Q3vCNZmbfm1qZ-qc68_Lbjgotcrhi8NPcPObB-DijehTWI1exKcd_8', 0.42904340, 9.43049260, '2024-10-29 10:17:38', '2024-10-29 14:48:03', '2024-01-01 00:00:00'),
(9, 'pvSIx6AkBT1730276813385', 'cJShh00WgKJyKmTIRM-f2u:APA91bGRj_9J4qBByzObtKbewMdN-O5damy9giq97kDxuxj_915BqnrV3TZlfNRZ10YZsEBBCNmxf0WAeO2ng65icEdWbLXw2Lme4tbwiBuPODAr6mSownI', 0.42902640, 9.43051780, '2024-10-30 09:26:54', '2024-10-30 12:08:18', '2024-01-01 00:00:00'),
(10, '82QYgOrneT1730292974718', 'fqZcbdMp8lZtDG9m7o_TEk:APA91bFVnMjqYjmEC6aqXHla_W520ReCsaV9cxDEbLCgY1-MLfwIbOrsPy0P1khPbJDOrMaJ2Sb9iipFOROmTfCxuH34ADO4lOevBvQQs-tKEJ8ecmTSdCg', 0.42906990, 9.43047450, '2024-10-30 13:56:15', '2024-10-30 14:23:55', '2024-01-01 00:00:00'),
(11, '2xTXS84BLX1730294727510', 'coWt-QsMt53VaErltlIIrX:APA91bFH8X6DQkyaNsAFM1B5taPn4bjxBFqIn2lmnFNfdkRYtIwXxd3QH5nplQhq8ecrL9H43_tIy80Tr-4imd44Bsbxaz2qVK7K_D0U6Xfht3-WGwcwhBM', 0.42904930, 9.43047690, '2024-10-30 14:25:28', '2024-11-07 09:59:51', '2024-01-01 00:00:00'),
(12, 'kenZRqIi011730294930120', 'ffL6vumq7KLo4yYX2acgv6:APA91bEQ6fIGyeMu4RJP_MX-tlC_JMpFv_REBYYZHC9ay1DiGfjiOuFxRq-Cp1jxc8hkSFtqfdKgX0i-tkpnWBt8UX8yaeEccfej8JhuU_TLkZgJc2YEGdQ', 0.42907330, 9.43048010, '2024-10-30 14:28:51', '2024-10-30 17:08:34', '2024-01-01 00:00:00'),
(13, 'MNdQU2ewkg1730362878699', 'eGIS2KHz9Ym-aiOWgm6D_M:APA91bHl-BpktNOuSZJuIb1zRZfTXja6HDbJit1i9VgDnifPTX2IQzRechaJ_eLUlQfP0-_ODT9Z-9ShLjjfYq75oEi770kzfFPgJIUvAAaKLaZnzWyNacU', 0.42907090, 9.43048000, '2024-10-31 09:21:20', '2024-10-31 14:05:14', '2024-01-01 00:00:00'),
(14, 'Hb1Wc4jZx81730712222446', 'd6BJzbvXOUt_gQbNidJxiZ:APA91bHZ_Y30ABuvU0-2nR8pqXRvrJj-a86b_lrdMN5oeBrcqqaNq15W7tngXlOvxUiZSIaWnv5efOyuiZSbQaBZ8a2gVuVh2LrO_5I081ttvAJs28_ZOIk', 0.42905050, 9.43046700, '2024-11-04 10:23:41', '2024-11-04 11:40:28', '2024-01-01 00:00:00'),
(15, 'CixHxfXrUA1730725436260', 'dokY5S0AgTMipDKDMmEc9b:APA91bHpFDTESfgmA3NwmHZLBeY2Ab-CPVEZSgYl7hd_FBS2pALKvHnKMYx0_dFPGtyjcw0hFlGDlHzsk1enZNzntOIBmJXRUYby1-Jb34gYlsX7k9N3ErU', 0.41620750, 9.46658380, '2024-11-04 14:03:56', '2024-11-04 14:03:56', '2024-01-01 00:00:00'),
(16, 'HZW33iJbYM1730725787048', 'dTofhaKzU4NA01MNAWf3Ji:APA91bFPtxYd5bppy-VX-Z9oeD66bpuSwhgCsg5ePiL5xsnyQRjNrNu1MlY98Q3p7xPB1L-mBwY8BvVfFUJEFef0pPzDxQc4XZL1Qlqjp_zIpe6fE4VkOEc', 0.41664240, 9.45426300, '2024-11-04 14:09:47', '2024-11-04 14:09:47', '2024-01-01 00:00:00'),
(17, 'A0lDsfCMhu1730726202097', 'du_ZiSEPKsSt220IoVAZ6k:APA91bFr-v6iKmWXF-Z5ksTtanqqxObUj9nGw8isACyYCmbZUZt9zALFcA0DpkxX-zQDoikBTK__lfBv5OVsQew2SKvRvtK5M_UCDogfPXIy--G2sF1rm8U', -0.69795840, 8.76216320, '2024-11-04 14:16:42', '2024-11-06 12:40:24', '2024-01-01 00:00:00'),
(18, 'cBkF7Vh8Ez1730727075662', 'evrSM9Bp8vaEIhy8tgMxO6:APA91bHS47ywaqpHZVIWBcE7zYfvJQKxAqF9Mk6hyzDQNF6NnrhCJKsoxE8zTn8QH7iAqtX7XclnYWqgZC70zO4F1u-t2qwkEj9fs23gstpLWr_2pzHNnIM', -0.69891070, 8.76788310, '2024-11-04 14:31:15', '2024-11-07 09:51:54', '2024-01-01 00:00:00'),
(19, 'UYZKL24UU61730813939948', 'ecvtZ9hewnpk4vnqyrCgJt:APA91bGL-_1X47Z85ZSHbtWptymEwimRCENBCzurGGP1OWDgko1kygfZpRDEUuieAg8FFttcr7_dr7I_UKYfjjOZdznbg-XWH6ChQvBGOe8prk_W5xgMh90', 0.42905160, 9.43047180, '2024-11-05 14:38:59', '2024-11-05 15:45:06', '2024-01-01 00:00:00'),
(20, 'xBoGffK8Fg1730900744007', 'f_nzpneHc-nmqrKoBn5khI:APA91bFodFE8kq8wFqBNwTokx6SlwSF72sILPwraxgUWG4BBrn4dEq16lMvGz7U8DWfXx6JihRyKVy6YM7MTD6HOALzNSY7IgQVNi3Z20hRehLZ_vSUaWB0', 0.42904980, 9.43047140, '2024-11-06 14:45:44', '2024-11-06 17:54:18', '2024-01-01 00:00:00'),
(21, 'S6QKNMxrdG1730904368773', 'd8IfmHb92A8vvOREi9Xgjm:APA91bEcW637NnHZKfg890-Lkqkf8xi0rk1zR582IJGVypVsGnvs2xqcJb_C4LE38UpwkyCqLKOnBZlaMnjh4uv2KctDPJQPR22U__uI7WvWcNix5sjSUuQ', -0.69795840, 8.76216320, '2024-11-06 15:46:08', '2024-11-08 17:15:55', '2024-01-01 00:00:00'),
(22, 'u7fLMY3T1P1730969562691', 'f4gFGLZZl6trtOxW7ITcFK:APA91bF2wiMSP63bbL-Vic5F1gnYFuSxhXswzaxLvtz36_iu7lJ0M39ZzyURMrnwE_Xtj7BtgV_-NIoR0pB_raqsBJBVvKBqWJ96z9vjyy9pUQzEWNZEWcc', -0.69877510, 8.76794480, '2024-11-07 09:52:42', '2024-11-08 17:34:44', '2024-01-01 00:00:00'),
(23, 'fab5NjxTQL1730970028157', 'e2CUEFbW0PoVaLhiFKH49T:APA91bHJeBKT2Cn8Dx2Ove0qARfy0VkkrggKbIoSq3UDL-KqD0sceb378EhRAFDB6u1cENwO14NheQ9C7vdBA4Vy2y9k3Sqtf9lcTqoUWlwj6VqtbcqxYxw', 0.42904930, 9.43047740, '2024-11-07 10:00:28', '2024-11-07 10:26:04', '2024-01-01 00:00:00'),
(24, 'OEJL6nW7KB1730971357229', 'etM-R2FUU2BFydF4xADoel:APA91bFaA600LupUM3gNlhF5EByPeORDoWmRCQFHoLYog9m1BPBpZNQok0LsNbxU4xOvLo8jlTGwVunJHCwNhUoxqR3I1Np33rcAfyiROBC-OJttrVf3COA', 0.42901650, 9.43051490, '2024-11-07 10:22:38', '2024-11-07 10:22:38', '2024-01-01 00:00:00'),
(25, 'uFnnGEj7TJ1730971702829', 'c5zke-W23vkKZRX1Rp4T87:APA91bF-KXbREidCJNHxv4KLUtU_nybioqhkV4Zvg2vmpkfcu5OUdMM7wNl-zIxBj94zD_eWbmh4IHCRB0JJO84IbZBmyQjLRkFH72MpK7YXSuzZ-5Gz3CM', 0.40042910, 9.45696360, '2024-11-07 10:28:23', '2024-11-08 14:25:01', '2024-01-01 00:00:00'),
(26, 'Kh8RPNQ45Z1731071738290', 'dZANOrLoOLkEieak6OW42E:APA91bHu-DmqW548WqzAiUt3R6bJhftVMKSIzXOWzSsKaBxErTU5yRfh5-dYuooc9wnY2vFfvgLsQ5QvBmrsjoGaeWrq-XBtRe4HkWIuWfbkcswnQC0-uCI', 0.40043890, 9.45684210, '2024-11-08 14:15:34', '2024-11-08 14:49:55', '2024-01-01 00:00:00'),
(27, 't6Q3OGqnoM1731072324479', 'eDS1QD0KXsN5pTKLjJFcJY:APA91bGavMmv_A72JMhhv7nhBrC2AEsnxFTWRZ6TDoxl6N6foje_X9_SvzEStEotoFXRlP7qF9O8Pxe7ktn-kYqTFJi2OUWPf9akEnzRs3JY4W5m3cor_hI', 0.40040480, 9.45692120, '2024-11-08 14:25:24', '2024-11-08 14:46:37', '2024-01-01 00:00:00'),
(28, 'vflhxsfC851731073925749', 'dgxNo3WKkp8MZdddiIYFvH:APA91bGRo9aeZECSdHrDB7SO8hKtxrM62I4-9-0K8mn7-XPQM3Jdag2PnQ580jdL-yWjj1bTxRnOKL1hpf2XQKmiBgtPekGzLzidciBTB0hOpQL3RdZCrV0', 0.40044330, 9.45685180, '2024-11-08 14:52:06', '2024-11-10 16:14:51', '2024-01-01 00:00:00'),
(29, 'MAGXBNjVJ21731073973774', 'djtP7cQUVxQ1ZArUCsV4Qb:APA91bFBCs1gga4q2KL73yGdVtTOyqoQ_B82qr2zrH_1Q1cGpGgOFhhdcgrvQdlkgko0Ewt4625bmPAQbWJfDAV6vSOJfMbE8OIWzsZSFYx3WfPby_j1tlM', 0.40047930, 9.45700770, '2024-11-08 14:52:50', '2024-11-09 11:54:07', '2024-01-01 00:00:00'),
(30, '03I64s7YIC1731083663664', 'dULPqTi5TEQGsdNz5XNtWm:APA91bHsS56RMF8Gxt7iCpAsVgSHoRBm1JXMVXII_EYb7D2qErTxkyL_UU0AgJ2K4H5Ggf5l086gNWXx3ile3WN3obd9qDiUQ0NR2CTuIAY9qwIclveK9Ko', -0.69795840, 8.76216320, '2024-11-08 17:34:24', '2024-11-11 11:26:16', '2024-01-01 00:00:00'),
(31, 'a2K48C1rEl1731083706074', 'fCKPrBMxjh0YeeuP0Ndwbd:APA91bETRW9SwiRPEe6K_sILd-duiBTmv-32grRrquT-wFPEmZmqFSz_OI2JBiguhEraO309umWq-na9ICCLNPxkQwGrQ74qihNLkDFnEYhigBjqOzpmIlg', -0.71854840, 8.74519120, '2024-11-08 17:35:06', '2024-11-09 00:07:34', '2024-01-01 00:00:00'),
(32, 'NKRITRIjWJ1731108016013', 'eigxkT9y8vjStitTYcdmgc:APA91bESJ2DDVjKX-Q-asXqJ4P1iXL8bQ15esVWg12C5-kO8vdtRaiwDTnMfOJAcTHEvuOtVlUpdOVtVe9bunlqKwxf759A2dWu1Bw4Cchn0Qzx9RDnxOAM', -0.71683130, 8.73741580, '2024-11-09 00:20:22', '2024-11-10 09:48:43', '2024-01-01 00:00:00'),
(33, 'Xjrxh1ZXRd1731157778473', 'dyUJbIOhBuTJFuqYGxfWNF:APA91bEvf61vfiHQBU57pCNWPUhrB20NXiH8QHgnlzVO1_cElYsSxqXIOwfsdCBjGg75zTCNw8RLGfAC90lMplMpW_yyHGlQAEyDt6EVhX4VM7fuIv9tzfc', 0.38010880, 9.51255040, '2024-11-09 14:09:38', '2024-11-09 19:18:43', '2024-01-01 00:00:00'),
(34, 'mTJco5HruM1731160388236', 'c7xLwNBltdatbitaElNUj6:APA91bFdhdX8_1NNbSlpozK6ANO4s0z4CJG90L6YAKnSojI8TdaNnhEk3iSxYULkJMkqjFo879UOouINj1N7nASKl_aglhcCCaFXELoEAZNu6vrGiPl170E', 0.40050670, 9.45703600, '2024-11-09 14:53:08', '2024-11-09 17:08:51', '2024-01-01 00:00:00'),
(35, 'fDQVYTSZQs1731180305718', 'c3w28dHVHFPW7KRgFwurFQ:APA91bG9w7tu7FWq2vNLLTJXx94eUL7GRRko8nme1g7oNIiLIMEk1UB56FHcY9TrElOkvfEIeb-vDuSRWeADdl5JNs1Kcw4sMBQWXJF-RtfadFdyZpWQfIs', 0.38010880, 9.51255040, '2024-11-09 20:25:06', '2024-11-09 20:25:06', '2024-01-01 00:00:00'),
(36, 'SXAakJDBN61731196393017', 'eZ5rcZYIq3iOZDkdEDv4HC:APA91bGfn7DT3giZRk3TgvP0eheHzOzHd1ZwqygO28v2AG5bmxaXMfcdaojtXCD4JcI10WDZ2vzPKaj0yJqIPdkSHEWVeP02l089RUAzs3OL95NndMnLnes', 0.39970000, 9.45630000, '2024-11-10 00:53:14', '2024-11-10 00:53:14', '2024-01-01 00:00:00'),
(37, 'nRorKLKuo41731197971164', 'ehFSbuM_OuLCwu0HfMc6pC:APA91bEya4iCK32OGt6NOoGQjd6VGnw0CTR41_mirfLUUHpawFNCHj5MrAz0vy0OSHqg134dWbc3xxMMNguGmqY1iC8IoUajgJb8Lr9eL6oT_ysNX-iK6Mc', 0.39970000, 9.45630000, '2024-11-10 01:19:32', '2024-11-10 01:19:32', '2024-01-01 00:00:00'),
(38, 'XUzxeICJvW1731200120492', 'dOCRij4u-5XcvgL9S7zUgQ:APA91bHzqYi87yKV556nfBZjhclfJD4fZXQuC9-YuHHG2eRG5IG8-tc8Um5JkVfJNtOAjj0EK4KLTEgpuRuD9nBCSDLdxuf9pyqSWKnNpwk8TVWB5d2LMA0', 0.38010880, 9.51255040, '2024-11-10 01:55:22', '2024-11-10 23:42:23', '2024-01-01 00:00:00'),
(39, '9IdOvvqvHT1731201169126', 'cOSdfjdQGfM4nexRyCh-kR:APA91bHxmLD-PZs4uWCwwNNnHwVKU32CH3pajB2eN1B_QdSmv-K7dBg9dypojnxL_s8FIRnooxjasUHdciUSTORAavO5yZknpVjWWXuRZCIH4Tiqf4gpORQ', 0.40042730, 9.45685630, '2024-11-10 02:12:50', '2024-11-10 16:16:27', '2024-01-01 00:00:00'),
(40, 'l8FW6ixPOb1731251898159', 'cjHGJS1MRbS7MDDDCaeW4Y:APA91bHNCFQLBAyh9V18IMr8AE-oszY7qLTSPGweOHMskGkG_jqLFVFa_wmdwTbkaWYi5tslIHbO9WxIw3m9HAV5yal7FQ1tqq7QbbmMUOIkq3RlxSxy8iA', 0.40037360, 9.45687930, '2024-11-10 16:18:19', '2024-11-10 16:18:19', '2024-01-01 00:00:00'),
(41, 'KJLc4uuMcQ1731251898720', 'cjHGJS1MRbS7MDDDCaeW4Y:APA91bHNCFQLBAyh9V18IMr8AE-oszY7qLTSPGweOHMskGkG_jqLFVFa_wmdwTbkaWYi5tslIHbO9WxIw3m9HAV5yal7FQ1tqq7QbbmMUOIkq3RlxSxy8iA', 0.40055940, 9.45693980, '2024-11-10 16:18:20', '2024-11-10 16:54:59', '2024-01-01 00:00:00'),
(42, 'nLFWDWEPdu1731254399201', 'cqKWMhgDa6rHSoynlWA7zr:APA91bHMNETTjYgGeLw1uJR08jA6VcVnXLBrxqPoGj63QYJkinBXLuEuIcpnDGjRbdyctQ1B7Kh92T4cpPZN7A1pSNq0Vn9R-H_fnyMvmZ9AttIzNmV3MG8', 0.40055860, 9.45699000, '2024-11-10 17:00:00', '2024-11-10 17:00:00', '2024-01-01 00:00:00'),
(43, 'r8V0JLzbSB1731254727703', 'ca_B8IxKKgEiSCYEp9ruk8:APA91bGmJDT_SrX9spgkVQLZACiOjGSc-g51zuN-V6O_3O3smf7wPk-_U3T4Qa9J4nHpNYuDSqXCvZrOviJ42qKdVTgjQZIH-qY8eoB3T8VaAt4XCayhBDI', 0.40050370, 9.45703430, '2024-11-10 17:05:29', '2024-11-10 17:07:51', '2024-01-01 00:00:00'),
(44, 'sqL5a37SCK1731254909560', 'eu4C1hIlbkYr4YbtHnYB0w:APA91bFeCC0odi_M14oeGBtAtbUAc5eUQVHB2jHY-Q7eiJ-S6RX0-97eBxj80Odw1LPl-SFTulLuVqoBlU772wvKtgkOAF0NVMZVu4KlR_0XTw4ldZGB9dU', 0.40046710, 9.45690800, '2024-11-10 17:08:31', '2024-11-10 17:13:43', '2024-01-01 00:00:00'),
(45, 'MptIuiim2C1731255273850', 'ch64Sb5xrtA65G56-7TJvV:APA91bFL1s4gPNutRDkuD3qzctxQAGrSWWHzz-V94_UsmvR-ArpuVfP1SWz6QKELpozFw1GwJtovPb9zcDzCkIFWjSZDcwvgQaaXBFBVYbuaS84e90X776g', 0.40053840, 9.45696510, '2024-11-10 17:14:35', '2024-11-10 20:13:39', '2024-01-01 00:00:00'),
(46, 'otNZEVcOOM1731266325112', 'c-i8K3kSrrPh8DYtxXDNNx:APA91bF7qVxhRcbdmz_dameLZUfvSdNxOFE-vf2Gs2Os8u0kqtlqcEtyy7Snl-vvkJfIArljX-xnNeUTt6zyXoEvrCHi0wB686wZSeGutGJ6zGSb71L9kF4', 0.40049380, 9.45704250, '2024-11-10 20:18:47', '2024-11-11 20:34:21', '2024-01-01 00:00:00'),
(47, 'PC0Zyewf811731275477867', 'ddGVB-Zp3iTVDx04yCWCOy:APA91bHf05Wnmg_yQeKMYkQk2WwB98EuVKqmf2WMfXJC0znqVrZ3sDtI9KtjHuUuDtYdKyIHe7A4sZzEfgAe80s9VPF0TrWrbZ5X_ZZCvHPNyhfAGaLmV48', 0.40045443, 9.45681160, '2024-11-10 22:51:18', '2024-11-10 23:01:22', '2024-01-01 00:00:00'),
(48, 'kwKQ3aPbhH1731319643848', 'ckinSCTxbNA5HEmvUfP7Ou:APA91bGHb53EAorllXkigcgVvjJ2_-dspB285EdjhnmZn7LYIkDPEgquB_Hun9Hr9t7B4yai14FBAiBJuAHoq2lNfKCPOKgvc3Tz9s1M2SGkE78mBnkXo34', 0.41663070, 9.45426980, '2024-11-11 11:07:24', '2024-11-12 18:22:16', '2024-01-01 00:00:00'),
(49, 'QKakQQlMIx1731320735805', 'cpAPZrnizGzJNSLA-PlW87:APA91bH3oNHZR5LkXiYYHYtPypH-yq7Vj3OxI-9QHE8DTVfjF4nInS6jc195vhbxLY_aXEgbfXlbytLJFR23LX3VshbDL3Shdk0MRT9deoHO8A4XqlW-rG0', -0.71683530, 8.73741380, '2024-11-11 11:25:36', '2024-11-15 15:26:31', '2024-01-01 00:00:00'),
(50, 'XgLSjMVr2H1731320894349', 'frx2CQ6cCHKguuvjhCngE0:APA91bE2CDdyXn5tD9n1zdUKZpf7OpxuGS99w4vbEv2K-nmGWDN6SqXriyfkO9zaUy-L9IttHsc8ltuQWQPPEGtqUBaNJB15o3G5C85x_mTP7wSE6ol1VVA', -0.69795840, 8.76216320, '2024-11-11 11:28:15', '2024-11-13 15:57:34', '2024-01-01 00:00:00'),
(51, 'ESsyOuk1021731334008160', 'cPWmnjsCDMhzlAwre7YBh4:APA91bGx8w2BIkRe6rYLsQHIkFClgjyWOal9vpbgskBGhzlmvlZWQg4r66o_hwUm9Dbo4rCl6FUAOVDVtAKAbRSEvU1rd2Fl5tttVj1CtmDRdU1PIPr8Vuk', 0.42905360, 9.43047300, '2024-11-11 15:06:49', '2024-11-11 15:06:49', '2024-01-01 00:00:00'),
(52, 'HAkBaPAkQ61731408333090', 'eVi88EGWVKPktesPgEl2lO:APA91bFkUFo7z8nnrhirZiTs-KT_K39AG2E6n6I5fhxBW_AqhkiI-3ZpFrAnoPseROSqYiTslKu0cCeEniRewXtvH1T1dO48y4h2imXPPBmod91KlGMWGo4', -0.71690000, 8.78740000, '2024-11-12 11:45:33', '2024-11-12 16:04:11', '2024-01-01 00:00:00'),
(53, 'DGJmvLda4K1731680060568', 'fh6n1GpDP7N8Jrfloux5eM:APA91bFqBTHYF1ctqdX7QYpYXef5NgqTPOEjVtXZBWuYDg_H9fnhodwO1ucMssiRSkMdiJaYbGSHuhk07pB-dsYcHIDhifjTkPBxxxGEAzcZ9lKPCiWI7Kk', -0.71681310, 8.73741550, '2024-11-15 15:14:23', '2024-11-15 15:25:40', '2024-01-01 00:00:00');

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

--
-- Structure de la table `user_interests`
--

CREATE TABLE `user_interests` (
  `id_interet` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `categorie_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `deleted_at` datetime NOT NULL DEFAULT '2024-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `user_interests` (`id_interet`, `user_id`, `categorie_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 6, '2024-10-26 19:57:20', '2024-10-26 19:57:20', '2024-01-01 00:00:00'),
(2, 1, 2, '2024-10-26 19:57:20', '2024-10-26 19:57:20', '2024-01-01 00:00:00'),
(3, 1, 3, '2024-10-26 19:57:20', '2024-10-26 19:57:20', '2024-01-01 00:00:00'),
(4, 2, 6, '2024-10-26 20:12:43', '2024-10-26 20:12:43', '2024-01-01 00:00:00'),
(5, 2, 2, '2024-10-26 20:12:43', '2024-10-26 20:12:43', '2024-01-01 00:00:00'),
(6, 2, 3, '2024-10-26 20:12:43', '2024-10-26 20:12:43', '2024-01-01 00:00:00'),
(7, 3, 6, '2024-10-26 20:17:43', '2024-10-26 20:17:43', '2024-01-01 00:00:00'),
(8, 3, 2, '2024-10-26 20:17:43', '2024-10-26 20:17:43', '2024-01-01 00:00:00'),
(9, 3, 1, '2024-10-26 20:17:43', '2024-10-26 20:17:43', '2024-01-01 00:00:00'),
(10, 4, 6, '2024-10-27 12:49:15', '2024-10-27 12:49:15', '2024-01-01 00:00:00'),
(11, 5, 4, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(12, 5, 7, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(13, 5, 8, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(14, 5, 5, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(15, 5, 6, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(16, 5, 2, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(17, 5, 3, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(18, 5, 1, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(19, 5, 9, '2024-10-27 12:52:48', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(20, 6, 6, '2024-10-28 09:15:57', '2024-10-28 09:15:57', '2024-01-01 00:00:00'),
(21, 6, 2, '2024-10-28 09:15:57', '2024-10-28 09:15:57', '2024-01-01 00:00:00'),
(22, 6, 3, '2024-10-28 09:15:57', '2024-10-28 09:15:57', '2024-01-01 00:00:00'),
(23, 7, 6, '2024-10-28 14:25:16', '2024-10-28 14:25:16', '2024-01-01 00:00:00'),
(24, 8, 6, '2024-10-29 10:17:54', '2024-10-29 10:17:54', '2024-01-01 00:00:00'),
(25, 8, 9, '2024-10-29 14:26:52', '2024-10-29 14:26:52', '2024-01-01 00:00:00'),
(26, 8, 5, '2024-10-29 14:26:52', '2024-10-29 14:26:52', '2024-01-01 00:00:00'),
(27, 8, 1, '2024-10-29 14:27:45', '2024-10-29 14:27:45', '2024-01-01 00:00:00'),
(28, 9, 6, '2024-10-30 09:27:06', '2024-10-30 09:27:06', '2024-01-01 00:00:00'),
(29, 9, 2, '2024-10-30 09:27:06', '2024-10-30 09:27:06', '2024-01-01 00:00:00'),
(30, 9, 3, '2024-10-30 09:27:06', '2024-10-30 09:27:06', '2024-01-01 00:00:00'),
(31, 10, 5, '2024-10-30 13:56:30', '2024-10-30 13:56:30', '2024-01-01 00:00:00'),
(32, 10, 6, '2024-10-30 13:56:30', '2024-10-30 13:56:30', '2024-01-01 00:00:00'),
(33, 10, 3, '2024-10-30 13:56:30', '2024-10-30 13:56:30', '2024-01-01 00:00:00'),
(34, 11, 6, '2024-10-30 14:25:38', '2024-10-30 14:25:38', '2024-01-01 00:00:00'),
(35, 11, 3, '2024-10-30 14:25:38', '2024-10-30 14:25:38', '2024-01-01 00:00:00'),
(36, 12, 6, '2024-10-30 14:29:05', '2024-10-30 14:29:05', '2024-01-01 00:00:00'),
(37, 12, 3, '2024-10-30 14:29:05', '2024-10-30 14:29:05', '2024-01-01 00:00:00'),
(38, 13, 5, '2024-10-31 09:21:38', '2024-10-31 09:21:38', '2024-01-01 00:00:00'),
(39, 13, 6, '2024-10-31 09:21:38', '2024-10-31 09:21:38', '2024-01-01 00:00:00'),
(40, 13, 3, '2024-10-31 09:21:38', '2024-10-31 09:21:38', '2024-01-01 00:00:00'),
(41, 13, 9, '2024-10-31 09:21:38', '2024-10-31 09:21:38', '2024-01-01 00:00:00'),
(42, 14, 6, '2024-11-04 10:23:52', '2024-11-04 10:23:52', '2024-01-01 00:00:00'),
(43, 14, 3, '2024-11-04 10:23:52', '2024-11-04 10:23:52', '2024-01-01 00:00:00'),
(44, 15, 4, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(45, 15, 7, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(46, 15, 8, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(47, 15, 5, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(48, 15, 6, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(49, 15, 2, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(50, 15, 3, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(51, 15, 1, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(52, 15, 9, '2024-11-04 14:05:00', '2024-11-04 14:05:00', '2024-01-01 00:00:00'),
(53, 17, 2, '2024-11-04 14:17:27', '2024-11-04 14:17:27', '2024-01-01 00:00:00'),
(54, 17, 1, '2024-11-04 14:17:27', '2024-11-04 14:17:27', '2024-01-01 00:00:00'),
(55, 18, 2, '2024-11-04 14:31:32', '2024-11-07 09:47:11', '2024-11-07 09:47:11'),
(56, 18, 1, '2024-11-04 14:31:32', '2024-11-07 09:47:11', '2024-11-07 09:47:11'),
(57, 19, 6, '2024-11-05 14:39:11', '2024-11-05 15:24:28', '2024-11-05 15:24:28'),
(58, 19, 6, '2024-11-05 15:24:29', '2024-11-05 15:24:29', '2024-01-01 00:00:00'),
(59, 19, 2, '2024-11-05 15:24:29', '2024-11-05 15:24:29', '2024-01-01 00:00:00'),
(60, 5, 4, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(61, 5, 8, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(62, 5, 5, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(63, 5, 6, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(64, 5, 2, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(65, 5, 3, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(66, 5, 1, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(67, 5, 9, '2024-11-05 15:49:34', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(68, 5, 4, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(69, 5, 8, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(70, 5, 5, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(71, 5, 6, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(72, 5, 2, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(73, 5, 3, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(74, 5, 1, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(75, 5, 9, '2024-11-05 15:49:36', '2024-11-05 15:59:07', '2024-11-05 15:59:07'),
(76, 5, 4, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(77, 5, 7, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(78, 5, 8, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(79, 5, 5, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(80, 5, 6, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(81, 5, 2, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(82, 5, 3, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(83, 5, 1, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(84, 5, 9, '2024-11-05 15:59:08', '2024-11-05 15:59:08', '2024-01-01 00:00:00'),
(85, 18, 4, '2024-11-06 12:26:09', '2024-11-07 09:47:11', '2024-11-07 09:47:11'),
(86, 18, 2, '2024-11-06 12:26:09', '2024-11-07 09:47:11', '2024-11-07 09:47:11'),
(87, 18, 3, '2024-11-06 12:26:09', '2024-11-07 09:47:11', '2024-11-07 09:47:11'),
(88, 18, 1, '2024-11-06 12:26:09', '2024-11-07 09:47:11', '2024-11-07 09:47:11'),
(89, 20, 6, '2024-11-06 14:45:52', '2024-11-06 14:45:52', '2024-01-01 00:00:00'),
(90, 21, 2, '2024-11-06 15:47:04', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(91, 21, 3, '2024-11-06 15:47:04', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(92, 21, 1, '2024-11-06 15:47:04', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(93, 21, 3, '2024-11-06 16:49:56', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(94, 18, 4, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(95, 18, 7, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(96, 18, 8, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(97, 18, 5, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(98, 18, 6, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(99, 18, 2, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(100, 18, 3, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(101, 18, 1, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(102, 18, 9, '2024-11-07 09:47:11', '2024-11-07 09:47:11', '2024-01-01 00:00:00'),
(103, 22, 4, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(104, 22, 7, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(105, 22, 8, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(106, 22, 5, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(107, 22, 6, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(108, 22, 2, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(109, 22, 3, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(110, 22, 1, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(111, 22, 9, '2024-11-07 09:53:28', '2024-11-07 09:53:28', '2024-01-01 00:00:00'),
(112, 23, 6, '2024-11-07 10:00:37', '2024-11-07 10:00:37', '2024-01-01 00:00:00'),
(113, 24, 3, '2024-11-07 10:22:47', '2024-11-07 10:22:47', '2024-01-01 00:00:00'),
(114, 25, 6, '2024-11-07 10:28:32', '2024-11-07 10:28:32', '2024-01-01 00:00:00'),
(115, 21, 6, '2024-11-07 11:39:17', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(116, 21, 2, '2024-11-07 11:39:17', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(117, 21, 3, '2024-11-07 11:39:17', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(118, 21, 1, '2024-11-07 11:39:17', '2024-11-07 16:37:12', '2024-11-07 16:37:12'),
(119, 21, 4, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(120, 21, 7, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(121, 21, 6, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(122, 21, 2, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(123, 21, 3, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(124, 21, 1, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(125, 21, 9, '2024-11-07 16:37:13', '2024-11-07 16:37:13', '2024-01-01 00:00:00'),
(126, 26, 6, '2024-11-08 14:15:47', '2024-11-08 14:15:47', '2024-01-01 00:00:00'),
(127, 27, 6, '2024-11-08 14:25:34', '2024-11-08 14:25:34', '2024-01-01 00:00:00'),
(128, 28, 6, '2024-11-08 14:52:14', '2024-11-08 16:16:26', '2024-11-08 16:16:26'),
(129, 29, 6, '2024-11-08 14:52:58', '2024-11-08 16:20:14', '2024-11-08 16:20:14'),
(130, 28, 6, '2024-11-08 16:16:27', '2024-11-08 16:16:27', '2024-01-01 00:00:00'),
(131, 28, 9, '2024-11-08 16:16:27', '2024-11-08 16:16:27', '2024-01-01 00:00:00'),
(132, 29, 6, '2024-11-08 16:20:14', '2024-11-08 16:20:14', '2024-01-01 00:00:00'),
(133, 29, 9, '2024-11-08 16:20:14', '2024-11-08 16:20:14', '2024-01-01 00:00:00'),
(134, 30, 4, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(135, 30, 7, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(136, 30, 8, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(137, 30, 5, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(138, 30, 6, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(139, 30, 2, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(140, 30, 3, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(141, 30, 1, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(142, 30, 9, '2024-11-08 17:34:40', '2024-11-08 17:34:40', '2024-01-01 00:00:00'),
(143, 31, 4, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(144, 31, 7, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(145, 31, 8, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(146, 31, 5, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(147, 31, 6, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(148, 31, 2, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(149, 31, 3, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(150, 31, 1, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(151, 31, 9, '2024-11-08 17:35:18', '2024-11-08 17:35:28', '2024-11-08 17:35:28'),
(152, 31, 4, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(153, 31, 7, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(154, 31, 8, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(155, 31, 5, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(156, 31, 6, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(157, 31, 2, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(158, 31, 3, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(159, 31, 1, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(160, 31, 9, '2024-11-08 17:35:29', '2024-11-08 17:35:29', '2024-01-01 00:00:00'),
(161, 32, 4, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(162, 32, 7, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(163, 32, 8, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(164, 32, 5, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(165, 32, 6, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(166, 32, 2, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(167, 32, 3, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(168, 32, 1, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(169, 32, 9, '2024-11-09 00:20:46', '2024-11-09 00:20:46', '2024-01-01 00:00:00'),
(170, 33, 6, '2024-11-09 14:09:51', '2024-11-09 14:09:51', '2024-01-01 00:00:00'),
(171, 33, 9, '2024-11-09 14:09:51', '2024-11-09 14:09:51', '2024-01-01 00:00:00'),
(172, 34, 9, '2024-11-09 14:53:18', '2024-11-09 14:53:18', '2024-01-01 00:00:00'),
(173, 35, 9, '2024-11-09 20:25:21', '2024-11-09 20:25:21', '2024-01-01 00:00:00'),
(174, 36, 9, '2024-11-10 01:13:38', '2024-11-10 01:13:38', '2024-01-01 00:00:00'),
(175, 37, 9, '2024-11-10 01:19:44', '2024-11-10 01:19:44', '2024-01-01 00:00:00'),
(176, 38, 6, '2024-11-10 01:55:31', '2024-11-10 01:55:31', '2024-01-01 00:00:00'),
(177, 38, 9, '2024-11-10 01:55:31', '2024-11-10 01:55:31', '2024-01-01 00:00:00'),
(178, 39, 6, '2024-11-10 02:12:59', '2024-11-10 02:12:59', '2024-01-01 00:00:00'),
(179, 39, 9, '2024-11-10 02:12:59', '2024-11-10 02:12:59', '2024-01-01 00:00:00'),
(180, 41, 9, '2024-11-10 16:18:28', '2024-11-10 16:18:28', '2024-01-01 00:00:00'),
(181, 42, 9, '2024-11-10 17:00:07', '2024-11-10 17:00:07', '2024-01-01 00:00:00'),
(182, 43, 9, '2024-11-10 17:05:37', '2024-11-10 17:05:37', '2024-01-01 00:00:00'),
(183, 44, 9, '2024-11-10 17:08:37', '2024-11-10 17:08:37', '2024-01-01 00:00:00'),
(184, 45, 9, '2024-11-10 17:14:44', '2024-11-10 17:14:44', '2024-01-01 00:00:00'),
(185, 46, 9, '2024-11-10 20:18:53', '2024-11-11 15:05:00', '2024-11-11 15:05:00'),
(186, 47, 9, '2024-11-10 22:51:47', '2024-11-10 22:51:47', '2024-01-01 00:00:00'),
(187, 48, 4, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(188, 48, 7, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(189, 48, 8, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(190, 48, 5, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(191, 48, 6, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(192, 48, 2, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(193, 48, 3, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(194, 48, 1, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(195, 48, 9, '2024-11-11 11:07:35', '2024-11-11 11:07:35', '2024-01-01 00:00:00'),
(196, 49, 4, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(197, 49, 7, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(198, 49, 8, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(199, 49, 5, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(200, 49, 6, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(201, 49, 2, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(202, 49, 3, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(203, 49, 1, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(204, 49, 9, '2024-11-11 11:25:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(205, 50, 4, '2024-11-11 11:28:38', '2024-11-11 14:01:04', '2024-11-11 14:01:04'),
(206, 50, 8, '2024-11-11 11:28:38', '2024-11-11 14:01:04', '2024-11-11 14:01:04'),
(207, 50, 6, '2024-11-11 11:28:38', '2024-11-11 14:01:04', '2024-11-11 14:01:04'),
(208, 50, 2, '2024-11-11 11:28:38', '2024-11-11 14:01:04', '2024-11-11 14:01:04'),
(209, 50, 3, '2024-11-11 11:28:38', '2024-11-11 14:01:04', '2024-11-11 14:01:04'),
(210, 50, 1, '2024-11-11 11:28:38', '2024-11-11 14:01:04', '2024-11-11 14:01:04'),
(211, 49, 4, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(212, 49, 7, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(213, 49, 8, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(214, 49, 6, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(215, 49, 2, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(216, 49, 1, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(217, 49, 9, '2024-11-11 11:50:51', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(218, 49, 4, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(219, 49, 7, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(220, 49, 8, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(221, 49, 6, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(222, 49, 2, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(223, 49, 1, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(224, 49, 9, '2024-11-11 11:56:39', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(225, 50, 4, '2024-11-11 14:01:04', '2024-11-11 14:01:04', '2024-01-01 00:00:00'),
(226, 50, 8, '2024-11-11 14:01:04', '2024-11-11 14:01:04', '2024-01-01 00:00:00'),
(227, 50, 6, '2024-11-11 14:01:04', '2024-11-11 14:01:04', '2024-01-01 00:00:00'),
(228, 50, 2, '2024-11-11 14:01:04', '2024-11-11 14:01:04', '2024-01-01 00:00:00'),
(229, 50, 3, '2024-11-11 14:01:04', '2024-11-11 14:01:04', '2024-01-01 00:00:00'),
(230, 50, 1, '2024-11-11 14:01:04', '2024-11-11 14:01:04', '2024-01-01 00:00:00'),
(231, 49, 4, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(232, 49, 7, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(233, 49, 8, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(234, 49, 5, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(235, 49, 6, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(236, 49, 2, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(237, 49, 3, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(238, 49, 1, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(239, 49, 9, '2024-11-11 14:47:42', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(240, 49, 4, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(241, 49, 7, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(242, 49, 8, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(243, 49, 5, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(244, 49, 6, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(245, 49, 2, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(246, 49, 3, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(247, 49, 1, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(248, 49, 9, '2024-11-11 14:58:26', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(249, 46, 7, '2024-11-11 15:05:01', '2024-11-11 15:05:01', '2024-01-01 00:00:00'),
(250, 46, 9, '2024-11-11 15:05:01', '2024-11-11 15:05:01', '2024-01-01 00:00:00'),
(251, 51, 7, '2024-11-11 15:06:59', '2024-11-11 15:06:59', '2024-01-01 00:00:00'),
(252, 51, 9, '2024-11-11 15:06:59', '2024-11-11 15:06:59', '2024-01-01 00:00:00'),
(253, 49, 4, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(254, 49, 7, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(255, 49, 8, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(256, 49, 5, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(257, 49, 6, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(258, 49, 2, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(259, 49, 3, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(260, 49, 1, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(261, 49, 9, '2024-11-11 15:48:21', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(262, 49, 4, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(263, 49, 7, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(264, 49, 8, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(265, 49, 5, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(266, 49, 6, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(267, 49, 2, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(268, 49, 3, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(269, 49, 1, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(270, 49, 9, '2024-11-12 10:57:41', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(271, 49, 7, '2024-11-12 11:09:24', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(272, 49, 2, '2024-11-12 11:09:24', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(273, 52, 4, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(274, 52, 7, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(275, 52, 8, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(276, 52, 5, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(277, 52, 6, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(278, 52, 2, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(279, 52, 3, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(280, 52, 1, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(281, 52, 9, '2024-11-12 11:45:50', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(282, 52, 4, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(283, 52, 7, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(284, 52, 8, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(285, 52, 5, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(286, 52, 6, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(287, 52, 2, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(288, 52, 3, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(289, 52, 1, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(290, 52, 9, '2024-11-12 11:48:39', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(291, 52, 4, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(292, 52, 7, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(293, 52, 8, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(294, 52, 5, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(295, 52, 6, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(296, 52, 2, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(297, 52, 3, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(298, 52, 1, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(299, 52, 9, '2024-11-12 15:57:56', '2024-11-12 16:01:15', '2024-11-12 16:01:15'),
(300, 52, 4, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(301, 52, 7, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(302, 52, 8, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(303, 52, 5, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(304, 52, 6, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(305, 52, 2, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(306, 52, 3, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(307, 52, 1, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(308, 52, 9, '2024-11-12 16:01:15', '2024-11-12 16:01:15', '2024-01-01 00:00:00'),
(309, 49, 4, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(310, 49, 7, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(311, 49, 8, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(312, 49, 5, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(313, 49, 6, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(314, 49, 2, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(315, 49, 3, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(316, 49, 1, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(317, 49, 9, '2024-11-12 16:03:11', '2024-11-14 23:04:19', '2024-11-14 23:04:19'),
(318, 49, 4, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(319, 49, 7, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(320, 49, 8, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(321, 49, 5, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(322, 49, 6, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(323, 49, 2, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(324, 49, 3, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(325, 49, 1, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(326, 49, 9, '2024-11-14 23:04:20', '2024-11-14 23:04:20', '2024-01-01 00:00:00'),
(327, 53, 4, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(328, 53, 7, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(329, 53, 8, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(330, 53, 6, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(331, 53, 2, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(332, 53, 3, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(333, 53, 1, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00'),
(334, 53, 9, '2024-11-15 15:14:35', '2024-11-15 15:14:35', '2024-01-01 00:00:00');

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

--
-- Index pour la table `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vendeurs_campagnes` (`vendeur_id`),
  ADD KEY `categorie_campagnes` (`categorie_id`);

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

--
-- Index pour la table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id_client`);

--
-- Index pour la table `user_interests`
--
ALTER TABLE `user_interests`
  ADD PRIMARY KEY (`id_interet`),
  ADD KEY `contrainte_client_interets` (`user_id`),
  ADD KEY `contrainte_categorie_interets` (`categorie_id`);

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

--
-- AUTO_INCREMENT pour la table `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

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

--
-- AUTO_INCREMENT pour la table `clients`
--
ALTER TABLE `clients`
  MODIFY `id_client` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT pour la table `user_interests`
--
ALTER TABLE `user_interests`
  MODIFY `id_interet` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=335;

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

--
-- Contraintes pour la table `campaigns`
--
ALTER TABLE `campaigns`
  ADD CONSTRAINT `categorie_campagnes` FOREIGN KEY (`categorie_id`) REFERENCES `categories` (`id_categorie`),
  ADD CONSTRAINT `vendeurs_campagnes` FOREIGN KEY (`vendeur_id`) REFERENCES `vendeurs` (`id_vendeur`);

--
-- Contraintes pour la table `user_interests`
--
ALTER TABLE `user_interests`
  ADD CONSTRAINT `contrainte_categorie_interets` FOREIGN KEY (`categorie_id`) REFERENCES `categories` (`id_categorie`),
  ADD CONSTRAINT `contrainte_client_interets` FOREIGN KEY (`user_id`) REFERENCES `clients` (`id_client`);
COMMIT;

