 ('ASPAM INTERNATIONAL CIBITUNG 01', '628184422894', 'CIBITUNG', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', 'Bintar/Yati'),
 ('ASPAM INTERNATIONAL CIBITUNG 02', '628184422895', 'CIBITUNG', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', 'Bintar/Yati'),
 ('ASPAM INTERNATIONAL CIBITUNG VGT', '628184422896', 'CIBITUNG', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', 'Bintar/Yati'),
+('BASH2', NULL, 'HUT Kisaran', 'Sulawesi Selatan', 'Not Set', NULL, 'In Service', NULL, NULL),
 ('BAYR1', NULL, 'HUT Anyer', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
 ('BAYR2', NULL, 'HUT Anyer', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
 ('BAYR3', NULL, 'HUT Cilegon', 'Jawa Barat', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
+('BBBL6', NULL, 'HUT Bangka Belitung', 'Kep. Bangka Belitung', 'Not Set', NULL, 'In Service', '2015-07-31', ''),
+('BBDG10', NULL, '(not set)', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG11', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG12', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG13', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG14', NULL, 'HUT Kiara Condong', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG15', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG16', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG17', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG18', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG19', NULL, 'HUT Padalarang Kota', 'Jawa Barat', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBDG3', NULL, 'XL Purnawarman', 'Jawa Barat', 'Not Set', NULL, 'In Service', '2015-07-31', ''),
+('BBDG4', NULL, 'XL Purnawarman', 'Jawa Barat', 'Not Set', NULL, 'In Service', '2015-07-31', ''),
+('BBDG5', NULL, 'HUT Kiara Condong', 'Jawa Barat', 'Not Set', NULL, 'In Service', '2015-07-31', ''),
+('BBDG9', NULL, 'BNB', 'Jawa Barat', 'Not Set', NULL, 'In Service', '2015-07-31', ''),
+('BBDN01', NULL, '(not set)', 'Lain-lain', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBGN03', NULL, 'HUT Budaggan', 'Jawa Timur', 'Not Set', NULL, 'In Service', NULL, NULL),
+('BBGN04', NULL, 'HUT Budaggan', 'Jawa Timur', 'Not Set', NULL, 'In Service', NULL, NULL),
 ('BBGR07', NULL, 'HUT Sukasari', 'DKI Jakarta', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
 ('BBGR08', NULL, 'Supernode Sukasari', 'DKI Jakarta', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
 ('BBGR2', NULL, 'HUT Kedung Jaya', 'DKI Jakarta', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),


INSERT INTO `mgw` (`bcu_id`, `mgw_name`, `pool`, `region`, `old_mss_connected`, `new_mss_connected`, `status`, `log_date`, `remark`) VALUES
('000', 'MGJ2002', 'Transit', 'Cibitung', '', '', 'In Service', '2015-07-10', ''),
('101', 'MGPK101', 'MiP Sum1/2', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, NULL),
('103', 'MGBT101', 'MiP Sum1/2', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, NULL),
('107', 'MGMD301', 'MiP Sum1/2', 'SUMATERA', 'MSMD3', NULL, 'in service', NULL, NULL),
('108', 'MGAC101', 'MiP Sum1/2', 'SUMATERA', 'MSMD3', NULL, 'in service', NULL, NULL),
('109', 'MGBT102', 'MiP Sum1/2', 'SUMATERA', 'MSBT1', NULL, 'in service', NULL, NULL),
('110', 'MGPK102', 'MiP Sum1/2', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, NULL),
('111', 'MGBB101', '', 'SUMATERA', 'MSJB1', '', 'in service', '0000-00-00', ''),
('113', 'MGBK101', '', 'SUMATERA', 'MSBK1', '', 'in service', '0000-00-00', ''),
('115', 'MGMD302', 'MiP Sum1/2', 'SUMATERA', 'MSMD3', NULL, 'in service', NULL, NULL),
('117', 'MGMD401', 'MiP Sum1/2', 'SUMATERA', 'MSMD4', NULL, 'in service', NULL, NULL),
('119', 'MGPB401', 'MiP Sum3/4', 'SUMATERA', 'MSPB4', NULL, 'in service', NULL, 'GCP Cutover from MSPB2 to MSPB3'),
('120', 'MGPB402', 'MiP Sum3/4', 'SUMATERA', 'MSPB4', NULL, 'in service', NULL, NULL),
('121', 'MGJB201', 'MiP Sum3/4', 'SUMATERA', 'MSJB2', NULL, 'in service', NULL, NULL),
('122', 'MGBK201', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('123', 'MGBB201', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('124', 'MGLP202', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('125', 'MGLK102', 'MiP Sum3/4', 'SUMATERA', 'MSJB2', NULL, 'in service', NULL, NULL),
('126', 'MGLP201', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('127', 'MGMD402', 'MiP Sum1/2', 'SUMATERA', 'MSMD4', NULL, 'in service', NULL, NULL),
('128', 'MGMD501', 'MiP Sum1/2', 'SUMATERA', 'MSMD5', NULL, 'in service', NULL, NULL),
('130', 'MGMD502', 'MiP Sum1/2', 'SUMATERA', 'MSMD5', NULL, 'in service', NULL, NULL),
('131', 'MGMD201', 'MiP Sum1/2', 'SUMATERA', NULL, NULL, 'in service', NULL, 'vmgw BMDN7A to MSPD1'),
('132', 'MGPK201', 'MiP Sum1/2', 'SUMATERA', 'MSPK2', NULL, 'in service', NULL, NULL),
('134', 'MGBB202', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('135', 'MGPB502', 'MiP Sum3/4', 'SUMATERA', 'Pool', NULL, 'in service', NULL, NULL),
('136', 'MGMD601', 'MiP Sum1/2', 'SUMATERA', 'MSMD6', NULL, 'in service', NULL, NULL),
('138', 'MGMD601', 'MiP Sum1/2', 'SUMATERA', 'MSMD7', NULL, 'in service', NULL, NULL),
('139', 'MGPK202', 'MiP Sum1/2', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('140', 'MGPB601', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('141', 'MGPB602', 'MiP Sum3/4', 'SUMATERA', 'Pool', NULL, 'in service', NULL, NULL),
('151', 'MGPK102', 'MiP Sum1/2', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, 'new BCUID for Virtual MGW to PSTN'),
('152', 'MGMD201', 'MiP Sum1/2', 'SUMATERA', NULL, 'MSMD2', 'in service', NULL, 'Cutover GCP from MSPK1 to MSMD2'),
('154', 'MGBT102', 'MiP Sum1/2', 'SUMATERA', NULL, 'MSBT1', 'in service', NULL, 'PLAN: Cutover GCP from MSPK1 to MSBT1'),
('155', 'MGJB102', '', 'SUMATERA', '', 'MSJB1', 'in service', '0000-00-00', 'done : Cutover GCP from MSPB2 to MSJB1'),
('156', 'MGBB101', '', 'SUMATERA', '', 'new MSBB1', '', '0000-00-00', 'PLAN: Cutover GCP MSJB1 to MSBB1'),
('157', 'MGAC102', 'MiP Sum1/2', 'SUMATERA', NULL, 'MSAC1', 'in service', NULL, 'PLAN: Cutover GCP from MSMD3 to MSAC1'),
('158', 'MGLK102', 'MiP Sum3/4', 'SUMATERA', 'MSJB1', 'MSPD1', 'in service', NULL, 'TEMP: Cutover GCP from MSJB1 to MSPD1'),
('159', 'MGPB501', 'MiP Sum3/4', 'SUMATERA', 'MSPB5', NULL, 'in service', NULL, NULL),
('160', 'MGLP401', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('161', 'MGLP402', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('162', 'MGJB202', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('170', 'MGPD301', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('171', 'MGPD302', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('172', 'MGMD201', 'MiP Sum1/2', 'SUMATERA', NULL, NULL, 'in service', NULL, 'MSAC1'),
('173', 'MGAC102', 'MiP Sum1/2', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('174', 'MGPD401', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('175', 'MGBB301', 'MiP Sum3/4', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('176', 'MGMD602', 'MiP Sum1/2', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
('1901', 'MGJ1901', 'Transit', 'Bintaro', '', '', 'In Service', '2015-07-10', ''),
('1902', 'MGJ1902', 'Transit', 'Bintaro', '', '', 'In Service', '2015-07-10', ''),
('2001', 'MGJ2001', 'Transit', 'Cibitung', '', '', 'In Service', '2015-07-10', ''),

('SGSN HUAWEI#5', '62818449020', 'BALIKPAPAN', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', '(for Iu Int''face)'),
('SGSN HUAWEI#6', '62818441210', 'JAMBI', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', NULL),
('SGSN HUAWEI#7', '62818441211', 'PEKANBARU', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', NULL),
('SGSN HUAWEI#8', '628184420602', 'MEDAN', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', NULL),
('SGSN HUAWEI#9', '628184421602', 'PALEMBANG', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', NULL),
('SIGOS C7 LU', 'SS7 LU 1', 'graha XL', 'not set', 'Not Set', NULL, 'In Service', NULL, 'I/OWGBLU - MGJK601'),
('SIGOS C7 LU 2', 'SS7 LU 2', 'not set', 'not set', 'Not Set', NULL, 'In Service', NULL, 'I/OWGTXW - MGJK601'),
