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.sh...@confluxtechnologies.com> Authored: Tue Apr 26 11:35:46 2016 +0530 Committer: Nazeer Hussain Shaik <nazeer.sh...@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