[civicrm-core.git] / xml / schema / Core / UserJob.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Core</base>
  <class>UserJob</class>
  <name>civicrm_user_job</name>
  <comment>Tracking for user jobs (eg. imports).</comment>
  <add>5.50</add>
  <log>false</log>
  <field>
    <name>id</name>
    <title>User Job ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Job ID</comment>
    <html>
      <type>Number</type>
    </html>
    <add>5.50</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <title>User job name</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Unique name for job.</comment>
    <add>5.50</add>
  </field>
  <index>
    <name>UI_name</name>
    <fieldName>name</fieldName>
    <unique>true</unique>
    <add>5.50</add>
  </index>
  <field>
    <name>created_id</name>
    <type>int unsigned</type>
    <title>Created By Contact ID</title>
    <comment>FK to contact table.</comment>
    <html>
      <label>Created By</label>
    </html>
    <add>5.50</add>
  </field>
  <foreignKey>
    <name>created_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <add>5.50</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>created_date</name>
    <type>timestamp</type>
    <default>CURRENT_TIMESTAMP</default>
    <required>true</required>
    <title>Import Job Created Date</title>
    <readonly>true</readonly>
    <comment>Date and time this job was created.</comment>
    <add>5.50</add>
    <html>
      <type>Select Date</type>
      <formatType>activityDateTime</formatType>
    </html>
  </field>
  <field>
    <name>start_date</name>
    <type>timestamp</type>
    <required>false</required>
    <title>Import Job Started Date</title>
    <comment>Date and time this import job started.</comment>
    <add>5.50</add>
    <html>
      <type>Select Date</type>
      <formatType>activityDateTime</formatType>
    </html>
    <readonly>true</readonly>
  </field>
  <field>
    <name>end_date</name>
    <type>timestamp</type>
    <required>false</required>
    <title>Job Ended Date</title>
    <comment>Date and time this import job ended.</comment>
    <add>5.50</add>
    <html>
      <type>Select Date</type>
      <formatType>activityDateTime</formatType>
    </html>
  </field>
  <field>
    <name>expires_date</name>
    <type>timestamp</type>
    <required>false</required>
    <title>Import Job Expires Date</title>
    <comment>Date and time to clean up after this import job (temp table deletion date).</comment>
    <add>5.50</add>
    <html>
      <type>Select Date</type>
      <formatType>activityDateTime</formatType>
    </html>
  </field>
  <field>
    <name>status_id</name>
    <title>User Job Status ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <label>Job Status</label>
    </html>
    <pseudoconstant>
      <callback>CRM_Core_BAO_UserJob::getStatuses</callback>
    </pseudoconstant>
    <add>5.50</add>
  </field>
  <field>
    <name>type_id</name>
    <title>User Job Type ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <label>Job Type</label>
    </html>
    <pseudoconstant>
      <callback>CRM_Core_BAO_UserJob::getTypes</callback>
    </pseudoconstant>
    <add>5.50</add>
  </field>
  <field>
    <name>queue_id</name>
    <title>Queue ID</title>
    <type>int unsigned</type>
    <comment>FK to Queue</comment>
    <html>
      <label>Queue</label>
    </html>
  </field>
  <foreignKey>
    <name>queue_id</name>
    <table>civicrm_queue</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>metadata</name>
    <type>text</type>
    <title>Job metadata</title>
    <comment>Data pertaining to job configuration</comment>
    <serialize>JSON</serialize>
    <add>5.50</add>
  </field>
