Merge pull request #3649 from colemanw/totten-colemanw-validate
[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 <pseudoconstant>
26 <table>civicrm_domain</table>
27 <keyColumn>id</keyColumn>
28 <labelColumn>name</labelColumn>
29 </pseudoconstant>
30 <comment>Which Domain is this scheduled job for</comment>
31 <add>4.1</add>
32 </field>
33 <foreignKey>
34 <name>domain_id</name>
35 <table>civicrm_domain</table>
36 <key>id</key>
37 <add>4.1</add>
38 </foreignKey>
39 <field>
40 <name>run_frequency</name>
41 <type>varchar</type>
42 <length>8</length>
43 <default>"Daily"</default>
44 <comment>Scheduled job run frequency.</comment>
45 <pseudoconstant>
46 <callback>CRM_Core_SelectValues::getJobFrequency</callback>
47 </pseudoconstant>
48 <add>4.1</add>
49 <html>
50 <type>Select</type>
51 </html>
52 </field>
53 <field>
54 <name>last_run</name>
55 <type>datetime</type>
56 <default>NULL</default>
57 <comment>When was this cron entry last run</comment>
58 <add>4.1</add>
59 </field>
60 <field>
61 <name>name</name>
62 <type>varchar</type>
63 <length>255</length>
64 <comment>Title of the job</comment>
65 <add>4.1</add>
66 </field>
67 <field>
68 <name>description</name>
69 <type>varchar</type>
70 <length>255</length>
71 <comment>Description of the job</comment>
72 <add>4.1</add>
73 </field>
74 <field>
75 <name>api_prefix</name>
76 <type>varchar</type>
77 <length>255</length>
78 <default>"civicrm_api3"</default>
79 <comment>Prefix of the job api call</comment>
80 <add>4.1</add>
81 <drop>4.3</drop>
82 </field>
83 <field>
84 <name>api_entity</name>
85 <type>varchar</type>
86 <length>255</length>
87 <comment>Entity of the job api call</comment>
88 <add>4.1</add>
89 </field>
90 <field>
91 <name>api_action</name>
92 <type>varchar</type>
93 <length>255</length>
94 <comment>Action of the job api call</comment>
95 <add>4.1</add>
96 </field>
97 <field>
98 <name>parameters</name>
99 <type>text</type>
100 <comment>List of parameters to the command.</comment>
101 <html>
102 <type>TextArea</type>
103 <rows>4</rows>
104 <cols>60</cols>
105 </html>
106 <add>4.1</add>
107 </field>
108 <field>
109 <name>is_active</name>
110 <type>boolean</type>
111 <comment>Is this job active?</comment>
112 <add>4.1</add>
113 </field>
114 </table>