#
# CERBERUS HELPDESK 2.0.0 - DATABASE CREATE SQL
#
# --------------------------------------------------------

#
# Table structure for table `address`
#

CREATE TABLE `address` (
  `address_id` int(10) unsigned NOT NULL auto_increment,
  `address_password` char(30) NOT NULL default '',
  `address_address` char(128) NOT NULL default '',
  `address_banned` tinyint(4) NOT NULL default '0',
  `company_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`address_id`),
  KEY `address_address` (`address_address`),
  KEY `company_id` (`company_id`)
) TYPE=MyISAM;

#
# Dumping data for table `address`
#

# --------------------------------------------------------

#
# Table structure for table `address_fields`
#

CREATE TABLE `address_fields` (
  `field_id` bigint(20) NOT NULL auto_increment,
  `field_name` varchar(64) NOT NULL default '',
  `field_type` enum('S','T','D') NOT NULL default 'S',
  `field_options` text NOT NULL,
  PRIMARY KEY  (`field_id`)
) TYPE=MyISAM;

#
# Dumping data for table `address_fields`
#

# --------------------------------------------------------

#
# Table structure for table `address_values`
#

CREATE TABLE `address_values` (
  `value_id` bigint(20) NOT NULL auto_increment,
  `field_id` bigint(20) NOT NULL default '0',
  `address_id` bigint(20) NOT NULL default '0',
  `value_text` text NOT NULL,
  PRIMARY KEY  (`value_id`)
) TYPE=MyISAM;

#
# Dumping data for table `address_values`
#

# --------------------------------------------------------

#
# Table structure for table `company`
#

CREATE TABLE `company` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `sla_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `sla_id` (`sla_id`)
) TYPE=MyISAM;

#
# Dumping data for table `company`
#

# --------------------------------------------------------

#
# Table structure for table `configuration`
#

CREATE TABLE `configuration` (
  `cfg_id` bigint(1) NOT NULL default '1',
  `cerberus_gui_path` char(64) NOT NULL default '',
  `customer_ticket_history_max` tinyint(4) NOT NULL default '0',
  `debug_mode` tinyint(4) NOT NULL default '0',
  `default_language` char(3) NOT NULL default '',
  `demo` tinyint(4) NOT NULL default '0',
  `enable_audit_log` tinyint(4) NOT NULL default '0',
  `enable_customer_history` tinyint(4) NOT NULL default '0',
  `enable_panel_stats` tinyint(4) NOT NULL default '0',
  `gui_version` char(16) NOT NULL default '',
  `http_server` char(128) NOT NULL default '',
  `kb_editors_enabled` tinyint(4) NOT NULL default '0',
  `list_tickets_per_page` int(11) NOT NULL default '0',
  `mail_delay` int(11) NOT NULL default '0',
  `mail_delivery` char(8) NOT NULL default '',
  `master_db_name` char(64) NOT NULL default '',
  `master_db_pass` char(64) NOT NULL default '',
  `master_db_server` char(64) NOT NULL default '',
  `master_db_user` char(64) NOT NULL default '',
  `only_unassigned_in_new` tinyint(4) NOT NULL default '0',
  `overdue_hours` int(11) NOT NULL default '0',
  `satellite_enabled` tinyint(4) NOT NULL default '0',
  `sendmail` tinyint(4) NOT NULL default '0',
  `session_lifespan` int(4) NOT NULL default '720',
  `show_kb` tinyint(4) NOT NULL default '0',
  `show_kb_topic_totals` tinyint(4) NOT NULL default '0',
  `smtp_server` char(64) NOT NULL default '',
  `time_adjust` bigint(20) NOT NULL default '0',
  `track_sid_url` tinyint(4) NOT NULL default '0',
  `who_max_idle_mins` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cfg_id`)
) TYPE=MyISAM;

#
# Dumping data for table `configuration`
#

# --------------------------------------------------------

#
# Table structure for table `email_domains`
#

CREATE TABLE `email_domains` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `domain` varchar(128) NOT NULL default '',
  `company_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `company_id` (`company_id`)
) TYPE=MyISAM;

#
# Dumping data for table `email_domains`
#

# --------------------------------------------------------

#
# Table structure for table `email_templates`
#

