[civicrm-core.git] / xml / schema / Queue / QueueItem.xml

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

<table>
  <!--
    NOTE: To facilitate upgrades, manually copy the CREATE TABLE statement
    from sql/civicrm.mysql to sql/civicrm_queue_item.mysql
  -->
  <base>CRM/Queue</base>
  <class>QueueItem</class>
  <name>civicrm_queue_item</name>
  <comment>Stores a list of queue items</comment>
  <add>4.2</add>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <required>true</required>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>queue_name</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Name of the queue which includes this item</comment>
    <required>true</required>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>weight</name>
    <title>Order</title>
    <type>int</type>
    <required>true</required>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>submit_time</name>
    <type>datetime</type>
    <comment>date on which this item was submitted to the queue</comment>
    <required>true</required>
    <html>
      <type>Select Date</type>
    </html>
  </field>
  <field>
    <name>release_time</name>
    <type>datetime</type>
    <comment>date on which this job becomes available; null if ASAP</comment>
    <html>
      <type>Select Date</type>
    </html>
  </field>

  <field>
    <name>data</name>
    <title>Queue item datas</title>
    <type>text</type>
    <comment>Serialized queue</comment>
  </field>
  <index>
    <name>index_queueids</name>
    <fieldName>queue_name</fieldName>
    <fieldName>weight</fieldName>
    <fieldName>id</fieldName>
  </index>
</table>
Commit	Line	Data
	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<!--
	5	NOTE: To facilitate upgrades, manually copy the CREATE TABLE statement
	6	from sql/civicrm.mysql to sql/civicrm_queue_item.mysql
	7	-->
	8	<base>CRM/Queue</base>
	9	<class>QueueItem</class>
	10	<name>civicrm_queue_item</name>
	11	<comment>Stores a list of queue items</comment>
	12	<add>4.2</add>
	13	<field>
	14	<name>id</name>
	15	<type>int unsigned</type>
	16	<required>true</required>
	17	</field>
	18	<primaryKey>
	19	<name>id</name>
	20	<autoincrement>true</autoincrement>
	21	</primaryKey>
	22	<field>
	23	<name>queue_name</name>
	24	<type>varchar</type>
	25	<length>64</length>
	26	<comment>Name of the queue which includes this item</comment>
	27	<required>true</required>
	28	<html>
	29	<type>Text</type>
	30	</html>
	31	</field>
	32	<field>
	33	<name>weight</name>
	34	<title>Order</title>
	35	<type>int</type>
	36	<required>true</required>
	37	<html>
	38	<type>Text</type>
	39	</html>
	40	</field>
	41	<field>
	42	<name>submit_time</name>
	43	<type>datetime</type>
	44	<comment>date on which this item was submitted to the queue</comment>
	45	<required>true</required>
	46	<html>
	47	<type>Select Date</type>
	48	</html>
	49	</field>
	50	<field>
	51	<name>release_time</name>
	52	<type>datetime</type>
	53	<comment>date on which this job becomes available; null if ASAP</comment>
	54	<html>
	55	<type>Select Date</type>
	56	</html>
	57	</field>
	58
	59	<field>
	60	<name>data</name>
	61	<title>Queue item datas</title>
	62	<type>text</type>
	63	<comment>Serialized queue</comment>
	64	</field>
	65	<index>
	66	<name>index_queueids</name>
	67	<fieldName>queue_name</fieldName>
	68	<fieldName>weight</fieldName>
	69	<fieldName>id</fieldName>
	70	</index>
	71	</table>