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

START TRANSACTION;



--
-- Database: `apphris`
--

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

--
-- Table structure for table `auto_shifts`
--

CREATE TABLE `auto_shifts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jabatan_id` bigint(20) UNSIGNED NOT NULL,
  `shift_id` bigint(20) UNSIGNED NOT 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 `counters`
--

CREATE TABLE `counters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `text` varchar(191) NOT NULL,
  `counter` 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;

--
-- Dumping data for table `counters`
--

INSERT INTO `counters` (`id`, `name`, `text`, `counter`, `created_at`, `updated_at`) VALUES
(1, 'Gaji', 'GJ', 1, '2025-01-12 23:19:09', '2025-01-12 23:50:48');

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

--
-- Table structure for table `cutis`
--

CREATE TABLE `cutis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `nama_cuti` varchar(191) NOT NULL,
  `tanggal` varchar(191) NOT NULL,
  `alasan_cuti` text NOT NULL,
  `foto_cuti` varchar(191) DEFAULT NULL,
  `status_cuti` varchar(191) NOT NULL,
  `catatan` varchar(191) 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 `cutis`
--

INSERT INTO `cutis` (`id`, `user_id`, `nama_cuti`, `tanggal`, `alasan_cuti`, `foto_cuti`, `status_cuti`, `catatan`, `created_at`, `updated_at`) VALUES
(1, 1, 'Cuti', '2025-01-14', 'CUTI SAJA', 'foto_cuti/Zh3swypTf4ftjk5DJZOCaowp1eJprxbGxT4N0Vdz.jpg', 'Pending', NULL, '2025-01-13 07:24:18', '2025-01-13 07:24:18'),
(2, 1, 'Cuti', '2025-01-15', 'CUTI SAJA', 'foto_cuti/Zh3swypTf4ftjk5DJZOCaowp1eJprxbGxT4N0Vdz.jpg', 'Pending', NULL, '2025-01-13 07:24:18', '2025-01-13 07:24:18');

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

--
-- Table structure for table `dinas_luars`
--

CREATE TABLE `dinas_luars` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `shift_id` bigint(20) UNSIGNED NOT NULL,
  `tanggal` varchar(191) NOT NULL,
  `jam_absen` varchar(191) DEFAULT NULL,
  `telat` varchar(191) DEFAULT NULL,
  `lat_absen` varchar(191) DEFAULT NULL,
  `long_absen` varchar(191) DEFAULT NULL,
  `foto_jam_absen` varchar(191) DEFAULT NULL,
  `jam_pulang` varchar(191) DEFAULT NULL,
  `pulang_cepat` varchar(191) DEFAULT NULL,
  `foto_jam_pulang` varchar(191) DEFAULT NULL,
  `lat_pulang` varchar(191) DEFAULT NULL,
  `long_pulang` varchar(191) DEFAULT NULL,
  `status_absen` varchar(191) 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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) 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 `files`
--

CREATE TABLE `files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jenis_file` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fileUpload` varchar(191) NOT 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 `golongans`
--

CREATE TABLE `golongans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `golongans`
--

