renaming sql script number
Project: http://git-wip-us.apache.org/repos/asf/incubator-fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-fineract/commit/b43d3ef0 Tree: http://git-wip-us.apache.org/repos/asf/incubator-fineract/tree/b43d3ef0 Diff: http://git-wip-us.apache.org/repos/asf/incubator-fineract/diff/b43d3ef0 Branch: refs/heads/develop Commit: b43d3ef06458a1ba1d22d5624b8817be2fa50359 Parents: a0f7da3 Author: Nazeer Hussain Shaik <[email protected]> Authored: Thu Jun 9 16:57:08 2016 +0530 Committer: Nazeer Hussain Shaik <[email protected]> Committed: Thu Jun 9 16:57:08 2016 +0530 ---------------------------------------------------------------------- ...a_from_entitytoentityaccess_to_entitytoentitymapping.sql | 9 --------- ...a_from_entitytoentityaccess_to_entitytoentitymapping.sql | 9 +++++++++ 2 files changed, 9 insertions(+), 9 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/b43d3ef0/fineract-provider/src/main/resources/sql/migrations/core_db/V309__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V309__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V309__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql deleted file mode 100644 index 19e58ae..0000000 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V309__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql +++ /dev/null @@ -1,9 +0,0 @@ -insert ignore into m_entity_to_entity_mapping (from_id,to_id,rel_id) -select mea.entity_id as fromId, -mea.second_entity_id as toid, -case mea.access_type_code_value_id -when 10 then 1 -when 11 then 2 -when 12 then 3 -end as reId -from m_entity_to_entity_access mea \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/b43d3ef0/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql new file mode 100644 index 0000000..19e58ae --- /dev/null +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql @@ -0,0 +1,9 @@ +insert ignore into m_entity_to_entity_mapping (from_id,to_id,rel_id) +select mea.entity_id as fromId, +mea.second_entity_id as toid, +case mea.access_type_code_value_id +when 10 then 1 +when 11 then 2 +when 12 then 3 +end as reId +from m_entity_to_entity_access mea \ No newline at end of file
