CREATE TABLE `search_words` (
`word_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`word` CHAR(45) NOT NULL,
UNIQUE (`word`)
);

CREATE TABLE `search_index` (
`word_id` BIGINT NOT NULL, 
`ticket_id` BIGINT NOT NULL,
UNIQUE (`word_id`, `ticket_id`)
);

ALTER TABLE `search_index` ADD `in_subject` TINYINT NOT NULL;
ALTER TABLE `search_index` ADD INDEX (`in_subject`);

ALTER TABLE `thread_content` DROP INDEX `content_content`;
ALTER TABLE `ticket` DROP INDEX `ticket_subject`;

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

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;

ALTER TABLE `knowledgebase` DROP INDEX `kb_keywords`;
ALTER TABLE `knowledgebase_problem` DROP INDEX `kb_problem_summary`;
ALTER TABLE `knowledgebase_problem` DROP INDEX `kb_problem_text`;
ALTER TABLE `knowledgebase_solution` DROP INDEX `kb_solution_text`;

ALTER TABLE `configuration` ADD `session_lifespan` INT( 4 ) NOT NULL default '720'  AFTER `sendmail` ;

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;

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;

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;

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,
  PRIMARY KEY  (kb_comment_id),
  KEY kb_article_id (kb_article_id),
  KEY kb_comment_approved (kb_comment_approved)
) TYPE=MyISAM;

ALTER TABLE `configuration` ADD `kb_editors_enabled` TINYINT DEFAULT '0' NOT NULL AFTER `http_server` ;
ALTER TABLE `knowledgebase_comments` ADD `poster_ip` VARCHAR( 16 ) DEFAULT '0.0.0.0' NOT NULL ;

ALTER TABLE `queue_access` ADD INDEX(`queue_id`);
ALTER TABLE `queue_access` ADD INDEX(`user_id`);
ALTER TABLE `thread_content` ADD INDEX(`thread_id`);
ALTER TABLE `thread_content` DROP INDEX `ticket_id`;