Merge pull request #23052 from konadave/r25088
[civicrm-core.git] / xml / schema / Core / MappingField.xml
index 0c444143756a4e3d7dfa708876489bac707c6f35..10cf1c4d542dfd03a7b0924f85ec8c763ba33c17 100644 (file)
@@ -12,6 +12,9 @@
     <title>Mapping Field ID</title>
     <required>true</required>
     <comment>Mapping Field ID</comment>
+    <html>
+      <type>Number</type>
+    </html>
     <add>1.2</add>
   </field>
   <primaryKey>
@@ -25,6 +28,9 @@
     <title>Mapping ID</title>
     <required>true</required>
     <comment>Mapping to which this field belongs</comment>
+    <html>
+      <label>Mapping</label>
+    </html>
     <add>1.2</add>
   </field>
   <foreignKey>
@@ -32,6 +38,7 @@
     <table>civicrm_mapping</table>
     <key>id</key>
     <add>1.2</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
     <name>name</name>
@@ -65,6 +72,9 @@
     <type>int unsigned</type>
     <title>Location type ID</title>
     <comment>Location type of this mapping, if required</comment>
+    <html>
+      <label>Location type</label>
+    </html>
     <add>1.2</add>
     <pseudoconstant>
       <table>civicrm_location_type</table>
@@ -80,9 +90,8 @@
   </foreignKey>
   <field>
     <name>phone_type_id</name>
-    <title>Phone Type</title>
-    <type>int unsigned</type>
     <title>Phone type ID</title>
+    <type>int unsigned</type>
     <comment>Which type of phone does this number belongs.</comment>
     <add>2.2</add>
   </field>
     <type>int unsigned</type>
     <title>Relationship type ID</title>
     <comment>Relationship type, if required</comment>
+    <html>
+      <label>Relationship type</label>
+    </html>
     <add>1.2</add>
   </field>
   <foreignKey>