   `active` varchar(200) DEFAULT 'active',
   `createdAt` date DEFAULT NULL,
   PRIMARY KEY (`sizeid`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
 
 --
 -- Dumping data for table `tbl_sizemaster`
 --
 
 INSERT INTO `tbl_sizemaster` (`sizeid`, `size`, `adminId`, `active`, `createdAt`) VALUES
-(1, 'XL', 2, 'active', '2016-08-18'),
-(2, 'XXL', 2, 'active', '2016-08-19'),
-(3, 'L', 2, 'active', '2016-08-19'),
-(4, '', 2, 'deleted', '2016-08-24'),
-(5, '3', 39, 'deleted', '2016-08-28'),
-(6, '5', 39, 'deleted', '2016-08-28'),
-(7, '1234', 39, 'active', '2016-08-28'),
-(8, '545', 39, 'active', '2016-08-28');
+(1, 'XL', 7, 'active', '2016-09-03'),
+(2, 'S', 7, 'active', '2016-09-03'),
+(3, 'L', 7, 'active', '2016-09-03');
 
 -- --------------------------------------------------------
 

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 31, 2016 at 11:24 PM
-- Server version: 5.5.49-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.17


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

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

INSERT INTO `tbl_categorytype` (`categorytypeid`, `categorytype`, `adminId`, `active`, `createdAt`) VALUES
(1, 'Pant', 7, 'active', '2016-09-03'),
(2, 'Shirt', 7, 'active', '2016-09-03'),
(3, 'underwear', 7, 'active', '2016-09-03'),
(4, 'test', 7, 'deleted', '2016-09-03');

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

