https://bekasikota.go.id/ Leaked By Anonymous Indonesia & AnonGhost Indonesia

#Opindonesia
#AnonymousIndonesia
#AnewsIndonesia
#AnonGhostIndonesia
#TOLAKRUUKUHAP
#TOLAKRUUTNI
#TOLAKRUUPOLRI
#BERANTASMAFIAJUDOL
#HackThePlanet
#OpGovIndonesian



-- ON_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `stink`
--

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

--
-- Table structure for table `ass`
--

CREATE TABLE `ass` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ass` varchar(255) NOT NULL,
  `ket` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `diklat`
--

CREATE TABLE `diklat` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `sk` varchar(255) NOT NULL,
  `mb` varchar(255) NOT NULL,
  `judul` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `diklat`
--

INSERT INTO `diklat` (`id`, `file`, `type`, `sk`, `mb`, `judul`, `user_id`, `created_at`, `updated_at`) VALUES
(1, '9XtMbaZKmHADIdCzJ7rpS5kT00SR59932kwtfVKt.pdf', 'internal', '1', '2023-12-18', 'Diklat 1', 7, '2023-12-17 20:12:36', '2023-12-17 20:12:36');

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

--
-- 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 `identitas`
--

CREATE TABLE `identitas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `img` varchar(255) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `nik` varchar(255) NOT NULL,
  `tempat` varchar(255) NOT NULL,
  `tgl` date NOT NULL,
  `recredential` varchar(255) NOT NULL,
  `intansi` varchar(255) NOT NULL,
  `unit` varchar(255) NOT NULL,
  `masakerja` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `identitas`
--

INSERT INTO `identitas` (`id`, `img`, `nama`, `nik`, `tempat`, `tgl`, `recredential`, `intansi`, `unit`, `masakerja`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'mV7ev2GOuMV2JksS6B70rbEWE5bXmoYru9pHdxGW.png', 'Anisa Rahmania Nurmala', '1234567890123456', 'Bekasi', '2023-12-15', '2023-12-15', 'Instansi I', 'Unit I', '2023-12-15', 16, '2023-12-15 08:45:28', '2023-12-15 09:15:36');

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

--
-- Table structure for table `info`
--

CREATE TABLE `info` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `info` varchar(255) NOT NULL,
  `tgl` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) 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 `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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2023_11_29_032425_add_role_to_users_table', 1),
(5, '2023_11_30_025851_create_sip_table', 1),
(6, '2023_12_04_014326_create_diklat_table', 1),
(7, '2023_12_04_025515_create_rkk_table', 1),
(8, '2023_12_04_030855_create_ass_table', 1),
(9, '2023_12_04_052128_create_info_table', 1),
(10, '2023_12_04_132653_create_identitas_table', 1),
(11, '2023_12_05_031553_create_pengalaman_table', 1),
(12, '2023_12_05_040220_create_sertifikat_table', 1);

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

--
-- Table structure for table `password_resets`
--

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

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

--
-- Table structure for table `pengalaman`
--

CREATE TABLE `pengalaman` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `intansi` varchar(255) NOT NULL,
  `unit` varchar(255) NOT NULL,
  `masakerja` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `rkk`
--

CREATE TABLE `rkk` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `rkk` varchar(255) NOT NULL,
  `ket` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `sertifikat`
--

CREATE TABLE `sertifikat` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sertifikat` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `sip`
--

CREATE TABLE `sip` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sip` varchar(255) NOT NULL,
  `noreg` varchar(255) NOT NULL,
  `masa` varchar(255) NOT NULL,
  `rekom` varchar(255) NOT NULL,
  `mas` varchar(255) NOT NULL,
  `str` varchar(255) NOT NULL,
  `user_id` bigint(20) 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 `sip`
--

INSERT INTO `sip` (`id`, `sip`, `noreg`, `masa`, `rekom`, `mas`, `str`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'LKz4xppzfD1Y04ntys5HOnEjqtU6MLanlh99aaaK.pdf', 'No Regis', '2023-12-18', 'No rekom', '2023-12-18', 'nO52W5VBgN3iS9vYVaHXwapwStRPtwHamciiNQk9.pdf', 7, '2023-12-17 18:59:36', '2023-12-17 18:59:36'),
(2, 'HET8DQaC0ip50ViNdzBksg04OIlhEncxmRxZECEY.pdf', 'test', '2023-12-18', 'norek', '2023-12-30', 'LJZmhZHWxkiVaXa17ckxgBJmgQzc9VnhrMPsrjs4.pdf', 7, '2023-12-17 20:42:36', '2023-12-17 20:42:36');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `last_seen` varchar(255) DEFAULT NULL,
  `karu` bigint(20) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role` enum('perawat','komite','karu','kabid','admin','author') NOT NULL DEFAULT 'author'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `last_seen`, `karu`, `remember_token`, `created_at`, `updated_at`, `role`) VALUES
