MovableType5.12のDBテーブル定義一覧
MySQLのテーブル定義をHTMLに変換して出力するツール
MovableType5.12のDBテーブル定義一覧
mt_asset
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| asset_id | int(11) | NO | PRI | NULL | auto_increment |
| asset_blog_id | int(11) | NO | MUL | NULL | |
| asset_class | varchar(255) | YES | MUL | file | |
| asset_created_by | int(11) | YES | MUL | NULL | |
| asset_created_on | datetime | YES | MUL | NULL | |
| asset_description | mediumtext | YES | NULL | ||
| asset_file_ext | varchar(20) | YES | MUL | NULL | |
| asset_file_name | varchar(255) | YES | NULL | ||
| asset_file_path | varchar(255) | YES | NULL | ||
| asset_label | varchar(255) | YES | MUL | NULL | |
| asset_mime_type | varchar(255) | YES | NULL | ||
| asset_modified_by | int(11) | YES | NULL | ||
| asset_modified_on | datetime | YES | NULL | ||
| asset_parent | int(11) | YES | MUL | NULL | |
| asset_url | varchar(255) | YES | NULL |
mt_asset_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| asset_meta_asset_id | int(11) | NO | PRI | NULL | |
| asset_meta_type | varchar(75) | NO | PRI | NULL | |
| asset_meta_vchar | varchar(255) | YES | NULL | ||
| asset_meta_vchar_idx | varchar(255) | YES | NULL | ||
| asset_meta_vdatetime | datetime | YES | NULL | ||
| asset_meta_vdatetime_idx | datetime | YES | NULL | ||
| asset_meta_vinteger | int(11) | YES | NULL | ||
| asset_meta_vinteger_idx | int(11) | YES | NULL | ||
| asset_meta_vfloat | float | YES | NULL | ||
| asset_meta_vfloat_idx | float | YES | NULL | ||
| asset_meta_vblob | mediumblob | YES | NULL | ||
| asset_meta_vclob | mediumtext | YES | NULL |
mt_association
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| association_id | int(11) | NO | PRI | NULL | auto_increment |
| association_author_id | int(11) | YES | MUL | 0 | |
| association_blog_id | int(11) | YES | MUL | 0 | |
| association_created_by | int(11) | YES | NULL | ||
| association_created_on | datetime | YES | MUL | NULL | |
| association_group_id | int(11) | YES | MUL | 0 | |
| association_modified_by | int(11) | YES | NULL | ||
| association_modified_on | datetime | YES | NULL | ||
| association_role_id | int(11) | YES | MUL | 0 | |
| association_type | int(11) | NO | MUL | NULL |
mt_author
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| author_id | int(11) | NO | PRI | NULL | auto_increment |
| author_api_password | varchar(60) | YES | NULL | ||
| author_can_create_blog | tinyint(4) | YES | NULL | ||
| author_can_view_log | tinyint(4) | YES | NULL | ||
| author_email | varchar(127) | YES | MUL | NULL | |
| author_entry_prefs | varchar(255) | YES | NULL | ||
| author_hint | varchar(75) | YES | NULL | ||
| author_is_superuser | tinyint(4) | YES | NULL | ||
| author_name | varchar(255) | NO | MUL | NULL | |
| author_nickname | varchar(255) | YES | NULL | ||
| author_password | varchar(60) | NO | NULL | ||
| author_preferred_language | varchar(50) | YES | NULL | ||
| author_public_key | mediumtext | YES | NULL | ||
| author_remote_auth_token | varchar(50) | YES | NULL | ||
| author_remote_auth_username | varchar(50) | YES | NULL | ||
| author_type | smallint(6) | NO | MUL | 1 | |
| author_url | varchar(255) | YES | NULL | ||
| author_created_on | datetime | YES | MUL | NULL | |
| author_created_by | int(11) | YES | NULL | ||
| author_modified_on | datetime | YES | NULL | ||
| author_modified_by | int(11) | YES | NULL | ||
| author_status | int(11) | YES | MUL | 1 | |
| author_text_format | varchar(30) | YES | NULL | ||
| author_auth_type | varchar(50) | YES | MUL | NULL | |
| author_external_id | varchar(255) | YES | MUL | NULL | |
| author_userpic_asset_id | int(11) | YES | NULL | ||
| author_basename | varchar(255) | YES | MUL | NULL | |
| author_date_format | varchar(30) | YES | relative |
mt_author_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| author_meta_author_id | int(11) | NO | PRI | NULL | |
| author_meta_type | varchar(75) | NO | PRI | NULL | |
| author_meta_vchar | varchar(255) | YES | NULL | ||
| author_meta_vchar_idx | varchar(255) | YES | NULL | ||
| author_meta_vdatetime | datetime | YES | NULL | ||
| author_meta_vdatetime_idx | datetime | YES | NULL | ||
| author_meta_vinteger | int(11) | YES | NULL | ||
| author_meta_vinteger_idx | int(11) | YES | NULL | ||
| author_meta_vfloat | float | YES | NULL | ||
| author_meta_vfloat_idx | float | YES | NULL | ||
| author_meta_vblob | mediumblob | YES | NULL | ||
| author_meta_vclob | mediumtext | YES | NULL |
mt_author_summary
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| author_summary_author_id | int(11) | NO | PRI | NULL | |
| author_summary_type | varchar(75) | NO | PRI | NULL | |
| author_summary_class | varchar(75) | NO | MUL | NULL | |
| author_summary_vchar_idx | varchar(255) | YES | NULL | ||
| author_summary_vinteger_idx | int(11) | YES | NULL | ||
| author_summary_vblob | mediumblob | YES | NULL | ||
| author_summary_vclob | mediumtext | YES | NULL | ||
| author_summary_expired | smallint(6) | YES | NULL |
mt_blog
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| blog_id | int(11) | NO | PRI | NULL | auto_increment |
| blog_allow_anon_comments | tinyint(4) | YES | NULL | ||
| blog_allow_comment_html | tinyint(4) | YES | NULL | ||
| blog_allow_comments_default | tinyint(4) | YES | NULL | ||
| blog_allow_pings | tinyint(4) | YES | NULL | ||
| blog_allow_pings_default | tinyint(4) | YES | NULL | ||
| blog_allow_reg_comments | tinyint(4) | YES | NULL | ||
| blog_allow_unreg_comments | tinyint(4) | YES | NULL | ||
| blog_archive_path | varchar(255) | YES | NULL | ||
| blog_archive_tmpl_category | varchar(255) | YES | NULL | ||
| blog_archive_tmpl_daily | varchar(255) | YES | NULL | ||
| blog_archive_tmpl_individual | varchar(255) | YES | NULL | ||
| blog_archive_tmpl_monthly | varchar(255) | YES | NULL | ||
| blog_archive_tmpl_weekly | varchar(255) | YES | NULL | ||
| blog_archive_type | varchar(255) | YES | NULL | ||
| blog_archive_type_preferred | varchar(25) | YES | NULL | ||
| blog_archive_url | varchar(255) | YES | NULL | ||
| blog_autodiscover_links | tinyint(4) | YES | NULL | ||
| blog_autolink_urls | tinyint(4) | YES | NULL | ||
| blog_basename_limit | smallint(6) | YES | NULL | ||
| blog_cc_license | varchar(255) | YES | NULL | ||
| blog_children_modified_on | datetime | YES | MUL | NULL | |
| blog_convert_paras | varchar(30) | YES | NULL | ||
| blog_convert_paras_comments | varchar(30) | YES | NULL | ||
| blog_custom_dynamic_templates | varchar(25) | YES | none | ||
| blog_days_on_index | int(11) | YES | NULL | ||
| blog_description | mediumtext | YES | NULL | ||
| blog_email_new_comments | tinyint(4) | YES | NULL | ||
| blog_email_new_pings | tinyint(4) | YES | NULL | ||
| blog_entries_on_index | int(11) | YES | NULL | ||
| blog_file_extension | varchar(10) | YES | NULL | ||
| blog_google_api_key | varchar(32) | YES | NULL | ||
| blog_internal_autodiscovery | tinyint(4) | YES | NULL | ||
| blog_is_dynamic | tinyint(4) | YES | NULL | ||
| blog_junk_folder_expiry | int(11) | YES | NULL | ||
| blog_junk_score_threshold | float | YES | NULL | ||
| blog_language | varchar(5) | YES | NULL | ||
| blog_manual_approve_commenters | tinyint(4) | YES | NULL | ||
| blog_moderate_pings | tinyint(4) | YES | NULL | ||
| blog_moderate_unreg_comments | tinyint(4) | YES | NULL | ||
| blog_mt_update_key | varchar(30) | YES | NULL | ||
| blog_name | varchar(255) | NO | MUL | NULL | |
| blog_old_style_archive_links | tinyint(4) | YES | NULL | ||
| blog_ping_blogs | tinyint(4) | YES | NULL | ||
| blog_ping_others | mediumtext | YES | NULL | ||
| blog_ping_technorati | tinyint(4) | YES | NULL | ||
| blog_ping_weblogs | tinyint(4) | YES | NULL | ||
| blog_remote_auth_token | varchar(50) | YES | NULL | ||
| blog_require_comment_emails | tinyint(4) | YES | NULL | ||
| blog_sanitize_spec | varchar(255) | YES | NULL | ||
| blog_server_offset | float | YES | NULL | ||
| blog_site_path | varchar(255) | YES | NULL | ||
| blog_site_url | varchar(255) | YES | NULL | ||
| blog_sort_order_comments | varchar(8) | YES | NULL | ||
| blog_sort_order_posts | varchar(8) | YES | NULL | ||
| blog_status_default | smallint(6) | YES | NULL | ||
| blog_welcome_msg | mediumtext | YES | NULL | ||
| blog_words_in_excerpt | smallint(6) | YES | NULL | ||
| blog_created_on | datetime | YES | NULL | ||
| blog_created_by | int(11) | YES | NULL | ||
| blog_use_comment_confirmation | tinyint(4) | YES | NULL | ||
| blog_modified_by | int(11) | YES | NULL | ||
| blog_allow_commenter_regist | tinyint(4) | YES | NULL | ||
| blog_ping_google | tinyint(4) | YES | NULL | ||
| blog_modified_on | datetime | YES | NULL | ||
| blog_theme_id | varchar(255) | YES | NULL | ||
| blog_use_revision | tinyint(4) | YES | NULL | ||
| blog_parent_id | int(11) | YES | MUL | NULL | |
| blog_class | varchar(255) | YES | MUL | blog |
mt_blog_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| blog_meta_blog_id | int(11) | NO | PRI | NULL | |
| blog_meta_type | varchar(75) | NO | PRI | NULL | |
| blog_meta_vchar | varchar(255) | YES | NULL | ||
| blog_meta_vchar_idx | varchar(255) | YES | NULL | ||
| blog_meta_vdatetime | datetime | YES | NULL | ||
| blog_meta_vdatetime_idx | datetime | YES | NULL | ||
| blog_meta_vinteger | int(11) | YES | NULL | ||
| blog_meta_vinteger_idx | int(11) | YES | NULL | ||
| blog_meta_vfloat | float | YES | NULL | ||
| blog_meta_vfloat_idx | float | YES | NULL | ||
| blog_meta_vblob | mediumblob | YES | NULL | ||
| blog_meta_vclob | mediumtext | YES | NULL |
mt_category
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| category_id | int(11) | NO | PRI | NULL | auto_increment |
| category_allow_pings | tinyint(4) | YES | 0 | ||
| category_author_id | int(11) | YES | NULL | ||
| category_basename | varchar(255) | YES | MUL | NULL | |
| category_blog_id | int(11) | NO | MUL | NULL | |
| category_description | mediumtext | YES | NULL | ||
| category_label | varchar(100) | NO | MUL | NULL | |
| category_parent | int(11) | YES | MUL | 0 | |
| category_ping_urls | mediumtext | YES | NULL | ||
| category_modified_on | datetime | YES | NULL | ||
| category_created_on | datetime | YES | NULL | ||
| category_modified_by | int(11) | YES | NULL | ||
| category_class | varchar(255) | YES | MUL | category | |
| category_created_by | int(11) | YES | NULL |
mt_category_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| category_meta_category_id | int(11) | NO | PRI | NULL | |
| category_meta_type | varchar(75) | NO | PRI | NULL | |
| category_meta_vchar | varchar(255) | YES | NULL | ||
| category_meta_vchar_idx | varchar(255) | YES | NULL | ||
| category_meta_vdatetime | datetime | YES | NULL | ||
| category_meta_vdatetime_idx | datetime | YES | NULL | ||
| category_meta_vinteger | int(11) | YES | NULL | ||
| category_meta_vinteger_idx | int(11) | YES | NULL | ||
| category_meta_vfloat | float | YES | NULL | ||
| category_meta_vfloat_idx | float | YES | NULL | ||
| category_meta_vblob | mediumblob | YES | NULL | ||
| category_meta_vclob | mediumtext | YES | NULL |
mt_comment
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| comment_id | int(11) | NO | PRI | NULL | auto_increment |
| comment_author | varchar(100) | YES | MUL | NULL | |
| comment_blog_id | int(11) | NO | MUL | NULL | |
| comment_commenter_id | int(11) | YES | MUL | NULL | |
| comment_email | varchar(127) | YES | MUL | NULL | |
| comment_entry_id | int(11) | NO | MUL | NULL | |
| comment_ip | varchar(50) | YES | MUL | NULL | |
| comment_junk_log | mediumtext | YES | NULL | ||
| comment_junk_score | float | YES | MUL | NULL | |
| comment_junk_status | smallint(6) | YES | MUL | 0 | |
| comment_last_moved_on | datetime | NO | MUL | 2000-01-01 00:00:00 | |
| comment_text | mediumtext | YES | NULL | ||
| comment_url | varchar(255) | YES | NULL | ||
| comment_visible | tinyint(4) | YES | MUL | NULL | |
| comment_created_on | datetime | YES | MUL | NULL | |
| comment_created_by | int(11) | YES | NULL | ||
| comment_modified_on | datetime | YES | NULL | ||
| comment_modified_by | int(11) | YES | NULL | ||
| comment_parent_id | int(11) | YES | MUL | NULL |
mt_comment_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| comment_meta_comment_id | int(11) | NO | PRI | NULL | |
| comment_meta_type | varchar(75) | NO | PRI | NULL | |
| comment_meta_vchar | varchar(255) | YES | NULL | ||
| comment_meta_vchar_idx | varchar(255) | YES | NULL | ||
| comment_meta_vdatetime | datetime | YES | NULL | ||
| comment_meta_vdatetime_idx | datetime | YES | NULL | ||
| comment_meta_vinteger | int(11) | YES | NULL | ||
| comment_meta_vinteger_idx | int(11) | YES | NULL | ||
| comment_meta_vfloat | float | YES | NULL | ||
| comment_meta_vfloat_idx | float | YES | NULL | ||
| comment_meta_vblob | mediumblob | YES | NULL | ||
| comment_meta_vclob | mediumtext | YES | NULL |
mt_config
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| config_id | int(11) | NO | PRI | NULL | auto_increment |
| config_data | mediumtext | YES | NULL |
mt_entry
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| entry_id | int(11) | NO | PRI | NULL | auto_increment |
| entry_allow_comments | tinyint(4) | YES | NULL | ||
| entry_allow_pings | tinyint(4) | YES | NULL | ||
| entry_atom_id | varchar(255) | YES | NULL | ||
| entry_author_id | int(11) | NO | MUL | NULL | |
| entry_basename | varchar(255) | YES | MUL | NULL | |
| entry_blog_id | int(11) | NO | MUL | NULL | |
| entry_category_id | int(11) | YES | NULL | ||
| entry_convert_breaks | varchar(60) | YES | NULL | ||
| entry_excerpt | mediumtext | YES | NULL | ||
| entry_keywords | mediumtext | YES | NULL | ||
| entry_pinged_urls | mediumtext | YES | NULL | ||
| entry_status | smallint(6) | NO | MUL | NULL | |
| entry_tangent_cache | mediumtext | YES | NULL | ||
| entry_text | mediumtext | YES | NULL | ||
| entry_text_more | mediumtext | YES | NULL | ||
| entry_title | varchar(255) | YES | MUL | NULL | |
| entry_to_ping_urls | mediumtext | YES | NULL | ||
| entry_week_number | int(11) | YES | MUL | NULL | |
| entry_created_on | datetime | YES | MUL | NULL | |
| entry_created_by | int(11) | YES | NULL | ||
| entry_modified_on | datetime | YES | MUL | NULL | |
| entry_modified_by | int(11) | YES | NULL | ||
| entry_authored_on | datetime | YES | MUL | NULL | |
| entry_template_id | int(11) | YES | NULL | ||
| entry_class | varchar(255) | YES | MUL | entry | |
| entry_ping_count | int(11) | YES | 0 | ||
| entry_comment_count | int(11) | YES | MUL | 0 | |
| entry_current_revision | int(11) | NO | 0 |
mt_entry_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| entry_meta_entry_id | int(11) | NO | PRI | NULL | |
| entry_meta_type | varchar(75) | NO | PRI | NULL | |
| entry_meta_vchar | varchar(255) | YES | NULL | ||
| entry_meta_vchar_idx | varchar(255) | YES | NULL | ||
| entry_meta_vdatetime | datetime | YES | NULL | ||
| entry_meta_vdatetime_idx | datetime | YES | NULL | ||
| entry_meta_vinteger | int(11) | YES | NULL | ||
| entry_meta_vinteger_idx | int(11) | YES | NULL | ||
| entry_meta_vfloat | float | YES | NULL | ||
| entry_meta_vfloat_idx | float | YES | NULL | ||
| entry_meta_vblob | mediumblob | YES | NULL | ||
| entry_meta_vclob | mediumtext | YES | NULL |
mt_entry_rev
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| entry_rev_id | int(11) | NO | PRI | NULL | auto_increment |
| entry_rev_changed | varchar(255) | NO | NULL | ||
| entry_rev_created_by | int(11) | YES | NULL | ||
| entry_rev_created_on | datetime | YES | NULL | ||
| entry_rev_description | varchar(255) | YES | NULL | ||
| entry_rev_entry | mediumblob | NO | NULL | ||
| entry_rev_entry_id | int(11) | NO | MUL | NULL | |
| entry_rev_label | varchar(255) | YES | NULL | ||
| entry_rev_modified_by | int(11) | YES | NULL | ||
| entry_rev_modified_on | datetime | YES | NULL | ||
| entry_rev_rev_number | int(11) | NO | 0 |
mt_entry_summary
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| entry_summary_entry_id | int(11) | NO | PRI | NULL | |
| entry_summary_type | varchar(75) | NO | PRI | NULL | |
| entry_summary_class | varchar(75) | NO | MUL | NULL | |
| entry_summary_vchar_idx | varchar(255) | YES | NULL | ||
| entry_summary_vinteger_idx | int(11) | YES | NULL | ||
| entry_summary_vblob | mediumblob | YES | NULL | ||
| entry_summary_vclob | mediumtext | YES | NULL | ||
| entry_summary_expired | smallint(6) | YES | NULL |
mt_field
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| field_id | int(11) | NO | PRI | NULL | auto_increment |
| field_basename | varchar(255) | YES | MUL | NULL | |
| field_blog_id | int(11) | YES | MUL | NULL | |
| field_default | mediumtext | YES | NULL | ||
| field_description | mediumtext | YES | NULL | ||
| field_name | varchar(255) | NO | MUL | NULL | |
| field_obj_type | varchar(50) | NO | MUL | NULL | |
| field_options | mediumtext | YES | NULL | ||
| field_required | tinyint(4) | YES | NULL | ||
| field_tag | varchar(255) | NO | NULL | ||
| field_type | varchar(50) | NO | MUL | NULL |
mt_fileinfo
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| fileinfo_id | int(11) | NO | PRI | NULL | auto_increment |
| fileinfo_archive_type | varchar(255) | YES | MUL | NULL | |
| fileinfo_blog_id | int(11) | NO | MUL | NULL | |
| fileinfo_category_id | int(11) | YES | MUL | NULL | |
| fileinfo_entry_id | int(11) | YES | MUL | NULL | |
| fileinfo_file_path | mediumtext | YES | NULL | ||
| fileinfo_startdate | varchar(80) | YES | MUL | NULL | |
| fileinfo_template_id | int(11) | YES | MUL | NULL | |
| fileinfo_templatemap_id | int(11) | YES | MUL | NULL | |
| fileinfo_url | varchar(255) | YES | MUL | NULL | |
| fileinfo_virtual | tinyint(4) | YES | NULL | ||
| fileinfo_author_id | int(11) | YES | MUL | NULL |
mt_filter
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| filter_id | int(11) | NO | PRI | NULL | auto_increment |
| filter_author_id | int(11) | NO | MUL | NULL | |
| filter_blog_id | int(11) | NO | NULL | ||
| filter_created_by | int(11) | YES | NULL | ||
| filter_created_on | datetime | YES | MUL | NULL | |
| filter_items | mediumblob | YES | NULL | ||
| filter_label | varchar(255) | YES | MUL | NULL | |
| filter_modified_by | int(11) | YES | NULL | ||
| filter_modified_on | datetime | YES | MUL | NULL | |
| filter_object_ds | varchar(255) | YES | NULL |
mt_ipbanlist
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ipbanlist_id | int(11) | NO | PRI | NULL | auto_increment |
| ipbanlist_blog_id | int(11) | NO | MUL | NULL | |
| ipbanlist_ip | varchar(50) | NO | MUL | NULL | |
| ipbanlist_created_on | datetime | YES | NULL | ||
| ipbanlist_created_by | int(11) | YES | NULL | ||
| ipbanlist_modified_on | datetime | YES | NULL | ||
| ipbanlist_modified_by | int(11) | YES | NULL |
mt_log
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| log_id | int(11) | NO | PRI | NULL | auto_increment |
| log_author_id | int(11) | YES | 0 | ||
| log_blog_id | int(11) | YES | MUL | 0 | |
| log_category | varchar(255) | YES | NULL | ||
| log_class | varchar(255) | YES | MUL | system | |
| log_ip | varchar(50) | YES | NULL | ||
| log_level | int(11) | YES | MUL | 1 | |
| log_message | mediumtext | YES | NULL | ||
| log_metadata | varchar(255) | YES | NULL | ||
| log_created_on | datetime | YES | MUL | NULL | |
| log_created_by | int(11) | YES | NULL | ||
| log_modified_on | datetime | YES | NULL | ||
| log_modified_by | int(11) | YES | NULL |
mt_notification
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| notification_id | int(11) | NO | PRI | NULL | auto_increment |
| notification_blog_id | int(11) | NO | MUL | NULL | |
| notification_email | varchar(75) | YES | MUL | NULL | |
| notification_name | varchar(50) | YES | NULL | ||
| notification_url | varchar(255) | YES | NULL | ||
| notification_created_on | datetime | YES | NULL | ||
| notification_created_by | int(11) | YES | NULL | ||
| notification_modified_on | datetime | YES | NULL | ||
| notification_modified_by | int(11) | YES | NULL |
mt_objectasset
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| objectasset_id | int(11) | NO | PRI | NULL | auto_increment |
| objectasset_asset_id | int(11) | NO | MUL | NULL | |
| objectasset_blog_id | int(11) | YES | MUL | NULL | |
| objectasset_object_ds | varchar(50) | NO | MUL | NULL | |
| objectasset_object_id | int(11) | NO | MUL | NULL | |
| objectasset_embedded | tinyint(4) | YES | 0 |
mt_objectscore
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| objectscore_id | int(11) | NO | PRI | NULL | auto_increment |
| objectscore_author_id | int(11) | YES | MUL | 0 | |
| objectscore_created_by | int(11) | YES | NULL | ||
| objectscore_created_on | datetime | YES | NULL | ||
| objectscore_modified_by | int(11) | YES | NULL | ||
| objectscore_modified_on | datetime | YES | NULL | ||
| objectscore_namespace | varchar(100) | NO | MUL | NULL | |
| objectscore_object_ds | varchar(50) | NO | MUL | NULL | |
| objectscore_object_id | int(11) | YES | MUL | 0 | |
| objectscore_score | float | YES | NULL | ||
| objectscore_ip | varchar(50) | YES | NULL |
mt_objecttag
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| objecttag_id | int(11) | NO | PRI | NULL | auto_increment |
| objecttag_blog_id | int(11) | YES | MUL | NULL | |
| objecttag_object_datasource | varchar(50) | NO | MUL | NULL | |
| objecttag_object_id | int(11) | NO | MUL | NULL | |
| objecttag_tag_id | int(11) | NO | MUL | NULL |
mt_permission
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| permission_id | int(11) | NO | PRI | NULL | auto_increment |
| permission_author_id | int(11) | NO | MUL | NULL | |
| permission_blog_id | int(11) | NO | MUL | NULL | |
| permission_blog_prefs | varchar(255) | YES | NULL | ||
| permission_entry_prefs | mediumtext | YES | NULL | ||
| permission_role_mask | int(11) | YES | MUL | NULL | |
| permission_template_prefs | varchar(255) | YES | NULL | ||
| permission_permissions | mediumtext | YES | NULL | ||
| permission_modified_on | datetime | YES | NULL | ||
| permission_created_on | datetime | YES | NULL | ||
| permission_modified_by | int(11) | YES | NULL | ||
| permission_created_by | int(11) | YES | NULL | ||
| permission_restrictions | mediumtext | YES | NULL | ||
| permission_page_prefs | mediumtext | YES | NULL |
mt_placement
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| placement_id | int(11) | NO | PRI | NULL | auto_increment |
| placement_blog_id | int(11) | NO | MUL | NULL | |
| placement_category_id | int(11) | NO | MUL | NULL | |
| placement_entry_id | int(11) | NO | MUL | NULL | |
| placement_is_primary | tinyint(4) | NO | MUL | NULL |
mt_plugindata
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| plugindata_id | int(11) | NO | PRI | NULL | auto_increment |
| plugindata_data | mediumblob | YES | NULL | ||
| plugindata_key | varchar(255) | NO | MUL | NULL | |
| plugindata_plugin | varchar(50) | NO | MUL | NULL |
mt_role
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| role_id | int(11) | NO | PRI | NULL | auto_increment |
| role_created_by | int(11) | YES | NULL | ||
| role_created_on | datetime | YES | MUL | NULL | |
| role_description | mediumtext | YES | NULL | ||
| role_is_system | tinyint(4) | YES | MUL | 0 | |
| role_modified_by | int(11) | YES | NULL | ||
| role_modified_on | datetime | YES | NULL | ||
| role_name | varchar(255) | NO | MUL | NULL | |
| role_permissions | mediumtext | YES | NULL | ||
| role_role_mask | int(11) | YES | NULL | ||
| role_role_mask2 | int(11) | YES | NULL | ||
| role_role_mask3 | int(11) | YES | NULL | ||
| role_role_mask4 | int(11) | YES | NULL |
mt_session
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| session_data | mediumblob | YES | NULL | ||
| session_email | varchar(255) | YES | NULL | ||
| session_id | varchar(80) | NO | PRI | NULL | |
| session_kind | varchar(2) | YES | MUL | NULL | |
| session_name | varchar(255) | YES | MUL | NULL | |
| session_start | int(11) | NO | MUL | NULL | |
| session_duration | int(11) | YES | MUL | NULL |
mt_tag
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| tag_id | int(11) | NO | PRI | NULL | auto_increment |
| tag_is_private | tinyint(4) | YES | MUL | 0 | |
| tag_n8d_id | int(11) | YES | MUL | 0 | |
| tag_name | varchar(255) | NO | MUL | NULL |
mt_tbping
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| tbping_id | int(11) | NO | PRI | NULL | auto_increment |
| tbping_blog_id | int(11) | NO | MUL | NULL | |
| tbping_blog_name | varchar(255) | YES | NULL | ||
| tbping_excerpt | mediumtext | YES | NULL | ||
| tbping_ip | varchar(50) | NO | MUL | NULL | |
| tbping_junk_log | mediumtext | YES | NULL | ||
| tbping_junk_score | float | YES | MUL | NULL | |
| tbping_junk_status | smallint(6) | NO | MUL | 0 | |
| tbping_last_moved_on | datetime | NO | MUL | 2000-01-01 00:00:00 | |
| tbping_source_url | varchar(255) | YES | NULL | ||
| tbping_tb_id | int(11) | NO | MUL | NULL | |
| tbping_title | varchar(255) | YES | NULL | ||
| tbping_visible | tinyint(4) | YES | MUL | NULL | |
| tbping_created_on | datetime | YES | MUL | NULL | |
| tbping_created_by | int(11) | YES | NULL | ||
| tbping_modified_on | datetime | YES | NULL | ||
| tbping_modified_by | int(11) | YES | NULL |
mt_tbping_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| tbping_meta_tbping_id | int(11) | NO | PRI | NULL | |
| tbping_meta_type | varchar(75) | NO | PRI | NULL | |
| tbping_meta_vchar | varchar(255) | YES | NULL | ||
| tbping_meta_vchar_idx | varchar(255) | YES | NULL | ||
| tbping_meta_vdatetime | datetime | YES | NULL | ||
| tbping_meta_vdatetime_idx | datetime | YES | NULL | ||
| tbping_meta_vinteger | int(11) | YES | NULL | ||
| tbping_meta_vinteger_idx | int(11) | YES | NULL | ||
| tbping_meta_vfloat | float | YES | NULL | ||
| tbping_meta_vfloat_idx | float | YES | NULL | ||
| tbping_meta_vblob | mediumblob | YES | NULL | ||
| tbping_meta_vclob | mediumtext | YES | NULL |
mt_template
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| template_id | int(11) | NO | PRI | NULL | auto_increment |
| template_blog_id | int(11) | NO | MUL | NULL | |
| template_build_dynamic | tinyint(4) | YES | MUL | 0 | |
| template_linked_file | varchar(255) | YES | NULL | ||
| template_linked_file_mtime | varchar(10) | YES | NULL | ||
| template_linked_file_size | int(11) | YES | NULL | ||
| template_name | varchar(255) | NO | MUL | NULL | |
| template_outfile | varchar(255) | YES | MUL | NULL | |
| template_rebuild_me | tinyint(4) | YES | 1 | ||
| template_text | mediumtext | YES | NULL | ||
| template_type | varchar(25) | NO | MUL | NULL | |
| template_created_on | datetime | YES | NULL | ||
| template_created_by | int(11) | YES | NULL | ||
| template_modified_on | datetime | YES | NULL | ||
| template_modified_by | int(11) | YES | NULL | ||
| template_identifier | varchar(50) | YES | MUL | NULL | |
| template_build_interval | int(11) | YES | NULL | ||
| template_build_type | smallint(6) | YES | NULL | ||
| template_current_revision | int(11) | NO | 0 |
mt_template_meta
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| template_meta_template_id | int(11) | NO | PRI | NULL | |
| template_meta_type | varchar(75) | NO | PRI | NULL | |
| template_meta_vchar | varchar(255) | YES | NULL | ||
| template_meta_vchar_idx | varchar(255) | YES | NULL | ||
| template_meta_vdatetime | datetime | YES | NULL | ||
| template_meta_vdatetime_idx | datetime | YES | NULL | ||
| template_meta_vinteger | int(11) | YES | NULL | ||
| template_meta_vinteger_idx | int(11) | YES | NULL | ||
| template_meta_vfloat | float | YES | NULL | ||
| template_meta_vfloat_idx | float | YES | NULL | ||
| template_meta_vblob | mediumblob | YES | NULL | ||
| template_meta_vclob | mediumtext | YES | NULL |
mt_template_rev
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| template_rev_id | int(11) | NO | PRI | NULL | auto_increment |
| template_rev_changed | varchar(255) | NO | NULL | ||
| template_rev_created_by | int(11) | YES | NULL | ||
| template_rev_created_on | datetime | YES | NULL | ||
| template_rev_description | varchar(255) | YES | NULL | ||
| template_rev_label | varchar(255) | YES | NULL | ||
| template_rev_modified_by | int(11) | YES | NULL | ||
| template_rev_modified_on | datetime | YES | NULL | ||
| template_rev_rev_number | int(11) | NO | 0 | ||
| template_rev_template | mediumblob | NO | NULL | ||
| template_rev_template_id | int(11) | NO | MUL | NULL |
mt_templatemap
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| templatemap_id | int(11) | NO | PRI | NULL | auto_increment |
| templatemap_archive_type | varchar(25) | NO | MUL | NULL | |
| templatemap_blog_id | int(11) | NO | MUL | NULL | |
| templatemap_file_template | varchar(255) | YES | NULL | ||
| templatemap_is_preferred | tinyint(4) | YES | MUL | NULL | |
| templatemap_template_id | int(11) | NO | MUL | NULL | |
| templatemap_build_interval | int(11) | YES | NULL | ||
| templatemap_build_type | smallint(6) | YES | 1 |
mt_touch
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| touch_id | int(11) | NO | PRI | NULL | auto_increment |
| touch_blog_id | int(11) | YES | MUL | NULL | |
| touch_modified_on | datetime | YES | NULL | ||
| touch_object_type | varchar(255) | YES | NULL |
mt_trackback
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| trackback_id | int(11) | NO | PRI | NULL | auto_increment |
| trackback_blog_id | int(11) | NO | MUL | NULL | |
| trackback_category_id | int(11) | NO | MUL | 0 | |
| trackback_description | mediumtext | YES | NULL | ||
| trackback_entry_id | int(11) | NO | MUL | 0 | |
| trackback_is_disabled | tinyint(4) | YES | 0 | ||
| trackback_passphrase | varchar(30) | YES | NULL | ||
| trackback_rss_file | varchar(255) | YES | NULL | ||
| trackback_title | varchar(255) | YES | NULL | ||
| trackback_url | varchar(255) | YES | NULL | ||
| trackback_created_on | datetime | YES | MUL | NULL | |
| trackback_created_by | int(11) | YES | NULL | ||
| trackback_modified_on | datetime | YES | NULL | ||
| trackback_modified_by | int(11) | YES | NULL |
mt_ts_error
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ts_error_error_time | int(11) | NO | MUL | NULL | |
| ts_error_funcid | int(11) | NO | MUL | 0 | |
| ts_error_jobid | int(11) | NO | MUL | NULL | |
| ts_error_message | varchar(255) | NO | NULL |
mt_ts_exitstatus
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ts_exitstatus_jobid | int(11) | NO | PRI | NULL | |
| ts_exitstatus_completion_time | int(11) | YES | NULL | ||
| ts_exitstatus_delete_after | int(11) | YES | MUL | NULL | |
| ts_exitstatus_funcid | int(11) | NO | MUL | NULL | |
| ts_exitstatus_status | int(11) | YES | NULL |
mt_ts_funcmap
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ts_funcmap_funcid | int(11) | NO | PRI | NULL | auto_increment |
| ts_funcmap_funcname | varchar(255) | NO | UNI | NULL |
mt_ts_job
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ts_job_jobid | int(11) | NO | PRI | NULL | auto_increment |
| ts_job_arg | mediumblob | YES | NULL | ||
| ts_job_coalesce | varchar(255) | YES | MUL | NULL | |
| ts_job_funcid | int(11) | NO | MUL | NULL | |
| ts_job_grabbed_until | int(11) | NO | NULL | ||
| ts_job_insert_time | int(11) | YES | NULL | ||
| ts_job_priority | int(11) | YES | NULL | ||
| ts_job_run_after | int(11) | NO | MUL | NULL | |
| ts_job_uniqkey | varchar(255) | YES | MUL | NULL |
mt_visitorstats_view
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| visitorstats_view_id | int(11) | NO | PRI | NULL | auto_increment |
| visitorstats_view_author_id | int(11) | YES | MUL | NULL | |
| visitorstats_view_blog_id | int(11) | NO | MUL | NULL | |
| visitorstats_view_created_by | int(11) | YES | NULL | ||
| visitorstats_view_created_on | datetime | YES | MUL | NULL | |
| visitorstats_view_modified_by | int(11) | YES | NULL | ||
| visitorstats_view_modified_on | datetime | YES | NULL | ||
| visitorstats_view_obj_id | int(11) | YES | MUL | NULL | |
| visitorstats_view_obj_type | varchar(50) | YES | MUL | NULL | |
| visitorstats_view_session_id | varchar(80) | YES | NULL | ||
| visitorstats_view_url | varchar(255) | NO | NULL | ||
| visitorstats_view_visitor_id | int(11) | YES | MUL | NULL |
mt_visitorstats_visitor
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| visitorstats_visitor_id | int(11) | NO | PRI | NULL | auto_increment |
| visitorstats_visitor_author_id | int(11) | YES | MUL | NULL | |
| visitorstats_visitor_blog_id | int(11) | NO | MUL | NULL | |
| visitorstats_visitor_created_by | int(11) | YES | NULL | ||
| visitorstats_visitor_created_on | datetime | YES | MUL | NULL | |
| visitorstats_visitor_ip | varchar(100) | NO | NULL | ||
| visitorstats_visitor_modified_by | int(11) | YES | NULL | ||
| visitorstats_visitor_modified_on | datetime | YES | NULL | ||
| visitorstats_visitor_referrer | varchar(255) | YES | NULL |