 
 LOCK TABLES `schema_version` WRITE;
 /*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
-INSERT INTO `schema_version` VALUES (1,1,'1','mifosplatform-core-ddl-latest','SQL','V1__mifosplatform-core-ddl-latest.sql',-1957145051,'root','2014-03-07 20:58:38',10710,1),(10,10,'10','interest-posting-fields-for-savings','SQL','V10__interest-posting-fields-for-savings.sql',-1133853485,'root','2014-03-07 20:58:43',1339,1),(100,100,'100','Group saving summary report','SQL','V100__Group_saving_summary_report.sql',-1635399448,'root','2014-03-07 20:59:23',26,1),(101,101,'101','add mulitplesof to account transfers table','SQL','V101__add_mulitplesof_to_account_transfers_table.sql',-1162976022,'root','2014-03-07 20:59:24',271,1),(102,102,'102','client attendance tables','SQL','V102__client_attendance_tables.sql',-45448019,'root','2014-03-07 20:59:24',359,1),(103,103,'103','cluster support for batch jobs','SQL','V103__cluster_support_for_batch_jobs.sql',-781879007,'root','2014-03-07 20:59:25',489,1),(104,104,'104','permissions for transfers','SQL','V104__permissions_for_transfers.sql',653895919,'root','2014-03-07 20:59:25',51,1),(105,105,'105','track loan transaction against office','SQL','V105__track_loan_transaction_against_office.sql',785650440,'root','2014-03-07 20:59:26',1260,1),(106,106,'106','more permissions for transfers','SQL','V106__more_permissions_for_transfers.sql',-1132691133,'root','2014-03-07 20:59:27',63,1),(107,107,'107','datatable code mappings','SQL','V107__datatable_code_mappings.sql',630737271,'root','2014-03-07 20:59:27',185,1),(108,108,'108','client has transfer office','SQL','V108__client_has_transfer_office.sql',-1748734810,'root','2014-03-07 20:59:27',356,1),(109,109,'109','account transfer withdrawal fee configuration','SQL','V109__account_transfer_withdrawal_fee_configuration.sql',-754569033,'root','2014-03-07 20:59:28',524,1),(11,11,'11','add-payment-details','SQL','V11__add-payment-details.sql',391380768,'root','2014-03-07 20:58:44',404,1),(110,110,'110','group center close','SQL','V110__group_center_close.sql',-1261775365,'root','2014-03-07 20:59:28',326,1),(111,111,'111','disable constraint approach for datatables by default','SQL','V111__disable_constraint_approach_for_datatables_by_default.sql',2058257907,'root','2014-03-07 20:59:29',28,1),(112,112,'111.1','set default transfers in suspense account for existing loan products','SQL','V111_1__set default_transfers_in_suspense_account_for_existing_loan_products.sql',1907173791,'root','2014-03-07 20:59:29',5,1),(113,113,'112','mixreport sql support','SQL','V112__mixreport_sql_support.sql',1254859560,'root','2014-03-07 20:59:29',655,1),(114,114,'113','track savings transaction against office','SQL','V113__track_savings_transaction_against_office.sql',-1390529632,'root','2014-03-07 20:59:30',799,1),(115,115,'114','set default transfers in suspense account for existing savings products - Copy','SQL','V114__set_default_transfers_in_suspense_account_for_existing_savings_products - Copy.sql',1518369372,'root','2014-03-07 20:59:30',3,1),(116,116,'115','permissions for cache api','SQL','V115__permissions_for_cache_api.sql',156437687,'root','2014-03-07 20:59:31',147,1),(117,117,'116','track currency for journal entries','SQL','V116__track_currency_for_journal_entries.sql',1109139399,'root','2014-03-07 20:59:31',613,1),(118,118,'117','loan charge from savings','SQL','V117__loan_charge_from_savings.sql',13633826,'root','2014-03-07 20:59:32',942,1),(119,119,'118','savings charge','SQL','V118__savings_charge.sql',899101813,'root','2014-03-07 20:59:33',522,1),(120,120,'118.1','savings charge patch update','SQL','V118_1__savings_charge_patch_update.sql',426133125,'root','2014-03-07 20:59:34',304,1),(121,121,'118.2','product mapping delete duplicate fund source to account mappings','SQL','V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql',139468093,'root','2014-03-07 20:59:34',3,1),(122,122,'118.3','permissions form propose and accept client transfers','SQL','V118_3__permissions_form_propose_and_accept_client_transfers.sql',602708322,'root','2014-03-07 20:59:34',26,1),(123,123,'118.4','reset default transfers in suspense account for existing savings products','SQL','V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql',1246865828,'root','2014-03-07 20:59:34',7,1),(124,124,'118.5','batch job entry for pay savings charge','SQL','V118_5__batch_job_entry_for_pay_savings_charge.sql',-1477017272,'root','2014-03-07 20:59:34',34,1),(125,125,'118.6','defaults for income from penalties for savings product','SQL','V118_6__defaults_for_income_from_penalties_for savings_product.sql',255024118,'root','2014-03-07 20:59:34',3,1),(126,126,'118.7','move withdrawal annual fee to charges','SQL','V118_7__move_withdrawal_annual_fee_to_charges.sql',480656720,'root','2014-03-07 20:59:35',1079,1),(127,127,'118.8','track overpayments seperately in loan transactions','SQL','V118_8__track_overpayments_seperately_in_loan_transactions.sql',1684107411,'root','2014-03-07 20:59:36',342,1),(128,128,'119','add template table','SQL','V119__add_template_table.sql',1524629249,'root','2014-03-07 20:59:36',388,1),(12,12,'12','add external id to couple of tables','SQL','V12__add_external_id_to_couple_of_tables.sql',371833586,'root','2014-03-07 20:58:45',1332,1),(129,129,'120','accounting running balance','SQL','V120__accounting_running_balance.sql',746738547,'root','2014-03-07 20:59:37',619,1),(130,130,'121','accounting running balance for organization','SQL','V121__accounting_running_balance_for_organization.sql',1907762382,'root','2014-03-07 20:59:38',488,1),(131,131,'122','recurring fee support for savings','SQL','V122__recurring_fee_support_for_savings.sql',-1538770236,'root','2014-03-07 20:59:38',527,1),(132,132,'123','remove payment mode for savings','SQL','V123__remove_payment_mode_for_savings.sql',1909778922,'root','2014-03-07 20:59:39',186,1),(133,133,'124','added min max cap for charges','SQL','V124__added_min_max_cap_for_charges.sql',-1996899270,'root','2014-03-07 20:59:39',472,1),(134,134,'125','added column for actual fee amount or percentage','SQL','V125__added_column_for_actual_fee_amount_or_percentage.sql',-87760502,'root','2014-03-07 20:59:40',230,1),(135,135,'126','initial database structure for sms outbound','SQL','V126__initial_database_structure_for_sms_outbound.sql',-586195149,'root','2014-03-07 20:59:40',252,1),(136,136,'127','mobile no fields','SQL','V127__mobile_no_fields.sql',-659228285,'root','2014-03-07 20:59:40',417,1),(137,137,'128','added loan installment charge','SQL','V128__added_loan_installment_charge.sql',-1983585024,'root','2014-03-07 20:59:41',145,1),(138,138,'129','client and group timeline','SQL','V129__client_and_group_timeline.sql',-1671377251,'root','2014-03-07 20:59:42',840,1),(13,13,'13','add group and client pending configuration','SQL','V13__add_group_and_client_pending_configuration.sql',145878397,'root','2014-03-07 20:58:46',58,1),(139,139,'130','calendar-history-table','SQL','V130__calendar-history-table.sql',-475045678,'root','2014-03-07 20:59:42',180,1),(140,140,'131','holiday-status-column-and-permissions','SQL','V131__holiday-status-column-and-permissions.sql',-1387001593,'root','2014-03-07 20:59:43',862,1),(141,141,'132','borrower cycle changes','SQL','V132__borrower_cycle_changes.sql',-355052428,'root','2014-03-07 20:59:44',579,1),(142,142,'133','adding payment detail with journal entry','SQL','V133__adding_payment_detail_with_journal_entry.sql',1975659943,'root','2014-03-07 20:59:44',399,1),(143,143,'134','added column value on c configuration','SQL','V134__added_column_value_on_c_configuration.sql',-30626232,'root','2014-03-07 20:59:45',495,1),(144,144,'134.1','submitted date updation for clients','SQL','V134_1__submitted_date_updation_for_clients.sql',184599342,'root','2014-03-07 20:59:45',7,1),(145,145,'134.2','permissions spelling correction','SQL','V134_2__permissions_spelling_correction.sql',996960341,'root','2014-03-07 20:59:45',73,1),(146,146,'135','added permission for undo written off','SQL','V135__added_permission_for_undo_written_off.sql',1414936537,'root','2014-03-07 20:59:45',50,1),(147,147,'136.1','update script strechy parameter','SQL','V136_1__update_script_strechy_parameter.sql',633461657,'root','2014-03-07 20:59:46',56,1),(148,148,'137','added is active column in m staff','SQL','V137__added_is_active_column_in_m_staff.sql',1962782431,'root','2014-03-07 20:59:46',494,1),(149,149,'138','add short name for m product loan and m savings product','SQL','V138__add_short_name_for_m_product_loan_and_m_savings_product.sql',-1526828084,'root','2014-03-07 20:59:51',4619,1),(150,150,'139','default value for is active updated to true in m staff','SQL','V139__default_value_for_is_active_updated_to_true_in_m_staff.sql',844329308,'root','2014-03-07 20:59:52',569,1),(14,14,'14','rename status id to enum','SQL','V14__rename_status_id_to_enum.sql',1958382098,'root','2014-03-07 20:58:46',532,1),(151,151,'140','added loan charge status','SQL','V140__added_loan_charge_status.sql',1209971905,'root','2014-03-07 20:59:53',657,1),(152,152,'140.1','added payment detail id in ac gl journal entry','SQL','V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql',-214253481,'root','2014-03-07 20:59:53',664,1),(153,153,'141','add early repayment strategy','SQL','V141__add_early_repayment_strategy.sql',401969634,'root','2014-03-07 20:59:54',56,1),(154,154,'142','read savingsaccount charge permission','SQL','V142__read_savingsaccount_charge_permission.sql',-1798083956,'root','2014-03-07 20:59:54',64,1),(155,155,'143','create journalentry checker permission','SQL','V143__create_journalentry_checker_permission.sql',227507002,'root','2014-03-07 20:59:54',57,1),(156,156,'144','spelling mistake corrections','SQL','V144__spelling_mistake_corrections.sql',-778391100,'root','2014-03-07 20:59:55',547,1),(157,157,'145','add force password reset in c configuration','SQL','V145__add_force_password_reset_in_c_configuration.sql',-662441756,'root','2014-03-07 20:59:57',2286,1),(158,158,'146','tranche loans','SQL','V146__tranche_loans.sql',989126672,'root','2014-03-07 21:00:02',4290,1),(159,159,'147','tranche loans column name changes','SQL','V147__tranche_loans_column_name_changes.sql',-533159256,'root','2014-03-07 21:00:03',812,1),(160,160,'148','overdraft changes','SQL','V148__overdraft_changes.sql',-1470217992,'root','2014-03-07 21:00:07',3837,1),(161,161,'149','add created date savings transaction','SQL','V149__add_created_date_savings_transaction.sql',137884095,'root','2014-03-07 21:00:08',772,1),(15,15,'15','center permissions','SQL','V15__center_permissions.sql',1124247014,'root','2014-03-07 20:58:46',28,1),(162,162,'150','basic savings report','SQL','V150__basic_savings_report.sql',-1500021911,'root','2014-03-07 21:00:09',1191,1),(163,163,'151','add default savings account to client','SQL','V151__add_default_savings_account_to_client.sql',-2012873976,'root','2014-04-02 22:17:49',105,1),(164,164,'152','added grace for over due','SQL','V152__added_grace_for_over_due.sql',1917777205,'root','2014-04-02 22:17:49',170,1),(165,165,'153','Insert missed permissions','SQL','V153__Insert_missed_permissions.sql',-1693091937,'root','2014-04-02 22:17:49',13,1),(166,166,'154','aging details','SQL','V154__aging_details.sql',1117759702,'root','2014-04-02 22:17:49',14,1),(167,167,'155','stretchy into pentaho','SQL','V155__stretchy_into_pentaho.sql',-1836158085,'root','2014-04-02 22:17:49',137,1),(168,168,'156','added loan saving txns pentaho','SQL','V156__added_loan_saving_txns_pentaho.sql',1942570756,'root','2014-04-02 22:17:49',6,1),(169,169,'157','overdue charge improvements','SQL','V157__overdue_charge_improvements.sql',-1267720651,'root','2014-04-02 22:17:50',106,1),(170,170,'158','dashboard and navigation queries','SQL','V158__dashboard_and_navigation_queries.sql',-265915721,'root','2014-04-02 22:17:50',14,1),(171,171,'159','add transaction id column m portfolio command source','SQL','V159__add_transaction_id_column_m_portfolio_command_source.sql',-1834626647,'root','2014-05-01 17:40:29',2615,1),(16,16,'16','drop min max column on loan table','SQL','V16__drop_min_max_column_on_loan_table.sql',-1497882087,'root','2014-03-07 20:58:47',275,1),(172,172,'160','standing instruction changes','SQL','V160__standing_instruction_changes.sql',-2130923257,'root','2014-05-01 17:40:35',5658,1),(173,191,'160.2','Allow nullValue For principal on lonProduct','SQL','V160_2__Allow_nullValue_For_principal_on_lonProduct.sql',844844635,'root','2014-07-11 01:27:59',1699,1),(174,173,'161','added accrual batch job','SQL','V161__added_accrual_batch_job.sql',-1558441026,'root','2014-05-01 17:40:36',813,1),(175,174,'162','overdue charge batch job','SQL','V162__overdue_charge_batch_job.sql',-1213828784,'root','2014-05-01 17:40:36',15,1),(176,175,'163','added npa for loans','SQL','V163__added_npa_for_loans.sql',-381581272,'root','2014-05-01 17:40:41',4713,1),(177,176,'164','fd and rd deposit tables','SQL','V164__fd_and_rd_deposit_tables.sql',-489803231,'root','2014-05-01 17:40:48',7168,1),(178,177,'165','added permission for disburse to saving account','SQL','V165__added_permission_for_disburse_to_saving_account.sql',-2109143723,'root','2014-05-01 17:40:48',100,1),(179,178,'166','added deposit amount to product term and preclosure','SQL','V166__added_deposit_amount_to_product_term_and_preclosure.sql',-2068527520,'root','2014-05-01 17:40:50',1411,1),(180,179,'167','added columns for writtenOff loans recovered','SQL','V167__added_columns_for_writtenOff_loans_recovered.sql',-901133645,'root','2014-06-11 16:09:12',3242,1),(181,180,'168','added transfer fixed deposit interest to linked account','SQL','V168__added_transfer_fixed_deposit_interest_to_linked_account.sql',1513454871,'root','2014-06-11 16:09:15',2239,1),(182,181,'169','update dashboard reports to core reports use report to false','SQL','V169__update_dashboard_reports_to_core_reports_use_report_to_false.sql',1910199831,'root','2014-06-11 16:09:15',39,1),(17,17,'17','update stretchy reporting ddl','SQL','V17__update_stretchy_reporting_ddl.sql',2040068410,'root','2014-03-07 20:58:48',1519,1),(183,182,'170','update deposit accounts maturity details job','SQL','V170__update_deposit_accounts_maturity_details_job.sql',348328732,'root','2014-06-11 16:09:15',31,1),(184,183,'171','added mandatory savings and rd changes','SQL','V171__added_mandatory_savings_and_rd_changes.sql',-219494664,'root','2014-06-11 16:09:21',5645,1),(185,184,'172','accounting changes for transfers','SQL','V172__accounting_changes_for_transfers.sql',1989818135,'root','2014-06-11 16:09:22',1052,1),(186,185,'173','ppi','SQL','V173__ppi.sql',-2061337506,'root','2014-06-11 16:09:25',3126,1),(187,186,'174','remove interest accrual','SQL','V174__remove_interest_accrual.sql',1343795196,'root','2014-06-11 16:09:25',3,1),(188,187,'175','added incentive interest rates','SQL','V175__added_incentive_interest_rates.sql',1609110836,'root','2014-06-11 16:09:33',7507,1),(189,188,'176','updates to financial activity accounts','SQL','V176__updates_to_financial_activity_accounts.sql',242225588,'root','2014-06-16 23:46:55',2330,1),(190,189,'177','cleanup for client incentives','SQL','V177__cleanup_for_client_incentives.sql',-2131344758,'root','2014-06-16 23:46:56',36,1),(191,190,'178','updates to financial activity accounts pt2','SQL','V178__updates_to_financial_activity_accounts_pt2.sql',-417659005,'root','2014-06-16 23:46:56',40,1),(192,192,'179','updates to action names for maker checker permissions','SQL','V179__updates_to_action_names_for_maker_checker_permissions.sql',-239637884,'root','2014-07-11 01:27:59',163,1),(18,18,'18','update stretchy reporting reportSql','SQL','V18__update_stretchy_reporting_reportSql.sql',-170206095,'root','2014-03-07 20:58:48',29,1),(193,193,'180','update report schemas for disbursed vs awaitingdisbursal and groupnamesbystaff','SQL','V180__update_report_schemas_for_disbursed_vs_awaitingdisbursal_and_groupnamesbystaff.sql',-478172694,'root','2014-07-11 01:27:59',43,1),(194,194,'181','standing instruction logging','SQL','V181__standing_instruction_logging.sql',-259580241,'root','2014-07-11 01:28:00',848,1),(195,195,'182','added min required balance to savings product','SQL','V182__added_min_required_balance_to_savings_product.sql',-2083442779,'root','2014-07-11 01:28:03',2500,1),(196,196,'183','added min balance for interest calculation','SQL','V183__added_min_balance_for_interest_calculation.sql',-1892956044,'root','2014-07-11 01:28:05',2157,1),(197,197,'184','update min required balance for savings product','SQL','V184__update_min_required_balance_for_savings_product.sql',-978631870,'root','2014-07-11 01:28:06',618,1),(198,198,'185','add accrual till date for periodic accrual','SQL','V185__add_accrual_till_date_for_periodic_accrual.sql',1925372415,'root','2014-10-14 23:19:45',3845,1),(199,199,'186','added periodic accrual job','SQL','V186__added_periodic_accrual_job.sql',292417488,'root','2014-10-14 23:19:45',71,1),(200,200,'187','added permission to periodic accrual','SQL','V187__added_permission_to_periodic_accrual.sql',1479836850,'root','2014-10-14 23:19:45',24,1),(201,201,'188','add savingscharge inactivate permissions','SQL','V188__add_savingscharge_inactivate_permissions.sql',2095096043,'root','2014-10-14 23:19:46',945,1),(202,202,'189','m loan interest recalculation tables','SQL','V189__m_loan_interest_recalculation_tables.sql',-61157169,'root','2014-10-14 23:19:53',6949,1),(19,19,'19','report maintenance permissions','SQL','V19__report_maintenance_permissions.sql',-1528956905,'root','2014-03-07 20:58:49',26,1),(203,203,'190','add associategroup disassociategroup permissions','SQL','V190__add_associategroup_disassociategroup_permissions.sql',296284732,'root','2014-10-14 23:19:53',30,1),(204,204,'191','update gl account increase size of name col','SQL','V191__update_gl_account_increase_size_of_name_col.sql',-247079901,'root','2014-10-14 23:19:55',1552,1),(205,205,'192','interest recalculate job','SQL','V192__interest_recalculate_job.sql',589462859,'root','2014-10-14 23:19:55',43,1),(206,206,'193','added column joiningDate for staff','SQL','V193__added_column_joiningDate_for_staff.sql',586097114,'root','2014-10-14 23:19:56',1100,1),(207,207,'194','added recalculatedInterestComponent for interest recalculation','SQL','V194__added_recalculatedInterestComponent_for_interest_recalculation.sql',1691292674,'root','2014-10-14 23:19:57',815,1),(208,208,'195','moved rest frequency to product level','SQL','V195__moved_rest_frequency_to_product_level.sql',1697161943,'root','2014-10-14 23:19:59',1551,1),(209,209,'196','added loan running balance to transactions','SQL','V196__added_loan_running_balance_to_transactions.sql',320541466,'root','2014-10-14 23:20:00',1091,1),(210,210,'197','updated loan running balance of transactions','SQL','V197__updated_loan_running_balance_of_transactions.sql',514142390,'root','2014-10-14 23:20:00',360,1),(211,211,'198','loan rescheduling tables and permissions','SQL','V198__loan_rescheduling_tables_and_permissions.sql',320951317,'root','2014-10-14 23:20:05',4569,1),(212,212,'199','removed extra columns from schedule history','SQL','V199__removed_extra_columns_from_schedule_history.sql',-885550667,'root','2014-10-14 23:20:06',695,1),(2,2,'2','mifosx-base-reference-data-utf8','SQL','V2__mifosx-base-reference-data-utf8.sql',1316484475,'root','2014-03-07 20:58:38',106,1),(20,20,'20','report maint perms really configuration','SQL','V20__report_maint_perms_really_configuration.sql',-402845015,'root','2014-03-07 20:58:49',31,1),(213,213,'200','alter savings account for start interest calculation date','SQL','V200__alter_savings_account_for_start_interest_calculation_date.sql',338554725,'root','2014-10-14 23:20:07',1303,1),(214,214,'201','webhooks','SQL','V201__webhooks.sql',1446707293,'root','2014-10-14 23:20:10',3093,1),(215,215,'202','savings officer history table','SQL','V202__savings_officer_history_table.sql',445151847,'root','2014-10-14 23:20:11',672,1),(216,216,'203','added subbmittedDate loantransaction','SQL','V203__added_subbmittedDate_loantransaction.sql',481117136,'root','2014-10-14 23:20:13',1698,1),(217,217,'204','insert script for charges paid by for accruals','SQL','V204__insert_script_for_charges_paid_by_for_accruals.sql',1126139057,'root','2014-10-14 23:20:13',4,1),(218,218,'205','fix for charge and interest waiver with accruals','SQL','V205__fix_for_charge_and_interest_waiver_with_accruals.sql',620191357,'root','2014-11-02 13:24:39',2022,1),(219,219,'206','interest posting configuration','SQL','V206__interest_posting_configuration.sql',-1024393207,'root','2014-11-02 13:24:40',948,1),(220,220,'207','min max clients per group','SQL','V207__min_max_clients_per_group.sql',-2069742774,'root','2014-12-23 17:05:48',923,1),(221,221,'208','min max clients in group redux','SQL','V208__min_max_clients_in_group_redux.sql',1253715309,'root','2014-12-23 17:05:49',764,1),(222,222,'209','add all report names in m permission table','SQL','V209__add_all_report_names_in_m_permission_table.sql',-801564857,'root','2014-12-23 17:05:49',177,1),(21,21,'21','activation-permissions-for-clients','SQL','V21__activation-permissions-for-clients.sql',-569932376,'root','2014-03-07 20:58:49',328,1),(223,223,'210','track manually adjusted transactions','SQL','V210__track_manually_adjusted_transactions.sql',228516334,'root','2014-12-23 17:05:51',1242,1),(224,224,'211','minimum days between disbursal and first repayment','SQL','V211__minimum_days_between_disbursal_and_first_repayment.sql',888628428,'root','2014-12-23 17:05:53',1831,1),(225,225,'212','add NthDay and DayOfWeek columns loan','SQL','V212__add_NthDay_and_DayOfWeek_columns_loan.sql',1949824258,'root','2014-12-23 17:05:56',3064,1),(226,226,'213','NthDay and DayOfWeek columns should be nullable','SQL','V213__NthDay_and_DayOfWeek_columns_should_be_nullable.sql',1399365002,'root','2014-12-23 17:06:00',4338,1),(227,227,'214','alter table add create SI at disbursement','SQL','V214__alter_table_add_create_SI_at_disbursement.sql',-154407476,'root','2014-12-23 17:06:03',3021,1),(228,228,'215','guarantee on hold fund changes','SQL','V215__guarantee_on_hold_fund_changes.sql',303524926,'root','2014-12-23 17:06:08',5060,1),(229,229,'216','adding loan proposed amount to loan','SQL','V216__adding_loan_proposed_amount_to_loan.sql',348182179,'root','2014-12-23 17:06:13',4172,1),(230,230,'217','client substatus and codevalue description','SQL','V217__client_substatus_and_codevalue_description.sql',1679310398,'root','2014-12-23 17:06:20',7286,1),(231,231,'218','add user and datetime for loan savings transactions','SQL','V218__add_user_and_datetime_for_loan_savings_transactions.sql',-1058697092,'root','2014-12-23 17:06:23',2416,1),(232,232,'219','guarantor on hold fund changes for account','SQL','V219__guarantor_on_hold_fund_changes_for_account.sql',1081934247,'root','2014-12-23 17:06:34',10673,1),(22,22,'22','alter-group-for-consistency-add-permissions','SQL','V22__alter-group-for-consistency-add-permissions.sql',578271556,'root','2014-03-07 20:58:50',841,1),(233,233,'220','account number preferences','SQL','V220__account_number_preferences.sql',-502873750,'root','2014-12-23 17:06:35',1295,1),(234,234,'221','add version for m savings account','SQL','V221__add_version_for_m_savings_account.sql',863858591,'root','2014-12-23 17:06:38',2521,1),(235,235,'222','guarantor on hold fund changes for transactions','SQL','V222__guarantor_on_hold_fund_changes_for_transactions.sql',-1709074177,'root','2014-12-23 17:06:43',5200,1),(236,236,'223','add version for m loan account','SQL','V223__add_version_for_m_loan_account.sql',-973851712,'root','2014-12-23 17:06:49',5675,1),(237,237,'224','client lifecycle adding statuses','SQL','V224__client_lifecycle_adding_statuses.sql',-289697454,'root','2014-12-23 17:07:01',11533,1),(238,238,'225','permissions for updating recurring deposit amount','SQL','V225__permissions_for_updating_recurring_deposit_amount.sql',-1367144205,'root','2014-12-23 17:07:01',41,1),(239,239,'226','configuration for enforcing calendars for jlg loans','SQL','V226__configuration_for_enforcing_calendars_for_jlg_loans.sql',-382855919,'root','2014-12-23 17:07:01',31,1),(240,240,'227','loan-refund-permissions','SQL','V227__loan-refund-permissions.sql',2141152676,'root','2014-12-23 17:07:01',242,1),(241,241,'228','entity to entity access','SQL','V228__entity_to_entity_access.sql',-1244421071,'root','2014-12-23 17:07:03',1255,1),(242,242,'229','teller cash management','SQL','V229__teller_cash_management.sql',753724982,'root','2014-12-23 17:07:05',2441,1),(23,23,'23','remove-enable-disable-configuration-for-client-group-status','SQL','V23__remove-enable-disable-configuration-for-client-group-status.sql',-832390233,'root','2014-03-07 20:58:50',295,1),(243,243,'230','role status and correspoding permissions','SQL','V230__role_status_and_correspoding_permissions.sql',-21174595,'root','2015-04-16 09:28:42',131,1),(244,244,'231','m cashier transaction added currency code','SQL','V231__m_cashier_transaction_added_currency_code.sql',-1593672561,'root','2015-04-16 09:28:42',33,1),(245,245,'232','insert center closure reason','SQL','V232__insert_center_closure_reason.sql',-2049914418,'root','2015-04-16 09:28:42',2,1),(246,246,'233','Savings Transaction Receipt','SQL','V233__Savings_Transaction_Receipt.sql',1836289382,'root','2015-04-16 09:28:42',16,1),(247,247,'234','opening balaces setup','SQL','V234__opening_balaces_setup.sql',1777198314,'root','2015-04-16 09:28:42',30,1),(248,248,'235','add ugd template id m hook','SQL','V235__add_ugd_template_id_m_hook.sql',1120955673,'root','2015-04-16 09:28:42',73,1),(249,249,'236','individual collection sheet permissions','SQL','V236__individual_collection_sheet_permissions.sql',-66130238,'root','2015-04-16 09:28:42',2,1),(250,250,'237','add threshold config for last instalment','SQL','V237__add_threshold_config_for_last_instalment.sql',412873149,'root','2015-04-16 09:28:42',53,1),(251,251,'238','update staff display name length','SQL','V238__update_staff_display_name_length.sql',-1003425306,'root','2015-04-16 09:28:42',57,1),(252,252,'239','Loan Transaction Receipt','SQL','V239__Loan_Transaction_Receipt.sql',-130819179,'root','2015-04-16 09:28:42',3,1),(24,24,'24','add-group-client-foreign-key-constraint-in-loan-table','SQL','V24__add-group-client-foreign-key-constraint-in-loan-table.sql',-621897624,'root','2014-03-07 20:58:51',318,1),(253,253,'240','arrears aging config for interest recalculation','SQL','V240__arrears_aging_config_for_interest_recalculation.sql',674368034,'root','2015-04-16 09:28:42',114,1),(254,254,'241','fixed emi changes','SQL','V241__fixed_emi_changes.sql',1943069939,'root','2015-04-16 09:28:42',47,1),(255,255,'242','entitytoentitymappingrelation','SQL','V242__entitytoentitymappingrelation.sql',-1770973716,'root','2015-04-16 09:28:42',59,1),(256,256,'243','alter loan disbursement details','SQL','V243__alter_loan_disbursement_details.sql',1461060824,'root','2015-04-16 09:28:42',31,1),(257,257,'244','staff assignment history table','SQL','V244__staff_assignment_history_table.sql',-427095856,'root','2015-04-16 09:28:43',30,1),(258,258,'245','open rd changes','SQL','V245__open_rd_changes.sql',2142566381,'root','2015-04-16 09:28:43',2,1),(259,259,'246','drop group client foreign key from m loan','SQL','V246__drop_group_client_foreign_key_from_m_loan.sql',-1721132405,'root','2015-04-16 09:28:43',11,1),(260,260,'247','consistency wrt spelling principalThresholdForLastInstalment','SQL','V247__consistency_wrt_spelling_principalThresholdForLastInstalment.sql',1371980378,'root','2015-04-16 09:28:43',9,1),(261,261,'248','added password never expired to User','SQL','V248__added_password_never_expired_to_User.sql',-1800179163,'root','2015-04-16 09:28:43',37,1),(262,262,'249','workingdays permissions','SQL','V249__workingdays_permissions.sql',-1322891155,'root','2015-04-16 09:28:43',3,1),(25,25,'25','update client reports for status and activation change','SQL','V25__update_client_reports_for_status_and_activation_change.sql',-1426943124,'root','2014-03-07 20:58:51',30,1),(263,263,'250','password validation policy','SQL','V250__password_validation_policy.sql',1197290340,'root','2015-04-16 09:28:43',38,1),(264,264,'251','paymentType table','SQL','V251__paymentType_table.sql',-1969329175,'root','2015-04-16 09:28:43',117,1),(265,265,'252','bug fix teller cash management','SQL','V252__bug_fix_teller_cash_management.sql',-736743970,'root','2015-04-16 09:28:43',167,1),(266,266,'253','product loan configurable attributes','SQL','V253__product_loan_configurable_attributes.sql',1787268316,'root','2015-04-16 09:28:43',15,1),(267,267,'254','General Ledger Report','SQL','V254__General_Ledger_Report.sql',-186920768,'root','2015-04-16 09:28:43',6,1),(268,268,'255','pre close interest period config','SQL','V255__pre_close_interest_period_config.sql',1383225707,'root','2015-04-16 09:28:43',23,1),(269,269,'256','Update script for General Ledger report','SQL','V256__Update script for General_Ledger_report.sql',1918702942,'root','2015-04-16 09:28:43',4,1),(270,270,'257','staff image association','SQL','V257__staff_image_association.sql',1740118046,'root','2015-04-16 09:28:43',37,1),(26,26,'26','add-support-for-withdrawal-fees-on-savings','SQL','V26__add-support-for-withdrawal-fees-on-savings.sql',-1955461568,'root','2014-03-07 20:58:52',884,1),(27,27,'27','add-loan-type-column-to-loan-table','SQL','V27__add-loan-type-column-to-loan-table.sql',-746287938,'root','2014-03-07 20:58:52',344,1),(28,28,'28','accounting-abstractions-and-autoposting','SQL','V28__accounting-abstractions-and-autoposting.sql',-966431980,'root','2014-03-07 20:58:53',556,1),(29,29,'29','add-support-for-annual-fees-on-savings','SQL','V29__add-support-for-annual-fees-on-savings.sql',992227725,'root','2014-03-07 20:58:55',1556,1),(3,3,'3','mifosx-permissions-and-authorisation-utf8','SQL','V3__mifosx-permissions-and-authorisation-utf8.sql',1922951887,'root','2014-03-07 20:58:38',110,1),(30,30,'30','add-referenceNumber-to-acc gl journal entry','SQL','V30__add-referenceNumber-to-acc_gl_journal_entry.sql',2079970797,'root','2014-03-07 20:58:55',327,1),(31,31,'31','drop-autopostings','SQL','V31__drop-autopostings.sql',630501407,'root','2014-03-07 20:58:55',39,1),(32,32,'32','associate-disassociate-clients-from-group-permissions','SQL','V32__associate-disassociate-clients-from-group-permissions.sql',765311507,'root','2014-03-07 20:58:55',29,1),(33,33,'33','drop unique check on stretchy report parameter','SQL','V33__drop_unique_check_on_stretchy_report_parameter.sql',-716768190,'root','2014-03-07 20:58:56',253,1),(34,34,'34','add unique check on stretchy report parameter','SQL','V34__add_unique_check_on_stretchy_report_parameter.sql',-1989718961,'root','2014-03-07 20:58:56',254,1),(35,35,'35','add hierarchy column for acc gl account','SQL','V35__add_hierarchy_column_for_acc_gl_account.sql',-1387013309,'root','2014-03-07 20:58:57',300,1),(36,36,'36','add tag id column for acc gl account','SQL','V36__add_tag_id_column_for_acc_gl_account.sql',-620418591,'root','2014-03-07 20:58:57',404,1),(37,37,'37','add-center-group-collection-sheet-permissions','SQL','V37__add-center-group-collection-sheet-permissions.sql',-1157429270,'root','2014-03-07 20:58:57',32,1),(38,38,'38','add-group-summary-details-report','SQL','V38__add-group-summary-details-report.sql',-1018394665,'root','2014-03-07 20:58:57',36,1),(39,39,'39','payment-channels-updates','SQL','V39__payment-channels-updates.sql',-1005512239,'root','2014-03-07 20:58:58',1172,1),(4,4,'4','mifosx-core-reports-utf8','SQL','V4__mifosx-core-reports-utf8.sql',-934709187,'root','2014-03-07 20:58:39',287,1),(40,40,'40','add permissions for accounting rule','SQL','V40__add_permissions_for_accounting_rule.sql',1514233058,'root','2014-03-07 20:58:59',37,1),(41,41,'41','group-summary-reports','SQL','V41__group-summary-reports.sql',263779795,'root','2014-03-07 20:58:59',229,1),(42,42,'42','Add default value for id for acc accounting rule','SQL','V42__Add_default_value_for_id_for_acc_accounting_rule.sql',1068680120,'root','2014-03-07 20:58:59',242,1),(43,43,'43','accounting-for-savings','SQL','V43__accounting-for-savings.sql',1965510021,'root','2014-03-07 20:59:00',567,1),(44,44,'44','document-increase-size-of-column-type','SQL','V44__document-increase-size-of-column-type.sql',1264142829,'root','2014-03-07 20:59:00',271,1),(45,45,'45','create acc rule tags table','SQL','V45__create_acc_rule_tags_table.sql',-307868244,'root','2014-03-07 20:59:01',189,1),(46,46,'46','extend datatables api','SQL','V46__extend_datatables_api.sql',297544230,'root','2014-03-07 20:59:01',38,1),(47,47,'47','staff-hierarchy-link-to-users','SQL','V47__staff-hierarchy-link-to-users.sql',480254198,'root','2014-03-07 20:59:02',868,1),(48,48,'48','adding-S3-Support','SQL','V48__adding-S3-Support.sql',-280798781,'root','2014-03-07 20:59:03',1276,1),(49,49,'49','track-loan-charge-payment-transactions','SQL','V49__track-loan-charge-payment-transactions.sql',170618680,'root','2014-03-07 20:59:03',176,1),(5,5,'5','update-savings-product-and-account-tables','SQL','V5__update-savings-product-and-account-tables.sql',1171300485,'root','2014-03-07 20:58:39',636,1),(50,50,'50','add-grace-settings-to-loan-product','SQL','V50__add-grace-settings-to-loan-product.sql',188244658,'root','2014-03-07 20:59:05',926,1),(51,51,'51','track-additional-details-related-to-installment-performance','SQL','V51__track-additional-details-related-to-installment-performance.sql',2012793946,'root','2014-03-07 20:59:05',602,1),(52,52,'52','add boolean support cols to acc accounting rule','SQL','V52__add_boolean_support_cols_to_acc_accounting_rule.sql',961668575,'root','2014-03-07 20:59:06',501,1),(53,53,'53','track-advance-and-late-payments-on-installment','SQL','V53__track-advance-and-late-payments-on-installment.sql',-230737076,'root','2014-03-07 20:59:06',212,1),(54,54,'54','charge-to-income-account-mappings','SQL','V54__charge-to-income-account-mappings.sql',2064168495,'root','2014-03-07 20:59:07',303,1),(55,55,'55','add-additional-transaction-processing-strategies','SQL','V55__add-additional-transaction-processing-strategies.sql',1186305896,'root','2014-03-07 20:59:07',352,1),(56,56,'56','track-overpaid-amount-on-loans','SQL','V56__track-overpaid-amount-on-loans.sql',1455634018,'root','2014-03-07 20:59:07',239,1),(57,57,'57','add default values to debit and credit accounts acc accounting rule','SQL','V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql',1936034654,'root','2014-03-07 20:59:08',272,1),(58,58,'58','create-holiday-tables changed','SQL','V58__create-holiday-tables_changed.sql',878594707,'root','2014-03-07 20:59:08',374,1),(59,59,'59','add group roles schema and permissions','SQL','V59__add_group_roles_schema_and_permissions.sql',2139634800,'root','2014-03-07 20:59:09',259,1),(6,6,'6','add min max principal column to loan','SQL','V6__add_min_max_principal_column_to_loan.sql',21414779,'root','2014-03-07 20:58:40',648,1),(60,60,'60','quipo dashboard reports','SQL','V60__quipo_dashboard_reports.sql',-1414014218,'root','2014-03-07 20:59:09',67,1),(61,61,'61','txn running balance example','SQL','V61__txn_running_balance_example.sql',-1186179870,'root','2014-03-07 20:59:09',43,1),(62,62,'62','add staff id to m client changed','SQL','V62__add_staff_id_to_m_client_changed.sql',-903717279,'root','2014-03-07 20:59:09',289,1),(63,63,'63','add sync disbursement with meeting column to loan','SQL','V63__add_sync_disbursement_with_meeting_column_to_loan.sql',1706011840,'root','2014-03-07 20:59:10',298,1),(64,64,'64','add permission for assign staff','SQL','V64__add_permission_for_assign_staff.sql',-1938102414,'root','2014-03-07 20:59:10',36,1),(65,65,'65','fix rupee symbol issues','SQL','V65__fix_rupee_symbol_issues.sql',581612224,'root','2014-03-07 20:59:10',33,1),(66,66,'66','client close functionality','SQL','V66__client_close_functionality.sql',225242657,'root','2014-03-07 20:59:10',357,1),(67,67,'67','loans in advance table','SQL','V67__loans_in_advance_table.sql',-2001051496,'root','2014-03-07 20:59:11',126,1),(68,68,'68','quipo dashboard reports updated','SQL','V68__quipo_dashboard_reports_updated.sql',-1241469930,'root','2014-03-07 20:59:11',74,1),(69,69,'69','loans in advance initialise','SQL','V69__loans_in_advance_initialise.sql',-1961764720,'root','2014-03-07 20:59:11',44,1),(7,7,'7','remove read makerchecker permission','SQL','V7__remove_read_makerchecker_permission.sql',-335430825,'root','2014-03-07 20:58:40',37,1),(70,70,'70','quipo program detail query fix','SQL','V70__quipo_program_detail_query_fix.sql',961289260,'root','2014-03-07 20:59:11',37,1),(71,71,'71','insert reschedule repayment to configuration','SQL','V71__insert_reschedule_repayment_to_configuration.sql',-1148306529,'root','2014-03-07 20:59:11',29,1),(72,72,'72','add m loan counter changes','SQL','V72__add_m_loan_counter_changes.sql',201544058,'root','2014-03-07 20:59:12',487,1),(73,73,'73','add repayments rescheduled to and processed column to holiday','SQL','V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql',-1946338033,'root','2014-03-07 20:59:12',265,1),(74,74,'74','alter m loan counter table add group','SQL','V74__alter_m_loan_counter_table_add_group.sql',-889985683,'root','2014-03-07 20:59:13',322,1),(75,75,'75','add reschedule-repayments-on-holidays to configuration','SQL','V75__add_reschedule-repayments-on-holidays_to_configuration.sql',1328301697,'root','2014-03-07 20:59:13',24,1),(76,76,'76','rename permission grouping','SQL','V76__rename_permission_grouping.sql',1717580945,'root','2014-03-07 20:59:13',28,1),(77,77,'77','alter m product loan changes','SQL','V77__alter_m_product_loan_changes.sql',677013677,'root','2014-03-07 20:59:13',283,1),(78,78,'78','breakdown portfolio grouping','SQL','V78__breakdown_portfolio_grouping.sql',-1385954232,'root','2014-03-07 20:59:13',28,1),(79,79,'79','schedule jobs tables','SQL','V79__schedule_jobs_tables.sql',339707179,'root','2014-03-07 20:59:14',435,1),(8,8,'8','deposit-transaction-permissions-if-they-exist','SQL','V8__deposit-transaction-permissions-if-they-exist.sql',-1507997551,'root','2014-03-07 20:58:40',6,1),(80,80,'80','schedule jobs tables updates','SQL','V80__schedule_jobs_tables_updates.sql',-152869205,'root','2014-03-07 20:59:15',1507,1),(81,81,'81','savings related changes','SQL','V81__savings_related_changes.sql',285284658,'root','2014-03-07 20:59:17',1593,1),(82,82,'82','schedule jobs tables updates for running status','SQL','V82__schedule_jobs_tables_updates_for_running_status.sql',-1029370098,'root','2014-03-07 20:59:18',621,1),(83,83,'83','non-working-days-table','SQL','V83__non-working-days-table.sql',-1092480574,'root','2014-03-07 20:59:18',138,1),(84,84,'84','undo savings transaction permission','SQL','V84__undo_savings_transaction_permission.sql',1857641857,'root','2014-03-07 20:59:18',31,1),(85,85,'85','product mix related changes','SQL','V85__product_mix_related_changes.sql',-740767169,'root','2014-03-07 20:59:19',484,1),(86,86,'86','update-working-days','SQL','V86__update-working-days.sql',1266232028,'root','2014-03-07 20:59:19',45,1),(87,87,'87','add permission for scheduler','SQL','V87__add_permission_for_scheduler.sql',-575950289,'root','2014-03-07 20:59:19',27,1),(88,88,'88','added update constrain for scheduler jobs','SQL','V88__added_update_constrain_for_scheduler_jobs.sql',1579070736,'root','2014-03-07 20:59:20',380,1),(89,89,'89','added scheduler group','SQL','V89__added_scheduler_group.sql',-1538207332,'root','2014-03-07 20:59:20',245,1),(9,9,'9','add min max constraint column to loan loanproduct','SQL','V9__add_min_max_constraint_column_to_loan_loanproduct.sql',-2103326932,'root','2014-03-07 20:58:42',1503,1),(90,90,'90','client performance history reports','SQL','V90__client_performance_history_reports.sql',35589718,'root','2014-03-07 20:59:20',51,1),(91,91,'91','apply annual fees permission','SQL','V91__apply_annual_fees_permission.sql',440351308,'root','2014-03-07 20:59:20',34,1),(92,92,'91.1','configuration settings for holiday and non workingday','SQL','V91_1__configuration_settings_for_holiday_and_non_workingday.sql',-429561096,'root','2014-03-07 20:59:20',25,1),(93,93,'92','group center assign staff permission','SQL','V92__group_center_assign_staff_permission.sql',-1557846330,'root','2014-03-07 20:59:20',21,1),(94,94,'93','loan transaction external id','SQL','V93__loan_transaction_external_id.sql',987684239,'root','2014-03-07 20:59:21',252,1),(95,95,'94','added savings accont type','SQL','V94__added_savings_accont type.sql',623078091,'root','2014-03-07 20:59:21',199,1),(96,96,'95','batch job postInterest','SQL','V95__batch_job_postInterest.sql',-1484077135,'root','2014-03-07 20:59:21',25,1),(97,97,'96','savings accounts transfers table','SQL','V96__savings_accounts_transfers_table.sql',-1447275289,'root','2014-03-07 20:59:22',370,1),(98,98,'97','add permission for adjust savings transaction','SQL','V97__add_permission_for_adjust_savings_transaction.sql',-2045732265,'root','2014-03-07 20:59:22',20,1),(99,99,'98','added currency roundof for multipleof','SQL','V98__added_currency_roundof_for_multipleof.sql',-131804848,'root','2014-03-07 20:59:23',1440,1);
+INSERT INTO `schema_version` VALUES (1,1,'1','mifosplatform-core-ddl-latest','SQL','V1__mifosplatform-core-ddl-latest.sql',-1957145051,'root','2014-03-07 20:58:38',10710,1),(10,10,'10','interest-posting-fields-for-savings','SQL','V10__interest-posting-fields-for-savings.sql',-1133853485,'root','2014-03-07 20:58:43',1339,1),(100,100,'100','Group saving summary report','SQL','V100__Group_saving_summary_report.sql',-1635399448,'root','2014-03-07 20:59:23',26,1),(101,101,'101','add mulitplesof to account transfers table','SQL','V101__add_mulitplesof_to_account_transfers_table.sql',-1162976022,'root','2014-03-07 20:59:24',271,1),(102,102,'102','client attendance tables','SQL','V102__client_attendance_tables.sql',-45448019,'root','2014-03-07 20:59:24',359,1),(103,103,'103','cluster support for batch jobs','SQL','V103__cluster_support_for_batch_jobs.sql',-781879007,'root','2014-03-07 20:59:25',489,1),(104,104,'104','permissions for transfers','SQL','V104__permissions_for_transfers.sql',653895919,'root','2014-03-07 20:59:25',51,1),(105,105,'105','track loan transaction against office','SQL','V105__track_loan_transaction_against_office.sql',785650440,'root','2014-03-07 20:59:26',1260,1),(106,106,'106','more permissions for transfers','SQL','V106__more_permissions_for_transfers.sql',-1132691133,'root','2014-03-07 20:59:27',63,1),(107,107,'107','datatable code mappings','SQL','V107__datatable_code_mappings.sql',630737271,'root','2014-03-07 20:59:27',185,1),(108,108,'108','client has transfer office','SQL','V108__client_has_transfer_office.sql',-1748734810,'root','2014-03-07 20:59:27',356,1),(109,109,'109','account transfer withdrawal fee configuration','SQL','V109__account_transfer_withdrawal_fee_configuration.sql',-754569033,'root','2014-03-07 20:59:28',524,1),(11,11,'11','add-payment-details','SQL','V11__add-payment-details.sql',391380768,'root','2014-03-07 20:58:44',404,1),(110,110,'110','group center close','SQL','V110__group_center_close.sql',-1261775365,'root','2014-03-07 20:59:28',326,1),(111,111,'111','disable constraint approach for datatables by default','SQL','V111__disable_constraint_approach_for_datatables_by_default.sql',2058257907,'root','2014-03-07 20:59:29',28,1),(112,112,'111.1','set default transfers in suspense account for existing loan products','SQL','V111_1__set default_transfers_in_suspense_account_for_existing_loan_products.sql',1907173791,'root','2014-03-07 20:59:29',5,1),(113,113,'112','mixreport sql support','SQL','V112__mixreport_sql_support.sql',1254859560,'root','2014-03-07 20:59:29',655,1),(114,114,'113','track savings transaction against office','SQL','V113__track_savings_transaction_against_office.sql',-1390529632,'root','2014-03-07 20:59:30',799,1),(115,115,'114','set default transfers in suspense account for existing savings products - Copy','SQL','V114__set_default_transfers_in_suspense_account_for_existing_savings_products - Copy.sql',1518369372,'root','2014-03-07 20:59:30',3,1),(116,116,'115','permissions for cache api','SQL','V115__permissions_for_cache_api.sql',156437687,'root','2014-03-07 20:59:31',147,1),(117,117,'116','track currency for journal entries','SQL','V116__track_currency_for_journal_entries.sql',1109139399,'root','2014-03-07 20:59:31',613,1),(118,118,'117','loan charge from savings','SQL','V117__loan_charge_from_savings.sql',13633826,'root','2014-03-07 20:59:32',942,1),(119,119,'118','savings charge','SQL','V118__savings_charge.sql',899101813,'root','2014-03-07 20:59:33',522,1),(120,120,'118.1','savings charge patch update','SQL','V118_1__savings_charge_patch_update.sql',426133125,'root','2014-03-07 20:59:34',304,1),(121,121,'118.2','product mapping delete duplicate fund source to account mappings','SQL','V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql',139468093,'root','2014-03-07 20:59:34',3,1),(122,122,'118.3','permissions form propose and accept client transfers','SQL','V118_3__permissions_form_propose_and_accept_client_transfers.sql',602708322,'root','2014-03-07 20:59:34',26,1),(123,123,'118.4','reset default transfers in suspense account for existing savings products','SQL','V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql',1246865828,'root','2014-03-07 20:59:34',7,1),(124,124,'118.5','batch job entry for pay savings charge','SQL','V118_5__batch_job_entry_for_pay_savings_charge.sql',-1477017272,'root','2014-03-07 20:59:34',34,1),(125,125,'118.6','defaults for income from penalties for savings product','SQL','V118_6__defaults_for_income_from_penalties_for savings_product.sql',255024118,'root','2014-03-07 20:59:34',3,1),(126,126,'118.7','move withdrawal annual fee to charges','SQL','V118_7__move_withdrawal_annual_fee_to_charges.sql',480656720,'root','2014-03-07 20:59:35',1079,1),(127,127,'118.8','track overpayments seperately in loan transactions','SQL','V118_8__track_overpayments_seperately_in_loan_transactions.sql',1684107411,'root','2014-03-07 20:59:36',342,1),(128,128,'119','add template table','SQL','V119__add_template_table.sql',1524629249,'root','2014-03-07 20:59:36',388,1),(12,12,'12','add external id to couple of tables','SQL','V12__add_external_id_to_couple_of_tables.sql',371833586,'root','2014-03-07 20:58:45',1332,1),(129,129,'120','accounting running balance','SQL','V120__accounting_running_balance.sql',746738547,'root','2014-03-07 20:59:37',619,1),(130,130,'121','accounting running balance for organization','SQL','V121__accounting_running_balance_for_organization.sql',1907762382,'root','2014-03-07 20:59:38',488,1),(131,131,'122','recurring fee support for savings','SQL','V122__recurring_fee_support_for_savings.sql',-1538770236,'root','2014-03-07 20:59:38',527,1),(132,132,'123','remove payment mode for savings','SQL','V123__remove_payment_mode_for_savings.sql',1909778922,'root','2014-03-07 20:59:39',186,1),(133,133,'124','added min max cap for charges','SQL','V124__added_min_max_cap_for_charges.sql',-1996899270,'root','2014-03-07 20:59:39',472,1),(134,134,'125','added column for actual fee amount or percentage','SQL','V125__added_column_for_actual_fee_amount_or_percentage.sql',-87760502,'root','2014-03-07 20:59:40',230,1),(135,135,'126','initial database structure for sms outbound','SQL','V126__initial_database_structure_for_sms_outbound.sql',-586195149,'root','2014-03-07 20:59:40',252,1),(136,136,'127','mobile no fields','SQL','V127__mobile_no_fields.sql',-659228285,'root','2014-03-07 20:59:40',417,1),(137,137,'128','added loan installment charge','SQL','V128__added_loan_installment_charge.sql',-1983585024,'root','2014-03-07 20:59:41',145,1),(138,138,'129','client and group timeline','SQL','V129__client_and_group_timeline.sql',-1671377251,'root','2014-03-07 20:59:42',840,1),(13,13,'13','add group and client pending configuration','SQL','V13__add_group_and_client_pending_configuration.sql',145878397,'root','2014-03-07 20:58:46',58,1),(139,139,'130','calendar-history-table','SQL','V130__calendar-history-table.sql',-475045678,'root','2014-03-07 20:59:42',180,1),(140,140,'131','holiday-status-column-and-permissions','SQL','V131__holiday-status-column-and-permissions.sql',-1387001593,'root','2014-03-07 20:59:43',862,1),(141,141,'132','borrower cycle changes','SQL','V132__borrower_cycle_changes.sql',-355052428,'root','2014-03-07 20:59:44',579,1),(142,142,'133','adding payment detail with journal entry','SQL','V133__adding_payment_detail_with_journal_entry.sql',1975659943,'root','2014-03-07 20:59:44',399,1),(143,143,'134','added column value on c configuration','SQL','V134__added_column_value_on_c_configuration.sql',-30626232,'root','2014-03-07 20:59:45',495,1),(144,144,'134.1','submitted date updation for clients','SQL','V134_1__submitted_date_updation_for_clients.sql',184599342,'root','2014-03-07 20:59:45',7,1),(145,145,'134.2','permissions spelling correction','SQL','V134_2__permissions_spelling_correction.sql',996960341,'root','2014-03-07 20:59:45',73,1),(146,146,'135','added permission for undo written off','SQL','V135__added_permission_for_undo_written_off.sql',1414936537,'root','2014-03-07 20:59:45',50,1),(147,147,'136.1','update script strechy parameter','SQL','V136_1__update_script_strechy_parameter.sql',633461657,'root','2014-03-07 20:59:46',56,1),(148,148,'137','added is active column in m staff','SQL','V137__added_is_active_column_in_m_staff.sql',1962782431,'root','2014-03-07 20:59:46',494,1),(149,149,'138','add short name for m product loan and m savings product','SQL','V138__add_short_name_for_m_product_loan_and_m_savings_product.sql',-1526828084,'root','2014-03-07 20:59:51',4619,1),(150,150,'139','default value for is active updated to true in m staff','SQL','V139__default_value_for_is_active_updated_to_true_in_m_staff.sql',844329308,'root','2014-03-07 20:59:52',569,1),(14,14,'14','rename status id to enum','SQL','V14__rename_status_id_to_enum.sql',1958382098,'root','2014-03-07 20:58:46',532,1),(151,151,'140','added loan charge status','SQL','V140__added_loan_charge_status.sql',1209971905,'root','2014-03-07 20:59:53',657,1),(152,152,'140.1','added payment detail id in ac gl journal entry','SQL','V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql',-214253481,'root','2014-03-07 20:59:53',664,1),(153,153,'141','add early repayment strategy','SQL','V141__add_early_repayment_strategy.sql',401969634,'root','2014-03-07 20:59:54',56,1),(154,154,'142','read savingsaccount charge permission','SQL','V142__read_savingsaccount_charge_permission.sql',-1798083956,'root','2014-03-07 20:59:54',64,1),(155,155,'143','create journalentry checker permission','SQL','V143__create_journalentry_checker_permission.sql',227507002,'root','2014-03-07 20:59:54',57,1),(156,156,'144','spelling mistake corrections','SQL','V144__spelling_mistake_corrections.sql',-778391100,'root','2014-03-07 20:59:55',547,1),(157,157,'145','add force password reset in c configuration','SQL','V145__add_force_password_reset_in_c_configuration.sql',-662441756,'root','2014-03-07 20:59:57',2286,1),(158,158,'146','tranche loans','SQL','V146__tranche_loans.sql',989126672,'root','2014-03-07 21:00:02',4290,1),(159,159,'147','tranche loans column name changes','SQL','V147__tranche_loans_column_name_changes.sql',-533159256,'root','2014-03-07 21:00:03',812,1),(160,160,'148','overdraft changes','SQL','V148__overdraft_changes.sql',-1470217992,'root','2014-03-07 21:00:07',3837,1),(161,161,'149','add created date savings transaction','SQL','V149__add_created_date_savings_transaction.sql',137884095,'root','2014-03-07 21:00:08',772,1),(15,15,'15','center permissions','SQL','V15__center_permissions.sql',1124247014,'root','2014-03-07 20:58:46',28,1),(162,162,'150','basic savings report','SQL','V150__basic_savings_report.sql',-1500021911,'root','2014-03-07 21:00:09',1191,1),(163,163,'151','add default savings account to client','SQL','V151__add_default_savings_account_to_client.sql',-2012873976,'root','2014-04-02 22:17:49',105,1),(164,164,'152','added grace for over due','SQL','V152__added_grace_for_over_due.sql',1917777205,'root','2014-04-02 22:17:49',170,1),(165,165,'153','Insert missed permissions','SQL','V153__Insert_missed_permissions.sql',-1693091937,'root','2014-04-02 22:17:49',13,1),(166,166,'154','aging details','SQL','V154__aging_details.sql',1117759702,'root','2014-04-02 22:17:49',14,1),(167,167,'155','stretchy into pentaho','SQL','V155__stretchy_into_pentaho.sql',-1836158085,'root','2014-04-02 22:17:49',137,1),(168,168,'156','added loan saving txns pentaho','SQL','V156__added_loan_saving_txns_pentaho.sql',1942570756,'root','2014-04-02 22:17:49',6,1),(169,169,'157','overdue charge improvements','SQL','V157__overdue_charge_improvements.sql',-1267720651,'root','2014-04-02 22:17:50',106,1),(170,170,'158','dashboard and navigation queries','SQL','V158__dashboard_and_navigation_queries.sql',-265915721,'root','2014-04-02 22:17:50',14,1),(171,171,'159','add transaction id column m portfolio command source','SQL','V159__add_transaction_id_column_m_portfolio_command_source.sql',-1834626647,'root','2014-05-01 17:40:29',2615,1),(16,16,'16','drop min max column on loan table','SQL','V16__drop_min_max_column_on_loan_table.sql',-1497882087,'root','2014-03-07 20:58:47',275,1),(172,172,'160','standing instruction changes','SQL','V160__standing_instruction_changes.sql',-2130923257,'root','2014-05-01 17:40:35',5658,1),(173,191,'160.2','Allow nullValue For principal on lonProduct','SQL','V160_2__Allow_nullValue_For_principal_on_lonProduct.sql',844844635,'root','2014-07-11 01:27:59',1699,1),(174,173,'161','added accrual batch job','SQL','V161__added_accrual_batch_job.sql',-1558441026,'root','2014-05-01 17:40:36',813,1),(175,174,'162','overdue charge batch job','SQL','V162__overdue_charge_batch_job.sql',-1213828784,'root','2014-05-01 17:40:36',15,1),(176,175,'163','added npa for loans','SQL','V163__added_npa_for_loans.sql',-381581272,'root','2014-05-01 17:40:41',4713,1),(177,176,'164','fd and rd deposit tables','SQL','V164__fd_and_rd_deposit_tables.sql',-489803231,'root','2014-05-01 17:40:48',7168,1),(178,177,'165','added permission for disburse to saving account','SQL','V165__added_permission_for_disburse_to_saving_account.sql',-2109143723,'root','2014-05-01 17:40:48',100,1),(179,178,'166','added deposit amount to product term and preclosure','SQL','V166__added_deposit_amount_to_product_term_and_preclosure.sql',-2068527520,'root','2014-05-01 17:40:50',1411,1),(180,179,'167','added columns for writtenOff loans recovered','SQL','V167__added_columns_for_writtenOff_loans_recovered.sql',-901133645,'root','2014-06-11 16:09:12',3242,1),(181,180,'168','added transfer fixed deposit interest to linked account','SQL','V168__added_transfer_fixed_deposit_interest_to_linked_account.sql',1513454871,'root','2014-06-11 16:09:15',2239,1),(182,181,'169','update dashboard reports to core reports use report to false','SQL','V169__update_dashboard_reports_to_core_reports_use_report_to_false.sql',1910199831,'root','2014-06-11 16:09:15',39,1),(17,17,'17','update stretchy reporting ddl','SQL','V17__update_stretchy_reporting_ddl.sql',2040068410,'root','2014-03-07 20:58:48',1519,1),(183,182,'170','update deposit accounts maturity details job','SQL','V170__update_deposit_accounts_maturity_details_job.sql',348328732,'root','2014-06-11 16:09:15',31,1),(184,183,'171','added mandatory savings and rd changes','SQL','V171__added_mandatory_savings_and_rd_changes.sql',-219494664,'root','2014-06-11 16:09:21',5645,1),(185,184,'172','accounting changes for transfers','SQL','V172__accounting_changes_for_transfers.sql',1989818135,'root','2014-06-11 16:09:22',1052,1),(186,185,'173','ppi','SQL','V173__ppi.sql',-2061337506,'root','2014-06-11 16:09:25',3126,1),(187,186,'174','remove interest accrual','SQL','V174__remove_interest_accrual.sql',1343795196,'root','2014-06-11 16:09:25',3,1),(188,187,'175','added incentive interest rates','SQL','V175__added_incentive_interest_rates.sql',1609110836,'root','2014-06-11 16:09:33',7507,1),(189,188,'176','updates to financial activity accounts','SQL','V176__updates_to_financial_activity_accounts.sql',242225588,'root','2014-06-16 23:46:55',2330,1),(190,189,'177','cleanup for client incentives','SQL','V177__cleanup_for_client_incentives.sql',-2131344758,'root','2014-06-16 23:46:56',36,1),(191,190,'178','updates to financial activity accounts pt2','SQL','V178__updates_to_financial_activity_accounts_pt2.sql',-417659005,'root','2014-06-16 23:46:56',40,1),(192,192,'179','updates to action names for maker checker permissions','SQL','V179__updates_to_action_names_for_maker_checker_permissions.sql',-239637884,'root','2014-07-11 01:27:59',163,1),(18,18,'18','update stretchy reporting reportSql','SQL','V18__update_stretchy_reporting_reportSql.sql',-170206095,'root','2014-03-07 20:58:48',29,1),(193,193,'180','update report schemas for disbursed vs awaitingdisbursal and groupnamesbystaff','SQL','V180__update_report_schemas_for_disbursed_vs_awaitingdisbursal_and_groupnamesbystaff.sql',-478172694,'root','2014-07-11 01:27:59',43,1),(194,194,'181','standing instruction logging','SQL','V181__standing_instruction_logging.sql',-259580241,'root','2014-07-11 01:28:00',848,1),(195,195,'182','added min required balance to savings product','SQL','V182__added_min_required_balance_to_savings_product.sql',-2083442779,'root','2014-07-11 01:28:03',2500,1),(196,196,'183','added min balance for interest calculation','SQL','V183__added_min_balance_for_interest_calculation.sql',-1892956044,'root','2014-07-11 01:28:05',2157,1),(197,197,'184','update min required balance for savings product','SQL','V184__update_min_required_balance_for_savings_product.sql',-978631870,'root','2014-07-11 01:28:06',618,1),(198,198,'185','add accrual till date for periodic accrual','SQL','V185__add_accrual_till_date_for_periodic_accrual.sql',1925372415,'root','2014-10-14 23:19:45',3845,1),(199,199,'186','added periodic accrual job','SQL','V186__added_periodic_accrual_job.sql',292417488,'root','2014-10-14 23:19:45',71,1),(200,200,'187','added permission to periodic accrual','SQL','V187__added_permission_to_periodic_accrual.sql',1479836850,'root','2014-10-14 23:19:45',24,1),(201,201,'188','add savingscharge inactivate permissions','SQL','V188__add_savingscharge_inactivate_permissions.sql',2095096043,'root','2014-10-14 23:19:46',945,1),(202,202,'189','m loan interest recalculation tables','SQL','V189__m_loan_interest_recalculation_tables.sql',-61157169,'root','2014-10-14 23:19:53',6949,1),(19,19,'19','report maintenance permissions','SQL','V19__report_maintenance_permissions.sql',-1528956905,'root','2014-03-07 20:58:49',26,1),(203,203,'190','add associategroup disassociategroup permissions','SQL','V190__add_associategroup_disassociategroup_permissions.sql',296284732,'root','2014-10-14 23:19:53',30,1),(204,204,'191','update gl account increase size of name col','SQL','V191__update_gl_account_increase_size_of_name_col.sql',-247079901,'root','2014-10-14 23:19:55',1552,1),(205,205,'192','interest recalculate job','SQL','V192__interest_recalculate_job.sql',589462859,'root','2014-10-14 23:19:55',43,1),(206,206,'193','added column joiningDate for staff','SQL','V193__added_column_joiningDate_for_staff.sql',586097114,'root','2014-10-14 23:19:56',1100,1),(207,207,'194','added recalculatedInterestComponent for interest recalculation','SQL','V194__added_recalculatedInterestComponent_for_interest_recalculation.sql',1691292674,'root','2014-10-14 23:19:57',815,1),(208,208,'195','moved rest frequency to product level','SQL','V195__moved_rest_frequency_to_product_level.sql',1697161943,'root','2014-10-14 23:19:59',1551,1),(209,209,'196','added loan running balance to transactions','SQL','V196__added_loan_running_balance_to_transactions.sql',320541466,'root','2014-10-14 23:20:00',1091,1),(210,210,'197','updated loan running balance of transactions','SQL','V197__updated_loan_running_balance_of_transactions.sql',514142390,'root','2014-10-14 23:20:00',360,1),(211,211,'198','loan rescheduling tables and permissions','SQL','V198__loan_rescheduling_tables_and_permissions.sql',320951317,'root','2014-10-14 23:20:05',4569,1),(212,212,'199','removed extra columns from schedule history','SQL','V199__removed_extra_columns_from_schedule_history.sql',-885550667,'root','2014-10-14 23:20:06',695,1),(2,2,'2','mifosx-base-reference-data-utf8','SQL','V2__mifosx-base-reference-data-utf8.sql',1316484475,'root','2014-03-07 20:58:38',106,1),(20,20,'20','report maint perms really configuration','SQL','V20__report_maint_perms_really_configuration.sql',-402845015,'root','2014-03-07 20:58:49',31,1),(213,213,'200','alter savings account for start interest calculation date','SQL','V200__alter_savings_account_for_start_interest_calculation_date.sql',338554725,'root','2014-10-14 23:20:07',1303,1),(214,214,'201','webhooks','SQL','V201__webhooks.sql',1446707293,'root','2014-10-14 23:20:10',3093,1),(215,215,'202','savings officer history table','SQL','V202__savings_officer_history_table.sql',445151847,'root','2014-10-14 23:20:11',672,1),(216,216,'203','added subbmittedDate loantransaction','SQL','V203__added_subbmittedDate_loantransaction.sql',481117136,'root','2014-10-14 23:20:13',1698,1),(217,217,'204','insert script for charges paid by for accruals','SQL','V204__insert_script_for_charges_paid_by_for_accruals.sql',1126139057,'root','2014-10-14 23:20:13',4,1),(218,218,'205','fix for charge and interest waiver with accruals','SQL','V205__fix_for_charge_and_interest_waiver_with_accruals.sql',620191357,'root','2014-11-02 13:24:39',2022,1),(219,219,'206','interest posting configuration','SQL','V206__interest_posting_configuration.sql',-1024393207,'root','2014-11-02 13:24:40',948,1),(220,220,'207','min max clients per group','SQL','V207__min_max_clients_per_group.sql',-2069742774,'root','2014-12-23 17:05:48',923,1),(221,221,'208','min max clients in group redux','SQL','V208__min_max_clients_in_group_redux.sql',1253715309,'root','2014-12-23 17:05:49',764,1),(222,222,'209','add all report names in m permission table','SQL','V209__add_all_report_names_in_m_permission_table.sql',-801564857,'root','2014-12-23 17:05:49',177,1),(21,21,'21','activation-permissions-for-clients','SQL','V21__activation-permissions-for-clients.sql',-569932376,'root','2014-03-07 20:58:49',328,1),(223,223,'210','track manually adjusted transactions','SQL','V210__track_manually_adjusted_transactions.sql',228516334,'root','2014-12-23 17:05:51',1242,1),(224,224,'211','minimum days between disbursal and first repayment','SQL','V211__minimum_days_between_disbursal_and_first_repayment.sql',888628428,'root','2014-12-23 17:05:53',1831,1),(225,225,'212','add NthDay and DayOfWeek columns loan','SQL','V212__add_NthDay_and_DayOfWeek_columns_loan.sql',1949824258,'root','2014-12-23 17:05:56',3064,1),(226,226,'213','NthDay and DayOfWeek columns should be nullable','SQL','V213__NthDay_and_DayOfWeek_columns_should_be_nullable.sql',1399365002,'root','2014-12-23 17:06:00',4338,1),(227,227,'214','alter table add create SI at disbursement','SQL','V214__alter_table_add_create_SI_at_disbursement.sql',-154407476,'root','2014-12-23 17:06:03',3021,1),(228,228,'215','guarantee on hold fund changes','SQL','V215__guarantee_on_hold_fund_changes.sql',303524926,'root','2014-12-23 17:06:08',5060,1),(229,229,'216','adding loan proposed amount to loan','SQL','V216__adding_loan_proposed_amount_to_loan.sql',348182179,'root','2014-12-23 17:06:13',4172,1),(230,230,'217','client substatus and codevalue description','SQL','V217__client_substatus_and_codevalue_description.sql',1679310398,'root','2014-12-23 17:06:20',7286,1),(231,231,'218','add user and datetime for loan savings transactions','SQL','V218__add_user_and_datetime_for_loan_savings_transactions.sql',-1058697092,'root','2014-12-23 17:06:23',2416,1),(232,232,'219','guarantor on hold fund changes for account','SQL','V219__guarantor_on_hold_fund_changes_for_account.sql',1081934247,'root','2014-12-23 17:06:34',10673,1),(22,22,'22','alter-group-for-consistency-add-permissions','SQL','V22__alter-group-for-consistency-add-permissions.sql',578271556,'root','2014-03-07 20:58:50',841,1),(233,233,'220','account number preferences','SQL','V220__account_number_preferences.sql',-502873750,'root','2014-12-23 17:06:35',1295,1),(234,234,'221','add version for m savings account','SQL','V221__add_version_for_m_savings_account.sql',863858591,'root','2014-12-23 17:06:38',2521,1),(235,235,'222','guarantor on hold fund changes for transactions','SQL','V222__guarantor_on_hold_fund_changes_for_transactions.sql',-1709074177,'root','2014-12-23 17:06:43',5200,1),(236,236,'223','add version for m loan account','SQL','V223__add_version_for_m_loan_account.sql',-973851712,'root','2014-12-23 17:06:49',5675,1),(237,237,'224','client lifecycle adding statuses','SQL','V224__client_lifecycle_adding_statuses.sql',-289697454,'root','2014-12-23 17:07:01',11533,1),(238,238,'225','permissions for updating recurring deposit amount','SQL','V225__permissions_for_updating_recurring_deposit_amount.sql',-1367144205,'root','2014-12-23 17:07:01',41,1),(239,239,'226','configuration for enforcing calendars for jlg loans','SQL','V226__configuration_for_enforcing_calendars_for_jlg_loans.sql',-382855919,'root','2014-12-23 17:07:01',31,1),(240,240,'227','loan-refund-permissions','SQL','V227__loan-refund-permissions.sql',2141152676,'root','2014-12-23 17:07:01',242,1),(241,241,'228','entity to entity access','SQL','V228__entity_to_entity_access.sql',-1244421071,'root','2014-12-23 17:07:03',1255,1),(242,242,'229','teller cash management','SQL','V229__teller_cash_management.sql',753724982,'root','2014-12-23 17:07:05',2441,1),(23,23,'23','remove-enable-disable-configuration-for-client-group-status','SQL','V23__remove-enable-disable-configuration-for-client-group-status.sql',-832390233,'root','2014-03-07 20:58:50',295,1),(243,243,'230','role status and correspoding permissions','SQL','V230__role_status_and_correspoding_permissions.sql',-21174595,'root','2015-04-16 09:28:42',131,1),(244,244,'231','m cashier transaction added currency code','SQL','V231__m_cashier_transaction_added_currency_code.sql',-1593672561,'root','2015-04-16 09:28:42',33,1),(245,245,'232','insert center closure reason','SQL','V232__insert_center_closure_reason.sql',-2049914418,'root','2015-04-16 09:28:42',2,1),(246,246,'233','Savings Transaction Receipt','SQL','V233__Savings_Transaction_Receipt.sql',1836289382,'root','2015-04-16 09:28:42',16,1),(247,247,'234','opening balaces setup','SQL','V234__opening_balaces_setup.sql',1777198314,'root','2015-04-16 09:28:42',30,1),(248,248,'235','add ugd template id m hook','SQL','V235__add_ugd_template_id_m_hook.sql',1120955673,'root','2015-04-16 09:28:42',73,1),(249,249,'236','individual collection sheet permissions','SQL','V236__individual_collection_sheet_permissions.sql',-66130238,'root','2015-04-16 09:28:42',2,1),(250,250,'237','add threshold config for last instalment','SQL','V237__add_threshold_config_for_last_instalment.sql',412873149,'root','2015-04-16 09:28:42',53,1),(251,251,'238','update staff display name length','SQL','V238__update_staff_display_name_length.sql',-1003425306,'root','2015-04-16 09:28:42',57,1),(252,252,'239','Loan Transaction Receipt','SQL','V239__Loan_Transaction_Receipt.sql',-130819179,'root','2015-04-16 09:28:42',3,1),(24,24,'24','add-group-client-foreign-key-constraint-in-loan-table','SQL','V24__add-group-client-foreign-key-constraint-in-loan-table.sql',-621897624,'root','2014-03-07 20:58:51',318,1),(253,253,'240','arrears aging config for interest recalculation','SQL','V240__arrears_aging_config_for_interest_recalculation.sql',674368034,'root','2015-04-16 09:28:42',114,1),(254,254,'241','fixed emi changes','SQL','V241__fixed_emi_changes.sql',1943069939,'root','2015-04-16 09:28:42',47,1),(255,255,'242','entitytoentitymappingrelation','SQL','V242__entitytoentitymappingrelation.sql',-1770973716,'root','2015-04-16 09:28:42',59,1),(256,256,'243','alter loan disbursement details','SQL','V243__alter_loan_disbursement_details.sql',1461060824,'root','2015-04-16 09:28:42',31,1),(257,257,'244','staff assignment history table','SQL','V244__staff_assignment_history_table.sql',-427095856,'root','2015-04-16 09:28:43',30,1),(258,258,'245','open rd changes','SQL','V245__open_rd_changes.sql',2142566381,'root','2015-04-16 09:28:43',2,1),(259,259,'246','drop group client foreign key from m loan','SQL','V246__drop_group_client_foreign_key_from_m_loan.sql',-1721132405,'root','2015-04-16 09:28:43',11,1),(260,260,'247','consistency wrt spelling principalThresholdForLastInstalment','SQL','V247__consistency_wrt_spelling_principalThresholdForLastInstalment.sql',1371980378,'root','2015-04-16 09:28:43',9,1),(261,261,'248','added password never expired to User','SQL','V248__added_password_never_expired_to_User.sql',-1800179163,'root','2015-04-16 09:28:43',37,1),(262,262,'249','workingdays permissions','SQL','V249__workingdays_permissions.sql',-1322891155,'root','2015-04-16 09:28:43',3,1),(25,25,'25','update client reports for status and activation change','SQL','V25__update_client_reports_for_status_and_activation_change.sql',-1426943124,'root','2014-03-07 20:58:51',30,1),(263,263,'250','password validation policy','SQL','V250__password_validation_policy.sql',1197290340,'root','2015-04-16 09:28:43',38,1),(264,264,'251','paymentType table','SQL','V251__paymentType_table.sql',-1969329175,'root','2015-04-16 09:28:43',117,1),(265,265,'252','bug fix teller cash management','SQL','V252__bug_fix_teller_cash_management.sql',-736743970,'root','2015-04-16 09:28:43',167,1),(266,266,'253','product loan configurable attributes','SQL','V253__product_loan_configurable_attributes.sql',1787268316,'root','2015-04-16 09:28:43',15,1),(267,267,'254','General Ledger Report','SQL','V254__General_Ledger_Report.sql',-186920768,'root','2015-04-16 09:28:43',6,1),(268,268,'255','pre close interest period config','SQL','V255__pre_close_interest_period_config.sql',1383225707,'root','2015-04-16 09:28:43',23,1),(269,269,'256','Update script for General Ledger report','SQL','V256__Update script for General_Ledger_report.sql',1918702942,'root','2015-04-16 09:28:43',4,1),(270,270,'257','staff image association','SQL','V257__staff_image_association.sql',1740118046,'root','2015-04-16 09:28:43',37,1),(271,271,'258','interest compounding changes','SQL','V258__interest_compounding_changes.sql',1484848861,'root','2015-05-18 23:20:26',223,1),(272,272,'259','alter working days','SQL','V259__alter_working_days.sql',1733733251,'root','2015-05-18 23:20:26',33,1),(26,26,'26','add-support-for-withdrawal-fees-on-savings','SQL','V26__add-support-for-withdrawal-fees-on-savings.sql',-1955461568,'root','2014-03-07 20:58:52',884,1),(273,273,'260','alter password validation policy','SQL','V260__alter_password_validation_policy.sql',-853716637,'root','2015-05-18 23:20:26',32,1),(27,27,'27','add-loan-type-column-to-loan-table','SQL','V27__add-loan-type-column-to-loan-table.sql',-746287938,'root','2014-03-07 20:58:52',344,1),(28,28,'28','accounting-abstractions-and-autoposting','SQL','V28__accounting-abstractions-and-autoposting.sql',-966431980,'root','2014-03-07 20:58:53',556,1),(29,29,'29','add-support-for-annual-fees-on-savings','SQL','V29__add-support-for-annual-fees-on-savings.sql',992227725,'root','2014-03-07 20:58:55',1556,1),(3,3,'3','mifosx-permissions-and-authorisation-utf8','SQL','V3__mifosx-permissions-and-authorisation-utf8.sql',1922951887,'root','2014-03-07 20:58:38',110,1),(30,30,'30','add-referenceNumber-to-acc gl journal entry','SQL','V30__add-referenceNumber-to-acc_gl_journal_entry.sql',2079970797,'root','2014-03-07 20:58:55',327,1),(31,31,'31','drop-autopostings','SQL','V31__drop-autopostings.sql',630501407,'root','2014-03-07 20:58:55',39,1),(32,32,'32','associate-disassociate-clients-from-group-permissions','SQL','V32__associate-disassociate-clients-from-group-permissions.sql',765311507,'root','2014-03-07 20:58:55',29,1),(33,33,'33','drop unique check on stretchy report parameter','SQL','V33__drop_unique_check_on_stretchy_report_parameter.sql',-716768190,'root','2014-03-07 20:58:56',253,1),(34,34,'34','add unique check on stretchy report parameter','SQL','V34__add_unique_check_on_stretchy_report_parameter.sql',-1989718961,'root','2014-03-07 20:58:56',254,1),(35,35,'35','add hierarchy column for acc gl account','SQL','V35__add_hierarchy_column_for_acc_gl_account.sql',-1387013309,'root','2014-03-07 20:58:57',300,1),(36,36,'36','add tag id column for acc gl account','SQL','V36__add_tag_id_column_for_acc_gl_account.sql',-620418591,'root','2014-03-07 20:58:57',404,1),(37,37,'37','add-center-group-collection-sheet-permissions','SQL','V37__add-center-group-collection-sheet-permissions.sql',-1157429270,'root','2014-03-07 20:58:57',32,1),(38,38,'38','add-group-summary-details-report','SQL','V38__add-group-summary-details-report.sql',-1018394665,'root','2014-03-07 20:58:57',36,1),(39,39,'39','payment-channels-updates','SQL','V39__payment-channels-updates.sql',-1005512239,'root','2014-03-07 20:58:58',1172,1),(4,4,'4','mifosx-core-reports-utf8','SQL','V4__mifosx-core-reports-utf8.sql',-934709187,'root','2014-03-07 20:58:39',287,1),(40,40,'40','add permissions for accounting rule','SQL','V40__add_permissions_for_accounting_rule.sql',1514233058,'root','2014-03-07 20:58:59',37,1),(41,41,'41','group-summary-reports','SQL','V41__group-summary-reports.sql',263779795,'root','2014-03-07 20:58:59',229,1),(42,42,'42','Add default value for id for acc accounting rule','SQL','V42__Add_default_value_for_id_for_acc_accounting_rule.sql',1068680120,'root','2014-03-07 20:58:59',242,1),(43,43,'43','accounting-for-savings','SQL','V43__accounting-for-savings.sql',1965510021,'root','2014-03-07 20:59:00',567,1),(44,44,'44','document-increase-size-of-column-type','SQL','V44__document-increase-size-of-column-type.sql',1264142829,'root','2014-03-07 20:59:00',271,1),(45,45,'45','create acc rule tags table','SQL','V45__create_acc_rule_tags_table.sql',-307868244,'root','2014-03-07 20:59:01',189,1),(46,46,'46','extend datatables api','SQL','V46__extend_datatables_api.sql',297544230,'root','2014-03-07 20:59:01',38,1),(47,47,'47','staff-hierarchy-link-to-users','SQL','V47__staff-hierarchy-link-to-users.sql',480254198,'root','2014-03-07 20:59:02',868,1),(48,48,'48','adding-S3-Support','SQL','V48__adding-S3-Support.sql',-280798781,'root','2014-03-07 20:59:03',1276,1),(49,49,'49','track-loan-charge-payment-transactions','SQL','V49__track-loan-charge-payment-transactions.sql',170618680,'root','2014-03-07 20:59:03',176,1),(5,5,'5','update-savings-product-and-account-tables','SQL','V5__update-savings-product-and-account-tables.sql',1171300485,'root','2014-03-07 20:58:39',636,1),(50,50,'50','add-grace-settings-to-loan-product','SQL','V50__add-grace-settings-to-loan-product.sql',188244658,'root','2014-03-07 20:59:05',926,1),(51,51,'51','track-additional-details-related-to-installment-performance','SQL','V51__track-additional-details-related-to-installment-performance.sql',2012793946,'root','2014-03-07 20:59:05',602,1),(52,52,'52','add boolean support cols to acc accounting rule','SQL','V52__add_boolean_support_cols_to_acc_accounting_rule.sql',961668575,'root','2014-03-07 20:59:06',501,1),(53,53,'53','track-advance-and-late-payments-on-installment','SQL','V53__track-advance-and-late-payments-on-installment.sql',-230737076,'root','2014-03-07 20:59:06',212,1),(54,54,'54','charge-to-income-account-mappings','SQL','V54__charge-to-income-account-mappings.sql',2064168495,'root','2014-03-07 20:59:07',303,1),(55,55,'55','add-additional-transaction-processing-strategies','SQL','V55__add-additional-transaction-processing-strategies.sql',1186305896,'root','2014-03-07 20:59:07',352,1),(56,56,'56','track-overpaid-amount-on-loans','SQL','V56__track-overpaid-amount-on-loans.sql',1455634018,'root','2014-03-07 20:59:07',239,1),(57,57,'57','add default values to debit and credit accounts acc accounting rule','SQL','V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql',1936034654,'root','2014-03-07 20:59:08',272,1),(58,58,'58','create-holiday-tables changed','SQL','V58__create-holiday-tables_changed.sql',878594707,'root','2014-03-07 20:59:08',374,1),(59,59,'59','add group roles schema and permissions','SQL','V59__add_group_roles_schema_and_permissions.sql',2139634800,'root','2014-03-07 20:59:09',259,1),(6,6,'6','add min max principal column to loan','SQL','V6__add_min_max_principal_column_to_loan.sql',21414779,'root','2014-03-07 20:58:40',648,1),(60,60,'60','quipo dashboard reports','SQL','V60__quipo_dashboard_reports.sql',-1414014218,'root','2014-03-07 20:59:09',67,1),(61,61,'61','txn running balance example','SQL','V61__txn_running_balance_example.sql',-1186179870,'root','2014-03-07 20:59:09',43,1),(62,62,'62','add staff id to m client changed','SQL','V62__add_staff_id_to_m_client_changed.sql',-903717279,'root','2014-03-07 20:59:09',289,1),(63,63,'63','add sync disbursement with meeting column to loan','SQL','V63__add_sync_disbursement_with_meeting_column_to_loan.sql',1706011840,'root','2014-03-07 20:59:10',298,1),(64,64,'64','add permission for assign staff','SQL','V64__add_permission_for_assign_staff.sql',-1938102414,'root','2014-03-07 20:59:10',36,1),(65,65,'65','fix rupee symbol issues','SQL','V65__fix_rupee_symbol_issues.sql',581612224,'root','2014-03-07 20:59:10',33,1),(66,66,'66','client close functionality','SQL','V66__client_close_functionality.sql',225242657,'root','2014-03-07 20:59:10',357,1),(67,67,'67','loans in advance table','SQL','V67__loans_in_advance_table.sql',-2001051496,'root','2014-03-07 20:59:11',126,1),(68,68,'68','quipo dashboard reports updated','SQL','V68__quipo_dashboard_reports_updated.sql',-1241469930,'root','2014-03-07 20:59:11',74,1),(69,69,'69','loans in advance initialise','SQL','V69__loans_in_advance_initialise.sql',-1961764720,'root','2014-03-07 20:59:11',44,1),(7,7,'7','remove read makerchecker permission','SQL','V7__remove_read_makerchecker_permission.sql',-335430825,'root','2014-03-07 20:58:40',37,1),(70,70,'70','quipo program detail query fix','SQL','V70__quipo_program_detail_query_fix.sql',961289260,'root','2014-03-07 20:59:11',37,1),(71,71,'71','insert reschedule repayment to configuration','SQL','V71__insert_reschedule_repayment_to_configuration.sql',-1148306529,'root','2014-03-07 20:59:11',29,1),(72,72,'72','add m loan counter changes','SQL','V72__add_m_loan_counter_changes.sql',201544058,'root','2014-03-07 20:59:12',487,1),(73,73,'73','add repayments rescheduled to and processed column to holiday','SQL','V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql',-1946338033,'root','2014-03-07 20:59:12',265,1),(74,74,'74','alter m loan counter table add group','SQL','V74__alter_m_loan_counter_table_add_group.sql',-889985683,'root','2014-03-07 20:59:13',322,1),(75,75,'75','add reschedule-repayments-on-holidays to configuration','SQL','V75__add_reschedule-repayments-on-holidays_to_configuration.sql',1328301697,'root','2014-03-07 20:59:13',24,1),(76,76,'76','rename permission grouping','SQL','V76__rename_permission_grouping.sql',1717580945,'root','2014-03-07 20:59:13',28,1),(77,77,'77','alter m product loan changes','SQL','V77__alter_m_product_loan_changes.sql',677013677,'root','2014-03-07 20:59:13',283,1),(78,78,'78','breakdown portfolio grouping','SQL','V78__breakdown_portfolio_grouping.sql',-1385954232,'root','2014-03-07 20:59:13',28,1),(79,79,'79','schedule jobs tables','SQL','V79__schedule_jobs_tables.sql',339707179,'root','2014-03-07 20:59:14',435,1),(8,8,'8','deposit-transaction-permissions-if-they-exist','SQL','V8__deposit-transaction-permissions-if-they-exist.sql',-1507997551,'root','2014-03-07 20:58:40',6,1),(80,80,'80','schedule jobs tables updates','SQL','V80__schedule_jobs_tables_updates.sql',-152869205,'root','2014-03-07 20:59:15',1507,1),(81,81,'81','savings related changes','SQL','V81__savings_related_changes.sql',285284658,'root','2014-03-07 20:59:17',1593,1),(82,82,'82','schedule jobs tables updates for running status','SQL','V82__schedule_jobs_tables_updates_for_running_status.sql',-1029370098,'root','2014-03-07 20:59:18',621,1),(83,83,'83','non-working-days-table','SQL','V83__non-working-days-table.sql',-1092480574,'root','2014-03-07 20:59:18',138,1),(84,84,'84','undo savings transaction permission','SQL','V84__undo_savings_transaction_permission.sql',1857641857,'root','2014-03-07 20:59:18',31,1),(85,85,'85','product mix related changes','SQL','V85__product_mix_related_changes.sql',-740767169,'root','2014-03-07 20:59:19',484,1),(86,86,'86','update-working-days','SQL','V86__update-working-days.sql',1266232028,'root','2014-03-07 20:59:19',45,1),(87,87,'87','add permission for scheduler','SQL','V87__add_permission_for_scheduler.sql',-575950289,'root','2014-03-07 20:59:19',27,1),(88,88,'88','added update constrain for scheduler jobs','SQL','V88__added_update_constrain_for_scheduler_jobs.sql',1579070736,'root','2014-03-07 20:59:20',380,1),(89,89,'89','added scheduler group','SQL','V89__added_scheduler_group.sql',-1538207332,'root','2014-03-07 20:59:20',245,1),(9,9,'9','add min max constraint column to loan loanproduct','SQL','V9__add_min_max_constraint_column_to_loan_loanproduct.sql',-2103326932,'root','2014-03-07 20:58:42',1503,1),(90,90,'90','client performance history reports','SQL','V90__client_performance_history_reports.sql',35589718,'root','2014-03-07 20:59:20',51,1),(91,91,'91','apply annual fees permission','SQL','V91__apply_annual_fees_permission.sql',440351308,'root','2014-03-07 20:59:20',34,1),(92,92,'91.1','configuration settings for holiday and non workingday','SQL','V91_1__configuration_settings_for_holiday_and_non_workingday.sql',-429561096,'root','2014-03-07 20:59:20',25,1),(93,93,'92','group center assign staff permission','SQL','V92__group_center_assign_staff_permission.sql',-1557846330,'root','2014-03-07 20:59:20',21,1),(94,94,'93','loan transaction external id','SQL','V93__loan_transaction_external_id.sql',987684239,'root','2014-03-07 20:59:21',252,1),(95,95,'94','added savings accont type','SQL','V94__added_savings_accont type.sql',623078091,'root','2014-03-07 20:59:21',199,1),(96,96,'95','batch job postInterest','SQL','V95__batch_job_postInterest.sql',-1484077135,'root','2014-03-07 20:59:21',25,1),(97,97,'96','savings accounts transfers table','SQL','V96__savings_accounts_transfers_table.sql',-1447275289,'root','2014-03-07 20:59:22',370,1),(98,98,'97','add permission for adjust savings transaction','SQL','V97__add_permission_for_adjust_savings_transaction.sql',-2045732265,'root','2014-03-07 20:59:22',20,1),(99,99,'98','added currency roundof for multipleof','SQL','V98__added_currency_roundof_for_multipleof.sql',-131804848,'root','2014-03-07 20:59:23',1440,1);
 /*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
 UNLOCK TABLES;
 

  `rest_frequency_type_enum` smallint(1) NOT NULL,
  `rest_frequency_interval` smallint(3) NOT NULL DEFAULT '0',
  `rest_freqency_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_m_loan_m_loan_recalculation_details` (`loan_id`),
  CONSTRAINT `FK_m_loan_m_loan_recalculation_details` FOREIGN KEY (`loan_id`) REFERENCES `m_loan` (`id`)

--
-- Host: localhost    Database: mifostenant-default
-- ------------------------------------------------------
-- Server version 5.6.23

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