CREATE TABLE `email_templates` (
  `template_id` bigint(20) unsigned NOT NULL auto_increment,
  `template_name` varchar(128) NOT NULL default '',
  `template_description` varchar(255) NOT NULL default '',
  `template_text` text NOT NULL,
  `template_created_by` bigint(20) NOT NULL default '0',
  `template_private` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`template_id`),
  KEY `template_id` (`template_id`)
) TYPE=MyISAM;

#
# Dumping data for table `email_templates`
#

# --------------------------------------------------------

#
# Table structure for table `knowledgebase`
#

CREATE TABLE `knowledgebase` (
  `kb_id` int(10) unsigned NOT NULL auto_increment,
  `kb_entry_date` datetime default NULL,
  `kb_entry_user` int(10) unsigned NOT NULL default '0',
  `kb_category_id` int(10) unsigned NOT NULL default '0',
  `kb_keywords` char(255) NOT NULL default '',
  `kb_public` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`kb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `knowledgebase`
#

# --------------------------------------------------------

#
# Table structure for table `knowledgebase_categories`
#

CREATE TABLE `knowledgebase_categories` (
  `kb_category_id` int(10) unsigned NOT NULL auto_increment,
  `kb_category_name` char(32) NOT NULL default '',
  `kb_category_parent_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`kb_category_id`)
) TYPE=MyISAM;

#
# Dumping data for table `knowledgebase_categories`
#

# --------------------------------------------------------

#
# Table structure for table `knowledgebase_comments`
#

