Mantis安装（1）

    Mantis是一个开源的Bug管理系统；基于PHP+MySQL，可以运行在Windows/Unix 平台上。作为一个bug管理系统，其适用性是否符合实际工作的需要，这是至关重要的。在对Mantis 摸索几天后，发现它基本可以满足bug 管理日常流程。而且，Mantis 是B/S 结构的web系统，如果今后有需要，还可以配置到Internet 上，实现异地进行Bug管理。

    1、下载WampServer，它包含了PHP+MYSQL+Apache，下载好后直接点Next就可安装成功。

    2、在桌面右下角可以看到一个该软件的图标，点击鼠标左键就可进行切换在线/离线状态。

    3、本人是把Mantis放在该软件下的www目录中，直接在MYSQL里创建Mantis需要的数据库mantis和bugtracker，两个数据库的表在db_generate.sql文件中。

    4、WampServer的黩认端口号为80如与IIS下的端口号一致，则会导致冲突，则要把IIS下的端口号改掉。  

    5、在IE下输入 则可以看到Mantis的主界面。

 

   db_generate.sql内容:

 

# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Nov 06, 2004 at 09:52 PM
# Server version: 4.0.20
# PHP Version: 4.3.8
#
# Database : `mantis`
#

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

#
# Table structure for table `mantis_bug_file_table`
#

