CRM-12167: Start Implementation of Visibility per Price Option
[civicrm-core.git] / xml / schema / Mailing / MailingAB.xml
index 16fde2785fe8fb4c8fbda817481fff9801dfbcc6..8bacee1aa718fe0a41965e4247d0d8827f39b590 100644 (file)
@@ -22,7 +22,7 @@
     <length>128</length>
     <title>Name</title>
     <comment>Name of the A/B test</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>status</name>
     <title>Status</title>
     <comment>Status</comment>
     <pseudoconstant>
-      <optionGroupName>mailing_ab_status</optionGroupName>
-      <keyColumn>name</keyColumn>
+      <callback>CRM_Mailing_PseudoConstant::abStatus</callback>
     </pseudoconstant>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>mailing_id_a</name>
     <type>int unsigned</type>
     <title>Mailing ID (A)</title>
     <comment>The first experimental mailing ("A" condition)</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>mailing_id_b</name>
     <type>int unsigned</type>
     <title>Mailing ID (B)</title>
     <comment>The second experimental mailing ("B" condition)</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>mailing_id_c</name>
     <type>int unsigned</type>
     <title>Mailing ID (C)</title>
     <comment>The final, general mailing (derived from A or B)</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>domain_id</name>
     <type>int unsigned</type>
     <title>Domain ID</title>
     <comment>Which site is this mailing for</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
-    <name>testing_criteria_id</name>
-    <type>int unsigned</type>
-    <title>Testing Criteria ID</title>
+    <name>testing_criteria</name>
+    <type>varchar</type>
+    <length>32</length>
+    <title>Testing Criteria</title>
     <pseudoconstant>
-      <optionGroupName>mailing_ab_testing_criteria</optionGroupName>
+      <callback>CRM_Mailing_PseudoConstant::abTestCriteria</callback>
     </pseudoconstant>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
-    <name>winner_criteria_id</name>
-    <type>int unsigned</type>
-    <title>Winner Criteria ID</title>
+    <name>winner_criteria</name>
+    <type>varchar</type>
+    <length>32</length>
+    <title>Winner Criteria</title>
     <pseudoconstant>
-      <optionGroupName>mailing_ab_winner_criteria</optionGroupName>
+      <callback>CRM_Mailing_PseudoConstant::abWinnerCriteria</callback>
     </pseudoconstant>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>specific_url</name>
     <title>URL for Winner Criteria</title>
     <length>255</length>
     <comment>What specific url to track</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>declare_winning_time</name>
     <type>datetime</type>
     <title>Declaration Time</title>
     <comment>In how much time to declare winner</comment>
-    <add>4.5</add>
+    <add>4.6</add>
   </field>
   <field>
     <name>group_percentage</name>
     <type>int unsigned</type>
     <title>Group Percentage</title>
-    <add>4.5</add>
+    <add>4.6</add>
+  </field>
+  <field>
+    <name>created_id</name>
+    <title>AB Test Created By</title>
+    <type>int unsigned</type>
+    <comment>FK to Contact ID</comment>
+    <add>4.6</add>
+  </field>
+  <foreignKey>
+    <name>created_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>4.6</add>
+    <onDelete>SET NULL</onDelete>
+  </foreignKey>
+  <field>
+    <name>created_date</name>
+    <title>AB Test Created Date</title>
+    <type>timestamp</type>
+    <required>false</required>
+    <default>CURRENT_TIMESTAMP</default>
+    <comment>When was this item created</comment>
+    <add>4.6</add>
+    <html>
+      <type>Select Date</type>
+    </html>
   </field>
-
 </table>