fineract-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nazeer1100...@apache.org
Subject [4/4] incubator-fineract git commit: Changing sql script number
Date Tue, 26 Apr 2016 06:11:09 GMT
Changing 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/f9746718
Tree: http://git-wip-us.apache.org/repos/asf/incubator-fineract/tree/f9746718
Diff: http://git-wip-us.apache.org/repos/asf/incubator-fineract/diff/f9746718

Branch: refs/heads/develop
Commit: f9746718fb1c2fb19f11ac260b56d92ab512b1cb
Parents: 93e615b
Author: Nazeer Hussain Shaik <nazeer.shaik@confluxtechnologies.com>
Authored: Tue Apr 26 11:35:46 2016 +0530
Committer: Nazeer Hussain Shaik <nazeer.shaik@confluxtechnologies.com>
Committed: Tue Apr 26 11:35:46 2016 +0530

----------------------------------------------------------------------
 .../core_db/V298__add_status_to_client_identifier.sql          | 6 ------
 .../core_db/V302__add_status_to_client_identifier.sql          | 6 ++++++
 2 files changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/f9746718/fineract-provider/src/main/resources/sql/migrations/core_db/V298__add_status_to_client_identifier.sql
----------------------------------------------------------------------
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V298__add_status_to_client_identifier.sql
b/fineract-provider/src/main/resources/sql/migrations/core_db/V298__add_status_to_client_identifier.sql
deleted file mode 100644
index 9397b2e..0000000
--- a/fineract-provider/src/main/resources/sql/migrations/core_db/V298__add_status_to_client_identifier.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-ALTER TABLE `m_client_identifier`
-  ADD COLUMN `status` INT(5) NOT NULL DEFAULT 300 AFTER `document_key`,
-  DROP INDEX `unique_client_identifier`,
-  ADD COLUMN `active` INT(5) NULL DEFAULT NULL AFTER `status`,
-  ADD UNIQUE INDEX `unique_active_client_identifier` (`client_id`, `document_type_id`, `active`
);
-  
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/f9746718/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql
----------------------------------------------------------------------
diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql
b/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql
new file mode 100644
index 0000000..9397b2e
--- /dev/null
+++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `m_client_identifier`
+  ADD COLUMN `status` INT(5) NOT NULL DEFAULT 300 AFTER `document_key`,
+  DROP INDEX `unique_client_identifier`,
+  ADD COLUMN `active` INT(5) NULL DEFAULT NULL AFTER `status`,
+  ADD UNIQUE INDEX `unique_active_client_identifier` (`client_id`, `document_type_id`, `active`
);
+  
\ No newline at end of file


Mime
View raw message