INSERT INTO `golongans` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'DIREKSI', '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(2, 'KABAG', '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(3, 'STAFF', '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(4, 'PELAKSANA', '2025-01-12 23:19:09', '2025-01-12 23:19:09');

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

--
-- Table structure for table `jabatans`
--

CREATE TABLE `jabatans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_jabatan` varchar(191) NOT NULL,
  `manager` bigint(20) UNSIGNED 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 `jabatans`
--

INSERT INTO `jabatans` (`id`, `nama_jabatan`, `manager`, `created_at`, `updated_at`) VALUES
(1, 'Teknologi Informasi', 1, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(2, 'Keuangan dan Akutansi', NULL, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(3, 'Administrasi & Umum', NULL, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(4, 'Humas & Pemasaran', NULL, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(5, 'Sekretariat', NULL, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(6, 'Direktur', NULL, '2025-01-12 23:19:09', '2025-01-12 23:19:09');

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

--
-- Table structure for table `kasbons`
--

CREATE TABLE `kasbons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `nominal` int(11) NOT NULL,
  `keperluan` text NOT NULL,
  `status` varchar(191) NOT 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 `lemburs`
--

CREATE TABLE `lemburs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `tanggal` varchar(191) NOT NULL,
  `jam_masuk` varchar(191) NOT NULL,
  `lat_masuk` varchar(191) NOT NULL,
  `long_masuk` varchar(191) NOT NULL,
  `jarak_masuk` varchar(191) NOT NULL,
  `foto_jam_masuk` varchar(191) NOT NULL,
  `jam_keluar` varchar(191) DEFAULT NULL,
  `lat_keluar` varchar(191) DEFAULT NULL,
  `long_keluar` varchar(191) DEFAULT NULL,
  `jarak_keluar` varchar(191) DEFAULT NULL,
  `foto_jam_keluar` varchar(191) DEFAULT NULL,
  `total_lembur` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `notes` varchar(191) DEFAULT NULL,
  `approved_by` bigint(20) UNSIGNED 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 `lokasis`
--

CREATE TABLE `lokasis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_lokasi` varchar(191) NOT NULL,
  `lat_kantor` varchar(191) DEFAULT NULL,
  `long_kantor` varchar(191) DEFAULT NULL,
  `radius` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED 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 `lokasis`
--

INSERT INTO `lokasis` (`id`, `nama_lokasi`, `lat_kantor`, `long_kantor`, `radius`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Kantor Cabang A', '-6.5832669', '107.7754766', '200', 'approved', 1, '2025-01-12 23:19:09', '2025-01-13 00:16:28');

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

--
-- Table structure for table `mapping_shifts`
--

CREATE TABLE `mapping_shifts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `shift_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tanggal` date NOT NULL,
  `jam_absen` varchar(191) DEFAULT NULL,
  `telat` varchar(191) DEFAULT NULL,
  `lat_absen` varchar(191) DEFAULT NULL,
  `long_absen` varchar(191) DEFAULT NULL,
  `jarak_masuk` varchar(191) DEFAULT NULL,
  `foto_jam_absen` varchar(191) DEFAULT NULL,
  `keterangan_masuk` varchar(191) DEFAULT NULL,
  `jam_pulang` varchar(191) DEFAULT NULL,
  `pulang_cepat` varchar(191) DEFAULT NULL,
  `lat_pulang` varchar(191) DEFAULT NULL,
  `long_pulang` varchar(191) DEFAULT NULL,
  `jarak_pulang` varchar(191) DEFAULT NULL,
  `foto_jam_pulang` varchar(191) DEFAULT NULL,
  `keterangan_pulang` varchar(191) DEFAULT NULL,
  `status_absen` varchar(191) DEFAULT NULL,
  `lock_location` varchar(191) DEFAULT NULL,
  `jam_masuk_pengajuan` varchar(191) DEFAULT NULL,
  `jam_pulang_pengajuan` varchar(191) DEFAULT NULL,
  `deskripsi` varchar(191) DEFAULT NULL,
  `status_pengajuan` varchar(191) DEFAULT NULL,
  `file_pengajuan` varchar(191) DEFAULT NULL,
  `komentar` varchar(191) DEFAULT NULL,
  `approved_by` bigint(20) UNSIGNED 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 `mapping_shifts`
--

INSERT INTO `mapping_shifts` (`id`, `user_id`, `shift_id`, `tanggal`, `jam_absen`, `telat`, `lat_absen`, `long_absen`, `jarak_masuk`, `foto_jam_absen`, `keterangan_masuk`, `jam_pulang`, `pulang_cepat`, `lat_pulang`, `long_pulang`, `jarak_pulang`, `foto_jam_pulang`, `keterangan_pulang`, `status_absen`, `lock_location`, `jam_masuk_pengajuan`, `jam_pulang_pengajuan`, `deskripsi`, `status_pengajuan`, `file_pengajuan`, `komentar`, `approved_by`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '2025-01-01', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(2, 1, 2, '2025-01-02', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(3, 1, 2, '2025-01-03', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(4, 1, 2, '2025-01-04', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(5, 1, 2, '2025-01-05', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(6, 1, 2, '2025-01-06', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(7, 1, 2, '2025-01-07', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(8, 1, 2, '2025-01-08', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(9, 1, 2, '2025-01-09', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(10, 1, 2, '2025-01-10', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(11, 1, 2, '2025-01-11', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(12, 1, 2, '2025-01-12', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(13, 1, 2, '2025-01-13', '13:27', '19620', '-6.5778708', '107.7795222', '0', 'foto_jam_absen/6784b23557681.png', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:27:01'),
(14, 1, 2, '2025-01-14', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(15, 1, 2, '2025-01-15', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(16, 1, 2, '2025-01-16', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(17, 1, 2, '2025-01-17', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(18, 1, 2, '2025-01-18', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(19, 1, 2, '2025-01-19', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(20, 1, 2, '2025-01-20', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(21, 1, 2, '2025-01-21', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(22, 1, 2, '2025-01-22', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(23, 1, 2, '2025-01-23', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(24, 1, 2, '2025-01-24', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(25, 1, 2, '2025-01-25', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(26, 1, 2, '2025-01-26', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(27, 1, 2, '2025-01-27', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(28, 1, 2, '2025-01-28', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(29, 1, 2, '2025-01-29', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(30, 1, 2, '2025-01-30', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(31, 1, 2, '2025-01-31', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 06:19:51', '2025-01-13 06:19:51'),
(32, 2, 2, '2025-01-01', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(33, 2, 2, '2025-01-02', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(34, 2, 2, '2025-01-03', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(35, 2, 2, '2025-01-04', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(36, 2, 2, '2025-01-05', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(37, 2, 2, '2025-01-06', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(38, 2, 2, '2025-01-07', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(39, 2, 2, '2025-01-08', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(40, 2, 2, '2025-01-09', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(41, 2, 2, '2025-01-10', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(42, 2, 2, '2025-01-11', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(43, 2, 2, '2025-01-12', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(45, 2, 2, '2025-01-14', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(46, 2, 2, '2025-01-15', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(47, 2, 2, '2025-01-16', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(48, 2, 2, '2025-01-17', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(49, 2, 2, '2025-01-18', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(50, 2, 2, '2025-01-19', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(51, 2, 2, '2025-01-20', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(52, 2, 2, '2025-01-21', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(53, 2, 2, '2025-01-22', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(54, 2, 2, '2025-01-23', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(55, 2, 2, '2025-01-24', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(56, 2, 2, '2025-01-25', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(57, 2, 2, '2025-01-26', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(58, 2, 2, '2025-01-27', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(59, 2, 2, '2025-01-28', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(60, 2, 2, '2025-01-29', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(61, 2, 2, '2025-01-30', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(62, 2, 2, '2025-01-31', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Tidak Masuk', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:14:37', '2025-01-13 07:14:37'),
(63, 2, 2, '2025-01-13', '14:19', '22740', '-6.5832669', '107.7754766', '0', 'foto_jam_absen/6784be640d488.png', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, 'Masuk', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-13 07:18:31', '2025-01-13 07:19:00');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_09_16_095447_create_shifts_table', 1),
(6, '2022_09_19_032649_create_mapping_shifts_table', 1),
(7, '2022_09_20_074944_create_lemburs_table', 1),
(8, '2022_09_20_092230_create_cutis_table', 1),
(9, '2022_10_31_083510_create_lokasis_table', 1),
(10, '2022_11_02_061554_create_reset_cutis_table', 1),
(11, '2022_12_01_041742_create_sips_table', 1),
(12, '2022_12_14_080034_create_jabatans_table', 1),
(13, '2023_03_22_103407_create_dinas_luars_table', 1),
(14, '2023_04_10_130307_create_auto_shifts_table', 1),
(15, '2023_06_28_042019_create_files_table', 1),
(16, '2023_07_15_095632_create_tunjangans_table', 1),
(17, '2023_07_16_152608_create_golongans_table', 1),
(18, '2023_07_19_122052_create_status_ptkps_table', 1),
(19, '2023_07_20_082307_create_pajaks_table', 1),
(20, '2023_07_21_085614_create_payrolls_table', 1),
(21, '2023_12_05_140334_create_counters_table', 1),
(22, '2023_12_06_163716_create_kasbons_table', 1),
(23, '2024_06_15_075202_create_notifications_table', 1),
(24, '2024_07_27_095429_create_settings_table', 1);

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

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

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) 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 `pajaks`
--

CREATE TABLE `pajaks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `bulan` varchar(191) NOT NULL,
  `tahun` varchar(191) NOT 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 `payrolls`
--

CREATE TABLE `payrolls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `bulan` varchar(191) NOT NULL,
  `tahun` varchar(191) NOT NULL,
  `persentase_kehadiran` varchar(191) NOT NULL,
  `no_gaji` varchar(191) NOT NULL,
  `gaji_pokok` int(11) NOT NULL,
  `uang_transport` int(11) NOT NULL,
  `jumlah_mangkir` int(11) NOT NULL,
  `uang_mangkir` int(11) NOT NULL,
  `total_mangkir` int(11) NOT NULL,
  `jumlah_lembur` int(11) NOT NULL,
  `uang_lembur` int(11) NOT NULL,
  `total_lembur` int(11) NOT NULL,
  `jumlah_izin` int(11) NOT NULL,
  `uang_izin` int(11) NOT NULL,
  `total_izin` int(11) NOT NULL,
  `jumlah_bonus` int(11) NOT NULL,
  `uang_bonus` int(11) NOT NULL,
  `total_bonus` int(11) NOT NULL,
  `jumlah_terlambat` int(11) NOT NULL,
  `uang_terlambat` int(11) NOT NULL,
  `total_terlambat` int(11) NOT NULL,
  `jumlah_kehadiran` int(11) NOT NULL,
  `uang_kehadiran` int(11) NOT NULL,
  `total_kehadiran` int(11) NOT NULL,
  `saldo_kasbon` int(11) NOT NULL,
  `bayar_kasbon` int(11) NOT NULL,
  `jumlah_thr` int(11) NOT NULL,
  `uang_thr` int(11) NOT NULL,
  `total_thr` int(11) NOT NULL,
  `loss` int(11) NOT NULL,
  `total_penjumlahan` int(11) NOT NULL,
  `total_pengurangan` int(11) NOT NULL,
  `grand_total` 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;

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

--
-- Table structure for table `reset_cutis`
--

CREATE TABLE `reset_cutis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `izin_cuti` varchar(191) NOT NULL,
  `izin_dinas_luar` varchar(191) NOT NULL,
  `izin_sakit` varchar(191) NOT NULL,
  `izin_cek_kesehatan` varchar(191) NOT NULL,
  `izin_keperluan_pribadi` varchar(191) NOT NULL,
  `izin_telat` varchar(191) NOT NULL,
  `izin_pulang_cepat` varchar(191) NOT NULL,
  `izin_lainnya` varchar(191) 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 `reset_cutis`
--

INSERT INTO `reset_cutis` (`id`, `izin_cuti`, `izin_dinas_luar`, `izin_sakit`, `izin_cek_kesehatan`, `izin_keperluan_pribadi`, `izin_telat`, `izin_pulang_cepat`, `izin_lainnya`, `created_at`, `updated_at`) VALUES
(1, '10', '10', '10', '10', '10', '10', '10', '10', '2025-01-12 23:19:09', '2025-01-12 23:19:09');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `logo` varchar(191) DEFAULT NULL,
  `alamat` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) 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 `settings`
--

INSERT INTO `settings` (`id`, `name`, `logo`, `alamat`, `phone`, `email`, `created_at`, `updated_at`) VALUES
(1, 'Absensi Pegawai', 'logo/SEch7V4csLjKaUgaS2jG2SItxin7hWmzavrul2Ud.png', 'Indonesia', '081902753442', 'absensi@gmail.com', '2025-01-12 23:19:09', '2025-01-12 23:49:11');

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

--
-- Table structure for table `shifts`
--

CREATE TABLE `shifts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_shift` varchar(191) NOT NULL,
  `jam_masuk` varchar(191) NOT NULL,
  `jam_keluar` varchar(191) 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 `shifts`
--

INSERT INTO `shifts` (`id`, `nama_shift`, `jam_masuk`, `jam_keluar`, `created_at`, `updated_at`) VALUES
(1, 'Libur', '00:00', '00:00', '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(2, 'Office', '08:00', '17:00', '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(3, 'Siang', '13:00', '21:00', '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(4, 'Malam', '21:00', '07:00', '2025-01-12 23:19:09', '2025-01-12 23:19:09');

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

--
-- Table structure for table `sips`
--

CREATE TABLE `sips` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `nama_dokumen` varchar(191) NOT NULL,
  `tanggal_berakhir` varchar(191) NOT NULL,
  `file` varchar(191) 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 `sips`
--

INSERT INTO `sips` (`id`, `user_id`, `nama_dokumen`, `tanggal_berakhir`, `file`, `created_at`, `updated_at`) VALUES
(1, 1, 'CV', '2025-01-13', 'file/zh2SfWxqMMlzfQCphi6XwshcZATn1iPJXdHZHQYs.pdf', '2025-01-13 00:23:36', '2025-01-13 00:23:36');

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

--
-- Table structure for table `status_ptkps`
--

CREATE TABLE `status_ptkps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `ptkp_2016` decimal(15,2) NOT NULL DEFAULT 0.00,
  `ptkp_2015` decimal(15,2) NOT NULL DEFAULT 0.00,
  `ptkp_2009_2012` decimal(15,2) NOT NULL DEFAULT 0.00,
  `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 `status_ptkps`
--

INSERT INTO `status_ptkps` (`id`, `name`, `ptkp_2016`, `ptkp_2015`, `ptkp_2009_2012`, `created_at`, `updated_at`) VALUES
(1, 'TK/0', 54000000.00, 36000000.00, 15840000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(2, 'TK/1', 58500000.00, 39000000.00, 17160000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(3, 'TK/2', 63000000.00, 42000000.00, 18480000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(4, 'TK/3', 67500000.00, 45000000.00, 19800000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09');

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

--
-- Table structure for table `tunjangans`
--

CREATE TABLE `tunjangans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `golongan_id` bigint(20) UNSIGNED NOT NULL,
  `tunjangan_makan` decimal(15,2) NOT NULL DEFAULT 0.00,
  `tunjangan_transport` decimal(15,2) NOT NULL DEFAULT 0.00,
  `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 `tunjangans`
--

INSERT INTO `tunjangans` (`id`, `golongan_id`, `tunjangan_makan`, `tunjangan_transport`, `created_at`, `updated_at`) VALUES
(1, 1, 20000.00, 20000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(2, 2, 30000.00, 20000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09'),
(3, 3, 30000.00, 30000.00, '2025-01-12 23:19:09', '2025-01-12 23:19:09');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- Indexes for table `jabatans`
--
ALTER TABLE `jabatans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jabatans_manager_foreign` (`manager`);

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

--
-- Indexes for table `lemburs`
--
ALTER TABLE `lemburs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lemburs_approved_by_foreign` (`approved_by`);

--
-- Indexes for table `lokasis`
--
ALTER TABLE `lokasis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lokasis_created_by_foreign` (`created_by`);

--
-- Indexes for table `mapping_shifts`
--
ALTER TABLE `mapping_shifts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mapping_shifts_approved_by_foreign` (`approved_by`);

--
-- 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 `pajaks`
--
ALTER TABLE `pajaks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pajaks_status_id_foreign` (`status_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `jabatans`
--
ALTER TABLE `jabatans`
  ADD CONSTRAINT `jabatans_manager_foreign` FOREIGN KEY (`manager`) REFERENCES `users` (`id`);

--
-- Constraints for table `lemburs`
--
ALTER TABLE `lemburs`
  ADD CONSTRAINT `lemburs_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `lokasis`
--
ALTER TABLE `lokasis`
  ADD CONSTRAINT `lokasis_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `mapping_shifts`
--
ALTER TABLE `mapping_shifts`
  ADD CONSTRAINT `mapping_shifts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `pajaks`
--
ALTER TABLE `pajaks`
  ADD CONSTRAINT `pajaks_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status_ptkps` (`id`);
COMMIT;

