function contact_schema

Implements hook_schema().

File

modules/contact/contact.install, line 11

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.',
                'translatable' => TRUE,
            ),
            '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,
                '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;
}