-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 19 Feb 2023 pada 07.04
-- Versi server: 10.4.24-MariaDB
-- Versi PHP: 8.1.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `laravelinvbe`
--

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

--
-- Struktur dari tabel `banners`
--

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

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

--
-- Struktur dari tabel `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_kategori` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `categories`
--

INSERT INTO `categories` (`id`, `nama_kategori`, `created_at`, `updated_at`) VALUES
(1, 'Alat Sedang', '2023-02-18 23:00:10', '2023-02-18 23:00:10'),
(2, 'Kendaraan', '2023-02-18 23:00:10', '2023-02-18 23:00:10');

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

--
-- Struktur dari tabel `distribusis`
--

CREATE TABLE `distribusis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kota_penerima` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_distribusi` date DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan_distribusi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `distribusi_items`
--

CREATE TABLE `distribusi_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_distribusi` bigint(20) UNSIGNED NOT NULL,
  `id_logistik` bigint(20) UNSIGNED NOT NULL,
  `jumlah` int(11) NOT NULL,
  `status` int(11) 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;

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

--
-- Struktur dari tabel `failed_jobs`
--

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

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

--
-- Struktur dari tabel `inventaris`
--

CREATE TABLE `inventaris` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_inv` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_tipe` bigint(20) UNSIGNED NOT NULL,
  `id_kota` bigint(20) UNSIGNED NOT NULL,
  `jmlh_inv` int(11) NOT NULL,
  `foto_inv` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan_inv` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `inventaris`
--

