CRM-13497 - getting there on main tables
[civicrm-core.git] / xml / schema / Activity / ActivityContact.xml
index 36268c9663527be83b83987149563e7c4334f2de..638a06fb7aaa9a80df98edb562720ff514af685f 100644 (file)
     <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-    <name>record_type</name>
-    <type>enum</type>
-    <title>Record Type</title>
-    <values>Source, Assignee, Target</values>
-    <comment>The record type for this row</comment>
+    <name>record_type_id</name>
+    <type>int unsigned</type>
+    <title>Record Type ID</title>
+    <comment>The record type id for this row</comment>
+    <pseudoconstant>
+      <optionGroupName>activity_contacts</optionGroupName>
+    </pseudoconstant>
+    <html>
+      <type>Select></type>
+    </html>
     <add>4.4</add>
   </field>
   <index>
-       <name>UI_activity_contact</name>
-       <fieldName>contact_id</fieldName>
-       <fieldName>activity_id</fieldName>
-       <fieldName>record_type</fieldName>
-       <unique>true</unique>
-       <add>4.4</add>
+    <name>UI_activity_contact</name>
+    <fieldName>contact_id</fieldName>
+    <fieldName>activity_id</fieldName>
+    <fieldName>record_type_id</fieldName>
+    <unique>true</unique>
+    <add>4.4</add>
   </index>
 
-
 </table>