contact_schema

Implementation of hook_schema().

File

modules/contact/contact.install, line 26

Code

function contact_schema() {
  $schema['contact'] = array(
    'description' => 'Contact form category settings.', 
    'fields' => array(
      'cid' => array(
        'type' => 'serial', 
        'unsigned' => TRUE, 
        'not null' => TRUE, 
        'description' => 'Primary Key: Unique category ID.',
      ), 
      'category' => array(
        'type' => 'varchar', 
        'length' => 255, 
        'not null' => TRUE, 
        'default' => '', 
        'description' => 'Category name.',
      ), 
      'recipients' => array(
        'type' => 'text', 
        'not null' => TRUE, 
        'size' => 'big', 
        'description' => 'Comma-separated list of recipient e-mail addresses.',
      ), 
      'reply' => array(
        'type' => 'text', 
        'not null' => TRUE, 
        'size' => 'big', 
        'description' => 'Text of the auto-reply message.',
      ), 
      'weight' => array(
        'type' => 'int', 
        'not null' => TRUE, 
        'default' => 0, 
        'size' => 'tiny', 
        'description' => "The category's weight.",
      ), 
      'selected' => array(
        'type' => 'int', 
        'not null' => TRUE, 
        'default' => 0, 
        'size' => 'tiny', 
        'description' => 'Flag to indicate whether or not category is selected by default. (1 = Yes, 0 = No)',
      ),
    ), 
    'primary key' => array('cid'), 
    'unique keys' => array(
      'category' => array('category'),
    ), 
    'indexes' => array(
      'list' => array('weight', 'category'),
    ),
  );

  return $schema;
}