INSERT INTO `inventaris` (`id`, `nama_inv`, `id_tipe`, `id_kota`, `jmlh_inv`, `foto_inv`, `keterangan_inv`, `created_at`, `updated_at`) VALUES
(1, 'Laptop', 1, 1, 3, 'https://media.wired.com/photos/5fb2cc575c9914713ead03de/1:1/w_1358,h_1358,c_limit/Gear-Apple-MacBook-Air-top-down-SOURCE-Apple.jpg', 'Laptop Kantor', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(2, 'Ambulan', 2, 1, 2, 'https://pict.sindonews.net/dyn/600/pena/sindo-article/original/2021/07/19/ambulans-apv.jpg', 'Ambulan Urgent', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(3, 'Laptop', 1, 2, 4, 'https://media.wired.com/photos/5fb2cc575c9914713ead03de/1:1/w_1358,h_1358,c_limit/Gear-Apple-MacBook-Air-top-down-SOURCE-Apple.jpg', 'Laptop Kantor', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(4, 'Ambulan', 2, 2, 1, 'https://pict.sindonews.net/dyn/600/pena/sindo-article/original/2021/07/19/ambulans-apv.jpg', 'Ambulan Urgent Binjai', '2023-02-18 23:00:09', '2023-02-18 23:00:09');

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

--
-- Struktur dari tabel `kategori_l_s`
--

CREATE TABLE `kategori_l_s` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_kategoril` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `kategori_l_s`
--

INSERT INTO `kategori_l_s` (`id`, `nama_kategoril`, `created_at`, `updated_at`) VALUES
(1, 'Makanan', '2023-02-18 23:00:10', '2023-02-18 23:00:10');

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

--
-- Struktur dari tabel `kondisis`
--

CREATE TABLE `kondisis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_barang` bigint(20) UNSIGNED NOT NULL,
  `baik` int(11) NOT NULL,
  `rusak_ringan` int(11) NOT NULL,
  `rusak_sedang` int(11) NOT NULL,
  `rusak_berat` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `kotas`
--

CREATE TABLE `kotas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_zona` bigint(20) UNSIGNED NOT NULL,
  `nama_kota` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_kota` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `kotas`
--

INSERT INTO `kotas` (`id`, `id_zona`, `nama_kota`, `kode_kota`, `created_at`, `updated_at`) VALUES
(1, 1, 'Medan', '1271', '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(2, 1, 'Binjai', '1275', '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(3, 1, 'Deli Serdang', '1207', '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(4, 1, 'Langkat', '1205', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(5, 2, 'Simalungun', '1208', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(6, 2, 'Tebing Tinggi', '1276', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(7, 2, 'Barubara', '1219', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(8, 2, 'Serdang Bedagai', '1218', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(9, 2, 'Pematang Siantar', '1272', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(10, 3, 'Tanjung Balai', '1274', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(11, 3, 'Asahan', '1209', '2023-02-18 23:00:04', '2023-02-18 23:00:04'),
(12, 3, 'Labuhan Batu Utara', '1223', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(13, 3, 'Labuhan Batu', '1210', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(14, 4, 'Labuhan Batu Selatan', '1222', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(15, 4, 'Padang Lawas Utara', '1220', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(16, 4, 'Padang Lawas', '1221', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(17, 5, 'Padangsidempuan', '1277', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(18, 5, 'Mandailing Natal', '1213', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(19, 5, 'Tapanuli Selatan', '1203', '2023-02-18 23:00:05', '2023-02-18 23:00:05'),
(20, 6, 'Sibolga', '1273', '2023-02-18 23:00:06', '2023-02-18 23:00:06'),
(21, 6, 'Tapanuli Tengah', '1201', '2023-02-18 23:00:06', '2023-02-18 23:00:06'),
(22, 6, 'Tapanuli Utara', '1202', '2023-02-18 23:00:06', '2023-02-18 23:00:06'),
(23, 6, 'Toba', '1212', '2023-02-18 23:00:06', '2023-02-18 23:00:06'),
(24, 6, 'Humbang Hasundutan', '1216', '2023-02-18 23:00:06', '2023-02-18 23:00:06'),
(25, 7, 'Dairi', '1211', '2023-02-18 23:00:06', '2023-02-18 23:00:06'),
(26, 7, 'Pakpak Barat', '1215', '2023-02-18 23:00:07', '2023-02-18 23:00:07'),
(27, 7, 'Samosir', '1217', '2023-02-18 23:00:07', '2023-02-18 23:00:07'),
(28, 7, 'Karo', '1206', '2023-02-18 23:00:07', '2023-02-18 23:00:07'),
(29, 8, 'Nias', '1204', '2023-02-18 23:00:07', '2023-02-18 23:00:07'),
(30, 8, 'Nias Selatan', '1214', '2023-02-18 23:00:08', '2023-02-18 23:00:08'),
(31, 8, 'Nias Barat', '1225', '2023-02-18 23:00:08', '2023-02-18 23:00:08'),
(32, 8, 'Nias Utara', '1224', '2023-02-18 23:00:08', '2023-02-18 23:00:08'),
(33, 8, 'Gunung Sitoli', '1278', '2023-02-18 23:00:08', '2023-02-18 23:00:08');

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

--
-- Struktur dari tabel `laporans`
--

CREATE TABLE `laporans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_zona` bigint(20) UNSIGNED NOT NULL,
  `id_kota` bigint(20) UNSIGNED DEFAULT NULL,
  `id_jenis_bencana` bigint(20) UNSIGNED NOT NULL,
  `nama_kota` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelurahan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_laporan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `foto_brg_keluar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_brg_kembali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tgl_laporan` date DEFAULT NULL,
  `tgl_brg_keluar` date DEFAULT NULL,
  `tgl_brg_terima` date DEFAULT NULL,
  `tgl_brg_kembali` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `logistiks`
--

CREATE TABLE `logistiks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_kota` bigint(20) UNSIGNED NOT NULL,
  `nama_logistik` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kategori_logistik` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_logistik` int(11) DEFAULT NULL,
  `satuan_logistik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_logistik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sumber_dana_logistik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_logistik` date DEFAULT NULL,
  `tahunexp_logistik` date DEFAULT NULL,
  `keterangan_logistik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `migrations`
--

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

--
-- Dumping data untuk tabel `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_12_06_100634_create_kotas_table', 1),
(6, '2022_12_06_100649_create_zonas_table', 1),
(7, '2022_12_10_084936_create_inventaris_table', 1),
(8, '2022_12_10_085656_create_tipe_inventaris_table', 1),
(9, '2022_12_10_144823_create_laporans_table', 1),
(10, '2022_12_10_145120_create_pivot_laporans_table', 1),
(11, '2022_12_16_155112_create_peralatan_table', 1),
(12, '2022_12_16_173450_create_logistiks_table', 1),
(13, '2022_12_16_225031_create_cetegories_table', 1),
(14, '2022_12_18_084007_create_kondisis_table', 1),
(15, '2022_12_18_090906_create_kategori_l_s_table', 1),
(16, '2022_12_18_143624_create_distribusi_items_table', 1),
(17, '2022_12_18_143642_create_distribusis_table', 1),
(18, '2022_12_20_044228_create_pinjams_table', 1),
(19, '2022_12_20_044415_create_pinjam_items_table', 1),
(20, '2022_12_20_125643_create_permintaans_table', 1),
(21, '2022_12_20_125907_create_permintaan_barangs_table', 1),
(22, '2022_12_20_132608_create_banners_table', 1);

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

--
-- Struktur dari tabel `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `peralatans`
--

CREATE TABLE `peralatans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_kota` bigint(20) UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah` int(11) DEFAULT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kategori` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sumber_dana_peralatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun` date DEFAULT NULL,
  `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `peralatans`
--

INSERT INTO `peralatans` (`id`, `id_kota`, `nama`, `jumlah`, `foto`, `kategori`, `sumber_dana_peralatan`, `tahun`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:11', '2023-02-18 23:00:11'),
(2, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:11', '2023-02-18 23:00:11'),
(3, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:11', '2023-02-18 23:00:11'),
(4, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:11', '2023-02-18 23:00:11'),
(5, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:11', '2023-02-18 23:00:11'),
(6, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:11', '2023-02-18 23:00:11'),
(7, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(8, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(9, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(10, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(11, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(12, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(13, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:12', '2023-02-18 23:00:12'),
(14, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(15, 1, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(16, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(17, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(18, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(19, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(20, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(21, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:13', '2023-02-18 23:00:13'),
(22, 2, 'Mobil', 1, NULL, 'Kendaraan', 'asasa', '2020-10-10', NULL, '2023-02-18 23:00:14', '2023-02-18 23:00:14');

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

--
-- Struktur dari tabel `permintaans`
--

CREATE TABLE `permintaans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_user` bigint(20) UNSIGNED NOT NULL,
  `kabupaten` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelurahan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_bencana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `permintaan_barangs`
--

CREATE TABLE `permintaan_barangs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_permintaan` bigint(20) UNSIGNED NOT NULL,
  `nama_permintaan_barang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_permintaan_barang` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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;

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

--
-- Struktur dari tabel `pinjams`
--

CREATE TABLE `pinjams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kota_penerima` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_pinjam` date DEFAULT NULL,
  `tanggal_balik` date DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan_pinjam` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `pinjam_items`
--

CREATE TABLE `pinjam_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_pinjam` bigint(20) UNSIGNED NOT NULL,
  `id_peralatan` bigint(20) UNSIGNED NOT NULL,
  `jumlah` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `pivot_laporans`
--

CREATE TABLE `pivot_laporans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_laporan` bigint(20) UNSIGNED NOT NULL,
  `id_inventaris` bigint(20) UNSIGNED NOT NULL,
  `jmlh_dipakai` int(11) NOT NULL,
  `status_brg` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `tipe_inventaris`
--

CREATE TABLE `tipe_inventaris` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_tipe` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan_tipe` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `tipe_inventaris`
--

INSERT INTO `tipe_inventaris` (`id`, `nama_tipe`, `keterangan_tipe`, `created_at`, `updated_at`) VALUES
(1, 'Peralatan', 'Mencakup Barang-Barang Elektronik', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(2, 'Logistik', 'Mencakup Ambulan, Mobil Dinas Dll', '2023-02-18 23:00:10', '2023-02-18 23:00:10');

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

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_kota` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_hp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `role` int(11) NOT NULL DEFAULT 0,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci 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 untuk tabel `users`
--

INSERT INTO `users` (`id`, `id_kota`, `name`, `nip`, `no_hp`, `status`, `role`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 2, 'Admin', '222012121111134', '082134567890', 1, 1, 'admin@gmail.com', NULL, '$2y$10$niWSo3Z4ev3wKPuNtT61seW/GjMTtUM78j/XP7RTFyvA4fEDw2B/e', NULL, '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(2, 3, 'Admin2', '222012121111134', '082134567890', 1, 1, 'admin2@gmail.com', NULL, '$2y$10$iPZE0hkvasSfu2u.UrguwOyNKPobFTfYtaXSDKdKR7ZNx/Knxa6hq', NULL, '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(3, NULL, 'Superadmin', '322012121111134', '085334567890', 1, 2, 'superadmin@gmail.com', NULL, '$2y$10$SouTElZVMKCU9iJKq1cLyevIbEeC5fmwy4ZBBLSKwZ6dv2kzncJe.', NULL, '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(4, 2, 'User', '122012121111134', '081234567890', 1, 0, 'user@gmail.com', NULL, '$2y$10$SRwOJPo5/7nTBlpGCfSXF.RsjWBSLcignbbsnOvHltI2xlQKI/7rC', NULL, '2023-02-18 23:00:03', '2023-02-18 23:00:03'),
(5, 3, 'User2', '122012121111134', '081234567890', 0, 0, 'user2@gmail.com', NULL, '$2y$10$lxNEmwPeSdS3FmX55JaOb.dEnRQdSK/cS7Agvr4RCoxjNhwu6jdCa', NULL, '2023-02-18 23:00:03', '2023-02-18 23:00:03');

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

--
-- Struktur dari tabel `zonas`
--

CREATE TABLE `zonas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_zona` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_zona` varchar(255) COLLATE utf8mb4_unicode_ci 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 untuk tabel `zonas`
--

INSERT INTO `zonas` (`id`, `nama_zona`, `kode_zona`, `created_at`, `updated_at`) VALUES
(1, 'Zona I', 'ZI', '2023-02-18 23:00:08', '2023-02-18 23:00:08'),
(2, 'Zona II', 'ZII', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(3, 'Zona III', 'ZIII', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(4, 'Zona IV', 'ZIV', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(5, 'Zona V', 'ZV', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(6, 'Zona VI', 'ZVI', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(7, 'Zona VII', 'ZVII', '2023-02-18 23:00:09', '2023-02-18 23:00:09'),
(8, 'Zona VII', 'ZVIII', '2023-02-18 23:00:09', '2023-02-18 23:00:09');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `distribusis`
--
ALTER TABLE `distribusis`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `distribusi_items`
--
ALTER TABLE `distribusi_items`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `inventaris`
--
ALTER TABLE `inventaris`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `kategori_l_s`
--
ALTER TABLE `kategori_l_s`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `kondisis`
--
ALTER TABLE `kondisis`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `kotas`
--
ALTER TABLE `kotas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kotas_kode_kota_unique` (`kode_kota`);

--
-- Indeks untuk tabel `laporans`
--
ALTER TABLE `laporans`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `logistiks`
--
ALTER TABLE `logistiks`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indeks untuk tabel `peralatans`
--
ALTER TABLE `peralatans`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `permintaans`
--
ALTER TABLE `permintaans`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `permintaan_barangs`
--
ALTER TABLE `permintaan_barangs`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indeks untuk tabel `pinjams`
--
ALTER TABLE `pinjams`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `pinjam_items`
--
ALTER TABLE `pinjam_items`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `pivot_laporans`
--
ALTER TABLE `pivot_laporans`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `tipe_inventaris`
--
ALTER TABLE `tipe_inventaris`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indeks untuk tabel `zonas`
--
ALTER TABLE `zonas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `zonas_kode_zona_unique` (`kode_zona`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `distribusis`
--
ALTER TABLE `distribusis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `distribusi_items`
--
ALTER TABLE `distribusi_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT untuk tabel `inventaris`
--
ALTER TABLE `inventaris`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `kategori_l_s`
--
ALTER TABLE `kategori_l_s`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `kondisis`
--
ALTER TABLE `kondisis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `kotas`
--
ALTER TABLE `kotas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT untuk tabel `laporans`
--
ALTER TABLE `laporans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `logistiks`
--
ALTER TABLE `logistiks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT untuk tabel `peralatans`
--
ALTER TABLE `peralatans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT untuk tabel `permintaans`
--
ALTER TABLE `permintaans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `permintaan_barangs`
--
ALTER TABLE `permintaan_barangs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `pinjams`
--
ALTER TABLE `pinjams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `pinjam_items`
--
ALTER TABLE `pinjam_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `pivot_laporans`
--
ALTER TABLE `pivot_laporans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `tipe_inventaris`
--
ALTER TABLE `tipe_inventaris`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `zonas`
--
ALTER TABLE `zonas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;