Mantis安装说明 - 图文

idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, bug_idINTEGER UNSIGNED NOTNULLDEFAULT 0, reporter_idINTEGER UNSIGNED NOTNULLDEFAULT 0, bugnote_text_idINTEGER UNSIGNED NOTNULLDEFAULT 0, view_stateSMALLINTNOTNULLDEFAULT 10,

date_submitted DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', last_modified DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', note_typeINTEGERDEFAULT 0, note_attrVARCHAR(250) DEFAULT'', PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_bugnote_table ADDINDEX idx_bug (bug_id);

ALTERTABLE mantis_bugnote_table ADDINDEX idx_last_mod (last_modified);

CREATETABLE mantis_bugnote_text_table ( idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, note LONGTEXT NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_custom_field_project_table ( field_idINTEGERNOTNULLDEFAULT 0,

project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, sequenceSMALLINTNOTNULLDEFAULT 0, PRIMARYKEY (field_id, project_id) )ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_custom_field_string_table ( field_idINTEGERNOTNULLDEFAULT 0, bug_idINTEGERNOTNULLDEFAULT 0, valueVARCHAR(255) NOTNULLDEFAULT'', PRIMARYKEY (field_id, bug_id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_custom_field_string_table ADDINDEX idx_custom_field_bug (bug_id);

CREATETABLE mantis_custom_field_table ( idINTEGERNOTNULL AUTO_INCREMENT, nameVARCHAR(64) NOTNULLDEFAULT'', typeSMALLINTNOTNULLDEFAULT 0,

possible_valuesVARCHAR(255) NOTNULLDEFAULT'',

default_valueVARCHAR(255) NOTNULLDEFAULT'', valid_regexpVARCHAR(255) NOTNULLDEFAULT'', access_level_rSMALLINTNOTNULLDEFAULT 0, access_level_rwSMALLINTNOTNULLDEFAULT 0, length_minINTEGERNOTNULLDEFAULT 0, length_maxINTEGERNOTNULLDEFAULT 0,

advanced TINYINT NOTNULLDEFAULT'0', require_report TINYINT NOTNULLDEFAULT'0', require_update TINYINT NOTNULLDEFAULT'0', display_report TINYINT NOTNULLDEFAULT'0', display_update TINYINT NOTNULLDEFAULT'1', require_resolved TINYINT NOTNULLDEFAULT'0', display_resolved TINYINT NOTNULLDEFAULT'0', display_closed TINYINT NOTNULLDEFAULT'0', require_closed TINYINT NOTNULLDEFAULT'0', PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_custom_field_table ADDINDEX idx_custom_field_name (name);

CREATETABLE mantis_filters_table (

idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, user_idINTEGERNOTNULLDEFAULT 0, project_idINTEGERNOTNULLDEFAULT 0,

is_public TINYINT DEFAULTNULL, nameVARCHAR(64) NOTNULLDEFAULT'',

filter_string LONGTEXT NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_news_table (

idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, poster_idINTEGER UNSIGNED NOTNULLDEFAULT 0,

date_posted DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', last_modified DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', view_stateSMALLINTNOTNULLDEFAULT 10,

announcement TINYINT NOTNULLDEFAULT'0', headlineVARCHAR(64) NOTNULLDEFAULT'', body LONGTEXT NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_project_category_table (

project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, categoryVARCHAR(64) NOTNULLDEFAULT'', user_idINTEGER UNSIGNED NOTNULLDEFAULT 0, PRIMARYKEY (project_id, category) )ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_project_file_table ( idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, titleVARCHAR(250) NOTNULLDEFAULT'', descriptionVARCHAR(250) NOTNULLDEFAULT'', diskfileVARCHAR(250) NOTNULLDEFAULT'', filenameVARCHAR(250) NOTNULLDEFAULT'', folderVARCHAR(250) NOTNULLDEFAULT'', filesizeINTEGERNOTNULLDEFAULT 0,

file_typeVARCHAR(250) NOTNULLDEFAULT'',

date_added DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', content LONGBLOB NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_project_hierarchy_table ( child_idINTEGER UNSIGNED NOTNULL, parent_idINTEGER UNSIGNED NOTNULL )ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_project_table (

idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, nameVARCHAR(128) NOTNULLDEFAULT'', statusSMALLINTNOTNULLDEFAULT 10,

enabled TINYINT NOTNULLDEFAULT'1', view_stateSMALLINTNOTNULLDEFAULT 10, access_minSMALLINTNOTNULLDEFAULT 10, file_pathVARCHAR(250) NOTNULLDEFAULT'', description LONGTEXT NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_project_table ADDINDEX idx_project_id (id);

ALTERTABLE mantis_project_table ADDUNIQUEINDEX idx_project_name (name);

ALTERTABLE mantis_project_table ADDINDEX idx_project_view (view_state);

CREATETABLE mantis_project_user_list_table ( project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, user_idINTEGER UNSIGNED NOTNULLDEFAULT 0, access_levelSMALLINTNOTNULLDEFAULT 10, PRIMARYKEY (project_id, user_id) )ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_project_user_list_table ADDINDEX idx_project_user (user_id);

CREATETABLE mantis_project_version_table ( idINTEGERNOTNULL AUTO_INCREMENT,

project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, versionVARCHAR(64) NOTNULLDEFAULT'',

date_order DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', description LONGTEXT NOTNULL,

released TINYINT NOTNULLDEFAULT'1', PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_project_version_table ADDUNIQUEINDEX idx_project_version (project_id, version);

CREATETABLE mantis_sponsorship_table ( idINTEGERNOTNULL AUTO_INCREMENT, bug_idINTEGERNOTNULLDEFAULT 0, user_idINTEGERNOTNULLDEFAULT 0, amountINTEGERNOTNULLDEFAULT 0, logoVARCHAR(128) NOTNULLDEFAULT'', urlVARCHAR(128) NOTNULLDEFAULT'',

paid TINYINT NOTNULLDEFAULT'0',

date_submitted DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', last_updated DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_sponsorship_table ADDINDEX idx_sponsorship_bug_id (bug_id);

ALTERTABLE mantis_sponsorship_table ADDINDEX idx_sponsorship_user_id (user_id);

CREATETABLE mantis_tokens_table ( idINTEGERNOTNULL AUTO_INCREMENT, ownerINTEGERNOTNULL, typeINTEGERNOTNULL,

timestamp DATETIME NOTNULL,