   PRIMARY KEY (`id`),
   KEY `image_id` (`image_id`,`username`),
   KEY `user_id` (`username`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
 
 --
 -- Dumping data for table `news`
 --
 
 INSERT INTO `news` (`id`, `title`, `news_desc`, `image_id`, `username`, `timestamp`) VALUES
-(3, 'Tes 2', 'Lorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.', 59, 'admin', '2015-07-14 03:51:42'),
-(4, 'tes lagi', 'asdasdad', 31, 'admin', '2015-07-14 04:15:50'),
-(5, 'tes 4', 'asdasdasd', NULL, 'admin', '2015-07-14 04:43:28'),
-(12, 'TES', 'Lorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.', 57, 'admin', '2015-07-28 06:22:52');
+(3, 'Tes 2', 'Lorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.', 70, 'admin', '2015-07-14 03:51:42'),
+(4, 'Tes 3', 'Lorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.', 72, 'admin', '2015-07-14 04:15:50'),
+(5, 'Tes 4', 'Lorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.', 74, 'admin', '2015-07-14 04:43:28'),
+(12, 'Tes 1', 'Lorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.\r\nLorem ipsum dolor sit amet.', 76, 'admin', '2015-07-28 06:22:52');
 
 -- --------------------------------------------------------
 

('MSKI1', '1271', 'MiP East Java', NULL, NULL, '47', '9340', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSKI2', '1272', 'MiP East Java', NULL, NULL, '48', '9527', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSKU2', '1603', 'MPP Amkupapua', NULL, '1', '30', '9399', 1000, '510110007', 0, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(inhibit from pool)'),
('MSLP2', '1000', 'MiP Sum3/4', '510110006', '1', '57', '9188', 0, NULL, 5, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSLP4', '1007', 'MiP Sum3/4', '510110009', '1', '60', '9478', 0, NULL, 8, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSLP5', '1008', 'MiP Sum3/4', NULL, NULL, '61', '9760', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSMD2', '1704', 'MiP Sum1/2', NULL, NULL, '28', '9155', 50, '510-11-00005', NULL, '121.52.113.139 & 121.52.113.171', '121.52.113.140 & 121.52.113.172', NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSMD3', '1705', 'MiP Sum1/2', NULL, NULL, '29', '9250', 50, '510-11-00006', NULL, '121.52.126.73 & 121.52.126.89', '121.52.126.74 & 121.52.126.90', NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSMD4', '1706', 'MiP Sum1/2', NULL, NULL, '30', '9454', 50, '510-11-00007', NULL, '121.52.9.201 & 121.52.9.217', '121.52.9.202 & 121.52.9.218', NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSMD5', '1707', 'MiP Sum1/2', NULL, NULL, '31', '9565', 200, '510-11-00008', NULL, '112.215.32.195 & 112.215.32.211', '112.215.32.196 & 112.215.32.212', NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSMD6', '1709', 'MiP Sum1/2', NULL, NULL, '34', '9764', 200, '510-11-00010', NULL, '112.215.55.3 & 112.215.55.19', '112.215.55.4 & 112.215.55.20', NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSMD7', '1710', 'MiP Sum1/2', NULL, NULL, '47', '9855', 200, '510-11-00011', NULL, '112.215.55.67 & 112.215.55.83', '112.215.55.68 & 112.215.55.84', NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSMD8', '1011', 'MiP Northern Sumatera', NULL, '0', '41', '9968', 1000, NULL, 1, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, '*enable MPP, to support BSC TDM does not support A-Flex'),
('MSMK3', '1501', 'MPP Sulawesi', NULL, '1', '24', '9382', 1000, '510110001', 0, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(inhibit from pool)'),
('MSML1', '1274', 'MiP East Java', NULL, NULL, '50', '9211', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSMO2', '1504', 'MPP Sulawesi', NULL, '1', '34', '9389', 1000, '510110004', 3, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, '(inhibit from pool)'),
('MSPA1', '1276', 'MiP East Java', NULL, NULL, '52', '9426', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSPB4', '1003', 'MiP Sum3/4', '510110002', '1', '54', '9374', 0, NULL, 2, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSPB5', '1005', 'MiP Sum3/4', '510110007', '1', '58', '9458', 0, NULL, 6, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSPB6', '1009', 'MiP Sum3/4', NULL, NULL, '62', '9778', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSPD3', '1006', 'MiP Sum3/4', '510110008', '1', '59', '9461', 0, NULL, 7, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, NULL),
('MSPK1', '1701', 'MiP Sum1/2', NULL, NULL, '46', '9121', 50, '510-11-00002', NULL, '121.52.112.139 & 121.52.112.171', '121.52.112.140 & 121.52.112.172', NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSPK2', '1702', 'MiP Sum1/2', NULL, NULL, '49', '9554', 200, '510-11-00003', NULL, '112.215.38.3 & 112.215.38.19', '112.215.38.4 & 112.215.38.20', NULL, NULL, 'IN SERVICE', NULL, '(BC)'),
('MSPK3', '1703', 'MiP Sum1/2', NULL, NULL, '51', '9770', 50, '510-11-00004', NULL, '121.52.112.142 & 121.52.112.174', '121.52.112.143 & 121.52.112.175', NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSPK4', '1013', 'MiP Northern Sumatera', NULL, '0', '43', '9972', 1000, NULL, 3, NULL, NULL, 'Yes', 'Yes', 'IN SERVICE', NULL, '*enable MPP, to support BSC TDM does not support A-Flex'),
('MSPL1', '1206', 'MiP Center Java', NULL, NULL, '40', '9208', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),
('MSPO1', '1208', 'MiP Center Java', NULL, NULL, '42', '9404', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'IN SERVICE', NULL, NULL),


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 Northern Sumatera', 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 Southern Sumatera', '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),
