发布时间 : 星期四 文章Mantis安装说明 - 图文更新完毕开始阅读1b523aa8b84ae45c3a358c08
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,