trpfancy_fields.install

<?php
/**
 * @file
 * Handles installation of this module
 */

/**
 * Implements hook_schema().
 */
function trpfancy_fields_schema() {
  $schema = array();

  //-------------------------
  // Quick Browse Field
  // A) Options are Constant for a given field instance.
  $schema['trpfancy_browse_options'] = array(
    'description' => 'Stores options that are constant for a given field instance.',
    'fields' => array(
      'option_id' => array(
        'description' => 'The primary identifier for the option.',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'instance_id' => array(
        'description' => 'The field instance these options are for.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'category' => array(
        'description' => 'The category the option belongs to.',
        'type' => 'varchar',
        'not null' => TRUE
      ),
      'key' => array(
        'description' => 'The key for the given option. This should be a machine friendly name for the option.',
        'type' => 'varchar',
        'not null' => TRUE
      ),
      'value' => array(
        'description' => 'The key for the given option. This should be a machine friendly name for the option.',
        'type' => 'varchar',
        'not null' => TRUE
      ),
    ),
    'indexes' => array(
      'field_id' => array('instance_id'),
    ),
    'unique keys' => array( ),
    'primary key' => array('option_id'),
  );

  // B) Options are specific to an entity / field instance combination.
  $schema['trpfancy_browse_options_per_entity'] = array(
    'description' => 'Stores options that are specific to the entity for a given field instance.',
    'fields' => array(
      'option_id' => array(
        'description' => 'The primary identifier for the option.',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'instance_id' => array(
        'description' => 'The field instance these options are for.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'entity_id' => array(
        'description' => 'The entity these options are for.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'category' => array(
        'description' => 'The category the option belongs to.',
        'type' => 'varchar',
        'not null' => TRUE
      ),
      'key' => array(
        'description' => 'The key for the given option. This should be a machine friendly name for the option.',
        'type' => 'varchar',
        'not null' => TRUE
      ),
      'value' => array(
        'description' => 'The key for the given option. This should be a machine friendly name for the option.',
        'type' => 'varchar',
        'not null' => TRUE
      ),
    ),
    'indexes' => array(
      'field_id' => array('instance_id', 'entity_id'),
    ),
    'unique keys' => array( ),
    'primary key' => array('option_id'),
  );

  return $schema;
}

/**
 * Add Quick Browse option tables.
 */
function trpfancy_fields_update_7001(&$sandbox) {

  $schema = trpfancy_fields_schema();
  db_create_table('trpfancy_browse_options', $schema['trpfancy_browse_options']);
  db_create_table('trpfancy_browse_options_per_entity', $schema['trpfancy_browse_options_per_entity']);

}