text: -- Adminer 4.8.1-dev MySQL 5.7.26 dump
  
  SET NAMES utf8;
  SET time_zone = '+00:00';
  SET foreign_key_checks = 0;
  SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  
  SET NAMES utf8mb4;
  
  DROP TABLE IF EXISTS `absensis`;
  CREATE TABLE `absensis` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(10) unsigned NOT NULL,
    `jam_hadir` datetime NOT NULL,
    `jam_pulang` datetime DEFAULT NULL,
    `ket_hadir` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `ket_pulang` text COLLATE utf8mb4_unicode_ci,
    `lat_hadir` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `long_hadir` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `lat_pulang` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `long_pulang` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `jam_kerja` double DEFAULT NULL,
    `jam_lembur` double DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `absensis` (`id`, `id_user`, `jam_hadir`, `jam_pulang`, `ket_hadir`, `ket_pulang`, `lat_hadir`, `long_hadir`, `lat_pulang`, `long_pulang`, `jam_kerja`, `jam_lembur`) VALUES
  (1,	1,	'2021-12-22 13:59:03',	NULL,	'hadir pak',	NULL,	'-8.6179148',	'115.1925648',	NULL,	NULL,	NULL,	NULL),
  (2,	3,	'2021-12-27 14:51:01',	NULL,	'absen hadir',	NULL,	'-8.6179135',	'115.1925721',	NULL,	NULL,	NULL,	NULL),
  (3,	1,	'2021-12-27 16:30:37',	NULL,	'hadir',	NULL,	'-8.6179142',	'115.1925948',	NULL,	NULL,	NULL,	NULL),
  (4,	1,	'2021-12-27 16:31:07',	NULL,	'hadir',	NULL,	'-8.6179142',	'115.1925948',	NULL,	NULL,	NULL,	NULL),
  (5,	1,	'2021-12-30 17:07:19',	NULL,	'hadir',	NULL,	'-8.6179159',	'115.1925795',	NULL,	NULL,	NULL,	NULL),
  (6,	2,	'2022-01-13 18:07:47',	NULL,	'hadir',	NULL,	'-8.6178917',	'115.1925541',	NULL,	NULL,	NULL,	NULL),
  (7,	2,	'2022-01-14 09:18:41',	NULL,	'hadir',	NULL,	'-8.6178923',	'115.1925302',	NULL,	NULL,	NULL,	NULL),
  (8,	2,	'2022-01-21 15:30:19',	NULL,	'hadir pagi',	NULL,	'-8.6178948',	'115.1925934',	NULL,	NULL,	NULL,	NULL);
  
  DROP TABLE IF EXISTS `cabangs`;
  CREATE TABLE `cabangs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_admin` int(10) unsigned NOT NULL,
    `cabang_nama` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
    `cabang_email` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `cabang_phone` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `cabang_alamat` text COLLATE utf8mb4_unicode_ci,
    `cabang_umk` double DEFAULT NULL,
    `lembur_dasar` double DEFAULT NULL,
    `lembur_h1` double DEFAULT NULL,
    `lembur_h2` double DEFAULT NULL,
    `lembur_h9` double DEFAULT NULL,
    `lembur_h10` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `cabangs` (`id`, `id_admin`, `cabang_nama`, `cabang_email`, `cabang_phone`, `cabang_alamat`, `cabang_umk`, `lembur_dasar`, `lembur_h1`, `lembur_h2`, `lembur_h9`, `lembur_h10`, `created_at`, `updated_at`) VALUES
  (1,	1,	'Asta Pijar',	'info@astapijar.id',	'085161100210',	'Jalan Gunung Galunggung Nomor 8A',	0,	0,	0,	0,	0,	0,	'2021-12-15 03:04:35',	'2021-12-15 03:04:35'),
  (2,	1,	'Pemprov Bali',	'info@astapijar.id',	'085161100210',	'Jalan Gunung Galunggung Nomor 8A',	2445000,	0,	0,	0,	0,	0,	'2021-12-15 03:04:35',	'2021-12-15 03:04:35'),
  (11,	1,	'Kantor Pusat BPD Bali',	NULL,	'0361',	'Jalan Niti Mandala Renon',	2770300,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-01-10 08:02:32',	'2022-01-10 08:02:32'),
  (12,	1,	'Asta Nadi Karya Utama',	NULL,	'0361 9090 963',	'Denpasar',	3500000,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-01-10 08:40:48',	'2022-01-10 08:40:48'),
  (13,	1,	'Asta Widya Wahana',	NULL,	'0361 9090 963',	'Denpasar',	3500000,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-01-10 08:40:48',	'2022-01-10 08:40:48');
  
  DROP TABLE IF EXISTS `cutis`;
  CREATE TABLE `cutis` (
    `id_cuti` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `cuti_awal` date NOT NULL,
    `cuti_akhir` date NOT NULL,
    `cuti_total` double NOT NULL,
    `cuti_deskripsi` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `cuti_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id_cuti`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `cutis` (`id_cuti`, `id_user`, `cuti_awal`, `cuti_akhir`, `cuti_total`, `cuti_deskripsi`, `cuti_status`, `created_at`, `updated_at`) VALUES
  (1,	3,	'2021-12-29',	'2021-12-29',	1,	'halo',	'DITERIMA',	'2021-12-27 03:48:26',	'2022-01-20 07:17:06'),
  (2,	3,	'2021-12-31',	'2022-01-01',	2,	'latihan',	'DITERIMA',	'2021-12-27 05:08:20',	'2022-01-20 07:17:09'),
  (3,	1,	'2021-12-30',	'2022-01-01',	3,	'minta izin',	'PENDING',	'2021-12-30 08:38:05',	'2021-12-30 08:38:05');
  
  DROP TABLE IF EXISTS `divisis`;
  CREATE TABLE `divisis` (
    `div_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `div_title` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
    `div_desc` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`div_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `failed_jobs`;
  CREATE TABLE `failed_jobs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `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,
    PRIMARY KEY (`id`),
    UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `izins`;
  CREATE TABLE `izins` (
    `id_izin` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `izin_awal` date NOT NULL,
    `izin_akhir` date NOT NULL,
    `izin_total` double NOT NULL,
    `izin_deskripsi` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `izin_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id_izin`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `kegiatans`;
  CREATE TABLE `kegiatans` (
    `id_kgt` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` bigint(20) unsigned NOT NULL,
    `tanggal_kgt` date NOT NULL,
    `title_kgt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `desc_kgt` text COLLATE utf8mb4_unicode_ci,
    `jam_kgt` time NOT NULL,
    `rating_kgt` int(11) DEFAULT NULL,
    `comm_kgt` text COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (`id_kgt`),
    KEY `id_user` (`id_user`),
    CONSTRAINT `kegiatans_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `kegiatans` (`id_kgt`, `id_user`, `tanggal_kgt`, `title_kgt`, `desc_kgt`, `jam_kgt`, `rating_kgt`, `comm_kgt`) VALUES
  (1,	1,	'2021-12-30',	'Setup Komputer',	'-Setup\r\n-Install Ulang',	'16:12:16',	NULL,	NULL),
  (2,	1,	'2021-12-30',	'Install Ulang',	'Punya mak pus',	'16:28:44',	NULL,	NULL),
  (3,	2,	'2022-01-14',	'Setup Komputer',	'Hilang',	'14:53:28',	NULL,	NULL),
  (4,	3,	'2022-01-25',	'2022-01-25',	'Corporis debitis min',	'18:49:00',	NULL,	NULL),
  (5,	3,	'2022-01-25',	'2022-01-25',	'Corporis debitis min',	'18:49:00',	NULL,	NULL),
  (6,	3,	'2022-01-25',	'2022-01-25',	'hadiri upacara pembukaan gapra',	'11:10:00',	NULL,	NULL);
  
  DROP TABLE IF EXISTS `kegiatan_galleries`;
  CREATE TABLE `kegiatan_galleries` (
    `id_galeri` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_kegiatan` int(11) NOT NULL,
    `kg_photo_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id_galeri`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `kegiatan_galleries` (`id_galeri`, `id_kegiatan`, `kg_photo_url`) VALUES
  (2,	6,	'Damasius Wikaryana Utama_kegiatan_1643082829.png'),
  (3,	6,	'Damasius Wikaryana Utama_kegiatan_1643083014.png'),
  (5,	5,	'Damasius Wikaryana Utama_kegiatan_1643087881.jpg'),
  (6,	5,	'Damasius Wikaryana Utama_kegiatan_1643087896.webp'),
  (7,	5,	'Damasius Wikaryana Utama_kegiatan_1643093232.png');
  
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  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,	'2021_12_14_105958_create_user_galleries_table',	1),
  (6,	'2021_12_14_110019_create_user_salaries_table',	1),
  (7,	'2021_12_14_110038_create_user_potongans_table',	1),
  (8,	'2021_12_14_110151_create_user_tunjangans_table',	1),
  (9,	'2021_12_14_110226_create_payrolls_table',	1),
  (13,	'2021_12_15_105540_create_cabangs_table',	2),
  (14,	'2021_12_14_110237_create_cutis_table',	3),
  (15,	'2021_12_14_110251_create_izins_table',	3),
  (16,	'2021_12_14_110300_create_absensis_table',	3),
  (17,	'2021_12_16_121631_create_user_personalias_table',	3),
  (18,	'2016_06_01_000001_create_oauth_auth_codes_table',	4),
  (19,	'2016_06_01_000002_create_oauth_access_tokens_table',	4),
  (20,	'2016_06_01_000003_create_oauth_refresh_tokens_table',	4),
  (21,	'2016_06_01_000004_create_oauth_clients_table',	4),
  (22,	'2016_06_01_000005_create_oauth_personal_access_clients_table',	4),
  (23,	'2021_12_27_164825_create_user_shifts_table',	5),
  (24,	'2021_12_28_104505_create_shifts_table',	6),
  (26,	'2021_12_30_144146_create_kegiatans_table',	7),
  (27,	'2021_12_30_144322_create_kegiatan_galleries_table',	7),
  (28,	'2021_12_30_074313_create_divisis_table',	8),
  (29,	'2022_01_04_100534_create_user_configs_table',	9);
  
  DROP TABLE IF EXISTS `oauth_access_tokens`;
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) unsigned DEFAULT NULL,
    `client_id` bigint(20) unsigned NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_access_tokens_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
  ('01da82425d60f612cf2eacb409b60dfaf9d9bcf5f90bc8abc64633f753b22ecd5914f05d5450dc06',	1,	3,	'nApp',	'[]',	0,	'2021-12-23 04:45:17',	'2021-12-23 04:45:17',	'2022-12-23 12:45:17'),
  ('045e24821046b1be195a5149f517cd3ac7eebf1aeeaf9922ca233900a3091dc4301ec2500c0dcd69',	3,	3,	'nApp',	'[]',	0,	'2021-12-23 04:44:35',	'2021-12-23 04:44:35',	'2022-12-23 12:44:35'),
  ('270e92ebe85ad2e2dc23e15a4d9eeab7a5029ba621267f88268fb4edf8e542a1c4b47979a685db50',	1,	3,	'nApp',	'[]',	0,	'2021-12-23 03:35:30',	'2021-12-23 03:35:30',	'2022-12-23 11:35:30'),
  ('3723348dfb73ce9eba52a2d8aa70c0b43ce550bd4d0438d53f29e2a49ea2f2f219435fc51e428f31',	1,	3,	'nApp',	'[]',	0,	'2021-12-23 04:43:38',	'2021-12-23 04:43:38',	'2022-12-23 12:43:38'),
  ('5989249f9241dedcf1aa84bb3d46bfa1a739c727935e4c90989b5b7bd66ec4aaea1f820a48fe0484',	1,	3,	'nApp',	'[]',	0,	'2021-12-23 03:39:48',	'2021-12-23 03:39:48',	'2022-12-23 11:39:48'),
  ('9365d99324f6e8bb46c4eafbab7ac0a2189394b4efe76e27b4a39af491c27c22aa595fb5894d2a0b',	3,	3,	'nApp',	'[]',	0,	'2021-12-23 03:34:53',	'2021-12-23 03:34:53',	'2022-12-23 11:34:53'),
  ('af7edf6404d9d8cda3af987b9b2bfb8e133564319fcf45aa29908b989cb27e47c5e2787a4977d4c4',	1,	3,	'nApp',	'[]',	0,	'2022-01-20 03:03:36',	'2022-01-20 03:03:36',	'2023-01-20 11:03:36'),
  ('bc9d658f7cd0855bdbb8e7b73c53192f8199d066635d1e17859d5919b9b9e31c634f2b8e858e4017',	1,	3,	'nApp',	'[]',	0,	'2022-01-20 03:27:41',	'2022-01-20 03:27:41',	'2023-01-20 11:27:41');
  
  DROP TABLE IF EXISTS `oauth_auth_codes`;
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) unsigned NOT NULL,
    `client_id` bigint(20) unsigned NOT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_auth_codes_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `oauth_clients`;
  CREATE TABLE `oauth_clients` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_clients_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
  (1,	NULL,	'Laravel Personal Access Client',	'JMtjsoph29NfNu7ymKeNUeEdEQuAl3Ffc98n0Bwq',	NULL,	'http://localhost',	1,	0,	0,	'2021-12-23 03:10:12',	'2021-12-23 03:10:12'),
  (2,	NULL,	'Laravel Password Grant Client',	'RnK1tlYgJO3x2mZoMEwxtfjllvuBbcrMtsIlx2Hk',	'users',	'http://localhost',	0,	1,	0,	'2021-12-23 03:10:12',	'2021-12-23 03:10:12'),
  (3,	NULL,	'Laravel Personal Access Client',	'LS862xQN3Qo20gbC31hqbFskl7gr16oeUC76olLw',	NULL,	'http://localhost',	1,	0,	0,	'2021-12-23 03:10:22',	'2021-12-23 03:10:22'),
  (4,	NULL,	'Laravel Password Grant Client',	'6QG927FFJLZGBR3jFCKu2ZAdre6ZshUhXZzlox5D',	'users',	'http://localhost',	0,	1,	0,	'2021-12-23 03:10:22',	'2021-12-23 03:10:22');
  
  DROP TABLE IF EXISTS `oauth_personal_access_clients`;
  CREATE TABLE `oauth_personal_access_clients` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
  (1,	1,	'2021-12-23 03:10:12',	'2021-12-23 03:10:12'),
  (2,	3,	'2021-12-23 03:10:22',	'2021-12-23 03:10:22');
  
  DROP TABLE IF EXISTS `oauth_refresh_tokens`;
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `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,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `payrolls`;
  CREATE TABLE `payrolls` (
    `id_pay` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `pay_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pay_bulan` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pay_tahun` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pay_pokok` double NOT NULL,
    `pay_description` text CHARACTER SET utf8mb4,
    `bpjs_tk_u` double DEFAULT NULL,
    `bpjs_tk_p` double DEFAULT NULL,
    `bpjs_kes_u` double DEFAULT NULL,
    `bpjs_kes_p` double DEFAULT NULL,
    `total_pot` double NOT NULL,
    `total_tj` double NOT NULL,
    `bruto` double NOT NULL,
    `netto` double NOT NULL,
    `pph21` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id_pay`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `payrolls` (`id_pay`, `id_user`, `pay_code`, `pay_bulan`, `pay_tahun`, `pay_pokok`, `pay_description`, `bpjs_tk_u`, `bpjs_tk_p`, `bpjs_kes_u`, `bpjs_kes_p`, `total_pot`, `total_tj`, `bruto`, `netto`, `pph21`, `created_at`, `updated_at`) VALUES
  (3,	2,	'ASTA-12-2021',	'12',	'2021',	3500000,	'Gaji Desember 2021',	105000,	218400,	35000,	140000,	540000,	500000,	4000000,	3460000,	NULL,	'2021-12-17 08:31:39',	'2021-12-17 08:31:39'),
  (4,	3,	'ASTA-12-2021',	'12',	'2021',	4500000,	'Gaji Desember 2021',	135000,	280800,	45000,	180000,	180000,	650000,	5150000,	4970000,	NULL,	'2021-12-17 08:31:39',	'2021-12-17 08:31:39');
  
  DROP TABLE IF EXISTS `personal_access_tokens`;
  CREATE TABLE `personal_access_tokens` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `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,
    `last_used_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
    KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `created_at`, `updated_at`) VALUES
  (1,	'App\\Models\\User',	1,	'nApp',	'224dc0be8aa6f4e8bc862938c18510439d4b96a56b8622a95fefda6f0095cdc3',	'[\"*\"]',	NULL,	'2021-12-23 03:21:14',	'2021-12-23 03:21:14'),
  (2,	'App\\Models\\User',	87,	'nApp',	'1ebf164414add7a6f5f0e17b34165975efed59a0e326cbe4e15b6eb72d9247ea',	'[\"*\"]',	NULL,	'2021-12-23 03:22:50',	'2021-12-23 03:22:50'),
  (3,	'App\\Models\\User',	87,	'nApp',	'4b000714147381701a754c895bae3cbc7ec480bb2b9c1199f5c95f93f9b9265e',	'[\"*\"]',	NULL,	'2021-12-23 03:28:47',	'2021-12-23 03:28:47'),
  (4,	'App\\Models\\User',	1,	'nApp',	'6b5301c6619573431218343246cf13bf9148cfea5006d1a02663c00a96d3f837',	'[\"*\"]',	NULL,	'2021-12-23 03:29:00',	'2021-12-23 03:29:00'),
  (5,	'App\\Models\\User',	1,	'nApp',	'e9e3949b060763b74ac8a8e5ec774a48c168eb0273ec3a1fdb3a6ed26644e61f',	'[\"*\"]',	NULL,	'2021-12-23 03:29:39',	'2021-12-23 03:29:39'),
  (6,	'App\\Models\\User',	1,	'nApp',	'9696c9d14c38dfea43febbce3655d9dc89c128f671e8c7973e17a2e3dcbf6ca1',	'[\"*\"]',	NULL,	'2021-12-23 03:32:12',	'2021-12-23 03:32:12'),
  (7,	'App\\Models\\User',	3,	'nApp',	'3958aa150af2280df20c9ecd7177b39e1a5494349eb0e5e6ee5937fab346d5e7',	'[\"*\"]',	NULL,	'2021-12-23 03:32:53',	'2021-12-23 03:32:53'),
  (8,	'App\\Models\\User',	3,	'nApp',	'80210c994aa1115e15f15009d4694b3bfb0a7147f0c283fedee6fe3bac5a7f60',	'[\"*\"]',	NULL,	'2021-12-23 03:32:54',	'2021-12-23 03:32:54');
  
  DROP TABLE IF EXISTS `shifts`;
  CREATE TABLE `shifts` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_admin` int(11) NOT NULL,
    `nama_shift` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ket_shift` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
    `hadir_shift` time NOT NULL,
    `pulang_shift` time NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `shifts` (`id`, `id_admin`, `nama_shift`, `ket_shift`, `hadir_shift`, `pulang_shift`) VALUES
  (1,	1,	'P',	'Pagi',	'07:00:00',	'19:00:00'),
  (2,	1,	'M',	'Malam',	'19:00:00',	'07:00:00'),
  (3,	1,	'L',	'Libur',	'00:00:00',	'00:00:00');
  
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_admin` int(11) DEFAULT NULL,
    `id_cabang` int(11) DEFAULT NULL,
    `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `gender` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `tanggungan` enum('TK/0','K/1','K/2','K/3') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `roles` enum('masteradmin','admin','user') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `bpjs_kes` enum('y','n') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `alamat` text COLLATE utf8mb4_unicode_ci,
    `email` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `company` text COLLATE utf8mb4_unicode_ci,
    `company_logo` text COLLATE utf8mb4_unicode_ci,
    `is_admin` tinyint(1) NOT NULL DEFAULT '0',
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_last_login_at` datetime DEFAULT NULL,
    `user_last_login_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `users` (`id`, `id_admin`, `id_cabang`, `nama`, `nip`, `username`, `gender`, `status`, `tanggungan`, `roles`, `bpjs_kes`, `alamat`, `email`, `phone`, `company`, `company_logo`, `is_admin`, `password`, `remember_token`, `user_last_login_at`, `user_last_login_ip`, `deleted_at`, `created_at`, `updated_at`) VALUES
  (1,	1,	NULL,	'Administrator',	'123000',	'masteradmin',	'Pria',	'active',	NULL,	'masteradmin',	NULL,	'Jalan Gunung Galunggung Nomor 8A Denpasar Utara, Bali 80116',	'admin@astapijar.id',	'085161100210',	'PT Asta Pijar Kreasi Digital',	'1_hadir_1642668465.webp',	1,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-14 04:16:50',	'2022-01-20 08:47:46'),
  (2,	1,	1,	'Anindita',	'321103',	'321103',	'Wanita',	'active',	'TK/0',	'user',	NULL,	'Denpasar',	'anin@astapijar.id',	'085161100210',	'PT Asta Pijar Kreasi Digital',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-14 04:16:50',	'2022-01-10 02:32:30'),
  (3,	1,	1,	'Damasius Wikaryana Utama',	'319101',	'319101',	'Pria',	'active',	'TK/0',	'user',	NULL,	'Denpasar, Bali',	'damas@astapijar.id',	'085161100210',	'PT Asta Pijar Kreasi Digital',	NULL,	0,	'$2y$10$j3zrCoWKOv9mBMpi.e.KOeElRwgcrOJ5VpPNCqw86Zad3UVampxpC',	NULL,	NULL,	NULL,	NULL,	'2021-12-14 04:16:50',	'2022-01-24 06:44:42'),
  (4,	1,	2,	'I Dewa Komang Wira Dharma',	'SPPB-001',	'SPPB-001',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (5,	1,	2,	'Igusti Ngurah Wijaya Putra',	'SPPB-002',	'SPPB-002',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (6,	1,	2,	'I Wayan Sukarsana',	'SPPB-003',	'SPPB-003',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (7,	1,	2,	'I Nyoman Krisna Widyantara',	'SPPB-004',	'SPPB-004',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (8,	1,	2,	'Ida Bagus Made Putra',	'SPPB-005',	'SPPB-005',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (9,	1,	2,	'I Dewa Gede Saputra',	'SPPB-006',	'SPPB-006',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (10,	1,	2,	'I Ketut Sudiarta',	'SPPB-007',	'SPPB-007',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (11,	1,	2,	'Iketut Sudirtawan',	'SPPB-008',	'SPPB-008',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (12,	1,	2,	'I Nyoman Sutanya',	'SPPB-009',	'SPPB-009',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (13,	1,	2,	'I Ketut Murdika',	'SPPB-010',	'SPPB-010',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (14,	1,	2,	'I Ketut Sukayasa',	'SPPB-011',	'SPPB-011',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (15,	1,	2,	'I Made Setiawan',	'SPPB-012',	'SPPB-012',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (16,	1,	2,	'I Made Sukardana',	'SPPB-013',	'SPPB-013',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (17,	1,	2,	'Nyoman Primantara Sinarida Kusuma',	'SPPB-014',	'SPPB-014',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (18,	1,	2,	'I Ketut Artana',	'SPPB-015',	'SPPB-015',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (19,	1,	2,	'Ketut Sudiarta',	'SPPB-016',	'SPPB-016',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (20,	1,	2,	'I Wayan Darta',	'SPPB-017',	'SPPB-017',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (21,	1,	2,	'Pande Kadek Bayu Semara',	'SPPB-018',	'SPPB-018',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (22,	1,	2,	'Dayu Komang Kerisna',	'SPPB-019',	'SPPB-019',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (23,	1,	2,	'Ni Made Mirayanti',	'SPPB-020',	'SPPB-020',	'Wanita',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (24,	1,	2,	'I Gede Urip Saputra',	'SPPB-021',	'SPPB-021',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (25,	1,	2,	'I Kadek Argita',	'SPPB-022',	'SPPB-022',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (26,	1,	2,	'Iputu Oka Purnama Putra',	'SPPB-023',	'SPPB-023',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (27,	1,	2,	'I Nyoman Kariada',	'SPPB-024',	'SPPB-024',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (28,	1,	2,	'I Made Gudarma Yasa',	'SPPB-025',	'SPPB-025',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (29,	1,	2,	'I Ketut Antarayasa',	'SPPB-026',	'SPPB-026',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (30,	1,	2,	'I Nyoman Muditayasa',	'SPPB-027',	'SPPB-027',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (31,	1,	2,	'I Wayan Mahindra Gunawan',	'SPPB-028',	'SPPB-028',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (32,	1,	2,	'I Putu Edik',	'SPPB-029',	'SPPB-029',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (33,	1,	2,	'I Dewa Putu Suarnama',	'SPPB-030',	'SPPB-030',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (34,	1,	2,	'Iwayan Gede Junaedi',	'SPPB-031',	'SPPB-031',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (35,	1,	2,	'I Gede Yudhi Ariyadi SH',	'SPPB-032',	'SPPB-032',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (36,	1,	2,	'I Made Endy Suryanta',	'SPPB-033',	'SPPB-033',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (37,	1,	2,	'I Ketut Wenten',	'SPPB-034',	'SPPB-034',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (38,	1,	2,	'Ikadek Suarmika',	'SPPB-035',	'SPPB-035',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (39,	1,	2,	'I Nyoman Wirajaya Kusuma',	'SPPB-036',	'SPPB-036',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (40,	1,	2,	'Tut De Widiantara',	'SPPB-037',	'SPPB-037',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (41,	1,	2,	'Sanjaya',	'SPPB-038',	'SPPB-038',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (42,	1,	2,	'I Gusti Ngurah Agung Nariana Putra',	'SPPB-039',	'SPPB-039',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (43,	1,	2,	'I Made Sukarsa',	'SPPB-040',	'SPPB-040',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (44,	1,	2,	'I Gede Wira Jayantara',	'SPPB-041',	'SPPB-041',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (45,	1,	2,	'Made Ariawan',	'SPPB-042',	'SPPB-042',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (46,	1,	2,	'I Wayan Jaya Antara',	'SPPB-043',	'SPPB-043',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (47,	1,	2,	'Ida Bagus Mas Putra Pertama',	'SPPB-044',	'SPPB-044',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (48,	1,	2,	'I Nyoman Sanjaya Anamerta',	'SPPB-045',	'SPPB-045',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (49,	1,	2,	'I Kadek Periawan',	'SPPB-046',	'SPPB-046',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (50,	1,	2,	'I Ketut Swastika Wijaya',	'SPPB-047',	'SPPB-047',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (51,	1,	2,	'I Made Sukma Tangkas Budianto',	'SPPB-048',	'SPPB-048',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (52,	1,	2,	'Anak Agung Ketut Wirawan',	'SPPB-049',	'SPPB-049',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (53,	1,	2,	'I Gusti Ketut Alit Arnawa',	'SPPB-050',	'SPPB-050',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (54,	1,	2,	'I Nyoman Subagia',	'SPPB-051',	'SPPB-051',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (55,	1,	2,	'I Made Sumendra',	'SPPB-052',	'SPPB-052',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (56,	1,	2,	'I Nyoman Sukada',	'SPPB-053',	'SPPB-053',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (57,	1,	2,	'I Made Putra Jaya',	'SPPB-054',	'SPPB-054',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (58,	1,	2,	'I Made Ardi Canis Cahyana',	'SPPB-055',	'SPPB-055',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (59,	1,	2,	'I Ketut Gde Sudarma',	'SPPB-056',	'SPPB-056',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (60,	1,	2,	'I Nyoman Candra Putra',	'SPPB-057',	'SPPB-057',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (61,	1,	2,	'I Gusti Ngurah Okta Jaya',	'SPPB-058',	'SPPB-058',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (62,	1,	2,	'Gede Maha Bawana',	'SPPB-059',	'SPPB-059',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (63,	1,	2,	'I Gusti Nyoman Tri Teja Arnawa',	'SPPB-060',	'SPPB-060',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (64,	1,	2,	'Imade Adnyana',	'SPPB-061',	'SPPB-061',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (65,	1,	2,	'I Nyoman Sukayadnya',	'SPPB-062',	'SPPB-062',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (66,	1,	2,	'I Wayan Lanus',	'SPPB-063',	'SPPB-063',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (67,	1,	2,	'Pande Bagus Pryatama',	'SPPB-064',	'SPPB-064',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (68,	1,	2,	'Dewa Putu Yuniartha Tedja Utama',	'SPPB-065',	'SPPB-065',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (69,	1,	2,	'I Nyoman Sudarsa',	'SPPB-066',	'SPPB-066',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (70,	1,	2,	'Ni Kadek Elly Sucita Wati',	'SPPB-067',	'SPPB-067',	'Wanita',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (71,	1,	2,	'I Wayan Yogi Wirawan',	'SPPB-068',	'SPPB-068',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (72,	1,	2,	'I Made Sudiarta',	'SPPB-069',	'SPPB-069',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (73,	1,	2,	'I Gusti Agung Ketut Suardita',	'SPPB-070',	'SPPB-070',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (74,	1,	2,	'Dewa Made Rai Budiasa',	'SPPB-071',	'SPPB-071',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (75,	1,	2,	'Putu Dion Mahesa Prathama',	'SPPB-072',	'SPPB-072',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (76,	1,	2,	'I Wayan Karsika',	'SPPB-073',	'SPPB-073',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (77,	1,	2,	'I Ketut Suta Arnawan',	'SPPB-074',	'SPPB-074',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (78,	1,	2,	'I Made Rai Priyana',	'SPPB-075',	'SPPB-075',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (79,	1,	2,	'I Wayan Sadiasa S.Ap.',	'SPPB-076',	'SPPB-076',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (80,	1,	2,	'I Made Dwi Eriyasa',	'SPPB-077',	'SPPB-077',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (81,	1,	2,	'Komang Roi Yudi Putra',	'SPPB-078',	'SPPB-078',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (82,	1,	2,	'I Made Suaka',	'SPPB-079',	'SPPB-079',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (83,	1,	2,	'I Wayan Candra',	'SPPB-080',	'SPPB-080',	'Pria',	'active',	NULL,	'user',	'n',	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-17 07:27:52'),
  (84,	1,	2,	'Dewa made Putra Dharma Utama',	'SPPB-081',	'SPPB-081',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (85,	1,	2,	'Ida Bagus Diyatmika',	'SPPB-082',	'SPPB-082',	'Pria',	'active',	NULL,	'user',	NULL,	'Denpasar',	'sppb01@astagojob.com',	'08123456789',	'Satpam Pemerintah Provinsi Bali',	NULL,	0,	'$2y$10$kSfntBIJDO4w/lqmb8QORejBk.l/Db8wMocRwLRyZ/95SktbCNXXW',	NULL,	NULL,	NULL,	NULL,	'2021-12-15 04:16:00',	'2021-12-15 04:16:00'),
  (95,	95,	NULL,	'Dio Restu',	NULL,	'diorestu',	NULL,	'active',	NULL,	'admin',	NULL,	'Jalan Kusuma Bangsa 2 Nomor 288 DD\r\nBr. Kusuma Jati, Denpasar Utara',	'diorestusaputra@gmail.com',	'085156432635',	'PT Inti Kreasi Digital',	NULL,	1,	'$2y$10$J6Ni9dMPOzlZyow/m.LCJOLR35ETyb7/AI4JszTJloUPTZinwlHIW',	NULL,	NULL,	NULL,	NULL,	'2022-01-11 06:24:40',	'2022-01-12 01:15:47');
  
  DROP TABLE IF EXISTS `user_configs`;
  CREATE TABLE `user_configs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_admin` int(10) unsigned NOT NULL,
    `layout_mode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nomor_surat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `max_user` double DEFAULT NULL,
    `tipe_akun` enum('basic','advance','pro') COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_first` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `user_configs` (`id`, `id_admin`, `layout_mode`, `nomor_surat`, `max_user`, `tipe_akun`, `is_first`, `created_at`, `updated_at`) VALUES
  (1,	1,	'dark',	'OS-2022',	100,	'basic',	'n',	'2022-01-11 07:21:39',	'2022-01-11 07:21:39'),
  (2,	95,	'dark',	'OS-2022',	100,	'basic',	'n',	'2022-01-11 07:21:39',	'2022-01-11 08:43:43');
  
  DROP TABLE IF EXISTS `user_galleries`;
  CREATE TABLE `user_galleries` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `photo_url` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `photo_roles` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `user_galleries` (`id`, `id_user`, `photo_url`, `photo_roles`, `created_at`, `updated_at`) VALUES
  (1,	1,	'1_hadir_1640747372.png',	'LOGO',	'2021-12-29 03:09:32',	'2021-12-29 03:09:32'),
  (2,	2,	'Anindita_pulang_1642125103.png',	'PULANG',	'2022-01-14 01:51:43',	'2022-01-14 01:51:43'),
  (3,	2,	'Anindita_hadir_1642750213.png',	'HADIR',	'2022-01-21 07:30:14',	'2022-01-21 07:30:14'),
  (4,	3,	'Damasius Wikaryana Utama_hadir_1643078675.png',	'HADIR',	'2022-01-25 02:44:36',	'2022-01-25 02:44:36'),
  (5,	3,	'Damasius Wikaryana Utama_hadir_1643081044.jpg',	'HADIR',	'2022-01-25 03:24:05',	'2022-01-25 03:24:05');
  
  DROP TABLE IF EXISTS `user_personalias`;
  CREATE TABLE `user_personalias` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `user_potongans`;
  CREATE TABLE `user_potongans` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `pot_bulan` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pot_tahun` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pot_keterangan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `pot_nilai` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `user_potongans` (`id`, `id_user`, `pot_bulan`, `pot_tahun`, `pot_keterangan`, `pot_nilai`, `created_at`, `updated_at`) VALUES
  (1,	2,	'12',	'2021',	'Koperasi',	325000,	'2021-12-15 04:08:21',	'2021-12-15 04:08:21'),
  (2,	2,	'12',	'2021',	'Kasbon',	75000,	'2021-12-15 04:08:21',	'2021-12-15 04:08:21');
  
  DROP TABLE IF EXISTS `user_salaries`;
  CREATE TABLE `user_salaries` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `gaji_pokok` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `user_salaries` (`id`, `id_user`, `gaji_pokok`, `created_at`, `updated_at`) VALUES
  (495,	4,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (496,	5,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (497,	6,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (498,	7,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (499,	8,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (500,	9,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (501,	10,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (502,	11,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (503,	12,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (504,	13,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (505,	14,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (506,	15,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (507,	16,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (508,	17,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (509,	18,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (510,	19,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (511,	20,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (512,	21,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (513,	22,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (514,	23,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (515,	24,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (516,	25,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (517,	26,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (518,	27,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (519,	28,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (520,	29,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (521,	30,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (522,	31,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (523,	32,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (524,	33,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (525,	34,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (526,	35,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (527,	36,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (528,	37,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (529,	38,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (530,	39,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (531,	40,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (532,	41,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (533,	42,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (534,	43,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (535,	44,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (536,	45,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (537,	46,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (538,	47,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (539,	48,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (540,	49,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (541,	50,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (542,	51,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (543,	52,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (544,	53,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (545,	54,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (546,	55,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (547,	56,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (548,	57,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (549,	58,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (550,	59,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (551,	60,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (552,	61,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (553,	62,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (554,	63,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (555,	64,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (556,	65,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (557,	66,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (558,	67,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (559,	68,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (560,	69,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (561,	70,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (562,	71,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (563,	72,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (564,	73,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (565,	74,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (566,	75,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (567,	76,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (568,	77,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (569,	78,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (570,	79,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (571,	80,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (572,	81,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (573,	82,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (574,	83,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (575,	84,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (576,	85,	2494000,	'2021-12-17 02:22:43',	'2021-12-17 02:22:43'),
  (578,	2,	3500000,	'2021-12-17 02:22:57',	'2021-12-17 03:02:07'),
  (579,	3,	4500000,	'2021-12-17 02:22:57',	'2021-12-17 02:59:09');
  
  DROP TABLE IF EXISTS `user_shifts`;
  CREATE TABLE `user_shifts` (
    `id_shift` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `id_user_shift` int(11) NOT NULL,
    `tanggal_shift` date NOT NULL,
    `status_shift` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id_shift`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `user_shifts` (`id_shift`, `id_user`, `id_user_shift`, `tanggal_shift`, `status_shift`) VALUES
  (1,	1,	1,	'2021-12-01',	'active'),
  (2,	1,	2,	'2021-12-02',	'active'),
  (3,	1,	3,	'2021-12-03',	'active'),
  (4,	1,	1,	'2021-12-04',	'active'),
  (5,	1,	2,	'2021-12-05',	'active'),
  (6,	1,	3,	'2021-12-06',	'active'),
  (7,	1,	1,	'2021-12-07',	'active'),
  (8,	1,	2,	'2021-12-08',	'active'),
  (9,	1,	3,	'2021-12-09',	'active'),
  (10,	1,	1,	'2021-12-10',	'active'),
  (11,	1,	2,	'2021-12-11',	'active'),
  (12,	1,	3,	'2021-12-12',	'active'),
  (13,	1,	1,	'2021-12-13',	'active'),
  (14,	1,	2,	'2021-12-14',	'active'),
  (15,	1,	3,	'2021-12-15',	'active'),
  (16,	1,	1,	'2021-12-16',	'active'),
  (17,	1,	2,	'2021-12-17',	'active'),
  (18,	1,	3,	'2021-12-18',	'active'),
  (19,	1,	1,	'2021-12-19',	'active'),
  (20,	1,	2,	'2021-12-20',	'active'),
  (21,	1,	3,	'2021-12-21',	'active'),
  (22,	1,	1,	'2021-12-22',	'active'),
  (23,	1,	2,	'2021-12-23',	'active'),
  (24,	1,	3,	'2021-12-24',	'active'),
  (25,	1,	1,	'2021-12-25',	'active'),
  (26,	1,	2,	'2021-12-26',	'active'),
  (27,	1,	3,	'2021-12-27',	'active'),
  (28,	1,	1,	'2021-12-28',	'active'),
  (29,	1,	2,	'2021-12-29',	'active'),
  (30,	1,	3,	'2021-12-30',	'active'),
  (31,	1,	1,	'2021-12-31',	'active'),
  (32,	2,	1,	'2021-12-01',	'active'),
  (33,	2,	2,	'2021-12-02',	'active'),
  (34,	2,	3,	'2021-12-03',	'active'),
  (35,	2,	1,	'2021-12-04',	'active'),
  (36,	2,	2,	'2021-12-05',	'active'),
  (37,	2,	3,	'2021-12-06',	'active'),
  (38,	2,	1,	'2021-12-07',	'active'),
  (39,	2,	2,	'2021-12-08',	'active'),
  (40,	2,	3,	'2021-12-09',	'active'),
  (41,	2,	1,	'2021-12-10',	'active'),
  (42,	2,	2,	'2021-12-11',	'active'),
  (43,	2,	3,	'2021-12-12',	'active'),
  (44,	2,	1,	'2021-12-13',	'active'),
  (45,	2,	2,	'2021-12-14',	'active'),
  (46,	2,	3,	'2021-12-15',	'active'),
  (47,	2,	1,	'2021-12-16',	'active'),
  (48,	2,	2,	'2021-12-17',	'active'),
  (49,	2,	3,	'2021-12-18',	'active'),
  (50,	2,	1,	'2021-12-19',	'active'),
  (51,	2,	2,	'2021-12-20',	'active'),
  (52,	2,	3,	'2021-12-21',	'active'),
  (53,	2,	1,	'2021-12-22',	'active'),
  (54,	2,	2,	'2021-12-23',	'active'),
  (55,	2,	3,	'2021-12-24',	'active'),
  (56,	2,	1,	'2021-12-25',	'active'),
  (57,	2,	2,	'2021-12-26',	'active'),
  (58,	2,	3,	'2021-12-27',	'active'),
  (59,	2,	1,	'2021-12-28',	'active'),
  (60,	2,	2,	'2021-12-29',	'active'),
  (61,	2,	3,	'2021-12-30',	'active'),
  (62,	2,	1,	'2021-12-31',	'active'),
  (63,	3,	1,	'2021-12-01',	'active'),
  (64,	3,	2,	'2021-12-02',	'active'),
  (65,	3,	3,	'2021-12-03',	'active'),
  (66,	3,	1,	'2021-12-04',	'active'),
  (67,	3,	2,	'2021-12-05',	'active'),
  (68,	3,	3,	'2021-12-06',	'active'),
  (69,	3,	1,	'2021-12-07',	'active'),
  (70,	3,	2,	'2021-12-08',	'active'),
  (71,	3,	3,	'2021-12-09',	'active'),
  (72,	3,	1,	'2021-12-10',	'active'),
  (73,	3,	2,	'2021-12-11',	'active'),
  (74,	3,	3,	'2021-12-12',	'active'),
  (75,	3,	1,	'2021-12-13',	'active'),
  (76,	3,	2,	'2021-12-14',	'active'),
  (77,	3,	3,	'2021-12-15',	'active'),
  (78,	3,	1,	'2021-12-16',	'active'),
  (79,	3,	2,	'2021-12-17',	'active'),
  (80,	3,	3,	'2021-12-18',	'active'),
  (81,	3,	1,	'2021-12-19',	'active'),
  (82,	3,	2,	'2021-12-20',	'active'),
  (83,	3,	3,	'2021-12-21',	'active'),
  (84,	3,	1,	'2021-12-22',	'active'),
  (85,	3,	2,	'2021-12-23',	'active'),
  (86,	3,	3,	'2021-12-24',	'active'),
  (87,	3,	1,	'2021-12-25',	'active'),
  (88,	3,	2,	'2021-12-26',	'active'),
  (89,	3,	3,	'2021-12-27',	'active'),
  (90,	3,	1,	'2021-12-28',	'active'),
  (91,	3,	2,	'2021-12-29',	'active'),
  (92,	3,	3,	'2021-12-30',	'active'),
  (93,	3,	1,	'2021-12-31',	'active'),
  (94,	4,	1,	'2021-12-01',	'active'),
  (95,	4,	2,	'2021-12-02',	'active'),
  (96,	4,	3,	'2021-12-03',	'active'),
  (97,	4,	1,	'2021-12-04',	'active'),
  (98,	4,	2,	'2021-12-05',	'active'),
  (99,	4,	3,	'2021-12-06',	'active'),
  (100,	4,	1,	'2021-12-07',	'active'),
  (101,	4,	2,	'2021-12-08',	'active'),
  (102,	4,	3,	'2021-12-09',	'active'),
  (103,	4,	1,	'2021-12-10',	'active'),
  (104,	4,	2,	'2021-12-11',	'active'),
  (105,	4,	3,	'2021-12-12',	'active'),
  (106,	4,	1,	'2021-12-13',	'active'),
  (107,	4,	2,	'2021-12-14',	'active'),
  (108,	4,	3,	'2021-12-15',	'active'),
  (109,	4,	1,	'2021-12-16',	'active'),
  (110,	4,	2,	'2021-12-17',	'active'),
  (111,	4,	3,	'2021-12-18',	'active'),
  (112,	4,	1,	'2021-12-19',	'active'),
  (113,	4,	2,	'2021-12-20',	'active'),
  (114,	4,	3,	'2021-12-21',	'active'),
  (115,	4,	1,	'2021-12-22',	'active'),
  (116,	4,	2,	'2021-12-23',	'active'),
  (117,	4,	3,	'2021-12-24',	'active'),
  (118,	4,	1,	'2021-12-25',	'active'),
  (119,	4,	2,	'2021-12-26',	'active'),
  (120,	4,	3,	'2021-12-27',	'active'),
  (121,	4,	1,	'2021-12-28',	'active'),
  (122,	4,	2,	'2021-12-29',	'active'),
  (123,	4,	3,	'2021-12-30',	'active'),
  (124,	4,	1,	'2021-12-31',	'active'),
  (125,	5,	1,	'2021-12-01',	'active'),
  (126,	5,	2,	'2021-12-02',	'active'),
  (127,	5,	3,	'2021-12-03',	'active'),
  (128,	5,	1,	'2021-12-04',	'active'),
  (129,	5,	2,	'2021-12-05',	'active'),
  (130,	5,	3,	'2021-12-06',	'active'),
  (131,	5,	1,	'2021-12-07',	'active'),
  (132,	5,	2,	'2021-12-08',	'active'),
  (133,	5,	3,	'2021-12-09',	'active'),
  (134,	5,	1,	'2021-12-10',	'active'),
  (135,	5,	2,	'2021-12-11',	'active'),
  (136,	5,	3,	'2021-12-12',	'active'),
  (137,	5,	1,	'2021-12-13',	'active'),
  (138,	5,	2,	'2021-12-14',	'active'),
  (139,	5,	3,	'2021-12-15',	'active'),
  (140,	5,	1,	'2021-12-16',	'active'),
  (141,	5,	2,	'2021-12-17',	'active'),
  (142,	5,	3,	'2021-12-18',	'active'),
  (143,	5,	1,	'2021-12-19',	'active'),
  (144,	5,	2,	'2021-12-20',	'active'),
  (145,	5,	3,	'2021-12-21',	'active'),
  (146,	5,	1,	'2021-12-22',	'active'),
  (147,	5,	2,	'2021-12-23',	'active'),
  (148,	5,	3,	'2021-12-24',	'active'),
  (149,	5,	1,	'2021-12-25',	'active'),
  (150,	5,	2,	'2021-12-26',	'active'),
  (151,	5,	3,	'2021-12-27',	'active'),
  (152,	5,	1,	'2021-12-28',	'active'),
  (153,	5,	2,	'2021-12-29',	'active'),
  (154,	5,	3,	'2021-12-30',	'active'),
  (155,	5,	1,	'2021-12-31',	'active'),
  (156,	6,	1,	'2021-12-01',	'active'),
  (157,	6,	2,	'2021-12-02',	'active'),
  (158,	6,	3,	'2021-12-03',	'active'),
  (159,	6,	1,	'2021-12-04',	'active'),
  (160,	6,	2,	'2021-12-05',	'active'),
  (161,	6,	3,	'2021-12-06',	'active'),
  (162,	6,	1,	'2021-12-07',	'active'),
  (163,	6,	2,	'2021-12-08',	'active'),
  (164,	6,	3,	'2021-12-09',	'active'),
  (165,	6,	1,	'2021-12-10',	'active'),
  (166,	6,	2,	'2021-12-11',	'active'),
  (167,	6,	3,	'2021-12-12',	'active'),
  (168,	6,	1,	'2021-12-13',	'active'),
  (169,	6,	2,	'2021-12-14',	'active'),
  (170,	6,	3,	'2021-12-15',	'active'),
  (171,	6,	1,	'2021-12-16',	'active'),
  (172,	6,	2,	'2021-12-17',	'active'),
  (173,	6,	3,	'2021-12-18',	'active'),
  (174,	6,	1,	'2021-12-19',	'active'),
  (175,	6,	2,	'2021-12-20',	'active'),
  (176,	6,	3,	'2021-12-21',	'active'),
  (177,	6,	1,	'2021-12-22',	'active'),
  (178,	6,	2,	'2021-12-23',	'active'),
  (179,	6,	3,	'2021-12-24',	'active'),
  (180,	6,	1,	'2021-12-25',	'active'),
  (181,	6,	2,	'2021-12-26',	'active'),
  (182,	6,	3,	'2021-12-27',	'active'),
  (183,	6,	1,	'2021-12-28',	'active'),
  (184,	6,	2,	'2021-12-29',	'active'),
  (185,	6,	3,	'2021-12-30',	'active'),
  (186,	6,	1,	'2021-12-31',	'active'),
  (187,	7,	1,	'2021-12-01',	'active'),
  (188,	7,	2,	'2021-12-02',	'active'),
  (189,	7,	3,	'2021-12-03',	'active'),
  (190,	7,	1,	'2021-12-04',	'active'),
  (191,	7,	2,	'2021-12-05',	'active'),
  (192,	7,	3,	'2021-12-06',	'active'),
  (193,	7,	1,	'2021-12-07',	'active'),
  (194,	7,	2,	'2021-12-08',	'active'),
  (195,	7,	3,	'2021-12-09',	'active'),
  (196,	7,	1,	'2021-12-10',	'active'),
  (197,	7,	2,	'2021-12-11',	'active'),
  (198,	7,	3,	'2021-12-12',	'active'),
  (199,	7,	1,	'2021-12-13',	'active'),
  (200,	7,	2,	'2021-12-14',	'active'),
  (201,	7,	3,	'2021-12-15',	'active'),
  (202,	7,	1,	'2021-12-16',	'active'),
  (203,	7,	2,	'2021-12-17',	'active'),
  (204,	7,	3,	'2021-12-18',	'active'),
  (205,	7,	1,	'2021-12-19',	'active'),
  (206,	7,	2,	'2021-12-20',	'active'),
  (207,	7,	3,	'2021-12-21',	'active'),
  (208,	7,	1,	'2021-12-22',	'active'),
  (209,	7,	2,	'2021-12-23',	'active'),
  (210,	7,	3,	'2021-12-24',	'active'),
  (211,	7,	1,	'2021-12-25',	'active'),
  (212,	7,	2,	'2021-12-26',	'active'),
  (213,	7,	3,	'2021-12-27',	'active'),
  (214,	7,	1,	'2021-12-28',	'active'),
  (215,	7,	2,	'2021-12-29',	'active'),
  (216,	7,	3,	'2021-12-30',	'active'),
  (217,	7,	1,	'2021-12-31',	'active'),
  (218,	8,	1,	'2021-12-01',	'active'),
  (219,	8,	2,	'2021-12-02',	'active'),
  (220,	8,	3,	'2021-12-03',	'active'),
  (221,	8,	1,	'2021-12-04',	'active'),
  (222,	8,	2,	'2021-12-05',	'active'),
  (223,	8,	3,	'2021-12-06',	'active'),
  (224,	8,	1,	'2021-12-07',	'active'),
  (225,	8,	2,	'2021-12-08',	'active'),
  (226,	8,	3,	'2021-12-09',	'active'),
  (227,	8,	1,	'2021-12-10',	'active'),
  (228,	8,	2,	'2021-12-11',	'active'),
  (229,	8,	3,	'2021-12-12',	'active'),
  (230,	8,	1,	'2021-12-13',	'active'),
  (231,	8,	2,	'2021-12-14',	'active'),
  (232,	8,	3,	'2021-12-15',	'active'),
  (233,	8,	1,	'2021-12-16',	'active'),
  (234,	8,	2,	'2021-12-17',	'active'),
  (235,	8,	3,	'2021-12-18',	'active'),
  (236,	8,	1,	'2021-12-19',	'active'),
  (237,	8,	2,	'2021-12-20',	'active'),
  (238,	8,	3,	'2021-12-21',	'active'),
  (239,	8,	1,	'2021-12-22',	'active'),
  (240,	8,	2,	'2021-12-23',	'active'),
  (241,	8,	3,	'2021-12-24',	'active'),
  (242,	8,	1,	'2021-12-25',	'active'),
  (243,	8,	2,	'2021-12-26',	'active'),
  (244,	8,	3,	'2021-12-27',	'active'),
  (245,	8,	1,	'2021-12-28',	'active'),
  (246,	8,	2,	'2021-12-29',	'active'),
  (247,	8,	3,	'2021-12-30',	'active'),
  (248,	8,	1,	'2021-12-31',	'active'),
  (249,	9,	1,	'2021-12-01',	'active'),
  (250,	9,	2,	'2021-12-02',	'active'),
  (251,	9,	3,	'2021-12-03',	'active'),
  (252,	9,	1,	'2021-12-04',	'active'),
  (253,	9,	2,	'2021-12-05',	'active'),
  (254,	9,	3,	'2021-12-06',	'active'),
  (255,	9,	1,	'2021-12-07',	'active'),
  (256,	9,	2,	'2021-12-08',	'active'),
  (257,	9,	3,	'2021-12-09',	'active'),
  (258,	9,	1,	'2021-12-10',	'active'),
  (259,	9,	2,	'2021-12-11',	'active'),
  (260,	9,	3,	'2021-12-12',	'active'),
  (261,	9,	1,	'2021-12-13',	'active'),
  (262,	9,	2,	'2021-12-14',	'active'),
  (263,	9,	3,	'2021-12-15',	'active'),
  (264,	9,	1,	'2021-12-16',	'active'),
  (265,	9,	2,	'2021-12-17',	'active'),
  (266,	9,	3,	'2021-12-18',	'active'),
  (267,	9,	1,	'2021-12-19',	'active'),
  (268,	9,	2,	'2021-12-20',	'active'),
  (269,	9,	3,	'2021-12-21',	'active'),
  (270,	9,	1,	'2021-12-22',	'active'),
  (271,	9,	2,	'2021-12-23',	'active'),
  (272,	9,	3,	'2021-12-24',	'active'),
  (273,	9,	1,	'2021-12-25',	'active'),
  (274,	9,	2,	'2021-12-26',	'active'),
  (275,	9,	3,	'2021-12-27',	'active'),
  (276,	9,	1,	'2021-12-28',	'active'),
  (277,	9,	2,	'2021-12-29',	'active'),
  (278,	9,	3,	'2021-12-30',	'active'),
  (279,	9,	1,	'2021-12-31',	'active'),
  (280,	10,	1,	'2021-12-01',	'active'),
  (281,	10,	2,	'2021-12-02',	'active'),
  (282,	10,	3,	'2021-12-03',	'active'),
  (283,	10,	1,	'2021-12-04',	'active'),
  (284,	10,	2,	'2021-12-05',	'active'),
  (285,	10,	3,	'2021-12-06',	'active'),
  (286,	10,	1,	'2021-12-07',	'active'),
  (287,	10,	2,	'2021-12-08',	'active'),
  (288,	10,	3,	'2021-12-09',	'active'),
  (289,	10,	1,	'2021-12-10',	'active'),
  (290,	10,	2,	'2021-12-11',	'active'),
  (291,	10,	3,	'2021-12-12',	'active'),
  (292,	10,	1,	'2021-12-13',	'active'),
  (293,	10,	2,	'2021-12-14',	'active'),
  (294,	10,	3,	'2021-12-15',	'active'),
  (295,	10,	1,	'2021-12-16',	'active'),
  (296,	10,	2,	'2021-12-17',	'active'),
  (297,	10,	3,	'2021-12-18',	'active'),
  (298,	10,	1,	'2021-12-19',	'active'),
  (299,	10,	2,	'2021-12-20',	'active'),
  (300,	10,	3,	'2021-12-21',	'active'),
  (301,	10,	1,	'2021-12-22',	'active'),
  (302,	10,	2,	'2021-12-23',	'active'),
  (303,	10,	3,	'2021-12-24',	'active'),
  (304,	10,	1,	'2021-12-25',	'active'),
  (305,	10,	2,	'2021-12-26',	'active'),
  (306,	10,	3,	'2021-12-27',	'active'),
  (307,	10,	1,	'2021-12-28',	'active'),
  (308,	10,	2,	'2021-12-29',	'active'),
  (309,	10,	3,	'2021-12-30',	'active'),
  (310,	10,	1,	'2021-12-31',	'active'),
  (311,	11,	1,	'2021-12-01',	'active'),
  (312,	11,	2,	'2021-12-02',	'active'),
  (313,	11,	3,	'2021-12-03',	'active'),
  (314,	11,	1,	'2021-12-04',	'active'),
  (315,	11,	2,	'2021-12-05',	'active'),
  (316,	11,	3,	'2021-12-06',	'active'),
  (317,	11,	1,	'2021-12-07',	'active'),
  (318,	11,	2,	'2021-12-08',	'active'),
  (319,	11,	3,	'2021-12-09',	'active'),
  (320,	11,	1,	'2021-12-10',	'active'),
  (321,	11,	2,	'2021-12-11',	'active'),
  (322,	11,	3,	'2021-12-12',	'active'),
  (323,	11,	1,	'2021-12-13',	'active'),
  (324,	11,	2,	'2021-12-14',	'active'),
  (325,	11,	3,	'2021-12-15',	'active'),
  (326,	11,	1,	'2021-12-16',	'active'),
  (327,	11,	2,	'2021-12-17',	'active'),
  (328,	11,	3,	'2021-12-18',	'active'),
  (329,	11,	1,	'2021-12-19',	'active'),
  (330,	11,	2,	'2021-12-20',	'active'),
  (331,	11,	3,	'2021-12-21',	'active'),
  (332,	11,	1,	'2021-12-22',	'active'),
  (333,	11,	2,	'2021-12-23',	'active'),
  (334,	11,	3,	'2021-12-24',	'active'),
  (335,	11,	1,	'2021-12-25',	'active'),
  (336,	11,	2,	'2021-12-26',	'active'),
  (337,	11,	3,	'2021-12-27',	'active'),
  (338,	11,	1,	'2021-12-28',	'active'),
  (339,	11,	2,	'2021-12-29',	'active'),
  (340,	11,	3,	'2021-12-30',	'active'),
  (341,	11,	1,	'2021-12-31',	'active'),
  (342,	12,	1,	'2021-12-01',	'active'),
  (343,	12,	2,	'2021-12-02',	'active'),
  (344,	12,	3,	'2021-12-03',	'active'),
  (345,	12,	1,	'2021-12-04',	'active'),
  (346,	12,	2,	'2021-12-05',	'active'),
  (347,	12,	3,	'2021-12-06',	'active'),
  (348,	12,	1,	'2021-12-07',	'active'),
  (349,	12,	2,	'2021-12-08',	'active'),
  (350,	12,	3,	'2021-12-09',	'active'),
  (351,	12,	1,	'2021-12-10',	'active'),
  (352,	12,	2,	'2021-12-11',	'active'),
  (353,	12,	3,	'2021-12-12',	'active'),
  (354,	12,	1,	'2021-12-13',	'active'),
  (355,	12,	2,	'2021-12-14',	'active'),
  (356,	12,	3,	'2021-12-15',	'active'),
  (357,	12,	1,	'2021-12-16',	'active'),
  (358,	12,	2,	'2021-12-17',	'active'),
  (359,	12,	3,	'2021-12-18',	'active'),
  (360,	12,	1,	'2021-12-19',	'active'),
  (361,	12,	2,	'2021-12-20',	'active'),
  (362,	12,	3,	'2021-12-21',	'active'),
  (363,	12,	1,	'2021-12-22',	'active'),
  (364,	12,	2,	'2021-12-23',	'active'),
  (365,	12,	3,	'2021-12-24',	'active'),
  (366,	12,	1,	'2021-12-25',	'active'),
  (367,	12,	2,	'2021-12-26',	'active'),
  (368,	12,	3,	'2021-12-27',	'active'),
  (369,	12,	1,	'2021-12-28',	'active'),
  (370,	12,	2,	'2021-12-29',	'active'),
  (371,	12,	3,	'2021-12-30',	'active'),
  (372,	12,	1,	'2021-12-31',	'active'),
  (373,	13,	1,	'2021-12-01',	'active'),
  (374,	13,	2,	'2021-12-02',	'active'),
  (375,	13,	3,	'2021-12-03',	'active'),
  (376,	13,	1,	'2021-12-04',	'active'),
  (377,	13,	2,	'2021-12-05',	'active'),
  (378,	13,	3,	'2021-12-06',	'active'),
  (379,	13,	1,	'2021-12-07',	'active'),
  (380,	13,	2,	'2021-12-08',	'active'),
  (381,	13,	3,	'2021-12-09',	'active'),
  (382,	13,	1,	'2021-12-10',	'active'),
  (383,	13,	2,	'2021-12-11',	'active'),
  (384,	13,	3,	'2021-12-12',	'active'),
  (385,	13,	1,	'2021-12-13',	'active'),
  (386,	13,	2,	'2021-12-14',	'active'),
  (387,	13,	3,	'2021-12-15',	'active'),
  (388,	13,	1,	'2021-12-16',	'active'),
  (389,	13,	2,	'2021-12-17',	'active'),
  (390,	13,	3,	'2021-12-18',	'active'),
  (391,	13,	1,	'2021-12-19',	'active'),
  (392,	13,	2,	'2021-12-20',	'active'),
  (393,	13,	3,	'2021-12-21',	'active'),
  (394,	13,	1,	'2021-12-22',	'active'),
  (395,	13,	2,	'2021-12-23',	'active'),
  (396,	13,	3,	'2021-12-24',	'active'),
  (397,	13,	1,	'2021-12-25',	'active'),
  (398,	13,	2,	'2021-12-26',	'active'),
  (399,	13,	3,	'2021-12-27',	'active'),
  (400,	13,	1,	'2021-12-28',	'active'),
  (401,	13,	2,	'2021-12-29',	'active'),
  (402,	13,	3,	'2021-12-30',	'active'),
  (403,	13,	1,	'2021-12-31',	'active'),
  (404,	14,	1,	'2021-12-01',	'active'),
  (405,	14,	2,	'2021-12-02',	'active'),
  (406,	14,	3,	'2021-12-03',	'active'),
  (407,	14,	1,	'2021-12-04',	'active'),
  (408,	14,	2,	'2021-12-05',	'active'),
  (409,	14,	3,	'2021-12-06',	'active'),
  (410,	14,	1,	'2021-12-07',	'active'),
  (411,	14,	2,	'2021-12-08',	'active'),
  (412,	14,	3,	'2021-12-09',	'active'),
  (413,	14,	1,	'2021-12-10',	'active'),
  (414,	14,	2,	'2021-12-11',	'active'),
  (415,	14,	3,	'2021-12-12',	'active'),
  (416,	14,	1,	'2021-12-13',	'active'),
  (417,	14,	2,	'2021-12-14',	'active'),
  (418,	14,	3,	'2021-12-15',	'active'),
  (419,	14,	1,	'2021-12-16',	'active'),
  (420,	14,	2,	'2021-12-17',	'active'),
  (421,	14,	3,	'2021-12-18',	'active'),
  (422,	14,	1,	'2021-12-19',	'active'),
  (423,	14,	2,	'2021-12-20',	'active'),
  (424,	14,	3,	'2021-12-21',	'active'),
  (425,	14,	1,	'2021-12-22',	'active'),
  (426,	14,	2,	'2021-12-23',	'active'),
  (427,	14,	3,	'2021-12-24',	'active'),
  (428,	14,	1,	'2021-12-25',	'active'),
  (429,	14,	2,	'2021-12-26',	'active'),
  (430,	14,	3,	'2021-12-27',	'active'),
  (431,	14,	1,	'2021-12-28',	'active'),
  (432,	14,	2,	'2021-12-29',	'active'),
  (433,	14,	3,	'2021-12-30',	'active'),
  (434,	14,	1,	'2021-12-31',	'active'),
  (435,	15,	1,	'2021-12-01',	'active'),
  (436,	15,	2,	'2021-12-02',	'active'),
  (437,	15,	3,	'2021-12-03',	'active'),
  (438,	15,	1,	'2021-12-04',	'active'),
  (439,	15,	2,	'2021-12-05',	'active'),
  (440,	15,	3,	'2021-12-06',	'active'),
  (441,	15,	1,	'2021-12-07',	'active'),
  (442,	15,	2,	'2021-12-08',	'active'),
  (443,	15,	3,	'2021-12-09',	'active'),
  (444,	15,	1,	'2021-12-10',	'active'),
  (445,	15,	2,	'2021-12-11',	'active'),
  (446,	15,	3,	'2021-12-12',	'active'),
  (447,	15,	1,	'2021-12-13',	'active'),
  (448,	15,	2,	'2021-12-14',	'active'),
  (449,	15,	3,	'2021-12-15',	'active'),
  (450,	15,	1,	'2021-12-16',	'active'),
  (451,	15,	2,	'2021-12-17',	'active'),
  (452,	15,	3,	'2021-12-18',	'active'),
  (453,	15,	1,	'2021-12-19',	'active'),
  (454,	15,	2,	'2021-12-20',	'active'),
  (455,	15,	3,	'2021-12-21',	'active'),
  (456,	15,	1,	'2021-12-22',	'active'),
  (457,	15,	2,	'2021-12-23',	'active'),
  (458,	15,	3,	'2021-12-24',	'active'),
  (459,	15,	1,	'2021-12-25',	'active'),
  (460,	15,	2,	'2021-12-26',	'active'),
  (461,	15,	3,	'2021-12-27',	'active'),
  (462,	15,	1,	'2021-12-28',	'active'),
  (463,	15,	2,	'2021-12-29',	'active'),
  (464,	15,	3,	'2021-12-30',	'active'),
  (465,	15,	1,	'2021-12-31',	'active'),
  (466,	16,	1,	'2021-12-01',	'active'),
  (467,	16,	2,	'2021-12-02',	'active'),
  (468,	16,	3,	'2021-12-03',	'active'),
  (469,	16,	1,	'2021-12-04',	'active'),
  (470,	16,	2,	'2021-12-05',	'active'),
  (471,	16,	3,	'2021-12-06',	'active'),
  (472,	16,	1,	'2021-12-07',	'active'),
  (473,	16,	2,	'2021-12-08',	'active'),
  (474,	16,	3,	'2021-12-09',	'active'),
  (475,	16,	1,	'2021-12-10',	'active'),
  (476,	16,	2,	'2021-12-11',	'active'),
  (477,	16,	3,	'2021-12-12',	'active'),
  (478,	16,	1,	'2021-12-13',	'active'),
  (479,	16,	2,	'2021-12-14',	'active'),
  (480,	16,	3,	'2021-12-15',	'active'),
  (481,	16,	1,	'2021-12-16',	'active'),
  (482,	16,	2,	'2021-12-17',	'active'),
  (483,	16,	3,	'2021-12-18',	'active'),
  (484,	16,	1,	'2021-12-19',	'active'),
  (485,	16,	2,	'2021-12-20',	'active'),
  (486,	16,	3,	'2021-12-21',	'active'),
  (487,	16,	1,	'2021-12-22',	'active'),
  (488,	16,	2,	'2021-12-23',	'active'),
  (489,	16,	3,	'2021-12-24',	'active'),
  (490,	16,	1,	'2021-12-25',	'active'),
  (491,	16,	2,	'2021-12-26',	'active'),
  (492,	16,	3,	'2021-12-27',	'active'),
  (493,	16,	1,	'2021-12-28',	'active'),
  (494,	16,	2,	'2021-12-29',	'active'),
  (495,	16,	3,	'2021-12-30',	'active'),
  (496,	16,	1,	'2021-12-31',	'active');
  
  DROP TABLE IF EXISTS `user_tunjangans`;
  CREATE TABLE `user_tunjangans` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `tj_jabatan` double NOT NULL,
    `tj_makan` double NOT NULL,
    `tj_transport` double NOT NULL,
    `tj_sertifikasi` double NOT NULL,
    `tj_lain` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `user_tunjangans` (`id`, `id_user`, `tj_jabatan`, `tj_makan`, `tj_transport`, `tj_sertifikasi`, `tj_lain`, `created_at`, `updated_at`) VALUES
  (1,	3,	500000,	0,	0,	0,	150000,	'2021-12-15 04:04:10',	'2021-12-15 04:04:10'),
  (2,	2,	100000,	0,	300000,	0,	100000,	'2021-12-15 04:04:10',	'2021-12-15 04:04:10'),
  (3,	21,	706000,	0,	0,	0,	0,	'2021-12-15 04:04:10',	'2021-12-15 04:04:10'),
  (4,	53,	550000,	0,	0,	0,	0,	'2021-12-15 04:04:10',	'2021-12-15 04:04:10');
  
  -- 2022-02-02 03:20:29
  