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   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>Unique ID</comment>
  15       <add>2.0</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22       <name>address_id</name>
  23       <type>int unsigned</type>
  24       <add>2.0</add>
  25   </field>
  26   <foreignKey>
  27        <name>address_id</name>
  28        <table>civicrm_address</table>
  29        <key>id</key>
  30        <add>2.0</add>
  31        <onDelete>SET NULL</onDelete>
  32   </foreignKey>
  33   <field>
  34       <name>email_id</name>
  35       <type>int unsigned</type>
  36       <add>2.0</add>
  37   </field>
  38   <foreignKey>
  39        <name>email_id</name>
  40        <table>civicrm_email</table>
  41        <key>id</key>
  42        <add>2.0</add>
  43        <onDelete>SET NULL</onDelete>
  44   </foreignKey>
  45   <field>
  46       <name>phone_id</name>
  47       <type>int unsigned</type>
  48       <add>2.0</add>
  49   </field>
  50   <foreignKey>
  51        <name>phone_id</name>
  52        <table>civicrm_phone</table>
  53        <key>id</key>
  54        <add>2.0</add>
  55        <onDelete>SET NULL</onDelete>
  56   </foreignKey>
  57   <field>
  58       <name>im_id</name>
  59       <type>int unsigned</type>
  60       <add>2.0</add>
  61   </field>
  62   <foreignKey>
  63        <name>im_id</name>
  64        <table>civicrm_im</table>
  65        <key>id</key>
  66        <add>2.0</add>
  67        <onDelete>SET NULL</onDelete>
  68   </foreignKey>
  69   <field>
  70       <name>address_2_id</name>
  71       <type>int unsigned</type>
  72       <add>2.0</add>
  73   </field>
  74   <foreignKey>
  75        <name>address_2_id</name>
  76        <table>civicrm_address</table>
  77        <key>id</key>
  78        <add>2.0</add>
  79        <onDelete>SET NULL</onDelete>
  80   </foreignKey>
  81   <field>
  82       <name>email_2_id</name>
  83       <type>int unsigned</type>
  84       <add>2.0</add>
  85   </field>
  86   <foreignKey>
  87        <name>email_2_id</name>
  88        <table>civicrm_email</table>
  89        <key>id</key>
  90        <add>2.0</add>
  91        <onDelete>SET NULL</onDelete>
  92   </foreignKey>
  93   <field>
  94       <name>phone_2_id</name>
  95       <type>int unsigned</type>
  96       <add>2.0</add>
  97   </field>
  98   <foreignKey>
  99        <name>phone_2_id</name>
 100        <table>civicrm_phone</table>
 101        <key>id</key>
 102        <add>2.0</add>
 103        <onDelete>SET NULL</onDelete>
 104   </foreignKey>
 105   <field>
 106       <name>im_2_id</name>
 107       <type>int unsigned</type>
 108       <add>2.0</add>
 109   </field>
 110   <foreignKey>
 111        <name>im_2_id</name>
 112        <table>civicrm_im</table>
 113        <key>id</key>
 114        <add>2.0</add>
 115        <onDelete>SET NULL</onDelete>
 116   </foreignKey>
 117 </table>