   `createdat` datetime DEFAULT NULL,
   PRIMARY KEY (`productid`),
   UNIQUE KEY `barcode` (`barcode`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 
 --
 -- Dumping data for table `tbl_product`
 --
 
 INSERT INTO `tbl_product` (`productid`, `productname`, `productrate`, `productsize`, `barcode`, `categorytypeid`, `brandid`, `adminid`, `active`, `createdat`) VALUES
-(1, 'Test', '150', 'Xl', 'BAR1234', 1, 1, 2, 'active', '2016-07-31 00:00:00'),
-(2, 'Jeans', '1234', 'XXL', 'DSF23222', 1, 5, 2, 'active', '2016-08-05 00:44:53'),
-(3, 'paint', '450', 'M', 'PAN001', 1, 5, 2, 'active', '2016-08-12 22:24:36'),
-(4, 'T-Shirt', '350', 'XL', 'TSH001', 1, 4, 2, 'active', '2016-08-12 22:25:51'),
-(5, 'shirt-Mens', '450', 'L', 'SH002', 1, 3, 2, 'active', '2016-08-12 22:27:44'),
-(6, 'Jeans-Shirt', '850', 'L', 'JESH002', 1, 5, 2, 'active', '2016-08-12 22:29:07'),
-(7, 'Jeans-T-Shirt', '850', 'L', 'JTSH002', 1, 5, 2, 'active', '2016-08-12 22:29:07'),
-(8, 'shirt', '450', '2', 'HJAHS11', 1, 8, 2, 'active', '2016-08-19 00:35:43'),
-(9, 'bew_paint', '562', '3', 'FDSF111', 1, 0, 2, 'active', '2016-08-19 00:38:24'),
-(11, 'test', '3245', '3', 'qwqeqsa123', 1, 8, 2, 'active', '2016-08-22 23:47:39'),
-(12, 'tersa', '456', '2', 'fdffdffaz', 1, 8, 2, 'active', '2016-08-24 01:28:39'),
-(13, 'sample', '20', '35', 'ssdfdce', 1, 8, 2, 'active', '2016-08-28 16:17:08'),
-(14, 'samplegg', '10', '35', 'fdgfdgfdgf', 1, 7, 2, 'active', '2016-08-28 16:18:27'),
-(15, 'sample', '2345', '2', 'sdfsdf', 1, 7, 2, 'active', '2016-08-28 17:45:48'),
-(16, 'hgdhg', '100', '3', 'gg101', 1, 8, 2, 'active', '2016-08-29 21:20:44'),
-(18, 'mkm', '100', '2', 'gghjk', 1, 8, 2, 'active', '2016-08-29 21:33:42'),
-(19, 'shirtss', '12039', '3', '1233445', 1, 8, 2, 'active', '2016-08-29 21:36:02');
+(1, 'full hand shirt', '120', '3', 'full1001', 2, 2, 7, 'active', '2016-09-03 23:06:47');
 
 -- --------------------------------------------------------
 

  `qty` int(11) DEFAULT NULL,
  `discount` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `tbl_customerreceiptproduct`
--

INSERT INTO `tbl_customerreceiptproduct` (`id`, `receiptId`, `productId`, `showroomId`, `price`, `qty`, `discount`) VALUES
(6, 5, 1, NULL, 150, 1, 10),
(7, 5, 4, NULL, 350, 1, 10),
(8, 6, 1, NULL, 150, 1, 0),
(9, 7, 5, NULL, 450, 1, 0),
(10, 8, 4, NULL, 350, 2, 0),
(11, 8, 6, NULL, 850, 1, 0),
(12, 9, 2, NULL, 1234, 1, 5),
(13, 9, 4, NULL, 350, 1, 5);

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


  `adminId` int(11) DEFAULT NULL,
  `createAt` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_productMapping`
--

INSERT INTO `tbl_productMapping` (`id`, `productId`, `showroomId`, `price`, `quantity`, `adminId`, `createAt`) VALUES
(1, '1', 8, 130, 10, 7, '2016-09-03');

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