(1, 'Admin', '[email protected]', NULL, '$2y$10$5byW3R5qu5N6TnQCMQGCLumW81znPfCoOIXJVLsIK/cXINS1WVe2S', '2023-12-15 15:36:31', NULL, NULL, NULL, '2023-12-15 08:36:31', 'admin'),
(2, 'Karu 1', '[email protected]', NULL, '$2y$10$TJ7/f2PdaBp4T4CjQt5PteCAIMPxu/A/oTSL3DJvA.NfurNdwltvm', '2023-12-15 19:56:02', NULL, NULL, NULL, '2023-12-15 12:56:02', 'karu'),
(3, 'Karu 2', '[email protected]', NULL, '$2y$10$j/HLjdLqndbFx7ZlLPgvE.pIF2Y24fYRYyvgMv9xRE54b4j.WEmyS', NULL, NULL, NULL, NULL, NULL, 'karu'),
(4, 'Karu 3', '[email protected]', NULL, '$2y$10$bUcrtRD.aUJ0QD.SVhhslOrUYCDtZ52g/nxsDZ8BvSoCAnr/dyiUq', NULL, NULL, NULL, NULL, NULL, 'karu'),
(5, 'Kabid', '[email protected]', NULL, '$2y$10$7YdRt/sz3MUEZN6sXKJW.OWMbM0Q1Ns8E0PByO/.VmEOagKIO.KMO', '2023-12-16 01:30:56', NULL, NULL, NULL, '2023-12-15 18:30:56', 'kabid'),
(6, 'Komite', '[email protected]', NULL, '$2y$10$7yMxapjxqvhohoEqnNTMDO9yzHe2v4iQWEqhk1ee/n64it6yQVwde', '2023-12-15 22:04:39', NULL, NULL, NULL, '2023-12-15 15:04:39', 'komite'),
(7, 'Perawat 1', '[email protected]', NULL, '$2y$10$GfV2gMk1DBvHmmkff3XUTuK2IUTt4egK2OTp3Zavs.sHEX06VDoP6', '2023-12-18 03:48:54', NULL, NULL, NULL, '2023-12-17 20:48:54', 'perawat'),
(8, 'Perawat 2', '[email protected]', NULL, '$2y$10$aWc3cJ4jpCE5qr1Ho3mEwevvU/Bxa6etekZlBfgmhMrekTjNiOCCy', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(9, 'Perawat 3', '[email protected]', NULL, '$2y$10$AP9RUDy08T2pterJVBVkt.Tag8Jg.DaZORFnRTM2SxuzZ1G/gfgD.', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(10, 'Perawat 4', '[email protected]', NULL, '$2y$10$DWtY9tSY1NIGzBXHWVmH5eszziu77AaaotCAuZ3nypsTFGzHiPude', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(11, 'Perawat 5', '[email protected]', NULL, '$2y$10$WDVEMow.YRRgOiSMvfxiJ.FLHyT47tgWmUAKe.CMzhODTByEYSH4a', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(12, 'Perawat 6', '[email protected]', NULL, '$2y$10$s6Z9DtQ6tf35t5elWxZdnedOSgTudQaGBNHVNVMey8rMefo4g.Kka', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(13, 'Perawat 7', '[email protected]', NULL, '$2y$10$rtXu.s7zNDE92U5EOmiRk.lSFSYCSeNxQAvsg.W/Zu.aGDQR6nMTS', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(14, 'Perawat 8', '[email protected]', NULL, '$2y$10$Vyxbp35zO57fUVn4HMYc0ujYtHb6JA/WCRsz.EFCo9Ud2e36xlZdu', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(15, 'Perawat 9', '[email protected]', NULL, '$2y$10$knpAdFlhJLRO.f555e.ENe2cJrgOQwKQj5Ygng.ZgEEHNs5kKjpWa', NULL, NULL, NULL, NULL, NULL, 'perawat'),
(16, 'Perawat 101', '[email protected]', NULL, '$2y$10$XHaRc4qLZ9nskx7W3QyIae9Wx./XmyXHnQYD9MOaHFzF/Vwm8gf42', '2023-12-15 17:04:50', NULL, NULL, '2023-12-15 08:28:41', '2023-12-15 10:04:50', 'perawat');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `diklat`
--
ALTER TABLE `diklat`
  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 `identitas`
--
ALTER TABLE `identitas`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
COMMIT;

/*!;