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