D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
var
/
softaculous
/
mantis
/
Filename :
mantis.sql
back
Copy
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `mantis2270` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]api_token_mantis` -- CREATE TABLE `[[dbprefix]]api_token_mantis` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(128) NOT NULL, `hash` varchar(128) NOT NULL, `date_created` int(10) unsigned NOT NULL DEFAULT '1', `date_used` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_user_id_name` (`user_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bugnote_mantis` -- CREATE TABLE `[[dbprefix]]bugnote_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bugnote_text_mantis` -- CREATE TABLE `[[dbprefix]]bugnote_text_mantis` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `note` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_file_mantis` -- CREATE TABLE `[[dbprefix]]bug_file_mantis` ( `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, `date_added` int(10) unsigned NOT NULL DEFAULT '1', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `bugnote_id` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_bug_file_bug_id` (`bug_id`), KEY `idx_diskfile` (`diskfile`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_history_mantis` -- CREATE TABLE `[[dbprefix]]bug_history_mantis` ( `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`), KEY `idx_bug_history_date_modified` (`date_modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_mantis` -- CREATE TABLE `[[dbprefix]]bug_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_monitor_mantis` -- CREATE TABLE `[[dbprefix]]bug_monitor_mantis` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0', `bug_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`bug_id`), KEY `idx_bug_id` (`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_relationship_mantis` -- CREATE TABLE `[[dbprefix]]bug_relationship_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_revision_mantis` -- CREATE TABLE `[[dbprefix]]bug_revision_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_tag_mantis` -- CREATE TABLE `[[dbprefix]]bug_tag_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bug_text_mantis` -- CREATE TABLE `[[dbprefix]]bug_text_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]category_mantis` -- CREATE TABLE `[[dbprefix]]category_mantis` ( `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 '1', PRIMARY KEY (`id`), UNIQUE KEY `idx_category_project_name` (`project_id`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]category_mantis` -- INSERT INTO `[[dbprefix]]category_mantis` VALUES (1, 0, 0, 'General', 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]config_mantis` -- CREATE TABLE `[[dbprefix]]config_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]config_mantis` -- INSERT INTO `[[dbprefix]]config_mantis` VALUES ('database_version', 0, 0, 90, 1, '213'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]custom_field_mantis` -- CREATE TABLE `[[dbprefix]]custom_field_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]custom_field_project_mantis` -- CREATE TABLE `[[dbprefix]]custom_field_project_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]custom_field_string_mantis` -- CREATE TABLE `[[dbprefix]]custom_field_string_mantis` ( `field_id` int(11) NOT NULL DEFAULT '0', `bug_id` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', `text` longtext, PRIMARY KEY (`field_id`,`bug_id`), KEY `idx_custom_field_bug` (`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]email_mantis` -- CREATE TABLE `[[dbprefix]]email_mantis` ( `email_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) 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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]filters_mantis` -- CREATE TABLE `[[dbprefix]]filters_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]news_mantis` -- CREATE TABLE `[[dbprefix]]news_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]plugin_mantis` -- CREATE TABLE `[[dbprefix]]plugin_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]plugin_mantis` -- INSERT INTO `[[dbprefix]]plugin_mantis` VALUES ('MantisCoreFormatting', 1, 0, 3); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]project_file_mantis` -- CREATE TABLE `[[dbprefix]]project_file_mantis` ( `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, `date_added` int(10) unsigned NOT NULL DEFAULT '1', `user_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]project_hierarchy_mantis` -- CREATE TABLE `[[dbprefix]]project_hierarchy_mantis` ( `child_id` int(10) unsigned NOT NULL, `parent_id` int(10) unsigned NOT NULL, `inherit_parent` tinyint(4) NOT NULL DEFAULT '0', UNIQUE KEY `idx_project_hierarchy` (`child_id`,`parent_id`), KEY `idx_project_hierarchy_child_id` (`child_id`), KEY `idx_project_hierarchy_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]project_mantis` -- CREATE TABLE `[[dbprefix]]project_mantis` ( `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` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_project_name` (`name`), KEY `idx_project_view` (`view_state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]project_user_list_mantis` -- CREATE TABLE `[[dbprefix]]project_user_list_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]project_version_mantis` -- CREATE TABLE `[[dbprefix]]project_version_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sponsorship_mantis` -- CREATE TABLE `[[dbprefix]]sponsorship_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tag_mantis` -- CREATE TABLE `[[dbprefix]]tag_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tokens_mantis` -- CREATE TABLE `[[dbprefix]]tokens_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_mantis` -- CREATE TABLE `[[dbprefix]]user_mantis` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(191) NOT NULL DEFAULT '', `realname` varchar(191) NOT NULL DEFAULT '', `email` varchar(191) NOT NULL DEFAULT '', `password` varchar(64) 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`), KEY `idx_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user_mantis` -- INSERT INTO `[[dbprefix]]user_mantis` VALUES (1, 'administrator', '[[admin_realname]]', '[[admin_email]]', '[[admin_pass]]', 1, 0, 90, 3, 0, 0, '[[cookie_string]]', [[timestamp]], [[timestamp]]); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_pref_mantis` -- CREATE TABLE `[[dbprefix]]user_pref_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_print_pref_mantis` -- CREATE TABLE `[[dbprefix]]user_print_pref_mantis` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0', `print_pref` varchar(64) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_profile_mantis` -- CREATE TABLE `[[dbprefix]]user_profile_mantis` ( `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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; /*!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 */;