crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/tools/xml/schema/Auction/Auction.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Auction</base>
   5   <class>Auction</class>
   6   <name>civicrm_auction</name>
   7   <add>3.0</add>
   8   <field>
   9       <name>id</name>
  10       <type>int unsigned</type>
  11       <required>true</required>
  12       <comment>Auction ID</comment>
  13       <add>3.0</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20       <name>title</name>
  21       <uniqueName>auction_title</uniqueName>
  22       <type>varchar</type>
  23       <import>true</import>
  24       <title>Auction Title</title>
  25       <length>255</length>
  26       <localizable>true</localizable>
  27       <comment>Auction Title (e.g. Fall Auction Dinner)</comment>
  28       <add>3.0</add>
  29   </field>
  30   <field>
  31       <name>description</name>
  32       <type>text</type>
  33       <uniqueName>auction_description</uniqueName>
  34       <title>Auction Description</title>
  35       <htmlType>textarea</htmlType>
  36       <rows>8</rows>
  37       <cols>60</cols>
  38       <localizable>true</localizable>
  39       <comment>Full description of auction. Text and html allowed.</comment>
  40       <add>3.0</add>
  41   </field>
  42   <field>
  43        <name>start_date</name>
  44        <type>datetime</type>
  45        <uniqueName>auction_start_date</uniqueName>
  46        <title>Auction Start Date</title>
  47        <comment>Date and time the auction starts.</comment>
  48        <add>3.0</add>
  49   </field>
  50   <field>
  51        <name>end_date</name>
  52        <type>datetime</type>
  53        <uniqueName>auction_end_date</uniqueName>
  54        <title>Auction End Date</title>
  55        <comment>Date and time the auction ends. May be NULL if no defined end date/time</comment>
  56        <add>3.0</add>
  57   </field>
  58   <field>
  59        <name>item_start_date</name>
  60        <type>datetime</type>
  61        <title>Item registration Start Date</title>
  62        <comment>Date and time that users can add item.</comment>
  63        <add>3.0</add>
  64   </field>
  65   <field>
  66        <name>item_end_date</name>
  67        <type>datetime</type>
  68        <title>Item registration End Date</title>
  69        <comment>Date and time that item registration ends. May be NULL if no defined end date/time</comment>
  70        <add>3.0</add>
  71   </field>
  72   <field>
  73       <name>is_approval_needed</name>
  74       <type>boolean</type>
  75       <title>Do items need to be approved?</title>
  76       <default>0</default>
  77       <comment>If true all items needs to be approved before appearing on the auction pages.</comment>
  78       <add>3.0</add>
  79   </field>
  80   <field>
  81       <name>is_item_groups</name>
  82       <type>boolean</type>
  83       <title>Can items be grouped?</title>
  84       <default>0</default>
  85       <comment>If true multiple items can be consolidated into one item group.</comment>
  86       <add>3.0</add>
  87   </field>
  88   <field>
  89       <name>max_items</name>
  90       <type>int unsigned</type>
  91       <title>Max Auction items</title>
  92       <default>NULL</default>
  93       <comment>Maximum number of items that can be added to the auction.</comment>
  94       <add>3.0</add>
  95   </field>
  96   <field>
  97       <name>max_items_user</name>
  98       <type>int unsigned</type>
  99       <default>NULL</default>
 100       <comment>Maximum number of items that can be added to the auction per user.</comment>
 101       <add>3.0</add>
 102   </field>
 103   <field>
 104       <name>event_id</name>
 105       <type>int unsigned</type>
 106       <comment>Event this auction is linked to</comment>
 107       <add>3.0</add>
 108   </field>
 109   <foreignKey>
 110        <name>event_id</name>
 111        <table>civicrm_event</table>
 112        <key>id</key>
 113        <onDelete>SET NULL</onDelete>
 114   </foreignKey>
 115   <field>
 116       <name>donor_profile_id</name>
 117       <type>int unsigned</type>
 118       <comment>Profile to be used for donor account creation.</comment>
 119       <add>3.0</add>
 120   </field>
 121   <foreignKey>
 122        <name>donor_profile_id</name>
 123        <table>civicrm_uf_group</table>
 124        <key>id</key>
 125        <onDelete>SET NULL</onDelete>
 126   </foreignKey>
 127   <field>
 128       <name>is_active</name>
 129       <type>boolean</type>
 130       <default>0</default>
 131       <comment>Is this Auction enabled or disabled/cancelled?</comment>
 132       <add>3.0</add>
 133   </field>
 134 </table>