From 775bdf880fc79d1ee736f054f7f51b1fe694db4f Mon Sep 17 00:00:00 2001 From: Web Access Date: Thu, 22 Jan 2015 11:18:54 +0530 Subject: [PATCH] Added missing table civicrm_mailing_abtest in 4.6.alpha1.mysql.tpl --- .../Incremental/sql/4.6.alpha1.mysql.tpl | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl index f7b6b40cb9..4f6618f073 100755 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl @@ -29,6 +29,23 @@ INSERT INTO `civicrm_navigation` VALUES ( {$domainID}, 'civicrm/admin/setting/preferences/contribute', '{ts escape="sql" skip="true"}CiviContribute Component Settings{/ts}', 'CiviContribute Component Settings', 'administer CiviCRM', '', @parent_id, '1', NULL, @add_weight_id + 1 ); +CREATE TABLE IF NOT EXISTS `civicrm_mailing_abtest` ( + `id` int unsigned NOT NULL AUTO_INCREMENT , + `name` varchar(128) COMMENT '', + `status` varchar(32) COMMENT '', + `mailing_id_a` int unsigned COMMENT '', + `mailing_id_b` int unsigned COMMENT '', + `mailing_id_c` int unsigned COMMENT '', + `domain_id` int unsigned COMMENT '', + `testing_criteria_id` int unsigned , + `winner_criteria_id` int unsigned , + `specific_url` varchar(255) COMMENT '', + `declare_winning_time` datetime COMMENT '', + `group_percentage` int unsigned +, + PRIMARY KEY ( `id` ) +) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; + -- Insert menu items under "Mailings" for A/B Tests SELECT @parent_id := id from `civicrm_navigation` where name = 'Mailings' AND domain_id = {$domainID}; SELECT @add_weight_id := weight from `civicrm_navigation` where `name` = 'Find Mass SMS' and `parent_id` = @parent_id; -- 2.25.1