xml/schema/Standalone/OpenID/Associations.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Standalone/OpenID</base>
   5   <class>Associations</class>
   6   <name>civicrm_openid_associations</name>
   7   <comment>The OpenID associations store for standalone login.</comment>
   8   <add>2.0</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <add>2.0</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20       <name>server_url</name>
  21       <type>blob</type>
  22       <add>2.0</add>
  23   </field>
  24   <field>
  25        <name>handle</name>
  26        <type>varchar</type>
  27        <length>255</length>
  28        <html>
  29           <type>Text</type>
  30        </html>
  31        <add>2.0</add>
  32   </field>
  33   <field>
  34       <name>secret</name>
  35       <type>blob</type>
  36       <add>2.0</add>
  37   </field>
  38   <field>
  39       <name>issued</name>
  40       <type>int</type>
  41       <add>2.0</add>
  42   </field>
  43   <field>
  44       <name>lifetime</name>
  45       <type>int</type>
  46       <add>2.0</add>
  47   </field>
  48   <field>
  49       <name>assoc_type</name>
  50       <type>varchar</type>
  51       <length>64</length>
  52       <html>
  53           <type>Text</type>
  54        </html>
  55       <add>2.0</add>
  56   </field>
  57   <index>
  58       <name>server_url_handle_index</name>
  59       <fieldName length="166">server_url</fieldName>
  60       <fieldName length="166">handle</fieldName>
  61       <unique>true</unique>
  62       <add>2.0</add>
  63   </index>
  64 </table>