From 329682dd95b688b4f00cac6500d50e7ecf0522c2 Mon Sep 17 00:00:00 2001 From: Edsel Date: Thu, 6 Feb 2014 18:06:53 +0530 Subject: [PATCH] MISC-32 Added comment from xml/schema --- CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl index dcc3ecf201..f1ddbf7734 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl @@ -521,7 +521,9 @@ WHERE co.id IS NULL; -- CRM-14197 Add contribution_id to civicrm_line_item -ALTER TABLE civicrm_line_item ADD contribution_id INT(10) NULL AFTER entity_id; +ALTER TABLE civicrm_line_item ADD contribution_id INT(10) COMMENT 'Formal (academic or similar) title in front of name. (Prof., Dr. etc.)' NULL AFTER entity_id; + +-- FK to civicrm_contribution ALTER TABLE civicrm_line_item ADD CONSTRAINT `FK_civicrm_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES civicrm_contribution (`id`) ON DELETE SET NULL; -- 2.25.1