#
# TABLE STRUCTURE FOR: coverage
#

DROP TABLE IF EXISTS `coverage`;

CREATE TABLE `coverage` (
  `coverage_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(128) NOT NULL,
  `address` text NOT NULL,
  `id_prov` varchar(50) NOT NULL,
  `id_kab` varchar(50) NOT NULL,
  `id_kec` varchar(50) NOT NULL,
  `id_kel` varchar(50) NOT NULL,
  `comment` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `radius` int(11) NOT NULL,
  `public` int(11) NOT NULL,
  `code_area` varchar(10) NOT NULL,
  `create_by` int(11) NOT NULL,
  `coverage_mitra` int(11) NOT NULL,
  PRIMARY KEY (`coverage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (131, 'WINONGAN', 'WINONGAN', '', '', '', '', '', '', '', 0, 1, '01', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (132, 'GONDANGWETAN', 'GONDANGWETAN', '', '', '', '', '', '', '', 0, 1, '02', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (133, 'REJOSO', 'REJOSO', '', '', '', '', '', '', '', 0, 1, '03', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (134, 'GRATI', 'GRATI', '', '', '', '', '', '', '', 0, 1, '04', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (135, 'NGULING', 'NGULING', '', '', '', '', '', '', '', 0, 1, '05', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (136, 'LEKOK', 'LEKOK', '', '', '', '', '', '', '', 0, 1, '06', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (137, 'KRATON', 'KRATON', '', '', '', '', '', '', '', 0, 1, '07', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (138, 'PASERPAN', 'PASERPAN', '', '', '', '', '', '', '', 0, 1, '08', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (139, 'REMBANG', 'REMBANG', '', '', '', '', '', '', '', 0, 1, '09', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (140, 'POJENTREK', 'POJENTREK', '', '', '', '', '', '', '', 0, 1, '10', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (141, 'PURWOREJO', 'PURWOREJO', '', '', '', '', '', '', '', 0, 1, '11', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (142, 'PANDAAN', 'PANDAAN', '', '', '', '', '', '', '', 0, 1, '12', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (143, 'LUMBANG', 'LUMBANG', '', '', '', '', '', '', '', 0, 1, '13', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (144, 'TONGAS', 'TONGAS', '', '', '', '', '', '', '', 0, 1, '14', 1667, 0);
INSERT INTO `coverage` (`coverage_id`, `c_name`, `address`, `id_prov`, `id_kab`, `id_kec`, `id_kel`, `comment`, `latitude`, `longitude`, `radius`, `public`, `code_area`, `create_by`, `coverage_mitra`) VALUES (145, 'WONOREJO', 'WONOREJO', '', '', '', '', '', '', '', 0, 1, '15', 1667, 0);


