-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mar. 20 déc. 2022 à 14:17
-- Version du serveur : 5.7.33
-- Version de PHP : 8.0.10

START TRANSACTION;



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

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

--
-- Structure de la table `account_cancellation_category`
--

CREATE TABLE `account_cancellation_category` (
  `id` int(11) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `account_cancellation_report`
--

CREATE TABLE `account_cancellation_report` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `cancelled_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `cause` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `alert`
--

CREATE TABLE `alert` (
  `id` int(11) NOT NULL,
  `users_id` int(11) DEFAULT NULL,
  `profil_id` int(11) DEFAULT NULL,
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `other_content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `annonces_users`
--

CREATE TABLE `annonces_users` (
  `annonces_id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `avatar`
--

CREATE TABLE `avatar` (
  `id` int(11) NOT NULL,
  `users_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `avatar` (`id`, `users_id`, `name`) VALUES
(1, 1, '8ee34d826adb95cae282affd76299d4e.jpeg'),
(2, 2, 'd688df52ed35c2210aee7c0d4126beed.jpeg'),
(3, 3, 'c87788754f61810182cedca0ba3aa571.jpeg'),
(4, 4, 'c12ce1bf3687e436440b95e015c6c0ce.png'),
(5, 5, '8643876de0531fcf4941f35bcc388957.jpeg'),
(6, 6, 'f8c23c65b286296860cae21d5feae219.jpeg'),
(7, 7, 'fcb0c26f63d18153110e66964c9364d5.jpeg'),
(8, 8, '2cefdcb18bdcf3bc50589b844cccc9ee.jpeg'),
(9, 9, '44ce01957f22c6579d02e6a37d35f5aa.jpeg'),
(10, 10, '0827f16b88c98d48d4f27a47ac119d81.jpeg'),
(11, 11, 'c39d8d169f8d81fda57cc36913d764f7.jpeg'),
(12, 12, '9d54279fd5b9261f2961c02c9af3122f.jpeg'),
(13, 13, '21e5e577f1a949b61ad7309f96ea7b53.jpeg'),
(14, 14, '35af664f6824d04d9efd1724ce418263.jpeg'),
(15, 15, 'b59e3305afdb5c0c207b6f8d73123051.jpeg'),
(16, 16, '08f5bd23962a94e3f4c13c8d77dd8cc3.jpeg'),
(17, 17, '940e30cc7482131f6b4c33a6d2096313.jpeg'),
(18, 18, 'zajeQSkJajgpKSkUKzkwMVvuAtEcQuFHpj.Jpeg'),
(19, 19, '9qbg78r7wd3dmrv96fjtydm99rdcs79837.jpg'),
(20, 20, 'tbrrmwdsb5xc3j3d2jzcufj9vbzp22hqbu.jpg'),
(21, 21, 'rtku58q9z865hhytfz4u4ywbberqkfmsmq.png'),
(22, 22, 'y4ysr5ve38jbv5n5p25f27w3r5kwruhnps.Jpeg'),
(23, 23, 'eb758hvcjus96xc2849v5sfysmcfebtcmz.Jpeg'),
(24, 24, 'm4pyxe47hdj8tp679a62gm5362t4g7wbcj.jpg'),
(25, 25, 'enpszqstm5q2yrnnm82nar5xb4z57ygdhu.jpg');

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `slug`, `color`) VALUES
(1, 'Véhicule', 'Véhicule', NULL),
(2, 'Immobilier', 'Immobilier', NULL),
(3, 'Equipement maison', 'Equipement maison', NULL),
(4, 'Mode', 'Mode', NULL),
(5, 'Multimédia', 'Multimédia', NULL),
(6, 'Loisirs', 'Loisirs', NULL),
(7, 'Matériel professionnel', 'Matériel professionnel', NULL),
(8, 'Services', 'Services', NULL);

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

--
-- Structure de la table `city`
--

CREATE TABLE `city` (
  `id` int(11) NOT NULL,
  `regions_id` int(11) DEFAULT NULL,
  `countries_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `city` (`id`, `regions_id`, `countries_id`, `name`) VALUES
(1, 1, 1, 'Limbé'),
(2, 2, 1, 'Douala'),
(3, 3, 1, 'Yaoundé'),
(4, 4, 2, 'Brazzaville'),
(5, 4, 2, 'Pointe noire'),
(6, 5, 2, 'Djambala'),
(7, 6, 2, 'Imphondo'),
(8, 7, 4, 'Libreville'),
(9, 8, 4, 'Franceville'),
(10, 9, 4, 'Port-Gentil');

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

--
-- Structure de la table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `profil_id` int(11) DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `rating` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `indicatif` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `countries` (`id`, `indicatif`, `name`) VALUES
(1, '+237', 'Cameroun'),
(2, '+242', 'Congo Brazzaville'),
(3, '+243', 'Congo (RDC)'),
(4, '+241', 'Gabon');

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

--
-- Structure de la table `districts`
--

CREATE TABLE `districts` (
  `id` int(11) NOT NULL,
  `regions_id` int(11) NOT NULL,
  `countries_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `districts` (`id`, `regions_id`, `countries_id`, `name`) VALUES
(1, 1, 1, 'Ngeme'),
(2, 1, 1, 'Boana'),
(3, 1, 1, 'Boto Land'),
(4, 2, 1, 'New-Bell'),
(5, 2, 1, 'Bonaberi'),
(6, 2, 1, 'Ndokotti'),
(7, 2, 1, 'Ndogbong'),
(8, 2, 1, 'Bonamoussadi'),
(9, 2, 1, 'Bonadjo'),
(10, 2, 1, 'Cité des palmiers'),
(11, 2, 1, 'Bepanda'),
(12, 3, 1, 'Mokolo'),
(13, 3, 1, 'Mvog.Mbi'),
(14, 3, 1, 'Bastos'),
(15, 4, 2, 'Poto-Poto'),
(16, 4, 2, 'Moungali'),
(17, 4, 2, 'Bacongo'),
(18, 4, 2, 'Talangaï'),
(19, 4, 2, 'Milou'),
(20, 4, 2, 'Makélékélé'),
(21, 4, 2, 'Ouenzé'),
(22, 4, 2, 'Djiri'),
(23, 4, 2, 'Nkouikou'),
(24, 4, 2, 'Mongo Mpoukou'),
(25, 4, 2, 'Tié-Tié'),
(26, 4, 2, 'Loandjili'),
(27, 4, 2, 'Mvoumvou'),
(28, 4, 2, 'Lumumba'),
(29, 4, 2, 'Mpaka'),
(30, 7, 4, 'Petro Owendo'),
(31, 7, 4, 'Carrefour Léon Mba'),
(32, 8, 4, 'Potosse'),
(33, 9, 4, 'Bac aviation'),
(34, 9, 4, 'grand village'),
(35, 9, 4, 'Balise'),
(36, 9, 4, 'Carrefour Chic'),
(37, 7, 4, 'Zeng ayong'),
(38, 7, 4, 'Nombamkele'),
(39, 7, 4, 'Okala'),
(40, 7, 4, 'Sablière'),
(42, 8, 4, 'Corniche 1');

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

--
-- Structure de la table `doctrine_migration_versions`
--

CREATE TABLE `doctrine_migration_versions` (
  `version` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `doctrine_migration_versions` (`version`, `executed_at`, `execution_time`) VALUES
('DoctrineMigrations\\Version20221217123635', '2022-12-17 12:36:44', 6584);

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

--
-- Structure de la table `idea`
--

CREATE TABLE `idea` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `images`
--

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `annonces_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `images` (`id`, `annonces_id`, `name`) VALUES
(1, 1, '03ccb7798958efa07736fdd9d63f9557.jpeg'),
(2, 1, '65faf03a451818b221e90e9efa8ddeeb.jpeg'),
(3, 1, '20a0183e333553d5a854e60db8490c43.jpeg'),
(4, 1, '5658f65350bb67ff1efc2f69f375eff6.jpeg'),
(5, 2, 'c8a1795795da670311b29944fc07b281.jpeg'),
(6, 2, 'c76c7d0916e2b7da98e031696fb054a7.jpeg'),
(7, 2, '3606b6e19f0bf6b09a63c65c51c71f7b.jpeg'),
(8, 3, '172c76d2b7da29bbd60efeab378bf246.jpeg'),
(9, 3, '290e975b73a35e0303120e68adf256d8.jpeg'),
(10, 3, 'f03af6b2299262ffdb5e518bc7c56cc5.jpeg'),
(11, 3, '31458dc30f5bbe53670cb9f74e0c1c9f.jpeg'),
(12, 4, '910ec0b57efa994ce341b8800458b59c.jpeg'),
(13, 4, '868e26f95c1babe9df6e509a22f19638.jpeg'),
(14, 4, '9b8594cf04a942ba9de357dd789595f0.jpeg'),
(15, 4, '32c1023a8d99e96d30da52db4046f7a8.jpeg'),
(16, 4, 'bdd8a3781709dfc178a7177113e515e0.jpeg'),
(17, 5, '6116f098ede50c8d72715fa748cc9e8b.jpeg'),
(18, 5, '878bc8772f49823b40e7b6eb948d4d59.jpeg'),
(19, 5, 'f37bd8f3d33ea03c36cd014f10bed827.jpeg'),
(20, 6, '204481a9c886fcb5227407bbf4d202b7.jpeg'),
(21, 6, 'f0f5c384a8f672f33d3fb1a10adcb657.jpeg'),
(22, 6, '913b21c686ebd95800c107d99a22fc6c.jpeg'),
(23, 6, '6fa89d9172fccc74f9ccd74bae465923.jpeg'),
(24, 7, '0237637674c38f9ace853fdd3bca89a9.jpeg'),
(25, 7, 'ad1b13d02ccaf6221e5442ce7575c93e.jpeg'),
(26, 7, 'd447b9a2326e4143c601a4a69b14eed2.jpeg'),
(27, 7, '9259be75b9fa41473543194f75a9b613.jpeg'),
(28, 8, '17487b7470f7103adb3863054c373423.jpeg'),
(29, 8, '92382e930a36434634eec14579a99b1e.jpeg'),
(30, 8, '488ea7c65e4fc06114b6504bd144aad2.jpeg'),
(31, 8, '0b80ad332a6123f2cb6e7b9b416ecdde.jpeg'),
(32, 8, 'e8940bbc84991a9713edbd8bbc617a63.jpeg'),
(33, 9, '9430cb0a399f23bb6bb0d55bb8c5f179.jpeg'),
(34, 9, 'e2b2f85c5adfb1607d95e3d0a64a13db.jpeg'),
(35, 9, '4e64ce0697cdd3b1fc6bb09944a0766c.jpeg'),
(36, 9, '69ba2a2bbce1502ad0cbc3ed5d6ed00e.jpeg'),
(37, 9, 'abfe5d2f4556b725aeb101d45e4e9f1f.jpeg'),
(38, 9, '1819003a46689d8ad90ca87d2639715a.jpeg'),
(40, 11, 'aaa0f5eac37c0246f44eb97535b71376.jpeg'),
(41, 11, '2dd31639005efaa3e65960fe13143985.jpeg'),
(42, 11, '82147181ccbd70eef43746e810605395.jpeg'),
(43, 11, '00de7617616aa98aa28362f1249666ed.jpeg'),
(44, 12, '799e068588f3c98e7ab5097d7ac08bda.jpeg'),
(45, 12, '5d66f2905222a4936f1e8bca7b9cbbdf.jpeg'),
(46, 13, '2fea137cd143765abec7ea38ef0b77b1.jpeg'),
(47, 13, '47b0d710bbdb68fa61212937b22149f6.jpeg'),
(48, 13, 'a54f3af91cc27e1e02038e4faff887ab.jpeg'),
(49, 13, 'dcf6e774407d0643ab3864ce444a5c18.jpeg'),
(50, 13, '6f044c9e677cffe275f30fe7aa97da57.jpeg'),
(51, 13, 'bb7d0e924c921e87d2bc2c5c688cb547.jpeg'),
(52, 13, 'b3949e9cc5e74ae8ee418ec3ce5d0964.jpeg'),
(53, 14, 'ade666c80306ea2fb5a3666faf243792.jpeg'),
(54, 14, '68855e06a8d4f692b9cd5331de964546.jpeg'),
(55, 14, '71eadc0de85f7304982ccc0715083de7.jpeg'),
(56, 14, 'd1e617d6b81a0e31b4552655ef4500bc.jpeg'),
(57, 14, 'f5ed92bb79f646b6cd28d6ce4cc8d2ca.jpeg'),
(58, 15, '705370fa20597e1ce2bc8e05b494932b.jpeg'),
(59, 15, '7423076b709ddc065043bb37c4d575ff.jpeg'),
(60, 15, '61c3fb5474040f47e675153f0bd17fac.jpeg'),
(61, 15, 'ac495a5d7e12c128e2a5533bf08fcb64.jpeg'),
(62, 16, '0e61b1227ebc30d50139edf8f745b6e1.jpeg'),
(63, 16, '73b5fc6747fb4d16684df7ec248f4179.jpeg'),
(64, 16, '851a05184f2cabde1f1f0512bea7970c.jpeg'),
(65, 16, '60109d1d0730ec779b261085cbbb7096.jpeg'),
(66, 16, '1403e4a80525ecccfd8b3fdcc5c50e45.jpeg'),
(147, 17, 'ce6575ad03306b777b26e1336c2b42b8.jpeg'),
(148, 17, '833a3fe74d09c05e60859450e3573715.jpeg'),
(149, 17, 'da6b41024b81272ed3071f5ac59d634d.jpeg'),
(150, 17, 'bb1535d42025e7ace0d76174ff7d14e1.jpeg'),
(151, 17, '68391c8764d813a52823f10e50fb83c9.jpeg'),
(152, 18, '98fbe298e9388b3932cb91b11763046a.jpeg'),
(153, 18, 'f759f9f1b0ed92edeb14ea3eb832ee00.jpeg'),
(154, 18, '53cfd5991cf76573d5d6aee8c3c696cf.jpeg'),
(155, 19, '7775880c0d94a18c4cff2a8bf47484e9.jpeg'),
(156, 19, 'bd518b2a419fa412599f2dcaf733ec58.jpeg'),
(157, 19, '1a897c477c2067fa91c84fcbcad4b694.jpeg'),
(158, 19, 'd68d837ec55dc10e08d05597e98095e6.jpeg'),
(159, 20, '60d06a317451063ab380de495586883e.jpeg'),
(160, 20, '27c1e8f00a9716d8e0042f0c61060087.jpeg'),
(161, 20, 'e04934921acd9887d7416d1612f0c2c9.jpeg'),
(162, 20, 'f0627b02d6f210614973c260804f8d28.jpeg'),
(163, 21, '49da57562ad123d69184e8f3cd263b4e.jpeg'),
(164, 21, 'a5f021d9213a289531f054c988701803.jpeg'),
(165, 21, '0466d4e2ccb17f99adc5576a19632549.jpeg'),
(166, 21, 'b2c84fd11ee5b531dbd49b19a553239b.jpeg'),
(167, 21, 'fcd5a55c010d33768a09ecb4add0a4f5.jpeg'),
(168, 22, 'bf33a39ce9e8b8c8940db293341f86b8.jpeg'),
(169, 22, 'e3edd326f2e42dbece20f56c0234dc53.jpeg'),
(170, 22, '8cefbf06dae1a85d8c90d5a0879765db.jpeg'),
(171, 23, 'c6618540f81cac90ed1fb101584dc4d0.jpeg'),
(172, 23, 'aa6fed238af41462138a22bfa3abe559.jpeg'),
(173, 23, 'aaefe9586195215ba43b98ff5940f055.jpeg'),
(174, 23, 'd6c303ae413350fdfc5e022fcd49b3ca.jpeg'),
(175, 23, 'd41f6eaf71f2ab180f959ea0aba32723.jpeg'),
(176, 24, '6129daba8499df745eb974e29102bc63.jpeg'),
(177, 24, '80f038cda855e06ad5a32e2c4c13117d.jpeg'),
(178, 24, 'f0f69f03369fb88bd51620b1eebc1577.jpeg'),
(179, 24, '73114bb186b76da58a7207a216509ed4.jpeg'),
(180, 25, '9a9357ed350796f05f2b0daa3bc19af8.jpeg'),
(181, 25, 'b98264953a98c2992beee86474437914.jpeg'),
(182, 25, 'ff075d1effafd333d0b8d230dc0c366c.jpeg'),
(183, 25, 'c354a5f250fdaf547a4a5967560ed19e.jpeg'),
(184, 26, 'e528f3f84e94fd286eeb75acbc088ad9.jpeg'),
(185, 26, 'efdfc2a619046c21bc3d53f96aa7b6a4.jpeg'),
(186, 26, 'e2a47d7ea81485e58101ea7bf147dc7a.jpeg'),
(187, 26, '02ea613983e92f71af958196911621cf.jpeg'),
(188, 26, '8d4fe253e611d310516a1024fd11be2d.jpeg'),
(189, 26, 'e5fd9129117ffd52182a29f281ac6ce6.jpeg'),
(190, 27, 'b373845032b4e92b67468d96b1a3a1d1.jpeg'),
(191, 27, 'deeb78cf9d40c00baf0f99e193b6c1bf.jpeg'),
(192, 27, 'b0c63ba43ba1da1d55c44b1006538bcc.jpeg'),
(193, 28, '1955f1010b94c8c6a095ae5240ecd763.jpeg'),
(194, 28, 'b81ec176a94d53f86c31d001c9ce1d23.jpeg'),
(195, 28, '1ff06e9c1a6e4e1702333440cf0be1b0.jpeg'),
(196, 28, '5370b3cc10df27ab49a98e8aba037e84.jpeg'),
(197, 28, '2060806bc0dec0f96058f99edf863565.jpeg'),
(198, 29, '3d70536fb8f6ac9646b6362b915cdc9e.jpeg'),
(199, 29, '578883585b7fe92b5ead058e4c9c7fcb.jpeg'),
(200, 29, '4b8749d22967c99f238b89f7d96e0043.jpeg'),
(201, 29, 'ff5370010fcc0bff34f7d67a0a19b24f.jpeg'),
(202, 30, 'e729b74d52495b7c72ed9a3bdf0192e8.jpeg'),
(203, 30, '1c56c7e3d97e9f599e20e5dd832dd1ca.jpeg'),
(204, 30, '3c7cbcb48b6b48b426dff6a3487734ab.jpeg'),
(205, 30, 'b67ffe30c8eb97bae132034d9aca0e7e.jpeg'),
(206, 30, 'bd706d802d917b7a18fc732b50920e50.jpeg'),
(207, 30, 'ac081b9d87499749b923cb3b3b972ffc.jpeg'),
(208, 31, '0b80ad332a6123f2cb6e7b9b416ecdde.jpeg'),
(209, 32, 'e8940bbc84991a9713edbd8bbc617a63.jpeg'),
(210, 33, '9430cb0a399f23bb6bb0d55bb8c5f179.jpeg'),
(211, 34, 'e2b2f85c5adfb1607d95e3d0a64a13db.jpeg');

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

--
-- Structure de la table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL,
  `profil_id` int(11) DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `is_read` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `preuve_img`
--

CREATE TABLE `preuve_img` (
  `id` int(11) NOT NULL,
  `signals_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `publicity`
--

CREATE TABLE `publicity` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `regions`
--

CREATE TABLE `regions` (
  `id` int(11) NOT NULL,
  `countries_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `regions` (`id`, `countries_id`, `name`) VALUES
(1, 1, 'Sud-Ouest '),
(2, 1, 'Littoral'),
(3, 1, 'Centre'),
(4, 2, 'Pool'),
(5, 2, 'Les plateaux'),
(6, 2, 'Likouala'),
(7, 4, 'Estuaire'),
(8, 4, 'Haut-Ogooué'),
(9, 4, 'Ogooué-Maritime ');

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

--
-- Structure de la table `save`
--

CREATE TABLE `save` (
  `id` int(11) NOT NULL,
  `annonce_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `signal_litige`
--

CREATE TABLE `signal_litige` (
  `id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL,
  `profil_id` int(11) DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `type_of_arnaque` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `statut`
--

CREATE TABLE `statut` (
  `id` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `statut` (`id`, `type`, `content`, `color`) VALUES
(1, 0, 'Personne dont l\'intérêt est principalement axé sur la recherche d\'offre. Ne déposant des offres que lorsque l\'occasion se présente de mettre à disposition, des biens dont ils sont propriétaires (Téléphone portable, veste …), ou des compétences techniques sous forme de service, sans structure ou lieu fixe (Coiffeur(se) à domicile, mécanicien(ne) …).', NULL),
(2, 0, 'Personne(s) déposants des offres en lien direct avec leur activité professionnelle, et ayant une structure ou lieu pour l’exercer. \r\n(Vendeur(se) de vêtement, magasin d\'électronique, mais aussi hôtel, restaurant, garage …)\r\n\r\n\r\n\r\n', NULL);

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

--
-- Structure de la table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `slug`) VALUES
(1, 1, 'Voitures', 'Voitures'),
(2, 1, 'Motos', 'Motos'),
(3, 1, 'Utilitaires', 'Utilitaires'),
(4, 1, 'Camions', 'Camions'),
(5, 1, 'Nautisme', 'Nautisme'),
(6, 1, 'Equipement auto\r\n', 'Equipement auto\r\n'),
(7, 1, 'Equipement moto\r\n', 'Equipement moto\r\n'),
(8, 1, 'Equipement nautisme   \r\n', 'Equipement nautisme   \r\n'),
(9, 2, 'Terrain', 'Terrain'),
(10, 2, 'Vente', 'Vente'),
(11, 2, 'Location', 'Location'),
(12, 2, 'Colocation', 'Colocation'),
(13, 3, 'Electroménagé\r\n', 'Electroménagé\r\n'),
(14, 3, 'Meuble', 'Meuble'),
(15, 3, 'Vaisselle', 'Vaisselle'),
(16, 3, 'Décoration', 'Décoration'),
(17, 3, 'Bricolage', 'Bricolage'),
(18, 3, 'Jardinage', 'Jardinage'),
(19, 4, 'Chaussures', 'Chaussures'),
(20, 4, 'Vêtements', 'Vêtements'),
(21, 4, 'Accessoires & Bagagerie', 'Accessoires & Bagagerie'),
(22, 4, 'Montres & Bijoux', 'Montres & Bijoux'),
(23, 4, 'Equipement bébé', 'Equipement bébé'),
(24, 4, 'Vêtements bébé', 'Vêtements bébé'),
(25, 4, 'Luxe & Tendance', 'Luxe & Tendance'),
(26, 5, 'Informatique\r\n', 'Informatique\r\n'),
(27, 5, 'Console & Jeux vidéo', 'Console & Jeux vidéo'),
(28, 5, 'Image & Son', 'Image & Son'),
(29, 5, 'Téléphonie', 'Téléphonie'),
(30, 6, 'DVD & blu-ray - Film', 'DVD & blu-ray - Film'),
(31, 6, 'CD - Musique', 'CD - Musique'),
(32, 6, 'Livres', 'Livres'),
(33, 6, 'deplacement pietons (Vélos, trottinette ...)', 'deplacement pietons (Vélos, trottinette ...)'),
(34, 6, 'Sports & Hobbies', 'Sports & Hobbies'),
(35, 6, 'Instruments de musique', 'Instruments de musique'),
(36, 6, 'Collection', 'Collection'),
(37, 6, 'Jeux & Jouets', 'Jeux & Jouets'),
(38, 7, 'Matériel agricole', 'Matériel agricole'),
(39, 7, 'Transport - Manutention', 'Transport - Manutention'),
(40, 7, 'BTP - Chantier gros-oeuvre', 'BTP - Chantier gros-oeuvre'),
(41, 7, 'Restauration - Hôtellerie', 'Restauration - Hôtellerie'),
(42, 7, 'Fournitures de bureau\r\n', 'Fournitures de bureau\r\n'),
(43, 7, 'Commerces & Marchés', 'Commerces & Marchés'),
(44, 8, 'Cours particuliers\r\n', 'Cours particuliers\r\n'),
(45, 8, 'Covoiturage', 'Covoiturage');

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

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

--
-- Index pour la table `account_cancellation_report`
--
ALTER TABLE `account_cancellation_report`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C6771D3512469DE2` (`category_id`);

--
-- Index pour la table `alert`
--
ALTER TABLE `alert`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_17FD46C167B3B43D` (`users_id`),
  ADD KEY `IDX_17FD46C1275ED078` (`profil_id`);

--
-- Index pour la table `annonces_users`
--
ALTER TABLE `annonces_users`
  ADD PRIMARY KEY (`annonces_id`,`users_id`),
  ADD KEY `IDX_F60119834C2885D7` (`annonces_id`),
  ADD KEY `IDX_F601198367B3B43D` (`users_id`);

--
-- Index pour la table `avatar`
--
ALTER TABLE `avatar`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_1677722F67B3B43D` (`users_id`);

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

--
-- Index pour la table `city`
--
ALTER TABLE `city`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_2D5B0234FCE83E5F` (`regions_id`),
  ADD KEY `IDX_2D5B0234AEBAE514` (`countries_id`);

--
-- Index pour la table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_5F9E962A67B3B43D` (`users_id`),
  ADD KEY `IDX_5F9E962A727ACA70` (`parent_id`),
  ADD KEY `IDX_5F9E962A275ED078` (`profil_id`);

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

--
-- Index pour la table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_68E318DCFCE83E5F` (`regions_id`),
  ADD KEY `IDX_68E318DCAEBAE514` (`countries_id`);

--
-- Index pour la table `doctrine_migration_versions`
--
ALTER TABLE `doctrine_migration_versions`
  ADD PRIMARY KEY (`version`);

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

--
-- Index pour la table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E01FBE6A4C2885D7` (`annonces_id`);

--
-- Index pour la table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_DB021E9667B3B43D` (`users_id`),
  ADD KEY `IDX_DB021E96275ED078` (`profil_id`);

--
-- Index pour la table `preuve_img`
--
ALTER TABLE `preuve_img`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_B6894F457073AAEB` (`signals_id`);

--
-- Index pour la table `publicity`
--
ALTER TABLE `publicity`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_938127612469DE2` (`category_id`);

--
-- Index pour la table `regions`
--
ALTER TABLE `regions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_A26779F3AEBAE514` (`countries_id`);

--
-- Index pour la table `save`
--
ALTER TABLE `save`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_55663ADE8805AB2F` (`annonce_id`),
  ADD KEY `IDX_55663ADEA76ED395` (`user_id`);

--
-- Index pour la table `signal_litige`
--
ALTER TABLE `signal_litige`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_4D9A7BAA67B3B43D` (`users_id`),
  ADD KEY `IDX_4D9A7BAA275ED078` (`profil_id`);

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

--
-- Index pour la table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_1638D5A512469DE2` (`category_id`);

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

--
-- AUTO_INCREMENT pour la table `account_cancellation_report`
--
ALTER TABLE `account_cancellation_report`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `alert`
--
ALTER TABLE `alert`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `avatar`
--
ALTER TABLE `avatar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

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

--
-- AUTO_INCREMENT pour la table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT pour la table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT pour la table `idea`
--
ALTER TABLE `idea`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=212;

--
-- AUTO_INCREMENT pour la table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `preuve_img`
--
ALTER TABLE `preuve_img`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `publicity`
--
ALTER TABLE `publicity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT pour la table `save`
--
ALTER TABLE `save`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `signal_litige`
--
ALTER TABLE `signal_litige`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `statut`
--
ALTER TABLE `statut`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

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

--
-- Contraintes pour la table `account_cancellation_report`
--
ALTER TABLE `account_cancellation_report`
  ADD CONSTRAINT `FK_C6771D3512469DE2` FOREIGN KEY (`category_id`) REFERENCES `account_cancellation_category` (`id`);

--
-- Contraintes pour la table `alert`
--
ALTER TABLE `alert`
  ADD CONSTRAINT `FK_17FD46C1275ED078` FOREIGN KEY (`profil_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `FK_17FD46C167B3B43D` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `annonces_users`
--
ALTER TABLE `annonces_users`
  ADD CONSTRAINT `FK_F60119834C2885D7` FOREIGN KEY (`annonces_id`) REFERENCES `annonces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_F601198367B3B43D` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `avatar`
--
ALTER TABLE `avatar`
  ADD CONSTRAINT `FK_1677722F67B3B43D` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `city`
--
ALTER TABLE `city`
  ADD CONSTRAINT `FK_2D5B0234AEBAE514` FOREIGN KEY (`countries_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_2D5B0234FCE83E5F` FOREIGN KEY (`regions_id`) REFERENCES `regions` (`id`);

--
-- Contraintes pour la table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `FK_5F9E962A275ED078` FOREIGN KEY (`profil_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `FK_5F9E962A67B3B43D` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `FK_5F9E962A727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `comments` (`id`);

--
-- Contraintes pour la table `districts`
--
ALTER TABLE `districts`
  ADD CONSTRAINT `FK_68E318DCAEBAE514` FOREIGN KEY (`countries_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_68E318DCFCE83E5F` FOREIGN KEY (`regions_id`) REFERENCES `regions` (`id`);

--
-- Contraintes pour la table `images`
--
ALTER TABLE `images`
  ADD CONSTRAINT `FK_E01FBE6A4C2885D7` FOREIGN KEY (`annonces_id`) REFERENCES `annonces` (`id`);

--
-- Contraintes pour la table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `FK_DB021E96275ED078` FOREIGN KEY (`profil_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `FK_DB021E9667B3B43D` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `preuve_img`
--
ALTER TABLE `preuve_img`
  ADD CONSTRAINT `FK_B6894F457073AAEB` FOREIGN KEY (`signals_id`) REFERENCES `signal_litige` (`id`);

--
-- Contraintes pour la table `publicity`
--
ALTER TABLE `publicity`
  ADD CONSTRAINT `FK_938127612469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Contraintes pour la table `regions`
--
ALTER TABLE `regions`
  ADD CONSTRAINT `FK_A26779F3AEBAE514` FOREIGN KEY (`countries_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `save`
--
ALTER TABLE `save`
  ADD CONSTRAINT `FK_55663ADE8805AB2F` FOREIGN KEY (`annonce_id`) REFERENCES `annonces` (`id`),
  ADD CONSTRAINT `FK_55663ADEA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `signal_litige`
--
ALTER TABLE `signal_litige`
  ADD CONSTRAINT `FK_4D9A7BAA275ED078` FOREIGN KEY (`profil_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `FK_4D9A7BAA67B3B43D` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD CONSTRAINT `FK_1638D5A512469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);
COMMIT;

