xml/schema/Core/LocBlock.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>LocBlock</class>
   6   <name>civicrm_loc_block</name>
   7   <comment>Define location specific properties</comment>
   8   <add>2.0</add>
   9   <log>true</log>
  10   <title>Location</title>
  11   <icon>fa-map-o</icon>
  12   <field>
  13     <name>id</name>
  14     <title>Location Block ID</title>
  15     <type>int unsigned</type>
  16     <required>true</required>
  17     <comment>Unique ID</comment>
  18     <html>
  19       <type>Number</type>
  20     </html>
  21     <add>2.0</add>
  22   </field>
  23   <primaryKey>
  24     <name>id</name>
  25     <autoincrement>true</autoincrement>
  26   </primaryKey>
  27   <field>
  28     <name>address_id</name>
  29     <title>Address ID</title>
  30     <type>int unsigned</type>
  31     <html>
  32       <label>Address</label>
  33     </html>
  34     <add>2.0</add>
  35   </field>
  36   <foreignKey>
  37     <name>address_id</name>
  38     <table>civicrm_address</table>
  39     <key>id</key>
  40     <add>2.0</add>
  41     <onDelete>SET NULL</onDelete>
  42   </foreignKey>
  43   <field>
  44     <name>email_id</name>
  45     <title>Email ID</title>
  46     <type>int unsigned</type>
  47     <html>
  48       <label>Email</label>
  49     </html>
  50     <add>2.0</add>
  51   </field>
  52   <foreignKey>
  53     <name>email_id</name>
  54     <table>civicrm_email</table>
  55     <key>id</key>
  56     <add>2.0</add>
  57     <onDelete>SET NULL</onDelete>
  58   </foreignKey>
  59   <field>
  60     <name>phone_id</name>
  61     <title>Phone ID</title>
  62     <type>int unsigned</type>
  63     <html>
  64       <label>Phone</label>
  65     </html>
  66     <add>2.0</add>
  67   </field>
  68   <foreignKey>
  69     <name>phone_id</name>
  70     <table>civicrm_phone</table>
  71     <key>id</key>
  72     <add>2.0</add>
  73     <onDelete>SET NULL</onDelete>
  74   </foreignKey>
  75   <field>
  76     <name>im_id</name>
  77     <title>IM ID</title>
  78     <type>int unsigned</type>
  79     <html>
  80       <label>Instant Messenger</label>
  81     </html>
  82     <add>2.0</add>
  83   </field>
  84   <foreignKey>
  85     <name>im_id</name>
  86     <table>civicrm_im</table>
  87     <key>id</key>
  88     <add>2.0</add>
  89     <onDelete>SET NULL</onDelete>
  90   </foreignKey>
  91   <field>
  92     <name>address_2_id</name>
  93     <title>Address 2 ID</title>
  94     <type>int unsigned</type>
  95     <html>
  96       <label>Address 2</label>
  97     </html>
  98     <add>2.0</add>
  99   </field>
 100   <foreignKey>
 101     <name>address_2_id</name>
 102     <table>civicrm_address</table>
 103     <key>id</key>
 104     <add>2.0</add>
 105     <onDelete>SET NULL</onDelete>
 106   </foreignKey>
 107   <field>
 108     <name>email_2_id</name>
 109     <type>int unsigned</type>
 110     <title>Email 2 ID</title>
 111     <html>
 112       <label>Email 2</label>
 113     </html>
 114     <add>2.0</add>
 115   </field>
 116   <foreignKey>
 117     <name>email_2_id</name>
 118     <table>civicrm_email</table>
 119     <key>id</key>
 120     <add>2.0</add>
 121     <onDelete>SET NULL</onDelete>
 122   </foreignKey>
 123   <field>
 124     <name>phone_2_id</name>
 125     <type>int unsigned</type>
 126     <title>Phone 2 ID</title>
 127     <html>
 128       <label>Phone 2</label>
 129     </html>
 130     <add>2.0</add>
 131   </field>
 132   <foreignKey>
 133     <name>phone_2_id</name>
 134     <table>civicrm_phone</table>
 135     <key>id</key>
 136     <add>2.0</add>
 137     <onDelete>SET NULL</onDelete>
 138   </foreignKey>
 139   <field>
 140     <name>im_2_id</name>
 141     <type>int unsigned</type>
 142     <title>IM 2 ID</title>
 143     <html>
 144       <label>Instant Messenger 2</label>
 145     </html>
 146     <add>2.0</add>
 147   </field>
 148   <foreignKey>
 149     <name>im_2_id</name>
 150     <table>civicrm_im</table>
 151     <key>id</key>
 152     <add>2.0</add>
 153     <onDelete>SET NULL</onDelete>
 154   </foreignKey>
 155 </table>