<add>2.0</add>
<log>true</log>
<field>
- <name>id</name>
- <type>int unsigned</type>
- <required>true</required>
- <comment>Unique ID</comment>
- <add>2.0</add>
+ <name>id</name>
+ <type>int unsigned</type>
+ <required>true</required>
+ <comment>Unique ID</comment>
+ <add>2.0</add>
</field>
<primaryKey>
- <name>id</name>
- <autoincrement>true</autoincrement>
+ <name>id</name>
+ <autoincrement>true</autoincrement>
</primaryKey>
<field>
- <name>address_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>address_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>address_id</name>
- <table>civicrm_address</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>address_id</name>
+ <table>civicrm_address</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>email_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>email_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>email_id</name>
- <table>civicrm_email</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>email_id</name>
+ <table>civicrm_email</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>phone_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>phone_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>phone_id</name>
- <table>civicrm_phone</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>phone_id</name>
+ <table>civicrm_phone</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>im_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>im_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>im_id</name>
- <table>civicrm_im</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>im_id</name>
+ <table>civicrm_im</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>address_2_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>address_2_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>address_2_id</name>
- <table>civicrm_address</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>address_2_id</name>
+ <table>civicrm_address</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>email_2_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>email_2_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>email_2_id</name>
- <table>civicrm_email</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>email_2_id</name>
+ <table>civicrm_email</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>phone_2_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>phone_2_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>phone_2_id</name>
- <table>civicrm_phone</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>phone_2_id</name>
+ <table>civicrm_phone</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
- <name>im_2_id</name>
- <type>int unsigned</type>
- <add>2.0</add>
+ <name>im_2_id</name>
+ <type>int unsigned</type>
+ <add>2.0</add>
</field>
<foreignKey>
- <name>im_2_id</name>
- <table>civicrm_im</table>
- <key>id</key>
- <add>2.0</add>
- <onDelete>SET NULL</onDelete>
+ <name>im_2_id</name>
+ <table>civicrm_im</table>
+ <key>id</key>
+ <add>2.0</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
</table>