From f85837defdc7c0c31e59bcadba2871cec873869b Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Tue, 24 Jun 2014 01:54:18 +1200 Subject: [PATCH] CRM-14903 alter enum field on civicrm_mapping_field to reflect allowed operators --- CRM/Upgrade/Incremental/sql/4.4.6.mysql.tpl | 3 +++ xml/schema/Core/MappingField.xml | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.4.6.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.4.6.mysql.tpl index aff565eb13..2641d8fcda 100644 --- a/CRM/Upgrade/Incremental/sql/4.4.6.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.4.6.mysql.tpl @@ -1 +1,4 @@ {* file to handle db changes in 4.4.6 during upgrade *} +-- CRM-14903 +ALTER TABLE `civicrm_mapping_field` +CHANGE COLUMN `operator` `operator` ENUM('=','!=','>','<','>=','<=','IN','NOT IN','LIKE','NOT LIKE','IS NULL','IS NOT NULL', 'IS EMPTY', 'IS NOT EMPTY', 'REGEX'); diff --git a/xml/schema/Core/MappingField.xml b/xml/schema/Core/MappingField.xml index 21882a9ee4..a2701795f2 100644 --- a/xml/schema/Core/MappingField.xml +++ b/xml/schema/Core/MappingField.xml @@ -130,7 +130,7 @@ operator enum =, !=, >, <, >=, <=, - IN, NOT IN, LIKE, NOT LIKE, IS NULL, IS NOT NULL + IN, NOT IN, LIKE, NOT LIKE, IS NULL, IS NOT NULL, IS EMPTY, IS NOT EMPTY, REGEX SQL WHERE operator for search-builder mapping fields (search criteria). 1.5 -- 2.25.1