text: -- MySQL dump 10.13  Distrib 5.7.28, for Linux (x86_64)
  --
  -- Host: localhost    Database: linmas
  -- ------------------------------------------------------
  -- Server version	5.7.28-0ubuntu0.16.04.2
  
  /*!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 utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `activity_log`
  --
  
  DROP TABLE IF EXISTS `activity_log`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `activity_log` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `log_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `subject_id` int(11) DEFAULT NULL,
    `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `causer_id` int(11) DEFAULT NULL,
    `causer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `properties` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `activity_log_log_name_index` (`log_name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=614 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `adminis`
  --
  
  DROP TABLE IF EXISTS `adminis`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `adminis` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) NOT NULL,
    `hak_akses` int(3) NOT NULL,
    `password` varchar(255) NOT NULL,
    `kd_kec` char(11) NOT NULL,
    `kd_kel_des` char(11) NOT NULL,
    `jns_sapras` int(11) NOT NULL,
    `regu_anggota` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `aset_limas`
  --
  
  DROP TABLE IF EXISTS `aset_limas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `aset_limas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` text COLLATE utf8mb4_unicode_ci,
    `id_kelurahan` text COLLATE utf8mb4_unicode_ci,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `kode_aset` text COLLATE utf8mb4_unicode_ci,
    `jumlah` text COLLATE utf8mb4_unicode_ci,
    `tahun_produksi` text COLLATE utf8mb4_unicode_ci,
    `tahun_perolehan` text COLLATE utf8mb4_unicode_ci,
    `merk` text COLLATE utf8mb4_unicode_ci,
    `kondisi` text COLLATE utf8mb4_unicode_ci,
    `foto` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `content_publikasis`
  --
  
  DROP TABLE IF EXISTS `content_publikasis`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `content_publikasis` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_publikasi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `judul` text COLLATE utf8mb4_unicode_ci,
    `deskripsi` longtext COLLATE utf8mb4_unicode_ci,
    `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kd_kec` text COLLATE utf8mb4_unicode_ci,
    `kel_des` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `detail_pembinaan`
  --
  
  DROP TABLE IF EXISTS `detail_pembinaan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `detail_pembinaan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_linmas` int(11) NOT NULL,
    `id_pembinaan` int(11) NOT NULL,
    `id_user` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `jabatan`
  --
  
  DROP TABLE IF EXISTS `jabatan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `jabatan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `jenis_linmas`
  --
  
  DROP TABLE IF EXISTS `jenis_linmas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `jenis_linmas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `uraian` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `jnsPublikasi`
  --
  
  DROP TABLE IF EXISTS `jnsPublikasi`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `jnsPublikasi` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `jns_sapras`
  --
  
  DROP TABLE IF EXISTS `jns_sapras`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `jns_sapras` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(255) NOT NULL,
    `status` int(11) NOT NULL DEFAULT '2',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `jns_tugas`
  --
  
  DROP TABLE IF EXISTS `jns_tugas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `jns_tugas` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nm_tugas` varchar(255) NOT NULL,
    `sifat` int(11) NOT NULL COMMENT '1: Rutin, 2: Berkala',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `kategori_laporan`
  --
  
  DROP TABLE IF EXISTS `kategori_laporan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kategori_laporan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `kecamatans`
  --
  
  DROP TABLE IF EXISTS `kecamatans`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kecamatans` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `kecamatan` text COLLATE utf8mb4_unicode_ci,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `telp` text COLLATE utf8mb4_unicode_ci,
    `fax` text COLLATE utf8mb4_unicode_ci,
    `nama_camat` text COLLATE utf8mb4_unicode_ci,
    `nip_camat` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `kelurahans`
  --
  
  DROP TABLE IF EXISTS `kelurahans`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kelurahans` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kelurahan` text COLLATE utf8mb4_unicode_ci,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `telp` text COLLATE utf8mb4_unicode_ci,
    `fax` text COLLATE utf8mb4_unicode_ci,
    `email` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `linmas`
  --
  
  DROP TABLE IF EXISTS `linmas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `linmas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_kelurahan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `no_angota` text COLLATE utf8mb4_unicode_ci,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `tempat_lahir` text COLLATE utf8mb4_unicode_ci,
    `tgl_lahir` text COLLATE utf8mb4_unicode_ci,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `hp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` text COLLATE utf8mb4_unicode_ci,
    `agama` text COLLATE utf8mb4_unicode_ci,
    `gol_darah` text COLLATE utf8mb4_unicode_ci,
    `pendidikan` text COLLATE utf8mb4_unicode_ci,
    `no_ktp` text COLLATE utf8mb4_unicode_ci,
    `jenis_kelamin` text COLLATE utf8mb4_unicode_ci,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `alamat_kecamatan` text COLLATE utf8mb4_unicode_ci,
    `alamat_kelurahan` text COLLATE utf8mb4_unicode_ci,
    `rt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `rw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status_linmas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `jenis_linmas` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `jabatan` text COLLATE utf8mb4_unicode_ci,
    `no_sk` text COLLATE utf8mb4_unicode_ci,
    `foto` text COLLATE utf8mb4_unicode_ci,
    `keterangan` text COLLATE utf8mb4_unicode_ci,
    `uk_baju` text COLLATE utf8mb4_unicode_ci,
    `uk_sepatu` text COLLATE utf8mb4_unicode_ci,
    `user_id` int(10) unsigned DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `jenis_linmas` (`jenis_linmas`),
    KEY `id_kecamatan` (`id_kecamatan`),
    KEY `id_kelurahan` (`id_kelurahan`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `linmas_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `lokasis`
  --
  
  DROP TABLE IF EXISTS `lokasis`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `lokasis` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` text COLLATE utf8mb4_unicode_ci,
    `id_kelurahan` text COLLATE utf8mb4_unicode_ci,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `lokasi` text COLLATE utf8mb4_unicode_ci,
    `kondisi` text COLLATE utf8mb4_unicode_ci,
    `kelengkapan` text COLLATE utf8mb4_unicode_ci,
    `sarpras` text COLLATE utf8mb4_unicode_ci,
    `aktifitas` text COLLATE utf8mb4_unicode_ci,
    `foto` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `pages`
  --
  
  DROP TABLE IF EXISTS `pages`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `pages` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `password_resets`
  --
  
  DROP TABLE IF EXISTS `password_resets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `pelaporans`
  --
  
  DROP TABLE IF EXISTS `pelaporans`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `pelaporans` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `judul` text COLLATE utf8mb4_unicode_ci,
    `deskripsi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_laporan` int(11) DEFAULT NULL,
    `kd_kec` text COLLATE utf8mb4_unicode_ci,
    `kel_des` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `pembinaans`
  --
  
  DROP TABLE IF EXISTS `pembinaans`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `pembinaans` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `lokasi` text COLLATE utf8mb4_unicode_ci,
    `kegiatan` text COLLATE utf8mb4_unicode_ci,
    `tanggal_mulai` date DEFAULT NULL,
    `tanggal_selesai` date DEFAULT NULL,
    `penyelengara` text COLLATE utf8mb4_unicode_ci,
    `narasumber` text COLLATE utf8mb4_unicode_ci,
    `user_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `pendaftarans`
  --
  
  DROP TABLE IF EXISTS `pendaftarans`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `pendaftarans` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_kelurahan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `hp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `no_ktp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `jenis_kelamin` text COLLATE utf8mb4_unicode_ci,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `alamat_kecamatan` text COLLATE utf8mb4_unicode_ci,
    `alamat_kelurahan` text COLLATE utf8mb4_unicode_ci,
    `rt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `rw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `foto` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `penugasan_linmas`
  --
  
  DROP TABLE IF EXISTS `penugasan_linmas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `penugasan_linmas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_linmas` text COLLATE utf8mb4_unicode_ci,
    `id_user` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `penugasans`
  --
  
  DROP TABLE IF EXISTS `penugasans`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `penugasans` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_kelurahan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status_pendaftaran` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `permission_role`
  --
  
  DROP TABLE IF EXISTS `permission_role`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `permission_role` (
    `permission_id` int(10) unsigned NOT NULL,
    `role_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`permission_id`,`role_id`),
    KEY `permission_role_role_id_foreign` (`role_id`),
    CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
    CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `permissions`
  --
  
  DROP TABLE IF EXISTS `permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `permissions` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `pos_jagas`
  --
  
  DROP TABLE IF EXISTS `pos_jagas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `pos_jagas` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_kelurahan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `alamat_kec` text COLLATE utf8mb4_unicode_ci,
    `alamat_kel` text COLLATE utf8mb4_unicode_ci,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `luas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `konstruksi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kondisi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kepemilikan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `luas_tanah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kelengkapan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `sarana` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `aktifitas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keterangan` text COLLATE utf8mb4_unicode_ci,
    `foto` text COLLATE utf8mb4_unicode_ci,
    `user_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `poskamlings`
  --
  
  DROP TABLE IF EXISTS `poskamlings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `poskamlings` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` text COLLATE utf8mb4_unicode_ci,
    `id_kelurahan` text COLLATE utf8mb4_unicode_ci,
    `nama` text COLLATE utf8mb4_unicode_ci,
    `lokasi` text COLLATE utf8mb4_unicode_ci,
    `kondisi` text COLLATE utf8mb4_unicode_ci,
    `kelengkapan` text COLLATE utf8mb4_unicode_ci,
    `sarpras` text COLLATE utf8mb4_unicode_ci,
    `aktifitas` text COLLATE utf8mb4_unicode_ci,
    `foto` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `regu`
  --
  
  DROP TABLE IF EXISTS `regu`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `regu` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `role_user`
  --
  
  DROP TABLE IF EXISTS `role_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `role_user` (
    `role_id` int(10) unsigned NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`role_id`,`user_id`),
    KEY `role_user_user_id_foreign` (`user_id`),
    CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
    CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `roles`
  --
  
  DROP TABLE IF EXISTS `roles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `sapras`
  --
  
  DROP TABLE IF EXISTS `sapras`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sapras` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `id_kecamatan` text COLLATE utf8mb4_unicode_ci,
    `id_kelurahan` text COLLATE utf8mb4_unicode_ci,
    `jenis_sapras` text COLLATE utf8mb4_unicode_ci,
    `merk` text COLLATE utf8mb4_unicode_ci,
    `type` text COLLATE utf8mb4_unicode_ci,
    `spesifikasi` text COLLATE utf8mb4_unicode_ci,
    `ket_item` text COLLATE utf8mb4_unicode_ci,
    `keterangan` text COLLATE utf8mb4_unicode_ci,
    `tahun` text COLLATE utf8mb4_unicode_ci,
    `kondisi` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `settings`
  --
  
  DROP TABLE IF EXISTS `settings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `settings` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `settings_key_unique` (`key`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `surat_keputusan`
  --
  
  DROP TABLE IF EXISTS `surat_keputusan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `surat_keputusan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nomor` text NOT NULL,
    `tanggal` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `temp_pembinaan`
  --
  
  DROP TABLE IF EXISTS `temp_pembinaan`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `temp_pembinaan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_linmas` int(10) unsigned NOT NULL,
    `id_user` int(10) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    KEY `id_linmas` (`id_linmas`),
    KEY `id_user` (`id_user`),
    CONSTRAINT `temp_pembinaan_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `uploads`
  --
  
  DROP TABLE IF EXISTS `uploads`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `uploads` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `filename` varchar(255) NOT NULL,
    `resized_name` varchar(255) NOT NULL,
    `original_name` varchar(255) NOT NULL,
    `modul` varchar(255) DEFAULT NULL,
    `user` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password2nd` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `kd_kec` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kel_des` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nm_kec` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nm_kel_des` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` int(3) NOT NULL,
    `level` int(3) NOT NULL,
    `adminis` int(3) NOT NULL,
    `user` int(3) NOT NULL,
    `anggota` int(3) NOT NULL,
    `pengasahaan` int(3) NOT NULL,
    `pembinaan` int(3) NOT NULL,
    `posKamling` int(3) NOT NULL,
    `sapras` int(3) NOT NULL,
    `publikasi` int(3) NOT NULL,
    `pelaporan` int(3) NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `users_login`
  --
  
  DROP TABLE IF EXISTS `users_login`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users_login` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `refid_user` int(11) NOT NULL,
    `nama` varchar(255) NOT NULL,
    `kd_kec` varchar(255) NOT NULL,
    `kel_des` varchar(255) NOT NULL,
    `nm_kec` varchar(255) NOT NULL,
    `nm_kel_des` varchar(255) NOT NULL,
    `login` datetime NOT NULL,
    `logout` datetime NOT NULL,
    `status_login` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wilayah`
  --
  
  DROP TABLE IF EXISTS `wilayah`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wilayah` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `kd_prov` char(11) NOT NULL,
    `kd_kota_kab` char(11) NOT NULL,
    `kd_kec` char(11) NOT NULL,
    `kd_kel_des` char(11) NOT NULL,
    `nama` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=379 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!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 */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2020-01-16 11:29:39
  