function scheduler_schema in Scheduler 6

Same name and namespace in other branches

1. 7 scheduler.install \scheduler_schema()

Implementation of hook_schema().

File

./scheduler.install, line 11

Installation file for Scheduler module.

Code

function scheduler_schema() {
  return array(
    'scheduler' => array(
      'description' => t('The main table to hold the scheduler data.'),
      'fields' => array(
        'nid' => array(
          'description' => t('The foreign key to node.nid'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
        ),
        'publish_on' => array(
          'description' => t('The UNIX UTC timestamp when to publish'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
          'default' => 0,
        ),
        'unpublish_on' => array(
          'description' => t('The UNIX UTC timestamp when to unpublish'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
          'default' => 0,
        ),
      ),
      'indexes' => array(
        'scheduler_publish_on' => array(
          'publish_on',
        ),
        'scheduler_unpublish_on' => array(
          'unpublish_on',
        ),
      ),
      'primary key' => array(
        'nid',
      ),
    ),
  );
}