Variable
Value
mbname
TurtleKickers
boardurl
https://www.turtlekickers.com
db_server
localhost
db_name
vtbsdnet_turtlekickers
db_prefix
smf_
language
english
db_type
mysql
db_character_set
utf8
db_mb4
NOT SET


Variable
Value
smfVersion
2.1.4




Name
Engine
Collation
Name
Engine
Collation
smf_admin_info_files
InnoDB
utf8mb3_general_ci
smf_admin_info_files
InnoDB
utf8_general_ci
botbanishclient_ip
InnoDB
utf8mb3_general_ci
botbanishclient_ip_dnb
InnoDB
utf8mb3_general_ci
botbanishclient_spiders_bad
InnoDB
utf8mb3_general_ci
botbanishclient_spiders_good
InnoDB
utf8mb3_general_ci
botbanishclient_url_dnc
InnoDB
utf8mb3_general_ci
smf_approval_queue
InnoDB
utf8mb3_general_ci
smf_approval_queue
InnoDB
utf8_general_ci
smf_arcade_categories
InnoDB
utf8mb3_general_ci
smf_arcade_favorite
InnoDB
utf8mb3_general_ci
smf_arcade_files
InnoDB
utf8mb3_general_ci
smf_arcade_game_info
InnoDB
utf8mb3_general_ci
smf_arcade_games
InnoDB
utf8mb3_general_ci
smf_arcade_guest_data
InnoDB
utf8mb3_general_ci
smf_arcade_guest_extra_data
InnoDB
utf8mb3_general_ci
smf_arcade_internal_game_conflicts
InnoDB
utf8mb3_general_ci
smf_arcade_internal_gamedata
InnoDB
utf8mb3_general_ci
smf_arcade_lists
InnoDB
utf8mb3_general_ci
smf_arcade_matches
InnoDB
utf8mb3_general_ci
smf_arcade_matches_players
InnoDB
utf8mb3_general_ci
smf_arcade_matches_results
InnoDB
utf8mb3_general_ci
smf_arcade_matches_rounds
InnoDB
utf8mb3_general_ci
smf_arcade_member_data
InnoDB
utf8mb3_general_ci
smf_arcade_membergroups
InnoDB
utf8mb3_general_ci
smf_arcade_members
InnoDB
utf8mb3_general_ci
smf_arcade_mobile_lists
InnoDB
utf8mb3_general_ci
smf_arcade_mobile_skins
InnoDB
utf8mb3_general_ci
smf_arcade_newshouts
InnoDB
utf8mb3_general_ci
smf_arcade_pdl1
InnoDB
utf8mb3_general_ci
smf_arcade_pdl2
InnoDB
utf8mb3_general_ci
smf_arcade_rates
InnoDB
utf8mb3_general_ci
smf_arcade_scores
InnoDB
utf8mb3_general_ci
smf_arcade_skins
InnoDB
utf8mb3_general_ci
smf_attachments
InnoDB
utf8mb3_general_ci
smf_attachments
InnoDB
utf8_general_ci
smf_background_tasks
InnoDB
utf8mb3_general_ci
smf_background_tasks
InnoDB
utf8_general_ci
smf_ban_groups
InnoDB
utf8mb3_general_ci
smf_ban_groups
InnoDB
utf8_general_ci
smf_ban_items
InnoDB
utf8mb3_general_ci
smf_ban_items
InnoDB
utf8_general_ci
smf_battle_campaign_1
InnoDB
utf8mb3_general_ci
smf_battle_campaign_2
InnoDB
utf8mb3_general_ci
smf_battle_campaign_3
InnoDB
utf8mb3_general_ci
smf_battle_champs
InnoDB
utf8mb3_general_ci
smf_battle_explore
InnoDB
utf8mb3_general_ci
smf_battle_graveyard
InnoDB
utf8mb3_general_ci
smf_battle_history
InnoDB
utf8mb3_general_ci
smf_battle_members
InnoDB
utf8mb3_general_ci
smf_battle_monsters
InnoDB
utf8mb3_general_ci
smf_battle_monsters_fight
InnoDB
utf8mb3_general_ci
smf_battle_quest
InnoDB
utf8mb3_general_ci
smf_battle_quest_champs
InnoDB
utf8mb3_general_ci
smf_battle_scores
InnoDB
utf8mb3_general_ci
smf_battle_shop
InnoDB
utf8mb3_general_ci
smf_battle_shouts
InnoDB
utf8mb3_general_ci
smf_board_permissions
InnoDB
utf8mb3_general_ci
smf_board_permissions
InnoDB
utf8_general_ci
smf_board_permissions_view
InnoDB
utf8mb3_general_ci
smf_board_permissions_view
InnoDB
utf8_general_ci
smf_boards
InnoDB
utf8mb3_general_ci
smf_boards
InnoDB
utf8_general_ci
smf_calendar
InnoDB
utf8mb3_general_ci
smf_calendar
InnoDB
utf8_general_ci
smf_calendar_holidays
InnoDB
utf8mb3_general_ci
smf_calendar_holidays
InnoDB
utf8_general_ci
smf_categories
InnoDB
utf8mb3_general_ci
smf_categories
InnoDB
utf8_general_ci
smf_custom_fields
InnoDB
utf8mb3_general_ci
smf_custom_fields
InnoDB
utf8_general_ci
smf_feedback
MyISAM
utf8mb3_general_ci
smf_group_moderators
InnoDB
utf8mb3_general_ci
smf_group_moderators
InnoDB
utf8_general_ci
smf_log_actions
InnoDB
utf8mb3_general_ci
smf_log_actions
InnoDB
utf8_general_ci
smf_log_activity
InnoDB
utf8mb3_general_ci
smf_log_activity
InnoDB
utf8_general_ci
smf_log_banned
InnoDB
utf8mb3_general_ci
smf_log_banned
InnoDB
utf8_general_ci
smf_log_boards
InnoDB
utf8mb3_general_ci
smf_log_boards
InnoDB
utf8_general_ci
smf_log_comments
InnoDB
utf8mb3_general_ci
smf_log_comments
InnoDB
utf8_general_ci
smf_log_digest
InnoDB
utf8mb3_general_ci
smf_log_digest
InnoDB
utf8_general_ci
smf_log_errors
InnoDB
utf8mb3_general_ci
smf_log_errors
InnoDB
utf8_general_ci
smf_log_floodcontrol
InnoDB
utf8mb3_general_ci
smf_log_floodcontrol
InnoDB
utf8_general_ci
smf_log_group_requests
InnoDB
utf8mb3_general_ci
smf_log_group_requests
InnoDB
utf8_general_ci
smf_log_mark_read
InnoDB
utf8mb3_general_ci
smf_log_mark_read
InnoDB
utf8_general_ci
smf_log_member_notices
InnoDB
utf8mb3_general_ci
smf_log_member_notices
InnoDB
utf8_general_ci
smf_log_notify
InnoDB
utf8mb3_general_ci
smf_log_notify
InnoDB
utf8_general_ci
smf_log_online
InnoDB
utf8mb3_general_ci
smf_log_online
InnoDB
utf8_general_ci
smf_log_packages
InnoDB
utf8mb3_general_ci
smf_log_packages
InnoDB
utf8_general_ci
smf_log_polls
InnoDB
utf8mb3_general_ci
smf_log_polls
InnoDB
utf8_general_ci
smf_log_reported
InnoDB
utf8mb3_general_ci
smf_log_reported
InnoDB
utf8_general_ci
smf_log_reported_comments
InnoDB
utf8mb3_general_ci
smf_log_reported_comments
InnoDB
utf8_general_ci
smf_log_scheduled_tasks
InnoDB
utf8mb3_general_ci
smf_log_scheduled_tasks
InnoDB
utf8_general_ci
smf_log_search_messages
InnoDB
utf8mb3_general_ci
smf_log_search_messages
InnoDB
utf8_general_ci
smf_log_search_results
InnoDB
utf8mb3_general_ci
smf_log_search_results
InnoDB
utf8_general_ci
smf_log_search_subjects
InnoDB
utf8mb3_general_ci
smf_log_search_subjects
InnoDB
utf8_general_ci
smf_log_search_topics
InnoDB
utf8mb3_general_ci
smf_log_search_topics
InnoDB
utf8_general_ci
smf_log_sfs
InnoDB
utf8mb3_general_ci
smf_log_spider_hits
InnoDB
utf8mb3_general_ci
smf_log_spider_hits
InnoDB
utf8_general_ci
smf_log_spider_stats
InnoDB
utf8mb3_general_ci
smf_log_spider_stats
InnoDB
utf8_general_ci
smf_log_subscribed
InnoDB
utf8mb3_general_ci
smf_log_subscribed
InnoDB
utf8_general_ci
smf_log_topics
InnoDB
utf8mb3_general_ci
smf_log_topics
InnoDB
utf8_general_ci
smf_mail_queue
InnoDB
utf8mb3_general_ci
smf_mail_queue
InnoDB
utf8_general_ci
smf_mediapro_cache
MyISAM
utf8mb3_unicode_ci
smf_mediapro_sites
MyISAM
utf8mb3_unicode_ci
smf_member_logins
InnoDB
utf8mb3_general_ci
smf_member_logins
InnoDB
utf8_general_ci
smf_membergroups
InnoDB
utf8mb3_general_ci
smf_membergroups
InnoDB
utf8_general_ci
smf_members
InnoDB
utf8mb3_general_ci
smf_members
InnoDB
utf8_general_ci
smf_mentions
InnoDB
utf8mb3_general_ci
smf_mentions
InnoDB
utf8_general_ci
smf_message_icons
InnoDB
utf8mb3_general_ci
smf_message_icons
InnoDB
utf8_general_ci
smf_messages
InnoDB
utf8mb3_general_ci
smf_messages
InnoDB
utf8_general_ci
smf_moderator_groups
InnoDB
utf8mb3_general_ci
smf_moderator_groups
InnoDB
utf8_general_ci
smf_moderators
InnoDB
utf8mb3_general_ci
smf_moderators
InnoDB
utf8_general_ci
smf_package_servers
InnoDB
utf8mb3_general_ci
smf_package_servers
InnoDB
utf8_general_ci
smf_permission_profiles
InnoDB
utf8mb3_general_ci
smf_permission_profiles
InnoDB
utf8_general_ci
smf_permissions
InnoDB
utf8mb3_general_ci
smf_permissions
InnoDB
utf8_general_ci
smf_personal_messages
InnoDB
utf8mb3_general_ci
smf_personal_messages
InnoDB
utf8_general_ci
smf_pm_labeled_messages
InnoDB
utf8mb3_general_ci
smf_pm_labeled_messages
InnoDB
utf8_general_ci
smf_pm_labels
InnoDB
utf8mb3_general_ci
smf_pm_labels
InnoDB
utf8_general_ci
smf_pm_recipients
InnoDB
utf8mb3_general_ci
smf_pm_recipients
InnoDB
utf8_general_ci
smf_pm_rules
InnoDB
utf8mb3_general_ci
smf_pm_rules
InnoDB
utf8_general_ci
smf_poll_choices
InnoDB
utf8mb3_general_ci
smf_poll_choices
InnoDB
utf8_general_ci
smf_polls
InnoDB
utf8mb3_general_ci
smf_polls
InnoDB
utf8_general_ci
smf_qanda
InnoDB
utf8mb3_general_ci
smf_qanda
InnoDB
utf8_general_ci
smf_quiz
InnoDB
utf8mb3_general_ci
smf_quiz_answer
InnoDB
utf8mb3_general_ci
smf_quiz_category
InnoDB
utf8mb3_general_ci
smf_quiz_dispute
InnoDB
utf8mb3_general_ci
smf_quiz_infoboard
InnoDB
utf8mb3_general_ci
smf_quiz_league
InnoDB
utf8mb3_general_ci
smf_quiz_league_result
InnoDB
utf8mb3_general_ci
smf_quiz_league_table
InnoDB
utf8mb3_general_ci
smf_quiz_question
InnoDB
utf8mb3_general_ci
smf_quiz_question_type
InnoDB
utf8mb3_general_ci
smf_quiz_result
InnoDB
utf8mb3_general_ci
smf_quiz_session
InnoDB
utf8mb3_general_ci
smf_scheduled_tasks
InnoDB
utf8mb3_general_ci
smf_scheduled_tasks
InnoDB
utf8_general_ci
smf_sessions
InnoDB
utf8mb3_general_ci
smf_sessions
InnoDB
utf8_general_ci
smf_settings
InnoDB
utf8mb3_general_ci
smf_settings
InnoDB
utf8_general_ci
smf_smiley_files
InnoDB
utf8mb3_general_ci
smf_smiley_files
InnoDB
utf8_general_ci
smf_smileys
InnoDB
utf8mb3_general_ci
smf_smileys
InnoDB
utf8_general_ci
smf_spiders
InnoDB
utf8mb3_general_ci
smf_spiders
InnoDB
utf8_general_ci
smf_stshop_categories
InnoDB
utf8mb3_general_ci
smf_stshop_inventory
InnoDB
utf8mb3_general_ci
smf_stshop_items
InnoDB
utf8mb3_general_ci
smf_stshop_log_bank
InnoDB
utf8mb3_general_ci
smf_stshop_log_buy
InnoDB
utf8mb3_general_ci
smf_stshop_log_content
InnoDB
utf8mb3_general_ci
smf_stshop_log_games
InnoDB
utf8mb3_general_ci
smf_stshop_log_gift
InnoDB
utf8mb3_general_ci
smf_stshop_modules
InnoDB
utf8mb3_general_ci
smf_subscriptions
InnoDB
utf8mb3_general_ci
smf_subscriptions
InnoDB
utf8_general_ci
smf_themes
InnoDB
utf8mb3_general_ci
smf_themes
InnoDB
utf8_general_ci
smf_topic_ratings
InnoDB
utf8mb3_general_ci
smf_topics
InnoDB
utf8mb3_general_ci
smf_topics
InnoDB
utf8_general_ci
smf_tp_articles
InnoDB
utf8mb3_general_ci
smf_tp_blocks
InnoDB
utf8mb3_general_ci
smf_tp_comments
InnoDB
utf8mb3_general_ci
smf_tp_data
InnoDB
utf8mb3_general_ci
smf_tp_dldata
InnoDB
utf8mb3_general_ci
smf_tp_dlmanager
InnoDB
utf8mb3_general_ci
smf_tp_events
InnoDB
utf8mb3_general_ci
smf_tp_menu
InnoDB
utf8mb3_general_ci
smf_tp_settings
InnoDB
utf8mb3_general_ci
smf_tp_shoutbox
InnoDB
utf8mb3_general_ci
smf_tp_variables
InnoDB
utf8mb3_general_ci
smf_tweet_cache
InnoDB
utf8mb3_general_ci
backup_smf_admin_info_files
InnoDB
utf8mb3_general_ci
backup_smf_approval_queue
InnoDB
utf8mb3_general_ci
backup_smf_arcade_categories
InnoDB
utf8mb3_general_ci
backup_smf_arcade_favorite
InnoDB
utf8mb3_general_ci
backup_smf_arcade_files
InnoDB
utf8mb3_general_ci
backup_smf_arcade_game_info
InnoDB
utf8mb3_general_ci
backup_smf_arcade_games
InnoDB
utf8mb3_general_ci
backup_smf_arcade_guest_data
InnoDB
utf8mb3_general_ci
backup_smf_arcade_guest_extra_data
InnoDB
utf8mb3_general_ci
backup_smf_arcade_lists
InnoDB
utf8mb3_general_ci
backup_smf_arcade_matches
InnoDB
utf8mb3_general_ci
backup_smf_arcade_matches_players
InnoDB
utf8mb3_general_ci
backup_smf_arcade_matches_results
InnoDB
utf8mb3_general_ci
backup_smf_arcade_matches_rounds
InnoDB
utf8mb3_general_ci
backup_smf_arcade_member_data
InnoDB
utf8mb3_general_ci
backup_smf_arcade_membergroups
InnoDB
utf8mb3_general_ci
backup_smf_arcade_members
InnoDB
utf8mb3_general_ci
backup_smf_arcade_mobile_lists
InnoDB
utf8mb3_general_ci
backup_smf_arcade_mobile_skins
InnoDB
utf8mb3_general_ci
backup_smf_arcade_newshouts
InnoDB
utf8mb3_general_ci
backup_smf_arcade_pdl1
InnoDB
utf8mb3_general_ci
backup_smf_arcade_pdl2
InnoDB
utf8mb3_general_ci
backup_smf_arcade_rates
InnoDB
utf8mb3_general_ci
backup_smf_arcade_scores
InnoDB
utf8mb3_general_ci
backup_smf_arcade_skins
InnoDB
utf8mb3_general_ci
backup_smf_attachments
InnoDB
utf8mb3_general_ci
backup_smf_background_tasks
InnoDB
utf8mb3_general_ci
backup_smf_ban_groups
InnoDB
utf8mb3_general_ci
backup_smf_ban_items
InnoDB
utf8mb3_general_ci
backup_smf_battle_campaign_1
InnoDB
utf8mb3_general_ci
backup_smf_battle_campaign_2
InnoDB
utf8mb3_general_ci
backup_smf_battle_campaign_3
InnoDB
utf8mb3_general_ci
backup_smf_battle_champs
InnoDB
utf8mb3_general_ci
backup_smf_battle_explore
InnoDB
utf8mb3_general_ci
backup_smf_battle_graveyard
InnoDB
utf8mb3_general_ci
backup_smf_battle_history
InnoDB
utf8mb3_general_ci
backup_smf_battle_members
InnoDB
utf8mb3_general_ci
backup_smf_battle_monsters
InnoDB
utf8mb3_general_ci
backup_smf_battle_monsters_fight
InnoDB
utf8mb3_general_ci
backup_smf_battle_quest
InnoDB
utf8mb3_general_ci
backup_smf_battle_quest_champs
InnoDB
utf8mb3_general_ci
backup_smf_battle_scores
InnoDB
utf8mb3_general_ci
backup_smf_battle_shop
InnoDB
utf8mb3_general_ci
backup_smf_battle_shouts
InnoDB
utf8mb3_general_ci
backup_smf_board_permissions
InnoDB
utf8mb3_general_ci
backup_smf_board_permissions_view
InnoDB
utf8mb3_general_ci
backup_smf_boards
InnoDB
utf8mb3_general_ci
backup_smf_calendar
InnoDB
utf8mb3_general_ci
backup_smf_calendar_holidays
InnoDB
utf8mb3_general_ci
backup_smf_categories
InnoDB
utf8mb3_general_ci
backup_smf_custom_fields
InnoDB
utf8mb3_general_ci
backup_smf_feedback
MyISAM
utf8mb3_general_ci
backup_smf_group_moderators
InnoDB
utf8mb3_general_ci
backup_smf_log_actions
InnoDB
utf8mb3_general_ci
backup_smf_log_activity
InnoDB
utf8mb3_general_ci
backup_smf_log_banned
InnoDB
utf8mb3_general_ci
backup_smf_log_boards
InnoDB
utf8mb3_general_ci
backup_smf_log_comments
InnoDB
utf8mb3_general_ci
backup_smf_log_digest
InnoDB
utf8mb3_general_ci
backup_smf_log_errors
InnoDB
utf8mb3_general_ci
backup_smf_log_floodcontrol
InnoDB
utf8mb3_general_ci
backup_smf_log_group_requests
InnoDB
utf8mb3_general_ci
backup_smf_log_mark_read
InnoDB
utf8mb3_general_ci
backup_smf_log_member_notices
InnoDB
utf8mb3_general_ci
backup_smf_log_notify
InnoDB
utf8mb3_general_ci
backup_smf_log_online
InnoDB
utf8mb3_general_ci
backup_smf_log_packages
InnoDB
utf8mb3_general_ci
backup_smf_log_polls
InnoDB
utf8mb3_general_ci
backup_smf_log_reported
InnoDB
utf8mb3_general_ci
backup_smf_log_reported_comments
InnoDB
utf8mb3_general_ci
backup_smf_log_scheduled_tasks
InnoDB
utf8mb3_general_ci
backup_smf_log_search_messages
InnoDB
utf8mb3_general_ci
backup_smf_log_search_results
InnoDB
utf8mb3_general_ci
backup_smf_log_search_subjects
InnoDB
utf8mb3_general_ci
backup_smf_log_search_topics
InnoDB
utf8mb3_general_ci
backup_smf_log_spider_hits
InnoDB
utf8mb3_general_ci
backup_smf_log_spider_stats
InnoDB
utf8mb3_general_ci
backup_smf_log_subscribed
InnoDB
utf8mb3_general_ci
backup_smf_log_topics
InnoDB
utf8mb3_general_ci
backup_smf_mail_queue
InnoDB
utf8mb3_general_ci
backup_smf_mediapro_cache
MyISAM
utf8mb3_unicode_ci
backup_smf_mediapro_sites
MyISAM
utf8mb3_unicode_ci
backup_smf_member_logins
InnoDB
utf8mb3_general_ci
backup_smf_membergroups
InnoDB
utf8mb3_general_ci
backup_smf_members
InnoDB
utf8mb3_general_ci
backup_smf_mentions
InnoDB
utf8mb3_general_ci
backup_smf_message_icons
InnoDB
utf8mb3_general_ci
backup_smf_messages
InnoDB
utf8mb3_general_ci
backup_smf_moderator_groups
InnoDB
utf8mb3_general_ci
backup_smf_moderators
InnoDB
utf8mb3_general_ci
backup_smf_package_servers
InnoDB
utf8mb3_general_ci
backup_smf_permission_profiles
InnoDB
utf8mb3_general_ci
backup_smf_permissions
InnoDB
utf8mb3_general_ci
backup_smf_personal_messages
InnoDB
utf8mb3_general_ci
backup_smf_pm_labeled_messages
InnoDB
utf8mb3_general_ci
backup_smf_pm_labels
InnoDB
utf8mb3_general_ci
backup_smf_pm_recipients
InnoDB
utf8mb3_general_ci
backup_smf_pm_rules
InnoDB
utf8mb3_general_ci
backup_smf_poll_choices
InnoDB
utf8mb3_general_ci
backup_smf_polls
InnoDB
utf8mb3_general_ci
backup_smf_qanda
InnoDB
utf8mb3_general_ci
backup_smf_scheduled_tasks
InnoDB
utf8mb3_general_ci
backup_smf_sessions
InnoDB
utf8mb3_general_ci
backup_smf_settings
InnoDB
utf8mb3_general_ci
backup_smf_smiley_files
InnoDB
utf8mb3_general_ci
backup_smf_smileys
InnoDB
utf8mb3_general_ci
backup_smf_spiders
InnoDB
utf8mb3_general_ci
backup_smf_stshop_categories
InnoDB
utf8mb3_general_ci
backup_smf_stshop_inventory
InnoDB
utf8mb3_general_ci
backup_smf_stshop_items
InnoDB
utf8mb3_general_ci
backup_smf_stshop_log_bank
InnoDB
utf8mb3_general_ci
backup_smf_stshop_log_buy
InnoDB
utf8mb3_general_ci
backup_smf_stshop_log_content
InnoDB
utf8mb3_general_ci
backup_smf_stshop_log_games
InnoDB
utf8mb3_general_ci
backup_smf_stshop_log_gift
InnoDB
utf8mb3_general_ci
backup_smf_stshop_modules
InnoDB
utf8mb3_general_ci
backup_smf_subscriptions
InnoDB
utf8mb3_general_ci
backup_smf_themes
InnoDB
utf8mb3_general_ci
backup_smf_topic_ratings
InnoDB
utf8mb3_general_ci
backup_smf_topics
InnoDB
utf8mb3_general_ci
backup_smf_tp_articles
InnoDB
utf8mb3_general_ci
backup_smf_tp_blocks
InnoDB
utf8mb3_general_ci
backup_smf_tp_comments
InnoDB
utf8mb3_general_ci
backup_smf_tp_data
InnoDB
utf8mb3_general_ci
backup_smf_tp_dldata
InnoDB
utf8mb3_general_ci
backup_smf_tp_dlmanager
InnoDB
utf8mb3_general_ci
backup_smf_tp_events
InnoDB
utf8mb3_general_ci
backup_smf_tp_menu
InnoDB
utf8mb3_general_ci
backup_smf_tp_modules
InnoDB
utf8mb3_general_ci
backup_smf_tp_rates
InnoDB
utf8mb3_general_ci
backup_smf_tp_ratestats
InnoDB
utf8mb3_general_ci
backup_smf_tp_settings
InnoDB
utf8mb3_general_ci
backup_smf_tp_shoutbox
InnoDB
utf8mb3_general_ci
backup_smf_tp_variables
InnoDB
utf8mb3_general_ci
backup_smf_user_alerts
InnoDB
utf8mb3_general_ci
backup_smf_user_alerts_prefs
InnoDB
utf8mb3_general_ci
backup_smf_user_drafts
InnoDB
utf8mb3_general_ci
backup_smf_user_likes
InnoDB
utf8mb3_general_ci
smf_user_alerts
InnoDB
utf8mb3_general_ci
smf_user_alerts
InnoDB
utf8_general_ci
smf_user_alerts_prefs
InnoDB
utf8mb3_general_ci
smf_user_alerts_prefs
InnoDB
utf8_general_ci
smf_user_drafts
InnoDB
utf8mb3_general_ci
smf_user_drafts
InnoDB
utf8_general_ci
smf_user_likes
InnoDB
utf8mb3_general_ci
smf_user_likes
InnoDB
utf8_general_ci


