#
# TABLE STRUCTURE FOR: m_odc
#

DROP TABLE IF EXISTS `m_odc`;

CREATE TABLE `m_odc` (
  `id_odc` int(11) NOT NULL AUTO_INCREMENT,
  `code_odc` text NOT NULL,
  `coverage_odc` int(11) NOT NULL,
  `no_port_olt` int(11) NOT NULL,
  `color_tube_fo` text NOT NULL,
  `no_pole` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `total_port` int(11) NOT NULL,
  `document` text NOT NULL,
  `remark` text NOT NULL,
  `created` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `create_by` int(11) NOT NULL,
  `lock_odc` int(11) NOT NULL,
  PRIMARY KEY (`id_odc`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `m_odc` (`id_odc`, `code_odc`, `coverage_odc`, `no_port_olt`, `color_tube_fo`, `no_pole`, `latitude`, `longitude`, `total_port`, `document`, `remark`, `created`, `role_id`, `create_by`, `lock_odc`) VALUES (2, '0101-MENDALAN', 131, 1, '', '', '', '', 30000, '', ' ', 1763950250, 0, 0, 0);
INSERT INTO `m_odc` (`id_odc`, `code_odc`, `coverage_odc`, `no_port_olt`, `color_tube_fo`, `no_pole`, `latitude`, `longitude`, `total_port`, `document`, `remark`, `created`, `role_id`, `create_by`, `lock_odc`) VALUES (3, '0102-MENDALAN BARU', 131, 2, '', '', '', '', 30000, '', ' ', 1763951451, 0, 0, 0);
INSERT INTO `m_odc` (`id_odc`, `code_odc`, `coverage_odc`, `no_port_olt`, `color_tube_fo`, `no_pole`, `latitude`, `longitude`, `total_port`, `document`, `remark`, `created`, `role_id`, `create_by`, `lock_odc`) VALUES (4, '0201-NGOPAK', 133, 3, '', '', '', '', 0, '', ' ', 1763951630, 0, 0, 0);
INSERT INTO `m_odc` (`id_odc`, `code_odc`, `coverage_odc`, `no_port_olt`, `color_tube_fo`, `no_pole`, `latitude`, `longitude`, `total_port`, `document`, `remark`, `created`, `role_id`, `create_by`, `lock_odc`) VALUES (5, '0301-NGULING', 135, 4, '', '', '', '', 0, '', ' ', 1763951677, 0, 0, 0);
INSERT INTO `m_odc` (`id_odc`, `code_odc`, `coverage_odc`, `no_port_olt`, `color_tube_fo`, `no_pole`, `latitude`, `longitude`, `total_port`, `document`, `remark`, `created`, `role_id`, `create_by`, `lock_odc`) VALUES (6, '0401-SIDOGIRI', 137, 4, '', '', '', '', 0, '', ' ', 1763951780, 0, 0, 0);
INSERT INTO `m_odc` (`id_odc`, `code_odc`, `coverage_odc`, `no_port_olt`, `color_tube_fo`, `no_pole`, `latitude`, `longitude`, `total_port`, `document`, `remark`, `created`, `role_id`, `create_by`, `lock_odc`) VALUES (7, '0501-PANDAAN', 142, 5, '', '', '', '', 0, '', ' ', 1763951817, 0, 0, 0);


