You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@fineract.apache.org by ma...@apache.org on 2016/02/01 10:43:11 UTC
[28/52] [abbrv] [partial] incubator-fineract git commit: deleted
initial code
http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/66cee785/fineract-db/multi-tenant-demo-backups/bare-bones-demo/bk_bare_bones_demo.sql
----------------------------------------------------------------------
diff --git a/fineract-db/multi-tenant-demo-backups/bare-bones-demo/bk_bare_bones_demo.sql b/fineract-db/multi-tenant-demo-backups/bare-bones-demo/bk_bare_bones_demo.sql
deleted file mode 100644
index fab47a1..0000000
--- a/fineract-db/multi-tenant-demo-backups/bare-bones-demo/bk_bare_bones_demo.sql
+++ /dev/null
@@ -1,1933 +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 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 */;
-/*!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','demomfi@mifos.org','\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=6 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);
-/*!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=5 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);
-/*!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=287 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);
-/*!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,
- `office_id` bigint(20) DEFAULT NULL,
- `group_id` bigint(20) DEFAULT NULL,
- `client_id` bigint(20) DEFAULT NULL,
- `loan_id` bigint(20) DEFAULT NULL,
- `api_get_url` varchar(100) NOT NULL,
- `resource_id` bigint(20) DEFAULT NULL,
- `subresource_id` bigint(20) DEFAULT NULL,
- `command_as_json` text NOT NULL,
- `maker_id` bigint(20) NOT NULL,
- `made_on_date` datetime NOT NULL,
- `checker_id` bigint(20) DEFAULT NULL,
- `checked_on_date` datetime DEFAULT NULL,
- `processing_result_enum` smallint(5) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_m_maker_m_appuser` (`maker_id`),
- KEY `FK_m_checker_m_appuser` (`checker_id`),
- KEY `action_name` (`action_name`),
- KEY `entity_name` (`entity_name`,`resource_id`),
- KEY `made_on_date` (`made_on_date`),
- KEY `checked_on_date` (`checked_on_date`),
- KEY `processing_result_enum` (`processing_result_enum`),
- KEY `office_id` (`office_id`),
- KEY `group_id` (`office_id`),
- KEY `client_id` (`office_id`),
- KEY `loan_id` (`office_id`),
- CONSTRAINT `FK_m_checker_m_appuser` FOREIGN KEY (`checker_id`) REFERENCES `m_appuser` (`id`),
- CONSTRAINT `FK_m_maker_m_appuser` FOREIGN KEY (`maker_id`) REFERENCES `m_appuser` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `m_portfolio_command_source`
---
-
-LOCK TABLES `m_portfolio_command_source` WRITE;
-/*!40000 ALTER TABLE `m_portfolio_command_source` DISABLE KEYS */;
-/*!40000 ALTER TABLE `m_portfolio_command_source` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `m_product_loan`
---
-
-DROP TABLE IF EXISTS `m_product_loan`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `m_product_loan` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `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,
- `name` varchar(100) NOT NULL,
- `description` varchar(500) DEFAULT NULL,
- `fund_id` bigint(20) 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',
- `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,
- `accounting_type` smallint(5) NOT NULL,
- `loan_transaction_strategy_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unq_name` (`name`),
- KEY `FKA6A8A7D77240145` (`fund_id`),
- KEY `FK_ltp_strategy` (`loan_transaction_strategy_id`),
- CONSTRAINT `FKA6A8A7D77240145` FOREIGN KEY (`fund_id`) REFERENCES `m_fund` (`id`),
- CONSTRAINT `FK_ltp_strategy` FOREIGN KEY (`loan_transaction_strategy_id`) REFERENCES `ref_loan_transaction_processing_strategy` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `m_product_loan`
---
-
-LOCK TABLES `m_product_loan` WRITE;
-/*!40000 ALTER TABLE `m_product_loan` DISABLE KEYS */;
-/*!40000 ALTER TABLE `m_product_loan` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `m_product_loan_charge`
---
-
-DROP TABLE IF EXISTS `m_product_loan_charge`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `m_product_loan_charge` (
- `product_loan_id` bigint(20) NOT NULL,
- `charge_id` bigint(20) NOT NULL,
- PRIMARY KEY (`product_loan_id`,`charge_id`),
- KEY `charge_id` (`charge_id`),
- CONSTRAINT `m_product_loan_charge_ibfk_1` FOREIGN KEY (`charge_id`) REFERENCES `m_charge` (`id`),
- CONSTRAINT `m_product_loan_charge_ibfk_2` FOREIGN KEY (`product_loan_id`) REFERENCES `m_product_loan` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `m_product_loan_charge`
---
-
-LOCK TABLES `m_product_loan_charge` WRITE;
-/*!40000 ALTER TABLE `m_product_loan_charge` DISABLE KEYS */;
-/*!40000 ALTER TABLE `m_product_loan_charge` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `m_role`
---
-
-DROP TABLE IF EXISTS `m_role`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `m_role` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(100) NOT NULL,
- `description` varchar(500) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unq_name` (`name`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `m_role`
---
-
-LOCK TABLES `m_role` WRITE;
-/*!40000 ALTER TABLE `m_role` DISABLE KEYS */;
-INSERT INTO `m_role` VALUES (1,'Super user','This role provides all application permissions.');
-/*!40000 ALTER TABLE `m_role` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `m_role_permission`
---
-
-DROP TABLE IF EXISTS `m_role_permission`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `m_role_permission` (
- `role_id` bigint(20) NOT NULL,
- `permission_id` bigint(20) NOT NULL,
- PRIMARY KEY (`role_id`,`permission_id`),
- KEY `FK8DEDB04815CEC7AB` (`role_id`),
- KEY `FK8DEDB048103B544B` (`permission_id`),
- CONSTRAINT `FK8DEDB048103B544B` FOREIGN KEY (`permission_id`) REFERENCES `m_permission` (`id`),
- CONSTRAINT `FK8DEDB04815CEC7AB` FOREIGN KEY (`role_id`) REFERENCES `m_role` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `m_role_permission`
---
-
-LOCK TABLES `m_role_permission` WRITE;
-/*!40000 ALTER TABLE `m_role_permission` DISABLE KEYS */;
-INSERT INTO `m_role_permission` VALUES (1,1);
-/*!40000 ALTER TABLE `m_role_permission` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `m_savings_account`
---
-
-DROP TABLE IF EXISTS `m_savings_account`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
<TRUNCATED>