You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@fineract.apache.org by aw...@apache.org on 2020/04/17 21:40:49 UTC
[fineract] branch develop updated: escape all `grouping` in SQL
files for MySQL 8 compatibility (#757)
This is an automated email from the ASF dual-hosted git repository.
awasum pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git
The following commit(s) were added to refs/heads/develop by this push:
new c7b58b9 escape all `grouping` in SQL files for MySQL 8 compatibility (#757)
c7b58b9 is described below
commit c7b58b986981e79106838f0cdf25c881b2eca961
Author: Michael Vorburger ⛑️ <mi...@vorburger.ch>
AuthorDate: Fri Apr 17 23:40:42 2020 +0200
escape all `grouping` in SQL files for MySQL 8 compatibility (#757)
Indirectly related to FINERACT-762 - not sure if strictly required,
but seems like a good idea anyway at this opportunity, so why not.
As originally on https://github.com/apache/fineract/pull/638/files
---
.../V134_2__permissions_spelling_correction.sql | 2 +-
..._add_group_and_client_pending_configuration.sql | 12 ++++++------
.../V202__savings_officer_history_table.sql | 4 ++--
...20__report_maint_perms_really_configuration.sql | 2 +-
.../core_db/V229__teller_cash_management.sql | 16 ++++++++--------
.../core_db/V250__password_validation_policy.sql | 6 +++---
.../core_db/V257__staff_image_association.sql | 4 ++--
...sert_paymenttype_and_report_read_permission.sql | 4 ++--
.../migrations/core_db/V324__datatable_checks.sql | 6 +++---
.../sql/migrations/core_db/V352__interop_init.sql | 22 +++++++++++-----------
...__mifosx-permissions-and-authorisation-utf8.sql | 10 +++++-----
.../core_db/V4__mifosx-core-reports-utf8.sql | 2 +-
.../core_db/V76__rename_permission_grouping.sql | 8 ++++----
.../core_db/V78__breakdown_portfolio_grouping.sql | 4 ++--
...posit-transaction-permissions-if-they-exist.sql | 2 +-
.../V92__group_center_assign_staff_permission.sql | 4 ++--
16 files changed, 54 insertions(+), 54 deletions(-)
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql
index 333819e..ca0bda2 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql
@@ -17,4 +17,4 @@
-- under the License.
--
-update m_permission set grouping="organisation" where grouping = "organistion";
+update m_permission set `grouping`="organisation" where grouping = "organistion";
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql
index 7d355ef..828cecf 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql
@@ -26,13 +26,13 @@ INSERT INTO c_configuration (`name`, `enabled`) VALUES ('allow-pending-client-st
INSERT INTO c_configuration (`name`, `enabled`) VALUES ('allow-pending-group-status', '0');
-INSERT INTO .`r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
+INSERT INTO `r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
VALUES ('status_id', '0', 'Invalid', 'Invalid');
-INSERT INTO .`r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
+INSERT INTO `r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
VALUES ('status_id', '100', 'Pending', 'Pending');
-INSERT INTO .`r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
+INSERT INTO `r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
VALUES ('status_id', '300', 'Active', 'Active');
-INSERT INTO .`r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
+INSERT INTO `r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
VALUES ('status_id', '600', 'Closed', 'Closed');
-INSERT INTO .`r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
- VALUES ('loan_status_id', '0', 'Invalid', 'Invalid');
\ No newline at end of file
+INSERT INTO `r_enum_value` (`enum_name`, `enum_id`, `enum_message_property`, `enum_value`)
+ VALUES ('loan_status_id', '0', 'Invalid', 'Invalid');
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V202__savings_officer_history_table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V202__savings_officer_history_table.sql
index e43ee03..f258414 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V202__savings_officer_history_table.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V202__savings_officer_history_table.sql
@@ -34,6 +34,6 @@ CREATE TABLE `m_savings_officer_assignment_history` (
CONSTRAINT `fk_m_savings_officer_assignment_history_0002` FOREIGN KEY (`savings_officer_id`) REFERENCES `m_staff` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-insert into m_permission (grouping,code,entity_name,action_name) values ('portfolio','REMOVESAVINGSOFFICER_SAVINGSACCOUNT','SAVINGSACCOUNT','REMOVESAVINGSOFFICER');
-insert into m_permission (grouping,code,entity_name,action_name) values ('portfolio','UPDATESAVINGSOFFICER_SAVINGSACCOUNT','SAVINGSACCOUNT','UPDATESAVINGSOFFICER');
+insert into m_permission (`grouping`,code,entity_name,action_name) values ('portfolio','REMOVESAVINGSOFFICER_SAVINGSACCOUNT','SAVINGSACCOUNT','REMOVESAVINGSOFFICER');
+insert into m_permission (`grouping`,code,entity_name,action_name) values ('portfolio','UPDATESAVINGSOFFICER_SAVINGSACCOUNT','SAVINGSACCOUNT','UPDATESAVINGSOFFICER');
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V20__report_maint_perms_really_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V20__report_maint_perms_really_configuration.sql
index 31ba00f..8e511e0 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V20__report_maint_perms_really_configuration.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V20__report_maint_perms_really_configuration.sql
@@ -18,4 +18,4 @@
--
-update m_permission set grouping = 'configuration' where entity_name = 'report';
+update m_permission set `grouping` = 'configuration' where entity_name = 'report';
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V229__teller_cash_management.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V229__teller_cash_management.sql
index 41c2d94..659d25f 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V229__teller_cash_management.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V229__teller_cash_management.sql
@@ -69,42 +69,42 @@ CREATE TABLE `m_cashier_transactions` (
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'CREATE_TELLER', 'TELLER', 'CREATE', 1
);
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'UPDATE_TELLER', 'TELLER', 'CREATE', 1
);
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'ALLOCATECASHIER_TELLER', 'TELLER', 'ALLOCATE', 1
);
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'UPDATECASHIERALLOCATION_TELLER', 'TELLER', 'UPDATECASHIERALLOCATION', 1
);
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'DELETECASHIERALLOCATION_TELLER', 'TELLER', 'DELETECASHIERALLOCATION', 1
);
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'ALLOCATECASHTOCASHIER_TELLER', 'TELLER', 'ALLOCATECASHTOCASHIER', 1
);
INSERT INTO m_permission (
- grouping, code, entity_name, action_name, can_maker_checker
+ `grouping`, code, entity_name, action_name, can_maker_checker
) values (
'cash_mgmt', 'SETTLECASHFROMCASHIER_TELLER', 'TELLER', 'SETTLECASHFROMCASHIER', 1
);
@@ -123,4 +123,4 @@ CREATE TABLE `m_cashier_transactions` (
enum_name, enum_id, enum_message_property, enum_value, enum_type
) values (
'teller_status', 600, 'Closed', 'Closed',0
- );
\ No newline at end of file
+ );
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V250__password_validation_policy.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V250__password_validation_policy.sql
index 5bb1d27..770d293 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V250__password_validation_policy.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V250__password_validation_policy.sql
@@ -47,13 +47,13 @@ VALUES (
NULL , '^(?=.*\\d)(?=.*[a-z])(?=.*[A-Z])(?!.*\\s).{6,50}$', 'Password must be at least 6 characters, no more than 50 characters long, must include at least one upper case letter, one lower case letter, one numeric digit and no space', '0'
);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUE ("authorisation","READ_PASSWORD_PREFERENCES","PASSWORD_PREFERENCES","READ",0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUE ("authorisation","UPDATE_PASSWORD_PREFERENCES","PASSWORD_PREFERENCES","UPDATE",0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUE ("authorisation","UPDATE_PASSWORD_PREFERENCES_CHECKER","PASSWORD_PREFERENCES","UPDATE_CHECKER",0);
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V257__staff_image_association.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V257__staff_image_association.sql
index 7bbc3d2..38d987c 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V257__staff_image_association.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V257__staff_image_association.sql
@@ -22,7 +22,7 @@ ALTER TABLE `m_staff`
ADD CONSTRAINT `FK_m_staff_m_image` FOREIGN KEY (`image_id`) REFERENCES `m_image` (`id`);
INSERT INTO m_permission (
-grouping ,
+`grouping` ,
code ,
entity_name ,
action_name ,
@@ -32,4 +32,4 @@ can_maker_checker
('portfolio', 'CREATE_STAFFIMAGE', 'STAFFIMAGE', 'CREATE', '1'),
('portfolio', 'CREATE_STAFFIMAGE_CHECKER', 'STAFFIMAGE', 'CREATE', '0'),
('portfolio', 'DELETE_STAFFIMAGE', 'STAFFIMAGE', 'DELETE', '1'),
-('portfolio', 'DELETE_STAFFIMAGE_CHECKER', 'STAFFIMAGE', 'DELETE', '0');
\ No newline at end of file
+('portfolio', 'DELETE_STAFFIMAGE_CHECKER', 'STAFFIMAGE', 'DELETE', '0');
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V264__insert_paymenttype_and_report_read_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V264__insert_paymenttype_and_report_read_permission.sql
index cde3ee7..d4239ad 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V264__insert_paymenttype_and_report_read_permission.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V264__insert_paymenttype_and_report_read_permission.sql
@@ -17,5 +17,5 @@
-- under the License.
--
-INSERT INTO m_permission (grouping,code,entity_name,action_name,can_maker_checker) VALUES ('portfolio','READ_PAYMENTTYPE','PAYMENTTYPE','READ',0);
-INSERT INTO m_permission (grouping,code,entity_name,action_name,can_maker_checker) VALUES ('report','READ_Staff Assignment History','Staff Assignment History(Pentaho)','READ',0);
\ No newline at end of file
+INSERT INTO m_permission (`grouping`,code,entity_name,action_name,can_maker_checker) VALUES ('portfolio','READ_PAYMENTTYPE','PAYMENTTYPE','READ',0);
+INSERT INTO m_permission (`grouping`,code,entity_name,action_name,can_maker_checker) VALUES ('report','READ_Staff Assignment History','Staff Assignment History(Pentaho)','READ',0);
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V324__datatable_checks.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V324__datatable_checks.sql
index 6ba0658..e1acace 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V324__datatable_checks.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V324__datatable_checks.sql
@@ -36,11 +36,11 @@ ENGINE=InnoDB
;
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUE ("datatable","READ_ENTITY_DATATABLE_CHECK","ENTITY_DATATABLE_CHECK","READ",0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUE ("datatable","CREATE_ENTITY_DATATABLE_CHECK","ENTITY_DATATABLE_CHECK","CREATE",0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUE ("datatable","DELETE_ENTITY_DATATABLE_CHECK","ENTITY_DATATABLE_CHECK","DELETE",0);
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V352__interop_init.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V352__interop_init.sql
index c2b4e5f..cec53dc 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V352__interop_init.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V352__interop_init.sql
@@ -48,28 +48,28 @@ INSERT INTO `m_appuser_role` VALUES ((SELECT id FROM m_appuser WHERE username =
-- Interoperation permissions
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'READ_INTERID', 'INTERID', 'READ', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'READ_INTERREQUEST', 'INTERREQUEST', 'READ', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'READ_INTERQUOTE', 'INTERQUOTE', 'READ', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'READ_INTERTRANSFER', 'INTERTRANSFER', 'READ', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'PREPARE_INTERTRANSFER', 'INTERTRANSFER', 'PREPARE', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'CREATE_INTERID', 'INTERID', 'CREATE', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'CREATE_INTERREQUEST', 'INTERREQUEST', 'CREATE', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'CREATE_INTERQUOTE', 'INTERQUOTE', 'CREATE', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'CREATE_INTERTRANSFER', 'INTERTRANSFER', 'CREATE', 0);
-INSERT INTO m_permission (grouping, code, entity_name, action_name, can_maker_checker)
+INSERT INTO m_permission (`grouping`, code, entity_name, action_name, can_maker_checker)
VALUES ('interop', 'DELETE_INTERID', 'INTERID', 'DELETE', 0);
@@ -80,4 +80,4 @@ SELECT id INTO @code_id FROM m_code WHERE code_name = 'PaymentType';
INSERT IGNORE INTO m_code_value (code_id, code_value, order_position) VALUES (@code_id, 'Money Transfer', 1);
-INSERT IGNORE INTO m_payment_type (value, description, order_position) VALUES ('Money Transfer', 'Money Transfer', 1);
\ No newline at end of file
+INSERT IGNORE INTO m_payment_type (value, description, order_position) VALUES ('Money Transfer', 'Money Transfer', 1);
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql
index fb2561c..6c9d948 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql
@@ -330,19 +330,19 @@ INSERT INTO `m_appuser_role` (`appuser_id`, `role_id`) VALUES (1,1);
-- This needs to always happen at end of the script
/* add a create, read, update and delete permission for each registered datatable */
-insert into m_permission(grouping, `code`, entity_name, action_name)
+insert into m_permission(`grouping`, `code`, entity_name, action_name)
select 'datatable', concat('CREATE_', r.registered_table_name), r.registered_table_name, 'CREATE'
from x_registered_table r;
-insert into m_permission(grouping, `code`, entity_name, action_name)
+insert into m_permission(`grouping`, `code`, entity_name, action_name)
select 'datatable', concat('READ_', r.registered_table_name), r.registered_table_name, 'READ'
from x_registered_table r;
-insert into m_permission(grouping, `code`, entity_name, action_name)
+insert into m_permission(`grouping`, `code`, entity_name, action_name)
select 'datatable', concat('UPDATE_', r.registered_table_name), r.registered_table_name, 'UPDATE'
from x_registered_table r;
-insert into m_permission(grouping, `code`, entity_name, action_name)
+insert into m_permission(`grouping`, `code`, entity_name, action_name)
select 'datatable', concat('DELETE_', r.registered_table_name), r.registered_table_name, 'DELETE'
from x_registered_table r;
@@ -350,4 +350,4 @@ from x_registered_table r;
/* regardless of inserted permission settings above, no permissions (transactions) are preselected as being part of the maker-checker process
so, just set the flag to false... the end-user can decide which permissions should be maker-checkerable
*/
-update m_permission set can_maker_checker = false;
\ No newline at end of file
+update m_permission set can_maker_checker = false;
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql
index 3804054..9a238cc 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql
@@ -25,6 +25,6 @@ INSERT INTO `stretchy_report` VALUES (1,'Client Listing','Table',NULL,'Client','
INSERT INTO `stretchy_parameter` VALUES (1,'startDateSelect','startDate','startDate','date','date','today',NULL,NULL,NULL,NULL,NULL),(2,'endDateSelect','endDate','endDate','date','date','today',NULL,NULL,NULL,NULL,NULL),(3,'obligDateTypeSelect','obligDateType','obligDateType','select','number','0',NULL,NULL,NULL,'select * from\r\n(select 1 as id, \"Closed\" as `name` union all\r\nselect 2, \"Disbursal\" ) x\r\norder by x.`id`',NULL),(5,'OfficeIdSelectOne','officeId','Office','select','nu [...]
INSERT INTO `stretchy_report_parameter` VALUES (1,5,NULL),(2,5,NULL),(2,6,NULL),(2,10,NULL),(2,20,NULL),(2,25,NULL),(2,26,NULL),(5,5,NULL),(5,6,NULL),(5,10,NULL),(5,20,NULL),(5,25,NULL),(5,26,NULL),(6,5,NULL),(6,6,NULL),(6,10,NULL),(6,20,NULL),(6,25,NULL),(6,26,NULL),(7,5,NULL),(7,6,NULL),(7,10,NULL),(7,20,NULL),(7,25,NULL),(7,26,NULL),(8,5,NULL),(8,6,NULL),(8,10,NULL),(8,25,NULL),(8,26,NULL),(11,5,NULL),(11,6,NULL),(11,10,NULL),(11,20,NULL),(11,25,NULL),(11,26,NULL),(11,100,NULL),(12,5, [...]
-insert into m_permission(grouping, `code`, entity_name, action_name, can_maker_checker)
+insert into m_permission(`grouping`, `code`, entity_name, action_name, can_maker_checker)
select 'report', concat('READ_', r.report_name), r.report_name, 'READ', false
from stretchy_report r;
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql
index 5def9a6..06565dc 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql
@@ -20,12 +20,12 @@
/* break-out center and group permissions from porfolio grouping */
update m_permission
-set grouping = "portfolio_center"
+set `grouping` = "portfolio_center"
where code like '%center%'
-and grouping like 'portfolio';
+and `grouping` like 'portfolio';
update m_permission
-set grouping = "portfolio_group"
+set `grouping` = "portfolio_group"
where code like '%group%'
-and grouping like 'portfolio';
\ No newline at end of file
+and `grouping` like 'portfolio';
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql
index acc3bef..50f28d3 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql
@@ -20,5 +20,5 @@
/* grouping is misspelt but also should be under accounting */
update m_permission
-set grouping = 'accounting'
-where grouping = 'organistion';
\ No newline at end of file
+set `grouping` = 'accounting'
+where `grouping` = 'organistion';
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql
index 9901d08..d9fc0ae 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql
@@ -17,5 +17,5 @@
-- under the License.
--
-delete from m_permission where grouping = 'transaction_deposit';
+delete from m_permission where `grouping` = 'transaction_deposit';
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql
index c6c4f04..c8c00c1 100644
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql
@@ -17,5 +17,5 @@
-- under the License.
--
-INSERT INTO `m_permission` (grouping,code,`entity_name`,`action_name`,`can_maker_checker`)
-values('portfolio_group','ASSIGNSTAFF_GROUP','GROUP','ASSIGNSTAFF',0);
\ No newline at end of file
+INSERT INTO `m_permission` (`grouping`,code,`entity_name`,`action_name`,`can_maker_checker`)
+values('portfolio_group','ASSIGNSTAFF_GROUP','GROUP','ASSIGNSTAFF',0);