Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER IGNORE TABLE ibf_admin_login_logs ADD PRIMARY KEY (admin_id);
- ALTER IGNORE TABLE ibf_admin_login_logs ADD INDEX admin_ip_address (admin_ip_address);
- ALTER IGNORE TABLE ibf_admin_login_logs ADD INDEX admin_time (admin_time);
- ALTER IGNORE TABLE ibf_announcements ADD PRIMARY KEY (announce_id);
- ALTER IGNORE TABLE ibf_announcements ADD INDEX announce_end (announce_end);
- ALTER IGNORE TABLE ibf_api_log ADD PRIMARY KEY (api_log_id);
- ALTER IGNORE TABLE ibf_api_log ADD INDEX api_log_date (api_log_date);
- ALTER IGNORE TABLE ibf_attachments ADD PRIMARY KEY (attach_id);
- ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_pid (attach_rel_id);
- ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_post_key (attach_post_key);
- ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_mid_size (attach_member_id,attach_rel_module,attach_filesize);
- ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_parent_id (attach_parent_id,attach_rel_module);
- ALTER IGNORE TABLE ibf_attachments_type ADD PRIMARY KEY (atype_id);
- ALTER IGNORE TABLE ibf_attachments_type ADD INDEX atype (atype_post);
- ALTER IGNORE TABLE ibf_attachments_type ADD INDEX atype_extension (atype_extension);
- ALTER IGNORE TABLE ibf_banfilters ADD PRIMARY KEY (ban_id);
- ALTER IGNORE TABLE ibf_banfilters ADD INDEX ban_content (ban_content(200));
- ALTER IGNORE TABLE ibf_bulk_mail ADD PRIMARY KEY (mail_id);
- ALTER IGNORE TABLE ibf_bulk_mail ADD INDEX mail_start (mail_start);
- ALTER IGNORE TABLE ibf_content_cache_sigs ADD INDEX date_index (cache_updated);
- ALTER IGNORE TABLE ibf_content_cache_posts ADD INDEX date_index (cache_updated);
- ALTER IGNORE TABLE ibf_core_editor_autosave ADD UNIQUE KEY eas_key (eas_key);
- ALTER IGNORE TABLE ibf_core_editor_autosave ADD INDEX eas_member_lookup (eas_member_id,eas_app,eas_section);
- ALTER IGNORE TABLE ibf_core_editor_autosave ADD INDEX eas_updated (eas_updated);
- ALTER IGNORE TABLE ibf_core_like ADD PRIMARY KEY (like_id);
- ALTER IGNORE TABLE ibf_core_like ADD INDEX find_rel_likes (like_lookup_id,like_visible,like_is_anon,like_added);
- ALTER IGNORE TABLE ibf_core_like ADD INDEX like_member_id (like_member_id,like_visible,like_added);
- ALTER IGNORE TABLE ibf_core_like ADD INDEX like_lookup_area (like_lookup_area,like_visible);
- ALTER IGNORE TABLE ibf_core_like ADD INDEX notification_task (like_notify_do,like_app(50),like_area(50),like_visible,like_notify_sent,like_notify_freq(50));
- ALTER IGNORE TABLE ibf_core_geolocation_cache ADD PRIMARY KEY (geocache_key);
- ALTER IGNORE TABLE ibf_core_geolocation_cache ADD INDEX geo_lat_lon (geocache_lat,geocache_lon);
- ALTER IGNORE TABLE ibf_core_tags ADD PRIMARY KEY (tag_id);
- ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_aai_lookup (tag_aai_lookup);
- ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_app (tag_meta_app(100),tag_meta_area(100));
- ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_member_id (tag_member_id);
- ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_aap_lookup (tag_aap_lookup,tag_text(200));
- ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_added (tag_added);
- ALTER IGNORE TABLE ibf_core_tags_perms ADD UNIQUE KEY tag_perm_aai_lookup (tag_perm_aai_lookup);
- ALTER IGNORE TABLE ibf_captcha ADD PRIMARY KEY (captcha_unique_id);
- ALTER IGNORE TABLE ibf_captcha ADD INDEX captcha_date (captcha_date);
- ALTER IGNORE TABLE ibf_converge_local ADD PRIMARY KEY (converge_api_code);
- ALTER IGNORE TABLE ibf_converge_local ADD INDEX converge_active (converge_active);
- ALTER IGNORE TABLE ibf_core_applications ADD PRIMARY KEY (app_id);
- ALTER IGNORE TABLE ibf_core_applications ADD INDEX app_directory (app_directory);
- ALTER IGNORE TABLE ibf_core_hooks_files ADD PRIMARY KEY (hook_file_id);
- ALTER IGNORE TABLE ibf_core_hooks_files ADD INDEX hook_hook_id (hook_hook_id);
- ALTER IGNORE TABLE ibf_core_item_markers ADD UNIQUE KEY combo_key (item_key,item_member_id,item_app);
- ALTER IGNORE TABLE ibf_core_item_markers ADD INDEX marker_index (item_member_id,item_app,item_app_key_1);
- ALTER IGNORE TABLE ibf_core_item_markers ADD INDEX item_last_saved (item_last_saved);
- ALTER IGNORE TABLE ibf_core_item_markers ADD INDEX item_member_id (item_is_deleted,item_member_id);
- ALTER IGNORE TABLE ibf_core_item_markers_storage ADD PRIMARY KEY (item_member_id);
- ALTER IGNORE TABLE ibf_core_item_markers_storage ADD INDEX item_last_saved (item_last_saved);
- ALTER IGNORE TABLE ibf_core_rss_imported ADD PRIMARY KEY (rss_guid);
- ALTER IGNORE TABLE ibf_core_rss_imported ADD INDEX rss_grabber (rss_guid,rss_foreign_key);
- ALTER IGNORE TABLE ibf_core_share_links ADD PRIMARY KEY (share_id);
- ALTER IGNORE TABLE ibf_core_share_links_log ADD PRIMARY KEY (log_id);
- ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX findstuff (log_data_app,log_data_type,log_data_primary_id);
- ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_date (log_date);
- ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_member_id (log_member_id);
- ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_share_key (log_share_key);
- ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_ip_address (log_ip_address);
- ALTER IGNORE TABLE ibf_core_soft_delete_log ADD PRIMARY KEY (sdl_id);
- ALTER IGNORE TABLE ibf_core_soft_delete_log ADD INDEX look_up (sdl_obj_id,sdl_obj_key);
- ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD PRIMARY KEY (conf_id);
- ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD INDEX conf_key (conf_key);
- ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD INDEX conf_group (conf_group,conf_position,conf_title);
- ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD INDEX conf_add_cache (conf_add_cache);
- ALTER IGNORE TABLE ibf_core_sys_cp_sessions ADD PRIMARY KEY (session_id);
- ALTER IGNORE TABLE ibf_core_sys_cp_sessions ADD INDEX session_running_time (session_running_time);
- ALTER IGNORE TABLE ibf_core_sys_cp_sessions ADD INDEX session_member_id (session_member_id);
- ALTER IGNORE TABLE ibf_core_sys_lang ADD PRIMARY KEY (lang_id);
- ALTER IGNORE TABLE ibf_core_sys_lang ADD INDEX lang_short (lang_short);
- ALTER IGNORE TABLE ibf_core_sys_lang ADD INDEX lang_default (lang_default);
- ALTER IGNORE TABLE ibf_core_sys_lang_words ADD PRIMARY KEY (word_id);
- ALTER IGNORE TABLE ibf_core_sys_lang_words ADD INDEX word_js (word_js);
- ALTER IGNORE TABLE ibf_core_sys_lang_words ADD INDEX word_find (lang_id,word_app(32),word_pack(100));
- ALTER IGNORE TABLE ibf_core_sys_module ADD PRIMARY KEY (sys_module_id);
- ALTER IGNORE TABLE ibf_core_sys_module ADD INDEX sys_module_application (sys_module_application);
- ALTER IGNORE TABLE ibf_core_sys_module ADD INDEX sys_module_visible (sys_module_visible);
- ALTER IGNORE TABLE ibf_core_sys_module ADD INDEX sys_module_key (sys_module_key);
- ALTER IGNORE TABLE ibf_core_sys_settings_titles ADD PRIMARY KEY (conf_title_id);
- ALTER IGNORE TABLE ibf_core_sys_settings_titles ADD INDEX conf_title_keyword (conf_title_keyword);
- ALTER IGNORE TABLE ibf_core_uagent_groups ADD PRIMARY KEY (ugroup_id);
- ALTER IGNORE TABLE ibf_core_uagent_groups ADD INDEX ugroup_title (ugroup_title);
- ALTER IGNORE TABLE ibf_core_uagents ADD PRIMARY KEY (uagent_id);
- ALTER IGNORE TABLE ibf_core_uagents ADD INDEX uagent_key (uagent_key);
- ALTER IGNORE TABLE ibf_core_uagents ADD INDEX ordering (uagent_position,uagent_key);
- ALTER IGNORE TABLE ibf_dnames_change ADD PRIMARY KEY (dname_id);
- ALTER IGNORE TABLE ibf_dnames_change ADD INDEX dname_member_id (dname_member_id);
- ALTER IGNORE TABLE ibf_dnames_change ADD INDEX date_id (dname_member_id,dname_date);
- ALTER IGNORE TABLE ibf_dnames_change ADD INDEX dname_ip_address (dname_ip_address);
- ALTER IGNORE TABLE ibf_emoticons ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_emoticons ADD INDEX emo_set (emo_set);
- ALTER IGNORE TABLE ibf_error_logs ADD PRIMARY KEY (log_id);
- ALTER IGNORE TABLE ibf_error_logs ADD INDEX log_date (log_date);
- ALTER IGNORE TABLE ibf_error_logs ADD INDEX log_ip_address (log_ip_address);
- ALTER IGNORE TABLE ibf_ignored_users ADD PRIMARY KEY (ignore_id);
- ALTER IGNORE TABLE ibf_ignored_users ADD INDEX ignore_owner_id (ignore_owner_id);
- ALTER IGNORE TABLE ibf_ignored_users ADD INDEX ignore_ignore_id (ignore_ignore_id);
- ALTER IGNORE TABLE ibf_cache_simple ADD UNIQUE KEY lookup (cache_id,cache_perm_key);
- ALTER IGNORE TABLE ibf_inline_notifications ADD PRIMARY KEY (notify_id);
- ALTER IGNORE TABLE ibf_inline_notifications ADD INDEX notify_to_id (notify_to_id,notify_sent);
- ALTER IGNORE TABLE ibf_inline_notifications ADD INDEX grabber (notify_to_id,notify_read,notify_sent);
- ALTER IGNORE TABLE ibf_inline_notifications ADD INDEX notify_meta_key (notify_meta_key);
- ALTER IGNORE TABLE ibf_members ADD PRIMARY KEY (member_id);
- ALTER IGNORE TABLE ibf_members ADD INDEX members_l_display_name (members_l_display_name);
- ALTER IGNORE TABLE ibf_members ADD INDEX members_l_username (members_l_username);
- ALTER IGNORE TABLE ibf_members ADD INDEX mgroup (member_group_id,member_id);
- ALTER IGNORE TABLE ibf_members ADD INDEX bday_day (bday_day);
- ALTER IGNORE TABLE ibf_members ADD INDEX bday_month (bday_month);
- ALTER IGNORE TABLE ibf_members ADD INDEX member_banned (member_banned);
- ALTER IGNORE TABLE ibf_members ADD INDEX members_bitoptions (members_bitoptions);
- ALTER IGNORE TABLE ibf_members ADD INDEX ip_address (ip_address);
- ALTER IGNORE TABLE ibf_members ADD INDEX failed_login_count (failed_login_count);
- ALTER IGNORE TABLE ibf_members ADD INDEX joined (joined);
- ALTER IGNORE TABLE ibf_members ADD INDEX fb_uid (fb_uid);
- ALTER IGNORE TABLE ibf_members ADD INDEX twitter_id (twitter_id);
- ALTER IGNORE TABLE ibf_members ADD INDEX email (email);
- ALTER IGNORE TABLE ibf_members_partial ADD PRIMARY KEY (partial_id);
- ALTER IGNORE TABLE ibf_members_partial ADD INDEX partial_member_id (partial_member_id);
- ALTER IGNORE TABLE ibf_members_warn_actions ADD PRIMARY KEY (wa_id);
- ALTER IGNORE TABLE ibf_members_warn_actions ADD INDEX wa_points (wa_points);
- ALTER IGNORE TABLE ibf_members_warn_logs ADD PRIMARY KEY (wl_id);
- ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_member (wl_member);
- ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_moderator (wl_moderator);
- ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_date (wl_member,wl_date);
- ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX content (wl_content_app,wl_content_id1,wl_content_id2);
- ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_expire_date (wl_expire_date);
- ALTER IGNORE TABLE ibf_members_warn_reasons ADD PRIMARY KEY (wr_id);
- ALTER IGNORE TABLE ibf_members_warn_reasons ADD INDEX wr_order (wr_order);
- ALTER IGNORE TABLE ibf_member_status_actions ADD PRIMARY KEY (action_id);
- ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_status_id (action_status_id);
- ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_member_id (action_member_id,action_date);
- ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_date (action_date);
- ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_custom (action_custom,action_date);
- ALTER IGNORE TABLE ibf_member_status_replies ADD PRIMARY KEY (reply_id);
- ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_status_id (reply_status_id);
- ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_member_id (reply_member_id);
- ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_status_count (reply_status_id,reply_member_id);
- ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_date (reply_date);
- ALTER IGNORE TABLE ibf_member_status_updates ADD PRIMARY KEY (status_id);
- ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_date (status_date);
- ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX s_hash (status_member_id,status_hash,status_date);
- ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_is_latest (status_is_latest,status_date);
- ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_author_lookup (status_author_id,status_member_id,status_date);
- ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_member_id (status_member_id,status_approved,status_date);
- ALTER IGNORE TABLE ibf_permission_index ADD PRIMARY KEY (perm_id);
- ALTER IGNORE TABLE ibf_permission_index ADD INDEX perm_index (perm_type,perm_type_id);
- ALTER IGNORE TABLE ibf_permission_index ADD INDEX perm_type (app,perm_type,perm_type_id);
- ALTER IGNORE TABLE ibf_profile_friends ADD PRIMARY KEY (friends_id);
- ALTER IGNORE TABLE ibf_profile_friends ADD INDEX my_friends (friends_member_id,friends_friend_id);
- ALTER IGNORE TABLE ibf_profile_friends_flood ADD PRIMARY KEY (friends_id);
- ALTER IGNORE TABLE ibf_profile_friends_flood ADD INDEX my_friends (friends_member_id,friends_friend_id);
- ALTER IGNORE TABLE ibf_profile_portal_views ADD INDEX views_member_id (views_member_id);
- ALTER IGNORE TABLE ibf_profile_ratings ADD PRIMARY KEY (rating_id);
- ALTER IGNORE TABLE ibf_profile_ratings ADD INDEX rating_for_member_id (rating_for_member_id);
- ALTER IGNORE TABLE ibf_profile_ratings ADD INDEX rating_ip_address (rating_ip_address);
- ALTER IGNORE TABLE ibf_rc_classes ADD PRIMARY KEY (com_id);
- ALTER IGNORE TABLE ibf_rc_classes ADD INDEX onoff (onoff,mod_group_perm(255));
- ALTER IGNORE TABLE ibf_rc_reports ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_rc_reports ADD INDEX rid (rid);
- ALTER IGNORE TABLE ibf_rc_reports_index ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_rc_reports_index ADD INDEX uid (uid);
- ALTER IGNORE TABLE ibf_rc_reports_index ADD INDEX status (status);
- ALTER IGNORE TABLE ibf_rc_status_sev ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_rc_status_sev ADD INDEX status (status,points);
- ALTER IGNORE TABLE ibf_reputation_cache ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_reputation_cache ADD UNIQUE KEY app (app,type,type_id);
- ALTER IGNORE TABLE ibf_reputation_cache ADD INDEX cache_date (cache_date);
- ALTER IGNORE TABLE ibf_reputation_cache ADD INDEX type (type,type_id);
- ALTER IGNORE TABLE ibf_reputation_index ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_reputation_index ADD INDEX app (app,type,type_id,member_id);
- ALTER IGNORE TABLE ibf_reputation_index ADD INDEX member_rep (member_id,rep_rating,rep_date);
- ALTER IGNORE TABLE ibf_rss_import ADD PRIMARY KEY (rss_import_id);
- ALTER IGNORE TABLE ibf_rss_import ADD INDEX rss_grab (rss_import_enabled,rss_import_last_import);
- ALTER IGNORE TABLE ibf_rss_imported ADD PRIMARY KEY (rss_imported_guid);
- ALTER IGNORE TABLE ibf_rss_imported ADD INDEX rss_imported_impid (rss_imported_impid);
- ALTER IGNORE TABLE ibf_search_sessions ADD PRIMARY KEY (session_id);
- ALTER IGNORE TABLE ibf_search_sessions ADD INDEX session_updated (session_updated);
- ALTER IGNORE TABLE ibf_sessions ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_sessions ADD INDEX location1 (location_1_type,location_1_id);
- ALTER IGNORE TABLE ibf_sessions ADD INDEX location2 (location_2_type,location_2_id);
- ALTER IGNORE TABLE ibf_sessions ADD INDEX location3 (location_3_type,location_3_id);
- ALTER IGNORE TABLE ibf_sessions ADD INDEX running_time (running_time);
- ALTER IGNORE TABLE ibf_sessions ADD INDEX member_id (member_id);
- ALTER IGNORE TABLE ibf_skin_cache ADD PRIMARY KEY (cache_id);
- ALTER IGNORE TABLE ibf_skin_cache ADD INDEX cache_type (cache_type);
- ALTER IGNORE TABLE ibf_skin_cache ADD INDEX cache_set_id (cache_set_id);
- ALTER IGNORE TABLE ibf_skin_collections ADD PRIMARY KEY (set_id);
- ALTER IGNORE TABLE ibf_skin_collections ADD INDEX parent_set_id (set_parent_id,set_id);
- ALTER IGNORE TABLE ibf_skin_collections ADD INDEX set_is_default (set_is_default);
- ALTER IGNORE TABLE ibf_skin_collections ADD INDEX set_order (set_order);
- ALTER IGNORE TABLE ibf_skin_css ADD PRIMARY KEY (css_id);
- ALTER IGNORE TABLE ibf_skin_css ADD INDEX css_set_id (css_set_id);
- ALTER IGNORE TABLE ibf_skin_merge_changes ADD PRIMARY KEY (change_id);
- ALTER IGNORE TABLE ibf_skin_merge_changes ADD INDEX change_key_change_data_type (change_key,change_data_type);
- ALTER IGNORE TABLE ibf_skin_replacements ADD PRIMARY KEY (replacement_id);
- ALTER IGNORE TABLE ibf_skin_replacements ADD INDEX replacement_set_id (replacement_set_id);
- ALTER IGNORE TABLE ibf_skin_templates ADD PRIMARY KEY (template_id);
- ALTER IGNORE TABLE ibf_skin_templates ADD INDEX template_set_id (template_set_id);
- ALTER IGNORE TABLE ibf_skin_templates ADD INDEX template_master_key (template_master_key);
- ALTER IGNORE TABLE ibf_skin_templates ADD INDEX template_name (template_name(100),template_group(100));
- ALTER IGNORE TABLE ibf_skin_templates_cache ADD PRIMARY KEY (template_id);
- ALTER IGNORE TABLE ibf_skin_templates_cache ADD INDEX template_set_id (template_set_id);
- ALTER IGNORE TABLE ibf_skin_templates_cache ADD INDEX template_group_name (template_group_name);
- ALTER IGNORE TABLE ibf_spider_logs ADD PRIMARY KEY (sid);
- ALTER IGNORE TABLE ibf_spider_logs ADD INDEX entry_date (entry_date);
- ALTER IGNORE TABLE ibf_tags_index ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_tags_index ADD INDEX app (app);
- ALTER IGNORE TABLE ibf_tags_index ADD INDEX tag_grab (app,type,type_id,type_2,type_id_2,tag_hidden);
- ALTER IGNORE TABLE ibf_task_logs ADD PRIMARY KEY (log_id);
- ALTER IGNORE TABLE ibf_task_logs ADD INDEX log_date (log_date);
- ALTER IGNORE TABLE ibf_task_manager ADD PRIMARY KEY (task_id);
- ALTER IGNORE TABLE ibf_task_manager ADD UNIQUE KEY task_key (task_application,task_key);
- ALTER IGNORE TABLE ibf_task_manager ADD INDEX task_next_run (task_enabled,task_next_run);
- ALTER IGNORE TABLE ibf_titles ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_titles ADD INDEX posts (posts);
- ALTER IGNORE TABLE ibf_upgrade_history ADD PRIMARY KEY (upgrade_id);
- ALTER IGNORE TABLE ibf_upgrade_history ADD INDEX upgrades (upgrade_app,upgrade_version_id);
- ALTER IGNORE TABLE ibf_validating ADD PRIMARY KEY (vid);
- ALTER IGNORE TABLE ibf_validating ADD INDEX new_reg (new_reg);
- ALTER IGNORE TABLE ibf_validating ADD INDEX ip_address (ip_address);
- ALTER IGNORE TABLE ibf_validating ADD INDEX lost_pass (lost_pass);
- ALTER IGNORE TABLE ibf_validating ADD INDEX coppa_user (coppa_user);
- ALTER IGNORE TABLE ibf_validating ADD INDEX spam_flag (spam_flag);
- ALTER IGNORE TABLE ibf_validating ADD INDEX member_id (member_id);
- ALTER IGNORE TABLE ibf_voters ADD PRIMARY KEY (vid);
- ALTER IGNORE TABLE ibf_voters ADD INDEX tid (tid);
- ALTER IGNORE TABLE ibf_voters ADD INDEX ip_address (ip_address);
- ALTER IGNORE TABLE ibf_warn_logs ADD PRIMARY KEY (wlog_id);
- ALTER IGNORE TABLE ibf_warn_logs ADD INDEX wlog_mid (wlog_mid,wlog_date);
- ALTER IGNORE TABLE ibf_mobile_notifications ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_mobile_notifications ADD INDEX notify_sent_notify_date (notify_sent,notify_date);
- ALTER IGNORE TABLE ibf_message_posts ADD PRIMARY KEY (msg_id);
- ALTER IGNORE TABLE ibf_message_posts ADD INDEX msg_topic_id (msg_topic_id);
- ALTER IGNORE TABLE ibf_message_posts ADD INDEX msg_date (msg_date);
- ALTER IGNORE TABLE ibf_message_posts ADD INDEX msg_ip_address (msg_ip_address);
- ALTER IGNORE TABLE ibf_message_topic_user_map ADD PRIMARY KEY (map_id);
- ALTER IGNORE TABLE ibf_message_topic_user_map ADD UNIQUE KEY map_main (map_user_id,map_topic_id);
- ALTER IGNORE TABLE ibf_message_topic_user_map ADD INDEX map_user (map_user_id,map_folder_id,map_last_topic_reply);
- ALTER IGNORE TABLE ibf_message_topic_user_map ADD INDEX map_topic_id (map_topic_id);
- ALTER IGNORE TABLE ibf_message_topics ADD PRIMARY KEY (mt_id);
- ALTER IGNORE TABLE ibf_message_topics ADD INDEX mt_date (mt_date);
- ALTER IGNORE TABLE ibf_message_topics ADD INDEX mt_starter_id (mt_starter_id);
- ALTER IGNORE TABLE ibf_forums ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_forums ADD INDEX position (position,parent_id);
- ALTER IGNORE TABLE ibf_forums_archive_posts ADD PRIMARY KEY (archive_id);
- ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_topic_id (archive_topic_id,archive_queued,archive_content_date);
- ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_author_id (archive_author_id);
- ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_restored (archive_restored);
- ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_content_date (archive_content_date,archive_topic_id);
- ALTER IGNORE TABLE ibf_forums_recent_posts ADD PRIMARY KEY (post_id);
- ALTER IGNORE TABLE ibf_forums_recent_posts ADD INDEX group_lookup (post_author_id,post_forum_id,post_date,post_id);
- ALTER IGNORE TABLE ibf_mod_queued_items ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_mod_queued_items ADD INDEX type_id (type_id);
- ALTER IGNORE TABLE ibf_moderator_logs ADD PRIMARY KEY (id);
- ALTER IGNORE TABLE ibf_moderator_logs ADD INDEX ctime (ctime);
- ALTER IGNORE TABLE ibf_moderator_logs ADD INDEX ip_address (ip_address);
- ALTER IGNORE TABLE ibf_moderators ADD PRIMARY KEY (mid);
- ALTER IGNORE TABLE ibf_moderators ADD INDEX group_id (group_id);
- ALTER IGNORE TABLE ibf_moderators ADD INDEX member_id (member_id);
- ALTER IGNORE TABLE ibf_polls ADD PRIMARY KEY (pid);
- ALTER IGNORE TABLE ibf_polls ADD INDEX tid (tid);
- ALTER IGNORE TABLE ibf_posts ADD PRIMARY KEY (pid);
- ALTER IGNORE TABLE ibf_posts ADD INDEX topic_id (topic_id,queued,pid,post_date);
- ALTER IGNORE TABLE ibf_posts ADD INDEX author_id (author_id,post_date,queued);
- ALTER IGNORE TABLE ibf_posts ADD INDEX post_date (post_date);
- ALTER IGNORE TABLE ibf_posts ADD INDEX ip_address (ip_address);
- ALTER IGNORE TABLE ibf_posts ADD INDEX post_key (post_key);
- ALTER IGNORE TABLE ibf_posts ADD INDEX queued (queued,pdelete_time);
- ALTER IGNORE TABLE ibf_topic_ratings ADD PRIMARY KEY (rating_id);
- ALTER IGNORE TABLE ibf_topic_ratings ADD INDEX rating_tid (rating_tid,rating_member_id);
- ALTER IGNORE TABLE ibf_topic_ratings ADD INDEX rating_ip_address (rating_ip_address);
- ALTER IGNORE TABLE ibf_topic_views ADD INDEX views_tid (views_tid);
- ALTER IGNORE TABLE ibf_topics ADD PRIMARY KEY (tid);
- ALTER IGNORE TABLE ibf_topics ADD INDEX topic_firstpost (topic_firstpost);
- ALTER IGNORE TABLE ibf_topics ADD INDEX last_post (forum_id,pinned,last_post,state);
- ALTER IGNORE TABLE ibf_topics ADD INDEX forum_id (forum_id,pinned,approved);
- ALTER IGNORE TABLE ibf_topics ADD INDEX starter_id (starter_id,forum_id,approved,start_date);
- ALTER IGNORE TABLE ibf_topics ADD INDEX last_post_sorting (last_post,forum_id);
- ALTER IGNORE TABLE ibf_topics ADD INDEX start_date (start_date);
- ALTER IGNORE TABLE ibf_topics ADD INDEX last_x_topics (forum_id,approved,start_date);
- ALTER IGNORE TABLE ibf_topics ADD INDEX approved (approved,tdelete_time);
- ALTER IGNORE TABLE ibf_topics ADD INDEX moved_redirects (moved_on,moved_to,pinned);
- ALTER IGNORE TABLE ibf_topics ADD INDEX topic_archive_status (topic_archive_status,forum_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement