<comment>Table to cache items for navigation on civicrm searched results.</comment>
<add>3.4</add>
<field>
- <name>id</name>
- <type>int unsigned</type>
- <required>true</required>
- <add>3.4</add>
+ <name>id</name>
+ <type>int unsigned</type>
+ <required>true</required>
+ <add>3.4</add>
</field>
<primaryKey>
- <name>id</name>
- <autoincrement>true</autoincrement>
+ <name>id</name>
+ <autoincrement>true</autoincrement>
</primaryKey>
<field>
- <name>entity_table</name>
- <type>varchar</type>
- <length>64</length>
- <comment>physical tablename for entity being joined to discount, e.g. civicrm_event</comment>
- <add>3.4</add>
+ <name>entity_table</name>
+ <type>varchar</type>
+ <length>64</length>
+ <comment>physical tablename for entity being joined to discount, e.g. civicrm_event</comment>
+ <add>3.4</add>
</field>
<field>
- <name>entity_id1</name>
- <type>int unsigned</type>
- <required>true</required>
- <comment>FK to entity table specified in entity_table column.</comment>
- <add>3.4</add>
+ <name>entity_id1</name>
+ <type>int unsigned</type>
+ <required>true</required>
+ <comment>FK to entity table specified in entity_table column.</comment>
+ <add>3.4</add>
</field>
<field>
- <name>entity_id2</name>
- <type>int unsigned</type>
- <required>true</required>
- <comment>FK to entity table specified in entity_table column.</comment>
- <add>3.4</add>
+ <name>entity_id2</name>
+ <type>int unsigned</type>
+ <required>true</required>
+ <comment>FK to entity table specified in entity_table column.</comment>
+ <add>3.4</add>
</field>
<field>
<name>cacheKey</name>
<add>4.2</add>
</field>
<index>
- <name>index_all</name>
- <fieldName>cacheKey</fieldName>
- <fieldName>entity_id1</fieldName>
- <fieldName>entity_id2</fieldName>
- <fieldName>entity_table</fieldName>
- <fieldName>is_selected</fieldName>
+ <name>index_all</name>
+ <fieldName>cacheKey</fieldName>
+ <fieldName>entity_id1</fieldName>
+ <fieldName>entity_id2</fieldName>
+ <fieldName>entity_table</fieldName>
+ <fieldName>is_selected</fieldName>
</index>
</table>