   `adminId` int(11) DEFAULT NULL,
   `createAt` date DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+) 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, '19', 35, 12039, 10, 2, '2016-08-29'),
-(2, '19', 32, 12039, 20, 2, '2016-08-29');
+(1, '1', 8, 130, 10, 7, '2016-09-03');
 
 -- --------------------------------------------------------
 

  `active` varchar(200) DEFAULT 'active',
  `createdAt` date DEFAULT NULL,
  PRIMARY KEY (`categorytypeid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tbl_categorytype`
--

INSERT INTO `tbl_categorytype` (`categorytypeid`, `categorytype`, `adminId`, `active`, `createdAt`) VALUES
(1, 'hghgf', 2, 'active', '2016-08-18'),
(2, 'XXL', 2, 'active', '2016-08-19'),
(3, 'L', 2, 'deleted', '2016-08-19'),
(4, '', 2, 'deleted', '2016-08-24'),
(5, '3', 39, 'deleted', '2016-08-28'),
(6, 'ghfhgf', 39, 'deleted', '2016-08-28'),
(7, '1234', 39, 'active', '2016-08-28'),
(8, '545', 39, 'active', '2016-08-28'),
(9, 'ttyyyuuuuu', 2, 'deleted', '2016-08-31'),
(10, 'hffgfdssssssss', 2, 'deleted', '2016-08-31'),
(11, 'css2', 2, 'deleted', '2016-08-31');

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


  `lastlogin` datetime DEFAULT NULL,
  `createdat` datetime DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`userid`, `name`, `email`, `password`, `usertypeid`, `adminid`, `retailerShowRoomId`, `mobile`, `address`, `doj`, `dob`, `active`, `lastlogin`, `createdat`) VALUES
(1, 'superadmin', 'superadmin@gmail.com', '1234', 1, 0, 0, '8344798628', '107, west street, Ammaiyappan, Thiruvarur.', '0000-00-00', '0000-00-00', 'active', '2016-09-05 08:09:44', NULL),
(2, 'mathan', 'mathanaiht@gmail.com', '1234', 2, 0, 0, '83446576575', 'ddsdsfsadfd ddf dsfsafasd', '0000-00-00', '0000-00-00', 'active', NULL, '2016-09-03 14:07:25'),
(3, 'mathansr', 'mathansr@gmail.com', NULL, 3, 2, 0, '656575656575', 'dsihjdfh jhdfjhds hdsfdhj dfjhjdsfh', '0000-00-00', '0000-00-00', 'active', NULL, '2016-09-03 14:08:51'),
(4, 'mathash', 'mathash@gmail.com', '1234', 4, 2, 3, '6576565765', 'dsfdsagdsgdsfg', '2016-09-08', '2016-09-10', 'active', NULL, '2016-09-03 20:08:45'),
(5, 'mathanse', 'mathanse@gmail.com', '1234', 5, 2, 3, '6565656756', 'fgfgfgfhg fgfg gfgf tytytytyuyiyy', '2016-09-07', '2016-09-14', 'active', NULL, '2016-09-03 20:11:19'),
(6, 'mathanse1', 'mathanse1@gmail.com', '12345', 5, 2, 3, '56454545456', 'ok', '2016-09-01', '2016-09-07', 'active', NULL, '2016-09-03 20:14:58'),
(7, 'manoj', 'manoj@gmail.com', '1234', 2, 0, 0, '56756567', 'chennai', '2016-09-20', '2016-09-23', 'active', '2016-09-05 17:09:22', '2016-09-03 21:23:33'),
(8, 'manojsr', 'manojsr@gmail.com', NULL, 3, 7, 0, '6567576', 'jkdhsfj jhgdj', '0000-00-00', '0000-00-00', 'active', NULL, '2016-09-03 21:25:45'),
(9, 'manojsh', 'manojsh@gmail.com', '1234', 4, 7, 8, '656575656757', 'yes', '2016-09-09', '2016-09-10', 'active', '2016-09-03 23:09:44', '2016-09-03 21:27:36'),
(10, 'manojse', 'manojse@gmail.com', '1234', 5, 7, 8, '6567565656567', 'success', '2016-09-15', '2016-09-16', 'active', NULL, '2016-09-03 21:28:52');

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

