Merge remote-tracking branch 'upstream/4.4' into 4.4-master-2013-12-30-11-03-32
[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>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 <html>
42 <type>Select</type>
43 </html>
44 </field>
45 <field>
46 <name>last_run</name>
47 <type>datetime</type>
48 <default>NULL</default>
49 <comment>When was this cron entry last run</comment>
50 <add>4.1</add>
51 </field>
52 <field>
53 <name>name</name>
54 <type>varchar</type>
55 <length>255</length>
56 <comment>Title of the job</comment>
57 <add>4.1</add>
58 </field>
59 <field>
60 <name>description</name>
61 <type>varchar</type>
62 <length>255</length>
63 <comment>Description of the job</comment>
64 <add>4.1</add>
65 </field>
66 <field>
67 <name>api_prefix</name>
68 <type>varchar</type>
69 <length>255</length>
70 <default>"civicrm_api3"</default>
71 <comment>Prefix of the job api call</comment>
72 <add>4.1</add>
73 <drop>4.3</drop>
74 </field>
75 <field>
76 <name>api_entity</name>
77 <type>varchar</type>
78 <length>255</length>
79 <comment>Entity of the job api call</comment>
80 <add>4.1</add>
81 </field>
82 <field>
83 <name>api_action</name>
84 <type>varchar</type>
85 <length>255</length>
86 <comment>Action of the job api call</comment>
87 <add>4.1</add>
88 </field>
89 <field>
90 <name>parameters</name>
91 <type>text</type>
92 <comment>List of parameters to the command.</comment>
93 <html>
94 <type>TextArea</type>
95 <rows>4</rows>
96 <cols>60</cols>
97 </html>
98 <add>4.1</add>
99 </field>
100 <field>
101 <name>is_active</name>
102 <type>boolean</type>
103 <comment>Is this job active?</comment>
104 <add>4.1</add>
105 </field>
106 </table>