将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
未命名 *
v 显示/隐藏表格列表 全屏查看 从其他数据库中添加表 新页面 打开页面 保存页面 保存页面为 删除页 新建数据表 创建关系 选择要显示的字段 重新载入 帮助 折角连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 显示/隐藏关系线 导出架构 > 移动菜单 > 固定文字
v v
数据表数量： 0
v bugtracker mantis_api_token_table
* id : int(10) unsigned
* user_id : int(10) unsigned
* name : varchar(128)
* hash : varchar(128)
* date_created : int(10) unsigned
* date_used : int(10) unsigned
v bugtracker mantis_bugnote_table
* id : int(10) unsigned
* bug_id : int(10) unsigned
* reporter_id : int(10) unsigned
* bugnote_text_id : int(10) unsigned
* view_state : smallint(6)
* note_type : int(11)
* note_attr : varchar(250)
* time_tracking : int(10) unsigned
* last_modified : int(10) unsigned
* date_submitted : int(10) unsigned
v bugtracker mantis_bugnote_text_table
* id : int(10) unsigned
* note : longtext
v bugtracker mantis_bug_file_table
* id : int(10) unsigned
* bug_id : int(10) unsigned
* title : varchar(250)
* description : varchar(250)
* diskfile : varchar(250)
* filename : varchar(250)
* folder : varchar(250)
* filesize : int(11)
* file_type : varchar(250)
* content : longblob
* date_added : int(10) unsigned
* user_id : int(10) unsigned
* bugnote_id : int(10) unsigned
v bugtracker mantis_bug_history_table
* id : int(10) unsigned
* user_id : int(10) unsigned
* bug_id : int(10) unsigned
* field_name : varchar(64)
* old_value : varchar(255)
* new_value : varchar(255)
* type : smallint(6)
* date_modified : int(10) unsigned
v bugtracker mantis_bug_monitor_table
* user_id : int(10) unsigned
* bug_id : int(10) unsigned
v bugtracker mantis_bug_relationship_table
* id : int(10) unsigned
* source_bug_id : int(10) unsigned
* destination_bug_id : int(10) unsigned
* relationship_type : smallint(6)
v bugtracker mantis_bug_revision_table
* id : int(10) unsigned
* bug_id : int(10) unsigned
* bugnote_id : int(10) unsigned
* user_id : int(10) unsigned
* type : int(10) unsigned
* value : longtext
* timestamp : int(10) unsigned
v bugtracker mantis_bug_table
* id : int(10) unsigned
* project_id : int(10) unsigned
* reporter_id : int(10) unsigned
* handler_id : int(10) unsigned
* duplicate_id : int(10) unsigned
* priority : smallint(6)
* severity : smallint(6)
* reproducibility : smallint(6)
* status : smallint(6)
* resolution : smallint(6)
* projection : smallint(6)
* eta : smallint(6)
* bug_text_id : int(10) unsigned
* os : varchar(32)
* os_build : varchar(32)
* platform : varchar(32)
* version : varchar(64)
* fixed_in_version : varchar(64)
* build : varchar(32)
* profile_id : int(10) unsigned
* view_state : smallint(6)
* summary : varchar(128)
* sponsorship_total : int(11)
* sticky : tinyint(4)
* target_version : varchar(64)
* category_id : int(10) unsigned
* date_submitted : int(10) unsigned
* due_date : int(10) unsigned
* last_updated : int(10) unsigned
v bugtracker mantis_bug_tag_table
* bug_id : int(10) unsigned
* tag_id : int(10) unsigned
* user_id : int(10) unsigned
* date_attached : int(10) unsigned
v bugtracker mantis_bug_text_table
* id : int(10) unsigned
* description : longtext
* steps_to_reproduce : longtext
* additional_information : longtext
v bugtracker mantis_category_table
* id : int(10) unsigned
* project_id : int(10) unsigned
* user_id : int(10) unsigned
* name : varchar(128)
* status : int(10) unsigned
v bugtracker mantis_config_table
* config_id : varchar(64)
* project_id : int(11)
* user_id : int(11)
* access_reqd : int(11)
* type : int(11)
* value : longtext
v bugtracker mantis_custom_field_project_table
* field_id : int(11)
* project_id : int(10) unsigned
* sequence : smallint(6)
v bugtracker mantis_custom_field_string_table
* field_id : int(11)
* bug_id : int(11)
* value : varchar(255)
* text : longtext
v bugtracker mantis_custom_field_table
* id : int(11)
* name : varchar(64)
* type : smallint(6)
* possible_values : text
* default_value : varchar(255)
* valid_regexp : varchar(255)
* access_level_r : smallint(6)
* access_level_rw : smallint(6)
* length_min : int(11)
* length_max : int(11)
* require_report : tinyint(4)
* require_update : tinyint(4)
* display_report : tinyint(4)
* display_update : tinyint(4)
* require_resolved : tinyint(4)
* display_resolved : tinyint(4)
* display_closed : tinyint(4)
* require_closed : tinyint(4)
* filter_by : tinyint(4)
v bugtracker mantis_email_table
* email_id : int(10) unsigned
* email : varchar(191)
* subject : varchar(250)
* metadata : longtext
* body : longtext
* submitted : int(10) unsigned
v bugtracker mantis_filters_table
* id : int(10) unsigned
* user_id : int(11)
* project_id : int(11)
* is_public : tinyint(4)
* name : varchar(64)
* filter_string : longtext
v bugtracker mantis_news_table
* id : int(10) unsigned
* project_id : int(10) unsigned
* poster_id : int(10) unsigned
* view_state : smallint(6)
* announcement : tinyint(4)
* headline : varchar(64)
* body : longtext
* last_modified : int(10) unsigned
* date_posted : int(10) unsigned
v bugtracker mantis_plugin_table
* basename : varchar(40)
* enabled : tinyint(4)
* protected : tinyint(4)
* priority : int(10) unsigned
v bugtracker mantis_project_file_table
* id : int(10) unsigned
* project_id : int(10) unsigned
* title : varchar(250)
* description : varchar(250)
* diskfile : varchar(250)
* filename : varchar(250)
* folder : varchar(250)
* filesize : int(11)
* file_type : varchar(250)
* content : longblob
* date_added : int(10) unsigned
* user_id : int(10) unsigned
v bugtracker mantis_project_hierarchy_table
* child_id : int(10) unsigned
* parent_id : int(10) unsigned
* inherit_parent : tinyint(4)
v bugtracker mantis_project_table
* id : int(10) unsigned
* name : varchar(128)
* status : smallint(6)
* enabled : tinyint(4)
* view_state : smallint(6)
* access_min : smallint(6)
* file_path : varchar(250)
* description : longtext
* category_id : int(10) unsigned
* inherit_global : tinyint(4)
v bugtracker mantis_project_user_list_table
* project_id : int(10) unsigned
* user_id : int(10) unsigned
* access_level : smallint(6)
v bugtracker mantis_project_version_table
* id : int(11)
* project_id : int(10) unsigned
* version : varchar(64)
* description : longtext
* released : tinyint(4)
* obsolete : tinyint(4)
* date_order : int(10) unsigned
v bugtracker mantis_sponsorship_table
* id : int(11)
* bug_id : int(11)
* user_id : int(11)
* amount : int(11)
* url : varchar(128)
* paid : tinyint(4)
* date_submitted : int(10) unsigned
* last_updated : int(10) unsigned
v bugtracker mantis_tag_table
* id : int(10) unsigned
* user_id : int(10) unsigned
* name : varchar(100)
* description : longtext
* date_created : int(10) unsigned
* date_updated : int(10) unsigned
v bugtracker mantis_tokens_table
* id : int(11)
* owner : int(11)
* type : int(11)
* value : longtext
* timestamp : int(10) unsigned
* expiry : int(10) unsigned
v bugtracker mantis_user_pref_table
* id : int(10) unsigned
* user_id : int(10) unsigned
* project_id : int(10) unsigned
* default_profile : int(10) unsigned
* default_project : int(10) unsigned
* refresh_delay : int(11)
* redirect_delay : int(11)
* bugnote_order : varchar(4)
* email_on_new : tinyint(4)
* email_on_assigned : tinyint(4)
* email_on_feedback : tinyint(4)
* email_on_resolved : tinyint(4)
* email_on_closed : tinyint(4)
* email_on_reopened : tinyint(4)
* email_on_bugnote : tinyint(4)
* email_on_status : tinyint(4)
* email_on_priority : tinyint(4)
* email_on_priority_min_severity : smallint(6)
* email_on_status_min_severity : smallint(6)
* email_on_bugnote_min_severity : smallint(6)
* email_on_reopened_min_severity : smallint(6)
* email_on_closed_min_severity : smallint(6)
* email_on_resolved_min_severity : smallint(6)
* email_on_feedback_min_severity : smallint(6)
* email_on_assigned_min_severity : smallint(6)
* email_on_new_min_severity : smallint(6)
* email_bugnote_limit : smallint(6)
* language : varchar(32)
* timezone : varchar(32)
v bugtracker mantis_user_print_pref_table
* user_id : int(10) unsigned
* print_pref : varchar(64)
v bugtracker mantis_user_profile_table
* id : int(10) unsigned
* user_id : int(10) unsigned
* platform : varchar(32)
* os : varchar(32)
* os_build : varchar(32)
* description : longtext
v bugtracker mantis_user_table
* id : int(10) unsigned
* username : varchar(191)
* realname : varchar(191)
* email : varchar(191)
* password : varchar(64)
* enabled : tinyint(4)
* protected : tinyint(4)
* access_level : smallint(6)
* login_count : int(11)
* lost_password_request_count : smallint(6)
* failed_login_count : smallint(6)
* cookie_string : varchar(64)
* last_visit : int(10) unsigned
* date_created : int(10) unsigned
创建关系
FOREIGN KEY
on delete
on update
删除关系