xml/schema/Core/Job.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Job</class>
   6   <name>civicrm_job</name>
   7   <comment>Scheduled job.</comment>
   8   <add>4.1</add>
   9   <log>false</log>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>Job Id</comment>
  15        <add>4.1</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22       <name>domain_id</name>
  23       <type>int unsigned</type>
  24       <required>true</required>
  25       <comment>Which Domain is this scheduled job for</comment>
  26       <add>4.1</add>
  27   </field>
  28   <foreignKey>
  29        <name>domain_id</name>
  30        <table>civicrm_domain</table>
  31        <key>id</key>
  32        <add>4.1</add>
  33   </foreignKey>
  34   <field>
  35        <name>run_frequency</name>
  36        <type>enum</type>
  37        <values>Hourly, Daily, Always</values>
  38        <default>"Daily"</default>
  39        <comment>Scheduled job run frequency.</comment>
  40        <add>4.1</add>
  41   </field>
  42   <field>
  43        <name>last_run</name>
  44        <type>datetime</type>
  45        <default>NULL</default>
  46        <comment>When was this cron entry last run</comment>
  47        <add>4.1</add>
  48   </field>
  49   <field>
  50        <name>name</name>
  51        <type>varchar</type>
  52        <length>255</length>
  53        <comment>Title of the job</comment>
  54        <add>4.1</add>
  55   </field>
  56   <field>
  57        <name>description</name>
  58        <type>varchar</type>
  59        <length>255</length>
  60        <comment>Description of the job</comment>
  61        <add>4.1</add>
  62   </field>
  63   <field>
  64        <name>api_prefix</name>
  65        <type>varchar</type>
  66        <length>255</length>
  67        <default>"civicrm_api3"</default>
  68        <comment>Prefix of the job api call</comment>
  69        <add>4.1</add>
  70        <drop>4.3</drop>
  71   </field>
  72   <field>
  73        <name>api_entity</name>
  74        <type>varchar</type>
  75        <length>255</length>
  76        <comment>Entity of the job api call</comment>
  77        <add>4.1</add>
  78   </field>
  79   <field>
  80        <name>api_action</name>
  81        <type>varchar</type>
  82        <length>255</length>
  83        <comment>Action of the job api call</comment>
  84        <add>4.1</add>
  85   </field>
  86   <field>
  87        <name>parameters</name>
  88        <type>text</type>
  89        <comment>List of parameters to the command.</comment>
  90        <html>
  91          <type>TextArea</type>
  92          <rows>4</rows>
  93          <cols>60</cols>
  94        </html>
  95        <add>4.1</add>
  96   </field>
  97   <field>
  98        <name>is_active</name>
  99        <type>boolean</type>
 100        <comment>Is this job active?</comment>
 101        <add>4.1</add>
 102   </field>
 103 </table>