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

START TRANSACTION;



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

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

CREATE TABLE IF NOT EXISTS `donations` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'food',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `img` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `qty` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `phone` varchar(12) COLLATE utf8mb3_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `slum_area_id` bigint UNSIGNED DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `donations` (`id`, `type`, `name`, `img`, `qty`, `phone`, `location`, `user_id`, `slum_area_id`, `status`, `created_at`, `updated_at`) VALUES
(31, 'food', 'mikomo', 'AQADkcYxG95u4FN-.jpg', '23.0', '0711747014', '38.272112,-95.980005', 5, 2, 'Donated', '2024-10-01 09:59:39', '2024-10-01 17:31:46'),
(32, 'water', 'Water', 'AQADksYxG95u4FNy.jpg', '10000.0', '0711471248', '38.272112,-95.980005', 5, 15, 'Donated', '2024-10-01 10:05:58', '2024-10-01 07:55:49'),
(33, 'food', 'pilau', 'AQADrMYxG95u4FN9.jpg', '60.0', '0711458936', '-1.229049,36.877541', 5, 14, 'Donated', '2024-10-01 10:48:59', '2024-10-01 19:55:21'),
(34, 'water', 'Water', 'AQADr8YxG95u4FN9.jpg', '100.0', '0785238945', '38.272112,-95.980005', 5, 15, 'In Transit', '2024-10-01 10:53:52', '2024-10-01 17:32:06'),
(35, 'food', 'rice', 'AQAD28UxGwYf4FN-.jpg', '6.0', '0711412356', '-4.009858,39.649905', 5, 15, 'Donated', '2024-10-01 20:30:06', '2024-10-01 20:15:58'),
(36, 'water', 'Water', 'AQAD7MMxGzX24VN-.jpg', '200.0', '0711747015', '-1.213967,36.895619', 6292897892, 15, 'Pending', '2024-10-01 22:52:37', '2024-10-01 22:52:37'),
(37, 'food', 'Mukimo', 'AQAD8sMxGzX24VN-.jpg', '100.0', '0704188199', '-1.213281,36.895627', 6292897892, 2, 'Pending', '2024-10-02 00:05:09', '2024-10-02 00:05:09'),
(38, 'food', 'full mbuzi', '1727829649.jpg', '30', '0721147014', '38.272112,-95.980005', 8, 2, 'Pending', '2024-10-01 21:40:49', '2024-10-01 21:40:49'),
(39, 'food', 'matoke', '1727951401.jpg', '60', '0721147014', '38.272112,-95.980005', 8, 1, 'Pending', '2024-10-03 07:30:01', '2024-10-03 07:30:01');

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

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

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_11_19_022831_create_admins_table', 2),
(6, '2022_11_19_051436_add_address_to_users_table', 3),
(7, '2022_11_19_145005_create_slum_areas_table', 4),
(8, '2022_11_19_170453_add_contact_to_users_table', 5),
(9, '2022_11_22_033059_create_donations_table', 6),
(10, '2022_11_22_040637_add_qty_to_donations_table', 7);

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

--
-- Table structure for table `slum_areas`
--

CREATE TABLE IF NOT EXISTS `slum_areas` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `slum_areas`
--

INSERT INTO `slum_areas` (`id`, `name`, `address`, `created_at`, `updated_at`) VALUES
(1, 'Any', 'Any slum area', '2024-09-14 16:22:27', '2024-09-14 16:22:27'),
(2, 'Githurai Childrens Home', 'Githurai 45 next to PEFA church', '2024-09-14 06:34:32', '2024-09-14 06:34:32'),
(14, 'Roysambu Childrens Home', 'Roysambu footbridge', '2024-09-29 08:59:48', '2024-09-29 08:59:48'),
(15, 'Ruaraka Home', 'Opposite Safari Park', '2024-09-29 09:00:18', '2024-09-29 09:00:18');
COMMIT;

