-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 30 Sep 2023 pada 06.01
-- Versi server: 10.4.17-MariaDB
-- Versi PHP: 7.3.26

START TRANSACTION;



--
-- Database: `dashboard`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `approve`
--

CREATE TABLE `approve` (
  `sow_id` varchar(20) NOT NULL,
  `kkst` varchar(50) NOT NULL,
  `capex` varchar(50) NOT NULL,
  `site_id` varchar(20) NOT NULL,
  `site_name` varchar(50) NOT NULL,
  `owner` varchar(20) NOT NULL,
  `sow` varchar(50) NOT NULL,
  `activity` varchar(50) NOT NULL,
  `rf_bfr` int(20) NOT NULL,
  `mw_bfr` int(20) NOT NULL,
  `rru_bfr` int(20) NOT NULL,
  `rf_aft` int(20) NOT NULL,
  `mw_aft` int(20) NOT NULL,
  `rru_aft` int(20) NOT NULL,
  `rf_ud` int(20) NOT NULL,
  `mw_ud` int(20) NOT NULL,
  `rru_ud` int(20) NOT NULL,
  `tgl_oac` date DEFAULT NULL,
  `oac` varchar(100) NOT NULL,
  `tgl` date NOT NULL,
  `status` varchar(20) NOT NULL,
  `status_tp` varchar(20) NOT NULL,
  `mitra` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `approve`
--

INSERT INTO `approve` (`sow_id`, `kkst`, `capex`, `site_id`, `site_name`, `owner`, `sow`, `activity`, `rf_bfr`, `mw_bfr`, `rru_bfr`, `rf_aft`, `mw_aft`, `rru_aft`, `rf_ud`, `mw_ud`, `rru_ud`, `tgl_oac`, `oac`, `tgl`, `status`, `status_tp`, `mitra`) VALUES
('4010109189', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', 'CAPEX RAN 2 PART 1 2023', 'BKG116', 'Petapahan (OPSG Topaz)', 'PTI', 'LOI-2 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 1, 6, 3, 1, 9, 3, 1, 9, '2023-06-14', '/uploads/4010109189_oac1.pdf', '2023-09-21', 'approve', 'approve', 'ericsson'),
('4010111892', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', 'CAPEX RAN 2 PART 1 2023', 'ASK003', 'Sei Nanam Gumanti', 'PTI', 'LOI-2 2023_New Site 4G', 'Swap 3 RF & Add 2 RRU', 5, 1, 9, 5, 1, 11, 5, 1, 11, '2023-06-21', '/uploads/4010111892_oac1.pdf', '2023-09-21', 'reject', 'approve', 'ericsson'),
('4010111893', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', 'CAPEX RAN 2 PART 1 2023', 'ASK010', 'Cupak Gunung Talang', 'PTI', 'LOI-1 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 3, 1, 8, '2023-06-20', '/uploads/4010111893_oac2.pdf', '2023-09-22', '', 'approve', 'ericsson'),
('4010111904', '0112/KKSTADD/PROTELINDO/ACTIVITY NON MPSL_CP 2 ADD', '2023 Capex 2 LOI', 'BKG703', 'E_BKG703_MuaraFajar2-PRO', 'PTI', 'EQP New NE 4G LTE 2300 10 Mhz', 'Add 2 RRU', 3, 0, 9, 3, 0, 11, 3, 0, 11, '2023-06-18', '/uploads/4010111904_oac1.pdf', '2023-09-29', '', 'approve', 'ericsson'),
('4010111975', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', '2023 Capex 2 LOI', 'PBR183', 'E_PBR183_SiakPalas-PTI', 'PTI', 'EQP New Site 4G LTE 2300 10 Mhz', 'Add RRU', 3, 0, 9, 3, 0, 11, 3, 0, 11, '2023-06-18', '/uploads/4010111975_oac2.pdf', '0000-00-00', '', '', 'ericsson'),
('4010111981', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', '2023 Capex 2 LOI', 'PBR816', 'E_PBR816_Limbungan2-PTI', 'PTI', 'EQP New NE 4G LTE 2300 10 Mhz', 'Add 1 RRU', 4, 0, 9, 4, 0, 10, 4, 0, 10, '2023-06-18', '/uploads/4010111981_oac1.pdf', '0000-00-00', '', '', 'ericsson'),
('4010113815', '0112/KKSTADD/PROTELINDO/ACTIVITY NON MPSL_CP 2 ADD', '2023 Capex 2 LOI', 'BKG204', 'E_BKG204_Teropong2-PTI', 'PTI', 'EQP NEW NE 4G LTE 900 5 Mhz', 'Add 3 RF Antenna + Remove 3 RF Antenna + Add 3 RRU', 3, 0, 9, 3, 0, 12, 3, 0, 12, '2023-06-18', '/uploads/4010113815_oac1.pdf', '2023-09-20', 'reject', 'approve', 'ericsson'),
('4010116754', '0028/KKSTADD/EBT/CAPEX RAN 2 PART 1 2023/VI/2023', 'CAPEX RAN 2 PART 1 2023', 'DUM320', 'STMIK Dumai 2', 'EBT', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 3, 1, 8, '2023-06-30', '/uploads/4010116754_UAS_DWDMok.pdf', '2023-09-14', 'approve', 'approve', 'ericsson'),
('4010117129', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', '2023 Capex 2 LOI#3', 'PBR876', 'E_PBR876_TamanKaryaUjung-KIN', 'PTI', 'EQP NEW NE 4G LTE 900 5 Mhz', 'Add RRU', 3, 0, 9, 3, 0, 12, 3, 0, 12, '2023-06-30', '/uploads/4010117129_statement_of_originality_sisfokom_2.pdf', '2023-09-21', 'reject', 'approve', 'huawei');

-- --------------------------------------------------------

--
-- Struktur dari tabel `dataset`
--

CREATE TABLE `dataset` (
  `sow_id` varchar(20) NOT NULL,
  `kkst` varchar(50) NOT NULL,
  `capex` varchar(100) NOT NULL,
  `site_id` varchar(10) NOT NULL,
  `site_name` varchar(50) NOT NULL,
  `owner` varchar(15) NOT NULL,
  `sow` varchar(100) NOT NULL,
  `activity` varchar(100) NOT NULL,
  `rf_bfr` int(10) NOT NULL,
  `mw_bfr` int(10) NOT NULL,
  `rru_bfr` int(10) NOT NULL,
  `rf_aft` int(10) NOT NULL,
  `mw_aft` int(10) NOT NULL,
  `rru_aft` int(10) NOT NULL,
  `rf_ud` int(10) NOT NULL,
  `mw_ud` int(10) NOT NULL,
  `rru_ud` int(10) NOT NULL,
  `tgl_oac` date DEFAULT NULL,
  `action` varchar(15) NOT NULL,
  `mitra` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `dataset`
--

INSERT INTO `dataset` (`sow_id`, `kkst`, `capex`, `site_id`, `site_name`, `owner`, `sow`, `activity`, `rf_bfr`, `mw_bfr`, `rru_bfr`, `rf_aft`, `mw_aft`, `rru_aft`, `rf_ud`, `mw_ud`, `rru_ud`, `tgl_oac`, `action`, `mitra`) VALUES
('4010109189', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', 'CAPEX RAN 2 PART 1 2023', 'BKG116', 'Petapahan (OPSG Topaz)', 'PTI', 'LOI-2 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 1, 6, 3, 1, 9, 3, 1, 9, '2023-06-14', 'approve', 'ericsson'),
('4010111892', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', 'CAPEX RAN 2 PART 1 2023', 'ASK003', 'Sei Nanam Gumanti', 'PTI', 'LOI-2 2023_New Site 4G', 'Swap 3 RF & Add 2 RRU', 5, 1, 9, 5, 1, 11, 5, 1, 11, '2023-06-21', 'approve', 'ericsson'),
('4010111893', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', 'CAPEX RAN 2 PART 1 2023', 'ASK010', 'Cupak Gunung Talang', 'PTI', 'LOI-1 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 3, 1, 8, '2023-06-20', 'approve', 'ericsson'),
('4010111904', '0112/KKSTADD/PROTELINDO/ACTIVITY NON MPSL_CP 2 ADD', '2023 Capex 2 LOI', 'BKG703', 'E_BKG703_MuaraFajar2-PRO', 'PTI', 'EQP New NE 4G LTE 2300 10 Mhz', 'Add 2 RRU', 3, 0, 9, 3, 0, 11, 3, 0, 11, '2023-06-18', 'approve', 'ericsson'),
('4010111975', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', '2023 Capex 2 LOI', 'PBR183', 'E_PBR183_SiakPalas-PTI', 'PTI', 'EQP New Site 4G LTE 2300 10 Mhz', 'Add RRU', 3, 0, 9, 3, 0, 11, 3, 0, 11, '2023-06-18', 'approve', 'ericsson'),
('4010111981', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', '2023 Capex 2 LOI', 'PBR816', 'E_PBR816_Limbungan2-PTI', 'PTI', 'EQP New NE 4G LTE 2300 10 Mhz', 'Add 1 RRU', 4, 0, 9, 4, 0, 10, 4, 0, 10, '2023-06-18', 'approve', 'ericsson'),
('4010113815', '0112/KKSTADD/PROTELINDO/ACTIVITY NON MPSL_CP 2 ADD', '2023 Capex 2 LOI', 'BKG204', 'E_BKG204_Teropong2-PTI', 'PTI', 'EQP NEW NE 4G LTE 900 5 Mhz', 'Add 3 RF Antenna + Remove 3 RF Antenna + Add 3 RRU', 3, 0, 9, 3, 0, 12, 0, 0, 0, '2023-06-18', '', 'ericsson'),
('4010113817', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', 'CAPEX RAN 2 PART 1 2023', 'BLS724', 'Selat Panjang Backbone', 'PTI', 'LOI-2 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-14', '', 'ericsson'),
('4010113820', '0071/KKSTADD/PROTELINDO/CAPEX RAN 2 PART 1 2023/V/', 'CAPEX RAN 2 PART 1 2023', 'BTM163', 'Batu Aji Pelabuhan Sagulung', 'PTI', 'LOI-2 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 4, 0, 7, 4, 0, 10, 0, 0, 0, '2023-06-14', '', 'ericsson'),
('4010115178', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PAD157', 'INDARUNG-RAYA-23', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 4, 1, 6, 4, 1, 9, 0, 0, 0, '2023-06-21', '', 'ericsson'),
('4010115364', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BLS135', 'Teluk Ketapang', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Dismantle 1 RRU, Add 3 RRU-->Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 0, 0, 0, '2023-06-26', '', 'ericsson'),
('4010115381', '0079/KKSTADD/EBT/Acti vity Non MPSL_CP2 RAFI 2023/', 'CAPEX RAN 2 PART 1 2023', 'DUM706', 'Dumai Barat Keladi', 'EBT', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-18', '', 'ericsson'),
('4010115534', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PPN787', 'Rambah Baru', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Dismantle 1 RRU, Add 2 RRU', 3, 1, 5, 3, 1, 6, 0, 0, 0, '2023-06-26', '', 'ericsson'),
('4010116029', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BKG165', 'Pondok Godang', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116040', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BKT108', 'BKT MC 9', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 0, 9, 3, 0, 11, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116051', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BLS138', 'Telaga Samsam', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116120', '0028/KKSTADD/EBT/CAPEX RAN 2 PART 1 2023/VI/2023', 'CAPEX RAN 2 PART 1 2023', 'DUM320', 'STMIK Dumai 2', 'EBT', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116221', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PKR664', 'Tanjung Kuyo', 'PTI', 'LOI-3 2023_New Site 4G', 'Dismantle 5 RF, Add 3 RF & Add 2 RRU', 6, 1, 6, 4, 1, 8, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116240', '0028/KKSTADD/EBT/CAPEX RAN 2 PART 1 2023/VI/2023', 'CAPEX RAN 2 PART 1 2023', 'PPN604', 'Simpang Torganda', 'EBT', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 4, 6, 3, 4, 8, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116282', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'SSI933', 'Kampung Tengah Siak', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 0, 9, 3, 0, 11, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116292', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', 'CAPEX RAN 2 PART 1 2023', 'TAK643', 'Sungai Paku - Koto Baru', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 2 RRU', 3, 1, 6, 3, 1, 8, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010116988', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BLS280', 'Pangkalan Jambi', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 1, 6, 3, 1, 9, 0, 0, 0, '2023-06-19', '', 'ericsson'),
('4010116993', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BLS739', 'Selat Panjang Kota 2', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 6, 1, 3, 6, 1, 6, 0, 0, 0, '2023-06-23', '', 'ericsson'),
('4010116995', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BSB007', 'Sungai Lekop Bintan', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 0, 3, 3, 0, 6, 0, 0, 0, '2023-06-23', '', 'ericsson'),
('4010117028', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BTM733', 'Ruko Taman Niaga', 'PTI', 'LOI-3 2023_New Site 4G', 'Swap 3 RF & Add 3 RRU', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-26', '', 'ericsson'),
('4010117038', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BTM993', 'PATTIMURA KABIL', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 1, 6, 3, 1, 9, 0, 0, 0, '2023-06-26', '', 'ericsson'),
('4010117046', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'DUM087', 'Sultan Hasanudin Rimba', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 1, 9, 3, 1, 12, 0, 0, 0, '2023-06-20', '', 'ericsson'),
('4010117051', '0028/KKSTADD/EBT/CAPEX RAN 2 PART 1 2023/VI/2023', 'CAPEX RAN 2 PART 1 2023', 'DUM186', 'Jl. Al Mubin Air Bersih (one ponsel)', 'EBT', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 1, 6, 3, 1, 9, 0, 0, 0, '2023-06-20', '', ''),
('4010117059', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'DUM684', 'Dumai 6', 'PTI', 'LOI-3 2023_New Site 4G', 'Swap 3 RF & Add 3 RRU', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-30', '', 'ericsson'),
('4010117105', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PAD610', 'Kalumbuk', 'PTI', 'LOI-3 2023_New Site 4G', 'Use RF Exist & Add 3 RRU', 3, 2, 3, 3, 2, 6, 0, 0, 0, '2023-06-23', '', 'ericsson'),
('4010117125', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', '2023 Capex 2 LOI#3', 'PBR338', 'E_PBR338_LanudTNIPekanbaru-KIN', 'PTI', 'EQP New Site 4G LTE 900 5 Mhz', 'Add RRU and Replace Antenna', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-21', '', 'ericsson'),
('4010117129', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', '2023 Capex 2 LOI#3', 'PBR876', 'E_PBR876_TamanKaryaUjung-KIN', 'PTI', 'EQP NEW NE 4G LTE 900 5 Mhz', 'Add RRU', 3, 0, 9, 3, 0, 12, 0, 0, 0, '2023-06-30', '', ''),
('4010117130', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', '2023 Capex 2 LOI#3', 'PBR879', 'E_PBR879_SidomulyoBarat4-PTI', 'PTI', 'EQP NEW NE 4G LTE 900 5 Mhz', 'Add 3 RF, Remove 3 RF, Add 3 RRU', 3, 0, 6, 3, 0, 9, 3, 0, 9, '2023-06-30', 'approve', 'ericsson'),
('4010117131', '0084/KKSTADD/Protelindo/Acti vity Non MPSL_CP2 RAF', '2023 Capex 2 LOI#3', 'PBR889', 'E_PBR889_LabuhBaru2-PTI', 'PTI', 'EQP New Site 4G LTE 900 5 Mhz', 'Add RRU and Replace Antenna', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-18', '', 'ericsson'),
('4010117167', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'TBK018', 'Perumahan Teluk Air (Masjid)', 'PTI', 'LOI-3 2023_New Site 4G', 'Swap 3 RF & Add 3 RRU', 3, 0, 6, 3, 0, 9, 0, 0, 0, '2023-06-26', '', 'ericsson'),
('4070088452', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN EXPLOIT UNTAPPED MARKET AND OPTIMIZING EXISTING NETWORK BATCH 3 2021', 'BTM166', 'HANGKATSURI', 'PTI', 'EQP 3G Site Dismantle', 'Dismantle Only', 6, 0, 5, 0, 0, 0, 0, 0, 0, '1900-01-01', '', 'ericsson'),
('4071249945', '0150/KKSTADD/Protelindo/CAPEX RAN 1 PART 2 2023/II', 'CAPEX RAN 1 PART 2 2023', 'TBH326', 'THIP Batang Tumu', 'PTI', 'Settlement#2 2023 - Upgrade 4G', 'Swap 2 RF & Remove 2 RRU, Add 4 RRU', 3, 1, 9, 3, 1, 11, 3, 1, 11, '2023-06-11', 'approve', 'ericsson'),
('4071255424', '0103/KKSTADD/EBT/CAPEX RAN 2 PART 1 2023/V/2023', 'CAPEX RAN 2 PART 1 2023', 'PKR939', 'Akasia Kerinci', 'EBT', 'LOI-2 2023_Upgrade 4G', 'Use RF Exist & Dismantle 1 RRU', 4, 1, 12, 4, 1, 11, 0, 0, 0, '2023-06-04', '', ''),
('4071256358', '0028/KKSTADD/EBT/CAPEX RAN 2 PART 1 2023/VI/2023', 'CAPEX RAN 2 PART 1 2023', 'BTM734', 'Brimob', 'EBT', 'LOI-3 2023_Upgrade 4G', 'Use RF Exist & Dismantle 3 RRU, Add 1 RRU', 3, 0, 13, 3, 0, 11, 0, 0, 0, '2023-06-27', '', ''),
('4071256637', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'BTM970', 'New Ahmad Yani', 'PTI', 'LOI-3 2023_Upgrade 4G', 'Use RF Exist & Dismantle 1 RRU', 4, 0, 12, 4, 0, 11, 4, 0, 11, '2023-06-14', 'approve', 'ericsson'),
('4071256668', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PAD089', 'Padang 68', 'PTI', 'LOI-3 2023_Upgrade 4G', 'Use RF Exist & Dismantle 2 RRU', 5, 1, 12, 5, 1, 10, 0, 0, 0, '2023-06-14', '', 'ericsson'),
('4071256679', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PAD588', 'Gajah Mada 2', 'PTI', 'LOI-3 2023_Upgrade 4G', 'Use RF Exist & Dismantle 1 RRU', 5, 1, 12, 5, 1, 11, 0, 0, 0, '2023-06-14', '', 'ericsson'),
('4071256682', '0020/KKSTADD/Protelindo/CAPEX RAN 2 PART 1 2023/VI', 'CAPEX RAN 2 PART 1 2023', 'PAP041', 'Kampung Teleng', 'PTI', 'LOI-3 2023_Upgrade 4G', 'Use RF Exist & Dismantle 1 RRU', 5, 2, 12, 5, 2, 11, 0, 0, 0, '2023-06-14', '', 'ericsson'),
('4098775444', '0100/KKSTADD/PROTELINDO/ACTIVITY NON MPSL/II/2023', 'TRM  Redeploy', 'BKG063', 'Tanjung Belit', 'PTI', 'TRM Redeploy', 'Add 1 MW', 3, 1, 7, 3, 2, 7, 0, 0, 0, '2023-05-15', '', 'ericsson');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `approve`
--
ALTER TABLE `approve`
  ADD PRIMARY KEY (`sow_id`);

--
-- Indeks untuk tabel `dataset`
--
ALTER TABLE `dataset`
  ADD PRIMARY KEY (`sow_id`);
COMMIT;

