materio-base-d7/sites/all/modules/gui/materiobasemod/materio_showroom.install

<?php
/**
 * @file
 * Install, update, and uninstall functions for the field_example module.
 */

/**
 * Implements hook_field_schema().
 *
 * Defines the database schema of the field, using the format used by the
 * Schema API.
 *
 * The data we will store here is just one 7-character element, even
 * though the widget presents the three portions separately.
 *
 * All implementations of hook_field_schema() must be in the module's
 * .install file.
 *
 * @see http://drupal.org/node/146939
 * @see schemaapi
 * @see hook_field_schema()
 * @ingroup field_example
 */
function materio_showroom_field_schema($field) {
  $columns = array(
    'showroom_tid' => array('type' => 'int', 'not null' => FALSE),
    'location' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE),
  );
  $indexes = array(
    'location' => array('location'),
  );
  return array(
    'columns' => $columns,
    'indexes' => $indexes,
  );
}