CREATE TABLE mantis_bug_file_table (
  id int(7) unsigned NOT NULL auto_increment,
  bug_id int(7) 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 '',
  date_added datetime NOT NULL default '1970-01-01 00:00:01',
  content longblob NOT NULL,
  PRIMARY KEY (id),
  KEY bug_id (bug_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bug_file_table`
#


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

#
# Table structure for table `mantis_bug_history_table`
#

CREATE TABLE mantis_bug_history_table (
  id int(7) unsigned NOT NULL auto_increment,
  user_id int(7) unsigned NOT NULL default '0',
  bug_id int(7) unsigned NOT NULL default '0',
  date_modified datetime NOT NULL default '1970-01-01 00:00:01',
  field_name varchar(32) NOT NULL default '',
  old_value varchar(128) NOT NULL default '',
  new_value varchar(128) NOT NULL default '',
  type int(2) NOT NULL default '0',
  PRIMARY KEY (id),
  KEY bug_id (bug_id),
  KEY user_id (user_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bug_history_table`
#


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

#
# Table structure for table `mantis_bug_monitor_table`
#

CREATE TABLE mantis_bug_monitor_table (
  user_id int(7) unsigned NOT NULL default '0',
  bug_id int(7) unsigned NOT NULL default '0',
  PRIMARY KEY (user_id,bug_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bug_monitor_table`
#


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

#
# Table structure for table `mantis_bug_relationship_table`
#

CREATE TABLE mantis_bug_relationship_table (
  id int(7) unsigned NOT NULL auto_increment,
  source_bug_id int(7) unsigned NOT NULL default '0',
  destination_bug_id int(7) unsigned NOT NULL default '0',
  relationship_type int(2) NOT NULL default '0',
  PRIMARY KEY (id),
  KEY source_bug_id (source_bug_id),
  KEY destination_bug_id (destination_bug_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bug_relationship_table`
#


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

#
# Table structure for table `mantis_bug_table`
#

CREATE TABLE mantis_bug_table (
  id int(7) unsigned NOT NULL auto_increment,
  project_id int(7) unsigned NOT NULL default '0',
  reporter_id int(7) unsigned NOT NULL default '0',
  handler_id int(7) unsigned NOT NULL default '0',
  duplicate_id int(7) unsigned NOT NULL default '0',
  priority int(2) NOT NULL default '30',
  severity int(2) NOT NULL default '50',
  reproducibility int(2) NOT NULL default '10',
  status int(2) NOT NULL default '10',
  resolution int(2) NOT NULL default '10',
  projection int(2) NOT NULL default '10',
  category varchar(64) NOT NULL default '',
  date_submitted datetime NOT NULL default '1970-01-01 00:00:01',
  last_updated datetime NOT NULL default '1970-01-01 00:00:01',
  eta int(2) NOT NULL default '10',
  bug_text_id int(7) 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(7) unsigned NOT NULL default '0',
  view_state int(2) NOT NULL default '10',
  summary varchar(128) NOT NULL default '',
  sponsorship_total int(7) NOT NULL default '0',
  PRIMARY KEY (id),
  KEY sponsorship_total (sponsorship_total),
  KEY fixed_in_version (fixed_in_version)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bug_table`
#


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

#
# Table structure for table `mantis_bug_text_table`
#

CREATE TABLE mantis_bug_text_table (
  id int(7) unsigned NOT NULL auto_increment,
  description text NOT NULL,
  steps_to_reproduce text NOT NULL,
  additional_information text NOT NULL,
  PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bug_text_table`
#


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

#
# Table structure for table `mantis_bugnote_table`
#

CREATE TABLE mantis_bugnote_table (
  id int(7) unsigned NOT NULL auto_increment,
  bug_id int(7) unsigned NOT NULL default '0',
  reporter_id int(7) unsigned NOT NULL default '0',
  bugnote_text_id int(7) unsigned NOT NULL default '0',
  view_state int(2) NOT NULL default '10',
  date_submitted datetime NOT NULL default '1970-01-01 00:00:01',
  last_modified datetime NOT NULL default '1970-01-01 00:00:01',
  note_type int(7) default '0',
  note_attr varchar(250) default '',
  PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bugnote_table`
#


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

#
# Table structure for table `mantis_bugnote_text_table`
#

CREATE TABLE mantis_bugnote_text_table (
  id int(7) unsigned NOT NULL auto_increment,
  note text NOT NULL,
  PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_bugnote_text_table`
#


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

#
# Table structure for table `mantis_custom_field_project_table`
#

CREATE TABLE mantis_custom_field_project_table (
  field_id int(3) NOT NULL default '0',
  project_id int(7) unsigned NOT NULL default '0',
  sequence int(2) NOT NULL default '0',
  PRIMARY KEY (field_id,project_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_custom_field_project_table`
#


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

#
# Table structure for table `mantis_custom_field_string_table`
#

CREATE TABLE mantis_custom_field_string_table (
  field_id int(3) NOT NULL default '0',
  bug_id int(7) NOT NULL default '0',
  value varchar(255) NOT NULL default '',
  PRIMARY KEY (field_id,bug_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_custom_field_string_table`
#


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

#
# Table structure for table `mantis_custom_field_table`
#

CREATE TABLE mantis_custom_field_table (
  id int(3) NOT NULL auto_increment,
  name varchar(64) NOT NULL default '',
  type int(2) NOT NULL default '0',
  possible_values varchar(255) NOT NULL default '',
  default_value varchar(255) NOT NULL default '',
  valid_regexp varchar(255) NOT NULL default '',
  access_level_r int(2) NOT NULL default '0',
  access_level_rw int(2) NOT NULL default '0',
  length_min int(3) NOT NULL default '0',
  length_max int(3) NOT NULL default '0',
  advanced int(1) NOT NULL default '0',
  require_report tinyint(1) NOT NULL default '0',
  require_update tinyint(1) NOT NULL default '0',
  display_report tinyint(1) NOT NULL default '1',
  display_update tinyint(1) NOT NULL default '1',
  require_resolved tinyint(1) NOT NULL default '0',
  display_resolved tinyint(1) NOT NULL default '0',
  display_closed tinyint(1) NOT NULL default '0',
  require_closed tinyint(1) NOT NULL default '0',
  PRIMARY KEY (id),
  KEY name (name)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_custom_field_table`
#


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

#
# Table structure for table `mantis_filters_table`
#

CREATE TABLE mantis_filters_table (
  id int(7) unsigned NOT NULL auto_increment,
  user_id int(7) NOT NULL default '0',
  project_id int(7) NOT NULL default '0',
  is_public tinyint(1) default NULL,
  name varchar(64) NOT NULL default '',
  filter_string text NOT NULL,
  PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_filters_table`
#


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

#
# Table structure for table `mantis_news_table`
#

CREATE TABLE mantis_news_table (
  id int(7) unsigned NOT NULL auto_increment,
  project_id int(7) unsigned NOT NULL default '0',
  poster_id int(7) unsigned NOT NULL default '0',
  date_posted datetime NOT NULL default '1970-01-01 00:00:01',
  last_modified datetime NOT NULL default '1970-01-01 00:00:01',
  view_state int(2) NOT NULL default '10',
  announcement int(1) NOT NULL default '0',
  headline varchar(64) NOT NULL default '',
  body text NOT NULL,
  PRIMARY KEY (id),
  KEY id (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_news_table`
#


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

#
# Table structure for table `mantis_project_category_table`
#

CREATE TABLE mantis_project_category_table (
  project_id int(7) unsigned NOT NULL default '0',
  category varchar(64) NOT NULL default '',
  user_id int(7) unsigned NOT NULL default '0',
  PRIMARY KEY (project_id,category)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_project_category_table`
#


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

#
# Table structure for table `mantis_project_file_table`
#

CREATE TABLE mantis_project_file_table (
  id int(7) unsigned NOT NULL auto_increment,
  project_id int(7) 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 '',
  date_added datetime NOT NULL default '1970-01-01 00:00:01',
  content longblob NOT NULL,
  PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_project_file_table`
#


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

#
# Table structure for table `mantis_project_table`
#

CREATE TABLE mantis_project_table (
  id int(7) unsigned NOT NULL auto_increment,
  name varchar(128) NOT NULL default '',
  status int(2) NOT NULL default '10',
  enabled int(1) NOT NULL default '1',
  view_state int(2) NOT NULL default '10',
  access_min int(2) NOT NULL default '10',
  file_path varchar(250) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY name (name),
  KEY id (id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_project_table`
#


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

#
# Table structure for table `mantis_project_user_list_table`
#

CREATE TABLE mantis_project_user_list_table (
  project_id int(7) unsigned NOT NULL default '0',
  user_id int(7) unsigned NOT NULL default '0',
  access_level int(2) NOT NULL default '10',
  PRIMARY KEY (project_id,user_id)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_project_user_list_table`
#


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

#
# Table structure for table `mantis_project_version_table`
#

CREATE TABLE mantis_project_version_table (
  id int(7) NOT NULL auto_increment,
  project_id int(7) unsigned NOT NULL default '0',
  version varchar(64) NOT NULL default '',
  date_order datetime NOT NULL default '1970-01-01 00:00:01',
  description text NOT NULL,
  released tinyint(1) NOT NULL default '1',
  PRIMARY KEY (id),
  UNIQUE KEY project_version (project_id,version)
) TYPE=MyISAM;

#
# Dumping data for table `mantis_project_version_table`
#


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

#
# Table structure for table `mantis_sponsorship_table`
#

CREATE TABLE mantis_sponsorship_table (
  id int(7) NOT NULL auto_increment,
  bug_id int(7) NOT NULL default '0',
  user_id int(7) NOT NULL default '0',
  amount int(7) NOT NULL default '0',
  logo varchar(128) NOT NULL default '',
  url varchar(128) NOT NULL default '',
  paid int(1) NOT NULL default '0',
  date_submitted datetime NOT NULL default '1970-01-01 00:00:01',
  last_updated datetime NOT NULL default '1970-01-01 00:00:01',
  PRIMARY KEY (id),
  KEY bug_id (bug_id),
  KEY user_id (user_id)
) TYPE=MyISAM COMMENT='A table for sponsorships';

#
# Dumping data for table `mantis_sponsorship_table`
#