CREATE TABLE IF NOT EXISTS `mantis_plugin_query_schedule_table` (
  `schedule_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `schedule_desc` varchar(200) NOT NULL,
  `query_id` int(11) NOT NULL,
  `schedule_filter` longtext NOT NULL,
  `target` longtext NOT NULL,
  `frequency` char(1) NOT NULL,
  PRIMARY KEY (`schedule_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS mantis_plugin_query_definitions_table (
  query_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  query_name varchar(100) NOT NULL DEFAULT '',
  query_desc varchar(200) NOT NULL DEFAULT '',
  query_type varchar(1) NOT NULL DEFAULT '',
  query_script longtext NOT NULL,
  query_tables longtext NOT NULL,
  query_joins longtext NOT NULL,
  query_fields longtext NOT NULL,
  query_filter longtext NOT NULL,
  query_order longtext NOT NULL,
  query_group longtext NOT NULL,
  query_sql longtext NOT NULL,
  PRIMARY KEY (query_id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8  ;