From 343630f4f7cd2cffed5838086b2dd6a1f665db9e Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 13 Sep 2014 16:05:46 +0100 Subject: [PATCH] Add upgrade script for 4.6alpha1 --- CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl index 77b196b523..4fcfbad697 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl @@ -55,4 +55,16 @@ ALTER TABLE `civicrm_contribution` ADD `creditnote_id` varchar(255) COLLATE utf8 -- Add new column is_billing_required in contribution_page and event table ALTER TABLE `civicrm_event` ADD COLUMN `is_billing_required` tinyint(4) DEFAULT '0' COMMENT 'Billing block required for Event'; -ALTER TABLE `civicrm_contribution_page` ADD COLUMN `is_billing_required` tinyint(4) DEFAULT '0' COMMENT 'Billing block required for Contribution Page'; \ No newline at end of file +ALTER TABLE `civicrm_contribution_page` ADD COLUMN `is_billing_required` tinyint(4) DEFAULT '0' COMMENT 'Billing block required for Contribution Page'; + +-- CRM-15256 +ALTER TABLE civicrm_action_schedule ADD used_for VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Used for repeating entity' AFTER sms_provider_id; + +CREATE TABLE IF NOT EXISTS `civicrm_recurring_entity` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key', + `parent_id` int(10) unsigned NOT NULL COMMENT 'recurring entity parent id', + `entity_id` int(10) unsigned DEFAULT NULL COMMENT 'recurring entity child id', + `entity_table` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'physical tablename for entity, e.g. civicrm_event', + `mode` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-this entity, 2-this and the following entities, 3-all the entities', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=87 ; -- 2.25.1