 -- Table structure for table `master_group`
 --
 
-DROP TABLE IF EXISTS `master_group`;
 CREATE TABLE IF NOT EXISTS `master_group` (
   `group_code` varchar(3) DEFAULT NULL,
   `group_name` varchar(50) DEFAULT NULL

-- 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,

--

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');

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

