xml/schema/Core/JobLog.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>JobLog</class>
   6   <name>civicrm_job_log</name>
   7   <comment>Scheduled jobs log.</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 log entry 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_time</name>
  36        <type>timestamp</type>
  37        <comment>Log entry date</comment>
  38        <add>4.1</add>
  39   </field>
  40   <field>
  41        <name>job_id</name>
  42        <type>int unsigned</type>
  43        <comment>Pointer to job id - not a FK though, just for logging purposes</comment>
  44        <add>4.1</add>
  45   </field>
  46   <field>
  47        <name>name</name>
  48        <type>varchar</type>
  49        <length>255</length>
  50        <comment>Title of the job</comment>
  51        <add>4.1</add>
  52   </field>
  53   <field>
  54        <name>command</name>
  55        <type>varchar</type>
  56        <length>255</length>
  57        <comment>Full path to file containing job script</comment>
  58        <add>4.1</add>
  59   </field>
  60   <field>
  61        <name>description</name>
  62        <type>varchar</type>
  63        <length>255</length>
  64        <comment>Title line of log entry</comment>
  65        <add>4.1</add>
  66   </field>
  67   <field>
  68        <name>data</name>
  69        <type>text</type>
  70        <comment>Potential extended data for specific job run (e.g. tracebacks).</comment>
  71        <add>4.1</add>
  72   </field>
  73 </table>