Move pingback code to separate repo

[civicrm-core.git] / tools / xml / schema / Auction / Bid.xml

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

<table>
  <base>CRM/Auction</base>
  <class>Bid</class>
  <name>civicrm_auction_bid</name>
  <comment>auction item bids.</comment>
  <add>3.0</add>
  <field>
      <name>id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>primary key</comment>
       <add>3.0</add>
  </field>
  <primaryKey>
       <name>id</name>
       <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
      <name>contact_id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>FK to civicrm_contact, who bid on this item</comment>
       <add>3.0</add>
  </field>
  <foreignKey>
       <name>contact_id</name>
       <table>civicrm_contact</table>
       <key>id</key>
       <add>3.0</add>
       <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
      <name>auction_item_id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>FK to civicrm_auction_item</comment>
       <add>3.0</add>
  </field>
  <foreignKey>
       <name>auction_item_id</name>
       <table>civicrm_auction_item</table>
       <key>id</key>
       <add>3.0</add>
       <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
      <name>bid_value</name>
      <title>Price</title>
      <type>decimal</type>
      <comment>Amount bid per item.</comment>
      <add>3.0</add>
  </field>
  <field>
      <name>quantity</name>
      <type>int unsigned</type>
      <comment>Number of items bid on.</comment>
      <add>3.0</add>
  </field>
  <field>
       <name>bid_date</name>
       <type>datetime</type>
       <comment>Date and time the bid was made.</comment>
       <add>3.0</add>
  </field>
  <field>
      <name>is_active</name>
      <type>boolean</type>
      <default>0</default>
      <comment>Is this bid active or disabled/cancelled?</comment>
      <add>3.0</add>
  </field>
  <field>
      <name>is_winner</name>
      <type>boolean</type>
      <default>0</default>
      <comment>Is this bid the winning bid</comment>
      <add>3.0</add>
  </field>
  <field>
      <name>quantity_won</name>
      <type>int unsigned</type>
      <comment>Number of items this bid won.</comment>
      <add>3.0</add>
  </field>
  <field>
      <name>contribution_id</name>
      <type>int unsigned</type>
      <comment>FK to contribution table.</comment>
      <add>3.0</add>
  </field>
  <foreignKey>
       <name>contribution_id</name>
       <table>civicrm_contribution</table>
       <key>id</key>
       <add>3.0</add>
       <onDelete>SET NULL</onDelete>
  </foreignKey>
</table>