fineract-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nazeer1100...@apache.org
Subject fineract git commit: Correcting V322_1 migration script
Date Mon, 11 Dec 2017 09:45:00 GMT
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 <nazeer.shaik@confluxtechnologies.com>
Authored: Mon Dec 11 15:14:30 2017 +0530
Committer: Nazeer Hussain Shaik <nazeer.shaik@confluxtechnologies.com>
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,


Mime
View raw message