TABLE_NAME
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_DEFAULT
EXTRA
COLLATION_NAME
TABLE_NAME
COLUMN_NAME
COLUMN_TYPE
IS_NULLABLE
COLUMN_DEFAULT
EXTRA
COLLATION_NAME
smf_admin_info_files
data
text
NO
null
utf8mb3_general_ci
smf_admin_info_files
data
text
NO
null
utf8_general_ci
smf_admin_info_files
filename
varchar(255)
NO
''
utf8mb3_general_ci
smf_admin_info_files
filename
varchar(255)
NO
utf8_general_ci
smf_admin_info_files
filetype
varchar(255)
NO
''
utf8mb3_general_ci
smf_admin_info_files
filetype
varchar(255)
NO
utf8_general_ci
smf_admin_info_files
id_file
tinyint(3) unsigned
NO
null
auto_increment
null
smf_admin_info_files
id_file
tinyint unsigned
NO
null
auto_increment
null
smf_admin_info_files
parameters
varchar(255)
NO
''
utf8mb3_general_ci
smf_admin_info_files
parameters
varchar(255)
NO
utf8_general_ci
smf_admin_info_files
path
varchar(255)
NO
''
utf8mb3_general_ci
smf_admin_info_files
path
varchar(255)
NO
utf8_general_ci
smf_approval_queue
id_attach
int(10) unsigned
NO
0
null
smf_approval_queue
id_attach
int unsigned
NO
0
null
smf_approval_queue
id_event
smallint(5) unsigned
NO
0
null
smf_approval_queue
id_event
smallint unsigned
NO
0
null
smf_approval_queue
id_msg
int(10) unsigned
NO
0
null
smf_approval_queue
id_msg
int unsigned
NO
0
null
smf_arcade_categories
cat_icon
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_categories
cat_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_categories
cat_order
int(10) unsigned
NO
1
null
smf_arcade_categories
id_cat
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_categories
member_groups
varchar(255)
NO
'-2,-1,0,2'
utf8mb3_general_ci
smf_arcade_categories
num_games
int(10) unsigned
NO
0
null
smf_arcade_categories
special
int(10) unsigned
NO
0
null
smf_arcade_favorite
id_favorite
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_favorite
id_game
int(10) unsigned
NO
null
null
smf_arcade_favorite
id_member
int(10) unsigned
NO
null
null
smf_arcade_files
file_type
varchar(30)
NO
'game'
utf8mb3_general_ci
smf_arcade_files
game_directory
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_files
game_file
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_files
game_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_files
id_file
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_files
id_game
int(10) unsigned
NO
null
null
smf_arcade_files
status
int(10) unsigned
NO
0
null
smf_arcade_files
submit_system
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_game_info
icon_position
int(10)
NO
0
null
smf_arcade_game_info
icon_position_hide
int(10)
NO
0
null
smf_arcade_game_info
id_game
int(10)
NO
null
null
smf_arcade_games
description
text
NO
null
utf8mb3_general_ci
smf_arcade_games
download
int(10) unsigned
NO
1
null
smf_arcade_games
enabled
int(10) unsigned
NO
0
null
smf_arcade_games
extra_data
text
NO
null
utf8mb3_general_ci
smf_arcade_games
game_directory
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_games
game_file
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_games
game_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_games
game_rating
float
NO
0
null
smf_arcade_games
help
text
NO
null
utf8mb3_general_ci
smf_arcade_games
id_cat
int(10) unsigned
NO
0
null
smf_arcade_games
id_champion
int(10) unsigned
NO
0
null
smf_arcade_games
id_champion_score
int(10) unsigned
NO
0
null
smf_arcade_games
id_game
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_games
id_topic
int(10) unsigned
NO
0
null
smf_arcade_games
internal_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_games
js_insertion
tinyint(1) unsigned
NO
0
null
smf_arcade_games
local_permissions
int(10) unsigned
NO
0
null
smf_arcade_games
member_groups
varchar(255)
NO
'-2,-1,0,2'
utf8mb3_general_ci
smf_arcade_games
num_favorites
int(10) unsigned
NO
0
null
smf_arcade_games
num_plays
int(10) unsigned
NO
0
null
smf_arcade_games
num_rates
int(10) unsigned
NO
0
null
smf_arcade_games
score_type
tinyint(3) unsigned
NO
0
null
smf_arcade_games
submit_system
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_games
thumbnail
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_games
thumbnail_small
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_guest_data
current_action
int(10) unsigned
NO
0
null
smf_arcade_guest_data
current_game
int(10) unsigned
NO
0
null
smf_arcade_guest_data
online_ip
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_guest_data
online_time
int(10) unsigned
NO
0
null
smf_arcade_guest_data
show_online
int(10) unsigned
NO
1
null
smf_arcade_guest_data
temp_name
varchar(250)
NO
''
utf8mb3_general_ci
smf_arcade_guest_extra_data
count
int(11)
YES
0
null
smf_arcade_guest_extra_data
day
int(10) unsigned
YES
0
null
smf_arcade_guest_extra_data
online_ip
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_guest_extra_data
year
int(10) unsigned
YES
0
null
smf_arcade_internal_game_conflicts
conflict_directory
varchar(255)
YES
''
utf8mb3_general_ci
smf_arcade_internal_game_conflicts
id_conflict
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_internal_game_conflicts
id_game
int(10)
YES
NULL
null
smf_arcade_internal_game_conflicts
internal_id_conflict
int(10)
YES
NULL
null
smf_arcade_internal_game_conflicts
internal_name_conflict
varchar(255)
YES
''
utf8mb3_general_ci
smf_arcade_internal_game_conflicts
submit_system_flag
int(10)
YES
NULL
null
smf_arcade_internal_gamedata
conflict_directory
varchar(255)
YES
''
utf8mb3_general_ci
smf_arcade_internal_gamedata
id_conflict
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_internal_gamedata
id_game
int(10)
YES
NULL
null
smf_arcade_internal_gamedata
internal_id_conflict
int(10)
YES
NULL
null
smf_arcade_internal_gamedata
internal_name_conflict
varchar(255)
YES
''
utf8mb3_general_ci
smf_arcade_internal_gamedata
submit_system_flag
int(10)
YES
NULL
null
smf_arcade_lists
enabled
int(10) unsigned
NO
0
null
smf_arcade_lists
id_list
int(11)
NO
null
auto_increment
null
smf_arcade_lists
list_function
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_lists
list_name
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_lists
list_source_file
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_lists
list_template
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_matches
created
int(10) unsigned
NO
0
null
smf_arcade_matches
current_players
int(10) unsigned
NO
1
null
smf_arcade_matches
current_round
int(10) unsigned
NO
0
null
smf_arcade_matches
id_match
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_matches
id_member
int(10) unsigned
NO
0
null
smf_arcade_matches
match_data
text
NO
null
utf8mb3_general_ci
smf_arcade_matches
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_matches
num_players
int(10) unsigned
NO
2
null
smf_arcade_matches
num_rounds
int(10) unsigned
NO
1
null
smf_arcade_matches
private_game
int(10) unsigned
NO
0
null
smf_arcade_matches
status
int(10) unsigned
NO
0
null
smf_arcade_matches
updated
int(10) unsigned
NO
0
null
smf_arcade_matches_players
id_match
int(10) unsigned
NO
null
null
smf_arcade_matches_players
id_member
int(10) unsigned
NO
null
null
smf_arcade_matches_players
player_data
text
NO
null
utf8mb3_general_ci
smf_arcade_matches_players
score
int(10) unsigned
NO
0
null
smf_arcade_matches_players
status
int(10) unsigned
NO
0
null
smf_arcade_matches_results
duration
float
NO
0
null
smf_arcade_matches_results
end_time
int(10) unsigned
NO
0
null
smf_arcade_matches_results
id_match
int(10) unsigned
NO
null
null
smf_arcade_matches_results
id_member
int(10) unsigned
NO
null
null
smf_arcade_matches_results
round
int(10) unsigned
NO
0
null
smf_arcade_matches_results
score
float
NO
0
null
smf_arcade_matches_results
score_status
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_matches_results
validate_hash
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_matches_rounds
id_game
int(10) unsigned
NO
null
null
smf_arcade_matches_rounds
id_match
int(10) unsigned
NO
null
null
smf_arcade_matches_rounds
round
int(10) unsigned
NO
0
null
smf_arcade_matches_rounds
status
int(10) unsigned
NO
0
null
smf_arcade_member_data
current_action
int(10) unsigned
NO
0
null
smf_arcade_member_data
current_game
int(10) unsigned
NO
0
null
smf_arcade_member_data
id_member
int(10) unsigned
NO
null
null
smf_arcade_member_data
online_color
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_member_data
online_ip
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_member_data
online_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_member_data
online_time
int(10) unsigned
NO
0
null
smf_arcade_member_data
show_online
int(10) unsigned
NO
0
null
smf_arcade_membergroups
download_limit
int(11)
YES
0
null
smf_arcade_membergroups
id_group
int(11)
NO
-2
null
smf_arcade_members
arcade_gametype
int(10) unsigned
NO
0
null
smf_arcade_members
archive_type
int(10) unsigned
NO
0
null
smf_arcade_members
arena_invite
int(10) unsigned
NO
0
null
smf_arcade_members
arena_match_end
int(10) unsigned
NO
0
null
smf_arcade_members
arena_new_round
int(10) unsigned
NO
0
null
smf_arcade_members
champion_email
int(10) unsigned
NO
0
null
smf_arcade_members
champion_pm
int(10) unsigned
NO
0
null
smf_arcade_members
detect_mobile
int(10) unsigned
YES
0
null
smf_arcade_members
games_per_page
int(10) unsigned
NO
0
null
smf_arcade_members
id_member
int(10) unsigned
NO
0
null
smf_arcade_members
list
int(10) unsigned
NO
0
null
smf_arcade_members
list_mobile
int(10) unsigned
NO
0
null
smf_arcade_members
new_champion_any
int(10) unsigned
NO
0
null
smf_arcade_members
new_champion_own
int(10) unsigned
NO
0
null
smf_arcade_members
new_game
int(10) unsigned
NO
0
null
smf_arcade_members
notify_game_reports
int(10) unsigned
YES
0
null
smf_arcade_members
scores_per_page
int(10) unsigned
NO
0
null
smf_arcade_members
skin
int(10) unsigned
NO
0
null
smf_arcade_members
skin_mobile
int(10) unsigned
NO
0
null
smf_arcade_mobile_lists
enabled
int(10) unsigned
NO
0
null
smf_arcade_mobile_lists
id_list
int(11)
NO
null
auto_increment
null
smf_arcade_mobile_lists
list_function
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_lists
list_name
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_lists
list_source_file
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_lists
list_template
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_skins
admin_function
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_skins
enabled
int(10) unsigned
NO
0
null
smf_arcade_mobile_skins
id_skin
int(11)
NO
null
auto_increment
null
smf_arcade_mobile_skins
skin_function
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_skins
skin_name
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_skins
skin_source_file
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_mobile_skins
skin_template
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_newshouts
content
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_newshouts
id_member
int(11)
NO
null
null
smf_arcade_newshouts
id_shout
int(11)
NO
null
auto_increment
null
smf_arcade_newshouts
time
int(11)
NO
null
null
smf_arcade_pdl1
count
int(10) unsigned
NO
null
null
smf_arcade_pdl1
day
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl1
id_member
int(10) unsigned
NO
null
null
smf_arcade_pdl1
latest_day
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl1
latest_year
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl1
permission
int(10) unsigned
NO
null
null
smf_arcade_pdl1
year
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl2
download_count
int(10) unsigned
NO
null
null
smf_arcade_pdl2
download_disable
int(10) unsigned
NO
null
null
smf_arcade_pdl2
game_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl2
pdl_gameid
int(10) unsigned
NO
null
null
smf_arcade_pdl2
report_day
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl2
report_id
int(10) unsigned
NO
null
null
smf_arcade_pdl2
report_reason
varchar(191)
NO
''
utf8mb3_general_ci
smf_arcade_pdl2
report_year
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_pdl2
user_id
int(10) unsigned
NO
null
null
smf_arcade_rates
id_game
int(10) unsigned
NO
null
null
smf_arcade_rates
id_member
int(10) unsigned
NO
null
null
smf_arcade_rates
rate_time
int(10) unsigned
NO
0
null
smf_arcade_rates
rating
int(10) unsigned
NO
0
null
smf_arcade_scores
champion_from
int(10) unsigned
NO
0
null
smf_arcade_scores
champion_to
int(10) unsigned
NO
0
null
smf_arcade_scores
comment
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_scores
duration
float
NO
null
null
smf_arcade_scores
end_time
int(10) unsigned
NO
null
null
smf_arcade_scores
id_game
int(10) unsigned
NO
null
null
smf_arcade_scores
id_member
int(10) unsigned
NO
null
null
smf_arcade_scores
id_score
int(10) unsigned
NO
null
auto_increment
null
smf_arcade_scores
member_ip
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_scores
personal_best
tinyint(3) unsigned
NO
0
null
smf_arcade_scores
player_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_scores
position
int(10) unsigned
NO
0
null
smf_arcade_scores
score
float
NO
null
null
smf_arcade_scores
score_status
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_scores
validate_hash
varchar(255)
NO
''
utf8mb3_general_ci
smf_arcade_skins
admin_function
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_skins
enabled
int(10) unsigned
NO
0
null
smf_arcade_skins
id_skin
int(11)
NO
null
auto_increment
null
smf_arcade_skins
skin_function
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_skins
skin_name
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_skins
skin_source_file
varchar(255)
NO
null
utf8mb3_general_ci
smf_arcade_skins
skin_template
varchar(255)
NO
null
utf8mb3_general_ci
smf_attachments
approved
tinyint(4)
NO
1
null
smf_attachments
approved
tinyint
NO
1
null
smf_attachments
attachment_type
tinyint(3) unsigned
NO
0
null
smf_attachments
attachment_type
tinyint unsigned
NO
0
null
smf_attachments
downloads
mediumint(8) unsigned
NO
0
null
smf_attachments
downloads
mediumint unsigned
NO
0
null
smf_attachments
file_hash
varchar(40)
NO
''
utf8mb3_general_ci
smf_attachments
file_hash
varchar(40)
NO
utf8_general_ci
smf_attachments
fileext
varchar(8)
NO
''
utf8mb3_general_ci
smf_attachments
fileext
varchar(8)
NO
utf8_general_ci
smf_attachments
filename
varchar(255)
NO
''
utf8mb3_general_ci
smf_attachments
filename
varchar(255)
NO
utf8_general_ci
smf_attachments
height
mediumint(8) unsigned
NO
0
null
smf_attachments
height
mediumint unsigned
NO
0
null
smf_attachments
id_attach
int(10) unsigned
NO
null
auto_increment
null
smf_attachments
id_attach
int unsigned
NO
null
auto_increment
null
smf_attachments
id_folder
tinyint(4)
NO
1
null
smf_attachments
id_folder
tinyint
NO
1
null
smf_attachments
id_member
mediumint(8) unsigned
NO
0
null
smf_attachments
id_member
mediumint unsigned
NO
0
null
smf_attachments
id_msg
int(10) unsigned
NO
0
null
smf_attachments
id_msg
int unsigned
NO
0
null
smf_attachments
id_thumb
int(10) unsigned
NO
0
null
smf_attachments
id_thumb
int unsigned
NO
0
null
smf_attachments
jpeg_quality
tinyint(3)
YES
100
null
smf_attachments
mime_type
varchar(128)
NO
''
utf8mb3_general_ci
smf_attachments
mime_type
varchar(128)
NO
utf8_general_ci
smf_attachments
proper_rotation
tinyint(3)
YES
0
null
smf_attachments
size
int(10) unsigned
NO
0
null
smf_attachments
size
int unsigned
NO
0
null
smf_attachments
width
mediumint(8) unsigned
NO
0
null
smf_attachments
width
mediumint unsigned
NO
0
null
smf_background_tasks
claimed_time
int(10) unsigned
NO
0
null
smf_background_tasks
claimed_time
int unsigned
NO
0
null
smf_background_tasks
id_task
int(10) unsigned
NO
null
auto_increment
null
smf_background_tasks
id_task
int unsigned
NO
null
auto_increment
null
smf_background_tasks
task_class
varchar(255)
NO
''
utf8mb3_general_ci
smf_background_tasks
task_class
varchar(255)
NO
utf8_general_ci
smf_background_tasks
task_data
mediumtext
NO
null
utf8mb3_general_ci
smf_background_tasks
task_data
mediumtext
NO
null
utf8_general_ci
smf_background_tasks
task_file
varchar(255)
NO
''
utf8mb3_general_ci
smf_background_tasks
task_file
varchar(255)
NO
utf8_general_ci
smf_ban_groups
ban_time
int(10) unsigned
NO
0
null
smf_ban_groups
ban_time
int unsigned
NO
0
null
smf_ban_groups
cannot_access
tinyint(3) unsigned
NO
0
null
smf_ban_groups
cannot_access
tinyint unsigned
NO
0
null
smf_ban_groups
cannot_login
tinyint(3) unsigned
NO
0
null
smf_ban_groups
cannot_login
tinyint unsigned
NO
0
null
smf_ban_groups
cannot_post
tinyint(3) unsigned
NO
0
null
smf_ban_groups
cannot_post
tinyint unsigned
NO
0
null
smf_ban_groups
cannot_register
tinyint(3) unsigned
NO
0
null
smf_ban_groups
cannot_register
tinyint unsigned
NO
0
null
smf_ban_groups
expire_time
int(10) unsigned
YES
NULL
null
smf_ban_groups
expire_time
int unsigned
YES
null
null
smf_ban_groups
id_ban_group
mediumint(8) unsigned
NO
null
auto_increment
null
smf_ban_groups
id_ban_group
mediumint unsigned
NO
null
auto_increment
null
smf_ban_groups
name
varchar(20)
NO
''
utf8mb3_general_ci
smf_ban_groups
name
varchar(20)
NO
utf8_general_ci
smf_ban_groups
notes
text
NO
null
utf8mb3_general_ci
smf_ban_groups
notes
text
NO
null
utf8_general_ci
smf_ban_groups
reason
varchar(255)
NO
''
utf8mb3_general_ci
smf_ban_groups
reason
varchar(255)
NO
utf8_general_ci
smf_ban_items
email_address
varchar(255)
NO
''
utf8mb3_general_ci
smf_ban_items
email_address
varchar(255)
NO
utf8_general_ci
smf_ban_items
hits
mediumint(8) unsigned
NO
0
null
smf_ban_items
hits
mediumint unsigned
NO
0
null
smf_ban_items
hostname
varchar(255)
NO
''
utf8mb3_general_ci
smf_ban_items
hostname
varchar(255)
NO
utf8_general_ci
smf_ban_items
id_ban
mediumint(8) unsigned
NO
null
auto_increment
null
smf_ban_items
id_ban
mediumint unsigned
NO
null
auto_increment
null
smf_ban_items
id_ban_group
smallint(5) unsigned
NO
0
null
smf_ban_items
id_ban_group
smallint unsigned
NO
0
null
smf_ban_items
id_member
mediumint(8) unsigned
NO
0
null
smf_ban_items
id_member
mediumint unsigned
NO
0
null
smf_ban_items
ip_high
varbinary(16)
YES
NULL
null
smf_ban_items
ip_high
varbinary(16)
YES
null
null
smf_ban_items
ip_low
varbinary(16)
YES
NULL
null
smf_ban_items
ip_low
varbinary(16)
YES
null
null
smf_battle_campaign_1
campaign_name
varchar(255)
YES
''
utf8mb3_general_ci
smf_battle_campaign_1
end_time
int(10) unsigned
YES
0
null
smf_battle_campaign_1
id_campaign
int(10) unsigned
YES
0
null
smf_battle_campaign_1
id_warrior
int(10) unsigned
NO
0
null
smf_battle_campaign_1
image
varchar(255)
YES
'blank.gif'
utf8mb3_general_ci
smf_battle_campaign_1
level_completion
int(10) unsigned
YES
0
null
smf_battle_campaign_1
quest_completions
int(10) unsigned
YES
0
null
smf_battle_campaign_1
score
int(10) unsigned
YES
0
null
smf_battle_campaign_1
start_time
int(10) unsigned
YES
0
null
smf_battle_campaign_1
timed_campaign
int(10) unsigned
YES
0
null
smf_battle_campaign_2
campaign_name
varchar(255)
YES
''
utf8mb3_general_ci
smf_battle_campaign_2
end_time
int(10) unsigned
YES
0
null
smf_battle_campaign_2
id_campaign
int(10) unsigned
YES
0
null
smf_battle_campaign_2
id_warrior
int(10) unsigned
NO
0
null
smf_battle_campaign_2
image
varchar(255)
YES
'blank.gif'
utf8mb3_general_ci
smf_battle_campaign_2
level_completion
int(10) unsigned
YES
0
null
smf_battle_campaign_2
quest_completions
int(10) unsigned
YES
0
null
smf_battle_campaign_2
score
int(10) unsigned
YES
0
null
smf_battle_campaign_2
start_time
int(10) unsigned
YES
0
null
smf_battle_campaign_2
timed_campaign
int(10) unsigned
YES
0
null
smf_battle_campaign_3
campaign_name
varchar(255)
YES
''
utf8mb3_general_ci
smf_battle_campaign_3
end_time
int(10) unsigned
YES
0
null
smf_battle_campaign_3
id_campaign
int(10) unsigned
YES
0
null
smf_battle_campaign_3
id_warrior
int(10) unsigned
NO
0
null
smf_battle_campaign_3
image
varchar(255)
YES
'blank.gif'
utf8mb3_general_ci
smf_battle_campaign_3
level_completion
int(10) unsigned
YES
0
null
smf_battle_campaign_3
quest_completions
int(10) unsigned
YES
0
null
smf_battle_campaign_3
score
int(10) unsigned
YES
0
null
smf_battle_campaign_3
start_time
int(10) unsigned
YES
0
null
smf_battle_campaign_3
timed_campaign
int(10) unsigned
YES
0
null
smf_battle_champs
date
int(10) unsigned
NO
0
null
smf_battle_champs
id_champ
int(10) unsigned
NO
null
null
smf_battle_champs
id_slain
int(10) unsigned
NO
0
null
smf_battle_champs
times_champ
int(10) unsigned
NO
0
null
smf_battle_explore
id_explore
int(10) unsigned
NO
null
auto_increment
null
smf_battle_explore
outcome1
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_explore
outcome1_action
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_explore
outcome1_reward
bigint(10)
NO
0
null
smf_battle_explore
outcome2
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_explore
outcome2_action
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_explore
outcome2_reward
bigint(10)
NO
0
null
smf_battle_explore
price
int(10) unsigned
NO
0
null
smf_battle_explore
start
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_graveyard
date
int(10) unsigned
NO
0
null
smf_battle_graveyard
id_grave
int(10) unsigned
NO
null
auto_increment
null
smf_battle_graveyard
id_mem
int(10) unsigned
NO
0
null
smf_battle_graveyard
id_memdef
int(10) unsigned
NO
0
null
smf_battle_graveyard
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_history
content
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_history
id_hist
int(11) unsigned
NO
null
auto_increment
null
smf_battle_history
time
int(10) unsigned
NO
0
null
smf_battle_members
battles
int(10) unsigned
YES
0
null
smf_battle_members
battles_date
int(10) unsigned
YES
0
null
smf_battle_members
kills
int(10) unsigned
YES
0
null
smf_battle_members
kills_date
int(10) unsigned
YES
0
null
smf_battle_members
member_id
int(10) unsigned
NO
null
null
smf_battle_members
opponent_id
int(10) unsigned
NO
0
null
smf_battle_monsters
atk
int(10) unsigned
NO
0
null
smf_battle_monsters
counter
int(10) unsigned
NO
0
null
smf_battle_monsters
def
int(10) unsigned
NO
0
null
smf_battle_monsters
evolve
int(10) unsigned
NO
0
null
smf_battle_monsters
hp
int(10) unsigned
NO
0
null
smf_battle_monsters
id_monster
int(10) unsigned
NO
null
auto_increment
null
smf_battle_monsters
img
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_monsters
max_hp
int(10) unsigned
NO
0
null
smf_battle_monsters
mon_max_range
int(10) unsigned
NO
0
null
smf_battle_monsters
mon_range
int(10) unsigned
NO
0
null
smf_battle_monsters
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_monsters_fight
id_monster
int(10) unsigned
NO
0
null
smf_battle_monsters_fight
id_warrior
int(10) unsigned
NO
0
null
smf_battle_monsters_fight
monster_atk
int(10) unsigned
NO
0
null
smf_battle_monsters_fight
monster_def
int(10) unsigned
NO
0
null
smf_battle_monsters_fight
monster_hp
int(10) unsigned
NO
0
null
smf_battle_monsters_fight
monster_max_hp
int(10) unsigned
NO
0
null
smf_battle_monsters_fight
time
int(10) unsigned
NO
0
null
smf_battle_quest
campaign_id
int(10) unsigned
NO
0
null
smf_battle_quest
energy
int(10) unsigned
NO
0
null
smf_battle_quest
exp
int(10) unsigned
NO
0
null
smf_battle_quest
ftext
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_quest
gold
int(10) unsigned
NO
0
null
smf_battle_quest
hp
int(10) unsigned
NO
0
null
smf_battle_quest
id_quest
int(10) unsigned
NO
null
auto_increment
null
smf_battle_quest
is_final
int(10) unsigned
NO
0
null
smf_battle_quest
itext
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_quest
level
int(10) unsigned
NO
0
null
smf_battle_quest
limit
int(10) unsigned
NO
0
null
smf_battle_quest
max_gain
int(10) unsigned
NO
0
null
smf_battle_quest
max_penalty
int(10) unsigned
NO
0
null
smf_battle_quest
min_exp
int(10) unsigned
NO
0
null
smf_battle_quest
min_gold
int(10) unsigned
NO
0
null
smf_battle_quest
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_quest
plays
int(10) unsigned
NO
0
null
smf_battle_quest
stext
text
YES
'\'\\\'\\\\\\\'NULL\\\\\\\'\\\'\''
utf8mb3_general_ci
smf_battle_quest
success
int(10) unsigned
NO
0
null
smf_battle_quest_champs
complete
int(10) unsigned
NO
0
null
smf_battle_quest_champs
date
int(10) unsigned
NO
0
null
smf_battle_quest_champs
exp_points
int(10) unsigned
NO
0
null
smf_battle_quest_champs
fail
int(10) unsigned
NO
0
null
smf_battle_quest_champs
id_quest
int(10) unsigned
NO
0
null
smf_battle_quest_champs
id_warrior
int(10) unsigned
NO
0
null
smf_battle_quest_champs
warrior_gold
int(10) unsigned
NO
0
null
smf_battle_scores
battle_title
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_scores
date
int(10) unsigned
NO
0
null
smf_battle_scores
id_warrior
int(10) unsigned
NO
null
null
smf_battle_scores
level
int(10) unsigned
NO
0
null
smf_battle_scores
score
bigint(11) unsigned
NO
0
null
smf_battle_shop
action
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_shop
amount
int(10) unsigned
NO
0
null
smf_battle_shop
description
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_shop
id_item
int(10) unsigned
NO
null
auto_increment
null
smf_battle_shop
img
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_shop
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_shop
price
int(10) unsigned
NO
0
null
smf_battle_shouts
content
varchar(255)
NO
''
utf8mb3_general_ci
smf_battle_shouts
id_member
int(10) unsigned
NO
0
null
smf_battle_shouts
id_shout
int(10) unsigned
NO
null
auto_increment
null
smf_battle_shouts
time
int(10) unsigned
NO
0
null
smf_board_permissions
add_deny
tinyint(4)
NO
1
null
smf_board_permissions
add_deny
tinyint
NO
1
null
smf_board_permissions
id_group
smallint(6)
NO
0
null
smf_board_permissions
id_group
smallint
NO
0
null
smf_board_permissions
id_profile
smallint(5) unsigned
NO
0
null
smf_board_permissions
id_profile
smallint unsigned
NO
0
null
smf_board_permissions
permission
varchar(30)
NO
''
utf8mb3_general_ci
smf_board_permissions
permission
varchar(30)
NO
utf8_general_ci
smf_board_permissions_view
deny
smallint(6)
NO
null
null
smf_board_permissions_view
deny
smallint
NO
null
null
smf_board_permissions_view
id_board
smallint(5) unsigned
NO
null
null
smf_board_permissions_view
id_board
smallint unsigned
NO
null
null
smf_board_permissions_view
id_group
smallint(6)
NO
0
null
smf_board_permissions_view
id_group
smallint
NO
0
null
smf_boards
board_order
smallint
NO
0
null
smf_boards
child_level
tinyint unsigned
NO
0
null
smf_boards
count_posts
tinyint
NO
0
null
smf_boards
deny_member_groups
varchar(255)
NO
utf8_general_ci
smf_boards
description
text
NO
null
utf8_general_ci
smf_boards
id_board
smallint unsigned
NO
null
auto_increment
null
smf_boards
id_cat
tinyint unsigned
NO
0
null
smf_boards
id_last_msg
int unsigned
NO
0
null
smf_boards
id_msg_updated
int unsigned
NO
0
null
smf_boards
id_parent
smallint unsigned
NO
0
null
smf_boards
id_profile
smallint unsigned
NO
1
null
smf_boards
id_theme
tinyint unsigned
NO
0
null
smf_boards
member_groups
varchar(255)
NO
-1,0
utf8_general_ci
smf_boards
name
varchar(255)
NO
utf8_general_ci
smf_boards
num_posts
mediumint unsigned
NO
0
null
smf_boards
num_topics
mediumint unsigned
NO
0
null
smf_boards
override_theme
tinyint unsigned
NO
0
null
smf_boards
redirect
varchar(255)
NO
utf8_general_ci
smf_boards
Shop_credits_bonus
tinyint(4) unsigned
NO
0
null
smf_boards
Shop_credits_count
tinyint(4) unsigned
NO
1
null
smf_boards
Shop_credits_post
int(11) unsigned
NO
0
null
smf_boards
Shop_credits_topic
int(11) unsigned
NO
0
null
smf_boards
board_order
smallint(6)
NO
0
null
smf_boards
child_level
tinyint(3) unsigned
NO
0
null
smf_boards
count_posts
tinyint(4)
NO
0
null
smf_boards
deny_member_groups
varchar(255)
NO
''
utf8mb3_general_ci
smf_boards
description
text
NO
null
utf8mb3_general_ci
smf_boards
fabi_color
varchar(16)
NO
''
utf8mb3_general_ci
smf_boards
fabi_icon
varchar(255)
NO
''
utf8mb3_general_ci
smf_boards
id_board
smallint(5) unsigned
NO
null
auto_increment
null
smf_boards
id_cat
tinyint(3) unsigned
NO
0
null
smf_boards
id_last_msg
int(10) unsigned
NO
0
null
smf_boards
id_msg_updated
int(10) unsigned
NO
0
null
smf_boards
id_parent
smallint(5) unsigned
NO
0
null
smf_boards
id_profile
smallint(5) unsigned
NO
1
null
smf_boards
id_theme
tinyint(3) unsigned
NO
0
null
smf_boards
member_groups
varchar(255)
NO
'-1,0'
utf8mb3_general_ci
smf_boards
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_boards
num_posts
mediumint(8) unsigned
NO
0
null
smf_boards
num_topics
mediumint(8) unsigned
NO
0
null
smf_boards
override_theme
tinyint(3) unsigned
NO
0
null
smf_boards
redirect
varchar(255)
NO
''
utf8mb3_general_ci
smf_boards
unapproved_posts
smallint(6)
NO
0
null
smf_boards
unapproved_posts
smallint
NO
0
null
smf_boards
unapproved_topics
smallint(6)
NO
0
null
smf_boards
unapproved_topics
smallint
NO
0
null
smf_calendar
end_date
date
NO
'1004-01-01'
null
smf_calendar
end_date
date
NO
1004-01-01
null
smf_calendar
end_time
time
YES
NULL
null
smf_calendar
end_time
time
YES
null
null
smf_calendar
id_board
smallint(5) unsigned
NO
0
null
smf_calendar
id_board
smallint unsigned
NO
0
null
smf_calendar
id_event
smallint(5) unsigned
NO
null
auto_increment
null
smf_calendar
id_event
smallint unsigned
NO
null
auto_increment
null
smf_calendar
id_member
mediumint(8) unsigned
NO
0
null
smf_calendar
id_member
mediumint unsigned
NO
0
null
smf_calendar
id_topic
mediumint(8) unsigned
NO
0
null
smf_calendar
id_topic
mediumint unsigned
NO
0
null
smf_calendar
location
varchar(255)
NO
''
utf8mb3_general_ci
smf_calendar
location
varchar(255)
NO
utf8_general_ci
smf_calendar
start_date
date
NO
'1004-01-01'
null
smf_calendar
start_date
date
NO
1004-01-01
null
smf_calendar
start_time
time
YES
NULL
null
smf_calendar
start_time
time
YES
null
null
smf_calendar
timezone
varchar(80)
YES
NULL
utf8mb3_general_ci
smf_calendar
timezone
varchar(80)
YES
null
utf8_general_ci
smf_calendar
title
varchar(255)
NO
''
utf8mb3_general_ci
smf_calendar
title
varchar(255)
NO
utf8_general_ci
smf_calendar_holidays
event_date
date
NO
'1004-01-01'
null
smf_calendar_holidays
event_date
date
NO
1004-01-01
null
smf_calendar_holidays
id_holiday
smallint(5) unsigned
NO
null
auto_increment
null
smf_calendar_holidays
id_holiday
smallint unsigned
NO
null
auto_increment
null
smf_calendar_holidays
title
varchar(255)
NO
''
utf8mb3_general_ci
smf_calendar_holidays
title
varchar(255)
NO
utf8_general_ci
smf_categories
can_collapse
tinyint(4)
NO
1
null
smf_categories
can_collapse
tinyint
NO
1
null
smf_categories
cat_order
tinyint(4)
NO
0
null
smf_categories
cat_order
tinyint
NO
0
null
smf_categories
description
text
NO
null
utf8mb3_general_ci
smf_categories
description
text
NO
null
utf8_general_ci
smf_categories
id_cat
tinyint(3) unsigned
NO
null
auto_increment
null
smf_categories
id_cat
tinyint unsigned
NO
null
auto_increment
null
smf_categories
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_categories
name
varchar(255)
NO
utf8_general_ci
smf_custom_fields
active
tinyint(4)
NO
1
null
smf_custom_fields
active
tinyint
NO
1
null
smf_custom_fields
bbc
tinyint(4)
NO
0
null
smf_custom_fields
bbc
tinyint
NO
0
null
smf_custom_fields
can_search
tinyint(4)
NO
0
null
smf_custom_fields
can_search
tinyint
NO
0
null
smf_custom_fields
col_name
varchar(12)
NO
''
utf8mb3_general_ci
smf_custom_fields
col_name
varchar(12)
NO
utf8_general_ci
smf_custom_fields
default_value
varchar(255)
NO
''
utf8mb3_general_ci
smf_custom_fields
default_value
varchar(255)
NO
utf8_general_ci
smf_custom_fields
enclose
text
NO
null
utf8mb3_general_ci
smf_custom_fields
enclose
text
NO
null
utf8_general_ci
smf_custom_fields
field_desc
varchar(255)
NO
''
utf8mb3_general_ci
smf_custom_fields
field_desc
varchar(255)
NO
utf8_general_ci
smf_custom_fields
field_length
smallint(6)
NO
255
null
smf_custom_fields
field_length
smallint
NO
255
null
smf_custom_fields
field_name
varchar(40)
NO
''
utf8mb3_general_ci
smf_custom_fields
field_name
varchar(40)
NO
utf8_general_ci
smf_custom_fields
field_options
text
NO
null
utf8mb3_general_ci
smf_custom_fields
field_options
text
NO
null
utf8_general_ci
smf_custom_fields
field_order
smallint(6)
NO
0
null
smf_custom_fields
field_order
smallint
NO
0
null
smf_custom_fields
field_type
varchar(8)
NO
'text'
utf8mb3_general_ci
smf_custom_fields
field_type
varchar(8)
NO
text
utf8_general_ci
smf_custom_fields
id_field
smallint(6)
NO
null
auto_increment
null
smf_custom_fields
id_field
smallint
NO
null
auto_increment
null
smf_custom_fields
mask
varchar(255)
NO
''
utf8mb3_general_ci
smf_custom_fields
mask
varchar(255)
NO
utf8_general_ci
smf_custom_fields
placement
tinyint(4)
NO
0
null
smf_custom_fields
placement
tinyint
NO
0
null
smf_custom_fields
private
tinyint(4)
NO
0
null
smf_custom_fields
private
tinyint
NO
0
null
smf_custom_fields
show_display
tinyint(4)
NO
0
null
smf_custom_fields
show_display
tinyint
NO
0
null
smf_custom_fields
show_mlist
smallint(6)
NO
0
null
smf_custom_fields
show_mlist
smallint
NO
0
null
smf_custom_fields
show_profile
varchar(20)
NO
'forumprofile'
utf8mb3_general_ci
smf_custom_fields
show_profile
varchar(20)
NO
forumprofile
utf8_general_ci
smf_custom_fields
show_reg
tinyint(4)
NO
0
null
smf_custom_fields
show_reg
tinyint
NO
0
null
smf_feedback
FeedBackMEMBER_ID
mediumint(8) unsigned
NO
0
null
smf_feedback
ID_LISTING
int(11)
NO
0
null
smf_feedback
ID_MEMBER
mediumint(8) unsigned
NO
0
null
smf_feedback
approved
tinyint(4)
NO
1
null
smf_feedback
comment_long
text
YES
NULL
utf8mb3_general_ci
smf_feedback
comment_short
tinytext
NO
null
utf8mb3_general_ci
smf_feedback
feedbackid
int(11)
NO
null
auto_increment
null
smf_feedback
saledate
int(11)
NO
0
null
smf_feedback
saletype
tinyint(4)
NO
0
null
smf_feedback
salevalue
tinyint(4)
NO
0
null
smf_feedback
topicurl
tinytext
YES
NULL
utf8mb3_general_ci
smf_group_moderators
id_group
smallint(5) unsigned
NO
0
null
smf_group_moderators
id_group
smallint unsigned
NO
0
null
smf_group_moderators
id_member
mediumint(8) unsigned
NO
0
null
smf_group_moderators
id_member
mediumint unsigned
NO
0
null
smf_log_actions
action
varchar(30)
NO
''
utf8mb3_general_ci
smf_log_actions
action
varchar(30)
NO
utf8_general_ci
smf_log_actions
extra
text
NO
null
utf8mb3_general_ci
smf_log_actions
extra
text
NO
null
utf8_general_ci
smf_log_actions
id_action
int(10) unsigned
NO
null
auto_increment
null
smf_log_actions
id_action
int unsigned
NO
null
auto_increment
null
smf_log_actions
id_board
smallint(5) unsigned
NO
0
null
smf_log_actions
id_board
smallint unsigned
NO
0
null
smf_log_actions
id_log
tinyint(3) unsigned
NO
1
null
smf_log_actions
id_log
tinyint unsigned
NO
1
null
smf_log_actions
id_member
mediumint(8) unsigned
NO
0
null
smf_log_actions
id_member
mediumint unsigned
NO
0
null
smf_log_actions
id_msg
int(10) unsigned
NO
0
null
smf_log_actions
id_msg
int unsigned
NO
0
null
smf_log_actions
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_actions
id_topic
mediumint unsigned
NO
0
null
smf_log_actions
ip
varbinary(16)
YES
NULL
null
smf_log_actions
ip
varbinary(16)
YES
null
null
smf_log_actions
log_time
int(10) unsigned
NO
0
null
smf_log_actions
log_time
int unsigned
NO
0
null
smf_log_activity
DATE
date
NO
null
null
smf_log_activity
date
date
NO
null
null
smf_log_activity
hits
mediumint(8) unsigned
NO
0
null
smf_log_activity
hits
mediumint unsigned
NO
0
null
smf_log_activity
most_on
smallint(5) unsigned
NO
0
null
smf_log_activity
most_on
smallint unsigned
NO
0
null
smf_log_activity
posts
smallint(5) unsigned
NO
0
null
smf_log_activity
posts
smallint unsigned
NO
0
null
smf_log_activity
registers
smallint(5) unsigned
NO
0
null
smf_log_activity
registers
smallint unsigned
NO
0
null
smf_log_activity
topics
smallint(5) unsigned
NO
0
null
smf_log_activity
topics
smallint unsigned
NO
0
null
smf_log_banned
email
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_banned
email
varchar(255)
NO
utf8_general_ci
smf_log_banned
id_ban_log
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_banned
id_ban_log
mediumint unsigned
NO
null
auto_increment
null
smf_log_banned
id_member
mediumint(8) unsigned
NO
0
null
smf_log_banned
id_member
mediumint unsigned
NO
0
null
smf_log_banned
ip
varbinary(16)
YES
NULL
null
smf_log_banned
ip
varbinary(16)
YES
null
null
smf_log_banned
log_time
int(10) unsigned
NO
0
null
smf_log_banned
log_time
int unsigned
NO
0
null
smf_log_boards
id_board
smallint(5) unsigned
NO
0
null
smf_log_boards
id_board
smallint unsigned
NO
0
null
smf_log_boards
id_member
mediumint(8) unsigned
NO
0
null
smf_log_boards
id_member
mediumint unsigned
NO
0
null
smf_log_boards
id_msg
int(10) unsigned
NO
0
null
smf_log_boards
id_msg
int unsigned
NO
0
null
smf_log_comments
body
text
NO
null
utf8mb3_general_ci
smf_log_comments
body
text
NO
null
utf8_general_ci
smf_log_comments
comment_type
varchar(8)
NO
'warning'
utf8mb3_general_ci
smf_log_comments
comment_type
varchar(8)
NO
warning
utf8_general_ci
smf_log_comments
counter
tinyint(4)
NO
0
null
smf_log_comments
counter
tinyint
NO
0
null
smf_log_comments
id_comment
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_comments
id_comment
mediumint unsigned
NO
null
auto_increment
null
smf_log_comments
id_member
mediumint(8) unsigned
NO
0
null
smf_log_comments
id_member
mediumint unsigned
NO
0
null
smf_log_comments
id_notice
mediumint(8) unsigned
NO
0
null
smf_log_comments
id_notice
mediumint unsigned
NO
0
null
smf_log_comments
id_recipient
mediumint(8) unsigned
NO
0
null
smf_log_comments
id_recipient
mediumint unsigned
NO
0
null
smf_log_comments
log_time
int(10)
NO
0
null
smf_log_comments
log_time
int
NO
0
null
smf_log_comments
member_name
varchar(80)
NO
''
utf8mb3_general_ci
smf_log_comments
member_name
varchar(80)
NO
utf8_general_ci
smf_log_comments
recipient_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_comments
recipient_name
varchar(255)
NO
utf8_general_ci
smf_log_digest
daily
tinyint(3) unsigned
NO
0
null
smf_log_digest
daily
tinyint unsigned
NO
0
null
smf_log_digest
exclude
mediumint(8) unsigned
NO
0
null
smf_log_digest
exclude
mediumint unsigned
NO
0
null
smf_log_digest
id_msg
int(10) unsigned
NO
0
null
smf_log_digest
id_msg
int unsigned
NO
0
null
smf_log_digest
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_digest
id_topic
mediumint unsigned
NO
0
null
smf_log_digest
note_type
varchar(10)
NO
'post'
utf8mb3_general_ci
smf_log_digest
note_type
varchar(10)
NO
post
utf8_general_ci
smf_log_errors
backtrace
varchar(10000)
NO
''
utf8mb3_general_ci
smf_log_errors
backtrace
varchar(10000)
NO
utf8_general_ci
smf_log_errors
error_type
char(15)
NO
'general'
utf8mb3_general_ci
smf_log_errors
error_type
char(15)
NO
general
utf8_general_ci
smf_log_errors
file
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_errors
file
varchar(255)
NO
utf8_general_ci
smf_log_errors
id_error
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_errors
id_error
mediumint unsigned
NO
null
auto_increment
null
smf_log_errors
id_member
mediumint(8) unsigned
NO
0
null
smf_log_errors
id_member
mediumint unsigned
NO
0
null
smf_log_errors
ip
varbinary(16)
YES
NULL
null
smf_log_errors
ip
varbinary(16)
YES
null
null
smf_log_errors
line
mediumint(8) unsigned
NO
0
null
smf_log_errors
line
mediumint unsigned
NO
0
null
smf_log_errors
log_time
int(10) unsigned
NO
0
null
smf_log_errors
log_time
int unsigned
NO
0
null
smf_log_errors
message
text
NO
null
utf8mb3_general_ci
smf_log_errors
message
text
NO
null
utf8_general_ci
smf_log_errors
session
varchar(128)
NO
' '
utf8mb3_general_ci
smf_log_errors
session
varchar(128)
NO
utf8_general_ci
smf_log_errors
url
text
NO
null
utf8mb3_general_ci
smf_log_errors
url
text
NO
null
utf8_general_ci
smf_log_floodcontrol
ip
varbinary(16)
NO
null
null
smf_log_floodcontrol
ip
varbinary(16)
NO
null
null
smf_log_floodcontrol
log_time
int(10) unsigned
NO
0
null
smf_log_floodcontrol
log_time
int unsigned
NO
0
null
smf_log_floodcontrol
log_type
varchar(30)
NO
'post'
utf8mb3_general_ci
smf_log_floodcontrol
log_type
varchar(30)
NO
post
utf8_general_ci
smf_log_group_requests
act_reason
text
NO
null
utf8mb3_general_ci
smf_log_group_requests
act_reason
text
NO
null
utf8_general_ci
smf_log_group_requests
id_group
smallint(5) unsigned
NO
0
null
smf_log_group_requests
id_group
smallint unsigned
NO
0
null
smf_log_group_requests
id_member
mediumint(8) unsigned
NO
0
null
smf_log_group_requests
id_member
mediumint unsigned
NO
0
null
smf_log_group_requests
id_member_acted
mediumint(8) unsigned
NO
0
null
smf_log_group_requests
id_member_acted
mediumint unsigned
NO
0
null
smf_log_group_requests
id_request
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_group_requests
id_request
mediumint unsigned
NO
null
auto_increment
null
smf_log_group_requests
member_name_acted
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_group_requests
member_name_acted
varchar(255)
NO
utf8_general_ci
smf_log_group_requests
reason
text
NO
null
utf8mb3_general_ci
smf_log_group_requests
reason
text
NO
null
utf8_general_ci
smf_log_group_requests
status
tinyint(3) unsigned
NO
0
null
smf_log_group_requests
status
tinyint unsigned
NO
0
null
smf_log_group_requests
time_acted
int(10) unsigned
NO
0
null
smf_log_group_requests
time_acted
int unsigned
NO
0
null
smf_log_group_requests
time_applied
int(10) unsigned
NO
0
null
smf_log_group_requests
time_applied
int unsigned
NO
0
null
smf_log_mark_read
id_board
smallint(5) unsigned
NO
0
null
smf_log_mark_read
id_board
smallint unsigned
NO
0
null
smf_log_mark_read
id_member
mediumint(8) unsigned
NO
0
null
smf_log_mark_read
id_member
mediumint unsigned
NO
0
null
smf_log_mark_read
id_msg
int(10) unsigned
NO
0
null
smf_log_mark_read
id_msg
int unsigned
NO
0
null
smf_log_member_notices
body
text
NO
null
utf8mb3_general_ci
smf_log_member_notices
body
text
NO
null
utf8_general_ci
smf_log_member_notices
id_notice
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_member_notices
id_notice
mediumint unsigned
NO
null
auto_increment
null
smf_log_member_notices
subject
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_member_notices
subject
varchar(255)
NO
utf8_general_ci
smf_log_notify
id_board
smallint(5) unsigned
NO
0
null
smf_log_notify
id_board
smallint unsigned
NO
0
null
smf_log_notify
id_member
mediumint(8) unsigned
NO
0
null
smf_log_notify
id_member
mediumint unsigned
NO
0
null
smf_log_notify
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_notify
id_topic
mediumint unsigned
NO
0
null
smf_log_notify
sent
tinyint(3) unsigned
NO
0
null
smf_log_notify
sent
tinyint unsigned
NO
0
null
smf_log_online
id_member
mediumint(8) unsigned
NO
0
null
smf_log_online
id_member
mediumint unsigned
NO
0
null
smf_log_online
id_spider
smallint(5) unsigned
NO
0
null
smf_log_online
id_spider
smallint unsigned
NO
0
null
smf_log_online
ip
varbinary(16)
YES
NULL
null
smf_log_online
ip
varbinary(16)
YES
null
null
smf_log_online
log_time
int(10)
NO
0
null
smf_log_online
log_time
int
NO
0
null
smf_log_online
session
varchar(128)
NO
''
utf8mb3_general_ci
smf_log_online
session
varchar(128)
NO
utf8_general_ci
smf_log_online
url
varchar(2048)
NO
''
utf8mb3_general_ci
smf_log_online
url
varchar(2048)
NO
utf8_general_ci
smf_log_packages
credits
text
NO
null
utf8mb3_general_ci
smf_log_packages
credits
text
NO
null
utf8_general_ci
smf_log_packages
db_changes
text
NO
null
utf8mb3_general_ci
smf_log_packages
db_changes
text
NO
null
utf8_general_ci
smf_log_packages
failed_steps
text
NO
null
utf8mb3_general_ci
smf_log_packages
failed_steps
text
NO
null
utf8_general_ci
smf_log_packages
filename
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
filename
varchar(255)
NO
utf8_general_ci
smf_log_packages
id_install
int(10)
NO
null
auto_increment
null
smf_log_packages
id_install
int
NO
null
auto_increment
null
smf_log_packages
id_member_installed
mediumint(9)
NO
0
null
smf_log_packages
id_member_installed
mediumint
NO
0
null
smf_log_packages
id_member_removed
mediumint(9)
NO
0
null
smf_log_packages
id_member_removed
mediumint
NO
0
null
smf_log_packages
install_state
tinyint(4)
NO
1
null
smf_log_packages
install_state
tinyint
NO
1
null
smf_log_packages
member_installed
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
member_installed
varchar(255)
NO
utf8_general_ci
smf_log_packages
member_removed
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
member_removed
varchar(255)
NO
utf8_general_ci
smf_log_packages
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
name
varchar(255)
NO
utf8_general_ci
smf_log_packages
package_id
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
package_id
varchar(255)
NO
utf8_general_ci
smf_log_packages
sha256_hash
text
YES
NULL
utf8mb3_general_ci
smf_log_packages
sha256_hash
text
YES
null
utf8_general_ci
smf_log_packages
themes_installed
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
themes_installed
varchar(255)
NO
utf8_general_ci
smf_log_packages
time_installed
int(10)
NO
0
null
smf_log_packages
time_installed
int
NO
0
null
smf_log_packages
time_removed
int(10)
NO
0
null
smf_log_packages
time_removed
int
NO
0
null
smf_log_packages
version
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_packages
version
varchar(255)
NO
utf8_general_ci
smf_log_polls
id_choice
tinyint(3) unsigned
NO
0
null
smf_log_polls
id_choice
tinyint unsigned
NO
0
null
smf_log_polls
id_member
mediumint(8) unsigned
NO
0
null
smf_log_polls
id_member
mediumint unsigned
NO
0
null
smf_log_polls
id_poll
mediumint(8) unsigned
NO
0
null
smf_log_polls
id_poll
mediumint unsigned
NO
0
null
smf_log_reported
body
mediumtext
NO
null
utf8mb3_general_ci
smf_log_reported
body
mediumtext
NO
null
utf8_general_ci
smf_log_reported
closed
tinyint(4)
NO
0
null
smf_log_reported
closed
tinyint
NO
0
null
smf_log_reported
id_board
smallint(5) unsigned
NO
0
null
smf_log_reported
id_board
smallint unsigned
NO
0
null
smf_log_reported
id_member
mediumint(8) unsigned
NO
0
null
smf_log_reported
id_member
mediumint unsigned
NO
0
null
smf_log_reported
id_msg
int(10) unsigned
NO
0
null
smf_log_reported
id_msg
int unsigned
NO
0
null
smf_log_reported
id_report
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_reported
id_report
mediumint unsigned
NO
null
auto_increment
null
smf_log_reported
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_reported
id_topic
mediumint unsigned
NO
0
null
smf_log_reported
ignore_all
tinyint(4)
NO
0
null
smf_log_reported
ignore_all
tinyint
NO
0
null
smf_log_reported
membername
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_reported
membername
varchar(255)
NO
utf8_general_ci
smf_log_reported
num_reports
mediumint(9)
NO
0
null
smf_log_reported
num_reports
mediumint
NO
0
null
smf_log_reported
subject
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_reported
subject
varchar(255)
NO
utf8_general_ci
smf_log_reported
time_started
int(10)
NO
0
null
smf_log_reported
time_started
int
NO
0
null
smf_log_reported
time_updated
int(10)
NO
0
null
smf_log_reported
time_updated
int
NO
0
null
smf_log_reported_comments
comment
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_reported_comments
comment
varchar(255)
NO
utf8_general_ci
smf_log_reported_comments
id_comment
mediumint(8) unsigned
NO
null
auto_increment
null
smf_log_reported_comments
id_comment
mediumint unsigned
NO
null
auto_increment
null
smf_log_reported_comments
id_member
mediumint(9)
NO
null
null
smf_log_reported_comments
id_member
mediumint
NO
null
null
smf_log_reported_comments
id_report
mediumint(9)
NO
0
null
smf_log_reported_comments
id_report
mediumint
NO
0
null
smf_log_reported_comments
member_ip
varbinary(16)
YES
NULL
null
smf_log_reported_comments
member_ip
varbinary(16)
YES
null
null
smf_log_reported_comments
membername
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_reported_comments
membername
varchar(255)
NO
utf8_general_ci
smf_log_reported_comments
time_sent
int(10)
NO
null
null
smf_log_reported_comments
time_sent
int
NO
null
null
smf_log_scheduled_tasks
id_log
mediumint(9)
NO
null
auto_increment
null
smf_log_scheduled_tasks
id_log
mediumint
NO
null
auto_increment
null
smf_log_scheduled_tasks
id_task
smallint(6)
NO
0
null
smf_log_scheduled_tasks
id_task
smallint
NO
0
null
smf_log_scheduled_tasks
time_run
int(10)
NO
0
null
smf_log_scheduled_tasks
time_run
int
NO
0
null
smf_log_scheduled_tasks
time_taken
float
NO
0
null
smf_log_scheduled_tasks
time_taken
float
NO
0
null
smf_log_search_messages
id_msg
int(10) unsigned
NO
0
null
smf_log_search_messages
id_msg
int unsigned
NO
0
null
smf_log_search_messages
id_search
tinyint(3) unsigned
NO
0
null
smf_log_search_messages
id_search
tinyint unsigned
NO
0
null
smf_log_search_results
id_msg
int(10) unsigned
NO
0
null
smf_log_search_results
id_msg
int unsigned
NO
0
null
smf_log_search_results
id_search
tinyint(3) unsigned
NO
0
null
smf_log_search_results
id_search
tinyint unsigned
NO
0
null
smf_log_search_results
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_search_results
id_topic
mediumint unsigned
NO
0
null
smf_log_search_results
num_matches
smallint(5) unsigned
NO
0
null
smf_log_search_results
num_matches
smallint unsigned
NO
0
null
smf_log_search_results
relevance
smallint(5) unsigned
NO
0
null
smf_log_search_results
relevance
smallint unsigned
NO
0
null
smf_log_search_subjects
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_search_subjects
id_topic
mediumint unsigned
NO
0
null
smf_log_search_subjects
word
varchar(20)
NO
''
utf8mb3_general_ci
smf_log_search_subjects
word
varchar(20)
NO
utf8_general_ci
smf_log_search_topics
id_search
tinyint(3) unsigned
NO
0
null
smf_log_search_topics
id_search
tinyint unsigned
NO
0
null
smf_log_search_topics
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_search_topics
id_topic
mediumint unsigned
NO
0
null
smf_log_sfs
checks
mediumtext
YES
NULL
utf8mb3_general_ci
smf_log_sfs
email
varchar(255)
YES
NULL
utf8mb3_general_ci
smf_log_sfs
id_member
mediumint(8) unsigned
YES
0
null
smf_log_sfs
id_sfs
int(10) unsigned
NO
null
auto_increment
null
smf_log_sfs
id_type
tinyint(3) unsigned
YES
0
null
smf_log_sfs
ip
varchar(255)
YES
NULL
utf8mb3_general_ci
smf_log_sfs
ip2
varchar(255)
YES
NULL
utf8mb3_general_ci
smf_log_sfs
log_time
int(10) unsigned
YES
0
null
smf_log_sfs
result
mediumtext
YES
NULL
utf8mb3_general_ci
smf_log_sfs
url
varchar(255)
YES
NULL
utf8mb3_general_ci
smf_log_sfs
username
varchar(255)
YES
NULL
utf8mb3_general_ci
smf_log_spider_hits
id_hit
int(10) unsigned
NO
null
auto_increment
null
smf_log_spider_hits
id_hit
int unsigned
NO
null
auto_increment
null
smf_log_spider_hits
id_spider
smallint(5) unsigned
NO
0
null
smf_log_spider_hits
id_spider
smallint unsigned
NO
0
null
smf_log_spider_hits
log_time
int(10) unsigned
NO
0
null
smf_log_spider_hits
log_time
int unsigned
NO
0
null
smf_log_spider_hits
processed
tinyint(4)
NO
0
null
smf_log_spider_hits
processed
tinyint
NO
0
null
smf_log_spider_hits
url
varchar(1024)
NO
''
utf8mb3_general_ci
smf_log_spider_hits
url
varchar(1024)
NO
utf8_general_ci
smf_log_spider_stats
id_spider
smallint(5) unsigned
NO
0
null
smf_log_spider_stats
id_spider
smallint unsigned
NO
0
null
smf_log_spider_stats
last_seen
int(10) unsigned
NO
0
null
smf_log_spider_stats
last_seen
int unsigned
NO
0
null
smf_log_spider_stats
page_hits
int(11)
NO
0
null
smf_log_spider_stats
page_hits
int
NO
0
null
smf_log_spider_stats
stat_date
date
NO
'1004-01-01'
null
smf_log_spider_stats
stat_date
date
NO
1004-01-01
null
smf_log_subscribed
end_time
int(10)
NO
0
null
smf_log_subscribed
end_time
int
NO
0
null
smf_log_subscribed
id_member
int(10)
NO
0
null
smf_log_subscribed
id_member
int
NO
0
null
smf_log_subscribed
id_sublog
int(10) unsigned
NO
null
auto_increment
null
smf_log_subscribed
id_sublog
int unsigned
NO
null
auto_increment
null
smf_log_subscribed
id_subscribe
mediumint(8) unsigned
NO
0
null
smf_log_subscribed
id_subscribe
mediumint unsigned
NO
0
null
smf_log_subscribed
old_id_group
smallint(6)
NO
0
null
smf_log_subscribed
old_id_group
smallint
NO
0
null
smf_log_subscribed
payments_pending
tinyint(4)
NO
0
null
smf_log_subscribed
payments_pending
tinyint
NO
0
null
smf_log_subscribed
pending_details
text
NO
null
utf8mb3_general_ci
smf_log_subscribed
pending_details
text
NO
null
utf8_general_ci
smf_log_subscribed
reminder_sent
tinyint(4)
NO
0
null
smf_log_subscribed
reminder_sent
tinyint
NO
0
null
smf_log_subscribed
start_time
int(10)
NO
0
null
smf_log_subscribed
start_time
int
NO
0
null
smf_log_subscribed
status
tinyint(4)
NO
0
null
smf_log_subscribed
status
tinyint
NO
0
null
smf_log_subscribed
vendor_ref
varchar(255)
NO
''
utf8mb3_general_ci
smf_log_subscribed
vendor_ref
varchar(255)
NO
utf8_general_ci
smf_log_topics
id_member
mediumint(8) unsigned
NO
0
null
smf_log_topics
id_member
mediumint unsigned
NO
0
null
smf_log_topics
id_msg
int(10) unsigned
NO
0
null
smf_log_topics
id_msg
int unsigned
NO
0
null
smf_log_topics
id_topic
mediumint(8) unsigned
NO
0
null
smf_log_topics
id_topic
mediumint unsigned
NO
0
null
smf_log_topics
unwatched
tinyint(4)
NO
0
null
smf_log_topics
unwatched
tinyint
NO
0
null
smf_mail_queue
body
mediumtext
NO
null
utf8mb3_general_ci
smf_mail_queue
body
mediumtext
NO
null
utf8_general_ci
smf_mail_queue
headers
text
NO
null
utf8mb3_general_ci
smf_mail_queue
headers
text
NO
null
utf8_general_ci
smf_mail_queue
id_mail
int(10) unsigned
NO
null
auto_increment
null
smf_mail_queue
id_mail
int unsigned
NO
null
auto_increment
null
smf_mail_queue
priority
tinyint(4)
NO
1
null
smf_mail_queue
priority
tinyint
NO
1
null
smf_mail_queue
private
tinyint(4)
NO
0
null
smf_mail_queue
private
tinyint
NO
0
null
smf_mail_queue
recipient
varchar(255)
NO
''
utf8mb3_general_ci
smf_mail_queue
recipient
varchar(255)
NO
utf8_general_ci
smf_mail_queue
send_html
tinyint(4)
NO
0
null
smf_mail_queue
send_html
tinyint
NO
0
null
smf_mail_queue
subject
varchar(255)
NO
''
utf8mb3_general_ci
smf_mail_queue
subject
varchar(255)
NO
utf8_general_ci
smf_mail_queue
time_sent
int(10)
NO
0
null
smf_mail_queue
time_sent
int
NO
0
null
smf_mediapro_cache
embedcode
text
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_cache
id
int(11)
NO
null
auto_increment
null
smf_mediapro_cache
mediaurl
varchar(255)
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_sites
embedcode
text
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_sites
enabled
tinyint(4)
YES
0
null
smf_mediapro_sites
height
int(5)
YES
0
null
smf_mediapro_sites
id
int(11)
NO
null
auto_increment
null
smf_mediapro_sites
processregex
text
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_sites
regexmatch
text
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_sites
title
varchar(255)
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_sites
website
varchar(255)
YES
NULL
utf8mb3_unicode_ci
smf_mediapro_sites
width
int(5)
YES
0
null
smf_member_logins
id_login
int(10)
NO
null
auto_increment
null
smf_member_logins
id_login
int
NO
null
auto_increment
null
smf_member_logins
id_member
mediumint(9)
NO
0
null
smf_member_logins
id_member
mediumint
NO
0
null
smf_member_logins
ip
varbinary(16)
YES
NULL
null
smf_member_logins
ip
varbinary(16)
YES
null
null
smf_member_logins
ip2
varbinary(16)
YES
NULL
null
smf_member_logins
ip2
varbinary(16)
YES
null
null
smf_member_logins
time
int(10)
NO
0
null
smf_member_logins
time
int
NO
0
null
smf_membergroups
description
text
NO
null
utf8mb3_general_ci
smf_membergroups
description
text
NO
null
utf8_general_ci
smf_membergroups
group_name
varchar(80)
NO
''
utf8mb3_general_ci
smf_membergroups
group_name
varchar(80)
NO
utf8_general_ci
smf_membergroups
group_type
tinyint(4)
NO
0
null
smf_membergroups
group_type
tinyint
NO
0
null
smf_membergroups
hidden
tinyint(4)
NO
0
null
smf_membergroups
hidden
tinyint
NO
0
null
smf_membergroups
icons
varchar(255)
NO
''
utf8mb3_general_ci
smf_membergroups
icons
varchar(255)
NO
utf8_general_ci
smf_membergroups
id_group
smallint(5) unsigned
NO
null
auto_increment
null
smf_membergroups
id_group
smallint unsigned
NO
null
auto_increment
null
smf_membergroups
id_parent
smallint(6)
NO
-2
null
smf_membergroups
id_parent
smallint
NO
-2
null
smf_membergroups
max_messages
smallint(5) unsigned
NO
0
null
smf_membergroups
max_messages
smallint unsigned
NO
0
null
smf_membergroups
min_posts
mediumint(9)
NO
-1
null
smf_membergroups
min_posts
mediumint
NO
-1
null
smf_membergroups
online_color
varchar(20)
NO
''
utf8mb3_general_ci
smf_membergroups
online_color
varchar(20)
NO
utf8_general_ci
smf_membergroups
tfa_required
tinyint(4)
NO
0
null
smf_membergroups
tfa_required
tinyint
NO
0
null
smf_members
additional_groups
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
additional_groups
varchar(255)
NO
utf8_general_ci
smf_members
alerts
int(10) unsigned
NO
0
null
smf_members
alerts
int unsigned
NO
0
null
smf_members
atk
int(11) unsigned
NO
100
null
smf_members
avatar
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
avatar
varchar(255)
NO
utf8_general_ci
smf_members
battle_last
int(10) unsigned
NO
0
null
smf_members
battle_only_buddies_shout
int(11) unsigned
NO
0
null
smf_members
battle_points
bigint(11) unsigned
NO
0
null
smf_members
birthdate
date
NO
'1004-01-01'
null
smf_members
birthdate
date
NO
1004-01-01
null
smf_members
bpm
int(11) unsigned
NO
0
null
smf_members
buddy_list
text
NO
null
utf8mb3_general_ci
smf_members
buddy_list
text
NO
null
utf8_general_ci
smf_members
date_registered
int(10) unsigned
NO
0
null
smf_members
date_registered
int unsigned
NO
0
null
smf_members
def
int(11) unsigned
NO
100
null
smf_members
email_address
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
email_address
varchar(255)
NO
utf8_general_ci
smf_members
energy
int(11) unsigned
NO
100
null
smf_members
exp
int(11) unsigned
NO
0
null
smf_members
gamesPass
int(10) unsigned
NO
0
null
smf_members
gold
bigint(11) unsigned
NO
1100
null
smf_members
hp
int(11) unsigned
NO
100
null
smf_members
id_group
smallint(5) unsigned
NO
0
null
smf_members
id_group
smallint unsigned
NO
0
null
smf_members
id_member
mediumint(8) unsigned
NO
null
auto_increment
null
smf_members
id_member
mediumint unsigned
NO
null
auto_increment
null
smf_members
id_msg_last_visit
int(10) unsigned
NO
0
null
smf_members
id_msg_last_visit
int unsigned
NO
0
null
smf_members
id_post_group
smallint(5) unsigned
NO
0
null
smf_members
id_post_group
smallint unsigned
NO
0
null
smf_members
id_theme
tinyint(3) unsigned
NO
0
null
smf_members
id_theme
tinyint unsigned
NO
0
null
smf_members
ignore_boards
text
NO
null
utf8mb3_general_ci
smf_members
ignore_boards
text
NO
null
utf8_general_ci
smf_members
instant_messages
smallint(6)
NO
0
null
smf_members
instant_messages
smallint
NO
0
null
smf_members
is_activated
tinyint(3) unsigned
NO
1
null
smf_members
is_activated
tinyint unsigned
NO
1
null
smf_members
is_dead
int(11) unsigned
NO
0
null
smf_members
last_login
int(10) unsigned
NO
0
null
smf_members
last_login
int unsigned
NO
0
null
smf_members
lastupdate
int(11) unsigned
NO
0
null
smf_members
level
int(11) unsigned
NO
0
null
smf_members
lngfile
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
lngfile
varchar(255)
NO
utf8_general_ci
smf_members
max_atk
int(11) unsigned
NO
100
null
smf_members
max_def
int(11) unsigned
NO
100
null
smf_members
max_energy
int(11) unsigned
NO
100
null
smf_members
max_exp
int(11) unsigned
NO
0
null
smf_members
max_hp
int(11) unsigned
NO
100
null
smf_members
max_stamina
int(11) unsigned
NO
100
null
smf_members
mem_slays
int(11) unsigned
NO
0
null
smf_members
member_ip
varbinary(16)
YES
NULL
null
smf_members
member_ip
varbinary(16)
YES
null
null
smf_members
member_ip2
varbinary(16)
YES
NULL
null
smf_members
member_ip2
varbinary(16)
YES
null
null
smf_members
member_name
varchar(80)
NO
''
utf8mb3_general_ci
smf_members
member_name
varchar(80)
NO
utf8_general_ci
smf_members
mod_prefs
varchar(20)
NO
''
utf8mb3_general_ci
smf_members
mod_prefs
varchar(20)
NO
utf8_general_ci
smf_members
mon_slays
int(11) unsigned
NO
0
null
smf_members
new_pm
tinyint(3) unsigned
NO
0
null
smf_members
new_pm
tinyint unsigned
NO
0
null
smf_members
passwd
varchar(64)
NO
''
utf8mb3_general_ci
smf_members
passwd
varchar(64)
NO
utf8_general_ci
smf_members
passwd_flood
varchar(12)
NO
''
utf8mb3_general_ci
smf_members
passwd_flood
varchar(12)
NO
utf8_general_ci
smf_members
password_salt
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
password_salt
varchar(255)
NO
utf8_general_ci
smf_members
personal_text
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
personal_text
varchar(255)
NO
utf8_general_ci
smf_members
pm_ignore_list
text
YES
NULL
utf8mb3_general_ci
smf_members
pm_ignore_list
text
YES
null
utf8_general_ci
smf_members
pm_prefs
mediumint(9)
NO
0
null
smf_members
pm_prefs
mediumint
NO
0
null
smf_members
pm_receive_from
tinyint(3) unsigned
NO
1
null
smf_members
pm_receive_from
tinyint unsigned
NO
1
null
smf_members
posts
mediumint(8) unsigned
NO
0
null
smf_members
posts
mediumint unsigned
NO
0
null
smf_members
real_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
real_name
varchar(255)
NO
utf8_general_ci
smf_members
ref_count
int(10) unsigned
NO
0
null
smf_members
referral
mediumint(8) unsigned
NO
0
null
smf_members
secret_answer
varchar(64)
NO
''
utf8mb3_general_ci
smf_members
secret_answer
varchar(64)
NO
utf8_general_ci
smf_members
secret_question
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
secret_question
varchar(255)
NO
utf8_general_ci
smf_members
shopBank
bigint(20)
NO
0
null
smf_members
shopInventory_hide
int(11) unsigned
NO
0
null
smf_members
shopMoney
mediumint(9)
NO
0
null
smf_members
show_online
tinyint(4)
NO
1
null
smf_members
show_online
tinyint
NO
1
null
smf_members
signature
text
NO
null
utf8mb3_general_ci
smf_members
signature
text
NO
null
utf8_general_ci
smf_members
smiley_set
varchar(48)
NO
''
utf8mb3_general_ci
smf_members
smiley_set
varchar(48)
NO
utf8_general_ci
smf_members
stamina
int(11) unsigned
NO
100
null
smf_members
stat_point
int(11) unsigned
NO
0
null
smf_members
tfa_backup
varchar(64)
NO
''
utf8mb3_general_ci
smf_members
tfa_backup
varchar(64)
NO
utf8_general_ci
smf_members
tfa_secret
varchar(24)
NO
''
utf8mb3_general_ci
smf_members
tfa_secret
varchar(24)
NO
utf8_general_ci
smf_members
time_format
varchar(80)
NO
''
utf8mb3_general_ci
smf_members
time_format
varchar(80)
NO
utf8_general_ci
smf_members
time_offset
float
NO
0
null
smf_members
time_offset
float
NO
0
null
smf_members
timezone
varchar(80)
NO
'UTC'
utf8mb3_general_ci
smf_members
timezone
varchar(80)
NO
UTC
utf8_general_ci
smf_members
total_time_logged_in
int(10) unsigned
NO
0
null
smf_members
total_time_logged_in
int unsigned
NO
0
null
smf_members
unread_messages
smallint(6)
NO
0
null
smf_members
unread_messages
smallint
NO
0
null
smf_members
usertitle
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
usertitle
varchar(255)
NO
utf8_general_ci
smf_members
validation_code
varchar(10)
NO
''
utf8mb3_general_ci
smf_members
validation_code
varchar(10)
NO
utf8_general_ci
smf_members
warning
tinyint(4)
NO
0
null
smf_members
warning
tinyint
NO
0
null
smf_members
website_title
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
website_title
varchar(255)
NO
utf8_general_ci
smf_members
website_url
varchar(255)
NO
''
utf8mb3_general_ci
smf_members
website_url
varchar(255)
NO
utf8_general_ci
smf_mentions
content_id
int(11)
NO
0
null
smf_mentions
content_id
int
NO
0
null
smf_mentions
content_type
varchar(10)
NO
''
utf8mb3_general_ci
smf_mentions
content_type
varchar(10)
NO
utf8_general_ci
smf_mentions
id_member
mediumint(8) unsigned
NO
0
null
smf_mentions
id_member
mediumint unsigned
NO
0
null
smf_mentions
id_mentioned
int(11)
NO
0
null
smf_mentions
id_mentioned
int
NO
0
null
smf_mentions
time
int(11)
NO
0
null
smf_mentions
time
int
NO
0
null
smf_message_icons
filename
varchar(80)
NO
''
utf8mb3_general_ci
smf_message_icons
filename
varchar(80)
NO
utf8_general_ci
smf_message_icons
icon_order
smallint(5) unsigned
NO
0
null
smf_message_icons
icon_order
smallint unsigned
NO
0
null
smf_message_icons
id_board
smallint(5) unsigned
NO
0
null
smf_message_icons
id_board
smallint unsigned
NO
0
null
smf_message_icons
id_icon
smallint(5) unsigned
NO
null
auto_increment
null
smf_message_icons
id_icon
smallint unsigned
NO
null
auto_increment
null
smf_message_icons
title
varchar(80)
NO
''
utf8mb3_general_ci
smf_message_icons
title
varchar(80)
NO
utf8_general_ci
smf_messages
approved
tinyint(4)
NO
1
null
smf_messages
approved
tinyint
NO
1
null
smf_messages
body
text
NO
null
utf8mb3_general_ci
smf_messages
body
text
NO
null
utf8_general_ci
smf_messages
icon
varchar(16)
NO
'xx'
utf8mb3_general_ci
smf_messages
icon
varchar(16)
NO
xx
utf8_general_ci
smf_messages
id_board
smallint(5) unsigned
NO
0
null
smf_messages
id_board
smallint unsigned
NO
0
null
smf_messages
id_member
mediumint(8) unsigned
NO
0
null
smf_messages
id_member
mediumint unsigned
NO
0
null
smf_messages
id_msg
int(10) unsigned
NO
null
auto_increment
null
smf_messages
id_msg
int unsigned
NO
null
auto_increment
null
smf_messages
id_msg_modified
int(10) unsigned
NO
0
null
smf_messages
id_msg_modified
int unsigned
NO
0
null
smf_messages
id_topic
mediumint(8) unsigned
NO
0
null
smf_messages
id_topic
mediumint unsigned
NO
0
null
smf_messages
likes
smallint(5) unsigned
NO
0
null
smf_messages
likes
smallint unsigned
NO
0
null
smf_messages
modified_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_messages
modified_name
varchar(255)
NO
utf8_general_ci
smf_messages
modified_reason
varchar(255)
NO
''
utf8mb3_general_ci
smf_messages
modified_reason
varchar(255)
NO
utf8_general_ci
smf_messages
modified_time
int(10) unsigned
NO
0
null
smf_messages
modified_time
int unsigned
NO
0
null
smf_messages
poster_email
varchar(255)
NO
''
utf8mb3_general_ci
smf_messages
poster_email
varchar(255)
NO
utf8_general_ci
smf_messages
poster_ip
varbinary(16)
YES
NULL
null
smf_messages
poster_ip
varbinary(16)
YES
null
null
smf_messages
poster_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_messages
poster_name
varchar(255)
NO
utf8_general_ci
smf_messages
poster_time
int(10) unsigned
NO
0
null
smf_messages
poster_time
int unsigned
NO
0
null
smf_messages
smileys_enabled
tinyint(4)
NO
1
null
smf_messages
smileys_enabled
tinyint
NO
1
null
smf_messages
subject
varchar(255)
NO
''
utf8mb3_general_ci
smf_messages
subject
varchar(255)
NO
utf8_general_ci
smf_moderator_groups
id_board
smallint(5) unsigned
NO
0
null
smf_moderator_groups
id_board
smallint unsigned
NO
0
null
smf_moderator_groups
id_group
smallint(5) unsigned
NO
0
null
smf_moderator_groups
id_group
smallint unsigned
NO
0
null
smf_moderators
id_board
smallint(5) unsigned
NO
0
null
smf_moderators
id_board
smallint unsigned
NO
0
null
smf_moderators
id_member
mediumint(8) unsigned
NO
0
null
smf_moderators
id_member
mediumint unsigned
NO
0
null
smf_package_servers
extra
text
YES
NULL
utf8mb3_general_ci
smf_package_servers
extra
text
YES
null
utf8_general_ci
smf_package_servers
id_server
smallint(5) unsigned
NO
null
auto_increment
null
smf_package_servers
id_server
smallint unsigned
NO
null
auto_increment
null
smf_package_servers
name
varchar(255)
NO
''
utf8mb3_general_ci
smf_package_servers
name
varchar(255)
NO
utf8_general_ci
smf_package_servers
url
varchar(255)
NO
''
utf8mb3_general_ci
smf_package_servers
url
varchar(255)
NO
utf8_general_ci
smf_package_servers
validation_url
varchar(255)
YES
''
utf8mb3_general_ci
smf_package_servers
validation_url
varchar(255)
NO
utf8_general_ci
smf_permission_profiles
id_profile
smallint(6)
NO
null
auto_increment
null
smf_permission_profiles
id_profile
smallint
NO
null
auto_increment
null
smf_permission_profiles
profile_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_permission_profiles
profile_name
varchar(255)
NO
utf8_general_ci
smf_permissions
add_deny
tinyint(4)
NO
1
null
smf_permissions
add_deny
tinyint
NO
1
null
smf_permissions
id_group
smallint(6)
NO
0
null
smf_permissions
id_group
smallint
NO
0
null
smf_permissions
permission
varchar(30)
NO
''
utf8mb3_general_ci
smf_permissions
permission
varchar(30)
NO
utf8_general_ci
smf_personal_messages
body
text
NO
null
utf8mb3_general_ci
smf_personal_messages
body
text
NO
null
utf8_general_ci
smf_personal_messages
deleted_by_sender
tinyint(3) unsigned
NO
0
null
smf_personal_messages
deleted_by_sender
tinyint unsigned
NO
0
null
smf_personal_messages
from_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_personal_messages
from_name
varchar(255)
NO
utf8_general_ci
smf_personal_messages
id_member_from
mediumint(8) unsigned
NO
0
null
smf_personal_messages
id_member_from
mediumint unsigned
NO
0
null
smf_personal_messages
id_pm
int(10) unsigned
NO
null
auto_increment
null
smf_personal_messages
id_pm
int unsigned
NO
null
auto_increment
null
smf_personal_messages
id_pm_head
int(10) unsigned
NO
0
null
smf_personal_messages
id_pm_head
int unsigned
NO
0
null
smf_personal_messages
msgtime
int(10) unsigned
NO
0
null
smf_personal_messages
msgtime
int unsigned
NO
0
null
smf_personal_messages
subject
varchar(255)
NO
''
utf8mb3_general_ci
smf_personal_messages
subject
varchar(255)
NO
utf8_general_ci
smf_pm_labeled_messages
id_label
int(10) unsigned
NO
0
null
smf_pm_labeled_messages
id_label
int unsigned
NO
0
null
smf_pm_labeled_messages
id_pm
int(10) unsigned
NO
0
null
smf_pm_labeled_messages
id_pm
int unsigned
NO
0
null
smf_pm_labels
id_label
int(10) unsigned
NO
null
auto_increment
null
smf_pm_labels
id_label
int unsigned
NO
null
auto_increment
null
smf_pm_labels
id_member
mediumint(8) unsigned
NO
0
null
smf_pm_labels
id_member
mediumint unsigned
NO
0
null
smf_pm_labels
name
varchar(30)
NO
''
utf8mb3_general_ci
smf_pm_labels
name
varchar(30)
NO
utf8_general_ci
smf_pm_recipients
bcc
tinyint(3) unsigned
NO
0
null
smf_pm_recipients
bcc
tinyint unsigned
NO
0
null
smf_pm_recipients
deleted
tinyint(3) unsigned
NO
0
null
smf_pm_recipients
deleted
tinyint unsigned
NO
0
null
smf_pm_recipients
id_member
mediumint(8) unsigned
NO
0
null
smf_pm_recipients
id_member
mediumint unsigned
NO
0
null
smf_pm_recipients
id_pm
int(10) unsigned
NO
0
null
smf_pm_recipients
id_pm
int unsigned
NO
0
null
smf_pm_recipients
in_inbox
tinyint(4)
NO
1
null
smf_pm_recipients
in_inbox
tinyint
NO
1
null
smf_pm_recipients
is_new
tinyint(3) unsigned
NO
0
null
smf_pm_recipients
is_new
tinyint unsigned
NO
0
null
smf_pm_recipients
is_read
tinyint(3) unsigned
NO
0
null
smf_pm_recipients
is_read
tinyint unsigned
NO
0
null
smf_pm_rules
actions
text
NO
null
utf8mb3_general_ci
smf_pm_rules
actions
text
NO
null
utf8_general_ci
smf_pm_rules
criteria
text
NO
null
utf8mb3_general_ci
smf_pm_rules
criteria
text
NO
null
utf8_general_ci
smf_pm_rules
delete_pm
tinyint(3) unsigned
NO
0
null
smf_pm_rules
delete_pm
tinyint unsigned
NO
0
null
smf_pm_rules
id_member
mediumint(8) unsigned
NO
0
null
smf_pm_rules
id_member
mediumint unsigned
NO
0
null
smf_pm_rules
id_rule
int(10) unsigned
NO
null
auto_increment
null
smf_pm_rules
id_rule
int unsigned
NO
null
auto_increment
null
smf_pm_rules
is_or
tinyint(3) unsigned
NO
0
null
smf_pm_rules
is_or
tinyint unsigned
NO
0
null
smf_pm_rules
rule_name
varchar(60)
NO
null
utf8mb3_general_ci
smf_pm_rules
rule_name
varchar(60)
NO
null
utf8_general_ci
smf_poll_choices
id_choice
tinyint(3) unsigned
NO
0
null
smf_poll_choices
id_choice
tinyint unsigned
NO
0
null
smf_poll_choices
id_poll
mediumint(8) unsigned
NO
0
null
smf_poll_choices
id_poll
mediumint unsigned
NO
0
null
smf_poll_choices
label
varchar(255)
NO
''
utf8mb3_general_ci
smf_poll_choices
label
varchar(255)
NO
utf8_general_ci
smf_poll_choices
votes
smallint(5) unsigned
NO
0
null
smf_poll_choices
votes
smallint unsigned
NO
0
null
smf_polls
change_vote
tinyint(3) unsigned
NO
0
null
smf_polls
change_vote
tinyint unsigned
NO
0
null
smf_polls
expire_time
int(10) unsigned
NO
0
null
smf_polls
expire_time
int unsigned
NO
0
null
smf_polls
guest_vote
tinyint(3) unsigned
NO
0
null
smf_polls
guest_vote
tinyint unsigned
NO
0
null
smf_polls
hide_results
tinyint(3) unsigned
NO
0
null
smf_polls
hide_results
tinyint unsigned
NO
0
null
smf_polls
id_member
mediumint(8) unsigned
NO
0
null
smf_polls
id_member
mediumint unsigned
NO
0
null
smf_polls
id_poll
mediumint(8) unsigned
NO
null
auto_increment
null
smf_polls
id_poll
mediumint unsigned
NO
null
auto_increment
null
smf_polls
max_votes
tinyint(3) unsigned
NO
1
null
smf_polls
max_votes
tinyint unsigned
NO
1
null
smf_polls
num_guest_voters
int(10) unsigned
NO
0
null
smf_polls
num_guest_voters
int unsigned
NO
0
null
smf_polls
poster_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_polls
poster_name
varchar(255)
NO
utf8_general_ci
smf_polls
question
varchar(255)
NO
''
utf8mb3_general_ci
smf_polls
question
varchar(255)
NO
utf8_general_ci
smf_polls
reset_poll
int(10) unsigned
NO
0
null
smf_polls
reset_poll
int unsigned
NO
0
null
smf_polls
voting_locked
tinyint(4)
NO
0
null
smf_polls
voting_locked
tinyint
NO
0
null
smf_qanda
answers
text
NO
null
utf8mb3_general_ci
smf_qanda
answers
text
NO
null
utf8_general_ci
smf_qanda
id_question
smallint(5) unsigned
NO
null
auto_increment
null
smf_qanda
id_question
smallint unsigned
NO
null
auto_increment
null
smf_qanda
lngfile
varchar(255)
NO
''
utf8mb3_general_ci
smf_qanda
lngfile
varchar(255)
NO
utf8_general_ci
smf_qanda
question
varchar(255)
NO
''
utf8mb3_general_ci
smf_qanda
question
varchar(255)
NO
utf8_general_ci
smf_quiz
creator_id
mediumint(8) unsigned
NO
0
null
smf_quiz
description
text
YES
NULL
utf8mb3_general_ci
smf_quiz
enabled
tinyint(3) unsigned
NO
0
null
smf_quiz
for_review
tinyint(3) unsigned
NO
0
null
smf_quiz
id_category
int(10) unsigned
NO
0
null
smf_quiz
id_quiz
int(10) unsigned
NO
null
auto_increment
null
smf_quiz
image
varchar(255)
NO
null
utf8mb3_general_ci
smf_quiz
imported
tinyint(3) unsigned
NO
0
null
smf_quiz
order_questions
tinyint(3) unsigned
NO
0
null
smf_quiz
play_limit
smallint(5) unsigned
NO
0
null
smf_quiz
question_plays
int(10) unsigned
NO
0
null
smf_quiz
quiz_plays
int(11)
NO
0
null
smf_quiz
rating
smallint(5) unsigned
NO
0
null
smf_quiz
seconds_per_question
smallint(5) unsigned
NO
0
null
smf_quiz
show_answers
tinyint(3)
NO
0
null
smf_quiz
title
varchar(255)
NO
'Quiz Title'
utf8mb3_general_ci
smf_quiz
top_correct
smallint(5) unsigned
NO
0
null
smf_quiz
top_points
smallint(5) unsigned
NO
0
null
smf_quiz
top_time
smallint(5) unsigned
NO
0
null
smf_quiz
top_user_id
mediumint(8) unsigned
NO
0
null
smf_quiz
total_correct
int(10) unsigned
NO
0
null
smf_quiz
updated
int(10) unsigned
NO
0
null
smf_quiz_answer
answer_plays
int(10) unsigned
NO
0
null
smf_quiz_answer
answer_text
varchar(255)
NO
'Answer Text'
utf8mb3_general_ci
smf_quiz_answer
id_answer
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_answer
id_question
int(10) unsigned
NO
0
null
smf_quiz_answer
is_correct
tinyint(3) unsigned
NO
0
null
smf_quiz_answer
order
smallint(5) unsigned
NO
0
null
smf_quiz_answer
points
smallint(5) unsigned
NO
0
null
smf_quiz_answer
updated
int(10) unsigned
NO
0
null
smf_quiz_category
description
text
YES
NULL
utf8mb3_general_ci
smf_quiz_category
id_category
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_category
id_parent
int(10) unsigned
NO
0
null
smf_quiz_category
image
varchar(255)
NO
null
utf8mb3_general_ci
smf_quiz_category
name
varchar(255)
NO
'Quiz Category'
utf8mb3_general_ci
smf_quiz_category
quiz_count
int(10) unsigned
NO
0
null
smf_quiz_category
updated
int(10) unsigned
NO
0
null
smf_quiz_dispute
id_quiz
int(10) unsigned
NO
0
null
smf_quiz_dispute
id_quiz_dispute
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_dispute
id_quiz_question
int(10) unsigned
NO
0
null
smf_quiz_dispute
id_user
mediumint(8) unsigned
NO
0
null
smf_quiz_dispute
reason
text
YES
NULL
utf8mb3_general_ci
smf_quiz_dispute
updated
int(10) unsigned
NO
0
null
smf_quiz_infoboard
entry
text
YES
NULL
utf8mb3_general_ci
smf_quiz_infoboard
entry_date
int(10) unsigned
NO
0
null
smf_quiz_infoboard
id_infoboard
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_league
categories
text
YES
NULL
utf8mb3_general_ci
smf_quiz_league
current_round
smallint(5) unsigned
NO
1
null
smf_quiz_league
day_interval
smallint(5) unsigned
NO
0
null
smf_quiz_league
description
text
YES
NULL
utf8mb3_general_ci
smf_quiz_league
id_leader
int(10) unsigned
NO
0
null
smf_quiz_league
id_question_category
int(10) unsigned
NO
0
null
smf_quiz_league
id_quiz_league
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_league
points_for_correct
smallint(5) unsigned
NO
0
null
smf_quiz_league
question_plays
smallint(5)
NO
0
null
smf_quiz_league
questions_per_session
smallint(5) unsigned
NO
0
null
smf_quiz_league
seconds_per_question
smallint(5) unsigned
NO
0
null
smf_quiz_league
show_answers
tinyint(3) unsigned
NO
0
null
smf_quiz_league
state
tinyint(3) unsigned
NO
1
null
smf_quiz_league
title
varchar(255)
NO
'Quiz League Title'
utf8mb3_general_ci
smf_quiz_league
total_correct
int(10) unsigned
NO
0
null
smf_quiz_league
total_incorrect
int(10) unsigned
NO
0
null
smf_quiz_league
total_plays
int(10) unsigned
NO
0
null
smf_quiz_league
total_rounds
smallint(5) unsigned
NO
0
null
smf_quiz_league
total_timeouts
int(10) unsigned
NO
0
null
smf_quiz_league
updated
int(10) unsigned
NO
0
null
smf_quiz_league_result
correct
smallint(5) unsigned
NO
0
null
smf_quiz_league_result
id_quiz_league
int(10) unsigned
NO
0
null
smf_quiz_league_result
id_quiz_league_result
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_league_result
id_user
mediumint(8) unsigned
NO
0
null
smf_quiz_league_result
incorrect
smallint(5) unsigned
NO
0
null
smf_quiz_league_result
points
smallint(5) unsigned
NO
0
null
smf_quiz_league_result
result_date
int(10) unsigned
NO
0
null
smf_quiz_league_result
round
smallint(5) unsigned
NO
0
null
smf_quiz_league_result
seconds
smallint(5) unsigned
NO
0
null
smf_quiz_league_result
timeouts
smallint(5) unsigned
NO
0
null
smf_quiz_league_result
total_resumes
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
correct
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
current_position
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
id_quiz_league
int(10) unsigned
NO
0
null
smf_quiz_league_table
id_quiz_league_table
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_league_table
id_user
mediumint(8) unsigned
NO
0
null
smf_quiz_league_table
incorrect
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
last_position
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
plays
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
points
int(10) unsigned
NO
0
null
smf_quiz_league_table
round
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
seconds
smallint(5) unsigned
NO
0
null
smf_quiz_league_table
timeouts
smallint(5) unsigned
NO
0
null
smf_quiz_question
answer_text
text
YES
NULL
utf8mb3_general_ci
smf_quiz_question
id_question
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_question
id_question_type
int(10) unsigned
NO
0
null
smf_quiz_question
id_quiz
int(10) unsigned
NO
0
null
smf_quiz_question
image
varchar(255)
NO
null
utf8mb3_general_ci
smf_quiz_question
order
smallint(5) unsigned
NO
0
null
smf_quiz_question
order_answers
tinyint(3) unsigned
NO
0
null
smf_quiz_question
plays
int(10) unsigned
NO
0
null
smf_quiz_question
question_text
varchar(255)
NO
'Question Text'
utf8mb3_general_ci
smf_quiz_question
updated
int(10) unsigned
NO
0
null
smf_quiz_question_type
description
varchar(100)
NO
'Description'
utf8mb3_general_ci
smf_quiz_question_type
id_question_type
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_result
auto_completed
tinyint(3) unsigned
NO
0
null
smf_quiz_result
correct
smallint(5) unsigned
NO
0
null
smf_quiz_result
id_quiz
int(10) unsigned
NO
0
null
smf_quiz_result
id_quiz_result
int(10) unsigned
NO
null
auto_increment
null
smf_quiz_result
id_user
mediumint(8) unsigned
NO
0
null
smf_quiz_result
incorrect
smallint(5) unsigned
NO
0
null
smf_quiz_result
questions
smallint(5) unsigned
NO
0
null
smf_quiz_result
result_date
int(10) unsigned
NO
0
null
smf_quiz_result
timeouts
smallint(5) unsigned
NO
0
null
smf_quiz_result
total_points
smallint(5) unsigned
NO
0
null
smf_quiz_result
total_resumes
smallint(5) unsigned
NO
0
null
smf_quiz_result
total_seconds
smallint(5) unsigned
NO
0
null
smf_quiz_session
correct
smallint(5) unsigned
NO
0
null
smf_quiz_session
id_quiz
int(10) unsigned
YES
0
null
smf_quiz_session
id_quiz_league
int(10) unsigned
YES
0
null
smf_quiz_session
id_quiz_session
varchar(38)
NO
null
utf8mb3_general_ci
smf_quiz_session
id_user
mediumint(8) unsigned
NO
0
null
smf_quiz_session
incorrect
smallint(5) unsigned
NO
0
null
smf_quiz_session
last_question_start
int(10) unsigned
NO
0
null
smf_quiz_session
question_count
smallint(5) unsigned
NO
0
null
smf_quiz_session
result_date
int(10) unsigned
NO
0
null
smf_quiz_session
session_start
int(10) unsigned
NO
0
null
smf_quiz_session
timeouts
smallint(5) unsigned
NO
0
null
smf_quiz_session
total_points
smallint(5) unsigned
NO
0
null
smf_quiz_session
total_resumes
smallint(5) unsigned
NO
0
null
smf_quiz_session
total_seconds
smallint(5) unsigned
NO
0
null
smf_scheduled_tasks
callable
varchar(60)
NO
''
utf8mb3_general_ci
smf_scheduled_tasks
callable
varchar(60)
NO
utf8_general_ci
smf_scheduled_tasks
disabled
tinyint(4)
NO
0
null
smf_scheduled_tasks
disabled
tinyint
NO
0
null
smf_scheduled_tasks
id_task
smallint(6)
NO
null
auto_increment
null
smf_scheduled_tasks
id_task
smallint
NO
null
auto_increment
null
smf_scheduled_tasks
next_time
int(10)
NO
0
null
smf_scheduled_tasks
next_time
int
NO
0
null
smf_scheduled_tasks
task
varchar(24)
NO
''
utf8mb3_general_ci
smf_scheduled_tasks
task
varchar(24)
NO
utf8_general_ci
smf_scheduled_tasks
time_offset
int(10)
NO
0
null
smf_scheduled_tasks
time_offset
int
NO
0
null
smf_scheduled_tasks
time_regularity
smallint(6)
NO
0
null
smf_scheduled_tasks
time_regularity
smallint
NO
0
null
smf_scheduled_tasks
time_unit
varchar(1)
NO
'h'
utf8mb3_general_ci
smf_scheduled_tasks
time_unit
varchar(1)
NO
h
utf8_general_ci
smf_sessions
data
text
NO
null
utf8mb3_general_ci
smf_sessions
data
text
NO
null
utf8_general_ci
smf_sessions
last_update
int(10) unsigned
NO
0
null
smf_sessions
last_update
int unsigned
NO
0
null
smf_sessions
session_id
varchar(128)
NO
''
utf8mb3_general_ci
smf_sessions
session_id
varchar(128)
NO
utf8_general_ci
smf_settings
value
text
NO
null
utf8mb3_general_ci
smf_settings
value
text
NO
null
utf8_general_ci
smf_settings
variable
varchar(255)
NO
''
utf8mb3_general_ci
smf_settings
variable
varchar(255)
NO
utf8_general_ci
smf_smiley_files
filename
varchar(48)
NO
''
utf8mb3_general_ci
smf_smiley_files
filename
varchar(48)
NO
utf8_general_ci
smf_smiley_files
id_smiley
smallint(6)
NO
0
null
smf_smiley_files
id_smiley
smallint
NO
0
null
smf_smiley_files
smiley_set
varchar(48)
NO
''
utf8mb3_general_ci
smf_smiley_files
smiley_set
varchar(48)
NO
utf8_general_ci
smf_smileys
code
varchar(30)
NO
''
utf8mb3_general_ci
smf_smileys
code
varchar(30)
NO
utf8_general_ci
smf_smileys
description
varchar(80)
NO
''
utf8mb3_general_ci
smf_smileys
description
varchar(80)
NO
utf8_general_ci
smf_smileys
hidden
tinyint(3) unsigned
NO
0
null
smf_smileys
hidden
tinyint unsigned
NO
0
null
smf_smileys
id_smiley
smallint(5) unsigned
NO
null
auto_increment
null
smf_smileys
id_smiley
smallint unsigned
NO
null
auto_increment
null
smf_smileys
smiley_order
smallint(5) unsigned
NO
0
null
smf_smileys
smiley_order
smallint unsigned
NO
0
null
smf_smileys
smiley_row
tinyint(3) unsigned
NO
0
null
smf_smileys
smiley_row
tinyint unsigned
NO
0
null
smf_spiders
id_spider
smallint(5) unsigned
NO
null
auto_increment
null
smf_spiders
id_spider
smallint unsigned
NO
null
auto_increment
null
smf_spiders
ip_info
varchar(255)
NO
''
utf8mb3_general_ci
smf_spiders
ip_info
varchar(255)
NO
utf8_general_ci
smf_spiders
spider_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_spiders
spider_name
varchar(255)
NO
utf8_general_ci
smf_spiders
user_agent
varchar(255)
NO
''
utf8mb3_general_ci
smf_spiders
user_agent
varchar(255)
NO
utf8_general_ci
smf_stshop_categories
catid
int(5) unsigned
NO
null
auto_increment
null
smf_stshop_categories
description
varchar(255)
NO
null
utf8mb3_general_ci
smf_stshop_categories
image
tinytext
NO
null
utf8mb3_general_ci
smf_stshop_categories
name
varchar(50)
NO
null
utf8mb3_general_ci
smf_stshop_inventory
date
int(11) unsigned
NO
null
null
smf_stshop_inventory
fav
tinyint(3) unsigned
NO
0
null
smf_stshop_inventory
id
mediumint(10) unsigned
NO
null
auto_increment
null
smf_stshop_inventory
itemid
int(10) unsigned
YES
NULL
null
smf_stshop_inventory
tradecost
int(10) unsigned
NO
0
null
smf_stshop_inventory
tradedate
int(11) unsigned
NO
0
null
smf_stshop_inventory
trading
tinyint(1) unsigned
NO
0
null
smf_stshop_inventory
userid
mediumint(10) unsigned
NO
null
null
smf_stshop_items
can_use_item
tinyint(1) unsigned
NO
0
null
smf_stshop_items
catid
int(10) unsigned
NO
0
null
smf_stshop_items
delete_after_use
tinyint(1) unsigned
NO
0
null
smf_stshop_items
description
varchar(255)
NO
null
utf8mb3_general_ci
smf_stshop_items
image
tinytext
YES
NULL
utf8mb3_general_ci
smf_stshop_items
info1
int(11)
YES
NULL
null
smf_stshop_items
info2
int(11)
YES
NULL
null
smf_stshop_items
info3
int(11)
YES
NULL
null
smf_stshop_items
info4
int(11)
YES
NULL
null
smf_stshop_items
input_needed
tinyint(1) unsigned
NO
0
null
smf_stshop_items
itemid
int(10) unsigned
NO
null
auto_increment
null
smf_stshop_items
itemlimit
int(10) unsigned
NO
0
null
smf_stshop_items
module
int(10) unsigned
NO
0
null
smf_stshop_items
name
varchar(50)
NO
null
utf8mb3_general_ci
smf_stshop_items
price
mediumint(8) unsigned
NO
0
null
smf_stshop_items
status
smallint(5) unsigned
NO
1
null
smf_stshop_items
stock
smallint(5) unsigned
NO
0
null
smf_stshop_log_bank
action
tinytext
NO
null
utf8mb3_general_ci
smf_stshop_log_bank
amount
int(10) unsigned
NO
null
null
smf_stshop_log_bank
date
int(11) unsigned
NO
null
null
smf_stshop_log_bank
fee
mediumint(10) unsigned
NO
0
null
smf_stshop_log_bank
id
int(10) unsigned
NO
null
auto_increment
null
smf_stshop_log_bank
type
smallint(10) unsigned
NO
null
null
smf_stshop_log_bank
userid
mediumint(10) unsigned
NO
null
null
smf_stshop_log_buy
amount
int(10) unsigned
NO
null
null
smf_stshop_log_buy
date
int(11) unsigned
NO
null
null
smf_stshop_log_buy
fee
int(10) unsigned
NO
0
null
smf_stshop_log_buy
id
int(10) unsigned
NO
null
auto_increment
null
smf_stshop_log_buy
invid
mediumint(10) unsigned
NO
null
null
smf_stshop_log_buy
itemid
int(10) unsigned
NO
null
null
smf_stshop_log_buy
sellerid
mediumint(10) unsigned
NO
0
null
smf_stshop_log_buy
userid
mediumint(10) unsigned
NO
null
null
smf_stshop_log_content
content
varchar(25)
NO
null
utf8mb3_general_ci
smf_stshop_log_content
id_member
mediumint(10) unsigned
NO
null
null
smf_stshop_log_content
id_msg
int(10) unsigned
NO
null
null
smf_stshop_log_games
amount
int(10) unsigned
NO
null
null
smf_stshop_log_games
date
int(11) unsigned
NO
null
null
smf_stshop_log_games
game
tinytext
NO
null
utf8mb3_general_ci
smf_stshop_log_games
id
int(10) unsigned
NO
null
auto_increment
null
smf_stshop_log_games
userid
mediumint(10) unsigned
NO
null
null
smf_stshop_log_gift
amount
int(10) unsigned
NO
null
null
smf_stshop_log_gift
date
int(11) unsigned
NO
null
null
smf_stshop_log_gift
id
int(10) unsigned
NO
null
auto_increment
null
smf_stshop_log_gift
invid
mediumint(10) unsigned
NO
0
null
smf_stshop_log_gift
is_admin
tinyint(3) unsigned
NO
0
null
smf_stshop_log_gift
itemid
mediumint(10) unsigned
NO
null
null
smf_stshop_log_gift
message
varchar(255)
NO
null
utf8mb3_general_ci
smf_stshop_log_gift
receiver
mediumint(10) unsigned
NO
null
null
smf_stshop_log_gift
userid
mediumint(10) unsigned
NO
null
null
smf_stshop_modules
author
varchar(80)
NO
null
utf8mb3_general_ci
smf_stshop_modules
can_use_item
tinyint(3) unsigned
NO
0
null
smf_stshop_modules
description
varchar(255)
NO
null
utf8mb3_general_ci
smf_stshop_modules
editable_input
tinyint(3) unsigned
NO
0
null
smf_stshop_modules
email
varchar(255)
NO
null
utf8mb3_general_ci
smf_stshop_modules
file
tinytext
NO
null
utf8mb3_general_ci
smf_stshop_modules
id
int(10) unsigned
NO
null
auto_increment
null
smf_stshop_modules
name
varchar(50)
NO
null
utf8mb3_general_ci
smf_stshop_modules
price
int(10) unsigned
NO
0
null
smf_stshop_modules
require_input
tinyint(3) unsigned
NO
0
null
smf_stshop_modules
web
varchar(255)
NO
null
utf8mb3_general_ci
smf_subscriptions
active
tinyint(4)
NO
1
null
smf_subscriptions
active
tinyint
NO
1
null
smf_subscriptions
add_groups
varchar(40)
NO
''
utf8mb3_general_ci
smf_subscriptions
add_groups
varchar(40)
NO
utf8_general_ci
smf_subscriptions
allow_partial
tinyint(4)
NO
0
null
smf_subscriptions
allow_partial
tinyint
NO
0
null
smf_subscriptions
cost
text
NO
null
utf8mb3_general_ci
smf_subscriptions
cost
text
NO
null
utf8_general_ci
smf_subscriptions
description
varchar(255)
NO
''
utf8mb3_general_ci
smf_subscriptions
description
varchar(255)
NO
utf8_general_ci
smf_subscriptions
email_complete
text
NO
null
utf8mb3_general_ci
smf_subscriptions
email_complete
text
NO
null
utf8_general_ci
smf_subscriptions
id_group
smallint(6)
NO
0
null
smf_subscriptions
id_group
smallint
NO
0
null
smf_subscriptions
id_subscribe
mediumint(8) unsigned
NO
null
auto_increment
null
smf_subscriptions
id_subscribe
mediumint unsigned
NO
null
auto_increment
null
smf_subscriptions
length
varchar(6)
NO
''
utf8mb3_general_ci
smf_subscriptions
length
varchar(6)
NO
utf8_general_ci
smf_subscriptions
name
varchar(60)
NO
''
utf8mb3_general_ci
smf_subscriptions
name
varchar(60)
NO
utf8_general_ci
smf_subscriptions
reminder
tinyint(4)
NO
0
null
smf_subscriptions
reminder
tinyint
NO
0
null
smf_subscriptions
repeatable
tinyint(4)
NO
0
null
smf_subscriptions
repeatable
tinyint
NO
0
null
smf_themes
id_member
mediumint(9)
NO
0
null
smf_themes
id_member
mediumint
NO
0
null
smf_themes
id_theme
tinyint(3) unsigned
NO
1
null
smf_themes
id_theme
tinyint unsigned
NO
1
null
smf_themes
value
text
NO
null
utf8mb3_general_ci
smf_themes
value
text
NO
null
utf8_general_ci
smf_themes
variable
varchar(255)
NO
''
utf8mb3_general_ci
smf_themes
variable
varchar(255)
NO
utf8_general_ci
smf_topic_ratings
id
mediumint(8) unsigned
NO
null
null
smf_topic_ratings
total_value
mediumint(8)
NO
0
null
smf_topic_ratings
total_votes
mediumint(8)
NO
0
null
smf_topic_ratings
user_ids
longtext
NO
null
utf8mb3_general_ci
smf_topics
approved
tinyint(4)
NO
1
null
smf_topics
approved
tinyint
NO
1
null
smf_topics
id_board
smallint(5) unsigned
NO
0
null
smf_topics
id_board
smallint unsigned
NO
0
null
smf_topics
id_first_msg
int(10) unsigned
NO
0
null
smf_topics
id_first_msg
int unsigned
NO
0
null
smf_topics
id_last_msg
int(10) unsigned
NO
0
null
smf_topics
id_last_msg
int unsigned
NO
0
null
smf_topics
id_member_started
mediumint(8) unsigned
NO
0
null
smf_topics
id_member_started
mediumint unsigned
NO
0
null
smf_topics
id_member_updated
mediumint(8) unsigned
NO
0
null
smf_topics
id_member_updated
mediumint unsigned
NO
0
null
smf_topics
id_poll
mediumint(8) unsigned
NO
0
null
smf_topics
id_poll
mediumint unsigned
NO
0
null
smf_topics
id_previous_board
smallint(6)
NO
0
null
smf_topics
id_previous_board
smallint
NO
0
null
smf_topics
id_previous_topic
mediumint(9)
NO
0
null
smf_topics
id_previous_topic
mediumint
NO
0
null
smf_topics
id_redirect_topic
mediumint(8) unsigned
NO
0
null
smf_topics
id_redirect_topic
mediumint unsigned
NO
0
null
smf_topics
id_topic
mediumint(8) unsigned
NO
null
auto_increment
null
smf_topics
id_topic
mediumint unsigned
NO
null
auto_increment
null
smf_topics
is_sticky
tinyint(4)
NO
0
null
smf_topics
is_sticky
tinyint
NO
0
null
smf_topics
locked
tinyint(4)
NO
0
null
smf_topics
locked
tinyint
NO
0
null
smf_topics
num_replies
int(10) unsigned
NO
0
null
smf_topics
num_replies
int unsigned
NO
0
null
smf_topics
num_views
int(10) unsigned
NO
0
null
smf_topics
num_views
int unsigned
NO
0
null
smf_topics
redirect_expires
int(10) unsigned
NO
0
null
smf_topics
redirect_expires
int unsigned
NO
0
null
smf_topics
unapproved_posts
smallint(6)
NO
0
null
smf_topics
unapproved_posts
smallint
NO
0
null
smf_tp_articles
approved
smallint(6)
NO
0
null
smf_tp_articles
author
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
author_id
int(11)
NO
0
null
smf_tp_articles
body
longtext
YES
NULL
utf8mb3_general_ci
smf_tp_articles
category
smallint(6)
NO
0
null
smf_tp_articles
comments
smallint(4)
NO
0
null
smf_tp_articles
comments_var
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
date
int(11)
NO
0
null
smf_tp_articles
featured
smallint(6)
NO
0
null
smf_tp_articles
fileimport
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
frame
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_articles
frontpage
smallint(1)
NO
0
null
smf_tp_articles
headers
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
id
int(11)
NO
null
auto_increment
null
smf_tp_articles
id_theme
smallint(6)
NO
0
null
smf_tp_articles
illustration
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
intro
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
locked
smallint(6)
NO
0
null
smf_tp_articles
off
smallint(6)
NO
0
null
smf_tp_articles
options
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
parse
smallint(6)
NO
0
null
smf_tp_articles
pub_end
int(11)
NO
0
null
smf_tp_articles
pub_start
int(11)
NO
0
null
smf_tp_articles
rating
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
shortname
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_articles
sticky
smallint(6)
NO
0
null
smf_tp_articles
subject
text
YES
NULL
utf8mb3_general_ci
smf_tp_articles
topic
int(11)
NO
0
null
smf_tp_articles
type
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_articles
useintro
smallint(1)
NO
0
null
smf_tp_articles
views
int(11)
NO
0
null
smf_tp_articles
voters
text
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
access
text
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
bar
smallint(4)
NO
0
null
smf_tp_blocks
body
text
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
display
text
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
frame
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
id
int(11)
NO
null
auto_increment
null
smf_tp_blocks
lang
text
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
off
smallint(1)
NO
0
null
smf_tp_blocks
pos
int(11)
NO
0
null
smf_tp_blocks
settings
text
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
title
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_blocks
type
smallint(6)
NO
0
null
smf_tp_blocks
visible
text
YES
NULL
utf8mb3_general_ci
smf_tp_comments
comment
text
YES
NULL
utf8mb3_general_ci
smf_tp_comments
datetime
int(11)
NO
0
null
smf_tp_comments
id
int(11)
NO
null
auto_increment
null
smf_tp_comments
item_id
int(11)
NO
0
null
smf_tp_comments
item_type
varchar(255)
NO
null
utf8mb3_general_ci
smf_tp_comments
member_id
int(11)
NO
0
null
smf_tp_comments
subject
text
YES
NULL
utf8mb3_general_ci
smf_tp_data
id
int(11)
NO
null
auto_increment
null
smf_tp_data
id_member
int(11)
NO
0
null
smf_tp_data
item
int(11)
NO
0
null
smf_tp_data
type
smallint(4)
NO
0
null
smf_tp_data
value
smallint(6)
NO
0
null
smf_tp_dldata
downloads
bigint(20)
NO
0
null
smf_tp_dldata
id
bigint(20)
NO
null
auto_increment
null
smf_tp_dldata
item
int(11)
NO
0
null
smf_tp_dldata
views
bigint(20)
NO
0
null
smf_tp_dldata
week
smallint(4)
NO
0
null
smf_tp_dldata
year
smallint(6)
NO
0
null
smf_tp_dlmanager
access
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
author_id
int(11)
NO
0
null
smf_tp_dlmanager
category
int(11)
NO
0
null
smf_tp_dlmanager
created
int(11)
NO
0
null
smf_tp_dlmanager
description
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
downloads
int(11)
NO
0
null
smf_tp_dlmanager
file
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
files
int(11)
NO
0
null
smf_tp_dlmanager
filesize
int(11)
NO
0
null
smf_tp_dlmanager
icon
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
id
int(11)
NO
null
auto_increment
null
smf_tp_dlmanager
last_access
int(11)
NO
0
null
smf_tp_dlmanager
link
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
name
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
parent
int(11)
NO
0
null
smf_tp_dlmanager
rating
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
screenshot
text
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
subitem
int(11)
NO
0
null
smf_tp_dlmanager
type
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_dlmanager
views
int(11)
NO
0
null
smf_tp_dlmanager
voters
text
YES
NULL
utf8mb3_general_ci
smf_tp_events
allowed
mediumtext
YES
NULL
utf8mb3_general_ci
smf_tp_events
date
int(11)
NO
0
null
smf_tp_events
description
mediumtext
YES
NULL
utf8mb3_general_ci
smf_tp_events
eventid
int(11)
NO
0
null
smf_tp_events
id
int(11)
NO
null
auto_increment
null
smf_tp_events
id_member
int(11)
NO
0
null
smf_tp_events
link
mediumtext
YES
NULL
utf8mb3_general_ci
smf_tp_events
on
smallint(4)
NO
0
null
smf_tp_events
textvariable
mediumtext
YES
NULL
utf8mb3_general_ci
smf_tp_menu
enabled
smallint(4)
NO
0
null
smf_tp_menu
id
int(11)
NO
null
auto_increment
null
smf_tp_menu
link
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_menu
name
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_menu
parent
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_menu
permissions
mediumtext
YES
NULL
utf8mb3_general_ci
smf_tp_menu
type
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_settings
id
mediumint(9)
NO
null
auto_increment
null
smf_tp_settings
name
text
YES
NULL
utf8mb3_general_ci
smf_tp_settings
value
text
YES
NULL
utf8mb3_general_ci
smf_tp_shoutbox
content
text
YES
NULL
utf8mb3_general_ci
smf_tp_shoutbox
edit
smallint(4)
NO
0
null
smf_tp_shoutbox
id
int(11)
NO
null
auto_increment
null
smf_tp_shoutbox
member_id
int(11)
NO
-2
null
smf_tp_shoutbox
member_ip
text
YES
NULL
utf8mb3_general_ci
smf_tp_shoutbox
member_link
text
YES
NULL
utf8mb3_general_ci
smf_tp_shoutbox
shoutbox_id
int(3)
YES
1
null
smf_tp_shoutbox
time
text
YES
NULL
utf8mb3_general_ci
smf_tp_shoutbox
type
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_variables
id
int(11)
NO
null
auto_increment
null
smf_tp_variables
subtype
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_variables
subtype2
int(11)
NO
0
null
smf_tp_variables
type
tinytext
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value1
text
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value2
text
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value3
text
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value4
text
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value5
int(11)
NO
-2
null
smf_tp_variables
value7
text
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value8
text
YES
NULL
utf8mb3_general_ci
smf_tp_variables
value9
text
YES
NULL
utf8mb3_general_ci
smf_tweet_cache
html
text
YES
NULL
utf8mb4_unicode_ci
smf_tweet_cache
id
int(11)
NO
null
auto_increment
null
smf_tweet_cache
tweetid
bigint(30)
YES
0
null
smf_user_alerts
alert_time
int(10) unsigned
NO
0
null
smf_user_alerts
alert_time
int unsigned
NO
0
null
smf_user_alerts
content_action
varchar(255)
NO
''
utf8mb3_general_ci
smf_user_alerts
content_action
varchar(255)
NO
utf8_general_ci
smf_user_alerts
content_id
int(10) unsigned
NO
0
null
smf_user_alerts
content_id
int unsigned
NO
0
null
smf_user_alerts
content_type
varchar(255)
NO
''
utf8mb3_general_ci
smf_user_alerts
content_type
varchar(255)
NO
utf8_general_ci
smf_user_alerts
extra
text
NO
null
utf8mb3_general_ci
smf_user_alerts
extra
text
NO
null
utf8_general_ci
smf_user_alerts
id_alert
int(10) unsigned
NO
null
auto_increment
null
smf_user_alerts
id_alert
int unsigned
NO
null
auto_increment
null
smf_user_alerts
id_member
mediumint(8) unsigned
NO
0
null
smf_user_alerts
id_member
mediumint unsigned
NO
0
null
smf_user_alerts
id_member_started
mediumint(8) unsigned
NO
0
null
smf_user_alerts
id_member_started
mediumint unsigned
NO
0
null
smf_user_alerts
is_read
int(10) unsigned
NO
0
null
smf_user_alerts
is_read
int unsigned
NO
0
null
smf_user_alerts
member_name
varchar(255)
NO
''
utf8mb3_general_ci
smf_user_alerts
member_name
varchar(255)
NO
utf8_general_ci
smf_user_alerts_prefs
alert_pref
varchar(32)
NO
''
utf8mb3_general_ci
smf_user_alerts_prefs
alert_pref
varchar(32)
NO
utf8_general_ci
smf_user_alerts_prefs
alert_value
tinyint(4)
NO
0
null
smf_user_alerts_prefs
alert_value
tinyint
NO
0
null
smf_user_alerts_prefs
id_member
mediumint(8) unsigned
NO
0
null
smf_user_alerts_prefs
id_member
mediumint unsigned
NO
0
null
smf_user_drafts
body
mediumtext
NO
null
utf8mb3_general_ci
smf_user_drafts
body
mediumtext
NO
null
utf8_general_ci
smf_user_drafts
icon
varchar(16)
NO
'xx'
utf8mb3_general_ci
smf_user_drafts
icon
varchar(16)
NO
xx
utf8_general_ci
smf_user_drafts
id_board
smallint(5) unsigned
NO
0
null
smf_user_drafts
id_board
smallint unsigned
NO
0
null
smf_user_drafts
id_draft
int(10) unsigned
NO
null
auto_increment
null
smf_user_drafts
id_draft
int unsigned
NO
null
auto_increment
null
smf_user_drafts
id_member
mediumint(8) unsigned
NO
0
null
smf_user_drafts
id_member
mediumint unsigned
NO
0
null
smf_user_drafts
id_reply
int(10) unsigned
NO
0
null
smf_user_drafts
id_reply
int unsigned
NO
0
null
smf_user_drafts
id_topic
mediumint(8) unsigned
NO
0
null
smf_user_drafts
id_topic
mediumint unsigned
NO
0
null
smf_user_drafts
is_sticky
tinyint(4)
NO
0
null
smf_user_drafts
is_sticky
tinyint
NO
0
null
smf_user_drafts
locked
tinyint(4)
NO
0
null
smf_user_drafts
locked
tinyint
NO
0
null
smf_user_drafts
poster_time
int(10) unsigned
NO
0
null
smf_user_drafts
poster_time
int unsigned
NO
0
null
smf_user_drafts
smileys_enabled
tinyint(4)
NO
1
null
smf_user_drafts
smileys_enabled
tinyint
NO
1
null
smf_user_drafts
subject
varchar(255)
NO
''
utf8mb3_general_ci
smf_user_drafts
subject
varchar(255)
NO
utf8_general_ci
smf_user_drafts
to_list
varchar(255)
NO
''
utf8mb3_general_ci
smf_user_drafts
to_list
varchar(255)
NO
utf8_general_ci
smf_user_drafts
type
tinyint(4)
NO
0
null
smf_user_drafts
type
tinyint
NO
0
null
smf_user_likes
content_id
int(10) unsigned
NO
0
null
smf_user_likes
content_id
int unsigned
NO
0
null
smf_user_likes
content_type
char(6)
NO
''
utf8mb3_general_ci
smf_user_likes
content_type
char(6)
NO
utf8_general_ci
smf_user_likes
id_member
mediumint(8) unsigned
NO
0
null
smf_user_likes
id_member
mediumint unsigned
NO
0
null
smf_user_likes
like_time
int(10) unsigned
NO
0
null
smf_user_likes
like_time
int unsigned
NO
0
null


