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


-- Dumping structure for table pdam_master.d1barang_pb
CREATE TABLE IF NOT EXISTS `d1barang_pb` (
  `NO_KELUARPB` char(20) DEFAULT NULL,
  `NO_DAFTARPB` char(20) DEFAULT NULL,
  `KD_BARANG` char(12) DEFAULT NULL,
  `JML_MINTA` decimal(12,2) DEFAULT NULL,
  `METER` tinyint(4) DEFAULT NULL,
  `UKURAN` char(20) DEFAULT NULL,
  `JML_KELUAR` decimal(12,2) DEFAULT '0.00',
  `JML_KEMBALI` decimal(12,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.d1barang_pb: ~0 rows (approximately)
DELETE FROM `d1barang_pb`;

-- Dumping structure for table pdam_master.dib
CREATE TABLE IF NOT EXISTS `dib` (
  `KD_BARANG` char(12) NOT NULL,
  `KD_GOL` char(4) NOT NULL,
  `KD_PERKIRAAN` char(15) NOT NULL,
  `NAMA` char(30) NOT NULL,
  `MERK` char(20) DEFAULT NULL,
  `UKURAN` char(20) DEFAULT NULL,
  `SATUAN` char(6) NOT NULL,
  `HARGA` decimal(20,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.dib: ~0 rows (approximately)
DELETE FROM `dib`;

-- Dumping structure for table pdam_master.dpaket_pb
CREATE TABLE IF NOT EXISTS `dpaket_pb` (
  `KD_PAKET` char(2) NOT NULL,
  `KD_BARANG` char(12) NOT NULL,
  `JUMLAH_PAKET` decimal(12,2) NOT NULL,
  `METER` tinyint(4) NOT NULL,
  `UKURAN` char(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.dpaket_pb: ~0 rows (approximately)
DELETE FROM `dpaket_pb`;

-- Dumping structure for table pdam_master.d_spkpb
CREATE TABLE IF NOT EXISTS `d_spkpb` (
  `NO_SPKPB` char(20) NOT NULL,
  `NO_DAFTARPB` char(20) NOT NULL,
  `STATUS_SPKPB` char(1) DEFAULT NULL,
  `TGL_REALISASI` datetime DEFAULT NULL,
  `KETERANGAN` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`NO_SPKPB`,`NO_DAFTARPB`),
  CONSTRAINT `d_spkpb_ibfk_1` FOREIGN KEY (`NO_SPKPB`) REFERENCES `spk_pb` (`NO_SPKPB`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.d_spkpb: ~0 rows (approximately)
DELETE FROM `d_spkpb`;

-- Dumping structure for table pdam_master.hkeluar_pb
CREATE TABLE IF NOT EXISTS `hkeluar_pb` (
  `NO_KELUARPB` char(20) NOT NULL,
  `KD_PEKERJAAN` char(4) NOT NULL,
  `KD_GUDANG` char(1) DEFAULT NULL,
  `TGL_MINTA` datetime NOT NULL,
  `TGL_KELUAR` datetime DEFAULT NULL,
  `TGL_KEMBALI` datetime DEFAULT NULL,
  `POSTING_KELUAR` datetime DEFAULT NULL,
  `POSTING_KEMBALI` datetime DEFAULT NULL,
  `IMPORT_AKTIVA` datetime DEFAULT NULL,
  `UPDATE_STOCKKLR` datetime DEFAULT NULL,
  `UPDATE_STOCKMSK` datetime DEFAULT NULL,
  `KD_UNITKRJ` char(4) NOT NULL,
  `NO_JURNAL_KELUAR` char(20) DEFAULT NULL,
  `BULAN_BUKU_KELUAR` tinyint(4) DEFAULT NULL,
  `TAHUN_BUKU_KELUAR` smallint(6) DEFAULT NULL,
  `NO_JURNAL_KEMBALI` char(20) DEFAULT NULL,
  `BULAN_BUKU_KEMBALI` tinyint(4) DEFAULT NULL,
  `TAHUN_BUKU_KEMBALI` smallint(6) DEFAULT NULL,
  `KD_PTGDIST` char(3) DEFAULT NULL,
  `NIP` char(20) DEFAULT NULL,
  `USER_ID` char(20) DEFAULT NULL,
  `NPWP_REKANAN` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.hkeluar_pb: ~0 rows (approximately)
DELETE FROM `hkeluar_pb`;

-- Dumping structure for table pdam_master.jenis_pekerjaan
CREATE TABLE IF NOT EXISTS `jenis_pekerjaan` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jenis_pekerjaan` char(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- Dumping data for table pdam_master.jenis_pekerjaan: ~13 rows (approximately)
DELETE FROM `jenis_pekerjaan`;
INSERT INTO `jenis_pekerjaan` (`id`, `jenis_pekerjaan`, `keterangan`) VALUES
	(1, 'TYPE I (A)', 'Jalan Kampung / Gang (tanah)'),
	(2, 'TYPE I (B)', 'Jalan Kampung Konstruksi Rabat'),
	(3, 'TYPE I (C)', 'Jalan Kampung Konstruksi Paving'),
	(4, 'TYPE II (A)', 'Jalan Perumahan Konstruksi Telford'),
	(5, 'TYPE II (B)', 'Jalan Perumahan Kontruksi CTB'),
	(6, 'TYPE II (C)', 'Jalan Perumahan Kontruksi Rabat'),
	(7, 'TYPE II (D)', 'Jalan Perumahan Kontruksi Paving'),
	(8, 'TYPE III (A)', 'Jalan Lokal Dalam Kota Kontruksi CTB'),
	(9, 'TYPE III (B)', 'Jalan Lokal Dalam Kota Kontruksi Paving'),
	(10, 'TYPE IV (A)', 'Jalan Kolektor Primer/Sekunder dengan Kontruksi CTB'),
	(11, 'TYPE IV (B)', 'Jalan Kolektor Primer/Sekunder dengan Kontruksi paving'),
	(12, 'TYPE V (A)', 'Jalan Arteri sekunder (protokol) dengan kontruksi CTB'),
	(13, 'TYPE V (B)', 'Jalan Arteri Sekunder (protokol) dengan kontruksi Paving');

-- Dumping structure for table pdam_master.kas_pb
CREATE TABLE IF NOT EXISTS `kas_pb` (
  `NO_BAYARPB` char(12) DEFAULT NULL,
  `NO_DAFTARPB` char(12) DEFAULT NULL,
  `TGL_BON` datetime DEFAULT NULL,
  `RP_BAYAR` bigint(20) DEFAULT NULL,
  `RP_SISA` bigint(20) DEFAULT NULL,
  `PEMBAYARAN_KE` bigint(20) DEFAULT NULL,
  `KETERANGAN` bigint(20) DEFAULT NULL,
  `POSTING` bigint(20) DEFAULT NULL,
  `NO_RENCANAPJ` int(11) DEFAULT NULL,
  `TAHUN_BUKU` int(11) DEFAULT NULL,
  `BULAN_BUKU` int(11) DEFAULT NULL,
  `NO_JURNAL` bigint(20) DEFAULT NULL,
  `MANUAL` int(11) DEFAULT NULL,
  `KETERANGAN1` bigint(20) DEFAULT NULL,
  `NAMA` bigint(20) DEFAULT NULL,
  `ALAMAT` bigint(20) DEFAULT NULL,
  `ISTAXABLE` int(11) DEFAULT NULL,
  `TAX_VAL` bigint(20) DEFAULT NULL,
  `ISPRINT` bigint(20) DEFAULT NULL,
  `PPH` bigint(20) DEFAULT NULL,
  `PPN` bigint(20) DEFAULT NULL,
  `KD_LOKET` varchar(2) DEFAULT NULL,
  `NO_FAKTUR` char(20) DEFAULT NULL,
  `BATAL` bigint(20) DEFAULT NULL,
  `TGL_BATAL` bigint(20) DEFAULT NULL,
  `KASIR` char(5) DEFAULT NULL,
  `IS_BANK` int(11) DEFAULT NULL,
  `KASIR_UPDATE` bigint(20) DEFAULT NULL,
  `KASIR_BATAL` bigint(20) DEFAULT NULL,
  `RP_MATERAI` bigint(20) DEFAULT NULL,
  `TGL_UPDATE` bigint(20) DEFAULT NULL,
  `JAMBAYAR` int(11) DEFAULT NULL,
  `TGLBAYAR` datetime DEFAULT NULL,
  `TIPE_PEMBAYARAN` varchar(50) DEFAULT NULL,
  `KODE_EDC` int(11) DEFAULT NULL,
  `NO_KARTU` bigint(20) DEFAULT NULL,
  `NILAI_BAYAR` bigint(20) DEFAULT NULL,
  `KETERANGAN2` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.kas_pb: ~0 rows (approximately)
DELETE FROM `kas_pb`;

-- Dumping structure for table pdam_master.keckel
CREATE TABLE IF NOT EXISTS `keckel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `KODE_KECAMATAN` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KODE_KELURAHAN` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KECAMATAN` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KELURAHAN` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- Dumping data for table pdam_master.keckel: ~178 rows (approximately)
DELETE FROM `keckel`;
INSERT INTO `keckel` (`id`, `KODE_KECAMATAN`, `KODE_KELURAHAN`, `KECAMATAN`, `KELURAHAN`) VALUES
	(1, '21', '01', 'Suko Manunggal', 'Suko Manunggal'),
	(2, '21', '02', 'Suko Manunggal', 'Tanjungsari'),
	(3, '21', '05', 'Suko Manunggal', 'Simomulyo'),
	(4, '21', '03', 'Suko Manunggal', 'Sonokwijenan'),
	(5, '21', '04', 'Suko Manunggal', 'Putat Gede'),
	(6, '22', '01', 'Asem Rowo', 'Asem Rowo'),
	(7, '22', '02', 'Asem Rowo', 'Genting'),
	(8, '22', '03', 'Asem Rowo', 'Kalianak'),
	(9, '22', '04', 'Asem Rowo', 'Greges'),
	(10, '22', '05', 'Asem Rowo', 'Tambak Langon'),
	(11, '29', '07', 'Bulak', 'Kenjeran'),
	(12, '29', '06', 'Bulak', 'Kedung Cowek'),
	(13, '29', '09', 'Bulak', 'Koplek Kenjeran'),
	(14, '29', '02', 'Bulak', 'Bulak'),
	(15, '29', '08', 'Bulak', 'Sukolilo'),
	(16, '30', '06', 'Pakal', 'Benowo'),
	(17, '30', '07', 'Pakal', 'Sumberejo'),
	(18, '30', '04', 'Pakal', 'Babat Jerawat'),
	(19, '30', '05', 'Pakal', 'Pakal'),
	(20, '30', '08', 'Pakal', 'Tambakdono'),
	(21, '31', '09', 'Sambi Kerep', 'Sambi Kerep'),
	(22, '31', '06', 'Sambi Kerep', 'Lontar'),
	(23, '31', '02', 'Sambi Kerep', 'Beringin'),
	(24, '31', '08', 'Sambi Kerep', 'Made'),
	(25, '00', '00', 'Luar Kota', 'Luar Kota'),
	(26, '23', '01', 'Benowo', 'Kandangan'),
	(27, '23', '02', 'Benowo', 'Klakahrejo'),
	(28, '23', '04', 'Benowo', 'Babat Jerawat'),
	(29, '23', '05', 'Benowo', 'Pakal'),
	(30, '23', '06', 'Benowo', 'Benowo'),
	(31, '23', '07', 'Benowo', 'Sumberejo'),
	(32, '23', '08', 'Benowo', 'Tambakdono'),
	(33, '23', '09', 'Benowo', 'Tambak Osowilangun'),
	(34, '23', '10', 'Benowo', 'Romo Kalisari'),
	(35, '23', '03', 'Benowo', 'Sememi'),
	(36, '03', '01', 'Krembangan', 'Krembangan Selatan'),
	(37, '03', '02', 'Krembangan', 'Kemayoran'),
	(38, '03', '03', 'Krembangan', 'Perak Barat'),
	(39, '03', '04', 'Krembangan', 'Dupak'),
	(40, '03', '05', 'Krembangan', 'Morokrembangan'),
	(41, '01', '02', 'Pabean cantikan', 'Nyamplungan'),
	(42, '01', '01', 'Pabean cantikan', 'Bongkaran'),
	(43, '01', '03', 'Pabean cantikan', 'Krembangan Utara'),
	(44, '01', '04', 'Pabean cantikan', 'Perak Utara'),
	(45, '01', '05', 'Pabean cantikan', 'Perak Timur'),
	(46, '02', '01', 'Semampir', 'Ampel'),
	(47, '02', '02', 'Semampir', 'Pegirian'),
	(48, '02', '03', 'Semampir', 'Wonokusumo'),
	(49, '02', '04', 'Semampir', 'Ujung'),
	(50, '02', '05', 'Semampir', 'Sidotopo'),
	(51, '06', '01', 'Gubeng', 'Mojo'),
	(52, '06', '02', 'Gubeng', 'Airlangga'),
	(53, '06', '04', 'Gubeng', 'Gubeng'),
	(54, '06', '05', 'Gubeng', 'Barata Jaya'),
	(55, '06', '06', 'Gubeng', 'Pucang Sewu'),
	(56, '06', '03', 'Gubeng', 'Kertajaya'),
	(57, '04', '01', 'Kenjeran', 'Tanah Kalikedinding'),
	(58, '04', '02', 'Kenjeran', 'Bulak'),
	(59, '04', '03', 'Kenjeran', 'Sidotopo Wetan'),
	(60, '04', '04', 'Kenjeran', 'Bulak Banteng'),
	(61, '04', '05', 'Kenjeran', 'Tambak Wedi'),
	(62, '04', '06', 'Kenjeran', 'Kedung Cowek'),
	(63, '04', '07', 'Kenjeran', 'Kenjeran'),
	(64, '04', '08', 'Kenjeran', 'Sukolilo'),
	(65, '04', '09', 'Kenjeran', 'Komplek Kenjeran'),
	(66, '05', '01', 'Tambaksari', 'Gading'),
	(67, '05', '02', 'Tambaksari', 'Pacar Kembang'),
	(68, '05', '03', 'Tambaksari', 'Tambaksari'),
	(69, '05', '04', 'Tambaksari', 'Ploso'),
	(70, '05', '05', 'Tambaksari', 'Rangkah'),
	(71, '05', '06', 'Tambaksari', 'Pacar Keling'),
	(72, '07', '01', 'Rungkut', 'Kalirungkut'),
	(73, '07', '02', 'Rungkut', 'Rungkut Kidul'),
	(74, '07', '03', 'Rungkut', 'Kedung Baruk'),
	(75, '07', '04', 'Rungkut', 'Penjaringan Sari'),
	(76, '07', '05', 'Rungkut', 'Wonorejo'),
	(77, '07', '06', 'Rungkut', 'Medoan Ayu'),
	(78, '08', '01', 'Gunung Anyar', 'Gunung Anyar'),
	(79, '08', '02', 'Gunung Anyar', 'Rungkut Tengah'),
	(80, '08', '03', 'Gunung Anyar', 'Rungkut Menanggal'),
	(81, '08', '04', 'Gunung Anyar', 'Gunung Anyar Tambak'),
	(82, '09', '02', 'Tenggilis Mejoyo', 'Prapen'),
	(83, '09', '03', 'Tenggilis Mejoyo', 'Panjang Jiwo'),
	(84, '09', '04', 'Tenggilis Mejoyo', 'Kendang Sari'),
	(85, '09', '05', 'Tenggilis Mejoyo', 'Kutisari'),
	(86, '09', '01', 'Tenggilis Mejoyo', 'Tenggilis Mejoyo'),
	(87, '10', '03', 'Sukolilo', 'Klampis Ngasem'),
	(88, '10', '04', 'Sukolilo', 'Menur Pumpungan'),
	(89, '10', '05', 'Sukolilo', 'Nginden Jangkungan'),
	(90, '10', '01', 'Sukolilo', 'Keputih'),
	(91, '10', '02', 'Sukolilo', 'Gebang Putih'),
	(92, '10', '06', 'Sukolilo', 'Semolowaru'),
	(93, '10', '07', 'Sukolilo', 'Medokan Semampir'),
	(94, '11', '02', 'Mulyorejo', 'Manyar Sabrangan'),
	(95, '11', '03', 'Mulyorejo', 'Kejawan Putih Tambak'),
	(96, '11', '04', 'Mulyorejo', 'Kalisari'),
	(97, '11', '01', 'Mulyorejo', 'Mulyorejo'),
	(98, '11', '05', 'Mulyorejo', 'Dukuh Sutorejo'),
	(99, '11', '06', 'Mulyorejo', 'Kalijudan'),
	(100, '12', '01', 'Sawahan', 'Petemon'),
	(101, '12', '02', 'Sawahan', 'Sawahan'),
	(102, '12', '03', 'Sawahan', 'Banyu Urip'),
	(103, '12', '04', 'Sawahan', 'Putat Jaya'),
	(104, '12', '05', 'Sawahan', 'Kupang Krajan'),
	(105, '12', '06', 'Sawahan', 'Pakis'),
	(106, '13', '02', 'Wonokromo', 'Jagir'),
	(107, '13', '03', 'Wonokromo', 'Ngagel'),
	(108, '13', '04', 'Wonokromo', 'Ngagel Rejo'),
	(109, '13', '05', 'Wonokromo', 'Darmo'),
	(110, '13', '06', 'Wonokromo', 'Sawunggaling'),
	(111, '13', '01', 'Wonokromo', 'Wonokromo'),
	(112, '14', '01', 'Karangpilang', 'Karangpilang'),
	(113, '14', '02', 'Karangpilang', 'Kebraon'),
	(114, '14', '03', 'Karangpilang', 'Kedurus'),
	(115, '14', '04', 'Karangpilang', 'Waru Gunung'),
	(116, '15', '01', 'Dukuh Pakis', 'Dukuh Pakis'),
	(117, '15', '03', 'Dukuh Pakis', 'Gunung Sari'),
	(118, '15', '04', 'Dukuh Pakis', 'Pradah Kalikendal'),
	(119, '15', '02', 'Dukuh Pakis', 'Dukuh Kupang'),
	(120, '16', '01', 'Wiyung', 'Wiyung'),
	(121, '16', '02', 'Wiyung', 'Jajar Tunggal'),
	(122, '16', '03', 'Wiyung', 'Babatan'),
	(123, '16', '04', 'Wiyung', 'Balas Klumprik'),
	(124, '17', '01', 'Wonocolo', 'Sidoresmo'),
	(125, '17', '02', 'Wonocolo', 'Bendul Merisi'),
	(126, '17', '03', 'Wonocolo', 'Margorejo'),
	(127, '17', '04', 'Wonocolo', 'Jemur Wonosari'),
	(128, '17', '05', 'Wonocolo', 'Siwalankerto'),
	(129, '18', '02', 'Gayungan', 'Ketintang'),
	(130, '18', '03', 'Gayungan', 'Menanggal'),
	(131, '18', '04', 'Gayungan', 'Dukuh Menanggal'),
	(132, '18', '01', 'Gayungan', 'Gayungan'),
	(133, '19', '01', 'Jambangan', 'Jambangan'),
	(134, '19', '02', 'Jambangan', 'Karah'),
	(135, '19', '03', 'Jambangan', 'Kebonsari'),
	(136, '19', '04', 'Jambangan', 'Pagesangan'),
	(137, '20', '01', 'Tandes', 'Gedang Asin'),
	(138, '20', '02', 'Tandes', 'Tandes Lor'),
	(139, '20', '03', 'Tandes', 'Tubanan'),
	(140, '20', '04', 'Tandes', 'Gadel'),
	(141, '20', '05', 'Tandes', 'Tandes Kidul'),
	(142, '20', '06', 'Tandes', 'Karang Poh'),
	(143, '20', '07', 'Tandes', 'Balongsari'),
	(144, '20', '08', 'Tandes', 'Bibis'),
	(145, '20', '09', 'Tandes', 'Manukan Kulon'),
	(146, '20', '10', 'Tandes', 'Buntaran'),
	(147, '20', '11', 'Tandes', 'Manukan Wetan'),
	(148, '20', '12', 'Tandes', 'Banjar Sugihan'),
	(149, '24', '02', 'Lakarsantri', 'Beringin'),
	(150, '24', '03', 'Lakarsantri', 'Jeruk'),
	(151, '24', '04', 'Lakarsantri', 'Lakarsantri'),
	(152, '24', '06', 'Lakarsantri', 'Lontar'),
	(153, '24', '08', 'Lakarsantri', 'Made'),
	(154, '24', '10', 'Lakarsantri', 'Sumurwelut'),
	(155, '24', '01', 'Lakarsantri', 'Bangkingan'),
	(156, '24', '05', 'Lakarsantri', 'Lidah Kulon'),
	(157, '24', '07', 'Lakarsantri', 'Lidah Wetan'),
	(158, '24', '09', 'Lakarsantri', 'Sambikerep'),
	(159, '25', '02', 'Genteng', 'Genteng'),
	(160, '25', '04', 'Genteng', 'Ketabang'),
	(161, '25', '05', 'Genteng', 'Peneleh'),
	(162, '25', '01', 'Genteng', 'Embong Kaliasin'),
	(163, '25', '03', 'Genteng', 'Kapasari'),
	(164, '26', '01', 'Tegalsari', 'Dr.Sutomo'),
	(165, '26', '02', 'Tegalsari', 'Kedungdoro'),
	(166, '26', '03', 'Tegalsari', 'Keputran'),
	(167, '26', '04', 'Tegalsari', 'Tegalsari'),
	(168, '26', '05', 'Tegalsari', 'Wonorejo'),
	(169, '27', '01', 'Bubutan', 'Tembok Dukuh'),
	(170, '27', '02', 'Bubutan', 'Bubutan'),
	(171, '27', '03', 'Bubutan', 'Alun-alun Contong'),
	(172, '27', '04', 'Bubutan', 'Gundih'),
	(173, '27', '05', 'Bubutan', 'Jepara'),
	(174, '28', '01', 'Simokerto', 'Simokerto'),
	(175, '28', '02', 'Simokerto', 'Kapasan'),
	(176, '28', '03', 'Simokerto', 'Sidodadi'),
	(177, '28', '04', 'Simokerto', 'Simolawang'),
	(178, '28', '05', 'Simokerto', 'Tambakrejo');

-- Dumping structure for table pdam_master.merk_meter
CREATE TABLE IF NOT EXISTS `merk_meter` (
  `KD_MERK` char(3) NOT NULL,
  `MERK` char(20) NOT NULL,
  PRIMARY KEY (`KD_MERK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.merk_meter: ~49 rows (approximately)
DELETE FROM `merk_meter`;
INSERT INTO `merk_meter` (`KD_MERK`, `MERK`) VALUES
	('001', 'ZACHI'),
	('002', 'KENT'),
	('003', 'BOSCO'),
	('004', 'BR'),
	('005', 'AICHI TOCKEY'),
	('006', 'FUJI'),
	('007', 'LINFLOW'),
	('008', 'AM.METRO'),
	('009', 'NB'),
	('010', 'B.CORI'),
	('011', 'SPANER'),
	('012', 'BPONT'),
	('013', 'WOLTEX'),
	('014', 'SB'),
	('016', 'CDC'),
	('017', 'AQ.METRO'),
	('018', 'P.A.M'),
	('019', 'BTC'),
	('020', 'HAMB'),
	('021', 'AMAZON'),
	('022', 'VF'),
	('023', 'MULTIMAG'),
	('024', 'PM'),
	('025', 'AKK'),
	('026', 'PV'),
	('027', 'ABB'),
	('028', 'SCHLUMBERGER'),
	('029', 'AQUINDO'),
	('030', 'ACTARIS'),
	('031', 'PDAM'),
	('032', 'SIEMENS'),
	('033', 'TEHNOBRAS'),
	('034', 'FUZHOU'),
	('035', 'MANNHEIM'),
	('036', 'HELIX'),
	('037', 'WWP'),
	('038', 'THERMO BOSH'),
	('039', 'BARINDO'),
	('040', 'ACTARIS AMR'),
	('041', 'KENT GKM'),
	('042', 'MEINEKKE'),
	('043', 'WOLTEX AMR'),
	('044', 'BOSCO TORINO'),
	('045', 'KENT HELIX'),
	('046', 'SCHLUMBERGER LORI'),
	('047', 'WOLMAG'),
	('048', 'ITRON'),
	('049', 'ITRON AMR'),
	('BAR', 'BARINDO AMR');

-- Dumping structure for table pdam_master.pb
CREATE TABLE IF NOT EXISTS `pb` (
  `NO_DAFTARPB` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `KODE_WILAYAH` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NO_RENCANAPJ` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TGL_DAFTARPB` datetime DEFAULT NULL,
  `TGL_KIRIMPG` datetime DEFAULT NULL,
  `TGL_SERAHBON` datetime DEFAULT NULL,
  `TGL_SRV` datetime DEFAULT NULL,
  `TGL_RAB` datetime DEFAULT NULL,
  `TGL_TERIMARAB` datetime DEFAULT NULL,
  `TGL_KASI` datetime DEFAULT NULL,
  `TGL_KABAG` datetime DEFAULT NULL,
  `TGL_KIRIMKAS` datetime DEFAULT NULL,
  `TGL_LUNAS` datetime DEFAULT NULL,
  `TGL_KIRIMDIST` datetime DEFAULT NULL,
  `TGL_KIRIMGUDANG` datetime DEFAULT NULL,
  `TGL_PASANG` datetime DEFAULT NULL,
  `TGL_KEMBALIPG` datetime DEFAULT NULL,
  `TGL_TERIMAPG` datetime DEFAULT NULL,
  `TGL_KIRIMREKENING` datetime DEFAULT NULL,
  `TGL_BONPUTIH` datetime DEFAULT NULL,
  `TGL_BONKUNING` datetime DEFAULT NULL,
  `TGL_PEREMAJAAN` datetime DEFAULT NULL,
  `TGL_BATAL` datetime DEFAULT NULL,
  `RAB_JARINGAN` int(10) unsigned DEFAULT NULL,
  `FLOW_PB` int(10) unsigned DEFAULT NULL,
  `STATUS_PB` int(10) unsigned DEFAULT NULL,
  `NO_RABNONPAKET` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TGL_KIRIMDISSTEK` datetime DEFAULT NULL,
  `TGL_TERIMADISSTEK` datetime DEFAULT NULL,
  `IS_MIKRO` tinyint(1) DEFAULT NULL,
  `MARKETING` tinyint(1) DEFAULT NULL,
  `OBA` tinyint(1) DEFAULT NULL,
  `MBR` tinyint(1) DEFAULT NULL,
  `IS_P3SCA` tinyint(1) DEFAULT NULL,
  `IS_PREFINANCING` tinyint(1) DEFAULT NULL,
  `IS_PIPAPEMKOT` tinyint(1) DEFAULT NULL,
  `IS_CT` tinyint(1) DEFAULT NULL,
  `IS_POTENSIPB` tinyint(1) DEFAULT NULL,
  `IS_GAKIN` tinyint(1) DEFAULT NULL,
  `TGL_KOREKSI` datetime DEFAULT NULL,
  `JENIS_PB` int(10) unsigned DEFAULT NULL,
  `TGL_EXPIRED` datetime DEFAULT NULL,
  `IS_EXOBA` tinyint(1) DEFAULT NULL,
  `IS_AUTODEBET` tinyint(1) DEFAULT NULL,
  `AUTODEBETBANK` tinyint(1) DEFAULT NULL,
  `NO_DAFTARPBOL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IS_PAKUWONB` tinyint(1) DEFAULT NULL,
  `SENTSMS` tinyint(1) DEFAULT NULL,
  `SENTSMSNOPELANGGAN` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IS_ODS` tinyint(1) DEFAULT NULL,
  `IS_SENTSURVEY` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`NO_DAFTARPB`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- Dumping data for table pdam_master.pb: ~3 rows (approximately)
DELETE FROM `pb`;
INSERT INTO `pb` (`NO_DAFTARPB`, `KODE_WILAYAH`, `NO_RENCANAPJ`, `TGL_DAFTARPB`, `TGL_KIRIMPG`, `TGL_SERAHBON`, `TGL_SRV`, `TGL_RAB`, `TGL_TERIMARAB`, `TGL_KASI`, `TGL_KABAG`, `TGL_KIRIMKAS`, `TGL_LUNAS`, `TGL_KIRIMDIST`, `TGL_KIRIMGUDANG`, `TGL_PASANG`, `TGL_KEMBALIPG`, `TGL_TERIMAPG`, `TGL_KIRIMREKENING`, `TGL_BONPUTIH`, `TGL_BONKUNING`, `TGL_PEREMAJAAN`, `TGL_BATAL`, `RAB_JARINGAN`, `FLOW_PB`, `STATUS_PB`, `NO_RABNONPAKET`, `TGL_KIRIMDISSTEK`, `TGL_TERIMADISSTEK`, `IS_MIKRO`, `MARKETING`, `OBA`, `MBR`, `IS_P3SCA`, `IS_PREFINANCING`, `IS_PIPAPEMKOT`, `IS_CT`, `IS_POTENSIPB`, `IS_GAKIN`, `TGL_KOREKSI`, `JENIS_PB`, `TGL_EXPIRED`, `IS_EXOBA`, `IS_AUTODEBET`, `AUTODEBETBANK`, `NO_DAFTARPBOL`, `IS_PAKUWONB`, `SENTSMS`, `SENTSMSNOPELANGGAN`, `IS_ODS`, `IS_SENTSURVEY`) VALUES
	('B20180000050', NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-27 07:21:49', '2018-07-27 08:47:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('T20180000017', 'T', NULL, NULL, NULL, NULL, '2018-08-02 00:00:00', '2018-08-02 00:00:00', '2018-08-02 00:00:00', '2018-08-02 00:00:00', '2018-08-02 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('T20180000020', 'T', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- Dumping structure for table pdam_master.pb_bayar
CREATE TABLE IF NOT EXISTS `pb_bayar` (
  `NO_DAFTARPB` char(12) DEFAULT NULL,
  `RP_BP` bigint(20) DEFAULT NULL,
  `RP_REG` bigint(20) DEFAULT NULL,
  `RP_BSI` bigint(20) DEFAULT NULL,
  `RP_UANGMUKA` bigint(20) DEFAULT NULL,
  `RP_DICICIL` bigint(20) DEFAULT NULL,
  `KALI_CICIL` int(11) DEFAULT NULL,
  `TGL_CICIL` int(11) DEFAULT NULL,
  `RP_TOTALBAYAR` bigint(20) DEFAULT NULL,
  `PEMBAYARAN_KE` varchar(50) DEFAULT NULL,
  `RP_PEMASANGAN` bigint(20) DEFAULT NULL,
  `PPN` bigint(20) DEFAULT NULL,
  `IS_CICILAN` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.pb_bayar: ~0 rows (approximately)
DELETE FROM `pb_bayar`;

-- Dumping structure for table pdam_master.pb_data
CREATE TABLE IF NOT EXISTS `pb_data` (
  `NO_DAFTARPB` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PAKET` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PTGSURVEY` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_HSLSURVEY` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NO_MTR` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_GUNAPERSIL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_TARIF` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ZONA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `STATUS_TANAH` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `UKURAN_MTR` decimal(8,2) DEFAULT NULL,
  `RP_RETRIBUSI` decimal(8,2) DEFAULT NULL,
  `NAMA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ALAMAT_PEMOHON` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `JALAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `GANG` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NOMOR` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NOTAMB` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TELEPON` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LUAS_TANAH` bigint(20) DEFAULT NULL,
  `SURAT_TANAH` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KTP_KSK` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IMB` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PBB` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RETRIBUSI` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `WILAYAH` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KECAMATAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KELURAHAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NO_BUNDEL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NO_PA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ALAMAT_TEKANAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TEKANAN_AIR` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TGL_TEKANAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RP_BP` bigint(20) DEFAULT NULL,
  `RP_REG` bigint(20) DEFAULT NULL,
  `RP_BSI` bigint(20) DEFAULT NULL,
  `BLNTERBIT` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ANGKA_PASANG` bigint(20) DEFAULT NULL,
  `NOPEL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `JNS_PELANGGAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PTGDIST` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PENGAWAS` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NIP_PETUGAS` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NIP_PENGAWAS` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_RETRIBUSI` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `JNS_PERSIL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PPN` bigint(20) DEFAULT NULL,
  `LEBARJALAN` bigint(20) DEFAULT NULL,
  `LISTRIK` bigint(20) DEFAULT NULL,
  `NJOP` bigint(20) DEFAULT NULL,
  `LUAS` bigint(20) DEFAULT NULL,
  `NO_DAFTAR` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LUAS_BANGUN` bigint(20) DEFAULT NULL,
  `JALUR_PIPA` bigint(20) DEFAULT NULL,
  `JENIS_PIPA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LETAK_PIPA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `URAIAN_PEKERJAAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TAHUN_PIPA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LEBAR_PERSIL` bigint(20) DEFAULT NULL,
  `KD_MERK` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `POT_RP_BP` bigint(20) DEFAULT NULL,
  `POT_RP_BSI` bigint(20) DEFAULT NULL,
  `NPWP` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `USER_ID` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_master.pb_data: ~63 rows (approximately)
DELETE FROM `pb_data`;
INSERT INTO `pb_data` (`NO_DAFTARPB`, `KD_PAKET`, `KD_PTGSURVEY`, `KD_HSLSURVEY`, `NO_MTR`, `KD_GUNAPERSIL`, `KD_TARIF`, `ZONA`, `STATUS_TANAH`, `UKURAN_MTR`, `RP_RETRIBUSI`, `NAMA`, `ALAMAT_PEMOHON`, `JALAN`, `GANG`, `NOMOR`, `NOTAMB`, `DA`, `TELEPON`, `LUAS_TANAH`, `SURAT_TANAH`, `KTP_KSK`, `IMB`, `PBB`, `RETRIBUSI`, `WILAYAH`, `KECAMATAN`, `KELURAHAN`, `NO_BUNDEL`, `NO_PA`, `ALAMAT_TEKANAN`, `TEKANAN_AIR`, `TGL_TEKANAN`, `RP_BP`, `RP_REG`, `RP_BSI`, `BLNTERBIT`, `ANGKA_PASANG`, `NOPEL`, `JNS_PELANGGAN`, `KD_PTGDIST`, `KD_PENGAWAS`, `NIP_PETUGAS`, `NIP_PENGAWAS`, `KD_RETRIBUSI`, `JNS_PERSIL`, `PPN`, `LEBARJALAN`, `LISTRIK`, `NJOP`, `LUAS`, `NO_DAFTAR`, `LUAS_BANGUN`, `JALUR_PIPA`, `JENIS_PIPA`, `LETAK_PIPA`, `URAIAN_PEKERJAAN`, `TAHUN_PIPA`, `LEBAR_PERSIL`, `KD_MERK`, `POT_RP_BP`, `POT_RP_BSI`, `NPWP`, `USER_ID`) VALUES
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'andi muzaki', 'rungkut (aaa depan)', 'arif', '8p', '777', NULL, NULL, '9821393821', 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 98932812, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '971291231', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '294212043845', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	('T20180000007', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	('T20180000001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	('T20180000002', NULL, '207', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123049213245', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ505', NULL, NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00) ( )', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ217', NULL, NULL, NULL, 'Troy Wahana', 'Jl Bhaskara Utara B-12 ( )', 'Bhaskara Utara', NULL, '12', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '4'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ217', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16 ( )', 'Pandugo', NULL, 'PV 16', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ114', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16 ( )', 'Pandugo', NULL, 'PV 16', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ225', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ225', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ205', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ205', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ216', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '10', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '10', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '10', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Anton Nazarudin', 'Keputih', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2200, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312000, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	('T20180000005', NULL, '223', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', '80', NULL, NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4'),
	('T20180000006', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', '80', NULL, NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4'),
	('T20180000004', NULL, '208', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4'),
	('T20180000003', NULL, '209', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', '100', NULL, NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '129'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '4'),
	('T20180000012', NULL, '242', NULL, NULL, NULL, NULL, 'SZ219', 'bermasalah', NULL, NULL, 'dev-diganti', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Asem Rowo', 'Airlangga', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4'),
	('T20180000016', NULL, '210', NULL, NULL, NULL, NULL, 'SZ222', 'tidak-bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Sukolilo', 'Keputih', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1'),
	('T20180000017', NULL, '236', NULL, NULL, NULL, NULL, '219', 'tidak-bermasalah', NULL, NULL, 'asdasd', 'Jalan Kali Kepunton no.4', 'Keputih', 'Perintis', '3A', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Sukolilo', 'Kalijudan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312000, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20, NULL, NULL, NULL, '123049213245', '132'),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ534', NULL, NULL, NULL, 'Arif Rahman', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '4');

-- Dumping structure for table pdam_master.pengawas_dist
CREATE TABLE IF NOT EXISTS `pengawas_dist` (
  `NIP` char(20) NOT NULL,
  `NAMA` char(30) NOT NULL,
  `KD_PENGAWAS` char(3) NOT NULL,
  `TELEPON` char(12) DEFAULT NULL,
  `ZONE` char(1) DEFAULT NULL,
  `ISTIBLANG` double DEFAULT '0',
  PRIMARY KEY (`KD_PENGAWAS`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.pengawas_dist: ~152 rows (approximately)
DELETE FROM `pengawas_dist`;
INSERT INTO `pengawas_dist` (`NIP`, `NAMA`, `KD_PENGAWAS`, `TELEPON`, `ZONE`, `ISTIBLANG`) VALUES
	('1.07.01489', 'D A R W A N T O', 'B', '', '', 0),
	('1.97.01145', 'AGUS SALIM', 'B01', '03171044251', '5', 0),
	('1.82.00471', 'MOCH. PIARI', 'B02', '081553317253', '5', 0),
	('1.96.00988', 'SUNARI', 'B03', '03171046593', '4', 0),
	('1.81.00324', 'KUSMADJI', 'B04', '', '5', 0),
	('1.96.00971', 'RIYANTO', 'B05', '03170176332', '5', 0),
	('1.81.00319', 'SUPARJIO', 'B06', '', '', 0),
	('1.07.01484', 'SUNTORO', 'B07', '0888356134', '4', 0),
	('1.78.00121', 'MUDJIHARKO', 'B08', '03171106376', '5', 0),
	('1.97.01132', 'MUNJONO', 'B09', '', '4', 0),
	('1.81.00319', 'SUPARJIO', 'B10', '', '5', 0),
	('1.81.00317', 'SUGIANTO', 'B11', '03170999365', '5', 0),
	('1.78.00144', 'ISMIRAN', 'B12', '081332464540', '5', 0),
	('1.06.01396', 'AGUNG NUGROHO', 'B13', '081330706697', '', 0),
	('1.96.00968', 'HERIYANTO', 'B14', '03171046315', '5', 0),
	('1.96.00930', 'KURIYANTO', 'B15', '', '', 0),
	('1.96.00972', 'SUPARDI', 'B17', '', '3', 0),
	('1.83.00558', 'MUDJIONO', 'B18', '03172010732', '4', 0),
	('1.96.00978', 'MOCH. MUDJIANTO', 'B19', '', '5', 0),
	('1.82.00450', 'HARYONO', 'B20', '081703420550', '4', 0),
	('1.78.00727', 'DRS. ARI SUYANTO', 'B21', '', '', 0),
	('1.97.01142', 'SUBROTO', 'B22', '03170812627', '5', 0),
	('1.96.00979', 'RUDY ISTANTO', 'B23', '03170146868', '', 0),
	('1.06.01451', 'SUBARI', 'B24', '', '4', 0),
	('1.96.00965', 'UNTUNG HARIYANTO', 'B25', '', '', 0),
	('1.96.00982', 'PIYANTO', 'B26', '081553317253', '5', 0),
	('1.96.00983', 'ZAINUDIN', 'B27', '081330440700', '5', 0),
	('1.78.00139', 'KATMIN', 'B28', '082139104050', '4', 0),
	('1.07.01468', 'CHANDRA ADITYA YUDHA', 'B29', '', '4', 0),
	('1.06.01428', 'KURNIAWAN HANARDI', 'B30', '', '', 0),
	('1.96.01005', 'TEGUH HARIJANTO', 'B31', '', '', 0),
	('1.96.00999', 'EKO SUMARNO', 'B32', '', '', 0),
	('1.81.00299', 'MISNAN', 'B33', '', '2', 0),
	('1.07.01489', 'D A R W A N T O', 'B34', '', '5', 0),
	('1.07.01473', 'HERU YUNIANTO', 'B35', '', '5', 0),
	('1.96.00996', 'SAMIRIN', 'B36', '', '', 0),
	('1.07.01497', 'K A S M U R I', 'B37', '', '', 0),
	('1.81.00295', 'SUTOPO', 'B38', '', '2', 0),
	('1.82.00470', 'KOHAFIT', 'B39', '', '', 0),
	('1.06.01403', 'ANDI SETIADI', 'B40', '', '', 0),
	('1.75.00028', 'SUTRISMAN', 'B41', '', '', 0),
	('1.96.00990', 'HARIYANTO', 'B42', '', '', 0),
	('1.96.01023', 'BENNY HERMAWAN', 'B43', '', '', 0),
	('1.95.00838', 'MOCH.IMAM SUPII', 'B44', '', '', 0),
	('1.14.01637', 'ANDRY SETYAWAN R.', 'B45', '', '', 0),
	('1.14.01615', 'AWANG SEBASTIAN A.', 'B46', '', '', 0),
	('1.14.01611', 'ACHMAD SUWANDI, AMD', 'B47', '', '', 0),
	('1.97.01139', 'RAHMAD', 'B48', '', '', 0),
	('1.06.01455', 'TRI PRAWOTO', 'B49', '', '', 0),
	('1.96.00980', 'SUTRISNO', 'B50', '085100290242', '5', 0),
	('1.96.00986', 'SUYANTO', 'B51', '085607794165', '4', 0),
	('1.06.01420', 'FATONI ASTRI MULYA', 'B52', '085731880003', '5', 0),
	('1.17.01843', 'RUDI HARDIYANTO', 'B53', '', '', 0),
	('1.81.00293', 'DUL RIFAI ALI', 'BB0', '', '', 0),
	('1.81.00304', 'SAMPURNO', 'BB3', '', '3', 0),
	('1.80.00268', 'SUWARSONO', 'BBM', '', '', 0),
	('1.07.01489', 'D A R W A N T O', 'BBN', '', '', 0),
	('1.06.01416', 'EKO MARGONO', 'BBP', '', '', 0),
	('1.97.01144', 'BASUNI ALWI', 'BM1', '', '', 0),
	('1.07.01490', 'DEDY SETIAWAN', 'BM2', NULL, NULL, 0),
	('1.06.01391', 'RICKY OCTAVIANUS', 'BM3', '', '', 0),
	('1.17.01857', 'THIBBY MUHAMMAD', 'BM4', '', '', 0),
	('1.17.01851', 'SUGENG RIYADI', 'BM5', '', '', 0),
	('1.96.01006', 'HARTOYO', 'BN1', '', '', 0),
	('1.88.00839', 'SUYONO', 'BN2', '', '', 0),
	('1.06.01381', 'WAFIYUDDIN, ST', 'BN3', '', '', 0),
	('1.06.01409', 'BAMBANG TRI WIDAYANTO', 'BN5', '', '', 0),
	('1.06.00429', 'KUSWARA', 'BN7', '', '', 0),
	('1.88.00882', 'YOHANES HENDRI WIHARTO', 'BN8', '', '', 0),
	('1.88.00842', 'SUJOKO', 'BN9', '', '', 0),
	('1.96.01042', 'SAFITRI AGUNG P', 'BP1', NULL, NULL, 0),
	('1.98.01258', 'PUJI MARDIANTO', 'BP2', NULL, NULL, 0),
	('1.81.00321', 'A.MUHJI', 'T01', '60263695', '3', 0),
	('1.06.01403', 'ANDI SETIADI', 'T02', '', '', 0),
	('1.96.01005', 'TEGUH HARIJANTO', 'T03', '', '1', 0),
	('1.07.01484', 'SUNTORO', 'T04', '', '', 0),
	('1.96.00990', 'HARIYANTO', 'T05', '', '', 0),
	('1.06.01396', 'AGUNG NUGROHO', 'T06', '', '', 0),
	('1.07.01497', 'K A S M U R I', 'T07', '', '', 0),
	('1.96.00999', 'EKO SUMARNO', 'T1', '', '', 0),
	('1.83.00556', 'SAMYONO', 'T12', '', '3', 0),
	('1.06.01428', 'KURNIAWAN HANARDI', 'T13', '081524061762', '', 0),
	('1.96.00968', 'HERIYANTO', 'T14', '', '3', 0),
	('1.96.00965', 'UNTUNG HARIYANTO', 'T15', '', '1', 0),
	('1.96.00994', 'NURIL HUDA', 'T16', '', '2', 0),
	('1.83.00900', 'EDI SUSENO', 'T17', '0811314351', '3', 0),
	('1.96.01011', 'BAMBANG SUDARTO S.SOS', 'T18', '0811310773', '', 0),
	('1.88.00883', 'AHMAD ROFIQ', 'T19', '08155323884', '2', 0),
	('1.06.01396', 'AGUNG NUGROHO', 'T2', '', '', 0),
	('1.83.00590', 'SAMURI', 'T20', '', '', 0),
	('1.83.00558', 'MUDJIONO', 'T26', '', '4', 0),
	('1.09.01556', 'JOHAN UNTUNG', 'T27', '082233006891', '3', 0),
	('1.96.00996', 'SAMIRIN', 'T30', '', '0', 0),
	('1.06.01416', 'EKO MARGONO', 'T32', '', '', 0),
	('1.81.00304', 'SAMPURNO', 'T33', '', '', 0),
	('1.80.00268', 'SUWARSONO', 'T34', '', '', 0),
	('1.95.00895', 'NASRUDIN', 'T35', '', '', 0),
	('1.96.00995', 'SUTOPO', 'T37', '03170783899', '2', 0),
	('1.96.01114', 'IRIANTO', 'T38', '03170783899', '2', 0),
	('1.96.00981', 'DISTOTO', 'T39', '', '3', 0),
	('1.78.00154', 'KATIRAN', 'T40', '', '', 0),
	('1.97.01126', 'PANUT', 'T41', '', '', 0),
	('1.96.01023', 'BENNY HERMAWAN', 'T43', '', '', 0),
	('1.97.01142', 'SUBROTO', 'T45', '', '3', 0),
	('1.82.00450', 'HARYONO', 'T46', '', '1', 0),
	('1.06.01450', 'MOCH. MUJIANTO', 'T47', '', '1', 0),
	('1.82.00354', 'MINGUN BUDI SETIJO UTOMO', 'T48', '', '5', 0),
	('1.14.01654', 'NURDHIN WAHYU R.', 'T49', '', '3', 0),
	('1.07.01483', 'SUGENG SANTOSO', 'T50', '', '2', 0),
	('1.96.00988', 'SUNARI', 'T51', '03177044781', '3', 0),
	('1.96.00983', 'ZAINUDIN', 'T52', '', '5', 0),
	('1.96.00982', 'PIYANTO', 'T53', '', '5', 0),
	('1.96.00930', 'KURIYANTO', 'T54', '', '1', 0),
	('1.95.00838', 'MOCH.IMAM SUPII', 'T56', '', '3', 0),
	('1.96.01035', 'MOCH. ARFANDI SH.', 'T69', '081703335634', '2', 0),
	('1.96.00972', 'SUPARDI', 'T71', '', '', 0),
	('1.06.01394', 'ADIE KURNIAWAN', 'T72', '', '', 0),
	('1.14.01637', 'ANDRY SETYAWAN R.', 'T73', '', '', 0),
	('1.14.01615', 'AWANG SEBASTIAN A.', 'T74', '', '', 0),
	('1.14.01611', 'ACHMAD SUWANDI, AMD', 'T75', '', '', 0),
	('1.10.01586', 'MOCHAMMAD MACHFUD', 'T76', '', '', 0),
	('1.09.01534', 'DIEGO MAULANA Y.', 'T77', '081234729519', '1', 0),
	('1.97.01137', 'NURALI', 'T78', '082233211114', '2', 0),
	('1.97.01141', 'APIN', 'T79', '082336194221', '2', 0),
	('1.97.01171', 'KHOIRUL HUDA', 'T80', '085230454989', '1', 0),
	('1.17.01791', 'MOCHAMAD ZAINUDIN', 'T81', '', '', 0),
	('1.17.01731', 'CHORI WIRANANTO', 'T82', '', '', 0),
	('1.84.00600', 'KASTUR', 'TA1', '0', '0', 0),
	('1.95.00880', 'Isnanto Hariyawan', 'TI', '', '', 1),
	('1.95.00840', 'RAKHMAD WIDAGDO', 'TL1', '', '0', 0),
	('1.98.01268', 'ANDIK SASMITO', 'TLK', '', '0', 0),
	('1.97.01144', 'BASUNI ALWI', 'TM1', NULL, NULL, 0),
	('1.07.01490', 'DEDY SETIAWAN', 'TM2', NULL, NULL, 0),
	('1.06.01391', 'RICKY OCTAVIANUS', 'TM3', '', '', 0),
	('1.17.01857', 'THIBBY MUHAMMAD', 'TM4', '', '', 0),
	('1.17.01851', 'SUGENG RIYADI', 'TM5', '', '', 0),
	('1.96.01006', 'HARTOYO', 'TN1', '', '', 0),
	('1.88.00839', 'SUYONO', 'TN2', '', '', 0),
	('1.06.01381', 'WAFIYUDDIN, ST', 'TN3', '', '', 0),
	('1.06.01353', 'IMANSYAH NOVIANTO, ST', 'TN4', '', '', 0),
	('1.06.01409', 'BAMBANG TRI WIDAYANTO', 'TN5', '', '', 0),
	('1.82.00369', 'MARGONO', 'TN6', '', '', 0),
	('1.06.00429', 'KUSWARA', 'TN7', '', '', 0),
	('1.88.00882', 'YOHANES HENDRI WIHARTO', 'TN8', '', '', 0),
	('1.88.00842', 'SUJOKO', 'TN9', '', '', 0),
	('1.96.01042', 'SAFITRI AGUNG P', 'TP1', NULL, NULL, 0),
	('1.98.01258', 'PUJI MARDIANTO', 'TP2', NULL, NULL, 0),
	('1.96.01010', 'MARDIYAN MULYO SUTONO', 'TSD', '', '', 0),
	('1.95.00838', 'MOCH.IMAM SUPII', 'TT2', '', '', 0),
	('1.81.00324', 'KUSMADJI', 'TTL', '', '', 0),
	('1.97.01107', 'HARIYANTO', 'TTQ', '', '', 0),
	('1.96.01023', 'BENNY HERMAWAN', 'TTS', '', '', 0);

-- Dumping structure for table pdam_master.ptgdist
CREATE TABLE IF NOT EXISTS `ptgdist` (
  `NIP` char(20) NOT NULL,
  `NAMA` char(30) NOT NULL,
  `KD_PTGDIST` char(4) NOT NULL,
  `TELEPON` char(12) DEFAULT NULL,
  `AKTIF` double DEFAULT NULL,
  `REKANAN` double DEFAULT NULL,
  `ISTIBLANG` double DEFAULT '0',
  PRIMARY KEY (`KD_PTGDIST`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.ptgdist: ~328 rows (approximately)
DELETE FROM `ptgdist`;
INSERT INTO `ptgdist` (`NIP`, `NAMA`, `KD_PTGDIST`, `TELEPON`, `AKTIF`, `REKANAN`, `ISTIBLANG`) VALUES
	('1.82.00299', 'M i s n a n', '01', NULL, 1, 0, 0),
	('510 056 059', 'Seger Al Nitiredjo', '02', NULL, 1, 0, 0),
	('1.78.00128', 'R u s d i', '03', NULL, 1, 0, 0),
	('510 050 963', 'K a s i d i', '04', NULL, 1, 0, 0),
	('510 092 184', 'W  a  r  a  s', '05', NULL, 1, 0, 0),
	('1.76.00072', 'R e m i n', '06', NULL, 1, 0, 0),
	('1.81.01070', 'Dulhadi', '07', NULL, 1, 0, 0),
	('1.78.00141', 'S u r i p', '08', NULL, 1, 0, 0),
	('1.81.00323', 'Ngateman', '09', NULL, 1, 0, 0),
	('510 092 065', 'Soekadi', '10', NULL, 1, 0, 0),
	('1.75.01069', 'K o i b', '11', NULL, 1, 0, 0),
	('1.75.00014', 'S a m e a n', '12', NULL, 1, 0, 0),
	('510 092 194', 'Achmad Sulani', '13', NULL, 1, 0, 0),
	('510 057 026', 'S u p a r m a n', '14', NULL, 1, 0, 0),
	('1.81.00296', 'B a n a r', '15', NULL, 1, 0, 0),
	('1.76.00074', 'N a s r i p', '16', NULL, 1, 0, 0),
	('510 092 204', 'S a m a r i', '17', NULL, 1, 0, 0),
	('1.80.00268', 'Suwarsono', '18', NULL, 1, 0, 0),
	('510 035 232', 'D u l l a h', '19', NULL, 1, 0, 0),
	('510 056 081', 'S o e m i d j a n', '20', NULL, 1, 0, 0),
	('1.81.00293', 'Dul Rifa\'i Ali', '21', NULL, 1, 0, 0),
	('1.76.00054', 'S e t u', '22', NULL, 1, 0, 0),
	('510 059 456', 'M i d j a n', '23', NULL, 1, 0, 0),
	('1.76.00075', 'D i m u n', '24', NULL, 1, 0, 0),
	('1.75.00019', 'T a h i t  I', '25', NULL, 1, 0, 0),
	('1.76.00056', 'M a s k u n', '26', NULL, 1, 0, 0),
	('510 035 214', 'Andi Suprapto', '27', NULL, 1, 0, 0),
	('1.76.00076', 'Slamet Riadi', '28', NULL, 1, 0, 0),
	('510 037 372', 'Atim', '29', NULL, 1, 0, 0),
	('1.75.00017', 'N g a d i m i n', '30', NULL, 1, 0, 0),
	('510 094 560', 'W a g i m i n', '31', NULL, 1, 0, 0),
	('1.96.01006', 'Hartoyo', '32', NULL, 1, 0, 0),
	('1.96.01007', 'M. Arip Mustopo', '33', NULL, 1, 0, 0),
	('1.78.00132', 'S a d i m a n', '34', NULL, 1, 0, 0),
	('1.78.00122', 'Muharto Hadi S.', '35', NULL, 1, 0, 0),
	('1.80.00281', 'S u c i p t  o', '36', NULL, 1, 0, 0),
	('1.81.00315', 'S u p o n o', '37', NULL, 1, 0, 0),
	('1.81.00291', 'S a h i d', '38', NULL, 1, 0, 0),
	('1.81.00303', 'N u r h a d i', '39', NULL, 1, 0, 0),
	('1.83.00485', 'S i s w a n t o', '40', NULL, 1, 0, 0),
	('1.82.00320', 'A s m a t', '42', NULL, 1, 0, 0),
	('1.81.00290', 'S a r d i n', '43', NULL, 1, 0, 0),
	('510 092 764', 'Y a h m a n', '44', NULL, 1, 0, 0),
	('510 052 072', 'A s k a n d a r', '45', NULL, 1, 0, 0),
	('1.80.00248', 'S u k a r n o', '46', NULL, 1, 0, 0),
	('510 052 077', 'P  o  n  i  d  i', '47', NULL, 1, 0, 0),
	('1.83.00558', 'M u d j i o n o', '48', NULL, 1, 0, 0),
	('1.71.00001', 'S a i m a n', '49', NULL, 1, 0, 0),
	('1.77.00114', 'S u t o n o', '50', NULL, 1, 0, 0),
	('1.75.00025', 'P o n i d i', '51', NULL, 1, 0, 0),
	('1.78.00135', 'A s p a n', '52', NULL, 1, 0, 0),
	('1.75.00024', 'M u d a k i r', '53', NULL, 1, 0, 0),
	('1.75.00034', 'S u t o', '54', NULL, 1, 0, 0),
	('1.77.00113', 'Supriadi', '55', NULL, 1, 0, 0),
	('1.78.00139', 'K a t m i n', '56', NULL, 1, 0, 0),
	('1.83.00579', 'A r s o', '57', NULL, 1, 0, 0),
	('510 056 757', 'W  i  n  i  h', '58', NULL, 1, 0, 0),
	('1.75.00023', 'S u w a r t o', '59', NULL, 1, 0, 0),
	('1.77.00112', 'Muntajib', '60', NULL, 1, 0, 0),
	('1.96.00978', 'Moch. Mudjianto', '61', NULL, 1, 0, 0),
	('1.76.00803', 'A. Kuswantoro', '62', NULL, 1, 0, 0),
	('1.78.00144', 'I s m i r a n', '63', NULL, 1, 0, 0),
	('1.76.00682', 'C h a s a n', '64', NULL, 1, 0, 0),
	('1.96.01068', 'S u b a r i', '65', NULL, 1, 0, 0),
	('510 056 058', 'S u k a r n o', '66', NULL, 1, 0, 0),
	('510 092 185', 'D u l m a n a n', '67', NULL, 1, 0, 0),
	('510 092 192', 'S u n i n d r o', '68', NULL, 1, 0, 0),
	('1.78.00142', 'Mudjiono', '69', NULL, 1, 0, 0),
	('1.77.00099', 'Moch. Kadarusman', '70', NULL, 1, 0, 0),
	('510 094 755', 'S  a  r  n  o', '71', NULL, 1, 0, 0),
	('510 092 209', 'S u p a r n o', '72', NULL, 1, 0, 0),
	('1.81.00294', 'I m b a r', '73', NULL, 1, 0, 0),
	('1.76.00068', 'Abd. Muin', '74', NULL, 1, 0, 0),
	('1.75.00025', 'P o n i d i', '75', NULL, 1, 0, 0),
	('1.97.01142', 'S u b r o t o', '76', NULL, 1, 0, 0),
	('1.79.00193', 'KADAR JAMAL', '77', NULL, 1, 0, 0),
	('1.83.00516', 'IMAM WAHYUDI', '78', NULL, 1, 0, 0),
	('1.78.00133', 'Ali Arifin', '99', NULL, 1, 0, 0),
	('SATUAN TUGAS PJD', 'SATUAN TUGAS PJD', 'B01', NULL, 1, 0, 0),
	('1.97.01137', 'NUR ALI', 'B02', NULL, 1, 0, 0),
	('1.81.00290', 'S A R D I N', 'B03', NULL, 1, 0, 0),
	('JEMBAR PERMAI', 'CV JEMBAR PERMAI', 'B04', NULL, 0, 1, 0),
	('1.17.01802', 'MUHAMMAD GUSJAINUR ROSIDIN', 'B05', NULL, NULL, NULL, 0),
	('1.96.00980', 'SUTRISNO', 'B06', NULL, 1, 0, 0),
	('1.97.01132', 'MUNJONO', 'B07', NULL, 1, 0, 0),
	('1.83.00558', 'M U D J I O N O', 'B08', NULL, 1, 0, 0),
	('CV HATA MAS', 'CV HATA MAS', 'B09', NULL, 0, 1, 0),
	('1.06.01453', 'MUSTAKIM', 'B10', NULL, 1, 0, 0),
	('1.06.01432', 'M. AHI FATMA WIDAGDA', 'B100', NULL, NULL, NULL, 0),
	('1.96.00986', 'SUYANTO', 'B11', NULL, 1, 0, 0),
	('CV MUSTIKA KARYA', 'CV MUSTIKA KARYA', 'B12', NULL, 0, 1, 0),
	('1.96.00974', 'MUSALI', 'B14', NULL, 1, 0, 0),
	('SATUAN TUGAS PTJSR', 'SATUAN TUGAS PTJSR', 'B16', NULL, 1, 0, 0),
	('1.83.00579', 'ARSO', 'B17', NULL, 1, 0, 0),
	('1.10.01582', 'HENDRO ARDIANSYAH R.', 'B18', NULL, NULL, NULL, 0),
	('1.96.00970', 'KANIPAN', 'B19', NULL, 1, 0, 0),
	('1.95.00886', 'KARDJONO', 'B20', NULL, 1, 0, 0),
	('1.97.01136', 'SUMADI', 'B21', NULL, 1, 0, 0),
	('1.96.00979', 'RUDI ISTANTO', 'B23', NULL, 1, 0, 0),
	('GANESHA JAYA', 'GANESHA JAYA', 'B24', NULL, 0, 1, 0),
	('1.96.00973', 'SUPARNO', 'B25', NULL, 1, 0, 0),
	('1.10.01581', 'WIDYAWAN P.', 'B26', NULL, NULL, NULL, 0),
	('1.09.01556', 'JOHAN UNTUNG', 'B27', NULL, NULL, NULL, 0),
	('1.17.01695', 'ACHMAD DJUNAEDI', 'B28', NULL, NULL, NULL, 0),
	('1.78.00142', 'MUDJIONO', 'B29', NULL, 1, 0, 0),
	('1.17.01726', 'AWIK SUSANTO', 'B30', NULL, NULL, NULL, 0),
	('1.81.00294', 'I M B A R', 'B33', NULL, 1, 0, 0),
	('1.96.00982', 'PIYANTO', 'B41', NULL, 1, 0, 0),
	('1.81.00298', 'MINADI', 'B42', NULL, 1, 0, 0),
	('1.06.01452', 'PURWANTO', 'B43', NULL, 1, 0, 0),
	('1.97.01141', 'APIN', 'B44', NULL, 1, 0, 0),
	('1.06.01455', 'TRI PRAWOTO', 'B45', NULL, NULL, NULL, 0),
	('1.97.01139', 'RAHMAD', 'B46', NULL, NULL, NULL, 0),
	('1.95.00838', 'MOCH.IMAM SUPII', 'B47', NULL, 1, 0, 0),
	('PERMANA PUTRA', 'CV PERMANA PUTRA', 'B48', NULL, 0, 1, 0),
	('1.06.01455', 'TRI PRAWOTO', 'B5', NULL, NULL, NULL, 0),
	('SURYA BUMI SAKTI', 'CV SURYA BUMI SAKTI', 'B50', NULL, 0, 1, 0),
	('BUKIDALAM BARISANI', 'PT BUKIDALAM BARISANI', 'B52', NULL, 0, 1, 0),
	('1.81.00289', 'SUJANTO', 'B55', NULL, 1, 0, 0),
	('T. 06020', 'HIDAYAT PURBO S.', 'B56', NULL, 1, 0, 0),
	('1.80.00703', 'BAMBANG HADI WALUYO', 'B58', NULL, 1, 0, 0),
	('1.96.00913', 'SOEDJIANTO', 'B59', NULL, 1, 0, 0),
	('1.97.01133', 'MUGIARTO', 'B60', NULL, 1, 0, 0),
	('1.06.01433', 'M. AFANDI', 'B62', NULL, 1, 0, 0),
	('1.06.01422', 'GUNAWAN KRISTIONO', 'B63', NULL, 1, 0, 0),
	('1.06.01403', 'ANDI SETIADI', 'B65', NULL, 1, 0, 0),
	('1.06.01396', 'AGUNG NUGROHO', 'B66', NULL, 1, 0, 0),
	('1.78.00134', 'ASKURI HADI', 'B67', NULL, 1, 0, 0),
	('CV JAYA LESTARI', 'JAYA LESTARI', 'B68', NULL, 0, 1, 0),
	('CV JAYA PUTRA', 'CV JAYA PUTRA', 'B69', NULL, 0, 1, 0),
	('1.07.01475', 'IMAM MASTUR', 'B7', NULL, NULL, NULL, 0),
	('CV HIKMAH.S', 'CV HIKMAH.S', 'B70', NULL, 0, 1, 0),
	('CV.GUSTI PUTRA SM', 'CV.GUSTI PUTRA SM', 'B71', NULL, 0, 1, 0),
	('CV.LANCAR REJEKI', 'CV.LANCAR REJEKI', 'B72', NULL, 0, 1, 0),
	('CV.ALAM INDAH', 'CV.ALAM INDAH', 'B73', NULL, 0, 1, 0),
	('CV BUNG JAYA A', 'CV BUNG JAYA A', 'B74', NULL, 0, 1, 0),
	('PT RIS PERDANA PUTRA', 'PT RIS PERDANA PUTRA', 'B75', NULL, 0, 1, 0),
	('CV RETRO M', 'CV RETRO M', 'B76', NULL, 0, 1, 0),
	('MEGA UTAMA', 'MEGA UTAMA', 'B77', NULL, 0, 1, 0),
	('CV.ANUGRAH ABADI', 'CV.ANUGRAH ABADI', 'B78', NULL, 0, 1, 0),
	('PELITA ABADI', 'PELITA ABADI', 'B79', NULL, 0, 1, 0),
	('1.07.01484', 'SUNTORO', 'B80', NULL, 1, 0, 0),
	('1.96.00939', 'WARYONO', 'B81', NULL, 1, 0, 0),
	('1.96.00971', 'RIYANTO', 'B82', NULL, 1, 0, 0),
	('1.81.00324', 'KUSMADJI', 'B83', NULL, 1, 0, 0),
	('1.96.00966', 'SUJONO', 'B84', NULL, 1, 0, 0),
	('1.96.00978', 'MOCH. MUDJIANTO', 'B85', NULL, 1, 0, 0),
	('TIRTA BUANA', 'TIRTA BUANA', 'B86', NULL, 1, 0, 0),
	('CV.AGUNG JAYA', 'CV.AGUNG JAYA', 'B87', NULL, 0, 1, 0),
	('PERMATA ALAM LESTARI', 'PERMATA ALAM LESTARI', 'B88', NULL, 0, 1, 0),
	('KARTIKA MARGA JAYA', 'KARTIKA MARGA JAYA', 'B89', NULL, 0, 1, 0),
	('CV.PUTRA PERTAMA', 'CV.PUTRA PERTAMA', 'B90', NULL, 0, 1, 0),
	('CV.SURYA JAYA M', 'CV.SURYA JAYA M', 'B91', NULL, 0, 1, 0),
	('PT. BEGAWAN', 'PT. BEGAWAN', 'B92', NULL, 0, 1, 0),
	('CV. MEGA LESTARI', 'CV. MEGA LESTARI', 'B93', NULL, 0, 1, 0),
	('CV. NIA KARYA', 'CV. NIA KARYA', 'B94', NULL, 0, 1, 0),
	('SARANA BUMI MANDIRI', 'CV SARANA BUMI MANDIRI', 'B95', NULL, 0, 1, 0),
	('FARHAT', 'CV FARHAT', 'B96', NULL, 0, 1, 0),
	('CENDAWAN', 'CV CENDAWAN', 'B97', NULL, 0, 1, 0),
	('ANUGRAH PERKASA', 'CV ANUGRA PERKASA', 'B98', NULL, 0, 1, 0),
	('KARYA DWI SENTOSA', 'KARYA DWI SENTOSA', 'B99', NULL, 0, 1, 0),
	('CV.DUTA PERKASA', 'CV.DUTA PERKASA', 'BA1', NULL, 0, 1, 0),
	('CV.LOKOMOTIF', 'CV.LOKOMOTIF', 'BA2', NULL, 0, 1, 0),
	('CV BOMA FORADI', 'CV BOMA FORADI', 'BA3', NULL, 0, 1, 0),
	('CV.AMERTA K.P.', 'CV.AMERTA K.P.', 'BA4', NULL, 0, 1, 0),
	('CV. ELSATAMA', 'CV. ELSATAMA', 'BA5', NULL, 0, 1, 0),
	('CV.CIPTA ADI PERSADA', 'CV.CIPTA ADI PERSADA', 'BA6', NULL, 0, 1, 0),
	('CV. VERSA INDO', 'CV. VERSA INDO', 'BA7', NULL, 0, 1, 0),
	('CV. PRIMA MARGA JAYA', 'CV. PRIMA MARGA JAYA', 'BA8', NULL, 0, 1, 0),
	('CV PELITA ABADI', 'CV PELITA ABADI', 'BA9', NULL, 0, 1, 0),
	('CV INDIE', 'CV INDIE', 'BB0', NULL, 0, 1, 0),
	('CV.NISRINA PRATAMA', 'CV.NISRINA PRATAMA', 'BB1', NULL, 0, 1, 0),
	('1.97.01137', 'NUR ALI', 'BB2', NULL, 1, 0, 0),
	('BUMI KARSA', 'CV BUMI KARSA', 'BB4', NULL, 0, 1, 0),
	('1.06.01450', 'MUDJIANTO', 'BB5', NULL, 1, 0, 0),
	('CV. NOOR AMBJAH', 'CV. NOOR AMBJAH', 'BB6', NULL, 0, 1, 0),
	('CV. PRIMA MARGA JAYA', 'CV. PRIMA MARGA JAYA', 'BB8', NULL, 0, 1, 0),
	('MAHAMERU', 'CV MAHAMERU', 'BB9', NULL, 0, 1, 0),
	('SATGAS', 'SATGAS', 'BBC9', NULL, NULL, NULL, 0),
	('BERLIAN NUSANTARA', 'BRILLIAN NUSANTARA', 'BBK', NULL, 0, 1, 0),
	('SATGAS', 'SATGAS', 'BBM1', NULL, NULL, NULL, 0),
	('AGUNG JAYA', 'CV. AGUNG JAYA', 'BBN', NULL, 0, 1, 0),
	('CV KARYA MUDA', 'CV KARYA MUDA', 'BC1', NULL, 0, 1, 0),
	('MUTIARA PRIMA', 'CV MUTIARA PRIMA', 'BC2', NULL, 0, 1, 0),
	('ANDHIKA MUDA', 'CV ANDHIKA MUDA', 'BC3', NULL, 0, 1, 0),
	('PT KHARISMA MULTI J', 'PT KHARISMA MULTI J', 'BC4', NULL, 0, 1, 0),
	('CV NOOR AMBJAH', 'CV NOOR AMBJAH', 'BC5', NULL, 0, 1, 0),
	('CV GUSTI PUTRA S.M', 'CV GUSTI PUTRA SUKSES MAKMUR', 'BC6', NULL, 0, 1, 0),
	('NISRINAPRATAMA.', 'CV NISRINA PRATAMA', 'BC7', NULL, 0, 1, 0),
	('CV RIZQULLAH PUTRA', 'CV RIZQULLAH PUTRA', 'BC8', NULL, NULL, NULL, 0),
	('CV ASIA LINE', 'CV ASIA LINE', 'BC9', NULL, 1, 1, 0),
	('CV. PUTRA MANDIRI', 'CV. PUTRA MANDIRI', 'BD1', NULL, 1, 1, 0),
	('KONT1 B', 'CV EMPAT SEKAWAN', 'BK1', NULL, 0, 1, 0),
	('KONT2 B', 'CV JOYO MAKMUR', 'BK2', '', 0, 1, 0),
	('KONT3 B', 'CV HARAPAN SANTOSA', 'BK3', NULL, 0, 1, 0),
	('CV.FADILLAH', 'CV.FADILLAH', 'BK4', NULL, 0, 1, 0),
	('CV.LANGGENG JAYA', 'CV.LANGGENG JAYA', 'BK5', NULL, 0, 1, 0),
	('CV.TRIPA JAYA', 'CV.TRIPA JAYA', 'BK6', NULL, 0, 1, 0),
	('BANGUN KARYA BERSAMA', 'BANGUN KARYA BERSAMA', 'BK7', NULL, 0, 1, 0),
	('WIDYA UTAMA KARYA', 'WIDYA UTAMA KARYA', 'BK8', NULL, 0, 1, 0),
	('JAKTOR KARYA KENCANA', 'JAKTOR KARYA KENCANA', 'BK9', NULL, 0, 1, 0),
	('PT. INDO MULYA', 'PT. INDO MULYA', 'BM2', NULL, 0, 1, 0),
	('1.96.01006', 'HARTOYO', 'BN1', NULL, 1, 0, 0),
	('1.88.00839', 'SUYONO', 'BN2', NULL, 1, 0, 0),
	('1.88.00882', 'YOHANES HENDRI WIHARTO', 'BN8', NULL, 1, 0, 0),
	('TIM PKA', 'TIM PKA', 'BN9', NULL, 1, 0, 0),
	('1.78.00134', 'ASKURI HADI', 'BZ1', NULL, NULL, NULL, 0),
	('PT. BKB', 'PT. BANGUN KARYA BERSAMA', 'T01', NULL, 0, 1, 0),
	('CV. DUTA PERKASA', 'CV. DUTA PERKASA', 'T02', NULL, 0, 1, 0),
	('SATUAN TUGAS PJD', 'SATUAN TUGAS PJD', 'T03', NULL, 1, 0, 0),
	('JATOR KARYA KENCANA', 'JATOR KARYA KENCANA', 'T04', NULL, 0, 1, 0),
	('CV. SURYA B.S', 'CV. SURYA B.S', 'T05', NULL, 0, 1, 0),
	('1.07.01473', 'HERU YUNIANTO', 'T06', NULL, 1, 0, 0),
	('1.06.01416', 'EKO MARGONO', 'T07', NULL, 1, 0, 0),
	('1.06.01433', 'M. AFANDI', 'T08', NULL, 0, 1, 0),
	('PELITA ABADI', 'PELITA ABADI', 'T09', NULL, 0, 1, 0),
	('PT. CIPTA ANEKA S', 'PT. CIPTA ANEKA SOLUSI', 'T10', NULL, 0, 1, 0),
	('CV. RUKUN. DS', 'CV. RUKUN. DS', 'T11', NULL, 0, 1, 0),
	('CV. BISMA KARYA', 'CV. BISMA KARYA', 'T12', NULL, 0, 1, 0),
	('PT. KARYA TUNGGAL MA', 'PT. KARYA TUNGGAL MA', 'T13', NULL, 0, 1, 0),
	('CV. ARFI', 'CV. ARFI', 'T14', NULL, 0, 1, 0),
	('SATUAN TUGAS PTJSR', 'SATUAN TUGAS PTJSR', 'T15', NULL, 1, 0, 0),
	('CV. TRIFA JAYA', 'CV. TRIFA JAYA', 'T16', NULL, 0, 1, 0),
	('VERSAINDO UTAMA', 'CV. VERSAINDO UTAMA', 'T17', NULL, 0, 1, 0),
	('CV.WINA UTAMA KARYA', 'CV.WINA UTAMA KARYA', 'T18', NULL, 0, 1, 0),
	('CV. LANGGENG. J', 'CV. LANGGENG JAYA', 'T19', NULL, 0, 1, 0),
	('FARHAT', 'CV FARHAT', 'T20', NULL, 0, 1, 0),
	('CV. RETRO MANDIRI', 'CV. RETRO MANDIRI', 'T21', NULL, 0, 1, 0),
	('1.96.01003', 'MISIYO', 'T22', NULL, 1, 0, 0),
	('CV. MAHAMERU', 'CV. MAHAMERU', 'T23', NULL, 0, 1, 0),
	('ANUGRAH ABADI', 'ANUGRAH ABADI', 'T24', NULL, 0, 1, 0),
	('YALA PINASTI', 'CV. YALA PINASTI', 'T25', NULL, 0, 1, 0),
	('CV. MUTIARA.P', 'CV. MUTIARA. P', 'T26', NULL, 0, 1, 0),
	('CV. GUSTI P.S.M', 'CV. GUSTI PUTRA SUKSES MAKMUR', 'T27', NULL, 0, 1, 0),
	('CV. INDIE CONS.', 'CV. INDIE CONSTRUCTION', 'T28', NULL, 0, 1, 0),
	('CV. ANDHITA PRATAMA', 'CV. ANDHITA PRATAMA', 'T29', NULL, 0, 1, 0),
	('1.17.01819', 'NURIL HUDA', 'T3', NULL, NULL, NULL, 0),
	('1.10.01581', 'WIDYAWAN P.', 'T30', NULL, 0, 1, 0),
	('1.83.00565', 'SARPIN', 'T31', NULL, 1, 0, 0),
	('1.96.01123', 'SUDJITO NUR CHAMID', 'T32', NULL, 1, 0, 0),
	('1.88.00879', 'ANWAR', 'T33', NULL, 1, 0, 0),
	('CV.KUMALA JAYA ABADI', 'CV.KUMALA JAYA ABADI', 'T34', NULL, 0, 1, 0),
	('1.09.01556', 'JOHAN UNTUNG', 'T35', NULL, 1, 0, 0),
	('1.80.00281', 'S U C I P T  O', 'T36', NULL, 1, 0, 0),
	('1.17.01804', 'MUHAMMAD NURUSH SHOBAH', 'T37', NULL, 1, 0, 0),
	('CV. LOKOMOTIF', 'CV. LOKOMOTIF', 'T38', NULL, 0, 1, 0),
	('1.81.00303', 'N U R H A D I', 'T39', NULL, 1, 0, 0),
	('1.17.01709', 'AHMAD FUAD KHOIRONI', 'T4', NULL, NULL, NULL, 0),
	('1.97.01171', 'KHOIRUL HUDA', 'T40', NULL, 1, 0, 0),
	('CV. NOOR AMBJAH', 'CV. NOOR AMBJAH', 'T41', NULL, 0, 1, 0),
	('1.17.01734', 'DAVID ADI PUTRA', 'T42', NULL, 1, 0, 0),
	('1.75.01069', 'K O I B', 'T43', NULL, 1, 0, 0),
	('CV. BRILIANT. N', 'CV. BRILIANT NUSANTARA', 'T44', NULL, 0, 1, 0),
	('1.14.01646', 'HENDRIK PRAKOSO', 'T45', NULL, 1, 0, 0),
	('1.06.01432', 'M. AHI FATMA WIDAGDA', 'T46', NULL, 1, 0, 0),
	('SATGAS', 'SATGAS', 'T47', NULL, NULL, NULL, 0),
	('1.97.01127', 'SUDAR', 'T48', NULL, 1, 0, 0),
	('BUKIDALAM BARISANI', 'PT. BUKIDALAM BARISANI', 'T49', NULL, 0, 1, 0),
	('1.10.01582', 'HENDRO ARDIANSYAH R.', 'T5', NULL, NULL, NULL, 0),
	('1.06.01387', 'ENDANG ISMAYANTI', 'T50', NULL, 1, 0, 0),
	('1.10.01581', 'WIDYAWAN P.', 'T51', NULL, 1, 0, 0),
	('1.83.00534', 'EDI SUMARNO', 'T52', NULL, 1, 0, 0),
	('1.06.01420', 'FATONI ASTRI MULYA', 'T53', NULL, 1, 0, 0),
	('JOYO MAKMUR', 'CV. JOYO MAKMUR', 'T54', NULL, 0, 1, 0),
	('CV. BUMI KARSA', 'CV. BUMI KARSA', 'T55', NULL, 0, 1, 0),
	('CV.KARYA BAROKAH', 'CV. KARYA BAROKAH', 'T56', NULL, 0, 1, 0),
	('1.79.00213', 'MISKAN', 'T59', NULL, 1, 0, 0),
	('1.06.01422', 'GUNAWAN KRISTIONO', 'T6', NULL, NULL, NULL, 0),
	('1.81.00296', 'BANAR', 'T60', NULL, 1, 0, 0),
	('1.95.01077', 'HASAN BASRI', 'T61', NULL, 1, 0, 0),
	('1.06.01394', 'ADIE KURNIAWAN', 'T62', NULL, 1, 0, 0),
	('KHARISMA MULTI JAYA', 'KHARISMA MULTI JAYA', 'T63', NULL, 0, 1, 0),
	('1.07.01490', 'DEDY SETIAWAN', 'T64', NULL, 1, 0, 0),
	('1.07.01480', 'M. SUJARWO', 'T65', NULL, 1, 0, 0),
	('1.17.01734', 'DAVID ADI PUTRA', 'T66', NULL, 1, 0, 0),
	('1.17.01706', 'AGUS YULIANTO', 'T67', NULL, 1, 0, 0),
	('1.97.01132', 'MUNJONO', 'T7', NULL, NULL, NULL, 0),
	('JAYA PUTRA', 'CV. JAYA PUTRA', 'T70', NULL, 0, 1, 0),
	('BRILIAN NUSANTARA', 'CV. BRILIAN NUSANTARA', 'T71', NULL, 0, 1, 0),
	('CV.MUSTIKA KARYA', 'CV.MUSTIKA KARYA', 'T72', NULL, 0, 1, 0),
	('NISRINA. P', 'CV. NISRINA. P', 'T73', NULL, 0, 1, 0),
	('OUT2', 'SIRAN', 'T75', NULL, 0, 1, 0),
	('CONT3', 'RUDJI', 'T76', NULL, 0, 1, 0),
	('CONT4', 'MUHARTO H.S', 'T77', NULL, 0, 1, 0),
	('CONT5', 'WARAS', 'T78', NULL, 0, 1, 0),
	('CONT6', 'SUJOTO', 'T79', NULL, 0, 1, 0),
	('EMPAT SEKAWAN', 'EMPAT SEKAWAN', 'T80', NULL, 0, 1, 0),
	('PERMANA PUTRA', 'PERMANA PUTRA', 'T81', NULL, 0, 1, 0),
	('RIDHO NUR', 'RIDHO NUR', 'T82', NULL, 0, 1, 0),
	('PUTRA PERTAMA', 'PUTRA PERTAMA', 'T83', NULL, 0, 1, 0),
	('JEMBAR PERMAI CORP', 'JEMBAR PERMAI CORP', 'T84', NULL, 0, 1, 0),
	('KARTIKA MARGA JAYA', 'KARTIKA MARGA JAYA', 'T85', NULL, 0, 1, 0),
	('GANESHA JAYA', 'GANESHA JAYA', 'T86', NULL, 0, 1, 0),
	('FADHILAH P.M', 'FADHILAH PUTRA MANDIRI', 'T87', NULL, 0, 1, 0),
	('MEGA LESTARI', 'MEGA LESTARI', 'T88', NULL, 0, 1, 0),
	('SARANA BUMI MANDIRI', 'SARANA BUMI MANDIRI', 'T89', NULL, 0, 1, 0),
	('BOMA FARADI', 'BOMA FARADI', 'T90', NULL, 0, 1, 0),
	('JAYA LESTARI', 'JAYA LESTARI', 'T91', NULL, 0, 1, 0),
	('MEGA UTAMA', 'MEGA UTAMA', 'T92', NULL, 0, 1, 0),
	('JAYA MAKMUR', 'JAYA MAKMUR', 'T93', NULL, 0, 1, 0),
	('BUNG JAYA ABADI', 'BUNG JAYA ABADI', 'T94', NULL, 0, 1, 0),
	('PRADAH KURNIA SAKTI', 'PRADAH KURNIA SAKTI', 'T95', NULL, 0, 1, 0),
	('ANUGERAH PERKASA', 'ANUGERAH PERKASA', 'T96', NULL, 0, 1, 0),
	('HATA MAS', 'HATA MAS', 'T97', NULL, 0, 1, 0),
	('NIA KARYA', 'NIA KARYA', 'T98', NULL, 0, 1, 0),
	('CENDAWAN', 'CENDAWAN', 'T99', NULL, 0, 1, 0),
	('1.81.00301', 'SIRAT', 'TA4', NULL, NULL, NULL, 0),
	('1.96.00970', 'KANIPAN', 'TA6', NULL, NULL, NULL, 0),
	('1.81.00318', 'SOLIKIN', 'TA7', NULL, 1, 0, 0),
	('CV. KARYA MUDA', 'CV. KARYA MUDA', 'TC1', NULL, 0, 1, 0),
	('CV. HYLAS JAYA', 'CV. HYLAS JAYA', 'TC2', NULL, 0, 1, 0),
	('CV. KARTIKO YASA U', 'CV. KARTIKO YASA UTAMA', 'TC3', NULL, NULL, NULL, 0),
	('1.90.00904', 'NURUL ANWAR', 'TC4', NULL, 1, NULL, 0),
	('CV RIZQULLAH PUTRA', 'CV RIZQULLAH PUTRA', 'TC8', NULL, NULL, NULL, 0),
	('CV ASIA LINE', 'CV ASIA LINE', 'TC9', NULL, 1, 1, 0),
	('CV. PUTRA MANDIRI', 'CV. PUTRA MANDIRI', 'TD1', NULL, 1, 1, 0),
	('SATUAN TUGAS TIBLANG', 'SATUAN TUGAS TIBLANG', 'TI', NULL, 1, 0, 1),
	('1.97.01144', 'BASUNI ALWI', 'TM1', NULL, 1, 0, 0),
	('PT. INDO MULYA', 'PT. INDO MULYA', 'TM2', NULL, 0, 1, 0),
	('1.95.00886', 'KARDJONO', 'TM3', NULL, 1, 0, 0),
	('1.96.00966', 'SUJONO', 'TN1', NULL, 1, 0, 0),
	('1.96.00980', 'SUTRISNO', 'TN2', NULL, 1, 0, 0),
	('1.06.01453', 'MUSTAKIM', 'TN3', NULL, 1, 0, 0),
	('1.77.00113', 'SUPRIADI', 'TN4', NULL, 1, 0, 0),
	('1.06.01409', 'BAMBANG TRI WIDAYANTO', 'TN5', NULL, 1, 0, 0),
	('1.96.00979', 'RUDI ISTANTO', 'TN6', NULL, 1, NULL, 0),
	('1.98.01268', 'ANDIK SASMITO', 'TN7', NULL, NULL, NULL, 0),
	('TIM PKA', 'TIM PKA', 'TN9', NULL, 1, 0, 0);

-- Dumping structure for table pdam_master.spk_pb
CREATE TABLE IF NOT EXISTS `spk_pb` (
  `NO_SPKPB` char(20) NOT NULL,
  `NO_KELUARPB` char(20) DEFAULT NULL,
  `TGL_SPKPB` datetime NOT NULL,
  `TGL_REALISASI` datetime DEFAULT NULL,
  `KD_PENGAWAS` char(3) NOT NULL,
  `KD_PTGDIST` char(4) DEFAULT NULL,
  `NIP` char(20) DEFAULT NULL,
  `NIP_NIP` char(20) DEFAULT NULL,
  `NIP_PETUGAS` char(20) DEFAULT NULL,
  `NIP_PENGAWAS` char(20) DEFAULT NULL,
  `PERLU_REKANAN` decimal(22,1) DEFAULT NULL,
  `NPWP_REKANAN` char(20) DEFAULT NULL,
  `IS_PERLUTAGIH` double DEFAULT '0',
  `NO_KONTRAK` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`NO_SPKPB`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.spk_pb: ~3 rows (approximately)
DELETE FROM `spk_pb`;
INSERT INTO `spk_pb` (`NO_SPKPB`, `NO_KELUARPB`, `TGL_SPKPB`, `TGL_REALISASI`, `KD_PENGAWAS`, `KD_PTGDIST`, `NIP`, `NIP_NIP`, `NIP_PETUGAS`, `NIP_PENGAWAS`, `PERLU_REKANAN`, `NPWP_REKANAN`, `IS_PERLUTAGIH`, `NO_KONTRAK`) VALUES
	('B20180800001', NULL, '2018-08-02 09:48:34', NULL, 'B45', 'B45', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
	('B20180800002', NULL, '2018-08-02 09:48:47', NULL, 'B45', 'B45', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
	('B20180800003', 'BPB201800001', '2018-08-02 09:42:03', NULL, 'B02', 'B45', NULL, NULL, NULL, NULL, 0.0, NULL, 0, NULL);

-- Dumping structure for table pdam_master.ukuranmtr
CREATE TABLE IF NOT EXISTS `ukuranmtr` (
  `UKURAN_MTR` decimal(4,2) NOT NULL,
  `RP_SEWA` decimal(20,2) NOT NULL,
  `RP_PENGGANTIAN` decimal(20,2) NOT NULL,
  `RP_TERA` decimal(20,2) NOT NULL,
  `RP_PASANGTANAH` decimal(20,2) NOT NULL,
  `RP_PASANGJEDING` decimal(20,2) NOT NULL,
  PRIMARY KEY (`UKURAN_MTR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_master.ukuranmtr: ~12 rows (approximately)
DELETE FROM `ukuranmtr`;
INSERT INTO `ukuranmtr` (`UKURAN_MTR`, `RP_SEWA`, `RP_PENGGANTIAN`, `RP_TERA`, `RP_PASANGTANAH`, `RP_PASANGJEDING`) VALUES
	(0.50, 2400.00, 144000.00, 0.00, 1600.00, 2100.00),
	(0.75, 2400.00, 144000.00, 0.00, 1600.00, 2100.00),
	(1.00, 8000.00, 480000.00, 0.00, 1600.00, 2100.00),
	(1.50, 14000.00, 840000.00, 0.00, 2600.00, 3100.00),
	(2.00, 19000.00, 1140000.00, 0.00, 2600.00, 3100.00),
	(3.00, 26500.00, 1590000.00, 0.00, 10800.00, 12800.00),
	(4.00, 40000.00, 2400000.00, 0.00, 10800.00, 15800.00),
	(6.00, 60000.00, 3600000.00, 0.00, 22000.00, 27000.00),
	(8.00, 75000.00, 4500000.00, 0.00, 0.00, 0.00),
	(10.00, 100000.00, 6000000.00, 0.00, 0.00, 32000.00),
	(12.00, 125000.00, 7500000.00, 0.00, 0.00, 0.00),
	(16.00, 175000.00, 10500000.00, 0.00, 0.00, 32000.00);

