[Summary view] [Print] [Text view]

   1  <?php
   2  // $Id: taxonomy.install,v 1.7.2.1 2009/01/06 15:46:38 goba Exp $
   3  
   4  /**
   5   * Implementation of hook_schema().
   6   */
   7  function taxonomy_schema() {
   8    $schema['term_data'] = array(
   9      'description' => 'Stores term information.',
  10      'fields' => array(
  11        'tid' => array(
  12          'type' => 'serial',
  13          'unsigned' => TRUE,
  14          'not null' => TRUE,
  15          'description' => 'Primary Key: Unique term ID.',
  16        ),
  17        'vid' => array(
  18          'type' => 'int',
  19          'unsigned' => TRUE,
  20          'not null' => TRUE,
  21          'default' => 0,
  22          'description' => 'The {vocabulary}.vid of the vocabulary to which the term is assigned.',
  23        ),
  24        'name' => array(
  25          'type' => 'varchar',
  26          'length' => 255,
  27          'not null' => TRUE,
  28          'default' => '',
  29          'description' => 'The term name.',
  30        ),
  31        'description' => array(
  32          'type' => 'text',
  33          'not null' => FALSE,
  34          'size' => 'big',
  35          'description' => 'A description of the term.',
  36        ),
  37        'weight' => array(
  38          'type' => 'int',
  39          'not null' => TRUE,
  40          'default' => 0,
  41          'size' => 'tiny',
  42          'description' => 'The weight of this term in relation to other terms.',
  43        ),
  44      ),
  45      'primary key' => array('tid'),
  46      'indexes' => array(
  47        'taxonomy_tree' => array('vid', 'weight', 'name'),
  48        'vid_name' => array('vid', 'name'),
  49      ),
  50    );
  51  
  52    $schema['term_hierarchy'] = array(
  53      'description' => 'Stores the hierarchical relationship between terms.',
  54      'fields' => array(
  55        'tid' => array(
  56          'type' => 'int',
  57          'unsigned' => TRUE,
  58          'not null' => TRUE,
  59          'default' => 0,
  60          'description' => 'Primary Key: The {term_data}.tid of the term.',
  61        ),
  62        'parent' => array(
  63          'type' => 'int',
  64          'unsigned' => TRUE,
  65          'not null' => TRUE,
  66          'default' => 0,
  67          'description' => "Primary Key: The {term_data}.tid of the term's parent. 0 indicates no parent.",
  68        ),
  69      ),
  70      'indexes' => array(
  71        'parent' => array('parent'),
  72      ),
  73      'primary key' => array('tid', 'parent'),
  74    );
  75  
  76    $schema['term_node'] = array(
  77      'description' => 'Stores the relationship of terms to nodes.',
  78      'fields' => array(
  79        'nid' => array(
  80          'type' => 'int',
  81          'unsigned' => TRUE,
  82          'not null' => TRUE,
  83          'default' => 0,
  84          'description' => 'Primary Key: The {node}.nid of the node.',
  85        ),
  86        'vid' => array(
  87          'type' => 'int',
  88          'unsigned' => TRUE,
  89          'not null' => TRUE,
  90          'default' => 0,
  91          'description' => 'Primary Key: The {node}.vid of the node.',
  92        ),
  93        'tid' => array(
  94          'type' => 'int',
  95          'unsigned' => TRUE,
  96          'not null' => TRUE,
  97          'default' => 0,
  98          'description' => 'Primary Key: The {term_data}.tid of a term assigned to the node.',
  99        ),
 100      ),
 101      'indexes' => array(
 102        'vid' => array('vid'),
 103        'nid' => array('nid'),
 104      ),
 105      'primary key' => array('tid', 'vid'),
 106    );
 107  
 108    $schema['term_relation'] = array(
 109      'description' => 'Stores non-hierarchical relationships between terms.',
 110      'fields' => array(
 111        'trid' => array(
 112          'type' => 'serial',
 113          'not null' => TRUE,
 114          'description' => 'Primary Key: Unique term relation ID.',
 115        ),
 116        'tid1' => array(
 117          'type' => 'int',
 118          'unsigned' => TRUE,
 119          'not null' => TRUE,
 120          'default' => 0,
 121          'description' => 'The {term_data}.tid of the first term in a relationship.',
 122        ),
 123        'tid2' => array(
 124          'type' => 'int',
 125          'unsigned' => TRUE,
 126          'not null' => TRUE,
 127          'default' => 0,
 128          'description' => 'The {term_data}.tid of the second term in a relationship.',
 129        ),
 130      ),
 131      'unique keys' => array(
 132        'tid1_tid2' => array('tid1', 'tid2'),
 133      ),
 134      'indexes' => array(
 135        'tid2' => array('tid2'),
 136      ),
 137      'primary key' => array('trid'),
 138    );
 139  
 140    $schema['term_synonym'] = array(
 141      'description' => 'Stores term synonyms.',
 142      'fields' => array(
 143        'tsid' => array(
 144          'type' => 'serial',
 145          'not null' => TRUE,
 146          'description' => 'Primary Key: Unique term synonym ID.',
 147        ),
 148        'tid' => array(
 149          'type' => 'int',
 150          'unsigned' => TRUE,
 151          'not null' => TRUE,
 152          'default' => 0,
 153          'description' => 'The {term_data}.tid of the term.',
 154        ),
 155        'name' => array(
 156          'type' => 'varchar',
 157          'length' => 255,
 158          'not null' => TRUE,
 159          'default' => '',
 160          'description' => 'The name of the synonym.',
 161        ),
 162      ),
 163      'indexes' => array(
 164        'tid' => array('tid'),
 165        'name_tid' => array('name', 'tid'),
 166      ),
 167      'primary key' => array('tsid'),
 168    );
 169  
 170    $schema['vocabulary'] = array(
 171      'description' => 'Stores vocabulary information.',
 172      'fields' => array(
 173        'vid' => array(
 174          'type' => 'serial',
 175          'unsigned' => TRUE,
 176          'not null' => TRUE,
 177          'description' => 'Primary Key: Unique vocabulary ID.',
 178        ),
 179        'name' => array(
 180          'type' => 'varchar',
 181          'length' => 255,
 182          'not null' => TRUE,
 183          'default' => '',
 184          'description' => 'Name of the vocabulary.',
 185        ),
 186        'description' => array(
 187          'type' => 'text',
 188          'not null' => FALSE,
 189          'size' => 'big',
 190          'description' => 'Description of the vocabulary.',
 191        ),
 192        'help' => array(
 193          'type' => 'varchar',
 194          'length' => 255,
 195          'not null' => TRUE,
 196          'default' => '',
 197          'description' => 'Help text to display for the vocabulary.',
 198        ),
 199        'relations' => array(
 200          'type' => 'int',
 201          'unsigned' => TRUE,
 202          'not null' => TRUE,
 203          'default' => 0,
 204          'size' => 'tiny',
 205          'description' => 'Whether or not related terms are enabled within the vocabulary. (0 = disabled, 1 = enabled)',
 206        ),
 207        'hierarchy' => array(
 208          'type' => 'int',
 209          'unsigned' => TRUE,
 210          'not null' => TRUE,
 211          'default' => 0,
 212          'size' => 'tiny',
 213          'description' => 'The type of hierarchy allowed within the vocabulary. (0 = disabled, 1 = single, 2 = multiple)',
 214        ),
 215        'multiple' => array(
 216          'type' => 'int',
 217          'unsigned' => TRUE,
 218          'not null' => TRUE,
 219          'default' => 0,
 220          'size' => 'tiny',
 221          'description' => 'Whether or not multiple terms from this vocabulary may be assigned to a node. (0 = disabled, 1 = enabled)',
 222        ),
 223        'required' => array(
 224          'type' => 'int',
 225          'unsigned' => TRUE,
 226          'not null' => TRUE,
 227          'default' => 0,
 228          'size' => 'tiny',
 229          'description' => 'Whether or not terms are required for nodes using this vocabulary. (0 = disabled, 1 = enabled)',
 230        ),
 231        'tags' => array(
 232          'type' => 'int',
 233          'unsigned' => TRUE,
 234          'not null' => TRUE,
 235          'default' => 0,
 236          'size' => 'tiny',
 237          'description' => 'Whether or not free tagging is enabled for the vocabulary. (0 = disabled, 1 = enabled)',
 238        ),
 239        'module' => array(
 240          'type' => 'varchar',
 241          'length' => 255,
 242          'not null' => TRUE,
 243          'default' => '',
 244          'description' => 'The module which created the vocabulary.',
 245        ),
 246        'weight' => array(
 247          'type' => 'int',
 248          'not null' => TRUE,
 249          'default' => 0,
 250          'size' => 'tiny',
 251          'description' => 'The weight of the vocabulary in relation to other vocabularies.',
 252        ),
 253      ),
 254      'primary key' => array('vid'),
 255      'indexes' => array(
 256        'list' => array('weight', 'name'),
 257      ),
 258    );
 259  
 260    $schema['vocabulary_node_types'] = array(
 261      'description' => 'Stores which node types vocabularies may be used with.',
 262      'fields' => array(
 263        'vid' => array(
 264          'type' => 'int',
 265          'unsigned' => TRUE,
 266          'not null' => TRUE,
 267          'default' => 0,
 268          'description' => 'Primary Key: the {vocabulary}.vid of the vocabulary.',
 269        ),
 270        'type' => array(
 271          'type' => 'varchar',
 272          'length' => 32,
 273          'not null' => TRUE,
 274          'default' => '',
 275          'description' => 'The {node}.type of the node type for which the vocabulary may be used.',
 276        ),
 277      ),
 278      'primary key' => array('type', 'vid'),
 279      'indexes' => array(
 280        'vid' => array('vid'),
 281      ),
 282    );
 283  
 284    return $schema;
 285  }
 286