'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; }