Introduce new `formal_title` field for contacts

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.5.alpha1.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
index 3fd798cb0f886019e2cbba23fa45d2fae7543a35..dc952096649e4e1a961613c5e1fd78d30490c2af 100644 (file)
--- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
@@ -1 +1,4 @@
 {* file to handle db changes in 4.5.alpha1 during upgrade *}
+
+ALTER TABLE `civicrm_contact`
+  ADD COLUMN `formal_title` varchar(64) COMMENT 'Formal (academic or similar) title in front of name. (Prof., Dr. etc.)' AFTER `suffix_id`;