 --
 
 INSERT INTO `lg_employee` (`id`, `name`, `email`, `password`, `group`, `telp`) VALUES
-('admin', 'admin', 'isnaini592@gmail.com', '21232f297a57a5a743894a0e4a801fc3', '0', '123131'),
-('EMP16028', 'Tsubasa Ozora', 'aklfjalkj@kalfjal', NULL, 'INS', '1093103'),
+('admin', 'admin', 'isnaini592@gmail.com', '21232f297a57a5a743894a0e4a801fc3', 'ADM', '123131'),
+('EMP16028', 'Tsubasa Ozora', 'aklfjalkj@kalfjal', '21232f297a57a5a743894a0e4a801fc3', 'SQA', '1093103'),
 ('EMP16030', 'Sukoco', 'isnaini592@gmail.com', NULL, 'OQA', '1212121212'),
 ('EMP16031', 'Bang Jack', 'email@asep.com', NULL, 'OQA', '98080'),
 ('EMP16033', 'Inspector Gadget', 'email@asep.com', NULL, 'INS', '232323'),
 ('EMP16034', 'Asep Gumasep', 'email@asep.com', 'd41d8cd98f00b204e9800998ecf8427e', 'INS', '1212121'),
-('EMP16036', 'Joko', 'isnaini592@gmail.com', '4504f64ca186c8b5cc1d3fa0af1e160c', 'OQA', '123131'),
-('EMP16037', 'Denti', 'isnaini592@gmail.com', '74ee55083a714aa3791f8d594fea00c9', 'INC', '1212121212');
+('EMP16036', 'Joko', 'isnaini592@gmail.com', '21232f297a57a5a743894a0e4a801fc3', 'OQA', '123131'),
+('EMP16037', 'Denti', 'isnaini592@gmail.com', '21232f297a57a5a743894a0e4a801fc3', 'INC', '1212121212');
 
 -- --------------------------------------------------------
 

--

INSERT INTO `lg_customer` (`id`, `name`, `address`, `email`, `telp`, `contact_person`, `password`) VALUES
('CUS1606', 'Maman', 'jl akjfsjflsjl', 'alul.cholil@yahoo.com', '908080', 'kajflajl', '4504f64ca186c8b5cc1d3fa0af1e160c'),
('CUS1608', 'LGEIN', 'jl lg eim', 'lgein@gmail.com', NULL, 'maman', '74ee55083a714aa3791f8d594fea00c9');

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


  `sp_employee_id` varchar(10) DEFAULT NULL,
  `sp_inspector_id` varchar(10) DEFAULT NULL,
  `sp_file_name` varchar(50) DEFAULT NULL,
  `spr_sub_date` date DEFAULT NULL,
  `spr_result` text,
  `out_sub_date` date DEFAULT NULL,
  `out_file_name` varchar(50) DEFAULT NULL,
  `out_description` text,
  PRIMARY KEY (`ng_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `ng_detail`
--

INSERT INTO `ng_detail` (`ng_item_id`, `ng_sub_date`, `ng_result`, `ng_file_name`, `ca_description`, `ca_sub_date`, `ca_file_name`, `car_sub_date`, `car_file_name`, `car_description`, `sp_sub_date`, `sp_employee_id`, `sp_inspector_id`, `sp_file_name`, `spr_sub_date`, `spr_result`, `out_sub_date`, `out_file_name`, `out_description`) VALUES
('NGI16010', '2016-06-09', 'nah ini dia', '01_detail_kedatangan_ngi16010.xls', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('NGI16011', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('NGI1605', '2016-06-07', 'done progress1', '01_detail_kedatangan_ngi1605.xls', 'done dua', '2016-06-07', '02_cipl_cust_ngi1605.pdf', '2016-06-07', '03_car_ngi1605.ppt', 'done progress 2', '2016-06-07', 'EMP16030', 'EMP16028', NULL, NULL, NULL, NULL, NULL, NULL),
('NGI1606', '2016-06-02', 'oke', 'asoy.pdf', 'ini udah d', '2016-06-07', 'cipl_cust_ngi1606.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('NGI1607', '2016-06-08', 'pretamax', '01_detail_kedatangan_ngi1607.xls', 'keduax', '2016-06-08', '02_cipl_cust_ngi1607.pdf', NULL, NULL, NULL, NULL, NULL, NULL, '', '0000-00-00', '', NULL, NULL, NULL),
('NGI1608', '2016-06-08', 'ini upload pertamax', '01_detail_kedatangan_ngi1608.pdf', 'proses kedua', '2016-06-08', '02_cipl_cust_ngi1608.xls', '2016-06-08', '03_car_ngi1608.pdf', 'proses ketiga', '2016-06-08', 'EMP16030', 'EMP16028', 'resultanalisa_ngi1608.xls', '2016-06-08', 'sadadada', '2016-06-08', '04_pengiriman_ngi1608.xls', 'ini coy'),
('NGI1609', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

