-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `caps`
--

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

--
-- Table structure for table `attachmentable`
--

CREATE TABLE `attachmentable` (
  `id` int(10) UNSIGNED NOT NULL,
  `attachmentable_type` varchar(255) NOT NULL,
  `attachmentable_id` int(10) UNSIGNED NOT NULL,
  `attachment_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `collection_points`
--

CREATE TABLE `collection_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `wilaya` smallint(6) NOT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `collection_points`
--

INSERT INTO `collection_points` (`id`, `wilaya`, `details`, `created_at`, `updated_at`) VALUES
(4, 1, 'Pas encore de point de dépôt', '2021-03-19 18:14:40', '2021-10-07 17:05:33'),
(5, 2, 'Pas encore de point de dépôt', '2021-03-19 18:15:01', '2021-10-07 17:13:21'),
(6, 3, 'Pas encore de point de dépôt', '2021-03-19 18:15:19', '2021-10-07 17:13:27'),
(7, 4, 'Pas encore de point de dépôt', '2021-03-19 18:15:32', '2021-10-07 17:13:33'),
(8, 5, 'Pas encore de point de dépôt', '2021-03-19 18:15:43', '2021-10-07 17:13:39'),
(9, 6, 'Pas encore de point de dépôt', '2021-03-19 18:15:56', '2021-10-07 17:13:44'),
(10, 7, 'Pas encore de point de dépôt', '2021-03-19 18:16:07', '2021-10-07 17:13:50'),
(11, 8, 'Pas encore de point de dépôt', '2021-03-19 18:16:17', '2021-10-07 17:13:56'),
(12, 9, 'Pas encore de point de dépôt', '2021-03-19 18:16:31', '2021-10-07 17:14:08'),
(13, 10, 'Pas encore de point de dépôt', '2021-03-19 18:16:46', '2021-10-07 17:20:39'),
(14, 11, 'Nous contacter en privé', '2021-03-19 18:16:58', '2021-03-19 18:16:58'),
(15, 12, 'Nous contacter en privé', '2021-03-19 18:17:12', '2021-03-19 18:17:12'),
(16, 13, 'Tulipe Violette a les dalias el kiffen tel 043 268 512 TLEMCEN', '2021-03-19 18:17:51', '2021-03-19 18:17:51'),
(17, 14, '06 59 61 15 07', '2021-03-19 18:18:01', '2021-03-19 18:18:01'),
(18, 15, 'Pas encore de point de dépôt', '2021-03-19 18:18:17', '2021-10-07 17:14:19'),
(19, 16, '0551 58 58 23 / 0661 960 120 / 0779 17 40 76', '2021-03-19 18:18:33', '2021-03-19 18:18:33'),
(20, 17, 'Nous contacter en privé', '2021-03-19 18:18:49', '2021-03-19 18:18:49'),
(21, 18, 'Nous contacter en privé', '2021-03-19 18:18:56', '2021-03-19 18:18:56'),
(22, 19, 'Nous contacter en privé', '2021-03-19 18:19:05', '2021-03-19 18:19:05'),
(23, 20, '05 51 90 13 89', '2021-03-19 18:19:20', '2021-03-19 18:19:20'),
(24, 21, '07 72 01 73 61\r\nhttps://www.facebook.com/groups/388341482512955', '2021-03-19 18:19:39', '2021-03-19 18:19:39'),
(25, 22, 'https://www.facebook.com/groups/354266252210967/', '2021-03-19 18:20:11', '2021-03-19 18:20:11'),
(26, 23, 'https://www.facebook.com/groups/199691234639567/', '2021-03-19 18:20:30', '2021-03-19 18:20:30'),
(27, 24, '05 52 49 70 53', '2021-03-19 18:21:17', '2021-03-19 18:21:17'),
(28, 25, 'https://www.facebook.com/groups/654433348752998/', '2021-03-19 18:21:37', '2021-03-19 18:21:37'),
(29, 26, 'Nous contacter en privé', '2021-03-19 18:21:53', '2021-03-19 18:21:53'),
(30, 27, 'Nous contacter en privé', '2021-03-19 18:22:04', '2021-03-19 18:22:04'),
(31, 28, 'Nous n\'avons pas de bénévole', '2021-03-19 18:22:33', '2021-03-19 18:22:33'),
(32, 29, '06 59 42 49 89', '2021-03-19 18:22:44', '2021-03-19 18:22:44'),
(33, 30, 'Nous contacter en privé', '2021-03-19 18:23:05', '2021-03-19 18:23:05'),
(34, 31, 'https://www.facebook.com/groups/223080739277009', '2021-03-19 18:23:49', '2021-03-19 18:23:49'),
(35, 32, 'https://www.facebook.com/groups/163256131673397/', '2021-03-19 18:24:04', '2021-03-19 18:24:04'),
(36, 33, 'Nous n\'avons pas de bénévole', '2021-03-19 18:24:20', '2021-03-19 18:24:20'),
(37, 34, 'Nous contacter en privé', '2021-03-19 18:24:38', '2021-03-19 18:24:38'),
(38, 35, 'Nous contacter en privé', '2021-03-19 18:24:44', '2021-03-19 18:24:44'),
(39, 36, 'Nous contacter en privé', '2021-03-19 18:24:51', '2021-03-19 18:24:51'),
(40, 37, 'Nous n\'avons pas de bénévole', '2021-03-19 18:28:06', '2021-03-19 18:28:06'),
(41, 38, 'Nous contacter en privé', '2021-03-19 18:28:30', '2021-03-19 18:28:30'),
(42, 39, 'Nous contacter en privé', '2021-03-19 18:28:38', '2021-03-19 18:28:38'),
(43, 40, 'Nous contacter en privé', '2021-03-19 18:28:44', '2021-03-19 18:28:44'),
(44, 41, 'Nous contacter en privé', '2021-03-19 18:28:54', '2021-03-19 18:28:54'),
(45, 42, 'Nous contacter en privé', '2021-03-19 18:29:02', '2021-03-19 18:29:02'),
(46, 43, '05 58 27 45 72', '2021-03-19 18:29:13', '2021-03-19 18:29:13'),
(47, 44, 'Nous contacter en privé', '2021-03-19 18:29:24', '2021-03-19 18:29:24'),
(48, 45, 'Nous contacter en privé', '2021-03-19 18:29:29', '2021-03-19 18:29:29'),
(49, 46, '05 55 65 42 22', '2021-03-19 18:30:28', '2021-03-19 18:30:28'),
(50, 47, 'https://www.facebook.com/Enl.kbe', '2021-03-19 18:30:58', '2021-03-19 18:33:12'),
(51, 48, 'Nous contacter en privé', '2021-03-19 18:31:22', '2021-03-19 18:31:22');

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_messages`
--

INSERT INTO `contact_messages` (`id`, `name`, `email`, `message`, `seen`, `created_at`, `updated_at`) VALUES
(1, 'Atik Meryem', 'atikmrm@gmail.com', 'Enfant Lune cherche pommade daylong', 1, '2021-03-10 18:35:48', '2021-10-12 08:01:11');

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

--
-- Table structure for table `donations`
--

CREATE TABLE `donations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `donor_id` bigint(20) NOT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `volunteer_id` bigint(20) DEFAULT NULL,
  `address` text NOT NULL,
  `wilaya` smallint(6) NOT NULL,
  `city` varchar(255) NOT NULL,
  `coordinates` text DEFAULT NULL,
  `quantity` text NOT NULL,
  `sorted` tinyint(1) NOT NULL,
  `status` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donations`
--

INSERT INTO `donations` (`id`, `donor_id`, `created_by`, `volunteer_id`, `address`, `wilaya`, `city`, `coordinates`, `quantity`, `sorted`, `status`, `created_at`, `updated_at`) VALUES
(16, 14, NULL, 27, '36;rue hamla abderzak bologhine', 16, 'Bologhine Ibnou Ziri', 'https://www.google.com/maps/search/36.8056255,3.0401622', 'Deux grands sacs', 0, 2, '2021-10-09 14:32:33', '2021-10-14 17:36:22'),
(17, 15, NULL, 27, 'Prêt du palais du gouvernement', 16, 'Alger Centre', NULL, 'Petit sac', 0, 2, '2021-10-09 16:49:52', '2021-10-13 17:45:33'),
(20, 18, NULL, 24, 'L\'adresse c\'est Cité DNC bâtiment B14 n°15 Reghaia à côté de primaire Mouloud Kacem Nait Belkacem', 16, 'Reghaia', NULL, '2 sacs', 0, 2, '2021-10-11 14:36:19', '2021-10-24 09:54:06'),
(21, 19, NULL, 24, 'Prés du commissariat 1024', 9, 'Ouled Yaich', NULL, 'Sacs', 0, 2, '2021-10-11 14:39:02', '2021-10-24 09:48:28'),
(22, 20, NULL, NULL, 'Draria', 16, 'Draria', NULL, '7 bidons de 5L', 0, 2, '2021-10-11 16:59:54', '2021-11-08 13:52:13'),
(24, 22, NULL, NULL, 'draria', 16, 'Draria', NULL, 'Sac', 1, 2, '2021-10-11 20:46:17', '2021-10-24 09:33:26'),
(25, 23, NULL, NULL, 'Dely brahim', 16, 'Dely Ibrahim', NULL, 'Je ne sais pas', 0, 2, '2021-10-11 20:46:48', '2021-11-08 15:56:11'),
(27, 25, NULL, NULL, 'Draria', 16, 'Draria', NULL, 'je ne sais pas', 0, 2, '2021-10-11 20:48:00', '2021-10-24 09:34:34'),
(30, 14, NULL, 27, 'Bologhine', 16, '0', 'https://www.google.com/maps/search/36.8056358,3.0401403', 'Un bonne packet', 0, 2, '2021-10-20 10:37:03', '2021-10-27 16:48:17'),
(31, 27, NULL, 22, 'Cheraga a côté de sonelgaz juste en face du marché', 16, 'Cheraga', NULL, 'Un grand sac plein de bouteilles remplis de bouchons triés', 1, 2, '2021-10-20 12:30:05', '2021-10-30 10:34:31'),
(32, 28, NULL, NULL, 'Draria', 16, 'Draria', NULL, '1 sac', 0, 2, '2021-10-20 18:10:09', '2022-04-09 16:36:35'),
(33, 29, NULL, NULL, 'draria', 16, 'Draria', NULL, 'inconnu', 0, 2, '2021-10-24 09:36:47', '2021-10-24 09:37:03'),
(34, 30, NULL, 10, 'Hydra', 16, 'Hydra', NULL, '2 sacs', 0, 2, '2021-10-24 16:24:18', '2021-12-11 13:44:37'),
(36, 31, NULL, NULL, 'cheraga a cote de l’agence', 16, 'Cheraga', NULL, 'À demandé', 0, 2, '2021-10-26 14:26:04', '2021-10-27 16:49:02'),
(37, 32, NULL, 27, 'Garidi', 16, 'Kouba', NULL, '1 grand sac', 0, 2, '2021-10-27 07:50:49', '2021-11-08 16:09:47'),
(38, 33, NULL, NULL, 'École El Malek pas loin du Restaurant Opéra sur la montée de Dely Brahim', 16, 'Dely Ibrahim', NULL, 'Un grand sac', 0, 2, '2021-10-27 08:25:13', '2021-11-09 09:45:10'),
(39, 34, NULL, 24, 'Kouba', 16, 'Kouba', 'Kouba', 'Beaucoup de petits sacs', 0, 2, '2021-10-27 14:58:23', '2021-11-09 09:45:34'),
(40, 35, NULL, 24, 'Rouiba ville', 16, 'Rouiba', NULL, 'Un très grand : 3 sacs triés 2 sacs non triés', 1, 2, '2021-10-28 16:44:41', '2021-10-28 17:00:05'),
(41, 36, NULL, NULL, 'Sur la descente de Dely Brahim en allant vers cheraga , magasin techno', 16, 'Dely Ibrahim', NULL, 'Grande', 0, 2, '2021-10-31 09:24:38', '2021-10-31 12:47:55'),
(42, 37, NULL, NULL, 'Ben aknoun', 16, 'Ben Aknoun', NULL, 'Petite quantité', 0, 0, '2021-11-03 08:52:21', '2021-11-03 08:52:21'),
(43, 38, NULL, 24, 'Saïd hamdine', 16, 'El Mouradia', NULL, 'Quantité', 0, 2, '2021-11-03 09:01:16', '2021-11-08 12:59:33'),
(44, 39, NULL, NULL, 'Café chergui', 16, 'Bordj El Bahri', NULL, '2 bouteilles de 5L', 0, 2, '2021-11-03 09:35:12', '2021-11-08 10:40:49'),
(45, 40, NULL, 27, 'Ain naaja', 16, 'Kouba', NULL, 'Quantité', 0, 2, '2021-11-03 09:39:41', '2022-01-01 15:43:44'),
(46, 41, NULL, 27, 'Bien Morad rais', 16, 'Bir Mourad Rais', NULL, 'Quantité', 0, 2, '2021-11-03 09:46:21', '2022-06-21 07:10:19'),
(47, 42, NULL, 15, 'Bou smail', 42, 'Bou Ismail', NULL, 'Grande quantité', 0, 2, '2021-11-03 10:05:00', '2021-11-13 13:45:34'),
(49, 43, NULL, 24, 'cite 618 logements bâtiment 43 n 3 (5maisons)', 16, 'Mohammadia', NULL, 'Un grand sachet trié,une bouteille cinque litre triée,3 petits sachets non triés', 1, 2, '2021-11-06 14:38:23', '2021-11-08 11:33:19'),
(50, 44, NULL, NULL, 'Staoueli', 16, 'Staoueli', NULL, '2 bidon et 1 sachets', 0, 2, '2021-11-06 20:09:51', '2021-11-08 10:40:33'),
(51, 45, NULL, 27, 'Alger centre', 16, 'Alger Centre', NULL, 'Quantité', 0, 2, '2021-11-09 11:21:03', '2021-11-19 15:23:05'),
(52, 46, NULL, 27, 'Les vergers', 16, 'Bir Mourad Rais', NULL, 'Quantité', 0, 2, '2021-11-09 11:32:46', '2021-12-01 17:22:59'),
(56, 14, NULL, 27, '36,rue hamla abderzak bologhine', 16, '0', NULL, 'Une bonne contite', 0, 2, '2021-11-29 10:12:19', '2022-01-18 16:09:34'),
(58, 49, NULL, 10, 'village celeste bouzareah', 16, 'Bouzareah', NULL, '2 grands sacs', 0, 2, '2021-12-01 10:19:32', '2021-12-08 06:40:37'),
(59, 50, NULL, 10, '2n city souidania', 16, 'Souidania', NULL, '3 sacs', 0, 2, '2021-12-01 10:34:24', '2021-12-04 11:13:41'),
(60, 51, NULL, 31, 'Bordj el kiffan centre ville: iceberg à coté du tramway', 16, 'Bordj El Kiffan', NULL, '1 sac', 0, 2, '2021-12-01 16:19:37', '2021-12-09 09:10:17'),
(61, 52, NULL, 14, 'Ain benian', 16, 'Ain Benian', NULL, 'Quantité', 0, 2, '2021-12-02 05:57:48', '2022-05-31 03:39:25'),
(62, 53, NULL, 31, 'Bateau cassé', 16, 'Bordj El Kiffan', NULL, 'Grande', 0, 2, '2021-12-02 06:05:01', '2021-12-09 09:46:01'),
(64, 48, NULL, 6, 'cité 250 logement bâtiment I Saoula Alger', 16, '0', NULL, '1 sac', 0, 1, '2021-12-02 06:20:43', '2021-12-09 12:00:17'),
(66, 55, NULL, NULL, 'SARL SEFIABAT, P22X+764, Djasr Kasentina', 16, 'Birkhadem', 'SARL SEFIABAT, P22X+764, Djasr Kasentina', '1 sac moyen', 0, 0, '2021-12-02 17:42:48', '2021-12-02 17:42:48'),
(67, 56, NULL, NULL, 'centre ville de Boumerdes \r\nCité 408 logement bat 01\r\nCage H', 35, 'Boumerdes', NULL, '2 sachets', 0, 2, '2021-12-02 17:56:46', '2022-01-04 10:58:28'),
(68, 57, NULL, 24, 'ain naadja en face station de métro', 16, '0', NULL, '2 bidons 5L', 0, 2, '2021-12-02 19:47:23', '2021-12-05 06:41:47'),
(69, 58, NULL, 10, 'Residence bouhired souidania.', 16, 'Souidania', NULL, 'Quantité', 0, 2, '2021-12-03 07:51:59', '2021-12-05 07:46:51'),
(70, 59, NULL, 27, 'La cité amirouche bâtiment d cage l 284 opgi Hussein dey', 16, 'Hussein Dey', NULL, '1 carton', 0, 0, '2021-12-03 10:28:26', '2021-12-07 18:56:49'),
(71, 60, NULL, 22, 'cité aadl 1500 logement BT 7 A3 ( plateau sud ) Ouled Fayet', 16, 'Ouled Fayet', NULL, '1 sac (poubelle) bien remplie', 0, 2, '2021-12-03 14:32:44', '2021-12-07 10:42:23'),
(72, 61, NULL, 27, 'Telemly', 16, 'Alger Centre', NULL, 'Un sac moyen', 0, 2, '2021-12-03 16:37:02', '2021-12-08 18:01:24'),
(73, 62, NULL, 31, 'Reghaia ville', 16, 'Reghaia', NULL, '2 bidon 5L plus un sachet', 0, 2, '2021-12-03 17:46:28', '2021-12-11 14:16:15'),
(74, 63, NULL, 27, 'Telemly boulevard krim belkacem', 16, 'Alger Centre', NULL, 'Quantité', 0, 2, '2021-12-04 13:35:14', '2022-06-21 07:09:57'),
(75, 64, NULL, 22, 'Ouled fayet', 16, 'Ouled Fayet', NULL, 'Quantité', 0, 2, '2021-12-04 15:32:56', '2021-12-08 15:17:24'),
(76, 14, NULL, 27, '36.rue halma abderzak bologhine alger', 16, 'Bologhine Ibnou Ziri', NULL, '6 jirakane de 5 litre', 0, 2, '2021-12-08 11:57:00', '2022-01-18 16:09:32'),
(77, 65, NULL, 10, 'Hydra', 16, 'Hydra', NULL, '2 petits sacs', 0, 2, '2021-12-08 13:52:01', '2021-12-23 11:59:54'),
(79, 67, NULL, NULL, 'Citée AADL hai El badr', 16, 'Birkhadem', NULL, 'Un sac', 0, 0, '2021-12-09 09:19:02', '2021-12-09 09:19:02'),
(80, 68, NULL, NULL, 'Draria', 16, 'Draria', NULL, 'Un sac', 0, 0, '2021-12-09 09:45:09', '2022-05-31 03:39:55'),
(81, 69, NULL, 27, 'Alger centre', 16, 'Alger Centre', NULL, 'Quantité', 0, 2, '2021-12-12 08:06:54', '2021-12-29 16:24:18'),
(82, 70, NULL, 27, 'Dr Zenoun rhumatologue sur map', 16, 'Kouba', NULL, 'Deux sacs', 0, 2, '2021-12-14 19:58:18', '2022-07-31 15:00:58'),
(83, 71, NULL, NULL, 'Draria', 16, 'Draria', NULL, 'Oui', 0, 0, '2021-12-21 08:18:18', '2022-05-31 03:39:51'),
(84, 72, NULL, 27, 'Lotissement Saidoun mohamed  Num 17 Ben omar Kouba', 16, 'Kouba', 'https://maps.app.goo.gl/A187YgGLjAbxX8SF6', '4 gros sacs ,un carton, quelque bidons 5L', 0, 2, '2021-12-24 12:01:08', '2022-07-31 15:00:55'),
(85, 73, NULL, 10, 'Ain benian', 16, 'Ain Benian', NULL, '4 gros sacs , 3 sacs moyen', 0, 2, '2021-12-24 15:26:43', '2021-12-24 16:00:44'),
(86, 74, NULL, 10, 'Saïd hamdin', 16, '0', NULL, '2 bidon 5L plus un sachet', 0, 2, '2021-12-25 18:08:05', '2021-12-26 10:49:49'),
(87, 75, NULL, NULL, 'Près de la clinique Aya', 16, 'Birkhadem', NULL, 'Un petit sachet', 0, 0, '2021-12-25 18:11:44', '2021-12-25 18:11:44'),
(88, 76, NULL, 24, 'Inforba', 16, 'Rouiba', NULL, '1 grand sac', 1, 2, '2021-12-25 18:13:09', '2021-12-25 18:13:20'),
(89, 77, NULL, NULL, 'Immeuble durafour', 16, 'Hussein Dey', NULL, '1 bidon 5L', 0, 0, '2021-12-25 18:19:13', '2021-12-25 18:19:13'),
(90, 62, NULL, NULL, 'Reghaia ville', 16, 'Dely Ibrahim', NULL, 'Moyenne', 0, 10, '2022-03-18 19:37:51', '2022-03-20 13:50:21'),
(91, 78, NULL, NULL, 'Bt14', 16, 'Mohammadia', 'Bt 14 https://maps.app.goo.gl/tV5vw7HvsQS9zq9U7', '7 bidons 5l', 1, 0, '2022-04-02 12:32:15', '2022-04-02 12:32:15'),
(92, 79, NULL, 10, 'Résidence essalam', 16, 'Souidania', 'Residence Essalem Souidania https://maps.app.goo.gl/7CgayzQeJWEHoALT6', '5 sachets', 0, 2, '2022-04-04 19:23:41', '2022-04-14 05:19:37'),
(93, 80, NULL, 24, 'Adresse\r\nAADL kerrouche\r\nBt 135 porte 16', 16, 'Reghaia', NULL, '1/2 placard (bouchons+bouteilles)', 0, 2, '2022-04-05 05:16:51', '2022-06-29 06:07:27'),
(94, 81, NULL, 6, 'Adresse: terminus tramway dargana', 16, 'Ain Taya', 'https://www.google.com/maps/place/36%C2%B046\'19.3%22N+3%C2%B015\'37.0%22E/@36.7720214,3.2602834,17z?hl=fr-FR&gl=fr', '2 sacs poubelles', 0, 2, '2022-04-05 12:30:17', '2022-04-08 14:01:38'),
(95, 82, NULL, NULL, 'Draria', 16, 'Draria', '36°42\'58.6\"N 2°59\'46.4\"E', '1 sac', 0, 0, '2022-04-05 13:29:07', '2022-05-31 03:39:53'),
(96, 83, NULL, NULL, 'El harrache centre. En face hôtel HANA', 16, 'El Harrach', NULL, '3 sacs+ 2 petits', 1, 0, '2022-04-05 14:47:24', '2022-04-05 14:47:24'),
(97, 84, NULL, 27, 'Clinique de chirurgie pédiatrique birtraria  belair', 16, 'El Biar', NULL, 'Un sac poubelle', 0, 2, '2022-04-08 13:28:25', '2022-07-31 15:00:52'),
(98, 85, NULL, NULL, 'cité Ain-Allah.Bt 405.Dely-brahim', 16, 'Dely Ibrahim', NULL, 'Un sac', 0, 0, '2022-04-08 18:11:58', '2022-04-08 18:11:58'),
(99, 86, NULL, 6, 'Forêt de bouchaoui', 16, 'Staoueli', NULL, '15 kilos', 0, 2, '2022-05-05 15:23:11', '2022-05-13 11:58:10'),
(100, 87, NULL, 22, 'villa N°13, lotissement djenane Delly-Brahim à Delly-Brahim', 16, 'Dely Ibrahim', 'Repère placé https://maps.app.goo.gl/XoxooRuEMKQ6krJs5', '3 sachets', 0, 2, '2022-05-06 11:52:35', '2022-07-03 17:18:59'),
(101, 88, NULL, NULL, '36°29\'12.9\"N 2°47\'13.0\"E\r\nFQPP+PWR, Blida 09000\r\nhttps://goo.gl/maps/2kVvd6Lo3KyfWA3u5', 9, 'Blida', '36°29\'12.9\"N 2°47\'13.0\"E FQPP+PWR, Blida 09000 https://goo.gl/maps/2kVvd6Lo3KyfWA3u5', '6 bouteilles', 0, 0, '2022-05-07 11:04:08', '2022-05-07 11:04:08'),
(102, 89, NULL, NULL, 'La pointe', 16, 'Rais Hamidou', NULL, '4 bidons', 0, 0, '2022-05-08 03:23:09', '2022-05-08 03:23:09'),
(103, 90, NULL, 27, 'Le ravin de la femme sauvage', 16, 'Bir Mourad Rais', NULL, '6 sacs moyen', 0, 2, '2022-05-16 07:13:19', '2022-07-31 15:00:49');

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

--
-- Table structure for table `donors`
--

CREATE TABLE `donors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` text NOT NULL,
  `wilaya` smallint(6) NOT NULL,
  `city` varchar(255) NOT NULL,
  `coordinates` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donors`
--

INSERT INTO `donors` (`id`, `name`, `email`, `phone`, `address`, `wilaya`, `city`, `coordinates`, `created_at`, `updated_at`) VALUES
(1, 'Test One', 'test@domain.com', '077754577', 'ruelle', 16, 'Alger Centre', 'https://www.google.com/maps/search/36.6379008,3.178496', '2021-03-12 16:05:39', '2021-03-12 16:05:39'),
(2, 'anis kaci mohammed', NULL, '0775232659', 'cite des annassers Bt 812 Porte 7 Kouba', 16, 'Bab Ezzouar', 'https://www.google.com/maps/search/46.227638,2.213749', '2021-03-19 17:26:59', '2021-04-03 12:17:39'),
(3, NULL, NULL, '+213775232659', 'draria', 16, 'Draria', 'https://www.google.com/maps/search/36.723097599999996,3.0375935999999997', '2021-04-03 12:04:13', '2021-04-03 12:04:13'),
(4, NULL, NULL, '00000', 'TEST', 16, 'Ain Taya', NULL, '2021-10-07 19:50:31', '2021-10-07 19:50:31'),
(5, NULL, NULL, '788877', 'Sidi mabrouk constantine', 25, 'Constantine', NULL, '2021-10-08 20:21:58', '2021-10-08 20:21:58'),
(6, NULL, NULL, '0666666666', 'Villa dallas', 16, 'Rouiba', 'https://www.google.com/maps/search/36.735369,3.2673405', '2021-10-08 20:23:06', '2021-10-08 20:23:06'),
(7, NULL, NULL, '0661111617', '66 rue chez nous', 16, 'Ouled Fayet', NULL, '2021-10-08 20:23:12', '2021-10-08 20:23:12'),
(8, NULL, NULL, '056602741', 'Mahelma', 16, 'Zeralda', NULL, '2021-10-08 20:26:31', '2021-10-08 20:26:31'),
(9, NULL, NULL, '0792869646', 'KOUBA', 16, 'Kouba', NULL, '2021-10-08 20:42:31', '2021-10-08 20:42:31'),
(10, NULL, NULL, '0770754369', 'Hay El jamila', 16, 'Ain Benian', 'https://www.google.com/maps/search/36.7065436,3.0872085', '2021-10-09 09:27:46', '2021-10-09 09:27:46'),
(11, NULL, NULL, '88383838383', 'Jdjdjdjdb', 16, 'Ain Benian', 'https://www.google.com/maps/search/36.704854,3.0858512', '2021-10-09 09:28:13', '2021-10-09 09:28:13'),
(12, NULL, NULL, '0555621087', 'حي 250 مسكن عمارة ك رقم 11 السحاولة', 16, 'Souidania', 'https://www.google.com/maps/search/36.704791,3.0860082', '2021-10-09 09:40:22', '2021-10-09 09:40:22'),
(13, NULL, NULL, '6262626', 'Bbsbsbsb', 42, 'Bou Ismail', NULL, '2021-10-09 09:44:56', '2021-10-09 09:44:56'),
(14, NULL, NULL, '0550358196', '36;rue hamla abderzak bologhine', 16, 'Bologhine Ibnou Ziri', 'https://www.google.com/maps/search/36.8056255,3.0401622', '2021-10-09 14:32:33', '2021-10-09 14:32:33'),
(15, NULL, NULL, '0550473680', 'Prêt du palais du gouvernement', 16, 'Alger Centre', NULL, '2021-10-09 16:49:52', '2021-10-09 16:49:52'),
(16, NULL, NULL, '07752435475', 'HYDRA TEST', 16, 'Hydra', NULL, '2021-10-09 16:56:01', '2021-10-09 16:56:01'),
(17, NULL, NULL, '0555656565', 'BARAKI TEST', 16, 'Baraki', NULL, '2021-10-09 16:56:30', '2021-10-09 16:56:30'),
(18, NULL, NULL, '0554 91 49 80', 'L\'adresse c\'est Cité DNC bâtiment B14 n°15 Reghaia à côté de primaire Mouloud Kacem Nait Belkacem', 16, 'Reghaia', NULL, '2021-10-11 14:36:19', '2021-10-11 14:36:19'),
(19, NULL, NULL, '0550400012', 'Prés du commissariat 1024', 9, 'Ouled Yaich', NULL, '2021-10-11 14:39:01', '2021-10-11 14:39:01'),
(20, NULL, NULL, '0557133537', 'Draria', 16, 'Draria', NULL, '2021-10-11 16:59:54', '2021-10-11 16:59:54'),
(21, NULL, NULL, '05555555555', 'Bab el oued', 16, 'Bab El Oued', NULL, '2021-10-11 19:35:20', '2021-10-11 19:35:20'),
(22, NULL, NULL, '0555454432', 'draria', 16, 'Draria', NULL, '2021-10-11 20:46:17', '2021-10-11 20:46:17'),
(23, NULL, NULL, '0771371239', 'Dely brahim', 16, 'Dely Ibrahim', NULL, '2021-10-11 20:46:48', '2021-10-11 20:46:48'),
(24, NULL, NULL, '0697206072', 'El achour', 16, 'El Achour', NULL, '2021-10-11 20:47:31', '2021-10-11 20:47:31'),
(25, NULL, NULL, '0554924194', 'Draria', 16, 'Draria', NULL, '2021-10-11 20:48:00', '2021-10-11 20:48:00'),
(26, NULL, NULL, '0779988364', 'ministère de la solidarité bir khadem côté onalait après la station d\'essence.', 16, 'Birkhadem', 'https://maps.app.goo.gl/uJ6YhXcB1W6PXDbK7', '2021-10-13 11:31:35', '2021-10-13 11:31:35'),
(27, NULL, NULL, '0540215678', 'Cheraga a côté de sonelgaz juste en face du marché', 16, 'Cheraga', NULL, '2021-10-20 12:30:05', '2021-10-20 12:30:05'),
(28, NULL, NULL, '0551294444', 'Draria', 16, 'Draria', NULL, '2021-10-20 18:10:09', '2021-10-20 18:10:09'),
(29, NULL, NULL, '0558804520', 'draria', 16, 'Draria', NULL, '2021-10-24 09:36:47', '2021-10-24 09:36:47'),
(30, NULL, NULL, '0555348949', 'Hydra', 16, 'Hydra', NULL, '2021-10-24 16:24:18', '2021-10-24 16:24:18'),
(31, NULL, NULL, '0560951530', 'cheraga a cote de l’agence', 16, 'Cheraga', NULL, '2021-10-26 13:50:38', '2021-10-26 13:50:38'),
(32, NULL, NULL, '0560943830', 'Garidi', 16, 'Kouba', NULL, '2021-10-27 07:50:49', '2021-10-27 07:50:49'),
(33, NULL, NULL, '0557229467', 'École El Malek pas loin du Restaurant Opéra sur la montée de Dely Brahim', 16, 'Dely Ibrahim', NULL, '2021-10-27 08:25:13', '2021-10-27 08:25:13'),
(34, NULL, NULL, '0549069894', 'Kouba', 16, 'Kouba', NULL, '2021-10-27 14:55:11', '2021-10-27 14:55:11'),
(35, NULL, NULL, '0770007387', 'Rouiba ville', 16, 'Rouiba', NULL, '2021-10-28 16:44:41', '2021-10-28 16:44:41'),
(36, NULL, NULL, '0770981407', 'Sur la descente de Dely Brahim en allant vers cheraga , magasin techno', 16, 'Dely Ibrahim', NULL, '2021-10-31 09:24:38', '2021-10-31 09:24:38'),
(37, NULL, NULL, '0549851776', 'Ben aknon', 16, 'Ben Aknoun', NULL, '2021-11-03 08:51:45', '2021-11-03 08:51:45'),
(38, NULL, NULL, '0560882988', 'Saïd hamdine', 16, 'El Mouradia', NULL, '2021-11-03 09:01:16', '2021-11-03 09:01:16'),
(39, NULL, NULL, '0542446423', 'Café chergui', 16, 'Bordj El Bahri', NULL, '2021-11-03 09:35:12', '2021-11-03 09:35:12'),
(40, NULL, NULL, '0542 33 12 10', 'Ain naaja', 16, 'Kouba', NULL, '2021-11-03 09:39:41', '2021-11-03 09:39:41'),
(41, NULL, NULL, '0552 00 36 24', 'Bien Morad rais', 16, 'Bir Mourad Rais', NULL, '2021-11-03 09:46:21', '2021-11-03 09:46:21'),
(42, NULL, NULL, '0550251330', 'Bou smail', 42, 'Bou Ismail', NULL, '2021-11-03 10:05:00', '2021-11-03 10:05:00'),
(43, NULL, NULL, '0779384127', 'cite 618 logements bâtiment 43 n 3 (5maisons)', 16, 'Mohammadia', NULL, '2021-11-04 19:28:10', '2021-11-04 19:28:10'),
(44, NULL, NULL, '0773962842', 'Staoueli', 16, 'Staoueli', NULL, '2021-11-06 20:08:38', '2021-11-06 20:08:38'),
(45, NULL, NULL, '0555896429', 'Alger centre', 16, 'Alger Centre', NULL, '2021-11-09 11:21:03', '2021-11-09 11:21:03'),
(46, NULL, NULL, '0550151280', 'Les vergers', 16, 'Bir Mourad Rais', NULL, '2021-11-09 11:32:46', '2021-11-09 11:32:46'),
(47, NULL, NULL, '0676208835', 'École d\'art screcedo carrefour zabana', 9, 'Blida', NULL, '2021-11-09 11:55:57', '2021-11-09 11:55:57'),
(48, NULL, NULL, '0561540227', 'cité 250 logement bâtiment I Saoula Alger', 16, 'Sehaoula', 'Cité 250 logts Saoula Centre https://maps.app.goo.gl/BB6rZPjxoprcpntf9', '2021-11-12 17:46:11', '2021-11-12 17:46:11'),
(49, NULL, NULL, '0771 51 73 61', 'village celeste bouzareah', 16, 'Bouzareah', NULL, '2021-12-01 10:19:27', '2021-12-01 10:19:27'),
(50, NULL, NULL, '0552684704', '2n city souidania', 16, 'Souidania', NULL, '2021-12-01 10:34:24', '2021-12-01 10:34:24'),
(51, NULL, NULL, '0662697212', 'Bordj el kiffan centre ville: iceberg à coté du tramway', 16, 'Bordj El Kiffan', NULL, '2021-12-01 16:19:37', '2021-12-01 16:19:37'),
(52, NULL, NULL, '0555299931', 'Ain benian', 16, 'Ain Benian', NULL, '2021-12-02 05:57:48', '2021-12-02 05:57:48'),
(53, NULL, NULL, '0540130720', 'Bateau cassé', 16, 'Bordj El Kiffan', NULL, '2021-12-02 06:05:01', '2021-12-02 06:05:01'),
(54, NULL, NULL, '0559 22 39 05', 'Sidi Abdellah lpp q3', 42, 'Tipaza', NULL, '2021-12-02 07:32:34', '2021-12-02 07:32:34'),
(55, NULL, NULL, '0550011660', 'SARL SEFIABAT, P22X+764, Djasr Kasentina', 16, 'Birkhadem', 'SARL SEFIABAT, P22X+764, Djasr Kasentina', '2021-12-02 17:42:48', '2021-12-02 17:42:48'),
(56, NULL, NULL, '0561846379', 'centre ville de Boumerdes \r\nCité 408 logement bat 01\r\nCage H', 35, 'Boumerdes', NULL, '2021-12-02 17:56:46', '2021-12-02 17:56:46'),
(57, NULL, NULL, '0667110552', 'ain naadja en face station de métro', 16, '0', NULL, '2021-12-02 19:47:23', '2021-12-02 19:47:23'),
(58, NULL, NULL, '0553258538', 'Residence bouhired souidania.', 16, 'Souidania', NULL, '2021-12-03 07:51:59', '2021-12-03 07:51:59'),
(59, NULL, NULL, '0793146020', 'La cité amirouche bâtiment d cage l 284 opgi Hussein dey', 16, 'Hussein Dey', NULL, '2021-12-03 10:28:26', '2021-12-03 10:28:26'),
(60, NULL, NULL, '0541994119', 'cité aadl 1500 logement BT 7 A3 ( plateau sud ) Ouled Fayet', 16, 'Ouled Fayet', NULL, '2021-12-03 14:32:44', '2021-12-03 14:32:44'),
(61, NULL, NULL, '0561 345606', 'Telemly', 16, 'Alger Centre', NULL, '2021-12-03 16:37:02', '2021-12-03 16:37:02'),
(62, NULL, NULL, '0558605366', 'Reghaia ville', 16, 'Reghaia', NULL, '2021-12-03 17:46:28', '2021-12-03 17:46:28'),
(63, NULL, NULL, '0672030094', 'Telemly boulevard krim belkacem', 16, 'Alger Centre', NULL, '2021-12-04 13:35:14', '2021-12-04 13:35:14'),
(64, NULL, NULL, '0770333286', 'Ouled fayet', 16, 'Ouled Fayet', NULL, '2021-12-04 15:32:56', '2021-12-04 15:32:56'),
(65, NULL, NULL, '0770985961', 'Hydra', 16, 'Hydra', NULL, '2021-12-08 13:52:01', '2021-12-08 13:52:01'),
(66, NULL, NULL, '079 773 7660', 'Pharmacie Lemdani Belcourt', 16, 'Mohamed Belouzdad', 'Pharmacie Lemdani 023 51 94 23 https://maps.app.goo.gl/BneCGuRQbGSEef427', '2021-12-08 18:39:41', '2021-12-08 18:39:41'),
(67, NULL, NULL, '0557982332', 'Citée AADL hai El badr', 16, 'Birkhadem', NULL, '2021-12-09 09:19:02', '2021-12-09 09:19:02'),
(68, NULL, NULL, '0558905339', 'Draria', 16, 'Draria', NULL, '2021-12-09 09:45:09', '2021-12-09 09:45:09'),
(69, NULL, NULL, '0559 05 08 95', 'Alger centre', 16, 'Alger Centre', NULL, '2021-12-12 08:06:54', '2021-12-12 08:06:54'),
(70, NULL, NULL, '0674 80 40 21', 'Dr Zenoun rhumatologue sur map', 16, 'Kouba', NULL, '2021-12-14 19:58:18', '2021-12-14 19:58:18'),
(71, NULL, NULL, '0664659991', 'Draria', 16, 'Draria', NULL, '2021-12-21 08:18:18', '2021-12-21 08:18:18'),
(72, NULL, NULL, '0552 620 113', 'Lotissement Saidoun mohamed  Num 17 Ben omar Kouba', 16, 'Kouba', 'https://maps.app.goo.gl/A187YgGLjAbxX8SF6', '2021-12-24 12:01:08', '2021-12-24 12:01:08'),
(73, NULL, NULL, '0799255547', 'Ain benian', 16, 'Ain Benian', NULL, '2021-12-24 15:26:43', '2021-12-24 15:26:43'),
(74, NULL, NULL, '0555991564', 'Saïd hamdin', 16, '0', NULL, '2021-12-25 18:08:05', '2021-12-25 18:08:05'),
(75, NULL, NULL, '0560523148', 'Près de la clinique Aya', 16, 'Birkhadem', NULL, '2021-12-25 18:11:44', '2021-12-25 18:11:44'),
(76, NULL, NULL, '0550 07 42 71', 'Inforba', 16, 'Rouiba', NULL, '2021-12-25 18:13:09', '2021-12-25 18:13:09'),
(77, NULL, NULL, '0782619505', 'Immeuble durafour', 16, 'Hussein Dey', NULL, '2021-12-25 18:19:13', '2021-12-25 18:19:13'),
(78, NULL, NULL, '0555806228', 'Bt14', 16, 'Mohammadia', 'Bt 14 https://maps.app.goo.gl/tV5vw7HvsQS9zq9U7', '2022-04-02 12:32:15', '2022-04-02 12:32:15'),
(79, NULL, NULL, '0552083555', 'Résidence essalam', 16, 'Souidania', 'Residence Essalem Souidania https://maps.app.goo.gl/7CgayzQeJWEHoALT6', '2022-04-04 19:23:41', '2022-04-04 19:23:41'),
(80, NULL, NULL, '0550691660', 'Adresse\r\nAADL kerrouche\r\nBt 135 porte 16', 16, 'Reghaia', NULL, '2022-04-05 05:16:51', '2022-04-05 05:16:51'),
(81, NULL, NULL, '0541310000', 'Adresse: terminus tramway dargana', 16, 'Ain Taya', 'https://www.google.com/maps/place/36%C2%B046\'19.3%22N+3%C2%B015\'37.0%22E/@36.7720214,3.2602834,17z?hl=fr-FR&gl=fr', '2022-04-05 12:30:17', '2022-04-05 12:30:17'),
(82, NULL, NULL, '0556951912', 'Draria', 16, 'Draria', '36°42\'58.6\"N 2°59\'46.4\"E', '2022-04-05 13:29:07', '2022-04-05 13:29:07'),
(83, NULL, NULL, '0792849899', 'El harrache centre. En face hôtel HANA', 16, 'El Harrach', NULL, '2022-04-05 14:47:24', '2022-04-05 14:47:24'),
(84, NULL, NULL, '0554755349', 'Clinique de chirurgie pédiatrique birtraria  belair', 16, 'El Biar', NULL, '2022-04-08 13:28:25', '2022-04-08 13:28:25'),
(85, NULL, NULL, '0661562948', 'cité Ain-Allah.Bt 405.Dely-brahim', 16, 'Dely Ibrahim', NULL, '2022-04-08 18:11:58', '2022-04-08 18:11:58'),
(86, NULL, NULL, '0553592375', 'Forêt de bouchaoui', 16, 'Staoueli', NULL, '2022-05-05 15:23:11', '2022-05-05 15:23:11'),
(87, NULL, NULL, '0551 41 49 37', 'villa N°13, lotissement djenane Delly-Brahim à Delly-Brahim', 16, 'Dely Ibrahim', 'Repère placé https://maps.app.goo.gl/XoxooRuEMKQ6krJs5', '2022-05-06 11:52:35', '2022-05-06 11:52:35'),
(88, NULL, NULL, '0782391138', '36°29\'12.9\"N 2°47\'13.0\"E\r\nFQPP+PWR, Blida 09000\r\nhttps://goo.gl/maps/2kVvd6Lo3KyfWA3u5', 9, 'Blida', '36°29\'12.9\"N 2°47\'13.0\"E FQPP+PWR, Blida 09000 https://goo.gl/maps/2kVvd6Lo3KyfWA3u5', '2022-05-07 11:04:08', '2022-05-07 11:04:08'),
(89, NULL, NULL, '0552844418', 'La pointe', 16, 'Rais Hamidou', NULL, '2022-05-08 03:23:09', '2022-05-08 03:23:09'),
(90, NULL, NULL, '0552464996', 'Le ravin de la femme sauvage', 16, 'Bir Mourad Rais', NULL, '2022-05-16 07:13:19', '2022-05-16 07:13:19');

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

--
-- Table structure for table `drugs`
--

CREATE TABLE `drugs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drugs`
--

INSERT INTO `drugs` (`id`, `name`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'vitamine D', 'Lot  de 2022', '2021-02-22 22:25:29', '2021-02-22 22:25:29'),
(2, 'Daylong', 'Lot 2023', '2021-02-22 22:25:48', '2021-02-22 22:25:48');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `important_numbers`
--

CREATE TABLE `important_numbers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` varchar(255) NOT NULL,
  `details` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `important_numbers`
--

INSERT INTO `important_numbers` (`id`, `number`, `details`, `created_at`, `updated_at`) VALUES
(1, '0792869646', 'Anis', '2021-03-22 00:44:13', '2021-03-22 00:44:13');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2015_04_12_000000_create_orchid_users_table', 1),
(4, '2015_10_19_214424_create_orchid_roles_table', 1),
(5, '2015_10_19_214425_create_orchid_role_users_table', 1),
(6, '2016_08_07_125128_create_orchid_attachmentstable_table', 1),
(7, '2017_09_17_125801_create_notifications_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2021_02_19_163756_add_custom_user_attributes_to_users_table', 2),
(10, '2021_02_19_190355_create_donors_table', 2),
(11, '2021_02_19_190400_create_donations_table', 2),
(12, '2021_02_19_190416_create_patient_requests_table', 2),
(13, '2021_02_19_190427_create_drugs_table', 2),
(14, '2021_02_23_230020_create_contact_messages_table', 3),
(15, '2021_02_24_210704_create_collection_points_table', 4),
(16, '2021_02_26_142656_make_name_column_nullable_in_donors_table', 5),
(17, '2021_03_05_230027_add_status_column_to_users_table', 6),
(18, '2014_10_12_200000_add_two_factor_columns_to_users_table', 7),
(19, '2021_03_12_155953_add_address_columns_to_donations_table', 8),
(20, '2021_03_15_152639_make_name_column_nullable_in_collection_points_table', 9),
(21, '2021_03_15_154819_create_important_numbers_table', 9),
(22, '2021_03_15_181725_remove_columns_from_collection_points_table', 10);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `patient_requests`
--

CREATE TABLE `patient_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `patient_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `volunteer_id` bigint(20) DEFAULT NULL,
  `shipped_by` varchar(255) DEFAULT NULL,
  `drugs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`drugs`)),
  `other_drugs` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `slug`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Admin', '{\"platform.contact.view\":\"0\",\"platform.collection_points.add_edit\":\"0\",\"platform.collection_points.view\":\"0\",\"platform.index\":\"1\",\"platform.systems.index\":\"0\",\"platform.numbers.add_edit\":\"0\",\"platform.numbers.view\":\"0\",\"platform.donations.add_edit\":\"1\",\"platform.donations.delete\":\"1\",\"platform.donations.view\":\"1\",\"platform.donors.add_edit\":\"1\",\"platform.donors.delete\":\"1\",\"platform.donors.view\":\"1\",\"platform.drugs.add_edit\":\"1\",\"platform.drugs.delete\":\"1\",\"platform.drugs.view\":\"1\",\"platform.patient_requests.add_edit\":\"1\",\"platform.patient_requests.delete\":\"1\",\"platform.patient_requests.view\":\"1\",\"platform.systems.attachment\":\"0\",\"platform.systems.roles\":\"0\",\"platform.systems.users\":\"0\",\"platform.patients.add_edit\":\"1\",\"platform.patients.patient\":\"0\",\"platform.patients.delete\":\"1\",\"platform.patients.view\":\"1\",\"platform.volunteers.add_edit\":\"1\",\"platform.volunteers.volunteer\":\"0\",\"platform.volunteers.delete\":\"1\",\"platform.volunteers.view\":\"1\"}', '2021-02-18 19:04:41', '2021-12-07 12:56:27'),
(2, 'patient', 'Patient', '{\"platform.systems.attachment\":\"0\",\"platform.index\":\"0\",\"platform.systems.index\":\"0\",\"platform.donations.add_edit\":\"0\",\"platform.donations.delete\":\"0\",\"platform.donations.view\":\"0\",\"platform.donors.add_edit\":\"0\",\"platform.donors.delete\":\"0\",\"platform.donors.view\":\"0\",\"platform.drugs.add_edit\":\"0\",\"platform.drugs.delete\":\"0\",\"platform.drugs.view\":\"0\",\"platform.patient_requests.add_edit\":\"0\",\"platform.patient_requests.delete\":\"0\",\"platform.patient_requests.view\":\"0\",\"platform.patients.add_edit\":\"0\",\"platform.patients.delete\":\"0\",\"platform.patients.view\":\"0\",\"platform.volunteers.add_edit\":\"0\",\"platform.volunteers.delete\":\"0\",\"platform.volunteers.view\":\"0\"}', '2021-02-18 19:12:14', '2021-02-18 19:12:14'),
(3, 'volunteer', 'Bénevole', '{\"platform.contact.view\":\"0\",\"platform.collection_points.add_edit\":\"0\",\"platform.collection_points.view\":\"0\",\"platform.index\":\"0\",\"platform.systems.index\":\"0\",\"platform.donations.add_edit\":\"0\",\"platform.donations.delete\":\"0\",\"platform.donations.view\":\"0\",\"platform.donors.add_edit\":\"0\",\"platform.donors.delete\":\"0\",\"platform.donors.view\":\"0\",\"platform.drugs.add_edit\":\"0\",\"platform.drugs.delete\":\"0\",\"platform.drugs.view\":\"0\",\"platform.patient_requests.add_edit\":\"0\",\"platform.patient_requests.delete\":\"0\",\"platform.patient_requests.view\":\"0\",\"platform.systems.attachment\":\"0\",\"platform.systems.roles\":\"0\",\"platform.systems.users\":\"0\",\"platform.patients.add_edit\":\"0\",\"platform.patients.patient\":\"0\",\"platform.patients.delete\":\"0\",\"platform.patients.view\":\"0\",\"platform.volunteers.add_edit\":\"0\",\"platform.volunteers.volunteer\":\"0\",\"platform.volunteers.delete\":\"0\",\"platform.volunteers.view\":\"0\"}', '2021-02-18 19:12:23', '2021-03-04 20:10:46'),
(4, 'superadmin', 'Super admin', '{\"platform.index\":\"1\",\"platform.systems.index\":\"1\",\"platform.donations.add_edit\":\"1\",\"platform.donations.delete\":\"1\",\"platform.donations.view\":\"1\",\"platform.donors.add_edit\":\"1\",\"platform.donors.delete\":\"1\",\"platform.donors.view\":\"1\",\"platform.drugs.add_edit\":\"1\",\"platform.drugs.delete\":\"1\",\"platform.drugs.view\":\"1\",\"platform.patient_requests.add_edit\":\"1\",\"platform.patient_requests.delete\":\"1\",\"platform.patient_requests.view\":\"1\",\"platform.patients.add_edit\":\"1\",\"platform.patients.delete\":\"1\",\"platform.patients.view\":\"1\",\"platform.systems.attachment\":\"1\",\"platform.systems.roles\":\"1\",\"platform.systems.users\":\"1\",\"platform.volunteers.add_edit\":\"1\",\"platform.volunteers.delete\":\"1\",\"platform.volunteers.view\":\"1\"}', '2021-02-18 19:13:15', '2021-02-18 19:44:14');

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

--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--

INSERT INTO `role_users` (`user_id`, `role_id`) VALUES
(3, 4);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attachmentable`
--
ALTER TABLE `attachmentable`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attachmentable_attachmentable_type_attachmentable_id_index` (`attachmentable_type`,`attachmentable_id`),
  ADD KEY `attachmentable_attachment_id_foreign` (`attachment_id`);

--
-- Indexes for table `collection_points`
--
ALTER TABLE `collection_points`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_messages`
--
ALTER TABLE `contact_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `donations`
--
ALTER TABLE `donations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `donors`
--
ALTER TABLE `donors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `donors_email_unique` (`email`),
  ADD UNIQUE KEY `donors_phone_unique` (`phone`);

--
-- Indexes for table `drugs`
--
ALTER TABLE `drugs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `important_numbers`
--
ALTER TABLE `important_numbers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `patient_requests`
--
ALTER TABLE `patient_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indexes for table `role_users`
--
ALTER TABLE `role_users`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `role_users_role_id_foreign` (`role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attachmentable`
--
ALTER TABLE `attachmentable`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `collection_points`
--
ALTER TABLE `collection_points`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `donations`
--
ALTER TABLE `donations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- AUTO_INCREMENT for table `donors`
--
ALTER TABLE `donors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `drugs`
--
ALTER TABLE `drugs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `important_numbers`
--
ALTER TABLE `important_numbers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `patient_requests`
--
ALTER TABLE `patient_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `attachmentable`
--
ALTER TABLE `attachmentable`
  ADD CONSTRAINT `attachmentable_attachment_id_foreign` FOREIGN KEY (`attachment_id`) REFERENCES `attachments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `role_users`
--
ALTER TABLE `role_users`
  ADD CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

