 -- Table structure for table `ng_items`
 --
 
-DROP TABLE IF EXISTS `ng_items`;
 CREATE TABLE IF NOT EXISTS `ng_items` (
   `id` varchar(10) NOT NULL DEFAULT '',
   `cust_id` varchar(10) DEFAULT NULL,

  `sp_employee_id` varchar(10) DEFAULT NULL,
  `sp_inspector_id` varchar(10) DEFAULT NULL,
  `sp_file_name` varchar(50) DEFAULT NULL,
  `in_sub_date` date DEFAULT NULL,
  `in_cipl` varchar(10) DEFAULT NULL,
  `in_staff` varchar(10) DEFAULT NULL,
  `out_sub_date` date DEFAULT NULL,
  `out_file_name` varchar(50) DEFAULT NULL,
  `out_description` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

INSERT INTO `ng_detail` (`id`, `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`, `in_sub_date`, `in_cipl`, `in_staff`, `out_sub_date`, `out_file_name`, `out_description`) VALUES
('DTL1601', '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, NULL),
('DTL1602', '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, NULL);

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


--

INSERT INTO `ng_incoming` (`id`, `date`, `cust_id`, `empl_id`, `part_no`, `no_cipl`, `no_awb`) VALUES
('INC1601', '2016-06-04', 'CUS1606', 'EMP16036', 'WF1', '111111', '222222'),
('INC1602', '2016-06-04', 'CUS1608', 'EMP16036', 'WF3', '212121', '33333'),
('INC1603', '2016-06-04', 'CUS1606', 'EMP16036', 'WF1', '12121211', '454545454'),
('INC1606', '2016-06-08', 'CUS16010', 'EMP16036', 'WF2', '1092381098', '9082038012');

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

