Repository: fineract Updated Branches: refs/heads/develop a9a29e51c -> 504f679c8
Correcting V322_1 migration script Project: http://git-wip-us.apache.org/repos/asf/fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/fineract/commit/504f679c Tree: http://git-wip-us.apache.org/repos/asf/fineract/tree/504f679c Diff: http://git-wip-us.apache.org/repos/asf/fineract/diff/504f679c Branch: refs/heads/develop Commit: 504f679c8f5fe77e8bff295563d4c4b77d38a2f6 Parents: a9a29e5 Author: Nazeer Hussain Shaik <[email protected]> Authored: Mon Dec 11 15:14:30 2017 +0530 Committer: Nazeer Hussain Shaik <[email protected]> Committed: Mon Dec 11 15:14:30 2017 +0530 ---------------------------------------------------------------------- .../V322_1__scheduled_email_campaign.sql | 33 ++++++++++++++++++-- 1 file changed, 31 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/fineract/blob/504f679c/fineract-provider/src/main/resources/sql/migrations/core_db/V322_1__scheduled_email_campaign.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V322_1__scheduled_email_campaign.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V322_1__scheduled_email_campaign.sql index 243e036..8e353c7 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V322_1__scheduled_email_campaign.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V322_1__scheduled_email_campaign.sql @@ -17,6 +17,35 @@ -- under the License. -- +CREATE TABLE `scheduled_email_campaign` ( + `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `campaign_name` VARCHAR(100) NOT NULL, + `campaign_type` INT(11) NOT NULL, + `businessRule_id` INT(11) NOT NULL, + `param_value` TEXT NULL, + `status_enum` INT(11) NOT NULL, + `email_subject` VARCHAR(100) NOT NULL, + `email_message` TEXT NOT NULL, + `email_attachment_file_format` VARCHAR(10) NOT NULL, + `stretchy_report_id` INT(11) NOT NULL, + `stretchy_report_param_map` TEXT NULL DEFAULT NULL, + `closedon_date` DATE NULL DEFAULT NULL, + `closedon_userid` BIGINT(20) NULL DEFAULT NULL, + `submittedon_date` DATE NULL DEFAULT NULL, + `submittedon_userid` BIGINT(20) NULL DEFAULT NULL, + `approvedon_date` DATE NULL DEFAULT NULL, + `approvedon_userid` BIGINT(20) NULL DEFAULT NULL, + `recurrence` VARCHAR(100) NULL DEFAULT NULL, + `next_trigger_date` DATETIME NULL DEFAULT NULL, + `last_trigger_date` DATETIME NULL DEFAULT NULL, + `recurrence_start_date` DATETIME NULL DEFAULT NULL, + `is_visible` TINYINT(1) NULL DEFAULT '1', + `previous_run_error_log` TEXT NULL DEFAULT NULL, + `previous_run_error_message` TEXT NULL DEFAULT NULL, + PRIMARY KEY (`id`), + CONSTRAINT `scheduled_email_campaign_ibfk_1` FOREIGN KEY (`stretchy_report_id`) REFERENCES `stretchy_report` (`id`) +); + CREATE TABLE IF NOT EXISTS scheduled_email_messages_outbound ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` bigint(20) DEFAULT NULL, @@ -37,8 +66,8 @@ CREATE TABLE IF NOT EXISTS scheduled_email_messages_outbound ( CONSTRAINT `SEFKGROUP000000001` FOREIGN KEY (`group_id`) REFERENCES `m_group` (`id`), CONSTRAINT `SEFKCLIENT00000001` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`), CONSTRAINT `SEFKSTAFF000000001` FOREIGN KEY (`staff_id`) REFERENCES `m_staff` (`id`), - CONSTRAINT `fk_schedule_email_campign` FOREIGN KEY (`email_campaign_id`) REFERENCES `scheduled_email_campaign` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + CONSTRAINT `fk_schedule_email_campign1` FOREIGN KEY (`email_campaign_id`) REFERENCES `scheduled_email_campaign` (`id`) +); create table if not exists scheduled_email_configuration ( id int primary key auto_increment,
