function faq_ask_schema in FAQ_Ask 6.2

Same name and namespace in other branches

1. 8 faq_ask.install \faq_ask_schema()
2. 6 faq_ask.install \faq_ask_schema()
3. 7 faq_ask.install \faq_ask_schema()

Implementation of hook_schema().

1 call to faq_ask_schema()

faq_ask_update_6101 in ./faq_ask.install

File

./faq_ask.install, line 12

This module is an add-on to the FAQ module that allows users with the 'ask question' permission to create a question which will be queued for an 'expert' to answer.

Code

function faq_ask_schema() {
  $schema['faq_expert'] = array(
    'description' => t('FAQ expert to term mapping.'),
    'fields' => array(
      'uid' => array(
        'description' => t('User identifier for the expert.'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'tid' => array(
        'description' => t('Taxonomy identifier of the terms for the expert.'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'uid',
      'tid',
    ),
    'indexes' => array(
      'tid' => array(
        'tid',
        'uid',
      ),
    ),
  );
  $schema['faq_ask_notify'] = array(
    'description' => t('FAQ node to asker mapping.'),
    'fields' => array(
      'nid' => array(
        'description' => t('Node identifier for notification'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'email' => array(
        'description' => t('Node identifier for notification'),
        'type' => 'varchar',
        'length' => '128',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'nid',
      'email',
    ),
    'indexes' => array(
      'nid' => array(
        'nid',
        'email',
      ),
    ),
  );
  return $schema;
}