TABLE_NAME
NON_UNIQUE
INDEX_NAME
SEQ_IN_INDEX
COLUMN_NAME
SUB_PART
TABLE_NAME
NON_UNIQUE
INDEX_NAME
SEQ_IN_INDEX
COLUMN_NAME
SUB_PART
smf_admin_info_files
1
idx_filename
1
filename
30
smf_admin_info_files
1
idx_filename
1
filename
30
smf_admin_info_files
0
PRIMARY
1
id_file
null
smf_admin_info_files
0
PRIMARY
1
id_file
null
smf_arcade_categories
0
PRIMARY
1
id_cat
null
smf_arcade_favorite
0
PRIMARY
1
id_favorite
null
smf_arcade_favorite
1
id_game
1
id_game
null
smf_arcade_favorite
1
id_game
2
id_member
null
smf_arcade_files
0
PRIMARY
1
id_file
null
smf_arcade_game_info
0
PRIMARY
1
id_game
null
smf_arcade_games
0
PRIMARY
1
id_game
null
smf_arcade_games
0
internal_name
1
internal_name
null
smf_arcade_guest_data
0
PRIMARY
1
online_ip
null
smf_arcade_guest_extra_data
0
PRIMARY
1
online_ip
null
smf_arcade_internal_game_conflicts
0
PRIMARY
1
id_conflict
null
smf_arcade_internal_gamedata
0
PRIMARY
1
id_conflict
null
smf_arcade_lists
0
PRIMARY
1
id_list
null
smf_arcade_matches
0
PRIMARY
1
id_match
null
smf_arcade_matches_players
0
PRIMARY
1
id_match
null
smf_arcade_matches_players
0
PRIMARY
2
id_member
null
smf_arcade_matches_results
0
PRIMARY
1
id_match
null
smf_arcade_matches_results
0
PRIMARY
2
id_member
null
smf_arcade_matches_results
0
PRIMARY
3
round
null
smf_arcade_matches_rounds
0
PRIMARY
1
id_match
null
smf_arcade_matches_rounds
0
PRIMARY
2
round
null
smf_arcade_member_data
0
PRIMARY
1
id_member
null
smf_arcade_membergroups
0
PRIMARY
1
id_group
null
smf_arcade_members
0
PRIMARY
1
id_member
null
smf_arcade_mobile_lists
0
PRIMARY
1
id_list
null
smf_arcade_mobile_skins
0
PRIMARY
1
id_skin
null
smf_arcade_newshouts
0
PRIMARY
1
id_shout
null
smf_arcade_pdl1
0
PRIMARY
1
id_member
null
smf_arcade_pdl2
0
PRIMARY
1
pdl_gameid
null
smf_arcade_rates
1
id_game
1
id_game
null
smf_arcade_rates
0
PRIMARY
1
id_game
null
smf_arcade_rates
0
PRIMARY
2
id_member
null
smf_arcade_scores
1
id_game
1
id_game
null
smf_arcade_scores
1
personal_best
1
id_member
null
smf_arcade_scores
1
personal_best
2
personal_best
null
smf_arcade_scores
0
PRIMARY
1
id_score
null
smf_arcade_skins
0
PRIMARY
1
id_skin
null
smf_attachments
1
idx_attachment_type
1
attachment_type
null
smf_attachments
1
idx_attachment_type
1
attachment_type
null
smf_attachments
0
PRIMARY
1
id_attach
null
smf_attachments
0
PRIMARY
1
id_attach
null
smf_attachments
0
idx_id_member
1
id_member
null
smf_attachments
0
idx_id_member
1
id_member
null
smf_attachments
0
idx_id_member
2
id_attach
null
smf_attachments
0
idx_id_member
2
id_attach
null
smf_attachments
1
idx_id_msg
1
id_msg
null
smf_attachments
1
idx_id_msg
1
id_msg
null
smf_attachments
1
idx_id_thumb
1
id_thumb
null
smf_attachments
1
idx_id_thumb
1
id_thumb
null
smf_background_tasks
0
PRIMARY
1
id_task
null
smf_background_tasks
0
PRIMARY
1
id_task
null
smf_ban_groups
0
PRIMARY
1
id_ban_group
null
smf_ban_groups
0
PRIMARY
1
id_ban_group
null
smf_ban_items
0
PRIMARY
1
id_ban
null
smf_ban_items
0
PRIMARY
1
id_ban
null
smf_ban_items
1
idx_id_ban_group
1
id_ban_group
null
smf_ban_items
1
idx_id_ban_group
1
id_ban_group
null
smf_ban_items
1
idx_ban_items_iplow_high
1
ip_low
null
smf_ban_items
1
idx_id_ban_ip
1
ip_low
null
smf_ban_items
1
idx_ban_items_iplow_high
2
ip_high
null
smf_ban_items
1
idx_id_ban_ip
2
ip_high
null
smf_battle_campaign_1
0
PRIMARY
1
id_warrior
null
smf_battle_campaign_2
0
PRIMARY
1
id_warrior
null
smf_battle_campaign_3
0
PRIMARY
1
id_warrior
null
smf_battle_champs
0
PRIMARY
1
id_champ
null
smf_battle_explore
0
PRIMARY
1
id_explore
null
smf_battle_graveyard
0
PRIMARY
1
id_grave
null
smf_battle_history
0
PRIMARY
1
id_hist
null
smf_battle_members
0
PRIMARY
1
member_id
null
smf_battle_members
0
PRIMARY
2
opponent_id
null
smf_battle_monsters
0
PRIMARY
1
id_monster
null
smf_battle_monsters_fight
0
PRIMARY
1
id_warrior
null
smf_battle_monsters_fight
0
PRIMARY
2
id_monster
null
smf_battle_quest
0
PRIMARY
1
id_quest
null
smf_battle_quest_champs
0
PRIMARY
1
id_warrior
null
smf_battle_quest_champs
0
PRIMARY
2
id_quest
null
smf_battle_scores
0
PRIMARY
1
battle_title
null
smf_battle_scores
0
PRIMARY
2
id_warrior
null
smf_battle_shop
0
PRIMARY
1
id_item
null
smf_battle_shouts
0
PRIMARY
1
id_shout
null
smf_board_permissions
0
PRIMARY
1
id_group
null
smf_board_permissions
0
PRIMARY
1
id_group
null
smf_board_permissions
0
PRIMARY
2
id_profile
null
smf_board_permissions
0
PRIMARY
2
id_profile
null
smf_board_permissions
0
PRIMARY
3
permission
null
smf_board_permissions
0
PRIMARY
3
permission
null
smf_board_permissions_view
0
PRIMARY
1
id_group
null
smf_board_permissions_view
0
PRIMARY
1
id_group
null
smf_board_permissions_view
0
PRIMARY
2
id_board
null
smf_board_permissions_view
0
PRIMARY
2
id_board
null
smf_board_permissions_view
0
PRIMARY
3
deny
null
smf_board_permissions_view
0
PRIMARY
3
deny
null
smf_boards
0
PRIMARY
1
id_board
null
smf_boards
0
PRIMARY
1
id_board
null
smf_boards
0
idx_categories
1
id_cat
null
smf_boards
0
idx_categories
1
id_cat
null
smf_boards
0
idx_categories
2
id_board
null
smf_boards
0
idx_categories
2
id_board
null
smf_boards
1
idx_id_msg_updated
1
id_msg_updated
null
smf_boards
1
idx_id_msg_updated
1
id_msg_updated
null
smf_boards
1
idx_id_parent
1
id_parent
null
smf_boards
1
idx_id_parent
1
id_parent
null
smf_boards
1
idx_member_groups
1
member_groups
48
smf_boards
1
idx_member_groups
1
member_groups
48
smf_calendar
1
idx_end_date
1
end_date
null
smf_calendar
1
idx_end_date
1
end_date
null
smf_calendar
0
PRIMARY
1
id_event
null
smf_calendar
0
PRIMARY
1
id_event
null
smf_calendar
1
idx_topic
1
id_topic
null
smf_calendar
1
idx_topic
1
id_topic
null
smf_calendar
1
idx_topic
2
id_member
null
smf_calendar
1
idx_topic
2
id_member
null
smf_calendar
1
idx_start_date
1
start_date
null
smf_calendar
1
idx_start_date
1
start_date
null
smf_calendar_holidays
1
idx_event_date
1
event_date
null
smf_calendar_holidays
1
idx_event_date
1
event_date
null
smf_calendar_holidays
0
PRIMARY
1
id_holiday
null
smf_calendar_holidays
0
PRIMARY
1
id_holiday
null
smf_categories
0
PRIMARY
1
id_cat
null
smf_categories
0
PRIMARY
1
id_cat
null
smf_custom_fields
0
idx_col_name
1
col_name
null
smf_custom_fields
0
idx_col_name
1
col_name
null
smf_custom_fields
0
PRIMARY
1
id_field
null
smf_custom_fields
0
PRIMARY
1
id_field
null
smf_feedback
1
ID_LISTING
1
ID_LISTING
null
smf_feedback
1
ID_MEMBER
1
ID_MEMBER
null
smf_feedback
0
PRIMARY
1
feedbackid
null
smf_group_moderators
0
PRIMARY
1
id_group
null
smf_group_moderators
0
PRIMARY
1
id_group
null
smf_group_moderators
0
PRIMARY
2
id_member
null
smf_group_moderators
0
PRIMARY
2
id_member
null
smf_log_actions
0
PRIMARY
1
id_action
null
smf_log_actions
0
PRIMARY
1
id_action
null
smf_log_actions
1
idx_id_board
1
id_board
null
smf_log_actions
1
idx_id_board
1
id_board
null
smf_log_actions
1
idx_id_log
1
id_log
null
smf_log_actions
1
idx_id_log
1
id_log
null
smf_log_actions
1
idx_id_member
1
id_member
null
smf_log_actions
1
idx_id_member
1
id_member
null
smf_log_actions
1
idx_id_msg
1
id_msg
null
smf_log_actions
1
idx_id_msg
1
id_msg
null
smf_log_actions
1
id_topic_id_log
1
id_topic
null
smf_log_actions
1
idx_id_topic_id_log
1
id_topic
null
smf_log_actions
1
id_topic_id_log
2
id_log
null
smf_log_actions
1
idx_id_topic_id_log
2
id_log
null
smf_log_actions
1
idx_log_time
1
log_time
null
smf_log_actions
1
idx_log_time
1
log_time
null
smf_log_activity
0
PRIMARY
1
DATE
null
smf_log_activity
0
PRIMARY
1
date
null
smf_log_banned
0
PRIMARY
1
id_ban_log
null
smf_log_banned
0
PRIMARY
1
id_ban_log
null
smf_log_banned
1
idx_log_time
1
log_time
null
smf_log_banned
1
idx_log_time
1
log_time
null
smf_log_boards
0
PRIMARY
1
id_member
null
smf_log_boards
0
PRIMARY
1
id_member
null
smf_log_boards
0
PRIMARY
2
id_board
null
smf_log_boards
0
PRIMARY
2
id_board
null
smf_log_comments
1
idx_comment_type
1
comment_type
null
smf_log_comments
1
idx_comment_type
1
comment_type
null
smf_log_comments
0
PRIMARY
1
id_comment
null
smf_log_comments
0
PRIMARY
1
id_comment
null
smf_log_comments
1
idx_id_recipient
1
id_recipient
null
smf_log_comments
1
idx_id_recipient
1
id_recipient
null
smf_log_comments
1
idx_log_time
1
log_time
null
smf_log_comments
1
idx_log_time
1
log_time
null
smf_log_errors
0
PRIMARY
1
id_error
null
smf_log_errors
0
PRIMARY
1
id_error
null
smf_log_errors
1
idx_id_member
1
id_member
null
smf_log_errors
1
idx_id_member
1
id_member
null
smf_log_errors
1
idx_ip
1
ip
null
smf_log_errors
1
idx_ip
1
ip
null
smf_log_errors
1
idx_log_time
1
log_time
null
smf_log_errors
1
idx_log_time
1
log_time
null
smf_log_floodcontrol
0
PRIMARY
1
ip
null
smf_log_floodcontrol
0
PRIMARY
1
ip
null
smf_log_floodcontrol
0
PRIMARY
2
log_type
null
smf_log_floodcontrol
0
PRIMARY
2
log_type
null
smf_log_group_requests
1
idx_id_member
1
id_member
null
smf_log_group_requests
1
idx_id_member
1
id_member
null
smf_log_group_requests
1
idx_id_member
2
id_group
null
smf_log_group_requests
1
idx_id_member
2
id_group
null
smf_log_group_requests
0
PRIMARY
1
id_request
null
smf_log_group_requests
0
PRIMARY
1
id_request
null
smf_log_mark_read
0
PRIMARY
1
id_member
null
smf_log_mark_read
0
PRIMARY
1
id_member
null
smf_log_mark_read
0
PRIMARY
2
id_board
null
smf_log_mark_read
0
PRIMARY
2
id_board
null
smf_log_member_notices
0
PRIMARY
1
id_notice
null
smf_log_member_notices
0
PRIMARY
1
id_notice
null
smf_log_notify
0
PRIMARY
1
id_member
null
smf_log_notify
0
PRIMARY
1
id_member
null
smf_log_notify
0
PRIMARY
2
id_topic
null
smf_log_notify
0
PRIMARY
2
id_topic
null
smf_log_notify
0
PRIMARY
3
id_board
null
smf_log_notify
0
PRIMARY
3
id_board
null
smf_log_notify
1
idx_id_topic
1
id_topic
null
smf_log_notify
1
idx_id_topic
1
id_topic
null
smf_log_notify
1
idx_id_topic
2
id_member
null
smf_log_notify
1
idx_id_topic
2
id_member
null
smf_log_online
1
idx_id_member
1
id_member
null
smf_log_online
1
idx_id_member
1
id_member
null
smf_log_online
1
idx_log_time
1
log_time
null
smf_log_online
1
idx_log_time
1
log_time
null
smf_log_online
0
PRIMARY
1
session
null
smf_log_online
0
PRIMARY
1
session
null
smf_log_packages
1
idx_filename
1
filename
15
smf_log_packages
1
idx_filename
1
filename
15
smf_log_packages
0
PRIMARY
1
id_install
null
smf_log_packages
0
PRIMARY
1
id_install
null
smf_log_polls
1
idx_id_poll
1
id_poll
null
smf_log_polls
1
idx_id_poll
1
id_poll
null
smf_log_polls
1
idx_id_poll
2
id_member
null
smf_log_polls
1
idx_id_poll
2
id_member
null
smf_log_polls
1
idx_id_poll
3
id_choice
null
smf_log_polls
1
idx_id_poll
3
id_choice
null
smf_log_reported
1
idx_closed
1
closed
null
smf_log_reported
1
idx_closed
1
closed
null
smf_log_reported
1
idx_id_member
1
id_member
null
smf_log_reported
1
idx_id_member
1
id_member
null
smf_log_reported
1
idx_id_msg
1
id_msg
null
smf_log_reported
1
idx_id_msg
1
id_msg
null
smf_log_reported
0
PRIMARY
1
id_report
null
smf_log_reported
0
PRIMARY
1
id_report
null
smf_log_reported
1
idx_id_topic
1
id_topic
null
smf_log_reported
1
idx_id_topic
1
id_topic
null
smf_log_reported
1
idx_time_started
1
time_started
null
smf_log_reported
1
idx_time_started
1
time_started
null
smf_log_reported_comments
0
PRIMARY
1
id_comment
null
smf_log_reported_comments
0
PRIMARY
1
id_comment
null
smf_log_reported_comments
1
idx_id_member
1
id_member
null
smf_log_reported_comments
1
idx_id_member
1
id_member
null
smf_log_reported_comments
1
idx_id_report
1
id_report
null
smf_log_reported_comments
1
idx_id_report
1
id_report
null
smf_log_reported_comments
1
idx_time_sent
1
time_sent
null
smf_log_reported_comments
1
idx_time_sent
1
time_sent
null
smf_log_scheduled_tasks
0
PRIMARY
1
id_log
null
smf_log_scheduled_tasks
0
PRIMARY
1
id_log
null
smf_log_search_messages
0
PRIMARY
1
id_search
null
smf_log_search_messages
0
PRIMARY
1
id_search
null
smf_log_search_messages
0
PRIMARY
2
id_msg
null
smf_log_search_messages
0
PRIMARY
2
id_msg
null
smf_log_search_results
0
PRIMARY
1
id_search
null
smf_log_search_results
0
PRIMARY
1
id_search
null
smf_log_search_results
0
PRIMARY
2
id_topic
null
smf_log_search_results
0
PRIMARY
2
id_topic
null
smf_log_search_subjects
1
idx_id_topic
1
id_topic
null
smf_log_search_subjects
1
idx_id_topic
1
id_topic
null
smf_log_search_subjects
0
PRIMARY
1
word
null
smf_log_search_subjects
0
PRIMARY
1
word
null
smf_log_search_subjects
0
PRIMARY
2
id_topic
null
smf_log_search_subjects
0
PRIMARY
2
id_topic
null
smf_log_search_topics
0
PRIMARY
1
id_search
null
smf_log_search_topics
0
PRIMARY
1
id_search
null
smf_log_search_topics
0
PRIMARY
2
id_topic
null
smf_log_search_topics
0
PRIMARY
2
id_topic
null
smf_log_sfs
0
PRIMARY
1
id_sfs
null
smf_log_sfs
1
id_type
1
id_type
null
smf_log_spider_hits
0
PRIMARY
1
id_hit
null
smf_log_spider_hits
0
PRIMARY
1
id_hit
null
smf_log_spider_hits
1
idx_id_spider
1
id_spider
null
smf_log_spider_hits
1
idx_id_spider
1
id_spider
null
smf_log_spider_hits
1
idx_log_time
1
log_time
null
smf_log_spider_hits
1
idx_log_time
1
log_time
null
smf_log_spider_hits
1
idx_processed
1
processed
null
smf_log_spider_hits
1
idx_processed
1
processed
null
smf_log_spider_stats
0
PRIMARY
1
stat_date
null
smf_log_spider_stats
0
PRIMARY
1
stat_date
null
smf_log_spider_stats
0
PRIMARY
2
id_spider
null
smf_log_spider_stats
0
PRIMARY
2
id_spider
null
smf_log_subscribed
1
idx_end_time
1
end_time
null
smf_log_subscribed
1
idx_end_time
1
end_time
null
smf_log_subscribed
1
idx_id_member
1
id_member
null
smf_log_subscribed
1
idx_id_member
1
id_member
null
smf_log_subscribed
0
PRIMARY
1
id_sublog
null
smf_log_subscribed
0
PRIMARY
1
id_sublog
null
smf_log_subscribed
0
id_subscribe
1
id_subscribe
null
smf_log_subscribed
0
id_subscribe
1
id_subscribe
null
smf_log_subscribed
0
id_subscribe
2
id_member
null
smf_log_subscribed
0
id_subscribe
2
id_member
null
smf_log_subscribed
1
idx_payments_pending
1
payments_pending
null
smf_log_subscribed
1
idx_payments_pending
1
payments_pending
null
smf_log_subscribed
1
idx_reminder_sent
1
reminder_sent
null
smf_log_subscribed
1
idx_reminder_sent
1
reminder_sent
null
smf_log_subscribed
1
status
1
status
null
smf_log_subscribed
1
idx_status
1
status
null
smf_log_topics
0
PRIMARY
1
id_member
null
smf_log_topics
0
PRIMARY
1
id_member
null
smf_log_topics
0
PRIMARY
2
id_topic
null
smf_log_topics
0
PRIMARY
2
id_topic
null
smf_log_topics
1
idx_id_topic
1
id_topic
null
smf_log_topics
1
idx_id_topic
1
id_topic
null
smf_mail_queue
0
PRIMARY
1
id_mail
null
smf_mail_queue
0
PRIMARY
1
id_mail
null
smf_mail_queue
1
idx_mail_priority
1
priority
null
smf_mail_queue
1
idx_mail_priority
1
priority
null
smf_mail_queue
1
idx_mail_priority
2
id_mail
null
smf_mail_queue
1
idx_mail_priority
2
id_mail
null
smf_mail_queue
1
idx_time_sent
1
time_sent
null
smf_mail_queue
1
idx_time_sent
1
time_sent
null
smf_mediapro_cache
0
PRIMARY
1
id
null
smf_mediapro_cache
1
mediaurl
1
mediaurl
null
smf_mediapro_sites
0
PRIMARY
1
id
null
smf_member_logins
0
PRIMARY
1
id_login
null
smf_member_logins
0
PRIMARY
1
id_login
null
smf_member_logins
1
idx_id_member
1
id_member
null
smf_member_logins
1
idx_id_member
1
id_member
null
smf_member_logins
1
idx_time
1
time
null
smf_member_logins
1
idx_time
1
time
null
smf_membergroups
0
PRIMARY
1
id_group
null
smf_membergroups
0
PRIMARY
1
id_group
null
smf_membergroups
1
idx_min_posts
1
min_posts
null
smf_membergroups
1
idx_min_posts
1
min_posts
null
smf_members
1
idx_birthdate
1
birthdate
null
smf_members
1
idx_birthdate
1
birthdate
null
smf_members
1
idx_date_registered
1
date_registered
null
smf_members
1
idx_date_registered
1
date_registered
null
smf_members
1
email_address
1
email_address
null
smf_members
1
idx_email_address
1
email_address
null
smf_members
1
idx_id_group
1
id_group
null
smf_members
1
idx_id_group
1
id_group
null
smf_members
0
PRIMARY
1
id_member
null
smf_members
0
PRIMARY
1
id_member
null
smf_members
1
idx_id_post_group
1
id_post_group
null
smf_members
1
idx_id_post_group
1
id_post_group
null
smf_members
1
idx_id_theme
1
id_theme
null
smf_members
1
idx_id_theme
1
id_theme
null
smf_members
1
idx_last_login
1
last_login
null
smf_members
1
idx_last_login
1
last_login
null
smf_members
1
idx_lngfile
1
lngfile
30
smf_members
1
idx_lngfile
1
lngfile
30
smf_members
1
idx_member_name
1
member_name
null
smf_members
1
idx_member_name
1
member_name
null
smf_members
1
idx_posts
1
posts
null
smf_members
1
idx_posts
1
posts
null
smf_members
1
idx_real_name
1
real_name
null
smf_members
1
idx_real_name
1
real_name
null
smf_members
1
idx_total_time_logged_in
1
total_time_logged_in
null
smf_members
1
idx_total_time_logged_in
1
total_time_logged_in
null
smf_members
1
idx_warning
1
warning
null
smf_members
1
idx_warning
1
warning
null
smf_mentions
1
content
1
content_id
null
smf_mentions
1
content
1
content_id
null
smf_mentions
1
content
2
content_type
null
smf_mentions
1
content
2
content_type
null
smf_mentions
0
PRIMARY
1
content_id
null
smf_mentions
0
PRIMARY
1
content_id
null
smf_mentions
0
PRIMARY
2
content_type
null
smf_mentions
0
PRIMARY
2
content_type
null
smf_mentions
0
PRIMARY
3
id_mentioned
null
smf_mentions
0
PRIMARY
3
id_mentioned
null
smf_mentions
1
mentionee
1
id_member
null
smf_mentions
1
mentionee
1
id_member
null
smf_message_icons
1
idx_id_board
1
id_board
null
smf_message_icons
1
idx_id_board
1
id_board
null
smf_message_icons
0
PRIMARY
1
id_icon
null
smf_message_icons
0
PRIMARY
1
id_icon
null
smf_messages
1
body
1
body
null
smf_messages
0
idx_id_board
1
id_board
null
smf_messages
0
idx_id_board
1
id_board
null
smf_messages
0
idx_id_board
2
id_msg
null
smf_messages
0
idx_id_board
2
id_msg
null
smf_messages
0
idx_id_board
3
approved
null
smf_messages
0
idx_id_board
3
approved
null
smf_messages
1
idx_id_member_msg
1
id_member
null
smf_messages
1
idx_id_member_msg
1
id_member
null
smf_messages
1
idx_id_member_msg
2
approved
null
smf_messages
1
idx_id_member_msg
2
approved
null
smf_messages
1
idx_id_member_msg
3
id_msg
null
smf_messages
1
idx_id_member_msg
3
id_msg
null
smf_messages
1
idx_show_posts
1
id_member
null
smf_messages
1
idx_show_posts
1
id_member
null
smf_messages
1
idx_show_posts
2
id_board
null
smf_messages
1
idx_show_posts
2
id_board
null
smf_messages
0
idx_id_member
1
id_member
null
smf_messages
0
idx_id_member
1
id_member
null
smf_messages
0
idx_id_member
2
id_msg
null
smf_messages
0
idx_id_member
2
id_msg
null
smf_messages
1
idx_participation
1
id_member
null
smf_messages
1
idx_participation
1
id_member
null
smf_messages
1
idx_participation
2
id_topic
null
smf_messages
1
idx_participation
2
id_topic
null
smf_messages
1
idx_related_ip
1
id_member
null
smf_messages
1
idx_related_ip
1
id_member
null
smf_messages
1
idx_related_ip
2
poster_ip
null
smf_messages
1
idx_related_ip
2
poster_ip
null
smf_messages
1
idx_related_ip
3
id_msg
null
smf_messages
1
idx_related_ip
3
id_msg
null
smf_messages
0
PRIMARY
1
id_msg
null
smf_messages
0
PRIMARY
1
id_msg
null
smf_messages
1
idx_current_topic
1
id_topic
null
smf_messages
1
idx_current_topic
1
id_topic
null
smf_messages
1
idx_current_topic
2
id_msg
null
smf_messages
1
idx_current_topic
2
id_msg
null
smf_messages
1
idx_current_topic
3
id_member
null
smf_messages
1
idx_current_topic
3
id_member
null
smf_messages
1
idx_current_topic
4
approved
null
smf_messages
1
idx_current_topic
4
approved
null
smf_messages
1
idx_likes
1
likes
null
smf_messages
1
idx_likes
1
likes
null
smf_messages
1
idx_ip_index
1
poster_ip
null
smf_messages
1
idx_ip_index
1
poster_ip
null
smf_messages
1
idx_ip_index
2
id_topic
null
smf_messages
1
idx_ip_index
2
id_topic
null
smf_messages
1
st_idx_subject
1
subject
null
smf_moderator_groups
0
PRIMARY
1
id_board
null
smf_moderator_groups
0
PRIMARY
1
id_board
null
smf_moderator_groups
0
PRIMARY
2
id_group
null
smf_moderator_groups
0
PRIMARY
2
id_group
null
smf_moderators
0
PRIMARY
1
id_board
null
smf_moderators
0
PRIMARY
1
id_board
null
smf_moderators
0
PRIMARY
2
id_member
null
smf_moderators
0
PRIMARY
2
id_member
null
smf_package_servers
0
PRIMARY
1
id_server
null
smf_package_servers
0
PRIMARY
1
id_server
null
smf_permission_profiles
0
PRIMARY
1
id_profile
null
smf_permission_profiles
0
PRIMARY
1
id_profile
null
smf_permissions
0
PRIMARY
1
id_group
null
smf_permissions
0
PRIMARY
1
id_group
null
smf_permissions
0
PRIMARY
2
permission
null
smf_permissions
0
PRIMARY
2
permission
null
smf_personal_messages
1
idx_id_member
1
id_member_from
null
smf_personal_messages
1
idx_id_member
1
id_member_from
null
smf_personal_messages
1
idx_id_member
2
deleted_by_sender
null
smf_personal_messages
1
idx_id_member
2
deleted_by_sender
null
smf_personal_messages
0
PRIMARY
1
id_pm
null
smf_personal_messages
0
PRIMARY
1
id_pm
null
smf_personal_messages
1
idx_id_pm_head
1
id_pm_head
null
smf_personal_messages
1
idx_id_pm_head
1
id_pm_head
null
smf_personal_messages
1
idx_msgtime
1
msgtime
null
smf_personal_messages
1
idx_msgtime
1
msgtime
null
smf_pm_labeled_messages
0
PRIMARY
1
id_label
null
smf_pm_labeled_messages
0
PRIMARY
1
id_label
null
smf_pm_labeled_messages
0
PRIMARY
2
id_pm
null
smf_pm_labeled_messages
0
PRIMARY
2
id_pm
null
smf_pm_labels
0
PRIMARY
1
id_label
null
smf_pm_labels
0
PRIMARY
1
id_label
null
smf_pm_recipients
0
idx_id_member
1
id_member
null
smf_pm_recipients
0
idx_id_member
1
id_member
null
smf_pm_recipients
0
idx_id_member
2
deleted
null
smf_pm_recipients
0
idx_id_member
2
deleted
null
smf_pm_recipients
0
idx_id_member
3
id_pm
null
smf_pm_recipients
0
idx_id_member
3
id_pm
null
smf_pm_recipients
0
PRIMARY
1
id_pm
null
smf_pm_recipients
0
PRIMARY
1
id_pm
null
smf_pm_recipients
0
PRIMARY
2
id_member
null
smf_pm_recipients
0
PRIMARY
2
id_member
null
smf_pm_rules
1
idx_delete_pm
1
delete_pm
null
smf_pm_rules
1
idx_delete_pm
1
delete_pm
null
smf_pm_rules
1
idx_id_member
1
id_member
null
smf_pm_rules
1
idx_id_member
1
id_member
null
smf_pm_rules
0
PRIMARY
1
id_rule
null
smf_pm_rules
0
PRIMARY
1
id_rule
null
smf_poll_choices
0
PRIMARY
1
id_poll
null
smf_poll_choices
0
PRIMARY
1
id_poll
null
smf_poll_choices
0
PRIMARY
2
id_choice
null
smf_poll_choices
0
PRIMARY
2
id_choice
null
smf_polls
0
PRIMARY
1
id_poll
null
smf_polls
0
PRIMARY
1
id_poll
null
smf_qanda
0
PRIMARY
1
id_question
null
smf_qanda
0
PRIMARY
1
id_question
null
smf_qanda
1
idx_lngfile
1
lngfile
null
smf_qanda
1
idx_lngfile
1
lngfile
null
smf_quiz
1
id_category
1
id_category
null
smf_quiz
0
PRIMARY
1
id_quiz
null
smf_quiz_answer
0
PRIMARY
1
id_answer
null
smf_quiz_answer
1
id_question_is_correct
1
id_question
null
smf_quiz_answer
1
id_question_is_correct
2
is_correct
null
smf_quiz_category
0
PRIMARY
1
id_category
null
smf_quiz_category
1
id_parent
1
id_parent
null
smf_quiz_dispute
0
PRIMARY
1
id_quiz_dispute
null
smf_quiz_dispute
1
id_user_id_quiz_id_quiz_question
1
id_user
null
smf_quiz_dispute
1
id_user_id_quiz_id_quiz_question
2
id_quiz
null
smf_quiz_dispute
1
id_user_id_quiz_id_quiz_question
3
id_quiz_question
null
smf_quiz_infoboard
0
PRIMARY
1
id_infoboard
null
smf_quiz_league
1
id_leader_id_question_category
1
id_leader
null
smf_quiz_league
1
id_leader_id_question_category
2
id_question_category
null
smf_quiz_league
0
PRIMARY
1
id_quiz_league
null
smf_quiz_league_result
0
PRIMARY
1
id_quiz_league_result
null
smf_quiz_league_result
1
id_user_round_result_date_id_quiz_league
1
id_user
null
smf_quiz_league_result
1
id_user_round_result_date_id_quiz_league
2
round
null
smf_quiz_league_result
1
id_user_round_result_date_id_quiz_league
3
result_date
null
smf_quiz_league_result
1
id_user_round_result_date_id_quiz_league
4
id_quiz_league
null
smf_quiz_league_table
0
PRIMARY
1
id_quiz_league_table
null
smf_quiz_league_table
1
id_user_id_quiz_league_current_position
1
id_user
null
smf_quiz_league_table
1
id_user_id_quiz_league_current_position
2
id_quiz_league
null
smf_quiz_league_table
1
id_user_id_quiz_league_current_position
3
current_position
null
smf_quiz_question
0
PRIMARY
1
id_question
null
smf_quiz_question
1
id_quiz_id_question_type
1
id_quiz
null
smf_quiz_question
1
id_quiz_id_question_type
2
id_question_type
null
smf_quiz_question_type
0
PRIMARY
1
id_question_type
null
smf_quiz_result
1
id_quiz_id_user
1
id_quiz
null
smf_quiz_result
1
id_quiz_id_user
2
id_user
null
smf_quiz_result
0
PRIMARY
1
id_quiz_result
null
smf_quiz_session
1
id_quiz_id_user_id_quiz_league
1
id_quiz
null
smf_quiz_session
1
id_quiz_id_user_id_quiz_league
2
id_user
null
smf_quiz_session
1
id_quiz_id_user_id_quiz_league
3
id_quiz_league
null
smf_quiz_session
0
PRIMARY
1
id_quiz_session
null
smf_scheduled_tasks
1
idx_disabled
1
disabled
null
smf_scheduled_tasks
1
idx_disabled
1
disabled
null
smf_scheduled_tasks
0
PRIMARY
1
id_task
null
smf_scheduled_tasks
0
PRIMARY
1
id_task
null
smf_scheduled_tasks
1
idx_next_time
1
next_time
null
smf_scheduled_tasks
1
idx_next_time
1
next_time
null
smf_scheduled_tasks
0
idx_task
1
task
null
smf_scheduled_tasks
0
idx_task
1
task
null
smf_sessions
0
PRIMARY
1
session_id
null
smf_sessions
0
PRIMARY
1
session_id
null
smf_settings
0
PRIMARY
1
variable
30
smf_settings
0
PRIMARY
1
variable
30
smf_smiley_files
0
PRIMARY
1
id_smiley
null
smf_smiley_files
0
PRIMARY
1
id_smiley
null
smf_smiley_files
0
PRIMARY
2
smiley_set
null
smf_smiley_files
0
PRIMARY
2
smiley_set
null
smf_smileys
0
PRIMARY
1
id_smiley
null
smf_smileys
0
PRIMARY
1
id_smiley
null
smf_spiders
0
PRIMARY
1
id_spider
null
smf_spiders
0
PRIMARY
1
id_spider
null
smf_stshop_categories
0
PRIMARY
1
catid
null
smf_stshop_inventory
0
PRIMARY
1
id
null
smf_stshop_items
0
PRIMARY
1
itemid
null
smf_stshop_log_bank
0
PRIMARY
1
id
null
smf_stshop_log_buy
0
PRIMARY
1
id
null
smf_stshop_log_content
0
PRIMARY
1
id_msg
null
smf_stshop_log_content
0
PRIMARY
2
id_member
null
smf_stshop_log_content
0
PRIMARY
3
content
null
smf_stshop_log_games
0
PRIMARY
1
id
null
smf_stshop_log_gift
0
PRIMARY
1
id
null
smf_stshop_modules
0
PRIMARY
1
id
null
smf_subscriptions
1
idx_active
1
active
null
smf_subscriptions
1
idx_active
1
active
null
smf_subscriptions
0
PRIMARY
1
id_subscribe
null
smf_subscriptions
0
PRIMARY
1
id_subscribe
null
smf_themes
1
idx_id_member
1
id_member
null
smf_themes
1
idx_id_member
1
id_member
null
smf_themes
0
PRIMARY
1
id_theme
null
smf_themes
0
PRIMARY
1
id_theme
null
smf_themes
0
PRIMARY
2
id_member
null
smf_themes
0
PRIMARY
2
id_member
null
smf_themes
0
PRIMARY
3
variable
30
smf_themes
0
PRIMARY
3
variable
30
smf_topic_ratings
0
id
1
id
null
smf_topic_ratings
1
total_votes_total_value
1
total_votes
null
smf_topic_ratings
1
total_votes_total_value
2
total_value
null
smf_topics
1
idx_approved
1
approved
null
smf_topics
1
idx_approved
1
approved
null
smf_topics
1
idx_board_news
1
id_board
null
smf_topics
1
idx_board_news
1
id_board
null
smf_topics
1
idx_board_news
2
id_first_msg
null
smf_topics
1
idx_board_news
2
id_first_msg
null
smf_topics
1
idx_last_message_sticky
1
id_board
null
smf_topics
1
idx_last_message_sticky
1
id_board
null
smf_topics
1
idx_last_message_sticky
2
is_sticky
null
smf_topics
1
idx_last_message_sticky
2
is_sticky
null
smf_topics
1
idx_last_message_sticky
3
id_last_msg
null
smf_topics
1
idx_last_message_sticky
3
id_last_msg
null
smf_topics
0
idx_first_message
1
id_first_msg
null
smf_topics
0
idx_first_message
1
id_first_msg
null
smf_topics
0
idx_first_message
2
id_board
null
smf_topics
0
idx_first_message
2
id_board
null
smf_topics
0
idx_last_message
1
id_last_msg
null
smf_topics
0
idx_last_message
1
id_last_msg
null
smf_topics
0
idx_last_message
2
id_board
null
smf_topics
0
idx_last_message
2
id_board
null
smf_topics
1
idx_member_started
1
id_member_started
null
smf_topics
1
idx_member_started
1
id_member_started
null
smf_topics
1
idx_member_started
2
id_board
null
smf_topics
1
idx_member_started
2
id_board
null
smf_topics
0
idx_poll
1
id_poll
null
smf_topics
0
idx_poll
1
id_poll
null
smf_topics
0
idx_poll
2
id_topic
null
smf_topics
0
idx_poll
2
id_topic
null
smf_topics
0
PRIMARY
1
id_topic
null
smf_topics
0
PRIMARY
1
id_topic
null
smf_topics
1
idx_is_sticky
1
is_sticky
null
smf_topics
1
idx_is_sticky
1
is_sticky
null
smf_tp_articles
1
search_body
1
body
null
smf_tp_articles
0
PRIMARY
1
id
null
smf_tp_articles
1
search_subject
1
subject
null
smf_tp_articles
1
search
1
subject
null
smf_tp_articles
1
search
2
body
null
smf_tp_blocks
0
PRIMARY
1
id
null
smf_tp_comments
0
PRIMARY
1
id
null
smf_tp_data
0
PRIMARY
1
id
null
smf_tp_dldata
0
PRIMARY
1
id
null
smf_tp_dlmanager
0
PRIMARY
1
id
null
smf_tp_events
0
PRIMARY
1
id
null
smf_tp_menu
0
PRIMARY
1
id
null
smf_tp_settings
0
PRIMARY
1
id
null
smf_tp_shoutbox
0
PRIMARY
1
id
null
smf_tp_variables
0
PRIMARY
1
id
null
smf_tweet_cache
0
PRIMARY
1
id
null
smf_tweet_cache
1
tweetid
1
tweetid
null
smf_user_alerts
1
idx_alert_time
1
alert_time
null
smf_user_alerts
1
idx_alert_time
1
alert_time
null
smf_user_alerts
0
PRIMARY
1
id_alert
null
smf_user_alerts
0
PRIMARY
1
id_alert
null
smf_user_alerts
1
idx_id_member
1
id_member
null
smf_user_alerts
1
idx_id_member
1
id_member
null
smf_user_alerts_prefs
0
PRIMARY
1
id_member
null
smf_user_alerts_prefs
0
PRIMARY
1
id_member
null
smf_user_alerts_prefs
0
PRIMARY
2
alert_pref
null
smf_user_alerts_prefs
0
PRIMARY
2
alert_pref
null
smf_user_drafts
0
PRIMARY
1
id_draft
null
smf_user_drafts
0
PRIMARY
1
id_draft
null
smf_user_drafts
0
idx_id_member
1
id_member
null
smf_user_drafts
0
idx_id_member
1
id_member
null
smf_user_drafts
0
idx_id_member
2
id_draft
null
smf_user_drafts
0
idx_id_member
2
id_draft
null
smf_user_drafts
0
idx_id_member
3
type
null
smf_user_drafts
0
idx_id_member
3
type
null
smf_user_likes
1
content
1
content_id
null
smf_user_likes
1
content
1
content_id
null
smf_user_likes
1
content
2
content_type
null
smf_user_likes
1
content
2
content_type
null
smf_user_likes
0
PRIMARY
1
content_id
null
smf_user_likes
0
PRIMARY
1
content_id
null
smf_user_likes
0
PRIMARY
2
content_type
null
smf_user_likes
0
PRIMARY
2
content_type
null
smf_user_likes
0
PRIMARY
3
id_member
null
smf_user_likes
0
PRIMARY
3
id_member
null
smf_user_likes
1
liker
1
id_member
null
smf_user_likes
1
liker
1
id_member
null

Remove when not in use
sbulen/sjrbTools