</table>
Commit	Line	Data
a082d2df EM	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Core</base>
	5	<class>UserJob</class>
	6	<name>civicrm_user_job</name>
	7	<comment>Tracking for user jobs (eg. imports).</comment>
	8	<add>5.50</add>
	9	<log>false</log>
	10	<field>
	11	<name>id</name>
	12	<title>User Job ID</title>
	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<comment>Job ID</comment>
	16	<html>
	17	<type>Number</type>
	18	</html>
	19	<add>5.50</add>
	20	</field>
	21	<primaryKey>
	22	<name>id</name>
	23	<autoincrement>true</autoincrement>
	24	</primaryKey>
	25	<field>
	26	<name>name</name>
	27	<title>User job name</title>
	28	<type>varchar</type>
	29	<length>64</length>
	30	<comment>Unique name for job.</comment>
	31	<add>5.50</add>
	32	</field>
	33	<index>
	34	<name>UI_name</name>
	35	<fieldName>name</fieldName>
	36	<unique>true</unique>
	37	<add>5.50</add>
	38	</index>
	39	<field>
	40	<name>created_id</name>
	41	<type>int unsigned</type>
	42	<title>Created By Contact ID</title>
	43	<comment>FK to contact table.</comment>
	44	<html>
	45	<label>Created By</label>
	46	</html>
	47	<add>5.50</add>
	48	</field>
	49	<foreignKey>
	50	<name>created_id</name>
	51	<table>civicrm_contact</table>
	52	<key>id</key>
	53	<add>5.50</add>
	54	<onDelete>SET NULL</onDelete>
	55	</foreignKey>
	56	<field>
	57	<name>created_date</name>
	58	<type>timestamp</type>
	59	<default>CURRENT_TIMESTAMP</default>
	60	<required>true</required>
	61	<title>Import Job Created Date</title>
	62	<readonly>true</readonly>
	63	<comment>Date and time this job was created.</comment>
	64	<add>5.50</add>
65	<html>
66	<type>Select Date</type>
67	<formatType>activityDateTime</formatType>
68	</html>
69	</field>
70	<field>
71	<name>start_date</name>
72	<type>timestamp</type>
73	<required>false</required>
74	<title>Import Job Started Date</title>
75	<comment>Date and time this import job started.</comment>
76	<add>5.50</add>
77	<html>
78	<type>Select Date</type>
79	<formatType>activityDateTime</formatType>
80	</html>
81	<readonly>true</readonly>
82	</field>
83	<field>
84	<name>end_date</name>
85	<type>timestamp</type>
86	<required>false</required>
87	<title>Job Ended Date</title>
88	<comment>Date and time this import job ended.</comment>
89	<add>5.50</add>
90	<html>
91	<type>Select Date</type>
92	<formatType>activityDateTime</formatType>
93	</html>
94	</field>
95	<field>
96	<name>expires_date</name>
97	<type>timestamp</type>
98	<required>false</required>
99	<title>Import Job Expires Date</title>
100	<comment>Date and time to clean up after this import job (temp table deletion date).</comment>
101	<add>5.50</add>
102	<html>
103	<type>Select Date</type>
104	<formatType>activityDateTime</formatType>
105	</html>
106	</field>
107	<field>
108	<name>status_id</name>
109	<title>User Job Status ID</title>
110	<type>int unsigned</type>
111	<required>true</required>
112	<html>
113	<label>Job Status</label>
114	</html>
115	<pseudoconstant>
116	<callback>CRM_Core_BAO_UserJob::getStatuses</callback>
117	</pseudoconstant>
118	<add>5.50</add>
119	</field>
120	<field>
121	<name>type_id</name>
122	<title>User Job Type ID</title>
123	<type>int unsigned</type>
124	<required>true</required>
125	<html>
126	<label>Job Type</label>
127	</html>
128	<pseudoconstant>
129	<callback>CRM_Core_BAO_UserJob::getTypes</callback>
130	</pseudoconstant>
131	<add>5.50</add>
132	</field>
133	<field>
134	<name>queue_id</name>
135	<title>Queue ID</title>
136	<type>int unsigned</type>
137	<comment>FK to Queue</comment>
138	<html>
139	<label>Queue</label>
140	</html>
141	</field>
142	<foreignKey>
143	<name>queue_id</name>
144	<table>civicrm_queue</table>
145	<key>id</key>
146	<onDelete>SET NULL</onDelete>
147	</foreignKey>
148	<field>
149	<name>metadata</name>
150	<type>text</type>
151	<title>Job metadata</title>
152	<comment>Data pertaining to job configuration</comment>
153	<serialize>JSON</serialize>
154	<add>5.50</add>
155	</field>
156	</table>