xml/schema/Bridge/OG.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Bridge</base>
   5   <class>OG</class>
   6   <name>civicrm_bridge_og</name>
   7   <comment>An FK table that links between drupal organic group, civicrm group and civicrm acl roles</comment>
   8   <add>2.0</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Unique table ID</comment>
  14       <add>2.0</add>
  15   </field>
  16   <primaryKey>
  17        <name>id</name>
  18        <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21        <name>drupal_og_id</name>
  22        <type>int unsigned</type>
  23        <comment>Foreign key to the organic group.</comment>
  24        <add>2.0</add>
  25   </field>
  26   <index>
  27        <name>index_drupal_og_id</name>
  28        <fieldName>index_drupal_og_id</fieldName>
  29        <add>2.0</add>
  30   </index>
  31   <field>
  32       <name>group_id</name>
  33       <type>int unsigned</type>
  34       <required>true</required>
  35       <comment>FK to civicrm group.</comment>
  36       <add>2.0</add>
  37       <pseudoconstant>
  38         <table>civicrm_group</table>
  39         <keyColumn>id</keyColumn>
  40         <labelColumn>title</labelColumn>
  41       </pseudoconstant>
  42   </field>
  43   <foreignKey>
  44        <name>group_id</name>
  45        <table>civicrm_group</table>
  46        <key>id</key>
  47        <add>2.0</add>
  48   </foreignKey>
  49   <field>
  50       <name>acl_id</name>
  51       <type>int unsigned</type>
  52       <required>true</required>
  53       <comment>FK to civicrm acl.</comment>
  54       <add>2.0</add>
  55   </field>
  56   <foreignKey>
  57        <name>acl_id</name>
  58        <table>civicrm_acl</table>
  59        <key>id</key>
  60        <add>2.0</add>
  61   </foreignKey>
  62   <field>
  63       <name>admin_group_id</name>
  64       <type>int unsigned</type>
  65       <required>true</required>
  66       <comment>FK to admin civicrm group.</comment>
  67       <add>2.0</add>
  68       <pseudoconstant>
  69         <table>civicrm_group</table>
  70         <keyColumn>id</keyColumn>
  71         <labelColumn>title</labelColumn>
  72       </pseudoconstant>
  73   </field>
  74   <foreignKey>
  75        <name>admin_group_id</name>
  76        <table>civicrm_group</table>
  77        <key>id</key>
  78        <add>2.0</add>
  79   </foreignKey>
  80   <field>
  81       <name>admin_acl_id</name>
  82       <type>int unsigned</type>
  83       <required>true</required>
  84       <comment>FK to civicrm acl.</comment>
  85       <add>2.0</add>
  86   </field>
  87   <foreignKey>
  88        <name>admin_acl_id</name>
  89        <table>civicrm_acl</table>
  90        <key>id</key>
  91        <add>2.0</add>
  92   </foreignKey>
  93 </table>