You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@fineract.apache.org by na...@apache.org on 2016/06/09 12:43:20 UTC

[3/3] incubator-fineract git commit: renaming sql script number

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 <na...@confluxtechnologies.com>
Authored: Thu Jun 9 16:57:08 2016 +0530
Committer: Nazeer Hussain Shaik <na...@confluxtechnologies.com>
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