 -- Table structure for table `ng_detail`
 --
 
-DROP TABLE IF EXISTS `ng_detail`;
 CREATE TABLE IF NOT EXISTS `ng_detail` (
-  `id` varchar(10) NOT NULL,
   `ng_item_id` varchar(10) NOT NULL,
   `ng_sub_date` date DEFAULT NULL,
   `ng_result` text,

-- Table structure for table `lg_customer`
--

DROP TABLE IF EXISTS `lg_customer`;
CREATE TABLE IF NOT EXISTS `lg_customer` (
  `id` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(50) DEFAULT NULL,

INSERT INTO `master_group` (`group_code`, `group_name`) VALUES
('SQA', 'Staff OQA'),
('INC', 'Staff Incoming'),
('OQA', 'Operator OQA');

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

