crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/xml/schema/Core/Navigation.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Navigation</class>
   6   <name>civicrm_navigation</name>
   7   <comment>Table to store navigation.</comment>
   8   <add>3.0</add>
   9   <field>
  10     <name>id</name>
  11     <type>int unsigned</type>
  12     <required>true</required>
  13     <add>3.0</add>
  14   </field>
  15   <primaryKey>
  16     <name>id</name>
  17     <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20     <name>domain_id</name>
  21     <type>int unsigned</type>
  22     <required>true</required>
  23     <pseudoconstant>
  24       <table>civicrm_domain</table>
  25       <keyColumn>id</keyColumn>
  26       <labelColumn>name</labelColumn>
  27     </pseudoconstant>
  28     <comment>Which Domain is this navigation item for</comment>
  29     <add>3.0</add>
  30   </field>
  31   <foreignKey>
  32     <name>domain_id</name>
  33     <table>civicrm_domain</table>
  34     <key>id</key>
  35     <add>3.0</add>
  36   </foreignKey>
  37   <field>
  38     <name>label</name>
  39     <type>varchar</type>
  40     <length>255</length>
  41     <comment>Navigation Title</comment>
  42     <add>3.0</add>
  43   </field>
  44   <field>
  45     <name>name</name>
  46     <type>varchar</type>
  47     <length>255</length>
  48     <comment>Internal Name</comment>
  49     <add>3.0</add>
  50   </field>
  51   <field>
  52     <name>url</name>
  53     <type>varchar</type>
  54     <length>255</length>
  55     <comment>url in case of custom navigation link</comment>
  56     <add>3.0</add>
  57   </field>
  58   <field>
  59     <name>permission</name>
  60     <type>varchar</type>
  61     <length>255</length>
  62     <comment>Permission for menu item</comment>
  63     <add>3.0</add>
  64   </field>
  65   <field>
  66     <name>permission_operator</name>
  67     <type>varchar</type>
  68     <length>3</length>
  69     <comment>Permission Operator</comment>
  70     <add>3.0</add>
  71   </field>
  72   <field>
  73     <name>parent_id</name>
  74     <type>int unsigned</type>
  75     <comment>Parent navigation item, used for grouping</comment>
  76     <add>3.0</add>
  77   </field>
  78   <foreignKey>
  79     <name>parent_id</name>
  80     <table>civicrm_navigation</table>
  81     <key>id</key>
  82     <onDelete>CASCADE</onDelete>
  83     <add>3.0</add>
  84   </foreignKey>
  85   <field>
  86     <name>is_active</name>
  87     <type>boolean</type>
  88     <comment>Is this navigation item active?</comment>
  89     <add>3.0</add>
  90   </field>
  91   <field>
  92     <name>has_separator</name>
  93     <type>boolean</type>
  94     <comment>If separator needs to be added after this menu item</comment>
  95     <add>3.0</add>
  96   </field>
  97   <field>
  98     <name>weight</name>
  99     <title>Order</title>
 100     <type>int</type>
 101     <comment>Ordering of the navigation items in various blocks.</comment>
 102     <add>3.0</add>
 103   </field>
 104 </table>