 
 /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_orderlistbyorderno` AS (select `o`.`OrderNo` AS `OrderNo`,concat(`i`.`ItemNo`,'-',`iv`.`VariantNo`) AS `ItemNumber`,concat(`i`.`Name`,'<br/>',`iv`.`VariantName`) AS `ItemDescription`,`o`.`Quantity` AS `Quantity`,`iv`.`Price` AS `Price`,(`o`.`Quantity` * `iv`.`Price`) AS `Total` from ((`orderlist` `o` join `item` `i` on((`o`.`ItemNo` = `i`.`ItemNo`))) join `itemvariant` `iv` on((`o`.`VariantNo` = `iv`.`VariantNo`)))) */;
 
+/*View structure for view vw_printsallitems */
+
+/*!50001 DROP TABLE IF EXISTS `vw_printsallitems` */;
+/*!50001 DROP VIEW IF EXISTS `vw_printsallitems` */;
+
+/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_printsallitems` AS (select concat(`i`.`ItemNo`,'-',`iv`.`VariantNo`) AS `ItemNo`,`i`.`Name` AS `Name`,`iv`.`VariantName` AS `VariantName`,`i`.`UOM` AS `UOM`,ifnull(`iv`.`Stocks`,0) AS `Stocks`,`l1`.`Name1` AS `FamilyName`,ifnull(`l2`.`Name2`,'-') AS `Category`,ifnull(`l3`.`Name3`,'-') AS `SubCategory` from ((((`itemvariant` `iv` join `item` `i` on((`iv`.`ItemNo` = `i`.`ItemNo`))) join `level1` `l1` on((`l1`.`Level1No` = `i`.`Level1No`))) left join `level2` `l2` on((`l2`.`Level2No` = `i`.`Level2No`))) left join `level3` `l3` on((`l3`.`Level3No` = `i`.`Level3No`))) where ((`iv`.`Owned` = 1) and ((`iv`.`Removed` = 0) or isnull(`iv`.`Removed`)) and ((`i`.`Removed` = 0) or isnull(`i`.`Removed`)))) */;
+
 /*View structure for view vw_receivings */
 
 /*!50001 DROP TABLE IF EXISTS `vw_receivings` */;

  `Description` text,
  `ImageFile` text,
  PRIMARY KEY (`Level1No`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

/*Data for the table `level1` */

insert  into `level1`(`Level1No`,`Name1`,`Description`,`ImageFile`) values (26,'Building Materials',NULL,NULL),(27,'Door',NULL,NULL),(28,'Electrical',NULL,NULL),(29,'Hardware',NULL,NULL);

/*Table structure for table `level2` */


  `TransactionDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `ModifiedBy` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=288 DEFAULT CHARSET=latin1;

/*Data for the table `tblauditlogs` */

insert  into `tblauditlogs`(`ID`,`Transaction`,`Action`,`TransactionDate`,`ModifiedBy`) values (1,'Update Family','Update','2016-11-25 18:34:29','Rolen'),(2,'Purchase Order','Insert','2016-11-25 18:57:43','Rolen'),(3,'New Family','Insert','2016-11-25 21:32:45','Rolen'),(4,'New Family','Insert','2016-11-25 21:35:24','Rolen'),(5,'New Category','Insert','2016-11-25 21:36:20','Rolen'),(6,'New Category','Insert','2016-11-25 21:41:01','Rolen'),(7,'New Sub-Category','Insert','2016-11-25 21:41:15','Rolen'),(8,'Update Category','Update','2016-11-25 21:49:10','Rolen'),(9,'Update Sub-Category','Update','2016-11-25 21:49:17','Rolen'),(10,'New Sub-Category','Insert','2016-11-25 21:50:05','Rolen'),(11,'Delete Sub-Category','Delete','2016-11-25 21:50:16','Rolen'),(12,'New Category','Insert','2016-11-25 21:50:41','Rolen'),(13,'Delete Category','Delete','2016-11-25 21:50:47','Rolen'),(14,'New Sub-Category','Insert','2016-11-25 22:11:59','Rolen'),(15,'Delete Sub-Category','Delete','2016-11-25 22:12:27','Rolen'),(16,'Delete Sub-Category','Delete','2016-11-25 22:12:33','Rolen'),(17,'Delete Category','Delete','2016-11-25 22:12:35','Rolen'),(18,'Delete Family','Delete','2016-11-25 22:12:39','Rolen'),(19,'Delete Family','Delete','2016-11-25 22:12:41','Rolen'),(20,'Order number: 00000009  set order status to Process','Update','2016-11-26 00:31:10','Rolen'),(21,'Order number: 00000009  set order status to Ship','Update','2016-11-26 00:31:18','Rolen'),(22,'Decrease Stock after Order to shipped','Update','2016-11-26 00:31:18','Rolen'),(23,'0','Insert','2016-11-30 00:10:17','JMDMktg'),(24,'0','Insert','2016-11-30 00:13:32','JMDMktg'),(25,'0','Insert','2016-11-30 00:13:32','JMDMktg'),(26,'0','Insert','2016-11-30 00:13:32','JMDMktg'),(27,'0','Insert','2016-11-30 00:26:56','JMDMktg'),(28,'0','Insert','2016-11-30 00:26:56','JMDMktg'),(29,'0','Insert','2016-11-30 00:26:56','JMDMktg'),(30,'0','Insert','2016-11-30 00:31:05','JMDMktg'),(31,'0','Insert','2016-11-30 00:31:05','JMDMktg'),(32,'0','Insert','2016-11-30 00:31:05','JMDMktg'),(33,'0','Insert','2016-11-30 00:31:05','JMDMktg'),(34,'0','Insert','2016-11-30 00:31:06','JMDMktg'),(35,'0','Insert','2016-11-30 00:31:06','JMDMktg'),(36,'0','Insert','2016-11-30 00:31:06','JMDMktg'),(37,'Purchase Order','Insert','2016-11-30 00:34:21','Rolen'),(38,'New PO Received','Insert','2016-11-30 00:38:12','Rolen'),(39,'Update Stock after PO Received','Update','2016-11-30 00:38:12','Rolen'),(40,'0','Insert','2016-11-30 14:52:27','JMDMktg'),(41,'0','Insert','2016-11-30 14:52:27','JMDMktg'),(42,'0','Insert','2016-11-30 14:52:27','JMDMktg'),(43,'0','Insert','2016-11-30 17:26:49','JMDMktg'),(44,'0','Insert','2016-11-30 17:26:49','JMDMktg'),(45,'0','Insert','2016-11-30 17:26:49','JMDMktg'),(46,'Purchase Order','Insert','2016-11-30 18:58:18','Rolen'),(47,'New PO Received','Insert','2016-11-30 18:59:04','Rolen'),(48,'Update Stock after PO Received','Update','2016-11-30 18:59:04','Rolen'),(49,'Update Family','Update','2016-12-01 15:07:04','Rolen'),(50,'Update Family','Update','2016-12-01 15:07:11','Rolen'),(51,'Update Family','Update','2016-12-01 17:39:02','Rolen'),(52,'0','Insert','2016-12-01 23:50:21','VEEnt'),(53,'0','Insert','2016-12-01 23:50:21','VEEnt'),(54,'0','Insert','2016-12-01 23:54:18','VEEnt'),(55,'0','Insert','2016-12-01 23:54:18','VEEnt'),(56,'Purchase Order','Insert','2016-12-02 00:07:19','Rolen'),(57,'Purchase Order','Insert','2016-12-02 01:51:01','Rolen'),(58,'New UOM','Insert','2016-12-02 14:51:07','JMDMktg'),(59,'New UOM','Insert','2016-12-02 14:53:31','JMDMktg'),(60,'New UOM','Insert','2016-12-02 15:10:18','JMDMktg'),(61,'New UOM','Insert','2016-12-02 15:11:04','JMDMktg'),(62,'New UOM','Insert','2016-12-02 15:17:26','JMDMktg'),(63,'New UOM','Insert','2016-12-02 15:21:43','JMDMktg'),(64,'New UOM','Insert','2016-12-02 15:22:01','JMDMktg'),(65,'New UOM','Insert','2016-12-02 15:28:57','JMDMktg'),(66,'New UOM','Insert','2016-12-02 15:29:06','JMDMktg'),(67,'New UOM','Insert','2016-12-02 15:29:57','JMDMktg'),(68,'New UOM','Insert','2016-12-02 15:30:39','JMDMktg'),(69,'New UOM','Insert','2016-12-02 21:53:47','JMDMktg'),(70,'New UOM','Insert','2016-12-02 22:01:57','JMDMktg'),(71,'New UOM','Insert','2016-12-02 22:03:43','JMDMktg'),(72,'New UOM','Insert','2016-12-02 22:03:54','JMDMktg'),(73,'New UOM','Insert','2016-12-02 22:04:49','JMDMktg'),(74,'New UOM','Insert','2016-12-02 22:06:21','JMDMktg'),(75,'New UOM','Insert','2016-12-02 22:06:28','JMDMktg'),(76,'New UOM','Insert','2016-12-02 22:06:37','JMDMktg'),(77,'0','Insert','2016-12-02 23:21:06','VEEnt'),(78,'0','Insert','2016-12-02 23:21:06','VEEnt'),(79,'0','Insert','2016-12-02 23:22:48','VEEnt'),(80,'0','Insert','2016-12-02 23:22:48','VEEnt'),(81,'Purchase Order','Insert','2016-12-03 10:00:33','Rolen'),(82,'121','Insert','2016-12-03 10:14:17','VEEnt'),(83,'121','Insert','2016-12-03 10:14:17','VEEnt'),(84,'12','Insert','2016-12-03 10:15:48','VEEnt'),(85,'12','Insert','2016-12-03 10:15:48','VEEnt'),(86,'New PO Received','Insert','2016-12-03 12:56:01','Rolen'),(87,'New PO Received','Insert','2016-12-03 13:03:11','Rolen'),(88,'Update Stock after PO Received','Update','2016-12-03 13:03:11','Rolen'),(89,'Purchase Order','Insert','2016-12-05 22:22:18','Rolen'),(90,'New UOM','Insert','2016-12-07 00:02:09','VEEnt'),(91,'0','Insert','2016-12-07 00:17:14','VEEnt'),(92,'0','Insert','2016-12-07 00:17:14','VEEnt'),(93,'0','Insert','2016-12-07 00:17:14','VEEnt'),(94,'New PO Received','Insert','2016-12-08 01:12:07','Rolen'),(95,'Update Stock after PO Received','Update','2016-12-08 01:12:07','Rolen'),(96,'Purchase Order','Insert','2016-12-08 01:15:13','Rolen'),(97,'New PO Received','Insert','2016-12-08 01:16:26','Rolen'),(98,'Update Stock after PO Received','Update','2016-12-08 01:16:26','Rolen'),(99,'New PO Received','Insert','2016-12-08 01:18:25','Rolen'),(100,'Update Stock after PO Received','Update','2016-12-08 01:18:25','Rolen'),(101,'New PO Received','Insert','2016-12-08 01:18:41','Rolen'),(102,'Update Stock after PO Received','Update','2016-12-08 01:18:41','Rolen'),(103,'Purchase Order','Insert','2016-12-08 01:19:43','Rolen'),(104,'Purchase Order','Insert','2016-12-08 01:25:05','Rolen'),(105,'New PO Received','Insert','2016-12-08 01:26:24','Rolen'),(106,'Update Stock after PO Received','Update','2016-12-08 01:26:24','Rolen'),(107,'0','Insert','2016-12-08 01:34:43','VEEnt'),(108,'0','Insert','2016-12-08 01:34:43','VEEnt'),(109,'0','Insert','2016-12-08 01:34:43','VEEnt'),(110,'0','Insert','2016-12-08 01:34:43','VEEnt'),(111,'0','Insert','2016-12-08 01:34:43','VEEnt'),(112,'Purchase Order','Insert','2016-12-08 01:35:29','Rolen'),(113,'New PO Received','Insert','2016-12-08 01:36:38','Rolen'),(114,'Update Stock after PO Received','Update','2016-12-08 01:36:38','Rolen'),(115,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:20:40','Rolen'),(116,'Update Physical Count for Item variant : 46','Update','2016-12-08 02:21:38','Rolen'),(117,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:24:03','Rolen'),(118,'Update Physical Count for Item variant : 46','Update','2016-12-08 02:24:26','Rolen'),(119,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:24:40','Rolen'),(120,'Update Physical Count for Item variant : 46','Update','2016-12-08 02:24:58','Rolen'),(121,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:27:03','Rolen'),(122,'Update Physical Count for Item variant : 46','Update','2016-12-08 02:27:52','Rolen'),(123,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:28:32','Rolen'),(124,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:30:08','Rolen'),(125,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:30:18','Rolen'),(126,'Update Physical Count for Item variant : 46','Update','2016-12-08 02:30:27','Rolen'),(127,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:30:41','Rolen'),(128,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:31:38','Rolen'),(129,'Update Physical Count for Item variant : 43','Update','2016-12-08 02:31:51','Rolen'),(130,'Update Physical Count for Item variant : 46','Update','2016-12-08 02:31:58','Rolen'),(131,'New UOM','Insert','2016-12-08 23:25:19','VEEnt'),(132,'0','Insert','2016-12-09 00:13:36','VEEnt'),(133,'0','Insert','2016-12-09 00:13:37','VEEnt'),(134,'Purchase Order','Insert','2016-12-09 00:15:09','Rolen'),(135,'New PO Received','Insert','2016-12-09 00:18:29','Rolen'),(136,'Update Stock after PO Received','Update','2016-12-09 00:18:29','Rolen'),(137,'Purchase Order','Insert','2016-12-09 00:25:56','Rolen'),(138,'New PO Received','Insert','2016-12-09 00:26:34','Rolen'),(139,'Update Stock after PO Received','Update','2016-12-09 00:26:34','Rolen'),(140,'Purchase Order','Insert','2016-12-09 00:27:20','Rolen'),(141,'New PO Received','Insert','2016-12-09 00:27:52','Rolen'),(142,'Update Stock after PO Received','Update','2016-12-09 00:27:52','Rolen'),(143,'Update Physical Count for Item variant : 45','Update','2016-12-09 00:33:07','Rolen'),(144,'Update Physical Count for Item variant : 45','Update','2016-12-09 00:33:19','Rolen'),(145,'Update Physical Count for Item variant : 46','Update','2016-12-09 00:34:17','Rolen'),(146,'Update Physical Count for Item variant : 43','Update','2016-12-09 00:35:21','Rolen'),(147,'Update Physical Count for Item variant : 43','Update','2016-12-09 00:35:41','Rolen'),(148,'0','Insert','2016-12-09 01:04:54','VEEnt'),(149,'0','Insert','2016-12-09 01:04:54','VEEnt'),(150,'Purchase Order','Insert','2016-12-09 01:05:41','Rolen'),(151,'0','Insert','2016-12-09 01:08:17','VEEnt'),(152,'0','Insert','2016-12-09 01:08:17','VEEnt'),(153,'Purchase Order','Insert','2016-12-09 01:08:53','Rolen'),(154,'New PO Received','Insert','2016-12-09 01:09:40','Rolen'),(155,'Update Stock after PO Received','Update','2016-12-09 01:09:40','Rolen'),(156,'0','Insert','2016-12-09 01:13:22','VEEnt'),(157,'0','Insert','2016-12-09 01:13:23','VEEnt'),(158,'Purchase Order','Insert','2016-12-09 01:14:24','Rolen'),(159,'New PO Received','Insert','2016-12-09 01:15:31','Rolen'),(160,'Update Stock after PO Received','Update','2016-12-09 01:15:31','Rolen'),(161,'0','Insert','2016-12-09 01:20:39','VEEnt'),(162,'0','Insert','2016-12-09 01:20:39','VEEnt'),(163,'Purchase Order','Insert','2016-12-09 01:23:50','Rolen'),(164,'New PO Received','Insert','2016-12-09 01:24:38','Rolen'),(165,'Update Stock after PO Received','Update','2016-12-09 01:24:38','Rolen'),(166,'0','Insert','2016-12-09 01:28:33','VEEnt'),(167,'0','Insert','2016-12-09 01:28:33','VEEnt'),(168,'Purchase Order','Insert','2016-12-09 01:31:33','Rolen'),(169,'New PO Received','Insert','2016-12-09 01:32:12','Rolen'),(170,'Update Stock after PO Received','Update','2016-12-09 01:32:12','Rolen'),(171,'0','Insert','2016-12-09 08:01:15','VEEnt'),(172,'0','Insert','2016-12-09 08:01:15','VEEnt'),(173,'0','Insert','2016-12-09 08:05:43','VEEnt'),(174,'0','Insert','2016-12-09 08:05:43','VEEnt'),(175,'Purchase Order','Insert','2016-12-09 08:07:49','Rolen'),(176,'New PO Received','Insert','2016-12-09 08:08:29','Rolen'),(177,'New PO Received','Insert','2016-12-09 08:08:31','Rolen'),(178,'New PO Received','Insert','2016-12-09 08:08:43','Rolen'),(179,'New PO Received','Insert','2016-12-09 08:09:17','Rolen'),(180,'New PO Received','Insert','2016-12-09 08:09:47','Rolen'),(181,'Update Stock after PO Received','Update','2016-12-09 08:09:47','Rolen'),(182,'Purchase Order','Insert','2016-12-09 08:15:35','Rolen'),(183,'New PO Received','Insert','2016-12-09 08:16:53','Rolen'),(184,'Update Stock after PO Received','Update','2016-12-09 08:16:53','Rolen'),(185,'Purchase Order','Insert','2016-12-09 08:18:53','Rolen'),(186,'New PO Received','Insert','2016-12-09 09:13:05','Rolen'),(187,'Update Stock after PO Received','Update','2016-12-09 09:13:05','Rolen'),(188,'Purchase Order','Insert','2016-12-09 09:13:55','Rolen'),(189,'New PO Received','Insert','2016-12-09 09:14:40','Rolen'),(190,'Update Stock after PO Received','Update','2016-12-09 09:14:40','Rolen'),(191,'Update Family','Update','2016-12-09 09:28:49','Rolen'),(192,'Delete Family','Delete','2016-12-09 09:29:47','Rolen'),(193,'Delete Family','Delete','2016-12-09 09:29:52','Rolen'),(194,'Delete Category','Delete','2016-12-09 09:29:54','Rolen'),(195,'New Family','Insert','2016-12-09 09:31:57','Rolen'),(196,'New Family','Insert','2016-12-09 09:46:53','Rolen'),(197,'New Family','Insert','2016-12-09 09:47:08','Rolen'),(198,'Delete Family','Delete','2016-12-09 09:47:30','Rolen'),(199,'Delete Family','Delete','2016-12-09 09:47:33','Rolen'),(200,'New Family','Insert','2016-12-09 09:47:55','Rolen'),(201,'New Family','Insert','2016-12-09 09:48:43','Rolen'),(202,'New Family','Insert','2016-12-09 09:49:16','Rolen'),(203,'New Family','Insert','2016-12-09 09:52:26','Rolen'),(204,'Delete Family','Delete','2016-12-09 09:52:50','Rolen'),(205,'Delete Family','Delete','2016-12-09 09:52:53','Rolen'),(206,'Delete Family','Delete','2016-12-09 09:52:55','Rolen'),(207,'Delete Family','Delete','2016-12-09 09:52:57','Rolen'),(208,'New Family','Insert','2016-12-09 09:53:02','Rolen'),(209,'New Family','Insert','2016-12-09 09:53:09','Rolen'),(210,'New Family','Insert','2016-12-09 09:53:38','Rolen'),(211,'New Family','Insert','2016-12-09 09:55:54','Rolen'),(212,'Delete Family','Delete','2016-12-09 09:56:38','Rolen'),(213,'Delete Family','Delete','2016-12-09 09:56:40','Rolen'),(214,'Delete Family','Delete','2016-12-09 09:56:42','Rolen'),(215,'Delete Family','Delete','2016-12-09 09:56:45','Rolen'),(216,'Delete Family','Delete','2016-12-09 09:56:48','Rolen'),(217,'New Family','Insert','2016-12-09 09:56:59','Rolen'),(218,'New Family','Insert','2016-12-09 10:00:32','Rolen'),(219,'Delete Family','Delete','2016-12-09 10:00:49','Rolen'),(220,'New Category','Insert','2016-12-09 10:06:21','Rolen'),(221,'New Category','Insert','2016-12-09 10:08:41','Rolen'),(222,'New Category','Insert','2016-12-09 10:10:50','Rolen'),(223,'New Category','Insert','2016-12-09 10:13:31','Rolen'),(224,'New Sub-Category','Insert','2016-12-09 10:17:58','Rolen'),(225,'New Sub-Category','Insert','2016-12-09 10:19:13','Rolen'),(226,'New Sub-Category','Insert','2016-12-09 10:19:20','Rolen'),(227,'New Sub-Category','Insert','2016-12-09 10:19:35','Rolen'),(228,'New Family','Insert','2016-12-09 10:21:31','Rolen'),(229,'New Category','Insert','2016-12-09 10:21:47','Rolen'),(230,'New Category','Insert','2016-12-09 10:22:02','Rolen'),(231,'New Sub-Category','Insert','2016-12-09 10:22:12','Rolen'),(232,'New Sub-Category','Insert','2016-12-09 10:22:23','Rolen'),(233,'New Sub-Category','Insert','2016-12-09 10:22:29','Rolen'),(234,'New Sub-Category','Insert','2016-12-09 10:22:36','Rolen'),(235,'New Sub-Category','Insert','2016-12-09 10:22:43','Rolen'),(236,'New Sub-Category','Insert','2016-12-09 10:22:50','Rolen'),(237,'New Sub-Category','Insert','2016-12-09 10:22:56','Rolen'),(238,'New Sub-Category','Insert','2016-12-09 10:23:02','Rolen'),(239,'New Family','Insert','2016-12-09 10:40:51','Rolen'),(240,'New Family','Insert','2016-12-09 10:41:00','Rolen'),(241,'New Family','Insert','2016-12-09 10:41:10','Rolen'),(242,'New Family','Insert','2016-12-09 10:41:19','Rolen'),(243,'New Category','Insert','2016-12-09 10:41:36','Rolen'),(244,'New Category','Insert','2016-12-09 10:41:45','Rolen'),(245,'New Sub-Category','Insert','2016-12-09 20:40:08','Rolen'),(246,'0','Insert','2016-12-09 20:40:48','VEEnt'),(247,'0','Insert','2016-12-09 20:40:48','VEEnt'),(248,'0','Insert','2016-12-09 21:45:47','VEEnt'),(249,'0','Insert','2016-12-09 21:45:47','VEEnt'),(250,'0','Insert','2016-12-09 21:45:47','VEEnt'),(251,'Purchase Order','Insert','2016-12-09 21:47:16','Rolen'),(252,'New PO Received','Insert','2016-12-09 21:48:20','Rolen'),(253,'Update Stock after PO Received','Update','2016-12-09 21:48:20','Rolen'),(254,'Update Physical Count for Item variant : 56','Update','2016-12-09 22:03:36','Rolen'),(255,'Update Physical Count for Item variant : 55','Update','2016-12-09 22:04:48','Rolen'),(256,'Purchase Order','Insert','2016-12-09 22:05:50','Rolen'),(257,'New PO Received','Insert','2016-12-09 22:08:58','Rolen'),(258,'Update Stock after PO Received','Update','2016-12-09 22:08:58','Rolen'),(259,'New Category','Insert','2016-12-12 22:57:38','Rolen'),(260,'New Category','Insert','2016-12-12 22:57:52','Rolen'),(261,'Delete Family','Delete','2016-12-12 22:58:02','Rolen'),(262,'New Category','Insert','2016-12-12 22:58:16','Rolen'),(263,'New Sub-Category','Insert','2016-12-12 22:58:25','Rolen'),(264,'New Sub-Category','Insert','2016-12-12 22:58:32','Rolen'),(265,'New Sub-Category','Insert','2016-12-12 22:58:37','Rolen'),(266,'New Category','Insert','2016-12-12 22:58:49','Rolen'),(267,'New Category','Insert','2016-12-12 22:59:03','Rolen'),(268,'New Sub-Category','Insert','2016-12-12 22:59:15','Rolen'),(269,'New Sub-Category','Insert','2016-12-12 22:59:22','Rolen'),(270,'New Sub-Category','Insert','2016-12-12 22:59:29','Rolen'),(271,'New Sub-Category','Insert','2016-12-12 22:59:35','Rolen'),(272,'New Family','Insert','2016-12-12 23:00:00','Rolen'),(273,'New Category','Insert','2016-12-12 23:00:11','Rolen'),(274,'New Category','Insert','2016-12-12 23:00:23','Rolen'),(275,'New Family','Insert','2016-12-12 23:00:34','Rolen'),(276,'New Sub-Category','Insert','2016-12-12 23:00:49','Rolen'),(277,'New Sub-Category','Insert','2016-12-12 23:00:55','Rolen'),(278,'New Sub-Category','Insert','2016-12-12 23:01:06','Rolen'),(279,'New Sub-Category','Insert','2016-12-12 23:01:11','Rolen'),(280,'New Sub-Category','Insert','2016-12-12 23:01:17','Rolen'),(281,'New Category','Insert','2016-12-12 23:01:32','Rolen'),(282,'New Category','Insert','2016-12-12 23:01:40','Rolen'),(283,'New Category','Insert','2016-12-12 23:01:49','Rolen'),(284,'New Family','Insert','2016-12-12 23:01:59','Rolen'),(285,'New Category','Insert','2016-12-12 23:02:09','Rolen'),(286,'New Category','Insert','2016-12-12 23:02:17','Rolen'),(287,'Delete Sub-Category','Delete','2016-12-12 23:03:18','Rolen');

/*Table structure for table `tblorder` */

