shortcut_schema

Implements hook_schema().

File

modules/shortcut/shortcut.install, line 52

Install, update and uninstall functions for the shortcut module.

Code

function shortcut_schema() {
  $schema['shortcut_set'] = array(
    'description' => 'Stores information about sets of shortcuts links.', 
    'fields' => array(
      'set_name' => array(
        'type' => 'varchar', 
        'length' => 32, 
        'not null' => TRUE, 
        'default' => '', 
        'description' => "Primary Key: The {menu_links}.menu_name under which the set's links are stored.",
      ), 
      'title' => array(
        'type' => 'varchar', 
        'length' => 255, 
        'not null' => TRUE, 
        'default' => '', 
        'description' => 'The title of the set.',
      ),
    ), 
    'primary key' => array('set_name'), 
    'foreign keys' => array(
      'menu_name' => array(
        'table' => 'menu_links', 
        'columns' => array('set_name' => 'menu_name'),
      ),
    ),
  );

  $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;
}