Implements hook_schema().
function shortcut_schema() {
$schema['shortcut_set_users'] = array(
'description' => 'Maps users to shortcut sets.',
'fields' => array(
'uid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
'description' => 'The {users}.uid for this set.',
),
'set_name' => array(
'type' => 'varchar',
'length' => 32,
'not null' => TRUE,
'default' => '',
'description' => "The {shortcut_set}.set_name that will be displayed for this user.",
),
),
'primary key' => array(
'uid',
),
'indexes' => array(
'set_name' => array(
'set_name',
),
),
'foreign keys' => array(
'set_user' => array(
'table' => 'users',
'columns' => array(
'uid' => 'uid',
),
),
'set_name' => array(
'table' => 'shortcut_set',
'columns' => array(
'set_name' => 'set_name',
),
),
),
);
return $schema;
}