[civicrm-core.git] / xml / schema / Mailing / MailingAB.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Mailing</base>
  <class>MailingAB</class>
  <name>civicrm_mailing_abtest</name>
  <comment>Stores information about abtesting</comment>
  <archive>true</archive>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <title>MailingAB ID</title>
    <required>true</required>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <type>varchar</type>
    <length>128</length>
    <title>Name</title>
    <comment>Name of the A/B test</comment>
    <add>4.6</add>
  </field>
  <field>
    <name>status</name>
    <type>varchar</type>
    <length>32</length>
    <title>Status</title>
    <comment>Status</comment>
    <pseudoconstant>
      <callback>CRM_Mailing_PseudoConstant::abStatus</callback>
    </pseudoconstant>
    <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.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.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.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.6</add>
  </field>
  <field>
    <name>testing_criteria</name>
    <type>varchar</type>
    <length>32</length>
    <title>Testing Criteria</title>
    <pseudoconstant>
      <callback>CRM_Mailing_PseudoConstant::abTestCriteria</callback>
    </pseudoconstant>
    <add>4.6</add>
  </field>
  <field>
    <name>winner_criteria</name>
    <type>varchar</type>
    <length>32</length>
    <title>Winner Criteria</title>
    <pseudoconstant>
      <callback>CRM_Mailing_PseudoConstant::abWinnerCriteria</callback>
    </pseudoconstant>
    <add>4.6</add>
  </field>
  <field>
    <name>specific_url</name>
    <type>varchar</type>
    <title>URL for Winner Criteria</title>
    <length>255</length>
    <comment>What specific url to track</comment>
    <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.6</add>
  </field>
  <field>
    <name>group_percentage</name>
    <type>int unsigned</type>
    <title>Group Percentage</title>
    <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>
Commit	Line	Data
802d1ee5	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
4aef704e	4	<base>CRM/Mailing</base>
4aef704e	5	<class>MailingAB</class>
172f99a3	6	<name>civicrm_mailing_abtest</name>
4aef704e	7	<comment>Stores information about abtesting</comment>
	8	<archive>true</archive>
	9	<field>
	10	<name>id</name>
	11	<type>int unsigned</type>
bd6658bd	12	<title>MailingAB ID</title>
4aef704e	13	<required>true</required>
	14	</field>
	15	<primaryKey>
	16	<name>id</name>
	17	<autoincrement>true</autoincrement>
	18	</primaryKey>
ef643544	19	<field>
	20	<name>name</name>
	21	<type>varchar</type>
840e3c4a	22	<length>128</length>
bd6658bd	23	<title>Name</title>
840e3c4a	24	<comment>Name of the A/B test</comment>
4b0cbc50	25	<add>4.6</add>
840e3c4a TO	26	</field>
	27	<field>
	28	<name>status</name>
	29	<type>varchar</type>
	30	<length>32</length>
	31	<title>Status</title>
	32	<comment>Status</comment>
	33	<pseudoconstant>
321121a1	34	<callback>CRM_Mailing_PseudoConstant::abStatus</callback>
840e3c4a	35	</pseudoconstant>
4b0cbc50	36	<add>4.6</add>
ef643544	37	</field>
4aef704e	38	<field>
	39	<name>mailing_id_a</name>
	40	<type>int unsigned</type>
bd6658bd TO	41	<title>Mailing ID (A)</title>
bd6658bd TO	42	<comment>The first experimental mailing ("A" condition)</comment>
4b0cbc50	43	<add>4.6</add>
4aef704e	44	</field>
	45	<field>
	46	<name>mailing_id_b</name>
	47	<type>int unsigned</type>
bd6658bd TO	48	<title>Mailing ID (B)</title>
bd6658bd TO	49	<comment>The second experimental mailing ("B" condition)</comment>
4b0cbc50	50	<add>4.6</add>
4aef704e	51	</field>
	52	<field>
	53	<name>mailing_id_c</name>
	54	<type>int unsigned</type>
bd6658bd TO	55	<title>Mailing ID (C)</title>
bd6658bd TO	56	<comment>The final, general mailing (derived from A or B)</comment>
4b0cbc50	57	<add>4.6</add>
4aef704e	58	</field>
	59	<field>
	60	<name>domain_id</name>
	61	<type>int unsigned</type>
bd6658bd	62	<title>Domain ID</title>
4aef704e	63	<comment>Which site is this mailing for</comment>
4b0cbc50	64	<add>4.6</add>
4aef704e	65	</field>
4aef704e	66	<field>
321121a1 TO	67	<name>testing_criteria</name>
	68	<type>varchar</type>
	69	<length>32</length>
	70	<title>Testing Criteria</title>
4aef704e	71	<pseudoconstant>
321121a1	72	<callback>CRM_Mailing_PseudoConstant::abTestCriteria</callback>
4aef704e	73	</pseudoconstant>
4b0cbc50	74	<add>4.6</add>
4aef704e	75	</field>
4aef704e	76	<field>
321121a1 TO	77	<name>winner_criteria</name>
	78	<type>varchar</type>
	79	<length>32</length>
	80	<title>Winner Criteria</title>
4aef704e	81	<pseudoconstant>
321121a1	82	<callback>CRM_Mailing_PseudoConstant::abWinnerCriteria</callback>
4aef704e	83	</pseudoconstant>
4b0cbc50	84	<add>4.6</add>
4aef704e	85	</field>
	86	<field>
	87	<name>specific_url</name>
	88	<type>varchar</type>
bd6658bd	89	<title>URL for Winner Criteria</title>
4aef704e	90	<length>255</length>
4aef704e	91	<comment>What specific url to track</comment>
4b0cbc50	92	<add>4.6</add>
4aef704e	93	</field>
	94	<field>
	95	<name>declare_winning_time</name>
	96	<type>datetime</type>
bd6658bd	97	<title>Declaration Time</title>
4aef704e	98	<comment>In how much time to declare winner</comment>
4b0cbc50	99	<add>4.6</add>
4aef704e	100	</field>
	101	<field>
	102	<name>group_percentage</name>
	103	<type>int unsigned</type>
bd6658bd	104	<title>Group Percentage</title>
4b0cbc50	105	<add>4.6</add>
4aef704e	106	</field>
8b06123b TO	107	<field>
	108	<name>created_id</name>
	109	<title>AB Test Created By</title>
	110	<type>int unsigned</type>
	111	<comment>FK to Contact ID</comment>
	112	<add>4.6</add>
	113	</field>
	114	<foreignKey>
	115	<name>created_id</name>
	116	<table>civicrm_contact</table>
	117	<key>id</key>
	118	<add>4.6</add>
	119	<onDelete>SET NULL</onDelete>
	120	</foreignKey>
	121	<field>
	122	<name>created_date</name>
	123	<title>AB Test Created Date</title>
4387c66f	124	<type>timestamp</type>
	125	<required>false</required>
	126	<default>CURRENT_TIMESTAMP</default>
8b06123b TO	127	<comment>When was this item created</comment>
	128	<add>4.6</add>
	129	<html>
	130	<type>Select Date</type>
	131	</html>
	132	</field>
840e3c4a	133	</table>