Mantis安装说明 - 图文

expiry DATETIME,

value LONGTEXT NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_user_pref_table ( idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, user_idINTEGER UNSIGNED NOTNULLDEFAULT 0, project_idINTEGER UNSIGNED NOTNULLDEFAULT 0, default_profileINTEGER UNSIGNED NOTNULLDEFAULT 0, default_projectINTEGER UNSIGNED NOTNULLDEFAULT 0, advanced_report TINYINT NOTNULLDEFAULT'0', advanced_view TINYINT NOTNULLDEFAULT'0', advanced_update TINYINT NOTNULLDEFAULT'0', refresh_delayINTEGERNOTNULLDEFAULT 0,

redirect_delay TINYINT NOTNULLDEFAULT'0', bugnote_orderVARCHAR(4) NOTNULLDEFAULT'ASC', email_on_new TINYINT NOTNULLDEFAULT'0', email_on_assigned TINYINT NOTNULLDEFAULT'0', email_on_feedback TINYINT NOTNULLDEFAULT'0', email_on_resolved TINYINT NOTNULLDEFAULT'0', email_on_closed TINYINT NOTNULLDEFAULT'0', email_on_reopened TINYINT NOTNULLDEFAULT'0', email_on_bugnote TINYINT NOTNULLDEFAULT'0', email_on_status TINYINT NOTNULLDEFAULT'0', email_on_priority TINYINT NOTNULLDEFAULT'0', email_on_priority_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_status_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_bugnote_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_reopened_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_closed_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_resolved_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_feedback_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_assigned_min_severitySMALLINTNOTNULLDEFAULT 10, email_on_new_min_severitySMALLINTNOTNULLDEFAULT 10, email_bugnote_limitSMALLINTNOTNULLDEFAULT 0, languageVARCHAR(32) NOTNULLDEFAULT'english', PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_user_print_pref_table ( user_idINTEGER UNSIGNED NOTNULLDEFAULT 0, print_prefVARCHAR(27) NOTNULLDEFAULT'', PRIMARYKEY (user_id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_user_profile_table ( idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, user_idINTEGER UNSIGNED NOTNULLDEFAULT 0, platformVARCHAR(32) NOTNULLDEFAULT'', osVARCHAR(32) NOTNULLDEFAULT'', os_buildVARCHAR(32) NOTNULLDEFAULT'', description LONGTEXT NOTNULL, PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATETABLE mantis_user_table (

idINTEGER UNSIGNED NOTNULL AUTO_INCREMENT, usernameVARCHAR(32) NOTNULLDEFAULT'', realnameVARCHAR(64) NOTNULLDEFAULT'', emailVARCHAR(64) NOTNULLDEFAULT'', passwordVARCHAR(32) NOTNULLDEFAULT'',

date_created DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', last_visit DATETIME NOTNULLDEFAULT'1970-01-01 00:00:01', enabled TINYINT NOTNULLDEFAULT'1', protected TINYINT NOTNULLDEFAULT'0', access_levelSMALLINTNOTNULLDEFAULT 10, login_countINTEGERNOTNULLDEFAULT 0,

lost_password_request_countSMALLINTNOTNULLDEFAULT 0, failed_login_countSMALLINTNOTNULLDEFAULT 0, cookie_stringVARCHAR(64) NOTNULLDEFAULT'', PRIMARYKEY (id)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTERTABLE mantis_user_table ADDUNIQUEINDEX idx_user_cookie_string (cookie_string);

ALTERTABLE mantis_user_table ADDUNIQUEINDEX idx_user_username (username);

ALTERTABLE mantis_user_table ADDINDEX idx_enable (enabled);

ALTERTABLE mantis_user_table ADDINDEX idx_access (access_level);

INSERTINTO mantis_user_table(username, realname, email, password, date_created, last_visit, enabled, protected, access_level, login_count,

lost_password_request_count, failed_login_count, cookie_string) VALUES

('administrator', '', 'root@localhost', '63a9f0ea7bb98050796b649e85481845', '2015-10-22 09:49:53', '2015-10-22 09:49:53', '1', '0', 90, 3, 0, 0,