http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/66cee785/fineract-db/multi-tenant-demo-backups/default-demo/bk_mifostenant-default.sql ---------------------------------------------------------------------- diff --git a/fineract-db/multi-tenant-demo-backups/default-demo/bk_mifostenant-default.sql b/fineract-db/multi-tenant-demo-backups/default-demo/bk_mifostenant-default.sql deleted file mode 100644 index 306570a..0000000 --- a/fineract-db/multi-tenant-demo-backups/default-demo/bk_mifostenant-default.sql +++ /dev/null @@ -1,1935 +0,0 @@ --- MySQL dump 10.13 Distrib 5.1.60, for Win32 (ia32) --- --- Host: localhost Database: mifostenant-default --- ------------------------------------------------------ --- Server version 5.1.60-community - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - --- --- Table structure for table `acc_gl_account` --- - -DROP TABLE IF EXISTS `acc_gl_account`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `acc_gl_account` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `name` varchar(45) NOT NULL, - `parent_id` bigint(20) DEFAULT NULL, - `gl_code` varchar(45) NOT NULL, - `disabled` tinyint(1) NOT NULL DEFAULT '0', - `manual_journal_entries_allowed` tinyint(1) NOT NULL DEFAULT '1', - `account_usage` tinyint(1) NOT NULL DEFAULT '2', - `classification_enum` smallint(5) NOT NULL, - `description` varchar(500) DEFAULT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `acc_gl_code` (`gl_code`), - KEY `FK_ACC_0000000001` (`parent_id`), - CONSTRAINT `FK_ACC_0000000001` FOREIGN KEY (`parent_id`) REFERENCES `acc_gl_account` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `acc_gl_account` --- - -LOCK TABLES `acc_gl_account` WRITE; -/*!40000 ALTER TABLE `acc_gl_account` DISABLE KEYS */; -INSERT INTO `acc_gl_account` VALUES (1,'Petty Cash Balances',NULL,'11100',0,1,2,1,NULL),(2,'Cash in Valut 1',NULL,'11101',0,1,1,1,NULL),(3,'Bank Balances',NULL,'11200',0,1,2,1,NULL),(4,'Centenary Opening Account',NULL,'11201',0,1,1,1,NULL),(5,'Centenary Expense Account',NULL,'11202',0,1,1,1,NULL),(6,'Centenary USD Account',NULL,'11203',0,1,1,1,NULL),(7,'Loans and Advances',NULL,'13100',0,1,2,1,NULL),(8,'Loans to Clients',NULL,'13101',0,1,1,1,NULL),(9,'Outstanding Interest',NULL,'13102',0,1,1,1,NULL),(10,'Outstanding Late Payment Interest',NULL,'13103',0,1,1,1,NULL),(11,'Outstanding Bank Fees to be collected',NULL,'13104',0,1,1,1,NULL),(12,'WriteOff Accounts',NULL,'13200',0,1,2,1,NULL),(13,'Write-offs (use for funds coming in)',NULL,'13201',0,1,1,1,NULL),(14,'Write-offs outstanding principal',NULL,'13202',0,1,1,1,NULL),(15,'Write-offs outstanding interest',NULL,'13203',0,1,1,1,NULL),(16,'Write-offs collected bank fees',NULL,'13204',0,1,1,1,NULL),(17,'Write-offs hardware/furniture',NU LL,'13205',0,1,1,1,NULL),(18,'Fixed Assets',NULL,'14100',0,1,2,1,NULL),(19,'Office Equipment',NULL,'14101',0,1,1,1,NULL),(20,'Suspense Items (unidentified deposits)',NULL,'15000',0,1,2,1,NULL),(21,'Assets',NULL,'10000',0,1,2,1,NULL),(22,'Liabilities',NULL,'20000',0,1,2,2,NULL),(23,'Shares Account',NULL,'26100',0,1,2,2,NULL),(24,'Shares Captial',NULL,'26101',0,1,1,2,NULL),(25,'Donated Equity',NULL,'26300',0,1,2,2,NULL),(26,'Donated Equity Ameropa Foundation',NULL,'26301',0,1,1,2,NULL),(27,'Donated Equity e.h',NULL,'26302',0,1,1,2,NULL),(28,'Overpaid Amounts',NULL,'27000',0,1,2,2,NULL),(29,'Loss Provision',NULL,'28000',0,1,2,2,NULL),(30,'Provision Outstanding Principal',NULL,'28001',0,1,1,2,NULL),(31,'Provision Oustanding Interest',NULL,'28002',0,1,1,2,NULL),(32,'Income',NULL,'30000',0,1,2,4,NULL),(33,'Interest Income from Loans',NULL,'31100',0,1,2,4,NULL),(34,'Interest on Loans',NULL,'31101',0,1,1,4,NULL),(35,'Late Payment Interest',NULL,'31102',0,1,1,4,NULL),(36,'Income from Micro c redit & Lending Activities',NULL,'31300',0,1,2,4,NULL),(37,'Collected Bank Fees Receivable',NULL,'6201',0,1,1,4,NULL),(38,'Deposits from Loans Write Off',NULL,'31400',0,1,2,4,NULL),(39,'Expenditure',NULL,'40000',0,1,2,5,NULL),(40,'Office Expenditure Account',NULL,'42100',0,1,2,5,NULL),(41,'Water Charges',NULL,'42102',0,1,1,5,NULL),(42,'Electricity Charges',NULL,'42103',0,1,1,5,NULL),(43,'Printing and Stationary',NULL,'42105',0,1,1,5,NULL),(44,'Office Rent',NULL,'42107',0,1,1,5,NULL),(45,'Marketing Expense',NULL,'42109',0,1,1,5,NULL),(46,'Office utilities',NULL,'42112',0,1,1,5,'(supplies, toiletries, kitchen)'),(47,'Furniture',NULL,'42113',0,1,1,5,NULL),(48,'CEDA Meeting Expense',NULL,'42114',0,1,1,5,NULL),(49,'Employee Personal Expsense Account',NULL,'42200',0,1,2,5,NULL),(50,'Salary Alice',NULL,'42201',0,1,1,5,NULL),(51,'Salary Irene',NULL,'42202',0,1,1,5,NULL),(52,'Salary Richard',NULL,'42203',0,1,1,5,NULL),(53,'Salary Loan Officer TBA',NULL,'42204',0,1,1,5,NULL),(54,'Medical Insu rance Alice & Family',NULL,'42205',0,1,1,5,NULL),(55,'Medical Insurance Irene',NULL,'42206',0,1,1,5,NULL),(56,'Medical Insurance Richard',NULL,'42207',0,1,1,5,NULL),(57,'Medical Insurance Loan Officer TBA',NULL,'42208',0,1,1,5,NULL),(58,'PAYE all employees',NULL,'42209',0,1,1,5,NULL),(59,'NSSF all employees',NULL,'42210',0,1,1,5,NULL),(60,'Lunch Allowances all employees',NULL,'42211',0,1,1,5,NULL),(61,'IT software and maintenance',NULL,'42300',0,1,2,5,NULL),(62,'Mifos maintenance contract 12 months',NULL,'42301',0,1,1,5,NULL),(63,'VPS Contract 12 months',NULL,'42302',0,1,1,5,NULL),(64,'Bulk SMS Service',NULL,'42303',0,1,1,5,NULL),(65,'Support Accounting Software',NULL,'42304',0,1,1,5,NULL),(66,'Mifos Instance Setup',NULL,'42305',0,1,1,5,NULL),(67,'Misc support expense',NULL,'42306',0,1,1,5,NULL),(68,'Warid Mobile Line',NULL,'42307',0,1,1,5,NULL),(69,'Landline',NULL,'42308',0,1,1,5,NULL),(70,'Modem Alice',NULL,'42309',0,1,1,5,NULL),(71,'Modem Irene',NULL,'42310',0,1,1,5,NULL),(72,'Mo dem Richard',NULL,'42311',0,1,1,5,NULL),(73,'Repairs',NULL,'42312',0,1,1,5,NULL),(74,'Airtime Expenses',NULL,'42400',0,1,2,5,NULL),(75,'Airtime Alice',NULL,'42401',0,1,1,5,NULL),(76,'Airtime Richard',NULL,'42402',0,1,1,5,NULL),(77,'Airtime Loan Office TBA',NULL,'42403',0,1,1,5,NULL),(78,'Special Airtime Alice',NULL,'42404',0,1,1,5,NULL),(79,'Transportation',NULL,'42500',0,1,2,5,NULL),(80,'Flat monthly transportation cost',NULL,'42501',0,1,1,5,NULL),(81,'Faciliation cost for Richard',NULL,'42502',0,1,1,5,NULL),(82,'Faciliation cost for Loan Officer TBA',NULL,'42503',0,1,1,5,NULL),(83,'Consultancy Expenses',NULL,'42600',0,1,2,5,NULL),(84,'Audit Fees',NULL,'42601',0,1,1,5,NULL),(85,'Legal Fees',NULL,'42602',0,1,1,5,NULL),(86,'Miscellaneous Expenses Account',NULL,'42700',0,1,2,5,NULL),(87,'MFI License',NULL,'42703',0,1,1,5,NULL),(88,'Sundy Expenses',NULL,'42704',0,1,1,5,NULL),(89,'Bank Fees',NULL,'42800',0,1,2,5,NULL),(90,'Bank Charges Operating Account',NULL,'42801',0,1,1,5,NULL),(91,' Bank Charges Expense Account',NULL,'42802',0,1,1,5,NULL),(92,'E.H Account',NULL,'42900',0,1,2,5,NULL),(93,'Airtime',NULL,'42901',0,1,1,5,NULL),(94,'Modem',NULL,'42902',0,1,1,5,NULL),(95,'Meals',NULL,'42903',0,1,1,5,NULL),(96,'Transportation',NULL,'42904',0,1,1,5,NULL),(97,'Miscellaneous',NULL,'42905',0,1,1,5,NULL); -/*!40000 ALTER TABLE `acc_gl_account` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `acc_gl_closure` --- - -DROP TABLE IF EXISTS `acc_gl_closure`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `acc_gl_closure` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `office_id` bigint(20) NOT NULL, - `closing_date` date NOT NULL, - `is_deleted` int(20) NOT NULL DEFAULT '0', - `createdby_id` bigint(20) DEFAULT NULL, - `lastmodifiedby_id` bigint(20) DEFAULT NULL, - `created_date` datetime DEFAULT NULL, - `lastmodified_date` datetime DEFAULT NULL, - `comments` varchar(500) DEFAULT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `office_id_closing_date` (`office_id`,`closing_date`), - KEY `FK_acc_gl_closure_m_office` (`office_id`), - KEY `FK_acc_gl_closure_m_appuser` (`createdby_id`), - KEY `FK_acc_gl_closure_m_appuser_2` (`lastmodifiedby_id`), - CONSTRAINT `FK_acc_gl_closure_m_appuser` FOREIGN KEY (`createdby_id`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_acc_gl_closure_m_appuser_2` FOREIGN KEY (`lastmodifiedby_id`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_acc_gl_closure_m_office` FOREIGN KEY (`office_id`) REFERENCES `m_office` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `acc_gl_closure` --- - -LOCK TABLES `acc_gl_closure` WRITE; -/*!40000 ALTER TABLE `acc_gl_closure` DISABLE KEYS */; -/*!40000 ALTER TABLE `acc_gl_closure` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `acc_gl_journal_entry` --- - -DROP TABLE IF EXISTS `acc_gl_journal_entry`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `acc_gl_journal_entry` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `account_id` bigint(20) NOT NULL, - `office_id` bigint(20) NOT NULL, - `reversal_id` bigint(20) DEFAULT NULL, - `transaction_id` varchar(50) NOT NULL, - `reversed` tinyint(1) NOT NULL DEFAULT '0', - `manual_entry` tinyint(1) NOT NULL DEFAULT '0', - `entry_date` date NOT NULL, - `type_enum` smallint(5) NOT NULL, - `amount` decimal(19,6) NOT NULL, - `description` varchar(500) DEFAULT NULL, - `entity_type_enum` smallint(5) DEFAULT NULL, - `entity_id` bigint(20) DEFAULT NULL, - `createdby_id` bigint(20) NOT NULL, - `lastmodifiedby_id` bigint(20) NOT NULL, - `created_date` datetime NOT NULL, - `lastmodified_date` datetime NOT NULL, - PRIMARY KEY (`id`), - KEY `FK_acc_gl_journal_entry_m_office` (`office_id`), - KEY `FK_acc_gl_journal_entry_m_appuser` (`createdby_id`), - KEY `FK_acc_gl_journal_entry_m_appuser_2` (`lastmodifiedby_id`), - KEY `FK_acc_gl_journal_entry_acc_gl_journal_entry` (`reversal_id`), - KEY `FK_acc_gl_journal_entry_acc_gl_account` (`account_id`), - CONSTRAINT `FK_acc_gl_journal_entry_acc_gl_account` FOREIGN KEY (`account_id`) REFERENCES `acc_gl_account` (`id`), - CONSTRAINT `FK_acc_gl_journal_entry_acc_gl_journal_entry` FOREIGN KEY (`reversal_id`) REFERENCES `acc_gl_journal_entry` (`id`), - CONSTRAINT `FK_acc_gl_journal_entry_m_appuser` FOREIGN KEY (`createdby_id`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_acc_gl_journal_entry_m_appuser_2` FOREIGN KEY (`lastmodifiedby_id`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_acc_gl_journal_entry_m_office` FOREIGN KEY (`office_id`) REFERENCES `m_office` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `acc_gl_journal_entry` --- - -LOCK TABLES `acc_gl_journal_entry` WRITE; -/*!40000 ALTER TABLE `acc_gl_journal_entry` DISABLE KEYS */; -/*!40000 ALTER TABLE `acc_gl_journal_entry` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `acc_product_mapping` --- - -DROP TABLE IF EXISTS `acc_product_mapping`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `acc_product_mapping` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `gl_account_id` bigint(20) DEFAULT NULL, - `product_id` bigint(20) DEFAULT NULL, - `product_type` smallint(5) DEFAULT NULL, - `financial_account_type` smallint(5) DEFAULT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `acc_product_mapping` --- - -LOCK TABLES `acc_product_mapping` WRITE; -/*!40000 ALTER TABLE `acc_product_mapping` DISABLE KEYS */; -/*!40000 ALTER TABLE `acc_product_mapping` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `c_configuration` --- - -DROP TABLE IF EXISTS `c_configuration`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `c_configuration` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `name` varchar(50) DEFAULT NULL, - `enabled` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `c_configuration` --- - -LOCK TABLES `c_configuration` WRITE; -/*!40000 ALTER TABLE `c_configuration` DISABLE KEYS */; -INSERT INTO `c_configuration` VALUES (1,'maker-checker',0); -/*!40000 ALTER TABLE `c_configuration` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `client additional data` --- - -DROP TABLE IF EXISTS `client additional data`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `client additional data` ( - `client_id` bigint(20) NOT NULL, - `Gender_cd` int(11) NOT NULL, - `Date of Birth` date NOT NULL, - `Home address` text NOT NULL, - `Telephone number` varchar(20) NOT NULL, - `Telephone number (2nd)` varchar(20) NOT NULL, - `Email address` varchar(50) NOT NULL, - `EducationLevel_cd` int(11) NOT NULL, - `MaritalStatus_cd` int(11) NOT NULL, - `Number of children` int(11) NOT NULL, - `Citizenship` varchar(50) NOT NULL, - `PovertyStatus_cd` int(11) NOT NULL, - `YesNo_cd_Employed` int(11) NOT NULL, - `FieldOfEmployment_cd_Field of employment` int(11) DEFAULT NULL, - `Employer name` varchar(50) DEFAULT NULL, - `Number of years` int(11) DEFAULT NULL, - `Monthly salary` decimal(19,6) DEFAULT NULL, - `YesNo_cd_Self employed` int(11) NOT NULL, - `FieldOfEmployment_cd_Field of self-employment` int(11) DEFAULT NULL, - `Business address` text, - `Number of employees` int(11) DEFAULT NULL, - `Monthly salaries paid` decimal(19,6) DEFAULT NULL, - `Monthly net income of business activity` decimal(19,6) DEFAULT NULL, - `Monthly rent` decimal(19,6) DEFAULT NULL, - `Other income generating activities` varchar(100) DEFAULT NULL, - `YesNo_cd_Bookkeeping` int(11) DEFAULT NULL, - `YesNo_cd_Loans with other institutions` int(11) NOT NULL, - `From whom` varchar(100) DEFAULT NULL, - `Amount` decimal(19,6) DEFAULT NULL, - `Interest rate pa` decimal(19,6) DEFAULT NULL, - `Number of people depending on overal income` int(11) NOT NULL, - `YesNo_cd_Bank account` int(11) NOT NULL, - `YesNo_cd_Business plan provided` int(11) NOT NULL, - `YesNo_cd_Access to internet` int(11) DEFAULT NULL, - `Introduced by` varchar(100) DEFAULT NULL, - `Known to introducer since` varchar(100) NOT NULL, - `Last visited by` varchar(100) DEFAULT NULL, - `Last visited on` date NOT NULL, - PRIMARY KEY (`client_id`), - CONSTRAINT `FK_client_additional_data` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `client additional data` --- - -LOCK TABLES `client additional data` WRITE; -/*!40000 ALTER TABLE `client additional data` DISABLE KEYS */; -/*!40000 ALTER TABLE `client additional data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `extra_client_details` --- - -DROP TABLE IF EXISTS `extra_client_details`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `extra_client_details` ( - `client_id` bigint(20) NOT NULL, - `Business Description` varchar(100) DEFAULT NULL, - `Years in Business` int(11) DEFAULT NULL, - `Gender_cd` int(11) DEFAULT NULL, - `Education_cv` varchar(60) DEFAULT NULL, - `Next Visit` date DEFAULT NULL, - `Highest Rate Paid` decimal(19,6) DEFAULT NULL, - `Comment` text, - PRIMARY KEY (`client_id`), - CONSTRAINT `FK_extra_client_details` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `extra_client_details` --- - -LOCK TABLES `extra_client_details` WRITE; -/*!40000 ALTER TABLE `extra_client_details` DISABLE KEYS */; -/*!40000 ALTER TABLE `extra_client_details` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `extra_family_details` --- - -DROP TABLE IF EXISTS `extra_family_details`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `extra_family_details` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `client_id` bigint(20) NOT NULL, - `Name` varchar(40) DEFAULT NULL, - `Date of Birth` date DEFAULT NULL, - `Points Score` int(11) DEFAULT NULL, - `Education_cd_Highest` int(11) DEFAULT NULL, - `Other Notes` text, - PRIMARY KEY (`id`), - KEY `FK_Extra Family Details Data_1` (`client_id`), - CONSTRAINT `FK_family_details` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `extra_family_details` --- - -LOCK TABLES `extra_family_details` WRITE; -/*!40000 ALTER TABLE `extra_family_details` DISABLE KEYS */; -/*!40000 ALTER TABLE `extra_family_details` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `extra_loan_details` --- - -DROP TABLE IF EXISTS `extra_loan_details`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `extra_loan_details` ( - `loan_id` bigint(20) NOT NULL, - `Business Description` varchar(100) DEFAULT NULL, - `Years in Business` int(11) DEFAULT NULL, - `Gender_cd` int(11) DEFAULT NULL, - `Education_cv` varchar(60) DEFAULT NULL, - `Next Visit` date DEFAULT NULL, - `Highest Rate Paid` decimal(19,6) DEFAULT NULL, - `Comment` text, - PRIMARY KEY (`loan_id`), - CONSTRAINT `FK_extra_loan_details` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `extra_loan_details` --- - -LOCK TABLES `extra_loan_details` WRITE; -/*!40000 ALTER TABLE `extra_loan_details` DISABLE KEYS */; -/*!40000 ALTER TABLE `extra_loan_details` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `impact measurement` --- - -DROP TABLE IF EXISTS `impact measurement`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `impact measurement` ( - `loan_id` bigint(20) NOT NULL, - `YesNo_cd_RepaidOnSchedule` int(11) NOT NULL, - `ReasonNotRepaidOnSchedule` text, - `How was Loan Amount Invested` text NOT NULL, - `Additional Income Generated` decimal(19,6) NOT NULL, - `Additional Income Used For` text NOT NULL, - `YesNo_cd_NewJobsCreated` int(11) NOT NULL, - `Number of Jobs Created` bigint(20) DEFAULT NULL, - PRIMARY KEY (`loan_id`), - CONSTRAINT `FK_impact measurement` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `impact measurement` --- - -LOCK TABLES `impact measurement` WRITE; -/*!40000 ALTER TABLE `impact measurement` DISABLE KEYS */; -/*!40000 ALTER TABLE `impact measurement` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `loan additional data` --- - -DROP TABLE IF EXISTS `loan additional data`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `loan additional data` ( - `loan_id` bigint(20) NOT NULL, - `PurposeOfLoan_cd` int(11) NOT NULL, - `CollateralType_cd` int(11) NOT NULL, - `Collateral notes` text NOT NULL, - `YesNo_cd_Guarantor` int(11) NOT NULL, - `Guarantor name` varchar(100) DEFAULT NULL, - `Guarantor relation` varchar(100) DEFAULT NULL, - `Guarantor address` varchar(100) DEFAULT NULL, - `Guarantor telephone number` varchar(20) DEFAULT NULL, - PRIMARY KEY (`loan_id`), - CONSTRAINT `FK_loan_additional_data` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `loan additional data` --- - -LOCK TABLES `loan additional data` WRITE; -/*!40000 ALTER TABLE `loan additional data` DISABLE KEYS */; -/*!40000 ALTER TABLE `loan additional data` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_appuser` --- - -DROP TABLE IF EXISTS `m_appuser`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_appuser` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `is_deleted` tinyint(1) NOT NULL DEFAULT '0', - `office_id` bigint(20) DEFAULT NULL, - `username` varchar(100) NOT NULL, - `firstname` varchar(100) NOT NULL, - `lastname` varchar(100) NOT NULL, - `password` varchar(255) NOT NULL, - `email` varchar(100) NOT NULL, - `firsttime_login_remaining` bit(1) NOT NULL, - `nonexpired` bit(1) NOT NULL, - `nonlocked` bit(1) NOT NULL, - `nonexpired_credentials` bit(1) NOT NULL, - `enabled` bit(1) NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `username_org` (`username`), - KEY `FKB3D587CE0DD567A` (`office_id`), - CONSTRAINT `FKB3D587CE0DD567A` FOREIGN KEY (`office_id`) REFERENCES `m_office` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_appuser` --- - -LOCK TABLES `m_appuser` WRITE; -/*!40000 ALTER TABLE `m_appuser` DISABLE KEYS */; -INSERT INTO `m_appuser` VALUES (1,0,1,'mifos','App','Administrator','5787039480429368bf94732aacc771cd0a3ea02bcf504ffe1185ab94213bc63a','[email protected]','\0','','','',''); -/*!40000 ALTER TABLE `m_appuser` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_appuser_role` --- - -DROP TABLE IF EXISTS `m_appuser_role`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_appuser_role` ( - `appuser_id` bigint(20) NOT NULL, - `role_id` bigint(20) NOT NULL, - PRIMARY KEY (`appuser_id`,`role_id`), - KEY `FK7662CE59B4100309` (`appuser_id`), - KEY `FK7662CE5915CEC7AB` (`role_id`), - CONSTRAINT `FK7662CE5915CEC7AB` FOREIGN KEY (`role_id`) REFERENCES `m_role` (`id`), - CONSTRAINT `FK7662CE59B4100309` FOREIGN KEY (`appuser_id`) REFERENCES `m_appuser` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_appuser_role` --- - -LOCK TABLES `m_appuser_role` WRITE; -/*!40000 ALTER TABLE `m_appuser_role` DISABLE KEYS */; -INSERT INTO `m_appuser_role` VALUES (1,1); -/*!40000 ALTER TABLE `m_appuser_role` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_calendar` --- - -DROP TABLE IF EXISTS `m_calendar`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_calendar` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `title` varchar(50) NOT NULL, - `description` varchar(100) DEFAULT NULL, - `location` varchar(50) DEFAULT NULL, - `start_date` date NOT NULL, - `end_date` date DEFAULT NULL, - `duration` smallint(6) DEFAULT NULL, - `calendar_type_enum` smallint(5) NOT NULL, - `repeating` tinyint(1) NOT NULL DEFAULT '0', - `recurrence` varchar(100) DEFAULT NULL, - `remind_by_enum` smallint(5) DEFAULT NULL, - `first_reminder` smallint(11) DEFAULT NULL, - `second_reminder` smallint(11) DEFAULT NULL, - `createdby_id` bigint(20) DEFAULT NULL, - `lastmodifiedby_id` bigint(20) DEFAULT NULL, - `created_date` datetime DEFAULT NULL, - `lastmodified_date` datetime DEFAULT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_calendar` --- - -LOCK TABLES `m_calendar` WRITE; -/*!40000 ALTER TABLE `m_calendar` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_calendar` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_calendar_instance` --- - -DROP TABLE IF EXISTS `m_calendar_instance`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_calendar_instance` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `calendar_id` bigint(20) NOT NULL, - `entity_id` bigint(20) NOT NULL, - `entity_type_enum` smallint(5) NOT NULL, - PRIMARY KEY (`id`), - KEY `FK_m_calendar_m_calendar_instance` (`calendar_id`), - CONSTRAINT `FK_m_calendar_m_calendar_instance` FOREIGN KEY (`calendar_id`) REFERENCES `m_calendar` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_calendar_instance` --- - -LOCK TABLES `m_calendar_instance` WRITE; -/*!40000 ALTER TABLE `m_calendar_instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_calendar_instance` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_charge` --- - -DROP TABLE IF EXISTS `m_charge`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_charge` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `name` varchar(100) DEFAULT NULL, - `currency_code` varchar(3) NOT NULL, - `charge_applies_to_enum` smallint(5) NOT NULL, - `charge_time_enum` smallint(5) NOT NULL, - `charge_calculation_enum` smallint(5) NOT NULL, - `amount` decimal(19,6) NOT NULL, - `is_penalty` tinyint(1) NOT NULL DEFAULT '0', - `is_active` tinyint(1) NOT NULL, - `is_deleted` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_charge` --- - -LOCK TABLES `m_charge` WRITE; -/*!40000 ALTER TABLE `m_charge` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_charge` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_client` --- - -DROP TABLE IF EXISTS `m_client`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_client` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `account_no` varchar(20) NOT NULL, - `office_id` bigint(20) NOT NULL, - `external_id` varchar(100) DEFAULT NULL, - `firstname` varchar(50) DEFAULT NULL, - `middlename` varchar(50) DEFAULT NULL, - `lastname` varchar(50) DEFAULT NULL, - `fullname` varchar(100) DEFAULT NULL, - `display_name` varchar(100) NOT NULL, - `image_key` varchar(500) DEFAULT NULL, - `joined_date` date DEFAULT NULL, - `is_deleted` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `account_no_UNIQUE` (`account_no`), - UNIQUE KEY `external_id` (`external_id`), - KEY `FKCE00CAB3E0DD567A` (`office_id`), - CONSTRAINT `FKCE00CAB3E0DD567A` FOREIGN KEY (`office_id`) REFERENCES `m_office` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_client` --- - -LOCK TABLES `m_client` WRITE; -/*!40000 ALTER TABLE `m_client` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_client` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_client_identifier` --- - -DROP TABLE IF EXISTS `m_client_identifier`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_client_identifier` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `client_id` bigint(20) NOT NULL, - `document_type_id` int(11) NOT NULL, - `document_key` varchar(50) NOT NULL, - `description` varchar(500) DEFAULT NULL, - `createdby_id` bigint(20) DEFAULT NULL, - `lastmodifiedby_id` bigint(20) DEFAULT NULL, - `created_date` datetime DEFAULT NULL, - `lastmodified_date` datetime DEFAULT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `unique_identifier_key` (`document_type_id`,`document_key`), - UNIQUE KEY `unique_client_identifier` (`client_id`,`document_type_id`), - KEY `FK_m_client_document_m_client` (`client_id`), - KEY `FK_m_client_document_m_code_value` (`document_type_id`), - CONSTRAINT `FK_m_client_document_m_client` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`), - CONSTRAINT `FK_m_client_document_m_code_value` FOREIGN KEY (`document_type_id`) REFERENCES `m_code_value` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_client_identifier` --- - -LOCK TABLES `m_client_identifier` WRITE; -/*!40000 ALTER TABLE `m_client_identifier` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_client_identifier` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_code` --- - -DROP TABLE IF EXISTS `m_code`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_code` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `code_name` varchar(100) DEFAULT NULL, - `is_system_defined` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `code_name` (`code_name`) -) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_code` --- - -LOCK TABLES `m_code` WRITE; -/*!40000 ALTER TABLE `m_code` DISABLE KEYS */; -INSERT INTO `m_code` VALUES (1,'Customer Identifier',1),(2,'LoanCollateral',1),(3,'LoanPurpose',1),(4,'Gender',1),(5,'YesNo',1),(6,'Education',1); -/*!40000 ALTER TABLE `m_code` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_code_value` --- - -DROP TABLE IF EXISTS `m_code_value`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_code_value` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `code_id` int(11) NOT NULL, - `code_value` varchar(100) DEFAULT NULL, - `order_position` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `code_value` (`code_id`,`code_value`), - KEY `FKCFCEA42640BE071Z` (`code_id`), - CONSTRAINT `FKCFCEA42640BE071Z` FOREIGN KEY (`code_id`) REFERENCES `m_code` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_code_value` --- - -LOCK TABLES `m_code_value` WRITE; -/*!40000 ALTER TABLE `m_code_value` DISABLE KEYS */; -INSERT INTO `m_code_value` VALUES (1,1,'Passport',1),(2,1,'Id',1),(3,1,'Drivers License',2),(4,1,'Any Other Id Type',3),(5,4,'option.Male',1),(6,4,'option.Female',5),(7,5,'option.Yes',1),(8,5,'option.No',7),(9,6,'Primary',1),(10,6,'Secondary',9),(11,6,'University',10); -/*!40000 ALTER TABLE `m_code_value` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_currency` --- - -DROP TABLE IF EXISTS `m_currency`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_currency` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `code` varchar(3) NOT NULL, - `decimal_places` smallint(5) NOT NULL, - `display_symbol` varchar(10) DEFAULT NULL, - `name` varchar(50) NOT NULL, - `internationalized_name_code` varchar(50) NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `code` (`code`) -) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_currency` --- - -LOCK TABLES `m_currency` WRITE; -/*!40000 ALTER TABLE `m_currency` DISABLE KEYS */; -INSERT INTO `m_currency` VALUES (1,'AED',2,NULL,'UAE Dirham','currency.AED'),(2,'AFN',2,NULL,'Afghanistan Afghani','currency.AFN'),(3,'ALL',2,NULL,'Albanian Lek','currency.ALL'),(4,'AMD',2,NULL,'Armenian Dram','currency.AMD'),(5,'ANG',2,NULL,'Netherlands Antillian Guilder','currency.ANG'),(6,'AOA',2,NULL,'Angolan Kwanza','currency.AOA'),(7,'ARS',2,'$','Argentine Peso','currency.ARS'),(8,'AUD',2,'A$','Australian Dollar','currency.AUD'),(9,'AWG',2,NULL,'Aruban Guilder','currency.AWG'),(10,'AZM',2,NULL,'Azerbaijanian Manat','currency.AZM'),(11,'BAM',2,NULL,'Bosnia and Herzegovina Convertible Marks','currency.BAM'),(12,'BBD',2,NULL,'Barbados Dollar','currency.BBD'),(13,'BDT',2,NULL,'Bangladesh Taka','currency.BDT'),(14,'BGN',2,NULL,'Bulgarian Lev','currency.BGN'),(15,'BHD',3,NULL,'Bahraini Dinar','currency.BHD'),(16,'BIF',0,NULL,'Burundi Franc','currency.BIF'),(17,'BMD',2,NULL,'Bermudian Dollar','currency.BMD'),(18,'BND',2,'B$','Brunei Dollar','currency.BND'),(19,'BOB',2,'Bs.','Bolivian Boliviano','currency.BOB'),(20,'BRL',2,'R$','Brazilian Real','currency.BRL'),(21,'BSD',2,NULL,'Bahamian Dollar','currency.BSD'),(22,'BTN',2,NULL,'Bhutan Ngultrum','currency.BTN'),(23,'BWP',2,NULL,'Botswana Pula','currency.BWP'),(24,'BYR',0,NULL,'Belarussian Ruble','currency.BYR'),(25,'BZD',2,'BZ$','Belize Dollar','currency.BZD'),(26,'CAD',2,NULL,'Canadian Dollar','currency.CAD'),(27,'CDF',2,NULL,'Franc Congolais','currency.CDF'),(28,'CHF',2,NULL,'Swiss Franc','currency.CHF'),(29,'CLP',0,'$','Chilean Peso','currency.CLP'),(30,'CNY',2,NULL,'Chinese Yuan Renminbi','currency.CNY'),(31,'COP',2,'$','Colombian Peso','currency.COP'),(32,'CRC',2,'â¡','Costa Rican Colon','currency.CRC'),(33,'CSD',2,NULL,'Serbian Dinar','currency.CSD'),(34,'CUP',2,'$MN','Cuban Peso','currency.CUP'),(35,'CVE',2,NULL,'Cape Verde Escudo','currency.CVE'),(36,'CYP',2,NULL,'Cyprus Pound','currency.CYP'),(37,'CZK',2,NULL,'Czech Koruna','currency.CZK'),(38,'DJF',0,NULL,'Djibouti Franc','currency.DJF'),(39,'DKK',2,NU LL,'Danish Krone','currency.DKK'),(40,'DOP',2,'RD$','Dominican Peso','currency.DOP'),(41,'DZD',2,NULL,'Algerian Dinar','currency.DZD'),(42,'EEK',2,NULL,'Estonian Kroon','currency.EEK'),(43,'EGP',2,NULL,'Egyptian Pound','currency.EGP'),(44,'ERN',2,NULL,'Eritrea Nafka','currency.ERN'),(45,'ETB',2,NULL,'Ethiopian Birr','currency.ETB'),(46,'EUR',2,'â¬','Euro','currency.EUR'),(47,'FJD',2,NULL,'Fiji Dollar','currency.FJD'),(48,'FKP',2,NULL,'Falkland Islands Pound','currency.FKP'),(49,'GBP',2,NULL,'Pound Sterling','currency.GBP'),(50,'GEL',2,NULL,'Georgian Lari','currency.GEL'),(51,'GHC',2,'GHc','Ghana Cedi','currency.GHC'),(52,'GIP',2,NULL,'Gibraltar Pound','currency.GIP'),(53,'GMD',2,NULL,'Gambian Dalasi','currency.GMD'),(54,'GNF',0,NULL,'Guinea Franc','currency.GNF'),(55,'GTQ',2,'Q','Guatemala Quetzal','currency.GTQ'),(56,'GYD',2,NULL,'Guyana Dollar','currency.GYD'),(57,'HKD',2,NULL,'Hong Kong Dollar','currency.HKD'),(58,'HNL',2,'L','Honduras Lempira','currency.HNL'),(59,'HRK',2,NULL,' Croatian Kuna','currency.HRK'),(60,'HTG',2,'G','Haiti Gourde','currency.HTG'),(61,'HUF',2,NULL,'Hungarian Forint','currency.HUF'),(62,'IDR',2,NULL,'Indonesian Rupiah','currency.IDR'),(63,'ILS',2,NULL,'New Israeli Shekel','currency.ILS'),(64,'INR',2,'â¹','Indian Rupee','currency.INR'),(65,'IQD',3,NULL,'Iraqi Dinar','currency.IQD'),(66,'IRR',2,NULL,'Iranian Rial','currency.IRR'),(67,'ISK',0,NULL,'Iceland Krona','currency.ISK'),(68,'JMD',2,NULL,'Jamaican Dollar','currency.JMD'),(69,'JOD',3,NULL,'Jordanian Dinar','currency.JOD'),(70,'JPY',0,NULL,'Japanese Yen','currency.JPY'),(71,'KES',2,'KSh','Kenyan Shilling','currency.KES'),(72,'KGS',2,NULL,'Kyrgyzstan Som','currency.KGS'),(73,'KHR',2,NULL,'Cambodia Riel','currency.KHR'),(74,'KMF',0,NULL,'Comoro Franc','currency.KMF'),(75,'KPW',2,NULL,'North Korean Won','currency.KPW'),(76,'KRW',0,NULL,'Korean Won','currency.KRW'),(77,'KWD',3,NULL,'Kuwaiti Dinar','currency.KWD'),(78,'KYD',2,NULL,'Cayman Islands Dollar','currency.KYD'),(79,'KZT',2,NU LL,'Kazakhstan Tenge','currency.KZT'),(80,'LAK',2,NULL,'Lao Kip','currency.LAK'),(81,'LBP',2,'L£','Lebanese Pound','currency.LBP'),(82,'LKR',2,NULL,'Sri Lanka Rupee','currency.LKR'),(83,'LRD',2,NULL,'Liberian Dollar','currency.LRD'),(84,'LSL',2,NULL,'Lesotho Loti','currency.LSL'),(85,'LTL',2,NULL,'Lithuanian Litas','currency.LTL'),(86,'LVL',2,NULL,'Latvian Lats','currency.LVL'),(87,'LYD',3,NULL,'Libyan Dinar','currency.LYD'),(88,'MAD',2,NULL,'Moroccan Dirham','currency.MAD'),(89,'MDL',2,NULL,'Moldovan Leu','currency.MDL'),(90,'MGA',2,NULL,'Malagasy Ariary','currency.MGA'),(91,'MKD',2,NULL,'Macedonian Denar','currency.MKD'),(92,'MMK',2,'K','Myanmar Kyat','currency.MMK'),(93,'MNT',2,NULL,'Mongolian Tugrik','currency.MNT'),(94,'MOP',2,NULL,'Macau Pataca','currency.MOP'),(95,'MRO',2,NULL,'Mauritania Ouguiya','currency.MRO'),(96,'MTL',2,NULL,'Maltese Lira','currency.MTL'),(97,'MUR',2,NULL,'Mauritius Rupee','currency.MUR'),(98,'MVR',2,NULL,'Maldives Rufiyaa','currency.MVR'),(99,'MWK',2,N ULL,'Malawi Kwacha','currency.MWK'),(100,'MXN',2,'$','Mexican Peso','currency.MXN'),(101,'MYR',2,NULL,'Malaysian Ringgit','currency.MYR'),(102,'MZM',2,NULL,'Mozambique Metical','currency.MZM'),(103,'NAD',2,NULL,'Namibia Dollar','currency.NAD'),(104,'NGN',2,NULL,'Nigerian Naira','currency.NGN'),(105,'NIO',2,'C$','Nicaragua Cordoba Oro','currency.NIO'),(106,'NOK',2,NULL,'Norwegian Krone','currency.NOK'),(107,'NPR',2,NULL,'Nepalese Rupee','currency.NPR'),(108,'NZD',2,NULL,'New Zealand Dollar','currency.NZD'),(109,'OMR',3,NULL,'Rial Omani','currency.OMR'),(110,'PAB',2,'B/.','Panama Balboa','currency.PAB'),(111,'PEN',2,'S/.','Peruvian Nuevo Sol','currency.PEN'),(112,'PGK',2,NULL,'Papua New Guinea Kina','currency.PGK'),(113,'PHP',2,NULL,'Philippine Peso','currency.PHP'),(114,'PKR',2,NULL,'Pakistan Rupee','currency.PKR'),(115,'PLN',2,NULL,'Polish Zloty','currency.PLN'),(116,'PYG',0,'â²','Paraguayan Guarani','currency.PYG'),(117,'QAR',2,NULL,'Qatari Rial','currency.QAR'),(118,'RON',2,NULL, 'Romanian Leu','currency.RON'),(119,'RUB',2,NULL,'Russian Ruble','currency.RUB'),(120,'RWF',0,NULL,'Rwanda Franc','currency.RWF'),(121,'SAR',2,NULL,'Saudi Riyal','currency.SAR'),(122,'SBD',2,NULL,'Solomon Islands Dollar','currency.SBD'),(123,'SCR',2,NULL,'Seychelles Rupee','currency.SCR'),(124,'SDD',2,NULL,'Sudanese Dinar','currency.SDD'),(125,'SEK',2,NULL,'Swedish Krona','currency.SEK'),(126,'SGD',2,NULL,'Singapore Dollar','currency.SGD'),(127,'SHP',2,NULL,'St Helena Pound','currency.SHP'),(128,'SIT',2,NULL,'Slovenian Tolar','currency.SIT'),(129,'SKK',2,NULL,'Slovak Koruna','currency.SKK'),(130,'SLL',2,NULL,'Sierra Leone Leone','currency.SLL'),(131,'SOS',2,NULL,'Somali Shilling','currency.SOS'),(132,'SRD',2,NULL,'Surinam Dollar','currency.SRD'),(133,'STD',2,NULL,'Sao Tome and Principe Dobra','currency.STD'),(134,'SVC',2,NULL,'El Salvador Colon','currency.SVC'),(135,'SYP',2,NULL,'Syrian Pound','currency.SYP'),(136,'SZL',2,NULL,'Swaziland Lilangeni','currency.SZL'),(137,'THB',2,NULL, 'Thai Baht','currency.THB'),(138,'TJS',2,NULL,'Tajik Somoni','currency.TJS'),(139,'TMM',2,NULL,'Turkmenistan Manat','currency.TMM'),(140,'TND',3,'DT','Tunisian Dinar','currency.TND'),(141,'TOP',2,NULL,'Tonga Pa\'anga','currency.TOP'),(142,'TRY',2,NULL,'Turkish Lira','currency.TRY'),(143,'TTD',2,NULL,'Trinidad and Tobago Dollar','currency.TTD'),(144,'TWD',2,NULL,'New Taiwan Dollar','currency.TWD'),(145,'TZS',2,NULL,'Tanzanian Shilling','currency.TZS'),(146,'UAH',2,NULL,'Ukraine Hryvnia','currency.UAH'),(147,'UGX',2,'USh','Uganda Shilling','currency.UGX'),(148,'USD',2,'$','US Dollar','currency.USD'),(149,'UYU',2,'$U','Peso Uruguayo','currency.UYU'),(150,'UZS',2,NULL,'Uzbekistan Sum','currency.UZS'),(151,'VEB',2,'Bs.F.','Venezuelan Bolivar','currency.VEB'),(152,'VND',2,NULL,'Vietnamese Dong','currency.VND'),(153,'VUV',0,NULL,'Vanuatu Vatu','currency.VUV'),(154,'WST',2,NULL,'Samoa Tala','currency.WST'),(155,'XAF',0,NULL,'CFA Franc BEAC','currency.XAF'),(156,'XCD',2,NULL,'East Caribbean Dollar','currency.XCD'),(157,'XDR',5,NULL,'SDR (Special Drawing Rights)','currency.XDR'),(158,'XOF',0,'CFA','CFA Franc BCEAO','currency.XOF'),(159,'XPF',0,NULL,'CFP Franc','currency.XPF'),(160,'YER',2,NULL,'Yemeni Rial','currency.YER'),(161,'ZAR',2,'R','South African Rand','currency.ZAR'),(162,'ZMK',2,NULL,'Zambian Kwacha','currency.ZMK'),(163,'ZWD',2,NULL,'Zimbabwe Dollar','currency.ZWD'); -/*!40000 ALTER TABLE `m_currency` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_document` --- - -DROP TABLE IF EXISTS `m_document`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_document` ( - `id` int(20) NOT NULL AUTO_INCREMENT, - `parent_entity_type` varchar(50) NOT NULL, - `parent_entity_id` int(20) NOT NULL DEFAULT '0', - `name` varchar(250) NOT NULL, - `file_name` varchar(250) NOT NULL, - `size` int(20) DEFAULT '0', - `type` varchar(50) DEFAULT NULL, - `description` varchar(1000) DEFAULT NULL, - `location` varchar(500) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_document` --- - -LOCK TABLES `m_document` WRITE; -/*!40000 ALTER TABLE `m_document` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_document` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_fund` --- - -DROP TABLE IF EXISTS `m_fund`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_fund` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `name` varchar(255) DEFAULT NULL, - `external_id` varchar(100) DEFAULT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `fund_name_org` (`name`), - UNIQUE KEY `fund_externalid_org` (`external_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_fund` --- - -LOCK TABLES `m_fund` WRITE; -/*!40000 ALTER TABLE `m_fund` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_fund` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_group` --- - -DROP TABLE IF EXISTS `m_group`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_group` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `office_id` bigint(20) NOT NULL, - `staff_id` bigint(20) DEFAULT NULL, - `parent_id` bigint(20) DEFAULT NULL, - `level_Id` int(11) NOT NULL, - `hierarchy` varchar(100) DEFAULT NULL, - `name` varchar(100) NOT NULL, - `external_id` varchar(100) DEFAULT NULL, - `is_deleted` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `name` (`name`,`level_Id`), - UNIQUE KEY `external_id` (`external_id`,`level_Id`), - KEY `office_id` (`office_id`), - KEY `staff_id` (`staff_id`), - KEY `Parent_Id_reference` (`parent_id`), - KEY `FK_m_group_level` (`level_Id`), - CONSTRAINT `m_group_ibfk_1` FOREIGN KEY (`office_id`) REFERENCES `m_office` (`id`), - CONSTRAINT `Parent_Id_reference` FOREIGN KEY (`parent_id`) REFERENCES `m_group` (`id`), - CONSTRAINT `FK_m_group_level` FOREIGN KEY (`level_Id`) REFERENCES `m_group_level` (`id`), - CONSTRAINT `FK_m_group_m_staff` FOREIGN KEY (`staff_id`) REFERENCES `m_staff` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_group` --- - -LOCK TABLES `m_group` WRITE; -/*!40000 ALTER TABLE `m_group` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_group` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_group_client` --- - -DROP TABLE IF EXISTS `m_group_client`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_group_client` ( - `group_id` bigint(20) NOT NULL, - `client_id` bigint(20) NOT NULL, - PRIMARY KEY (`group_id`,`client_id`), - KEY `client_id` (`client_id`), - CONSTRAINT `m_group_client_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `m_group` (`id`), - CONSTRAINT `m_group_client_ibfk_2` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_group_client` --- - -LOCK TABLES `m_group_client` WRITE; -/*!40000 ALTER TABLE `m_group_client` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_group_client` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_group_level` --- - -DROP TABLE IF EXISTS `m_group_level`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_group_level` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `parent_id` int(11) DEFAULT NULL, - `super_parent` tinyint(1) NOT NULL, - `level_name` varchar(100) NOT NULL, - `recursable` tinyint(1) NOT NULL, - `can_have_clients` tinyint(1) NOT NULL, - PRIMARY KEY (`id`), - KEY `Parent_levelId_reference` (`parent_id`), - CONSTRAINT `Parent_levelId_reference` FOREIGN KEY (`parent_id`) REFERENCES `m_group_level` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_group_level` --- - -LOCK TABLES `m_group_level` WRITE; -/*!40000 ALTER TABLE `m_group_level` DISABLE KEYS */; -INSERT INTO `m_group_level` VALUES (1,NULL,1,'Center',1,0),(2,1,0,'Group',0,1); -/*!40000 ALTER TABLE `m_group_level` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_guarantor` --- - -DROP TABLE IF EXISTS `m_guarantor`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_guarantor` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `loan_id` bigint(20) NOT NULL, - `type_enum` smallint(5) NOT NULL, - `entity_id` bigint(20) DEFAULT NULL, - `firstname` varchar(50) DEFAULT NULL, - `lastname` varchar(50) DEFAULT NULL, - `dob` date DEFAULT NULL, - `address_line_1` varchar(500) DEFAULT NULL, - `address_line_2` varchar(500) DEFAULT NULL, - `city` varchar(50) DEFAULT NULL, - `state` varchar(50) DEFAULT NULL, - `country` varchar(50) DEFAULT NULL, - `zip` varchar(20) DEFAULT NULL, - `house_phone_number` varchar(20) DEFAULT NULL, - `mobile_number` varchar(20) DEFAULT NULL, - `comment` varchar(500) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FK_m_guarantor_m_loan` (`loan_id`), - CONSTRAINT `FK_m_guarantor_m_loan` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_guarantor` --- - -LOCK TABLES `m_guarantor` WRITE; -/*!40000 ALTER TABLE `m_guarantor` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_guarantor` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan` --- - -DROP TABLE IF EXISTS `m_loan`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `account_no` varchar(20) NOT NULL, - `external_id` varchar(100) DEFAULT NULL, - `client_id` bigint(20) DEFAULT NULL, - `group_id` bigint(20) DEFAULT NULL, - `product_id` bigint(20) DEFAULT NULL, - `fund_id` bigint(20) DEFAULT NULL, - `loan_officer_id` bigint(20) DEFAULT NULL, - `loanpurpose_cv_id` int(11) DEFAULT NULL, - `loan_status_id` smallint(5) NOT NULL, - `currency_code` varchar(3) NOT NULL, - `currency_digits` smallint(5) NOT NULL, - `principal_amount` decimal(19,6) NOT NULL, - `arrearstolerance_amount` decimal(19,6) DEFAULT NULL, - `nominal_interest_rate_per_period` decimal(19,6) NOT NULL, - `interest_period_frequency_enum` smallint(5) NOT NULL, - `annual_nominal_interest_rate` decimal(19,6) NOT NULL, - `interest_method_enum` smallint(5) NOT NULL, - `interest_calculated_in_period_enum` smallint(5) NOT NULL DEFAULT '1', - `term_frequency` smallint(5) NOT NULL DEFAULT '0', - `term_period_frequency_enum` smallint(5) NOT NULL DEFAULT '2', - `repay_every` smallint(5) NOT NULL, - `repayment_period_frequency_enum` smallint(5) NOT NULL, - `number_of_repayments` smallint(5) NOT NULL, - `amortization_method_enum` smallint(5) NOT NULL, - `submittedon_date` date DEFAULT NULL, - `submittedon_userid` bigint(20) DEFAULT NULL, - `approvedon_date` date DEFAULT NULL, - `approvedon_userid` bigint(20) DEFAULT NULL, - `expected_disbursedon_date` date DEFAULT NULL, - `expected_firstrepaymenton_date` date DEFAULT NULL, - `interest_calculated_from_date` date DEFAULT NULL, - `disbursedon_date` date DEFAULT NULL, - `disbursedon_userid` bigint(20) DEFAULT NULL, - `expected_maturedon_date` date DEFAULT NULL, - `maturedon_date` date DEFAULT NULL, - `closedon_date` date DEFAULT NULL, - `closedon_userid` bigint(20) DEFAULT NULL, - `total_charges_due_at_disbursement_derived` decimal(19,6) DEFAULT NULL, - `principal_disbursed_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `principal_repaid_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `principal_writtenoff_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `principal_outstanding_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `interest_charged_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `interest_repaid_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `interest_waived_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `interest_writtenoff_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `interest_outstanding_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `fee_charges_charged_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `fee_charges_repaid_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `fee_charges_waived_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `fee_charges_writtenoff_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `fee_charges_outstanding_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `penalty_charges_charged_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `penalty_charges_repaid_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `penalty_charges_waived_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `penalty_charges_writtenoff_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `penalty_charges_outstanding_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_expected_repayment_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_repayment_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_expected_costofloan_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_costofloan_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_waived_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_writtenoff_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_outstanding_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `rejectedon_date` date DEFAULT NULL, - `rejectedon_userid` bigint(20) DEFAULT NULL, - `rescheduledon_date` date DEFAULT NULL, - `withdrawnon_date` date DEFAULT NULL, - `withdrawnon_userid` bigint(20) DEFAULT NULL, - `writtenoffon_date` date DEFAULT NULL, - `loan_transaction_strategy_id` bigint(20) DEFAULT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `loan_account_no_UNIQUE` (`account_no`), - UNIQUE KEY `loan_externalid_UNIQUE` (`external_id`), - KEY `FKB6F935D87179A0CB` (`client_id`), - KEY `FKB6F935D8C8D4B434` (`product_id`), - KEY `FK7C885877240145` (`fund_id`), - KEY `FK_loan_ltp_strategy` (`loan_transaction_strategy_id`), - KEY `FK_m_loan_m_staff` (`loan_officer_id`), - KEY `group_id` (`group_id`), - KEY `FK_m_loanpurpose_codevalue` (`loanpurpose_cv_id`), - KEY `FK_submittedon_userid` (`submittedon_userid`), - KEY `FK_approvedon_userid` (`approvedon_userid`), - KEY `FK_rejectedon_userid` (`rejectedon_userid`), - KEY `FK_withdrawnon_userid` (`withdrawnon_userid`), - KEY `FK_disbursedon_userid` (`disbursedon_userid`), - KEY `FK_closedon_userid` (`closedon_userid`), - CONSTRAINT `FK7C885877240145` FOREIGN KEY (`fund_id`) REFERENCES `m_fund` (`id`), - CONSTRAINT `FKB6F935D87179A0CB` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`), - CONSTRAINT `FKB6F935D8C8D4B434` FOREIGN KEY (`product_id`) REFERENCES `m_product_loan` (`id`), - CONSTRAINT `FK_approvedon_userid` FOREIGN KEY (`approvedon_userid`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_closedon_userid` FOREIGN KEY (`closedon_userid`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_disbursedon_userid` FOREIGN KEY (`disbursedon_userid`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_loan_ltp_strategy` FOREIGN KEY (`loan_transaction_strategy_id`) REFERENCES `ref_loan_transaction_processing_strategy` (`id`), - CONSTRAINT `FK_m_loanpurpose_codevalue` FOREIGN KEY (`loanpurpose_cv_id`) REFERENCES `m_code_value` (`id`), - CONSTRAINT `FK_m_loan_m_staff` FOREIGN KEY (`loan_officer_id`) REFERENCES `m_staff` (`id`), - CONSTRAINT `FK_rejectedon_userid` FOREIGN KEY (`rejectedon_userid`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_submittedon_userid` FOREIGN KEY (`submittedon_userid`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK_withdrawnon_userid` FOREIGN KEY (`withdrawnon_userid`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `m_loan_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `m_group` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan` --- - -LOCK TABLES `m_loan` WRITE; -/*!40000 ALTER TABLE `m_loan` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan_arrears_aging` --- - -DROP TABLE IF EXISTS `m_loan_arrears_aging`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan_arrears_aging` ( - `loan_id` bigint(20) NOT NULL AUTO_INCREMENT, - `principal_overdue_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `interest_overdue_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `fee_charges_overdue_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `penalty_charges_overdue_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `total_overdue_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `overdue_since_date_derived` date DEFAULT NULL, - PRIMARY KEY (`loan_id`), - CONSTRAINT `m_loan_arrears_aging_ibfk_1` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan_arrears_aging` --- - -LOCK TABLES `m_loan_arrears_aging` WRITE; -/*!40000 ALTER TABLE `m_loan_arrears_aging` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan_arrears_aging` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan_charge` --- - -DROP TABLE IF EXISTS `m_loan_charge`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan_charge` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `loan_id` bigint(20) NOT NULL, - `charge_id` bigint(20) NOT NULL, - `is_penalty` tinyint(1) NOT NULL DEFAULT '0', - `charge_time_enum` smallint(5) NOT NULL, - `due_for_collection_as_of_date` date DEFAULT NULL, - `charge_calculation_enum` smallint(5) NOT NULL, - `calculation_percentage` decimal(19,6) DEFAULT NULL, - `calculation_on_amount` decimal(19,6) DEFAULT NULL, - `amount` decimal(19,6) NOT NULL, - `amount_paid_derived` decimal(19,6) DEFAULT NULL, - `amount_waived_derived` decimal(19,6) DEFAULT NULL, - `amount_writtenoff_derived` decimal(19,6) DEFAULT NULL, - `amount_outstanding_derived` decimal(19,6) NOT NULL DEFAULT '0.000000', - `is_paid_derived` tinyint(1) NOT NULL DEFAULT '0', - `waived` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`id`), - KEY `charge_id` (`charge_id`), - KEY `m_loan_charge_ibfk_2` (`loan_id`), - CONSTRAINT `m_loan_charge_ibfk_1` FOREIGN KEY (`charge_id`) REFERENCES `m_charge` (`id`), - CONSTRAINT `m_loan_charge_ibfk_2` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan_charge` --- - -LOCK TABLES `m_loan_charge` WRITE; -/*!40000 ALTER TABLE `m_loan_charge` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan_charge` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan_collateral` --- - -DROP TABLE IF EXISTS `m_loan_collateral`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan_collateral` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `loan_id` bigint(20) NOT NULL, - `type_cv_id` int(11) NOT NULL, - `description` varchar(500) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FK_collateral_m_loan` (`loan_id`), - KEY `FK_collateral_code_value` (`type_cv_id`), - CONSTRAINT `FK_collateral_m_loan` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`), - CONSTRAINT `FK_collateral_code_value` FOREIGN KEY (`type_cv_id`) REFERENCES `m_code_value` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan_collateral` --- - -LOCK TABLES `m_loan_collateral` WRITE; -/*!40000 ALTER TABLE `m_loan_collateral` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan_collateral` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan_officer_assignment_history` --- - -DROP TABLE IF EXISTS `m_loan_officer_assignment_history`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan_officer_assignment_history` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `loan_id` bigint(20) NOT NULL, - `loan_officer_id` bigint(20) DEFAULT NULL, - `start_date` date NOT NULL, - `end_date` date DEFAULT NULL, - `createdby_id` bigint(20) DEFAULT NULL, - `created_date` datetime DEFAULT NULL, - `lastmodified_date` datetime DEFAULT NULL, - `lastmodifiedby_id` bigint(20) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `fk_m_loan_officer_assignment_history_0001` (`loan_id`), - KEY `fk_m_loan_officer_assignment_history_0002` (`loan_officer_id`), - CONSTRAINT `fk_m_loan_officer_assignment_history_0001` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`), - CONSTRAINT `fk_m_loan_officer_assignment_history_0002` FOREIGN KEY (`loan_officer_id`) REFERENCES `m_staff` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan_officer_assignment_history` --- - -LOCK TABLES `m_loan_officer_assignment_history` WRITE; -/*!40000 ALTER TABLE `m_loan_officer_assignment_history` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan_officer_assignment_history` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan_repayment_schedule` --- - -DROP TABLE IF EXISTS `m_loan_repayment_schedule`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan_repayment_schedule` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `loan_id` bigint(20) NOT NULL, - `fromdate` date DEFAULT NULL, - `duedate` date NOT NULL, - `installment` smallint(5) NOT NULL, - `principal_amount` decimal(19,6) DEFAULT NULL, - `principal_completed_derived` decimal(19,6) DEFAULT NULL, - `principal_writtenoff_derived` decimal(19,6) DEFAULT NULL, - `interest_amount` decimal(19,6) DEFAULT NULL, - `interest_completed_derived` decimal(19,6) DEFAULT NULL, - `interest_writtenoff_derived` decimal(19,6) DEFAULT NULL, - `fee_charges_amount` decimal(19,6) DEFAULT NULL, - `fee_charges_completed_derived` decimal(19,6) DEFAULT NULL, - `fee_charges_writtenoff_derived` decimal(19,6) DEFAULT NULL, - `fee_charges_waived_derived` decimal(19,6) DEFAULT NULL, - `penalty_charges_amount` decimal(19,6) DEFAULT NULL, - `penalty_charges_completed_derived` decimal(19,6) DEFAULT NULL, - `penalty_charges_writtenoff_derived` decimal(19,6) DEFAULT NULL, - `penalty_charges_waived_derived` decimal(19,6) DEFAULT NULL, - `completed_derived` bit(1) NOT NULL, - `createdby_id` bigint(20) DEFAULT NULL, - `created_date` datetime DEFAULT NULL, - `lastmodified_date` datetime DEFAULT NULL, - `lastmodifiedby_id` bigint(20) DEFAULT NULL, - `interest_waived_derived` decimal(19,6) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FK488B92AA40BE0710` (`loan_id`), - CONSTRAINT `FK488B92AA40BE0710` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan_repayment_schedule` --- - -LOCK TABLES `m_loan_repayment_schedule` WRITE; -/*!40000 ALTER TABLE `m_loan_repayment_schedule` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan_repayment_schedule` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_loan_transaction` --- - -DROP TABLE IF EXISTS `m_loan_transaction`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_loan_transaction` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `loan_id` bigint(20) NOT NULL, - `is_reversed` tinyint(1) NOT NULL, - `transaction_type_enum` smallint(5) NOT NULL, - `transaction_date` date NOT NULL, - `amount` decimal(19,6) NOT NULL, - `principal_portion_derived` decimal(19,6) DEFAULT NULL, - `interest_portion_derived` decimal(19,6) DEFAULT NULL, - `fee_charges_portion_derived` decimal(19,6) DEFAULT NULL, - `penalty_charges_portion_derived` decimal(19,6) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FKCFCEA42640BE0710` (`loan_id`), - CONSTRAINT `FKCFCEA42640BE0710` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_loan_transaction` --- - -LOCK TABLES `m_loan_transaction` WRITE; -/*!40000 ALTER TABLE `m_loan_transaction` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_loan_transaction` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_note` --- - -DROP TABLE IF EXISTS `m_note`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_note` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `client_id` bigint(20) DEFAULT NULL, - `group_id` bigint(20) DEFAULT NULL, - `loan_id` bigint(20) DEFAULT NULL, - `loan_transaction_id` bigint(20) DEFAULT NULL, - `note_type_enum` smallint(5) NOT NULL, - `note` varchar(1000) DEFAULT NULL, - `created_date` datetime DEFAULT NULL, - `createdby_id` bigint(20) DEFAULT NULL, - `lastmodified_date` datetime DEFAULT NULL, - `lastmodifiedby_id` bigint(20) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FK7C9708924D26803` (`loan_transaction_id`), - KEY `FK7C97089541F0A56` (`createdby_id`), - KEY `FK7C970897179A0CB` (`client_id`), - KEY `FK_m_note_m_group` (`group_id`), - KEY `FK7C970898F889C3F` (`lastmodifiedby_id`), - KEY `FK7C9708940BE0710` (`loan_id`), - CONSTRAINT `FK7C9708924D26803` FOREIGN KEY (`loan_transaction_id`) REFERENCES `m_loan_transaction` (`id`), - CONSTRAINT `FK7C9708940BE0710` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`), - CONSTRAINT `FK7C97089541F0A56` FOREIGN KEY (`createdby_id`) REFERENCES `m_appuser` (`id`), - CONSTRAINT `FK7C970897179A0CB` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`), - CONSTRAINT `FK_m_note_m_group` FOREIGN KEY (`group_id`) REFERENCES `m_group` (`id`), - CONSTRAINT `FK7C970898F889C3F` FOREIGN KEY (`lastmodifiedby_id`) REFERENCES `m_appuser` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_note` --- - -LOCK TABLES `m_note` WRITE; -/*!40000 ALTER TABLE `m_note` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_note` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_office` --- - -DROP TABLE IF EXISTS `m_office`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_office` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `parent_id` bigint(20) DEFAULT NULL, - `hierarchy` varchar(100) DEFAULT NULL, - `external_id` varchar(100) DEFAULT NULL, - `name` varchar(50) NOT NULL, - `opening_date` date NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY `name_org` (`name`), - UNIQUE KEY `externalid_org` (`external_id`), - KEY `FK2291C477E2551DCC` (`parent_id`), - CONSTRAINT `FK2291C477E2551DCC` FOREIGN KEY (`parent_id`) REFERENCES `m_office` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_office` --- - -LOCK TABLES `m_office` WRITE; -/*!40000 ALTER TABLE `m_office` DISABLE KEYS */; -INSERT INTO `m_office` VALUES (1,NULL,'.','1','Head Office','2009-01-01'); -/*!40000 ALTER TABLE `m_office` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_office_transaction` --- - -DROP TABLE IF EXISTS `m_office_transaction`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_office_transaction` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `from_office_id` bigint(20) DEFAULT NULL, - `to_office_id` bigint(20) DEFAULT NULL, - `currency_code` varchar(3) NOT NULL, - `currency_digits` int(11) NOT NULL, - `transaction_amount` decimal(19,6) NOT NULL, - `transaction_date` date NOT NULL, - `description` varchar(100) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FK1E37728B93C6C1B6` (`to_office_id`), - KEY `FK1E37728B783C5C25` (`from_office_id`), - CONSTRAINT `FK1E37728B783C5C25` FOREIGN KEY (`from_office_id`) REFERENCES `m_office` (`id`), - CONSTRAINT `FK1E37728B93C6C1B6` FOREIGN KEY (`to_office_id`) REFERENCES `m_office` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_office_transaction` --- - -LOCK TABLES `m_office_transaction` WRITE; -/*!40000 ALTER TABLE `m_office_transaction` DISABLE KEYS */; -/*!40000 ALTER TABLE `m_office_transaction` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_organisation_currency` --- - -DROP TABLE IF EXISTS `m_organisation_currency`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_organisation_currency` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `code` varchar(3) NOT NULL, - `decimal_places` smallint(5) NOT NULL, - `name` varchar(50) NOT NULL, - `display_symbol` varchar(10) DEFAULT NULL, - `internationalized_name_code` varchar(50) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_organisation_currency` --- - -LOCK TABLES `m_organisation_currency` WRITE; -/*!40000 ALTER TABLE `m_organisation_currency` DISABLE KEYS */; -INSERT INTO `m_organisation_currency` VALUES (21,'USD',2,'US Dollar','$','currency.USD'); -/*!40000 ALTER TABLE `m_organisation_currency` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_permission` --- - -DROP TABLE IF EXISTS `m_permission`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_permission` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `grouping` varchar(45) DEFAULT NULL, - `code` varchar(100) NOT NULL, - `entity_name` varchar(100) DEFAULT NULL, - `action_name` varchar(100) DEFAULT NULL, - `can_maker_checker` tinyint(1) NOT NULL DEFAULT '1', - PRIMARY KEY (`id`), - UNIQUE KEY `code` (`code`) -) ENGINE=InnoDB AUTO_INCREMENT=299 DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `m_permission` --- - -LOCK TABLES `m_permission` WRITE; -/*!40000 ALTER TABLE `m_permission` DISABLE KEYS */; -INSERT INTO `m_permission` VALUES (1,'special','ALL_FUNCTIONS',NULL,NULL,0),(2,'special','ALL_FUNCTIONS_READ',NULL,NULL,0),(3,'special','CHECKER_SUPER_USER',NULL,NULL,0),(4,'special','REPORTING_SUPER_USER',NULL,NULL,0),(5,'authorisation','READ_PERMISSION','PERMISSION','READ',0),(6,'authorisation','PERMISSIONS_ROLE','ROLE','PERMISSIONS',0),(7,'authorisation','CREATE_ROLE','ROLE','CREATE',0),(8,'authorisation','CREATE_ROLE_CHECKER','ROLE','CREATE',0),(9,'authorisation','READ_ROLE','ROLE','READ',0),(10,'authorisation','UPDATE_ROLE','ROLE','UPDATE',0),(11,'authorisation','UPDATE_ROLE_CHECKER','ROLE','UPDATE',0),(12,'authorisation','DELETE_ROLE','ROLE','DELETE',0),(13,'authorisation','DELETE_ROLE_CHECKER','ROLE','DELETE',0),(14,'authorisation','CREATE_USER','USER','CREATE',0),(15,'authorisation','CREATE_USER_CHECKER','USER','CREATE',0),(16,'authorisation','READ_USER','USER','READ',0),(17,'authorisation','UPDATE_USER','USER','UPDATE',0),(18,'authorisation','UPDATE_USER_CHECKER','USER','UP DATE',0),(19,'authorisation','DELETE_USER','USER','DELETE',0),(20,'authorisation','DELETE_USER_CHECKER','USER','DELETE',0),(21,'configuration','READ_CONFIGURATION','CONFIGURATION','READ',0),(22,'configuration','UPDATE_CONFIGURATION','CONFIGURATION','UPDATE',0),(23,'configuration','UPDATE_CONFIGURATION_CHECKER','CONFIGURATION','UPDATE',0),(24,'configuration','READ_CODE','CODE','READ',0),(25,'configuration','CREATE_CODE','CODE','CREATE',0),(26,'configuration','CREATE_CODE_CHECKER','CODE','CREATE',0),(27,'configuration','UPDATE_CODE','CODE','UPDATE',0),(28,'configuration','UPDATE_CODE_CHECKER','CODE','UPDATE',0),(29,'configuration','DELETE_CODE','CODE','DELETE',0),(30,'configuration','DELETE_CODE_CHECKER','CODE','DELETE',0),(31,'configuration','READ_CODEVALUE','CODEVALUE','READ',0),(32,'configuration','CREATE_CODEVALUE','CODEVALUE','CREATE',0),(33,'configuration','CREATE_CODEVALUE_CHECKER','CODEVALUE','CREATE',0),(34,'configuration','UPDATE_CODEVALUE','CODEVALUE','UPDATE',0),(35,'confi guration','UPDATE_CODEVALUE_CHECKER','CODEVALUE','UPDATE',0),(36,'configuration','DELETE_CODEVALUE','CODEVALUE','DELETE',0),(37,'configuration','DELETE_CODEVALUE_CHECKER','CODEVALUE','DELETE',0),(38,'configuration','READ_CURRENCY','CURRENCY','READ',0),(39,'configuration','UPDATE_CURRENCY','CURRENCY','UPDATE',0),(40,'configuration','UPDATE_CURRENCY_CHECKER','CURRENCY','UPDATE',0),(41,'configuration','UPDATE_PERMISSION','PERMISSION','UPDATE',0),(42,'configuration','UPDATE_PERMISSION_CHECKER','PERMISSION','UPDATE',0),(43,'configuration','READ_DATATABLE','DATATABLE','READ',0),(44,'configuration','REGISTER_DATATABLE','DATATABLE','REGISTER',0),(45,'configuration','REGISTER_DATATABLE_CHECKER','DATATABLE','REGISTER',0),(46,'configuration','DEREGISTER_DATATABLE','DATATABLE','DEREGISTER',0),(47,'configuration','DEREGISTER_DATATABLE_CHECKER','DATATABLE','DEREGISTER',0),(48,'configuration','READ_AUDIT','AUDIT','READ',0),(49,'configuration','CREATE_CALENDAR','CALENDAR','CREATE',0),(50,'configura tion','READ_CALENDAR','CALENDAR','READ',0),(51,'configuration','UPDATE_CALENDAR','CALENDAR','UPDATE',0),(52,'configuration','DELETE_CALENDAR','CALENDAR','DELETE',0),(53,'configuration','CREATE_CALENDAR_CHECKER','CALENDAR','CREATE',0),(54,'configuration','UPDATE_CALENDAR_CHECKER','CALENDAR','UPDATE',0),(55,'configuration','DELETE_CALENDAR_CHECKER','CALENDAR','DELETE',0),(56,'organisation','READ_MAKERCHECKER','MAKERCHECKER','READ',0),(57,'organisation','READ_CHARGE','CHARGE','READ',0),(58,'organisation','CREATE_CHARGE','CHARGE','CREATE',0),(59,'organisation','CREATE_CHARGE_CHECKER','CHARGE','CREATE',0),(60,'organisation','UPDATE_CHARGE','CHARGE','UPDATE',0),(61,'organisation','UPDATE_CHARGE_CHECKER','CHARGE','UPDATE',0),(62,'organisation','DELETE_CHARGE','CHARGE','DELETE',0),(63,'organisation','DELETE_CHARGE_CHECKER','CHARGE','DELETE',0),(64,'organisation','READ_FUND','FUND','READ',0),(65,'organisation','CREATE_FUND','FUND','CREATE',0),(66,'organisation','CREATE_FUND_CHECKER','FUND',' CREATE',0),(67,'organisation','UPDATE_FUND','FUND','UPDATE',0),(68,'organisation','UPDATE_FUND_CHECKER','FUND','UPDATE',0),(69,'organisation','DELETE_FUND','FUND','DELETE',0),(70,'organisation','DELETE_FUND_CHECKER','FUND','DELETE',0),(71,'organisation','READ_LOANPRODUCT','LOANPRODUCT','READ',0),(72,'organisation','CREATE_LOANPRODUCT','LOANPRODUCT','CREATE',0),(73,'organisation','CREATE_LOANPRODUCT_CHECKER','LOANPRODUCT','CREATE',0),(74,'organisation','UPDATE_LOANPRODUCT','LOANPRODUCT','UPDATE',0),(75,'organisation','UPDATE_LOANPRODUCT_CHECKER','LOANPRODUCT','UPDATE',0),(76,'organisation','DELETE_LOANPRODUCT','LOANPRODUCT','DELETE',0),(77,'organisation','DELETE_LOANPRODUCT_CHECKER','LOANPRODUCT','DELETE',0),(78,'organisation','READ_OFFICE','OFFICE','READ',0),(79,'organisation','CREATE_OFFICE','OFFICE','CREATE',0),(80,'organisation','CREATE_OFFICE_CHECKER','OFFICE','CREATE',0),(81,'organisation','UPDATE_OFFICE','OFFICE','UPDATE',0),(82,'organisation','UPDATE_OFFICE_CHECKER','OFFICE', 'UPDATE',0),(83,'organisation','READ_OFFICETRANSACTION','OFFICETRANSACTION','READ',0),(84,'organisation','DELETE_OFFICE_CHECKER','OFFICE','DELETE',0),(85,'organisation','CREATE_OFFICETRANSACTION','OFFICETRANSACTION','CREATE',0),(86,'organisation','CREATE_OFFICETRANSACTION_CHECKER','OFFICETRANSACTION','CREATE',0),(87,'organisation','DELETE_OFFICETRANSACTION','OFFICETRANSACTION','DELETE',0),(88,'organisation','DELETE_OFFICETRANSACTION_CHECKER','OFFICETRANSACTION','DELETE',0),(89,'organisation','READ_STAFF','STAFF','READ',0),(90,'organisation','CREATE_STAFF','STAFF','CREATE',0),(91,'organisation','CREATE_STAFF_CHECKER','STAFF','CREATE',0),(92,'organisation','UPDATE_STAFF','STAFF','UPDATE',0),(93,'organisation','UPDATE_STAFF_CHECKER','STAFF','UPDATE',0),(94,'organisation','DELETE_STAFF','STAFF','DELETE',0),(95,'organisation','DELETE_STAFF_CHECKER','STAFF','DELETE',0),(96,'organisation','READ_SAVINGSPRODUCT','SAVINGSPRODUCT','READ',0),(97,'organisation','CREATE_SAVINGSPRODUCT','SAVINGSPR ODUCT','CREATE',0),(98,'organisation','CREATE_SAVINGSPRODUCT_CHECKER','SAVINGSPRODUCT','CREATE',0),(99,'organisation','UPDATE_SAVINGSPRODUCT','SAVINGSPRODUCT','UPDATE',0),(100,'organisation','UPDATE_SAVINGSPRODUCT_CHECKER','SAVINGSPRODUCT','UPDATE',0),(101,'organisation','DELETE_SAVINGSPRODUCT','SAVINGSPRODUCT','DELETE',0),(102,'organisation','DELETE_SAVINGSPRODUCT_CHECKER','SAVINGSPRODUCT','DELETE',0),(103,'portfolio','READ_LOAN','LOAN','READ',0),(104,'portfolio','CREATE_LOAN','LOAN','CREATE',0),(105,'portfolio','CREATE_LOAN_CHECKER','LOAN','CREATE',0),(106,'portfolio','UPDATE_LOAN','LOAN','UPDATE',0),(107,'portfolio','UPDATE_LOAN_CHECKER','LOAN','UPDATE',0),(108,'portfolio','DELETE_LOAN','LOAN','DELETE',0),(109,'portfolio','DELETE_LOAN_CHECKER','LOAN','DELETE',0),(110,'portfolio','READ_CLIENT','CLIENT','READ',0),(111,'portfolio','CREATE_CLIENT','CLIENT','CREATE',0),(112,'portfolio','CREATE_CLIENT_CHECKER','CLIENT','CREATE',0),(113,'portfolio','UPDATE_CLIENT','CLIENT','UPDATE',0),( 114,'portfolio','UPDATE_CLIENT_CHECKER','CLIENT','UPDATE',0),(115,'portfolio','DELETE_CLIENT','CLIENT','DELETE',0),(116,'portfolio','DELETE_CLIENT_CHECKER','CLIENT','DELETE',0),(117,'portfolio','READ_CLIENTIMAGE','CLIENTIMAGE','READ',0),(118,'portfolio','CREATE_CLIENTIMAGE','CLIENTIMAGE','CREATE',0),(119,'portfolio','CREATE_CLIENTIMAGE_CHECKER','CLIENTIMAGE','CREATE',0),(120,'portfolio','DELETE_CLIENTIMAGE','CLIENTIMAGE','DELETE',0),(121,'portfolio','DELETE_CLIENTIMAGE_CHECKER','CLIENTIMAGE','DELETE',0),(122,'portfolio','READ_CLIENTNOTE','CLIENTNOTE','READ',0),(123,'portfolio','CREATE_CLIENTNOTE','CLIENTNOTE','CREATE',0),(124,'portfolio','CREATE_CLIENTNOTE_CHECKER','CLIENTNOTE','CREATE',0),(125,'portfolio','UPDATE_CLIENTNOTE','CLIENTNOTE','UPDATE',0),(126,'portfolio','UPDATE_CLIENTNOTE_CHECKER','CLIENTNOTE','UPDATE',0),(127,'portfolio','DELETE_CLIENTNOTE','CLIENTNOTE','DELETE',0),(128,'portfolio','DELETE_CLIENTNOTE_CHECKER','CLIENTNOTE','DELETE',0),(129,'portfolio','READ_GROUPNOTE', 'GROUPNOTE','READ',0),(130,'portfolio','CREATE_GROUPNOTE','GROUPNOTE','CREATE',0),(131,'portfolio','UPDATE_GROUPNOTE','GROUPNOTE','UPDATE',0),(132,'portfolio','DELETE_GROUPNOTE','GROUPNOTE','DELETE',0),(133,'portfolio','CREATE_GROUPNOTE_CHECKER','GROUPNOTE','CREATE',0),(134,'portfolio','UPDATE_GROUPNOTE_CHECKER','GROUPNOTE','UPDATE',0),(135,'portfolio','DELETE_GROUPNOTE_CHECKER','GROUPNOTE','DELETE',0),(136,'portfolio','READ_LOANNOTE','LOANNOTE','READ',0),(137,'portfolio','CREATE_LOANNOTE','LOANNOTE','CREATE',0),(138,'portfolio','UPDATE_LOANNOTE','LOANNOTE','UPDATE',0),(139,'portfolio','DELETE_LOANNOTE','LOANNOTE','DELETE',0),(140,'portfolio','CREATE_LOANNOTE_CHECKER','LOANNOTE','CREATE',0),(141,'portfolio','UPDATE_LOANNOTE_CHECKER','LOANNOTE','UPDATE',0),(142,'portfolio','DELETE_LOANNOTE_CHECKER','LOANNOTE','DELETE',0),(143,'portfolio','READ_LOANTRANSACTIONNOTE','LOANTRANSACTIONNOTE','READ',0),(144,'portfolio','CREATE_LOANTRANSACTIONNOTE','LOANTRANSACTIONNOTE','CREATE',0),(145,'por tfolio','UPDATE_LOANTRANSACTIONNOTE','LOANTRANSACTIONNOTE','UPDATE',0),(146,'portfolio','DELETE_LOANTRANSACTIONNOTE','LOANTRANSACTIONNOTE','DELETE',0),(147,'portfolio','CREATE_LOANTRANSACTIONNOTE_CHECKER','LOANTRANSACTIONNOTE','CREATE',0),(148,'portfolio','UPDATE_LOANTRANSACTIONNOTE_CHECKER','LOANTRANSACTIONNOTE','UPDATE',0),(149,'portfolio','DELETE_LOANTRANSACTIONNOTE_CHECKER','LOANTRANSACTIONNOTE','DELETE',0),(150,'portfolio','READ_SAVINGNOTE','SAVINGNOTE','READ',0),(151,'portfolio','CREATE_SAVINGNOTE','SAVINGNOTE','CREATE',0),(152,'portfolio','UPDATE_SAVINGNOTE','SAVINGNOTE','UPDATE',0),(153,'portfolio','DELETE_SAVINGNOTE','SAVINGNOTE','DELETE',0),(154,'portfolio','CREATE_SAVINGNOTE_CHECKER','SAVINGNOTE','CREATE',0),(155,'portfolio','UPDATE_SAVINGNOTE_CHECKER','SAVINGNOTE','UPDATE',0),(156,'portfolio','DELETE_SAVINGNOTE_CHECKER','SAVINGNOTE','DELETE',0),(157,'portfolio','READ_CLIENTIDENTIFIER','CLIENTIDENTIFIER','READ',0),(158,'portfolio','CREATE_CLIENTIDENTIFIER','CLIENTIDENTIFI ER','CREATE',0),(159,'portfolio','CREATE_CLIENTIDENTIFIER_CHECKER','CLIENTIDENTIFIER','CREATE',0),(160,'portfolio','UPDATE_CLIENTIDENTIFIER','CLIENTIDENTIFIER','UPDATE',0),(161,'portfolio','UPDATE_CLIENTIDENTIFIER_CHECKER','CLIENTIDENTIFIER','UPDATE',0),(162,'portfolio','DELETE_CLIENTIDENTIFIER','CLIENTIDENTIFIER','DELETE',0),(163,'portfolio','DELETE_CLIENTIDENTIFIER_CHECKER','CLIENTIDENTIFIER','DELETE',0),(164,'portfolio','READ_DOCUMENT','DOCUMENT','READ',0),(165,'portfolio','CREATE_DOCUMENT','DOCUMENT','CREATE',0),(166,'portfolio','CREATE_DOCUMENT_CHECKER','DOCUMENT','CREATE',0),(167,'portfolio','UPDATE_DOCUMENT','DOCUMENT','UPDATE',0),(168,'portfolio','UPDATE_DOCUMENT_CHECKER','DOCUMENT','UPDATE',0),(169,'portfolio','DELETE_DOCUMENT','DOCUMENT','DELETE',0),(170,'portfolio','DELETE_DOCUMENT_CHECKER','DOCUMENT','DELETE',0),(171,'portfolio','READ_GROUP','GROUP','READ',0),(172,'portfolio','CREATE_GROUP','GROUP','CREATE',0),(173,'portfolio','CREATE_GROUP_CHECKER','GROUP','CREATE',0),( 174,'portfolio','UPDATE_GROUP','GROUP','UPDATE',0),(175,'portfolio','UPDATE_GROUP_CHECKER','GROUP','UPDATE',0),(176,'portfolio','DELETE_GROUP','GROUP','DELETE',0),(177,'portfolio','DELETE_GROUP_CHECKER','GROUP','DELETE',0),(178,'portfolio','UNASSIGNSTAFF_GROUP','GROUP','UNASSIGNSTAFF',0),(179,'portfolio','UNASSIGNSTAFF_GROUP_CHECKER','GROUP','UNASSIGNSTAFF',0),(180,'portfolio','CREATE_LOANCHARGE','LOANCHARGE','CREATE',0),(181,'portfolio','CREATE_LOANCHARGE_CHECKER','LOANCHARGE','CREATE',0),(182,'portfolio','UPDATE_LOANCHARGE','LOANCHARGE','UPDATE',0),(183,'portfolio','UPDATE_LOANCHARGE_CHECKER','LOANCHARGE','UPDATE',0),(184,'portfolio','DELETE_LOANCHARGE','LOANCHARGE','DELETE',0),(185,'portfolio','DELETE_LOANCHARGE_CHECKER','LOANCHARGE','DELETE',0),(186,'portfolio','WAIVE_LOANCHARGE','LOANCHARGE','WAIVE',0),(187,'portfolio','WAIVE_LOANCHARGE_CHECKER','LOANCHARGE','WAIVE',0),(188,'portfolio','READ_SAVINGSACCOUNT','SAVINGSACCOUNT','READ',0),(189,'portfolio','CREATE_SAVINGSACCOUNT','SA VINGSACCOUNT','CREATE',0),(190,'portfolio','CREATE_SAVINGSACCOUNT_CHECKER','SAVINGSACCOUNT','CREATE',0),(191,'portfolio','UPDATE_SAVINGSACCOUNT','SAVINGSACCOUNT','UPDATE',0),(192,'portfolio','UPDATE_SAVINGSACCOUNT_CHECKER','SAVINGSACCOUNT','UPDATE',0),(193,'portfolio','DELETE_SAVINGSACCOUNT','SAVINGSACCOUNT','DELETE',0),(194,'portfolio','DELETE_SAVINGSACCOUNT_CHECKER','SAVINGSACCOUNT','DELETE',0),(195,'portfolio','READ_GUARANTOR','GUARANTOR','READ',0),(196,'portfolio','CREATE_GUARANTOR','GUARANTOR','CREATE',0),(197,'portfolio','CREATE_GUARANTOR_CHECKER','GUARANTOR','CREATE',0),(198,'portfolio','UPDATE_GUARANTOR','GUARANTOR','UPDATE',0),(199,'portfolio','UPDATE_GUARANTOR_CHECKER','GUARANTOR','UPDATE',0),(200,'portfolio','DELETE_GUARANTOR','GUARANTOR','DELETE',0),(201,'portfolio','DELETE_GUARANTOR_CHECKER','GUARANTOR','DELETE',0),(202,'transaction_loan','APPROVE_LOAN','LOAN','APPROVE',0),(203,'transaction_loan','APPROVEINPAST_LOAN','LOAN','APPROVEINPAST',0),(204,'transaction_loan','RE JECT_LOAN','LOAN','REJECT',0),(205,'transaction_loan','REJECTINPAST_LOAN','LOAN','REJECTINPAST',0),(206,'transaction_loan','WITHDRAW_LOAN','LOAN','WITHDRAW',0),(207,'transaction_loan','WITHDRAWINPAST_LOAN','LOAN','WITHDRAWINPAST',0),(208,'transaction_loan','APPROVALUNDO_LOAN','LOAN','APPROVALUNDO',0),(209,'transaction_loan','DISBURSE_LOAN','LOAN','DISBURSE',0),(210,'transaction_loan','DISBURSEINPAST_LOAN','LOAN','DISBURSEINPAST',0),(211,'transaction_loan','DISBURSALUNDO_LOAN','LOAN','DISBURSALUNDO',0),(212,'transaction_loan','REPAYMENT_LOAN','LOAN','REPAYMENT',0),(213,'transaction_loan','REPAYMENTINPAST_LOAN','LOAN','REPAYMENTINPAST',0),(214,'transaction_loan','ADJUST_LOAN','LOAN','ADJUST',0),(215,'transaction_loan','WAIVEINTERESTPORTION_LOAN','LOAN','WAIVEINTERESTPORTION',0),(216,'transaction_loan','WRITEOFF_LOAN','LOAN','WRITEOFF',0),(217,'transaction_loan','CLOSE_LOAN','LOAN','CLOSE',0),(218,'transaction_loan','CLOSEASRESCHEDULED_LOAN','LOAN','CLOSEASRESCHEDULED',0),(219,'transac tion_loan','UPDATELOANOFFICER_LOAN','LOAN','UPDATELOANOFFICER',0),(220,'transaction_loan','UPDATELOANOFFICER_LOAN_CHECKER','LOAN','UPDATELOANOFFICER',0),(221,'transaction_loan','REMOVELOANOFFICER_LOAN','LOAN','REMOVELOANOFFICER',0),(222,'transaction_loan','REMOVELOANOFFICER_LOAN_CHECKER','LOAN','REMOVELOANOFFICER',0),(223,'transaction_loan','BULKREASSIGN_LOAN','LOAN','BULKREASSIGN',0),(224,'transaction_loan','BULKREASSIGN_LOAN_CHECKER','LOAN','BULKREASSIGN',0),(225,'transaction_loan','APPROVE_LOAN_CHECKER','LOAN','APPROVE',0),(226,'transaction_loan','APPROVEINPAST_LOAN_CHECKER','LOAN','APPROVEINPAST',0),(227,'transaction_loan','REJECT_LOAN_CHECKER','LOAN','REJECT',0),(228,'transaction_loan','REJECTINPAST_LOAN_CHECKER','LOAN','REJECTINPAST',0),(229,'transaction_loan','WITHDRAW_LOAN_CHECKER','LOAN','WITHDRAW',0),(230,'transaction_loan','WITHDRAWINPAST_LOAN_CHECKER','LOAN','WITHDRAWINPAST',0),(231,'transaction_loan','APPROVALUNDO_LOAN_CHECKER','LOAN','APPROVALUNDO',0),(232,'transaction _loan','DISBURSE_LOAN_CHECKER','LOAN','DISBURSE',0),(233,'transaction_loan','DISBURSEINPAST_LOAN_CHECKER','LOAN','DISBURSEINPAST',0),(234,'transaction_loan','DISBURSALUNDO_LOAN_CHECKER','LOAN','DISBURSALUNDO',0),(235,'transaction_loan','REPAYMENT_LOAN_CHECKER','LOAN','REPAYMENT',0),(236,'transaction_loan','REPAYMENTINPAST_LOAN_CHECKER','LOAN','REPAYMENTINPAST',0),(237,'transaction_loan','ADJUST_LOAN_CHECKER','LOAN','ADJUST',0),(238,'transaction_loan','WAIVEINTERESTPORTION_LOAN_CHECKER','LOAN','WAIVEINTERESTPORTION',0),(239,'transaction_loan','WRITEOFF_LOAN_CHECKER','LOAN','WRITEOFF',0),(240,'transaction_loan','CLOSE_LOAN_CHECKER','LOAN','CLOSE',0),(241,'transaction_loan','CLOSEASRESCHEDULED_LOAN_CHECKER','LOAN','CLOSEASRESCHEDULED',0),(242,'transaction_savings','DEPOSIT_SAVINGSACCOUNT','SAVINGSACCOUNT','DEPOSIT',0),(243,'transaction_savings','DEPOSIT_SAVINGSACCOUNT_CHECKER','SAVINGSACCOUNT','DEPOSIT',0),(244,'transaction_savings','WITHDRAWAL_SAVINGSACCOUNT','SAVINGSACCOUNT','WITHDRA WAL',0),(245,'transaction_savings','WITHDRAWAL_SAVINGSACCOUNT_CHECKER','SAVINGSACCOUNT','WITHDRAWAL',0),(246,'transaction_savings','ACTIVATE_SAVINGSACCOUNT','SAVINGSACCOUNT','ACTIVATE',0),(247,'transaction_savings','ACTIVATE_SAVINGSACCOUNT_CHECKER','SAVINGSACCOUNT','ACTIVATE',0),(248,'accounting','CREATE_GLACCOUNT','GLACCOUNT','CREATE',0),(249,'accounting','UPDATE_GLACCOUNT','GLACCOUNT','UPDATE',0),(250,'accounting','DELETE_GLACCOUNT','GLACCOUNT','DELETE',0),(251,'accounting','CREATE_GLCLOSURE','GLCLOSURE','CREATE',0),(252,'accounting','UPDATE_GLCLOSURE','GLCLOSURE','UPDATE',0),(253,'accounting','DELETE_GLCLOSURE','GLCLOSURE','DELETE',0),(254,'accounting','CREATE_JOURNALENTRY','JOURNALENTRY','CREATE',0),(255,'accounting','REVERSE_JOURNALENTRY','JOURNALENTRY','REVERSE',0),(256,'report','READ_Active Loans - Details','Active Loans - Details','READ',0),(257,'report','READ_Active Loans - Summary','Active Loans - Summary','READ',0),(258,'report','READ_Active Loans by Disbursal Period','Ac tive Loans by Disbursal Period','READ',0),(259,'report','READ_Active Loans in last installment','Active Loans in last installment','READ',0),(260,'report','READ_Active Loans in last installment Summary','Active Loans in last installment Summary','READ',0),(261,'report','READ_Active Loans Passed Final Maturity','Active Loans Passed Final Maturity','READ',0),(262,'report','READ_Active Loans Passed Final Maturity Summary','Active Loans Passed Final Maturity Summary','READ',0),(263,'report','READ_Aging Detail','Aging Detail','READ',0),(264,'report','READ_Aging Summary (Arrears in Months)','Aging Summary (Arrears in Months)','READ',0),(265,'report','READ_Aging Summary (Arrears in Weeks)','Aging Summary (Arrears in Weeks)','READ',0),(266,'report','READ_Balance Sheet','Balance Sheet','READ',0),(267,'report','READ_Branch Expected Cash Flow','Branch Expected Cash Flow','READ',0),(268,'report','READ_Client Listing','Client Listing','READ',0),(269,'report','READ_Client Loans Listing','Client L oans Listing','READ',0),(270,'report','READ_Expected Payments By Date - Basic','Expected Payments By Date - Basic','READ',0),(271,'report','READ_Expected Payments By Date - Formatted','Expected Payments By Date - Formatted','READ',0),(272,'report','READ_Funds Disbursed Between Dates Summary','Funds Disbursed Between Dates Summary','READ',0),(273,'report','READ_Funds Disbursed Between Dates Summary by Office','Funds Disbursed Between Dates Summary by Office','READ',0),(274,'report','READ_Income Statement','Income Statement','READ',0),(275,'report','READ_Loan Account Schedule','Loan Account Schedule','READ',0),(276,'report','READ_Loans Awaiting Disbursal','Loans Awaiting Disbursal','READ',0),(277,'report','READ_Loans Awaiting Disbursal Summary','Loans Awaiting Disbursal Summary','READ',0),(278,'report','READ_Loans Awaiting Disbursal Summary by Month','Loans Awaiting Disbursal Summary by Month','READ',0),(279,'report','READ_Loans Pending Approval','Loans Pending Approval','READ',0),(28 0,'report','READ_Obligation Met Loans Details','Obligation Met Loans Details','READ',0),(281,'report','READ_Obligation Met Loans Summary','Obligation Met Loans Summary','READ',0),(282,'report','READ_Portfolio at Risk','Portfolio at Risk','READ',0),(283,'report','READ_Portfolio at Risk by Branch','Portfolio at Risk by Branch','READ',0),(284,'report','READ_Rescheduled Loans','Rescheduled Loans','READ',0),(285,'report','READ_Trial Balance','Trial Balance','READ',0),(286,'report','READ_Written-Off Loans','Written-Off Loans','READ',0),(287,'datatable','CREATE_extra_client_details','extra_client_details','CREATE',1),(288,'datatable','CREATE_extra_family_details','extra_family_details','CREATE',1),(289,'datatable','CREATE_extra_loan_details','extra_loan_details','CREATE',1),(290,'datatable','READ_extra_client_details','extra_client_details','READ',1),(291,'datatable','READ_extra_family_details','extra_family_details','READ',1),(292,'datatable','READ_extra_loan_details','extra_loan_details' ,'READ',1),(293,'datatable','UPDATE_extra_client_details','extra_client_details','UPDATE',1),(294,'datatable','UPDATE_extra_family_details','extra_family_details','UPDATE',1),(295,'datatable','UPDATE_extra_loan_details','extra_loan_details','UPDATE',1),(296,'datatable','DELETE_extra_client_details','extra_client_details','DELETE',1),(297,'datatable','DELETE_extra_family_details','extra_family_details','DELETE',1),(298,'datatable','DELETE_extra_loan_details','extra_loan_details','DELETE',1); -/*!40000 ALTER TABLE `m_permission` ENABLE KEYS */; -UNLOCK TABLES; - --- --- Table structure for table `m_portfolio_command_source` --- - -DROP TABLE IF EXISTS `m_portfolio_command_source`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `m_portfolio_command_source` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `action_name` varchar(50) NOT NULL, - `entity_name` varchar(50) NOT NULL, - `o
<TRUNCATED>
