xml/schema/Mailing/MailingJob.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Mailing</base>
   5   <class>MailingJob</class>
   6   <name>civicrm_mailing_job</name>
   7   <comment>Stores information about the job that executes this mailing</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>mailing_id</name>
  20       <type>int unsigned</type>
  21       <required>true</required>
  22       <comment>The ID of the mailing this Job will send.</comment>
  23   </field>
  24   <foreignKey>
  25        <name>mailing_id</name>
  26        <table>civicrm_mailing</table>
  27        <key>id</key>
  28        <onDelete>CASCADE</onDelete>
  29   </foreignKey>
  30   <field>
  31       <name>scheduled_date</name>
  32       <type>datetime</type>
  33       <comment>date on which this job was scheduled.</comment>
  34   </field>
  35   <field>
  36       <name>start_date</name>
  37       <type>datetime</type>
  38       <comment>date on which this job was started.</comment>
  39   </field>
  40   <field>
  41       <name>end_date</name>
  42       <type>datetime</type>
  43       <comment>date on which this job ended.</comment>
  44   </field>
  45   <field>
  46       <name>status</name>
  47       <type>enum</type>
  48       <values>Scheduled, Running, Complete, Paused, Canceled</values>
  49       <comment>The state of this job</comment>
  50   </field>
  51   <field>
  52       <name>is_test</name>
  53       <type>boolean</type>
  54       <default>0</default>
  55       <comment>Is this job for a test mail?</comment>
  56       <add>1.9</add>
  57   </field>
  58   <field>
  59       <name>job_type</name>
  60       <type>varchar</type>
  61       <length>255</length>
  62       <comment>Type of mailling job: null | child </comment>
  63       <add>3.3</add>
  64   </field>
  65   <field>
  66       <name>parent_id</name>
  67       <type>int unsigned</type>
  68       <comment>Parent job id</comment>
  69       <default>NULL</default>
  70       <add>3.3</add>
  71   </field>
  72   <foreignKey>
  73        <name>parent_id</name>
  74        <table>civicrm_mailing_job</table>
  75        <key>id</key>
  76        <onDelete>CASCADE</onDelete>
  77   </foreignKey>
  78   <field>
  79       <name>job_offset</name>
  80       <type>int</type>
  81       <comment>Offset of the child job</comment>
  82       <default>0</default>
  83       <add>3.3</add>
  84   </field>
  85   <field>
  86       <name>job_limit</name>
  87       <type>int</type>
  88       <comment>Queue size limit for each child job</comment>
  89       <default>0</default>
  90       <add>3.3</add>
  91   </field>
  92 </table>