Commit | Line | Data |
---|---|---|
7f254ad8 AE |
1 | {* file to handle db changes in 4.5.0 during upgrade *} |
2 | ||
3 | {include file='../CRM/Upgrade/4.5.0.msg_template/civicrm_msg_template.tpl'} | |
4 | ||
5 | ALTER TABLE `civicrm_action_schedule` | |
6 | ADD COLUMN `sms_template_id` int(10) unsigned DEFAULT NULL COMMENT 'SMS Reminder Template. FK to id in civicrm_msg_template.' AFTER `msg_template_id`, | |
7 | ADD COLUMN `sms_body_text` longtext COLLATE utf8_unicode_ci COMMENT 'Body of the mailing in html format.' AFTER `body_html`, | |
8 | ADD CONSTRAINT `FK_civicrm_action_schedule_sms_template_id` FOREIGN KEY (`sms_template_id`) REFERENCES civicrm_msg_template(`id`) ON DELETE SET NULL; | |
9 | ||
10 | ALTER TABLE `civicrm_msg_template` | |
11 | ADD COLUMN `is_sms` tinyint(4) DEFAULT '0' COMMENT 'Is this message template used for sms?'; |