 
 LOCK TABLES `customer_hierarchy` WRITE;
 /*!40000 ALTER TABLE `customer_hierarchy` DISABLE KEYS */;
-INSERT INTO `customer_hierarchy` VALUES (1,1,4,1,'2010-01-22',NULL,NULL,NULL),(2,4,5,1,'2010-01-22',NULL,NULL,NULL);
+INSERT INTO `customer_hierarchy` VALUES (1,1,4,1,'2010-01-22',NULL,NULL,NULL),(2,4,5,1,'2010-01-22',NULL,NULL,NULL),(3,1,9,1,'2011-02-18',NULL,NULL,NULL),(4,9,10,1,'2011-02-18',NULL,NULL,NULL);
 /*!40000 ALTER TABLE `customer_hierarchy` ENABLE KEYS */;
 UNLOCK TABLES;
 


LOCK TABLES `loan_trxn_detail` WRITE;
/*!40000 ALTER TABLE `loan_trxn_detail` DISABLE KEYS */;
INSERT INTO `loan_trxn_detail` VALUES (2,'1000.0000',2,'0.0000',2,'0.0000',2,'0.0000',2,'0.0000',2);
/*!40000 ALTER TABLE `loan_trxn_detail` ENABLE KEYS */;
UNLOCK TABLES;



LOCK TABLES `customer_name_detail` WRITE;
/*!40000 ALTER TABLE `customer_name_detail` DISABLE KEYS */;
INSERT INTO `customer_name_detail` VALUES (1,2,1,NULL,NULL,'Client1233266063395','','Client1233266063395','',NULL,'Client1233266063395 Client1233266063395'),(2,2,3,NULL,228,'Client - Mary','','Monthly','',NULL,'Client - Mary Monthly'),(3,3,1,NULL,NULL,'Client1233266063395','','Client1233266063395','',NULL,'Client1233266063395 Client1233266063395'),(4,3,3,NULL,47,'Stu1233266063395','','Client1233266063395','',NULL,'Stu1233266063395 Client1233266063395'),(5,5,3,NULL,47,'client1','','lastname','',NULL,'client1 lastname'),(6,5,1,NULL,NULL,'Client1233266063395','','Client1233266063395','',NULL,'Client1233266063395 Client1233266063395'),(7,6,3,NULL,47,'Stu1233171716380','','Client1233171716380','',NULL,'Stu1233171716380 Client1233171716380'),(8,6,1,NULL,NULL,'Client1233266063395','','Client1233266063395','',NULL,'Client1233266063395 Client1233266063395'),(9,7,NULL,NULL,NULL,'','','','',NULL,''),(10,7,3,NULL,47,'Client - Mary','','Monthly1','',NULL,'Client - Mary Monthly1'),(11,8,3,NULL,228,'Client - Mia','','Monthly3rdFriday','',NULL,'Client - Mia Monthly3rdFriday'),(12,8,NULL,NULL,NULL,'','','','',NULL,''),(13,10,3,NULL,47,'ClientWithLoan','','20110221','',NULL,'ClientWithLoan 20110221'),(14,10,NULL,NULL,NULL,'','','','',NULL,'');
/*!40000 ALTER TABLE `customer_name_detail` ENABLE KEYS */;
UNLOCK TABLES;