CREATE TABLE `knowledgebase_comments` (
  `kb_comment_id` bigint(20) unsigned NOT NULL auto_increment,
  `kb_article_id` bigint(20) unsigned NOT NULL default '0',
  `kb_comment_approved` tinyint(4) NOT NULL default '0',
  `kb_comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `poster_email` varchar(128) NOT NULL default '',
  `poster_comment` text NOT NULL,
  `poster_ip` varchar(16) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`kb_comment_id`),
  KEY `kb_article_id` (`kb_article_id`),
  KEY `kb_comment_approved` (`kb_comment_approved`)
) TYPE=MyISAM;

#
# Dumping data for table `knowledgebase_comments`
#

# --------------------------------------------------------

#
# Table structure for table `knowledgebase_problem`
#

CREATE TABLE `knowledgebase_problem` (
  `kb_problem_id` int(10) unsigned NOT NULL auto_increment,
  `kb_id` int(10) unsigned NOT NULL default '0',
  `kb_problem_summary` varchar(128) NOT NULL default '',
  `kb_problem_text` text NOT NULL,
  PRIMARY KEY  (`kb_problem_id`)
) TYPE=MyISAM;

#
# Dumping data for table `knowledgebase_problem`
#

# --------------------------------------------------------

#
# Table structure for table `knowledgebase_ratings`
#

CREATE TABLE `knowledgebase_ratings` (
  `rating_id` bigint(20) unsigned NOT NULL auto_increment,
  `kb_article_id` bigint(20) NOT NULL default '0',
  `ip_addr` char(16) NOT NULL default '',
  `rating` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`rating_id`),
  UNIQUE KEY `kb_article_id` (`kb_article_id`,`ip_addr`)
) TYPE=MyISAM;

#
# Dumping data for table `knowledgebase_ratings`
#

# --------------------------------------------------------

#
# Table structure for table `knowledgebase_solution`
#

CREATE TABLE `knowledgebase_solution` (
  `kb_solution_id` int(10) unsigned NOT NULL auto_increment,
  `kb_id` int(10) unsigned NOT NULL default '0',
  `kb_solution_text` text NOT NULL,
  PRIMARY KEY  (`kb_solution_id`)
) TYPE=MyISAM;

#
# Dumping data for table `knowledgebase_solution`
#

# --------------------------------------------------------

#
# Table structure for table `log`
#

CREATE TABLE `log` (
  `log_id` bigint(20) unsigned NOT NULL auto_increment,
  `message` text NOT NULL,
  `log_date` timestamp(14) NOT NULL,
  PRIMARY KEY  (`log_id`),
  KEY `log_id` (`log_id`)
) TYPE=MyISAM;

#
# Dumping data for table `log`
#

# --------------------------------------------------------

#
# Table structure for table `product_key`
#

CREATE TABLE `product_key` (
  `key_file` text NOT NULL,
  `key_date` timestamp(14) NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table `product_key`
#

# --------------------------------------------------------

#
# Table structure for table `product_key_info`
#

CREATE TABLE `product_key_info` (
  `key_name` varchar(255) NOT NULL default '',
  `key_email` varchar(255) NOT NULL default '',
  `key_issue` varchar(8) NOT NULL default '',
  `key_domains` tinytext NOT NULL,
  `key_maxqueues` int(11) NOT NULL default '0',
  `key_tagline` varchar(255) NOT NULL default '',
  `key_lastupdate` timestamp(14) NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table `product_key_info`
#

# --------------------------------------------------------

#
# Table structure for table `queue`
#

CREATE TABLE `queue` (
  `queue_id` int(11) NOT NULL auto_increment,
  `queue_name` varchar(32) NOT NULL default '',
  `queue_prefix` varchar(32) NOT NULL default '',
  `queue_response_open` text NOT NULL,
  `queue_response_close` text NOT NULL,
  `queue_send_open` tinyint(4) NOT NULL default '0',
  `queue_send_closed` tinyint(4) NOT NULL default '0',
  `queue_restricted` tinyint(4) NOT NULL default '0',
  `queue_response_restricted` text NOT NULL,
  `queue_core_update` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`queue_id`)
) TYPE=MyISAM;

#
# Dumping data for table `queue`
#

# --------------------------------------------------------

#
# Table structure for table `queue_access`
#

CREATE TABLE `queue_access` (
  `queue_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `queue_access` enum('read','write') NOT NULL default 'read',
  `queue_watch` tinyint(1) NOT NULL default '0',
  KEY `queue_id` (`queue_id`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `queue_access`
#

# --------------------------------------------------------

#
# Table structure for table `queue_addresses`
#

CREATE TABLE `queue_addresses` (
  `queue_addresses_id` int(11) NOT NULL auto_increment,
  `queue_id` int(11) NOT NULL default '0',
  `queue_address` varchar(128) NOT NULL default '',
  `queue_domain` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`queue_addresses_id`),
  KEY `queue_id` (`queue_id`)
) TYPE=MyISAM;

#
# Dumping data for table `queue_addresses`
#

# --------------------------------------------------------

#
# Table structure for table `requestor`
#

CREATE TABLE `requestor` (
  `requestor_id` bigint(20) unsigned NOT NULL auto_increment,
  `ticket_id` bigint(20) unsigned NOT NULL default '0',
  `address_id` int(10) unsigned default '0',
  PRIMARY KEY  (`requestor_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `address_id` (`address_id`)
) TYPE=MyISAM;

#
# Dumping data for table `requestor`
#

# --------------------------------------------------------

#
# Table structure for table `rule_action`
#

CREATE TABLE `rule_action` (
  `rule_id` bigint(20) unsigned NOT NULL default '0',
  `action_type` int(10) unsigned NOT NULL default '0',
  `action_value` char(128) NOT NULL default '',
  KEY `rule_id` (`rule_id`)
) TYPE=MyISAM;

#
# Dumping data for table `rule_action`
#

# --------------------------------------------------------

#
# Table structure for table `rule_entry`
#

CREATE TABLE `rule_entry` (
  `rule_id` bigint(20) unsigned NOT NULL auto_increment,
  `rule_name` char(128) NOT NULL default '',
  `rule_order` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rule_id`)
) TYPE=MyISAM;

#
# Dumping data for table `rule_entry`
#

# --------------------------------------------------------

#
# Table structure for table `rule_fov`
#

CREATE TABLE `rule_fov` (
  `rule_id` bigint(20) unsigned NOT NULL default '0',
  `fov_field` int(10) unsigned NOT NULL default '0',
  `fov_oper` int(10) unsigned NOT NULL default '0',
  `fov_value` char(128) NOT NULL default '',
  KEY `rule_id` (`rule_id`)
) TYPE=MyISAM;

#
# Dumping data for table `rule_fov`
#

# --------------------------------------------------------

#
# Table structure for table `search_index`
#

CREATE TABLE `search_index` (
  `word_id` bigint(20) NOT NULL default '0',
  `ticket_id` bigint(20) NOT NULL default '0',
  `in_subject` tinyint(4) NOT NULL default '0',
  UNIQUE KEY `word_id` (`word_id`,`ticket_id`),
  KEY `in_subject` (`in_subject`)
) TYPE=MyISAM;

#
# Dumping data for table `search_index`
#

# --------------------------------------------------------

#
# Table structure for table `search_index_kb`
#

CREATE TABLE `search_index_kb` (
  `word_id` bigint(20) NOT NULL default '0',
  `kb_article_id` bigint(20) NOT NULL default '0',
  `in_topic` tinyint(4) NOT NULL default '0',
  UNIQUE KEY `word_id` (`word_id`,`kb_article_id`),
  KEY `in_topic` (`in_topic`)
) TYPE=MyISAM;

#
# Dumping data for table `search_index_kb`
#

# --------------------------------------------------------

#
# Table structure for table `search_words`
#

CREATE TABLE `search_words` (
  `word_id` bigint(20) NOT NULL auto_increment,
  `word` char(45) NOT NULL default '',
  PRIMARY KEY  (`word_id`),
  UNIQUE KEY `word` (`word`)
) TYPE=MyISAM;

#
# Dumping data for table `search_words`
#

# --------------------------------------------------------

#
# Table structure for table `session`
#

CREATE TABLE `session` (
  `s_id` bigint(20) unsigned NOT NULL auto_increment,
  `session_id` char(32) NOT NULL default '',
  `session_ip` char(16) NOT NULL default '',
  `session_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`s_id`),
  UNIQUE KEY `session_id` (`session_id`)
) TYPE=MyISAM;

#
# Dumping data for table `session`
#

# --------------------------------------------------------

#
# Table structure for table `session_vars`
#

CREATE TABLE `session_vars` (
  `s_id` bigint(20) unsigned NOT NULL default '0',
  `var_name` varchar(64) NOT NULL default '',
  `var_val` text NOT NULL,
  KEY `s_id` (`s_id`),
  KEY `var_name` (`var_name`)
) TYPE=MyISAM;

#
# Dumping data for table `session_vars`
#

# --------------------------------------------------------

#
# Table structure for table `sla`
#

CREATE TABLE `sla` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` char(64) NOT NULL default '',
  `queues` char(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `sla`
#

# --------------------------------------------------------

#
# Table structure for table `thread`
#

CREATE TABLE `thread` (
  `ticket_id` int(11) NOT NULL default '0',
  `thread_id` int(10) unsigned NOT NULL auto_increment,
  `thread_message_id` char(255) NOT NULL default '',
  `thread_inreplyto_id` int(11) NOT NULL default '0',
  `thread_address_id` int(11) NOT NULL default '0',
  `thread_type` enum('email','comment') NOT NULL default 'email',
  `thread_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `thread_time_worked` smallint(6) NOT NULL default '0',
  `thread_bytes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`thread_id`),
  KEY `ticket_sender_id` (`thread_address_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `thread_id` (`thread_id`),
  KEY `thread_address_id` (`thread_address_id`),
  KEY `thread_inreplyto_id` (`thread_inreplyto_id`)
) TYPE=MyISAM;

#
# Dumping data for table `thread`
#

# --------------------------------------------------------

#
# Table structure for table `thread_content`
#

CREATE TABLE `thread_content` (
  `thread_id` int(11) NOT NULL default '0',
  `content_id` int(10) unsigned NOT NULL auto_increment,
  `content_content` text NOT NULL,
  PRIMARY KEY  (`content_id`),
  KEY `thread_id` (`thread_id`)
) TYPE=MyISAM;

#
# Dumping data for table `thread_content`
#

# --------------------------------------------------------

#
# Table structure for table `thread_file`
#

CREATE TABLE `thread_file` (
  `thread_id` bigint(20) NOT NULL default '0',
  `file_id` bigint(20) unsigned NOT NULL auto_increment,
  `file_name` varchar(255) NOT NULL default '""',
  `file_size` int(11) NOT NULL default '0',
  `file_content` mediumblob NOT NULL,
  PRIMARY KEY  (`file_id`),
  KEY `thread_id` (`thread_id`)
) TYPE=MyISAM;

#
# Dumping data for table `thread_file`
#

# --------------------------------------------------------

#
# Table structure for table `ticket`
#

CREATE TABLE `ticket` (
  `ticket_id` bigint(20) unsigned NOT NULL auto_increment,
  `ticket_subject` char(128) NOT NULL default '',
  `ticket_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ticket_priority` tinyint(4) NOT NULL default '0',
  `ticket_status` enum('new','responded','in progress','info needed','acceptance','on hold','escalated','fixed','resolved','reopened','dead') NOT NULL default 'new',
  `last_update_date` timestamp(14) NOT NULL,
  `last_update_user_id` int(10) unsigned NOT NULL default '0',
  `ticket_assigned_to_id` int(10) unsigned NOT NULL default '0',
  `ticket_queue_id` int(10) unsigned NOT NULL default '0',
  `queue_addresses_id` int(11) NOT NULL default '0',
  `ticket_reopenings` smallint(6) NOT NULL default '0',
  `min_thread_id` bigint(21) default NULL,
  `max_thread_id` bigint(21) default NULL,
  PRIMARY KEY  (`ticket_id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `ticket_queue_id` (`ticket_queue_id`),
  KEY `min_thread_id` (`min_thread_id`),
  KEY `max_thread_id` (`max_thread_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

#
# Dumping data for table `ticket`
#

# --------------------------------------------------------

#
# Table structure for table `ticket_audit_log`
#

CREATE TABLE `ticket_audit_log` (
  `audit_id` bigint(20) NOT NULL auto_increment,
  `ticket_id` bigint(20) NOT NULL default '0',
  `epoch` bigint(20) NOT NULL default '0',
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_id` bigint(20) NOT NULL default '0',
  `action` int(11) NOT NULL default '0',
  `action_value` char(128) NOT NULL default '',
  PRIMARY KEY  (`audit_id`)
) TYPE=MyISAM;

#
# Dumping data for table `ticket_audit_log`
#

# --------------------------------------------------------

#
# Table structure for table `ticket_fields`
#

CREATE TABLE `ticket_fields` (
  `field_id` bigint(20) NOT NULL auto_increment,
  `field_name` varchar(64) NOT NULL default '',
  `field_type` enum('S','T','D') NOT NULL default 'S',
  `field_options` text NOT NULL,
  PRIMARY KEY  (`field_id`)
) TYPE=MyISAM;

#
# Dumping data for table `ticket_fields`
#

# --------------------------------------------------------

#
# Table structure for table `ticket_old`
#

CREATE TABLE `ticket_old` (
  `ticket_id` int(10) unsigned NOT NULL auto_increment,
  `ticket_subject` char(128) NOT NULL default '',
  `ticket_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ticket_priority` tinyint(4) NOT NULL default '0',
  `ticket_status` enum('new','responded','in progress','info needed','acceptance','on hold','escalated','fixed','resolved','reopened','dead') NOT NULL default 'new',
  `last_update_date` timestamp(14) NOT NULL,
  `last_update_user_id` int(10) unsigned NOT NULL default '0',
  `ticket_assigned_to_id` int(10) unsigned NOT NULL default '0',
  `ticket_queue_id` int(10) unsigned NOT NULL default '0',
  `queue_addresses_id` int(11) NOT NULL default '0',
  `ticket_reopenings` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`ticket_id`),
  FULLTEXT KEY `ticket_subject` (`ticket_subject`)
) TYPE=MyISAM;

#
# Dumping data for table `ticket_old`
#

# --------------------------------------------------------

#
# Table structure for table `ticket_values`
#

CREATE TABLE `ticket_values` (
  `value_id` bigint(20) NOT NULL auto_increment,
  `field_id` bigint(20) NOT NULL default '0',
  `ticket_id` bigint(20) NOT NULL default '0',
  `value_text` text NOT NULL,
  PRIMARY KEY  (`value_id`)
) TYPE=MyISAM;

#
# Dumping data for table `ticket_values`
#

# --------------------------------------------------------

#
# Table structure for table `ticket_views`
#

CREATE TABLE `ticket_views` (
  `view_id` bigint(20) unsigned NOT NULL auto_increment,
  `view_name` char(64) NOT NULL default '',
  `view_created_by_id` bigint(20) NOT NULL default '0',
  `view_private` tinyint(4) NOT NULL default '0',
  `view_queues` char(255) NOT NULL default '',
  `view_columns` char(255) NOT NULL default '',
  `view_hide_statuses` char(255) NOT NULL default '',
  PRIMARY KEY  (`view_id`),
  KEY `view_id` (`view_id`)
) TYPE=MyISAM;

#
# Dumping data for table `ticket_views`
#

# --------------------------------------------------------

#
# Table structure for table `user`
#

CREATE TABLE `user` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `user_name` char(64) NOT NULL default '',
  `user_email` char(128) NOT NULL default '',
  `user_email_verify` char(16) NOT NULL default '',
  `user_icq` char(16) NOT NULL default '',
  `user_login` char(32) NOT NULL default '',
  `user_password` char(16) NOT NULL default '',
  `user_group_id` int(10) unsigned NOT NULL default '0',
  `user_last_login` timestamp(14) NOT NULL,
  `user_superuser` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_login` (`user_login`)
) TYPE=MyISAM;

#
# Dumping data for table `user`
#

INSERT INTO `user` VALUES (1, 'Super User', 'superuser@localhost', '', '', 'superuser', 'upfoCpqap/nUc', 0, 20030324220654, 1);
# --------------------------------------------------------

#
# Table structure for table `user_access_levels`
#

CREATE TABLE `user_access_levels` (
  `group_id` int(10) unsigned NOT NULL auto_increment,
  `group_name` char(40) NOT NULL default '0',
  `is_core_default` tinyint(4) NOT NULL default '0',
  `group_acl` char(20) NOT NULL default '0',
  `group_acl2` char(20) NOT NULL default '0',
  `group_acl3` char(20) NOT NULL default '0',
  PRIMARY KEY  (`group_id`)
) TYPE=MyISAM;

#
# Dumping data for table `user_access_levels`
#

# --------------------------------------------------------

#
# Table structure for table `user_prefs`
#

CREATE TABLE `user_prefs` (
  `user_id` int(11) default NULL,
  `assigned_filter` tinyint(4) default NULL,
  `assigned_results` tinyint(4) default NULL,
  `unassigned_filter` tinyint(4) default NULL,
  `unassigned_results` tinyint(4) default NULL,
  `refresh_rate` tinyint(4) default NULL,
  `ticket_order` tinyint(4) default NULL,
  `user_language` char(3) NOT NULL default 'en',
  `signature_pos` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table `user_prefs`
#

# --------------------------------------------------------

#
# Table structure for table `user_sig`
#

CREATE TABLE `user_sig` (
  `sig_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `sig_content` text NOT NULL,
  PRIMARY KEY  (`sig_id`)
) TYPE=MyISAM;

#
# Dumping data for table `user_sig`
#

# --------------------------------------------------------

#
# Table structure for table `whos_online`
#

CREATE TABLE `whos_online` (
  `user_id` bigint(20) unsigned NOT NULL auto_increment,
  `user_ip` char(20) NOT NULL default '',
  `user_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_what_action` int(11) NOT NULL default '0',
  `user_what_arg1` char(64) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;

#------------------[ 1.5.1rc1 SQL Update ]------------------------------
ALTER TABLE `configuration` DROP `cerberus_gui_path` ;
ALTER TABLE `configuration` DROP `http_server` ;
ALTER TABLE `user` ADD `user_disabled` TINYINT DEFAULT '0' NOT NULL ;
ALTER TABLE `queue_addresses` ADD UNIQUE `address_unique` ( `queue_address` , `queue_domain` );

#------------------[ 1.5.1rc2 SQL Update ]------------------------------
DROP TABLE IF EXISTS thread_source;
ALTER TABLE `requestor` ADD `suppress` TINYINT DEFAULT '0' NOT NULL ;
ALTER TABLE `configuration` DROP `mail_delay`;
ALTER TABLE `requestor` DROP `requestor_id`;
ALTER  TABLE  `requestor`  ADD  UNIQUE `ticket_and_address` (  `ticket_id` ,  `address_id`  );
CREATE TABLE `thread_errors` (
 `error_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `ticket_id` BIGINT UNSIGNED NOT NULL ,
 `thread_id` BIGINT UNSIGNED NOT NULL ,
 `error_msg` TEXT NOT NULL ,
 PRIMARY KEY ( `error_id` ), 
 INDEX (`ticket_id`),
 INDEX (`thread_id`)
);

DROP TABLE IF EXISTS ticket_old;

CREATE TABLE `war_check` (
 `warcheck_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `address_id` BIGINT UNSIGNED NOT NULL ,
 `subject_md5` CHAR( 32 ) NOT NULL ,
 `queue_id` BIGINT UNSIGNED NOT NULL ,
 `timestamp` DATETIME NOT NULL ,
 PRIMARY KEY (`warcheck_id`),
 INDEX(`address_id`),
 INDEX(`queue_id`),
 INDEX(`subject_md5`)
);

CREATE TABLE `thread_attachments` (
 `thread_id` BIGINT UNSIGNED NOT NULL ,
 `file_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `file_name` CHAR( 255 ) NOT NULL ,
 `file_size` BIGINT( 11 ) NOT NULL ,
 PRIMARY KEY ( `file_id` ) 
);

ALTER TABLE `thread_attachments` ADD INDEX ( `thread_id` );

CREATE TABLE `thread_attachments_parts` (
 `part_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `file_id` BIGINT UNSIGNED NOT NULL ,
 `part_content` MEDIUMBLOB NOT NULL ,
 PRIMARY KEY ( `part_id` ) ,
 INDEX ( `file_id` ) 
);

ALTER TABLE `product_key_info` DROP `key_name` ;
ALTER TABLE `product_key_info` DROP `key_email` ;
ALTER TABLE `product_key_info` DROP `key_issue` ;
ALTER TABLE `product_key_info` ADD `key_type` TINYINT NOT NULL ;
ALTER TABLE `product_key_info` ADD `key_expiration` DATETIME NOT NULL ;

ALTER TABLE `configuration` ADD `warcheck_secs` INT DEFAULT '10' NOT NULL AFTER `track_sid_url` ;
ALTER TABLE `configuration` ADD `ob_callback` CHAR( 64 ) NOT NULL AFTER `master_db_user` ;

#---------------[ 2.0.0 beta rc0 ]-----------------------------------
ALTER TABLE `configuration` DROP `list_tickets_per_page` ;
ALTER TABLE `user_prefs` DROP `assigned_filter`;
ALTER TABLE `user_prefs` DROP `unassigned_filter`;
ALTER TABLE `user_prefs` DROP `assigned_results`;
ALTER TABLE `user_prefs` DROP `unassigned_results` ;
ALTER TABLE `ticket_views` CHANGE `view_columns` `view_columns` TEXT NOT NULL;
ALTER TABLE `ticket_views` ADD `view_only_assigned` TINYINT( 0 ) NOT NULL ;

#---------------[ 2.0.0 release ]-----------------------------------
CREATE TABLE `merge_forward` (
	`from_ticket` BIGINT UNSIGNED NOT NULL,
	`to_ticket` BIGINT UNSIGNED NOT NULL,
	UNIQUE `merge_pair` (`from_ticket`,`to_ticket`)
);
CREATE TABLE `search_index_exclude` (
 `exclude_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `exclude_word` CHAR( 25 ) NOT NULL ,
 PRIMARY KEY ( `exclude_id` ) ,
 UNIQUE (
 `exclude_word` 
)
);
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('to'),('is'),('if'),('of'),('or'),('it'),('in'),('do'),('no'),('on'),('id'),('by'),('be'),('us');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('the'),('you'),('for'),('any'),('not'),('and'),('llc'),('inc'),('key'),('has'),('let'),('new'),('can'),('was'),('are'),('get');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('this'),('have'),('name'),('from'),('that'),('your'),('been'),('know'),('need'),('with'),('mail'),('will');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('email'),('please'),('company'),('questions'),('message'),('reply'),('domain'),('thanks'),('contact'),('information'),('address'),('internet'),('phone'),('number'),('support');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('there'),('might'),('but'),('means'),('our'),('upon'),('all'),('when'),('while'),('among'),('thank'),('now'),('would'),('could'),('like'),('just'),('may'),('use'),('again');