 
 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),
+('101', 'MGPK101', 'MiP Northern Sumatera', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, NULL),
+('103', 'MGBT101', 'MiP Northern Sumatera', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, NULL),
+('107', 'MGMD301', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD3', NULL, 'in service', NULL, NULL),
+('108', 'MGAC101', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD3', NULL, 'in service', NULL, NULL),
+('109', 'MGBT102', 'MiP Northern Sumatera', 'SUMATERA', 'MSBT1', NULL, 'in service', NULL, NULL),
+('110', 'MGPK102', 'MiP Northern Sumatera', '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'),
+('115', 'MGMD302', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD3', NULL, 'in service', NULL, NULL),
+('117', 'MGMD401', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD4', NULL, 'in service', NULL, NULL),
+('119', 'MGPB401', 'MiP Southern Sumatera', 'SUMATERA', 'MSPB4', NULL, 'in service', NULL, 'GCP Cutover from MSPB2 to MSPB3'),
+('120', 'MGPB402', 'MiP Southern Sumatera', 'SUMATERA', 'MSPB4', NULL, 'in service', NULL, NULL),
+('121', 'MGJB201', 'MiP Southern Sumatera', 'SUMATERA', 'MSJB2', NULL, 'in service', NULL, NULL),
+('122', 'MGBK201', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('123', 'MGBB201', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('124', 'MGLP202', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('125', 'MGLK102', 'MiP Southern Sumatera', 'SUMATERA', 'MSJB2', NULL, 'in service', NULL, NULL),
+('126', 'MGLP201', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('127', 'MGMD402', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD4', NULL, 'in service', NULL, NULL),
+('128', 'MGMD501', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD5', NULL, 'in service', NULL, NULL),
+('130', 'MGMD502', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD5', NULL, 'in service', NULL, NULL),
+('131', 'MGMD201', 'MiP Northern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, 'vmgw BMDN7A to MSPD1'),
+('132', 'MGPK201', 'MiP Northern Sumatera', 'SUMATERA', 'MSPK2', NULL, 'in service', NULL, NULL),
+('134', 'MGBB202', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('135', 'MGPB502', 'MiP Southern Sumatera', 'SUMATERA', 'Pool', NULL, 'in service', NULL, NULL),
+('136', 'MGMD601', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD6', NULL, 'in service', NULL, NULL),
+('138', 'MGMD601', 'MiP Northern Sumatera', 'SUMATERA', 'MSMD7', NULL, 'in service', NULL, NULL),
+('139', 'MGPK202', 'MiP Northern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('140', 'MGPB601', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('141', 'MGPB602', 'MiP Southern Sumatera', 'SUMATERA', 'Pool', NULL, 'in service', NULL, NULL),
+('151', 'MGPK102', 'MiP Northern Sumatera', 'SUMATERA', 'MSPK1', NULL, 'in service', NULL, 'new BCUID for Virtual MGW to PSTN'),
+('152', 'MGMD201', 'MiP Northern Sumatera', 'SUMATERA', NULL, 'MSMD2', 'in service', NULL, 'Cutover GCP from MSPK1 to MSMD2'),
+('154', 'MGBT102', 'MiP Northern Sumatera', '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),
+('157', 'MGAC102', 'MiP Northern Sumatera', 'SUMATERA', NULL, 'MSAC1', 'in service', NULL, 'PLAN: Cutover GCP from MSMD3 to MSAC1'),
+('158', 'MGLK102', 'MiP Southern Sumatera', 'SUMATERA', 'MSJB1', 'MSPD1', 'in service', NULL, 'TEMP: Cutover GCP from MSJB1 to MSPD1'),
+('159', 'MGPB501', 'MiP Southern Sumatera', 'SUMATERA', 'MSPB5', NULL, 'in service', NULL, NULL),
+('160', 'MGLP401', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('161', 'MGLP402', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('162', 'MGJB202', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('170', 'MGPD301', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('171', 'MGPD302', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('172', 'MGMD201', 'MiP Northern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, 'MSAC1'),
+('173', 'MGAC102', 'MiP Northern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('174', 'MGPD401', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('175', 'MGBB301', 'MiP Southern Sumatera', 'SUMATERA', NULL, NULL, 'in service', NULL, NULL),
+('176', 'MGMD602', 'MiP Northern Sumatera', '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', ''),


INSERT INTO `msc` (`msc_name`, `cnid`, `pool`, `non_broadcast_lai`, `null_nri`, `nri_msc`, `spc_msc`, `cap_value`, `nb_lai`, `msc_index`, `msc_IP_sigtran1`, `msc_IP_sigtran2`, `mgw_proxyA_flex`, `mgw_managerA_circuit`, `status`, `log_date`, `remark`) VALUES
('MSAB1', '1601', 'MPP Amkupapua', NULL, '1', '28', '9393', 1000, '510110007', 1, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(inhibit from pool)'),
('MSAC1', '1708', 'MiP Sum1/2', NULL, NULL, '33', '9274', 50, '510-11-00009', NULL, '121.52.39.9 & 121.52.39.25', '121.52.39.10 & 121.52.39.26', NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSAC2', '1014', 'MiP Northern Sumatera', NULL, '0', '44', '9974', 1000, NULL, 4, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, '*enable MPP, to support BSC TDM does not support A-Flex'),
('MSB10', '1281', 'MiP East Java', NULL, NULL, '3', '9936', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSB11', '1282', 'MiP East Java', NULL, NULL, '31-32', '7384', 240, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSB12', '1283', 'MiP East Java', NULL, NULL, '33-34', '7454', 240, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSBB2', '1001', 'MiP Sum3/4', '510110005', '1', '56', '9450', 0, NULL, 4, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSBD2', '1230', 'MiP West Java', NULL, NULL, '26', '9106', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSBD4', '1231', 'MiP West Java', NULL, NULL, '27', '9140', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSBD5', '1232', 'MiP West Java', NULL, NULL, '28', '9233', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),

('MSJ28', '1116', 'MiP Jabodetabek', NULL, NULL, '23-24', '7317', 240, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSJ29', '1117', 'MiP Jabodetabek', NULL, NULL, '10,16', '7458', 240, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSJ30', '1118', 'MiP Jabodetabek', NULL, NULL, '25,35', '7462', 240, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSJB2', '1004', 'MiP Southern Sumatera', '510110004', '1', '53', '9370', 0, NULL, 1, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSJE1', '1273', 'MiP East Java', NULL, NULL, '49', '9311', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSJK5', '1100', 'Test Bed', NULL, '', '15', '9101', 60, '', NULL, '', '', 'Yes', 'Yes', 'In Service', '2015-07-08', ''),
('MSJK8', '1102', 'MiP Jabodetabek', NULL, NULL, '4', '9131', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
