xml/schema/Mailing/MailingAB.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Mailing</base>
   5   <class>MailingAB</class>
   6   <name>civicrm_mailing_abtesting</name>
   7   <comment>Stores information about abtesting</comment>
   8   <archive>true</archive>
   9   <field>
  10     <name>id</name>
  11     <type>int unsigned</type>
  12     <required>true</required>
  13   </field>
  14   <primaryKey>
  15     <name>id</name>
  16     <autoincrement>true</autoincrement>
  17   </primaryKey>
  18   <field>
  19     <name>name</name>
  20     <type>varchar</type>
  21     <length>25</length>
  22     <comment>name of abtesting</comment>
  23     <add>4.5</add>
  24   </field>
  25   <field>
  26     <name>mailing_id_a</name>
  27     <type>int unsigned</type>
  28     <comment>Id of mailing A</comment>
  29     <add>4.5</add>
  30   </field>
  31   <field>
  32     <name>mailing_id_b</name>
  33     <type>int unsigned</type>
  34     <comment>Id of mailing B</comment>
  35     <add>4.5</add>
  36   </field>
  37   <field>
  38     <name>mailing_id_c</name>
  39     <type>int unsigned</type>
  40     <comment>temporary mailing which is created during a/b testing</comment>
  41     <add>4.5</add>
  42   </field>
  43   <field>
  44     <name>domain_id</name>
  45     <type>int unsigned</type>
  46     <comment>Which site is this mailing for</comment>
  47     <add>4.5</add>
  48   </field>
  49   <field>
  50     <name>testing_criteria_id</name>
  51     <type>int unsigned</type>
  52     <pseudoconstant>
  53       <optionGroupName>mailing_ab_testing_criteria</optionGroupName>
  54     </pseudoconstant>
  55     <add>4.5</add>
  56   </field>
  57   <field>
  58     <name>winner_criteria_id</name>
  59     <type>int unsigned</type>
  60     <pseudoconstant>
  61       <optionGroupName>mailing_ab_winner_criteria</optionGroupName>
  62     </pseudoconstant>
  63     <add>4.5</add>
  64   </field>
  65   <field>
  66     <name>specific_url</name>
  67     <type>varchar</type>
  68     <length>255</length>
  69     <comment>What specific url to track</comment>
  70     <add>4.5</add>
  71   </field>
  72   <field>
  73     <name>declare_winning_time</name>
  74     <type>datetime</type>
  75     <comment>In how much time to declare winner</comment>
  76     <add>4.5</add>
  77   </field>
  78   <field>
  79     <name>group_percentage</name>
  80     <type>int unsigned</type>
  81     <add>4.5</add>
  82   </field>
  83
  84 </table>