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

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

<table>
  <base>CRM/Mailing</base>
  <class>MailingJob</class>
  <name>civicrm_mailing_job</name>
  <comment>Stores information about the job that executes this mailing</comment>
  <archive>true</archive>
  <field>
    <name>id</name>
    <title>Mailing JOb ID</title>
    <type>int unsigned</type>
    <required>true</required>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>mailing_id</name>
    <title>Mailing</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>The ID of the mailing this Job will send.</comment>
  </field>
  <foreignKey>
    <name>mailing_id</name>
    <table>civicrm_mailing</table>
    <key>id</key>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>scheduled_date</name>
    <title>Mailing Scheduled Date</title>
    <type>datetime</type>
    <comment>date on which this job was scheduled.</comment>
  </field>
  <field>
    <name>start_date</name>
    <title>Mailing Job Start Date</title>
    <type>datetime</type>
    <comment>date on which this job was started.</comment>
  </field>
  <field>
    <name>end_date</name>
    <title>Mailing Job End Date</title>
    <type>datetime</type>
    <comment>date on which this job ended.</comment>
  </field>
  <field>
    <name>status</name>
    <title>Mailing Job Status</title>
    <type>varchar</type>
    <length>12</length>
    <comment>The state of this job</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getMailingJobStatus</callback>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>is_test</name>
    <title>Mailing Job Is Test?</title>
    <type>boolean</type>
    <default>0</default>
    <comment>Is this job for a test mail?</comment>
    <add>1.9</add>
  </field>
  <field>
    <name>job_type</name>
    <title>Mailing Job Type</title>
    <type>varchar</type>
    <length>255</length>
    <comment>Type of mailling job: null | child </comment>
    <add>3.3</add>
  </field>
  <field>
    <name>parent_id</name>
    <title>Mailing Job Parent</title>
    <type>int unsigned</type>
    <comment>Parent job id</comment>
    <default>NULL</default>
    <add>3.3</add>
  </field>
  <foreignKey>
    <name>parent_id</name>
    <table>civicrm_mailing_job</table>
    <key>id</key>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>job_offset</name>
    <title>Mailing Job Offset</title>
    <type>int</type>
    <comment>Offset of the child job</comment>
    <default>0</default>
    <add>3.3</add>
  </field>
  <field>
    <name>job_limit</name>
    <title>Mailing Job Limit</title>
    <type>int</type>
    <comment>Queue size limit for each child job</comment>
    <default>0</default>
    <add>3.3</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Mailing</base>
9da8dc8c	5	<class>MailingJob</class>
6a488035 TO	6	<name>civicrm_mailing_job</name>
	7	<comment>Stores information about the job that executes this mailing</comment>
	8	<archive>true</archive>
	9	<field>
5435b737	10	<name>id</name>
0d94665e	11	<title>Mailing JOb ID</title>
5435b737 EM	12	<type>int unsigned</type>
5435b737 EM	13	<required>true</required>
6a488035 TO	14	</field>
6a488035 TO	15	<primaryKey>
5435b737 EM	16	<name>id</name>
5435b737 EM	17	<autoincrement>true</autoincrement>
6a488035 TO	18	</primaryKey>
6a488035 TO	19	<field>
5435b737	20	<name>mailing_id</name>
0d94665e	21	<title>Mailing</title>
5435b737 EM	22	<type>int unsigned</type>
	23	<required>true</required>
	24	<comment>The ID of the mailing this Job will send.</comment>
6a488035 TO	25	</field>
6a488035 TO	26	<foreignKey>
5435b737 EM	27	<name>mailing_id</name>
	28	<table>civicrm_mailing</table>
	29	<key>id</key>
	30	<onDelete>CASCADE</onDelete>
6a488035 TO	31	</foreignKey>
6a488035 TO	32	<field>
5435b737	33	<name>scheduled_date</name>
0d94665e	34	<title>Mailing Scheduled Date</title>
5435b737 EM	35	<type>datetime</type>
5435b737 EM	36	<comment>date on which this job was scheduled.</comment>
6a488035 TO	37	</field>
6a488035 TO	38	<field>
5435b737	39	<name>start_date</name>
0d94665e	40	<title>Mailing Job Start Date</title>
5435b737 EM	41	<type>datetime</type>
5435b737 EM	42	<comment>date on which this job was started.</comment>
6a488035 TO	43	</field>
6a488035 TO	44	<field>
5435b737	45	<name>end_date</name>
0d94665e	46	<title>Mailing Job End Date</title>
5435b737 EM	47	<type>datetime</type>
5435b737 EM	48	<comment>date on which this job ended.</comment>
6a488035 TO	49	</field>
6a488035 TO	50	<field>
5435b737	51	<name>status</name>
0d94665e	52	<title>Mailing Job Status</title>
5435b737 EM	53	<type>varchar</type>
	54	<length>12</length>
	55	<comment>The state of this job</comment>
	56	<pseudoconstant>
	57	<callback>CRM_Core_SelectValues::getMailingJobStatus</callback>
	58	</pseudoconstant>
	59	<html>
	60	<type>Select</type>
	61	</html>
6a488035 TO	62	</field>
6a488035 TO	63	<field>
5435b737	64	<name>is_test</name>
0d94665e	65	<title>Mailing Job Is Test?</title>
5435b737 EM	66	<type>boolean</type>
	67	<default>0</default>
	68	<comment>Is this job for a test mail?</comment>
	69	<add>1.9</add>
6a488035 TO	70	</field>
6a488035 TO	71	<field>
5435b737	72	<name>job_type</name>
0d94665e	73	<title>Mailing Job Type</title>
5435b737 EM	74	<type>varchar</type>
	75	<length>255</length>
	76	<comment>Type of mailling job: null \| child </comment>
	77	<add>3.3</add>
6a488035 TO	78	</field>
6a488035 TO	79	<field>
5435b737	80	<name>parent_id</name>
0d94665e	81	<title>Mailing Job Parent</title>
5435b737 EM	82	<type>int unsigned</type>
	83	<comment>Parent job id</comment>
	84	<default>NULL</default>
	85	<add>3.3</add>
6a488035 TO	86	</field>
6a488035 TO	87	<foreignKey>
5435b737 EM	88	<name>parent_id</name>
	89	<table>civicrm_mailing_job</table>
	90	<key>id</key>
	91	<onDelete>CASCADE</onDelete>
6a488035 TO	92	</foreignKey>
6a488035 TO	93	<field>
5435b737	94	<name>job_offset</name>
0d94665e	95	<title>Mailing Job Offset</title>
5435b737 EM	96	<type>int</type>
	97	<comment>Offset of the child job</comment>
	98	<default>0</default>
	99	<add>3.3</add>
6a488035 TO	100	</field>
6a488035 TO	101	<field>
5435b737	102	<name>job_limit</name>
0d94665e	103	<title>Mailing Job Limit</title>
5435b737 EM	104	<type>int</type>
	105	<comment>Queue size limit for each child job</comment>
	106	<default>0</default>
	107	<add>3.3</add>
6a488035 TO	108	</field>
6a488035 TO	109	</table>