-- MySQL dump 10.13 Distrib 5.1.69, for redhat-linux-gnu (x86_64) -- -- Host: localhost Database: mld_bug -- ------------------------------------------------------ -- Server version 5.1.69 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `mantis_bug_file_table` -- DROP TABLE IF EXISTS `mantis_bug_file_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_file_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `bug_id` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(250) NOT NULL DEFAULT '', `description` varchar(250) NOT NULL DEFAULT '', `diskfile` varchar(250) NOT NULL DEFAULT '', `filename` varchar(250) NOT NULL DEFAULT '', `folder` varchar(250) NOT NULL DEFAULT '', `filesize` int(11) NOT NULL DEFAULT '0', `file_type` varchar(250) NOT NULL DEFAULT '', `content` longblob NOT NULL, `date_added` int(10) unsigned NOT NULL DEFAULT '1', `user_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_bug_file_bug_id` (`bug_id`), KEY `idx_diskfile` (`diskfile`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_file_table` -- LOCK TABLES `mantis_bug_file_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_file_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_file_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_history_table` -- DROP TABLE IF EXISTS `mantis_bug_history_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_history_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `bug_id` int(10) unsigned NOT NULL DEFAULT '0', `field_name` varchar(64) NOT NULL, `old_value` varchar(255) NOT NULL, `new_value` varchar(255) NOT NULL, `type` smallint(6) NOT NULL DEFAULT '0', `date_modified` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_bug_history_bug_id` (`bug_id`), KEY `idx_history_user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_history_table` -- LOCK TABLES `mantis_bug_history_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_history_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_history_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_monitor_table` -- DROP TABLE IF EXISTS `mantis_bug_monitor_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_monitor_table` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0', `bug_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_monitor_table` -- LOCK TABLES `mantis_bug_monitor_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_monitor_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_monitor_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_relationship_table` -- DROP TABLE IF EXISTS `mantis_bug_relationship_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_relationship_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `source_bug_id` int(10) unsigned NOT NULL DEFAULT '0', `destination_bug_id` int(10) unsigned NOT NULL DEFAULT '0', `relationship_type` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_relationship_source` (`source_bug_id`), KEY `idx_relationship_destination` (`destination_bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_relationship_table` -- LOCK TABLES `mantis_bug_relationship_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_relationship_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_relationship_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_revision_table` -- DROP TABLE IF EXISTS `mantis_bug_revision_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_revision_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `bug_id` int(10) unsigned NOT NULL, `bugnote_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL, `type` int(10) unsigned NOT NULL, `value` longtext NOT NULL, `timestamp` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_bug_rev_type` (`type`), KEY `idx_bug_rev_id_time` (`bug_id`,`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_revision_table` -- LOCK TABLES `mantis_bug_revision_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_revision_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_revision_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_table` -- DROP TABLE IF EXISTS `mantis_bug_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `project_id` int(10) unsigned NOT NULL DEFAULT '0', `reporter_id` int(10) unsigned NOT NULL DEFAULT '0', `handler_id` int(10) unsigned NOT NULL DEFAULT '0', `duplicate_id` int(10) unsigned NOT NULL DEFAULT '0', `priority` smallint(6) NOT NULL DEFAULT '30', `severity` smallint(6) NOT NULL DEFAULT '50', `reproducibility` smallint(6) NOT NULL DEFAULT '10', `status` smallint(6) NOT NULL DEFAULT '10', `resolution` smallint(6) NOT NULL DEFAULT '10', `projection` smallint(6) NOT NULL DEFAULT '10', `eta` smallint(6) NOT NULL DEFAULT '10', `bug_text_id` int(10) unsigned NOT NULL DEFAULT '0', `os` varchar(32) NOT NULL DEFAULT '', `os_build` varchar(32) NOT NULL DEFAULT '', `platform` varchar(32) NOT NULL DEFAULT '', `version` varchar(64) NOT NULL DEFAULT '', `fixed_in_version` varchar(64) NOT NULL DEFAULT '', `build` varchar(32) NOT NULL DEFAULT '', `profile_id` int(10) unsigned NOT NULL DEFAULT '0', `view_state` smallint(6) NOT NULL DEFAULT '10', `summary` varchar(128) NOT NULL DEFAULT '', `sponsorship_total` int(11) NOT NULL DEFAULT '0', `sticky` tinyint(4) NOT NULL DEFAULT '0', `target_version` varchar(64) NOT NULL DEFAULT '', `category_id` int(10) unsigned NOT NULL DEFAULT '1', `date_submitted` int(10) unsigned NOT NULL DEFAULT '1', `due_date` int(10) unsigned NOT NULL DEFAULT '1', `last_updated` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_bug_sponsorship_total` (`sponsorship_total`), KEY `idx_bug_fixed_in_version` (`fixed_in_version`), KEY `idx_bug_status` (`status`), KEY `idx_project` (`project_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_table` -- LOCK TABLES `mantis_bug_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_tag_table` -- DROP TABLE IF EXISTS `mantis_bug_tag_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_tag_table` ( `bug_id` int(10) unsigned NOT NULL DEFAULT '0', `tag_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `date_attached` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`bug_id`,`tag_id`), KEY `idx_bug_tag_tag_id` (`tag_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_tag_table` -- LOCK TABLES `mantis_bug_tag_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_tag_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_tag_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bug_text_table` -- DROP TABLE IF EXISTS `mantis_bug_text_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bug_text_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `description` longtext NOT NULL, `steps_to_reproduce` longtext NOT NULL, `additional_information` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bug_text_table` -- LOCK TABLES `mantis_bug_text_table` WRITE; /*!40000 ALTER TABLE `mantis_bug_text_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bug_text_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bugnote_table` -- DROP TABLE IF EXISTS `mantis_bugnote_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bugnote_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `bug_id` int(10) unsigned NOT NULL DEFAULT '0', `reporter_id` int(10) unsigned NOT NULL DEFAULT '0', `bugnote_text_id` int(10) unsigned NOT NULL DEFAULT '0', `view_state` smallint(6) NOT NULL DEFAULT '10', `note_type` int(11) DEFAULT '0', `note_attr` varchar(250) DEFAULT '', `time_tracking` int(10) unsigned NOT NULL DEFAULT '0', `last_modified` int(10) unsigned NOT NULL DEFAULT '1', `date_submitted` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_bug` (`bug_id`), KEY `idx_last_mod` (`last_modified`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bugnote_table` -- LOCK TABLES `mantis_bugnote_table` WRITE; /*!40000 ALTER TABLE `mantis_bugnote_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bugnote_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_bugnote_text_table` -- DROP TABLE IF EXISTS `mantis_bugnote_text_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_bugnote_text_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `note` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_bugnote_text_table` -- LOCK TABLES `mantis_bugnote_text_table` WRITE; /*!40000 ALTER TABLE `mantis_bugnote_text_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_bugnote_text_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_category_table` -- DROP TABLE IF EXISTS `mantis_category_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_category_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `project_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', `status` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_category_project_name` (`project_id`,`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_category_table` -- LOCK TABLES `mantis_category_table` WRITE; /*!40000 ALTER TABLE `mantis_category_table` DISABLE KEYS */; INSERT INTO `mantis_category_table` VALUES (1,0,0,'General',0); /*!40000 ALTER TABLE `mantis_category_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_config_table` -- DROP TABLE IF EXISTS `mantis_config_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_config_table` ( `config_id` varchar(64) NOT NULL, `project_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `access_reqd` int(11) DEFAULT '0', `type` int(11) DEFAULT '90', `value` longtext NOT NULL, PRIMARY KEY (`config_id`,`project_id`,`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_config_table` -- LOCK TABLES `mantis_config_table` WRITE; /*!40000 ALTER TABLE `mantis_config_table` DISABLE KEYS */; INSERT INTO `mantis_config_table` VALUES ('database_version',0,0,90,1,'183'); /*!40000 ALTER TABLE `mantis_config_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_custom_field_project_table` -- DROP TABLE IF EXISTS `mantis_custom_field_project_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_custom_field_project_table` ( `field_id` int(11) NOT NULL DEFAULT '0', `project_id` int(10) unsigned NOT NULL DEFAULT '0', `sequence` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`field_id`,`project_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_custom_field_project_table` -- LOCK TABLES `mantis_custom_field_project_table` WRITE; /*!40000 ALTER TABLE `mantis_custom_field_project_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_custom_field_project_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_custom_field_string_table` -- DROP TABLE IF EXISTS `mantis_custom_field_string_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_custom_field_string_table` ( `field_id` int(11) NOT NULL DEFAULT '0', `bug_id` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`field_id`,`bug_id`), KEY `idx_custom_field_bug` (`bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_custom_field_string_table` -- LOCK TABLES `mantis_custom_field_string_table` WRITE; /*!40000 ALTER TABLE `mantis_custom_field_string_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_custom_field_string_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_custom_field_table` -- DROP TABLE IF EXISTS `mantis_custom_field_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_custom_field_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL DEFAULT '', `type` smallint(6) NOT NULL DEFAULT '0', `possible_values` text NOT NULL, `default_value` varchar(255) NOT NULL DEFAULT '', `valid_regexp` varchar(255) NOT NULL DEFAULT '', `access_level_r` smallint(6) NOT NULL DEFAULT '0', `access_level_rw` smallint(6) NOT NULL DEFAULT '0', `length_min` int(11) NOT NULL DEFAULT '0', `length_max` int(11) NOT NULL DEFAULT '0', `require_report` tinyint(4) NOT NULL DEFAULT '0', `require_update` tinyint(4) NOT NULL DEFAULT '0', `display_report` tinyint(4) NOT NULL DEFAULT '0', `display_update` tinyint(4) NOT NULL DEFAULT '1', `require_resolved` tinyint(4) NOT NULL DEFAULT '0', `display_resolved` tinyint(4) NOT NULL DEFAULT '0', `display_closed` tinyint(4) NOT NULL DEFAULT '0', `require_closed` tinyint(4) NOT NULL DEFAULT '0', `filter_by` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_custom_field_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_custom_field_table` -- LOCK TABLES `mantis_custom_field_table` WRITE; /*!40000 ALTER TABLE `mantis_custom_field_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_custom_field_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_email_table` -- DROP TABLE IF EXISTS `mantis_email_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_email_table` ( `email_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(64) NOT NULL DEFAULT '', `subject` varchar(250) NOT NULL DEFAULT '', `metadata` longtext NOT NULL, `body` longtext NOT NULL, `submitted` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`email_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_email_table` -- LOCK TABLES `mantis_email_table` WRITE; /*!40000 ALTER TABLE `mantis_email_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_email_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_filters_table` -- DROP TABLE IF EXISTS `mantis_filters_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_filters_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0', `is_public` tinyint(4) DEFAULT NULL, `name` varchar(64) NOT NULL DEFAULT '', `filter_string` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_filters_table` -- LOCK TABLES `mantis_filters_table` WRITE; /*!40000 ALTER TABLE `mantis_filters_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_filters_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_news_table` -- DROP TABLE IF EXISTS `mantis_news_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_news_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `project_id` int(10) unsigned NOT NULL DEFAULT '0', `poster_id` int(10) unsigned NOT NULL DEFAULT '0', `view_state` smallint(6) NOT NULL DEFAULT '10', `announcement` tinyint(4) NOT NULL DEFAULT '0', `headline` varchar(64) NOT NULL DEFAULT '', `body` longtext NOT NULL, `last_modified` int(10) unsigned NOT NULL DEFAULT '1', `date_posted` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_news_table` -- LOCK TABLES `mantis_news_table` WRITE; /*!40000 ALTER TABLE `mantis_news_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_news_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_plugin_table` -- DROP TABLE IF EXISTS `mantis_plugin_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_plugin_table` ( `basename` varchar(40) NOT NULL, `enabled` tinyint(4) NOT NULL DEFAULT '0', `protected` tinyint(4) NOT NULL DEFAULT '0', `priority` int(10) unsigned NOT NULL DEFAULT '3', PRIMARY KEY (`basename`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_plugin_table` -- LOCK TABLES `mantis_plugin_table` WRITE; /*!40000 ALTER TABLE `mantis_plugin_table` DISABLE KEYS */; INSERT INTO `mantis_plugin_table` VALUES ('MantisCoreFormatting',1,0,3); /*!40000 ALTER TABLE `mantis_plugin_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_project_file_table` -- DROP TABLE IF EXISTS `mantis_project_file_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_project_file_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `project_id` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(250) NOT NULL DEFAULT '', `description` varchar(250) NOT NULL DEFAULT '', `diskfile` varchar(250) NOT NULL DEFAULT '', `filename` varchar(250) NOT NULL DEFAULT '', `folder` varchar(250) NOT NULL DEFAULT '', `filesize` int(11) NOT NULL DEFAULT '0', `file_type` varchar(250) NOT NULL DEFAULT '', `content` longblob NOT NULL, `date_added` int(10) unsigned NOT NULL DEFAULT '1', `user_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_project_file_table` -- LOCK TABLES `mantis_project_file_table` WRITE; /*!40000 ALTER TABLE `mantis_project_file_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_project_file_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_project_hierarchy_table` -- DROP TABLE IF EXISTS `mantis_project_hierarchy_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_project_hierarchy_table` ( `child_id` int(10) unsigned NOT NULL, `parent_id` int(10) unsigned NOT NULL, `inherit_parent` int(10) unsigned NOT NULL DEFAULT '0', KEY `idx_project_hierarchy_child_id` (`child_id`), KEY `idx_project_hierarchy_parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_project_hierarchy_table` -- LOCK TABLES `mantis_project_hierarchy_table` WRITE; /*!40000 ALTER TABLE `mantis_project_hierarchy_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_project_hierarchy_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_project_table` -- DROP TABLE IF EXISTS `mantis_project_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_project_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL DEFAULT '', `status` smallint(6) NOT NULL DEFAULT '10', `enabled` tinyint(4) NOT NULL DEFAULT '1', `view_state` smallint(6) NOT NULL DEFAULT '10', `access_min` smallint(6) NOT NULL DEFAULT '10', `file_path` varchar(250) NOT NULL DEFAULT '', `description` longtext NOT NULL, `category_id` int(10) unsigned NOT NULL DEFAULT '1', `inherit_global` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_project_name` (`name`), KEY `idx_project_view` (`view_state`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_project_table` -- LOCK TABLES `mantis_project_table` WRITE; /*!40000 ALTER TABLE `mantis_project_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_project_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_project_user_list_table` -- DROP TABLE IF EXISTS `mantis_project_user_list_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_project_user_list_table` ( `project_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `access_level` smallint(6) NOT NULL DEFAULT '10', PRIMARY KEY (`project_id`,`user_id`), KEY `idx_project_user` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_project_user_list_table` -- LOCK TABLES `mantis_project_user_list_table` WRITE; /*!40000 ALTER TABLE `mantis_project_user_list_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_project_user_list_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_project_version_table` -- DROP TABLE IF EXISTS `mantis_project_version_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_project_version_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(10) unsigned NOT NULL DEFAULT '0', `version` varchar(64) NOT NULL DEFAULT '', `description` longtext NOT NULL, `released` tinyint(4) NOT NULL DEFAULT '1', `obsolete` tinyint(4) NOT NULL DEFAULT '0', `date_order` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_project_version` (`project_id`,`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_project_version_table` -- LOCK TABLES `mantis_project_version_table` WRITE; /*!40000 ALTER TABLE `mantis_project_version_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_project_version_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_sponsorship_table` -- DROP TABLE IF EXISTS `mantis_sponsorship_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_sponsorship_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bug_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `amount` int(11) NOT NULL DEFAULT '0', `logo` varchar(128) NOT NULL DEFAULT '', `url` varchar(128) NOT NULL DEFAULT '', `paid` tinyint(4) NOT NULL DEFAULT '0', `date_submitted` int(10) unsigned NOT NULL DEFAULT '1', `last_updated` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_sponsorship_bug_id` (`bug_id`), KEY `idx_sponsorship_user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_sponsorship_table` -- LOCK TABLES `mantis_sponsorship_table` WRITE; /*!40000 ALTER TABLE `mantis_sponsorship_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_sponsorship_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_tag_table` -- DROP TABLE IF EXISTS `mantis_tag_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_tag_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', `description` longtext NOT NULL, `date_created` int(10) unsigned NOT NULL DEFAULT '1', `date_updated` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`,`name`), KEY `idx_tag_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_tag_table` -- LOCK TABLES `mantis_tag_table` WRITE; /*!40000 ALTER TABLE `mantis_tag_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_tag_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_tokens_table` -- DROP TABLE IF EXISTS `mantis_tokens_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_tokens_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `owner` int(11) NOT NULL, `type` int(11) NOT NULL, `value` longtext NOT NULL, `timestamp` int(10) unsigned NOT NULL DEFAULT '1', `expiry` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_typeowner` (`type`,`owner`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_tokens_table` -- LOCK TABLES `mantis_tokens_table` WRITE; /*!40000 ALTER TABLE `mantis_tokens_table` DISABLE KEYS */; INSERT INTO `mantis_tokens_table` VALUES (1,1,4,'1',1376128351,1376128651); /*!40000 ALTER TABLE `mantis_tokens_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_user_pref_table` -- DROP TABLE IF EXISTS `mantis_user_pref_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_user_pref_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `project_id` int(10) unsigned NOT NULL DEFAULT '0', `default_profile` int(10) unsigned NOT NULL DEFAULT '0', `default_project` int(10) unsigned NOT NULL DEFAULT '0', `refresh_delay` int(11) NOT NULL DEFAULT '0', `redirect_delay` int(11) NOT NULL DEFAULT '0', `bugnote_order` varchar(4) NOT NULL DEFAULT 'ASC', `email_on_new` tinyint(4) NOT NULL DEFAULT '0', `email_on_assigned` tinyint(4) NOT NULL DEFAULT '0', `email_on_feedback` tinyint(4) NOT NULL DEFAULT '0', `email_on_resolved` tinyint(4) NOT NULL DEFAULT '0', `email_on_closed` tinyint(4) NOT NULL DEFAULT '0', `email_on_reopened` tinyint(4) NOT NULL DEFAULT '0', `email_on_bugnote` tinyint(4) NOT NULL DEFAULT '0', `email_on_status` tinyint(4) NOT NULL DEFAULT '0', `email_on_priority` tinyint(4) NOT NULL DEFAULT '0', `email_on_priority_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_status_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_bugnote_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_reopened_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_closed_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_resolved_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_feedback_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_assigned_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_on_new_min_severity` smallint(6) NOT NULL DEFAULT '10', `email_bugnote_limit` smallint(6) NOT NULL DEFAULT '0', `language` varchar(32) NOT NULL DEFAULT 'english', `timezone` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_user_pref_table` -- LOCK TABLES `mantis_user_pref_table` WRITE; /*!40000 ALTER TABLE `mantis_user_pref_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_user_pref_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_user_print_pref_table` -- DROP TABLE IF EXISTS `mantis_user_print_pref_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_user_print_pref_table` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0', `print_pref` varchar(64) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_user_print_pref_table` -- LOCK TABLES `mantis_user_print_pref_table` WRITE; /*!40000 ALTER TABLE `mantis_user_print_pref_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_user_print_pref_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_user_profile_table` -- DROP TABLE IF EXISTS `mantis_user_profile_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_user_profile_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `platform` varchar(32) NOT NULL DEFAULT '', `os` varchar(32) NOT NULL DEFAULT '', `os_build` varchar(32) NOT NULL DEFAULT '', `description` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_user_profile_table` -- LOCK TABLES `mantis_user_profile_table` WRITE; /*!40000 ALTER TABLE `mantis_user_profile_table` DISABLE KEYS */; /*!40000 ALTER TABLE `mantis_user_profile_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mantis_user_table` -- DROP TABLE IF EXISTS `mantis_user_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mantis_user_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '', `realname` varchar(64) NOT NULL DEFAULT '', `email` varchar(64) NOT NULL DEFAULT '', `password` varchar(32) NOT NULL DEFAULT '', `enabled` tinyint(4) NOT NULL DEFAULT '1', `protected` tinyint(4) NOT NULL DEFAULT '0', `access_level` smallint(6) NOT NULL DEFAULT '10', `login_count` int(11) NOT NULL DEFAULT '0', `lost_password_request_count` smallint(6) NOT NULL DEFAULT '0', `failed_login_count` smallint(6) NOT NULL DEFAULT '0', `cookie_string` varchar(64) NOT NULL DEFAULT '', `last_visit` int(10) unsigned NOT NULL DEFAULT '1', `date_created` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_user_cookie_string` (`cookie_string`), UNIQUE KEY `idx_user_username` (`username`), KEY `idx_enable` (`enabled`), KEY `idx_access` (`access_level`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mantis_user_table` -- LOCK TABLES `mantis_user_table` WRITE; /*!40000 ALTER TABLE `mantis_user_table` DISABLE KEYS */; INSERT INTO `mantis_user_table` VALUES (1,'administrator','','root@localhost','63a9f0ea7bb98050796b649e85481845',1,0,90,4,0,0,'e85bf190633d7b3ec30b0c9bd32b78e688176cafde675c2a2b4b6519d956cd9a',1376128402,1376127759); /*!40000 ALTER TABLE `mantis_user_table` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2013-08-10 11:54:23