-- --------------------------------------------------------
-- Server OS:                    Win32
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------



-- Dumping database structure for pdam_web
CREATE DATABASE IF NOT EXISTS `pdam_web` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `pdam_web`;

-- Dumping structure for table pdam_web.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.permissions: ~17 rows (approximately)
DELETE FROM `permissions`;
INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `built_in`, `created_at`, `updated_at`) VALUES
	(1, 'create-role', 'Create Role', 'Create Role', 1, '2018-06-06 10:24:35', '2018-06-06 10:24:35'),
	(2, 'read-role', 'Read Role', 'Read Role', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(3, 'update-role', 'Update Role', 'Update Role', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(4, 'delete-role', 'Delete Role', 'Delete Role', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(5, 'read-permission', 'Read Permission', 'Read Permission', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(6, 'update-permission', 'Update Permission', 'Update Permission', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(7, 'delete-permission', 'Delete Permission', 'Delete Permission', 1, '2018-06-06 10:24:36', '2018-07-02 05:29:53'),
	(8, 'create-permission', 'Create Permission', 'Create permission', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(9, 'create-pemasangan-baru', 'Membuat Data Pemasangan Baru', 'Membuat data pemasangan baru', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(10, 'delete-pemasangan-baru', 'Menghapus Data Pemasangan Baru', 'Menghapus data Pemasangan Baru', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(11, 'lihat-pemasangan-baru', 'Melihat Data Pemasangan Baru', 'Melihat data pemasangan baru', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(12, 'update-pemasangan-baru', 'Mengubah Data Pemasangan Baru', 'Mengubah data pemasangan baru', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(13, 'approve-pemasangan-baru', 'Menyetujui Pemasangan Baru', 'Menyetujui Pemasangan Baru', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(14, 'approve-rab', 'Menyetujui RAB', 'Menyetujui RAB', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(15, 'lihat-survey', 'Melihat Data Survei', 'Melihat Data Survei', 1, '2018-07-02 15:26:26', '2018-07-02 15:26:28'),
	(16, 'lihat-rab', 'Melihat Data RAB', 'Melihat Data RAB', 1, '2018-07-02 15:26:27', '2018-07-02 15:26:29'),
	(17, 'update-survey', 'Mengubah Data Survei', 'Mengubah Data Survei', 1, '2018-07-02 15:43:21', '2018-07-02 15:43:21'),
	(18, 'lihat-semua-pb', 'Melihat Semua Data PB', 'Melihat Semua Data Pemasangan Baru yang masuk', 1, '2018-07-03 13:33:35', '2018-07-03 13:33:35');

-- Dumping structure for table pdam_web.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.roles: ~8 rows (approximately)
DELETE FROM `roles`;
INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `built_in`, `created_at`, `updated_at`) VALUES
	(1, 'super-admin', 'Super Admin', 'Super Admin', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(2, 'pengguna', 'Pengguna', 'End-user, pengguna yang mendaftar via web', 0, '2018-07-02 05:56:09', '2018-07-02 05:56:09'),
	(3, 'p2k', 'P2K', 'Petugas P2K', 0, '2018-07-02 05:56:44', '2018-07-02 05:56:44'),
	(4, 'vip_p2k', 'VIP P2K', 'Spv dan Manager P2K', 0, '2018-07-02 05:57:26', '2018-07-02 05:57:26'),
	(5, 'pjsr', 'PJSR', 'Petugas PJSR', 0, '2018-07-02 05:57:57', '2018-07-02 05:57:57'),
	(6, 'vip_pjsr', 'VIP PJSR', 'Spv dan Manager PJSR', 0, '2018-07-02 05:58:39', '2018-07-02 05:58:39'),
	(7, 'ptjsr', 'PTJSR', 'Petugas PTJSR', 0, '2018-07-02 05:59:10', '2018-07-02 05:59:10'),
	(8, 'vip_ptjsr', 'VIP PTJSR', 'Spv dan Manager PTJSR', 0, '2018-07-02 05:59:57', '2018-07-02 05:59:57'),
	(9, 'surveyor', 'Surveyor', 'Surveyor', 0, '2018-07-02 09:04:43', '2018-07-02 09:04:43');

-- Dumping structure for table pdam_web.role_user
CREATE TABLE IF NOT EXISTS `role_user` (
  `role_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.role_user: ~6 rows (approximately)
DELETE FROM `role_user`;
INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`) VALUES
	(1, 1, 'App\\User'),
	(2, 2, 'App\\User'),
	(2, 3, 'App\\User'),
	(2, 4, 'App\\User'),
	(9, 5, 'App\\User'),
	(9, 89, 'App\\User'),
	(9, 90, 'App\\User'),
	(9, 91, 'App\\User'),
	(9, 92, 'App\\User'),
	(9, 93, 'App\\User'),
	(9, 94, 'App\\User'),
	(9, 95, 'App\\User'),
	(9, 96, 'App\\User'),
	(9, 97, 'App\\User'),
	(9, 98, 'App\\User'),
	(9, 99, 'App\\User'),
	(9, 100, 'App\\User'),
	(9, 101, 'App\\User'),
	(9, 102, 'App\\User'),
	(9, 103, 'App\\User'),
	(9, 104, 'App\\User'),
	(9, 105, 'App\\User'),
	(9, 106, 'App\\User'),
	(9, 107, 'App\\User'),
	(9, 108, 'App\\User'),
	(9, 109, 'App\\User'),
	(9, 110, 'App\\User'),
	(9, 111, 'App\\User'),
	(9, 112, 'App\\User'),
	(9, 113, 'App\\User'),
	(9, 114, 'App\\User'),
	(9, 115, 'App\\User'),
	(9, 116, 'App\\User'),
	(9, 117, 'App\\User'),
	(9, 118, 'App\\User'),
	(9, 119, 'App\\User'),
	(9, 120, 'App\\User'),
	(9, 121, 'App\\User'),
	(9, 122, 'App\\User'),
	(9, 123, 'App\\User'),
	(9, 124, 'App\\User'),
	(9, 125, 'App\\User'),
	(9, 126, 'App\\User'),
	(9, 127, 'App\\User'),
	(9, 128, 'App\\User');

-- Dumping structure for table pdam_web.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `firebase_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(10,7) DEFAULT NULL,
  `longitude` double(10,7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_number_unique` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.users: ~46 rows (approximately)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `username`, `full_name`, `email`, `address`, `phone_number`, `password`, `photo`, `active`, `built_in`, `firebase_token`, `remember_token`, `created_at`, `updated_at`, `nip`, `latitude`, `longitude`) VALUES
	(1, 'admin', 'Administrator', 'admin@artcak.com', NULL, '0817777', '$2y$10$QYfIq929cWPtBQed1Y9lsOZxVtQmB3I8uw2jIcYPX7QgL0hYCSQWO', NULL, 1, 1, NULL, NULL, '2018-06-06 10:24:38', '2018-06-06 10:24:38', NULL, NULL, NULL),
	(2, 'ownser', 'Owner', 'owner@artcak.com', NULL, '0818888', '$2y$10$mG/PA7w6R1Ipd0ug0cQM1OcgzYLaHsUCIEuHCZumEFCS5I.vWHyPC', NULL, 1, 0, NULL, NULL, '2018-06-06 10:24:39', '2018-06-06 10:24:39', NULL, NULL, NULL),
	(3, 'contributor1', 'Contributor 1', 'contributor1@artcak.com', NULL, '0815555', '$2y$10$XAwR3jgFL0.swWgGqjjAqO.P9fD9gl6uaV/kbitDnhfXihFOg56g.', NULL, 1, 0, NULL, NULL, '2018-06-06 10:24:39', '2018-06-06 10:24:39', NULL, NULL, NULL),
	(4, 'user', 'user', 'user@artcak.com', NULL, '0816666', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 1, 0, NULL, NULL, '2018-06-07 03:50:46', '2018-06-07 03:50:47', NULL, NULL, NULL),
	(5, 'surveyor', 'surveyor', 'surveyor@artcak.com', NULL, '0819999', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 1, 0, NULL, NULL, '2018-06-07 03:50:46', '2018-06-07 03:50:47', NULL, NULL, NULL),
	(89, '201', 'Mellany Junono                ', 'surveyor201@pdam.go.id', NULL, '0811201', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:46:59', '2018-07-04 07:46:59', NULL, NULL, NULL),
	(90, '203', 'S u k a m t o                 ', 'surveyor203@pdam.go.id', NULL, '0811203', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:00', '2018-07-04 07:47:00', NULL, NULL, NULL),
	(91, '207', 'S y a m s u r i               ', 'surveyor207@pdam.go.id', NULL, '0811207', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:00', '2018-07-04 07:47:00', NULL, NULL, NULL),
	(92, '208', 'U s n a d i                   ', 'surveyor208@pdam.go.id', NULL, '0811208', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:00', '2018-07-04 07:47:00', NULL, NULL, NULL),
	(93, '209', 'Oni Sahroni                   ', 'surveyor209@pdam.go.id', NULL, '0811209', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:01', '2018-07-04 07:47:01', NULL, NULL, NULL),
	(94, '210', 'Khamim Sulton H.              ', 'surveyor210@pdam.go.id', NULL, '0811210', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:01', '2018-07-04 07:47:01', NULL, NULL, NULL),
	(95, '211', 'M. Irfan Fahlefi              ', 'surveyor211@pdam.go.id', NULL, '0811211', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02', NULL, NULL, NULL),
	(96, '213', 'Sumilan BE                    ', 'surveyor213@pdam.go.id', NULL, '0811213', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02', NULL, NULL, NULL),
	(97, '214', 'Edy Priyono                   ', 'surveyor214@pdam.go.id', NULL, '0811214', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02', NULL, NULL, NULL),
	(98, '215', 'Moch. Farchan                 ', 'surveyor215@pdam.go.id', NULL, '0811215', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02', NULL, NULL, NULL),
	(99, '218', 'S u g i a n t o               ', 'surveyor218@pdam.go.id', NULL, '0811218', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:03', '2018-07-04 07:47:03', NULL, NULL, NULL),
	(100, '220', 'Budi Waluyo                   ', 'surveyor220@pdam.go.id', NULL, '0811220', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:03', '2018-07-04 07:47:03', NULL, NULL, NULL),
	(101, '221', 'S u s a n t o  BA.E.          ', 'surveyor221@pdam.go.id', NULL, '0811221', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:04', '2018-07-04 07:47:04', NULL, NULL, NULL),
	(102, '222', 'Rachmad Bahagia               ', 'surveyor222@pdam.go.id', NULL, '0811222', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:04', '2018-07-04 07:47:04', NULL, NULL, NULL),
	(103, '223', 'Trisna Hadi                   ', 'surveyor223@pdam.go.id', NULL, '0811223', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:04', '2018-07-04 07:47:04', NULL, NULL, NULL),
	(104, '224', 'K a r m u d j i               ', 'surveyor224@pdam.go.id', NULL, '0811224', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:05', '2018-07-04 07:47:05', NULL, NULL, NULL),
	(105, '228', 'Imansyah N.                   ', 'surveyor228@pdam.go.id', NULL, '0811228', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:05', '2018-07-04 07:47:05', NULL, NULL, NULL),
	(106, '229', 'S u d i o n o                 ', 'surveyor229@pdam.go.id', NULL, '0811229', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:05', '2018-07-04 07:47:05', NULL, NULL, NULL),
	(107, '230', 'Andi Eko Purwono              ', 'surveyor230@pdam.go.id', NULL, '0811230', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:06', '2018-07-04 07:47:06', NULL, NULL, NULL),
	(108, '231', 'Agus Martono                  ', 'surveyor231@pdam.go.id', NULL, '0811231', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:06', '2018-07-04 07:47:06', NULL, NULL, NULL),
	(109, '232', 'Teguh Susijono                ', 'surveyor232@pdam.go.id', NULL, '0811232', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:06', '2018-07-04 07:47:06', NULL, NULL, NULL),
	(110, '233', 'Irwan Hermana U.              ', 'surveyor233@pdam.go.id', NULL, '0811233', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:07', '2018-07-04 07:47:07', NULL, NULL, NULL),
	(111, '234', 'Forneo  H.S.                  ', 'surveyor234@pdam.go.id', NULL, '0811234', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:07', '2018-07-04 07:47:07', NULL, NULL, NULL),
	(112, '235', 'Zupri                         ', 'surveyor235@pdam.go.id', NULL, '0811235', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:07', '2018-07-04 07:47:07', NULL, NULL, NULL),
	(113, '236', 'Bambang Tri W.                ', 'surveyor236@pdam.go.id', NULL, '0811236', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:08', '2018-07-04 07:47:08', NULL, NULL, NULL),
	(114, '237', 'Eko Saputra                   ', 'surveyor237@pdam.go.id', NULL, '0811237', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:08', '2018-07-04 07:47:08', NULL, NULL, NULL),
	(115, '238', 'Irawan Sudarsono              ', 'surveyor238@pdam.go.id', NULL, '0811238', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:09', '2018-07-04 07:47:09', NULL, NULL, NULL),
	(116, '239', 'Kuswara                       ', 'surveyor239@pdam.go.id', NULL, '0811239', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:09', '2018-07-04 07:47:09', NULL, NULL, NULL),
	(117, '240', 'Teguh Wiyono                  ', 'surveyor240@pdam.go.id', NULL, '0811240', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:10', '2018-07-04 07:47:10', NULL, NULL, NULL),
	(118, '241', 'M. ABDUS SOMAD MUSLIM, AMD    ', 'surveyor241@pdam.go.id', NULL, '0811241', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:10', '2018-07-04 07:47:10', NULL, NULL, NULL),
	(119, '242', 'AGUS HARYADI                  ', 'surveyor242@pdam.go.id', NULL, '0811242', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:11', '2018-07-04 07:47:11', NULL, NULL, NULL),
	(120, '243', 'Joko Indah Permadi            ', 'surveyor243@pdam.go.id', NULL, '0811243', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:11', '2018-07-04 07:47:11', NULL, NULL, NULL),
	(121, '244', 'Deny Eka Pratama              ', 'surveyor244@pdam.go.id', NULL, '0811244', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:11', '2018-07-04 07:47:11', NULL, NULL, NULL),
	(122, '245', 'Angga Christian Hananta       ', 'surveyor245@pdam.go.id', NULL, '0811245', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12', NULL, NULL, NULL),
	(123, '246', 'Deni Kurniawati               ', 'surveyor246@pdam.go.id', NULL, '0811246', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12', NULL, NULL, NULL),
	(124, '247', 'Surios Ramisda                ', 'surveyor247@pdam.go.id', NULL, '0811247', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12', NULL, NULL, NULL),
	(125, '248', 'Danny Erwanto                 ', 'surveyor248@pdam.go.id', NULL, '0811248', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12', NULL, NULL, NULL),
	(126, '249', 'Nur Cholis Ikhsan             ', 'surveyor249@pdam.go.id', NULL, '0811249', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:13', '2018-07-04 07:47:13', NULL, NULL, NULL),
	(127, '250', 'Ahmad Rais Setyo Laksono      ', 'surveyor250@pdam.go.id', NULL, '0811250', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:13', '2018-07-04 07:47:13', NULL, NULL, NULL),
	(128, '251', 'Achmad Hardianas              ', 'surveyor251@pdam.go.id', NULL, '0811251', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, 0, 1, NULL, NULL, '2018-07-04 07:47:13', '2018-07-04 07:47:13', NULL, NULL, NULL);

