You are here

function fb_friend_schema in Drupal for Facebook 6.3

Same name and namespace in other branches
  1. 7.3 contrib/fb_friend.install \fb_friend_schema()
1 call to fb_friend_schema()
fb_friend_update_6300 in contrib/fb_friend.install

File

contrib/fb_friend.install, line 28
Installs database tables and settings required by fb_friend module.

Code

function fb_friend_schema() {
  $schema['fb_friend'] = array(
    'description' => 'Main fb_friend table.  Stores friend to friend interaction in a generic way. For example, that Joe invited Sally to visit node/42, but not limited to just invitations.',
    'fields' => array(
      'fb_friend_id' => array(
        'description' => 'The primary identifier.',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'module' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'description' => 'Textual id for type of interaction represented by this row.',
      ),
      'ref_id' => array(
        'description' => 'Reference to another entity. i.e. node, user, etc',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'label' => array(
        /* Would it be better to store id? */
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'description' => 'Unique textual id for app. See fb_app table.',
      ),
      'fbu_actor' => array(
        'description' => 'For example the user who sent an invitation.',
        'type' => 'int',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'fbu_target' => array(
        'description' => 'For example the user being invited.',
        'type' => 'int',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'status' => array(
        'description' => 'For invitations, 1=active, 2=accepted.',
        'type' => 'int',
        'size' => 'small',
        'not null' => TRUE,
        'default' => 1,
      ),
      'created' => array(
        'description' => 'The Unix timestamp when the row was created.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'data' => array(
        'type' => 'text',
        'size' => 'big',
        'description' => 'serialized generic data.',
        'default' => NULL,
      ),
    ),
    'primary key' => array(
      'fb_friend_id',
    ),
    'indexes' => array(
      'fb_friend_fbu_actor' => array(
        'fbu_actor',
      ),
      'fb_friend_fbu_target' => array(
        'fbu_target',
      ),
      'fb_friend_module' => array(
        'module',
      ),
      'fb_friend_module_ref_id' => array(
        'module',
        'ref_id',
      ),
      'fb_friend_label' => array(
        'label',
      ),
    ),
  );
  return $schema;
}