mailinglist_archive.install

Go to the documentation of this file.

<?php
function mailinglist_archive_schema() {
  $schema=array();
  $schema['mailinglist_archive'] = array(
    'description' => 'Table for holding the text of the messages',
    'fields' => array(
      'nid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Primary Key for table',
      ),
      'list' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'msg_id' => array(
        'type' => 'varchar',
        'length' => '2048',
        'description' => 'Message ID from message',
        'not null' => TRUE,
      ),
      'reply_to' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'description' => 'mid of message we are a reply to',
      ),
      'thread_id' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'mid of first message of thread',
      ),
      'time' => _mailinglist_datetime_schema(
        array(
          'description' => 'Time message was posted',
          'not null' => TRUE,
        )
      ),
      'year' => array(
        'type' => 'int',
        'size' => 'small',
        'not null' => TRUE,
      ),
      'month' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
      ),
      'day' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
      ),
      'hour' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
      ),
      'author' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Index to Author\'s ID in mailinglist_names'
      ),
      'author_email' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'status' => array(
        'type' => 'int',
        'description' => 'published status, 0 = published, 1 = moderation queue, 2=waiting reply, 3=rejected',
        'not null' => TRUE,
      ),
      // ?? digest flag, topic flags
    ),
    'primary key' => array('nid'),
    'unique key' => array(
      'msg_id' => array('msg_id'),
    ),
    'indexes' => array(
      'time' => array(array('list', 20), 'time'),
      'thread_id' => array('thread_id', 'time'),
      'author_email' => array(array('list', 20), array('author_email',40)),
      'hour' => array(array('list', 20), 'hour'),
      'msg_id' => array(array('msg_id', 40)),
      'reply_to' => array('reply_to', 'time'),
      'time_parsed' => array(array('list', 20), 'year', 'month', 'day'),
      ),
    'foreign keys' => array(
      'reply_to' => array(
        'table' => 'mailinglist_archive',
        'columns' => array('reply_to' => 'nid'),
      ),
      'thread_id' => array(
        'table' => 'mailinglist_archive',
        'columns' => array('thread_id' => 'nid'),
      ),
      'author' => array(
        'table' => 'mailinglist_names',
        'columns' => array('author' => 'key'),
      ),
    ),
  );

  $schema['mailinglist_archive_debug'] = array(
    'description' => 'Table for holding the text of the messages',
    'fields' => array(
      'nid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Primary Key for table',
      ),
      'updated' => _mailinglist_datetime_schema(
        array(
          'description' => 'Time message was last updated (Debug)',
          'not null' => TRUE,
        )
      ),
      'headers' => array(
        'type' => 'text',
        'serialize' => TRUE,
        'not null' => TRUE,
      ),
      'full_body' => array(
        'type' => 'text',
        'serialize' => TRUE,
        'not null' => TRUE,
      ),
      'raw_message' => array(
        'type' => 'text',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array('nid'),
    'indexes' => array(
      'updated' => array('updated'),
    ),
  );

  $schema['mailinglist_archive_reference']  = array(
    'description' => 'Table to track the references of a message',
    'fields' => array(
      'nid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'nid of message these are references to',
      ),
      'idx' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Sequence number for which ref this is for the meesage'
      ),
      'ref_nid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'description' => 'mid of message we are a reply to',
      ),
      'ref_msg_id' => array(
        'type' => 'varchar',
        'length' => '2048',
        'not null' => TRUE,
        'description' => 'Message ID of message we are a reply to',
      ),
    ),
    'primary key' => array('nid', 'idx'),
    'indexes' => array(
      'ref_nid' => array('ref_nid'),
      'ref_msg_id' => array(array('ref_msg_id', 40)),
    ),
    'foreign keys' => array(
      'nid' => array(
        'table' => 'mailinglist_archive',
        'columns' => array('nid' => 'nid'),
      ),
      'ref_nid' => array(
        'table' => 'mailinglist_archive',
        'columns' => array('ref_nid' => 'nid'),
      ),
      'ref_msgid' => array(
        'table' => 'mailinglist_archive',
        'columns' => array('ref_msg_id' => 'msg_id'),
      ),
    ),
  );

  $schema['mailinglist_archive_thread'] = array(
    'description' => 'Table for holding information about threads',
    'fields' => array(
      'thread_id' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'mid of first message of thread',
      ),
      'list' => array(
        'type' => 'varchar',
        'length' => '255',
        'description' => 'List the thread is on',
        'not null' => TRUE,
      ),
      'start_time' => _mailinglist_datetime_schema(array(
        'description' => 'Time thread was started',
        'not null' => TRUE,
      )),
      'last_time' => _mailinglist_datetime_schema(array(
        'description' => 'Time thread was last posted to',
        'not null' => TRUE,
      )),
    ),
    'primary key' => array('thread_id'),
    'indexes' => array(
      'times' => array('list', 'start_time', 'last_time'),
    ),
  );

  $lists = mailinglist_list_load_all();
  foreach ($lists as $list) {
    $list_schema = _mailinglist_archives_list_schema($list);
    $schema += $list_schema;
  }
  return $schema;
}

function mailinglist_archive_enable() {
}

function mailinglist_archive_modules_enabled($modules) {
}