Merge pull request #2712 from pratik-joshi/CRM-14363
[civicrm-core.git] / 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>varchar</type>
37 <length>8</length>
38 <default>"Daily"</default>
39 <comment>Scheduled job run frequency.</comment>
40 <pseudoconstant>
41 <callback>CRM_Core_SelectValues::getJobFrequency</callback>
42 </pseudoconstant>
43 <add>4.1</add>
44 <html>
45 <type>Select</type>
46 </html>
47 </field>
48 <field>
49 <name>last_run</name>
50 <type>datetime</type>
51 <default>NULL</default>
52 <comment>When was this cron entry last run</comment>
53 <add>4.1</add>
54 </field>
55 <field>
56 <name>name</name>
57 <type>varchar</type>
58 <length>255</length>
59 <comment>Title of the job</comment>
60 <add>4.1</add>
61 </field>
62 <field>
63 <name>description</name>
64 <type>varchar</type>
65 <length>255</length>
66 <comment>Description of the job</comment>
67 <add>4.1</add>
68 </field>
69 <field>
70 <name>api_prefix</name>
71 <type>varchar</type>
72 <length>255</length>
73 <default>"civicrm_api3"</default>
74 <comment>Prefix of the job api call</comment>
75 <add>4.1</add>
76 <drop>4.3</drop>
77 </field>
78 <field>
79 <name>api_entity</name>
80 <type>varchar</type>
81 <length>255</length>
82 <comment>Entity of the job api call</comment>
83 <add>4.1</add>
84 </field>
85 <field>
86 <name>api_action</name>
87 <type>varchar</type>
88 <length>255</length>
89 <comment>Action of the job api call</comment>
90 <add>4.1</add>
91 </field>
92 <field>
93 <name>parameters</name>
94 <type>text</type>
95 <comment>List of parameters to the command.</comment>
96 <html>
97 <type>TextArea</type>
98 <rows>4</rows>
99 <cols>60</cols>
100 </html>
101 <add>4.1</add>
102 </field>
103 <field>
104 <name>is_active</name>
105 <type>boolean</type>
106 <comment>Is this job active?</comment>
107 <add>4.1</add>
108 </field>
109 </table>