Advertisement
Guest User

Untitled

a guest
Oct 25th, 2016
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.01 KB | None | 0 0
  1. ALTER IGNORE TABLE ibf_admin_login_logs ADD PRIMARY KEY (admin_id);
  2. ALTER IGNORE TABLE ibf_admin_login_logs ADD INDEX admin_ip_address (admin_ip_address);
  3. ALTER IGNORE TABLE ibf_admin_login_logs ADD INDEX admin_time (admin_time);
  4. ALTER IGNORE TABLE ibf_announcements ADD PRIMARY KEY (announce_id);
  5. ALTER IGNORE TABLE ibf_announcements ADD INDEX announce_end (announce_end);
  6. ALTER IGNORE TABLE ibf_api_log ADD PRIMARY KEY (api_log_id);
  7. ALTER IGNORE TABLE ibf_api_log ADD INDEX api_log_date (api_log_date);
  8. ALTER IGNORE TABLE ibf_attachments ADD PRIMARY KEY (attach_id);
  9. ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_pid (attach_rel_id);
  10. ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_post_key (attach_post_key);
  11. ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_mid_size (attach_member_id,attach_rel_module,attach_filesize);
  12. ALTER IGNORE TABLE ibf_attachments ADD INDEX attach_parent_id (attach_parent_id,attach_rel_module);
  13. ALTER IGNORE TABLE ibf_attachments_type ADD PRIMARY KEY (atype_id);
  14. ALTER IGNORE TABLE ibf_attachments_type ADD INDEX atype (atype_post);
  15. ALTER IGNORE TABLE ibf_attachments_type ADD INDEX atype_extension (atype_extension);
  16. ALTER IGNORE TABLE ibf_banfilters ADD PRIMARY KEY (ban_id);
  17. ALTER IGNORE TABLE ibf_banfilters ADD INDEX ban_content (ban_content(200));
  18. ALTER IGNORE TABLE ibf_bulk_mail ADD PRIMARY KEY (mail_id);
  19. ALTER IGNORE TABLE ibf_bulk_mail ADD INDEX mail_start (mail_start);
  20. ALTER IGNORE TABLE ibf_content_cache_sigs ADD INDEX date_index (cache_updated);
  21. ALTER IGNORE TABLE ibf_content_cache_posts ADD INDEX date_index (cache_updated);
  22. ALTER IGNORE TABLE ibf_core_editor_autosave ADD UNIQUE KEY eas_key (eas_key);
  23. ALTER IGNORE TABLE ibf_core_editor_autosave ADD INDEX eas_member_lookup (eas_member_id,eas_app,eas_section);
  24. ALTER IGNORE TABLE ibf_core_editor_autosave ADD INDEX eas_updated (eas_updated);
  25. ALTER IGNORE TABLE ibf_core_like ADD PRIMARY KEY (like_id);
  26. ALTER IGNORE TABLE ibf_core_like ADD INDEX find_rel_likes (like_lookup_id,like_visible,like_is_anon,like_added);
  27. ALTER IGNORE TABLE ibf_core_like ADD INDEX like_member_id (like_member_id,like_visible,like_added);
  28. ALTER IGNORE TABLE ibf_core_like ADD INDEX like_lookup_area (like_lookup_area,like_visible);
  29. 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));
  30. ALTER IGNORE TABLE ibf_core_geolocation_cache ADD PRIMARY KEY (geocache_key);
  31. ALTER IGNORE TABLE ibf_core_geolocation_cache ADD INDEX geo_lat_lon (geocache_lat,geocache_lon);
  32. ALTER IGNORE TABLE ibf_core_tags ADD PRIMARY KEY (tag_id);
  33. ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_aai_lookup (tag_aai_lookup);
  34. ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_app (tag_meta_app(100),tag_meta_area(100));
  35. ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_member_id (tag_member_id);
  36. ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_aap_lookup (tag_aap_lookup,tag_text(200));
  37. ALTER IGNORE TABLE ibf_core_tags ADD INDEX tag_added (tag_added);
  38. ALTER IGNORE TABLE ibf_core_tags_perms ADD UNIQUE KEY tag_perm_aai_lookup (tag_perm_aai_lookup);
  39. ALTER IGNORE TABLE ibf_captcha ADD PRIMARY KEY (captcha_unique_id);
  40. ALTER IGNORE TABLE ibf_captcha ADD INDEX captcha_date (captcha_date);
  41. ALTER IGNORE TABLE ibf_converge_local ADD PRIMARY KEY (converge_api_code);
  42. ALTER IGNORE TABLE ibf_converge_local ADD INDEX converge_active (converge_active);
  43. ALTER IGNORE TABLE ibf_core_applications ADD PRIMARY KEY (app_id);
  44. ALTER IGNORE TABLE ibf_core_applications ADD INDEX app_directory (app_directory);
  45. ALTER IGNORE TABLE ibf_core_hooks_files ADD PRIMARY KEY (hook_file_id);
  46. ALTER IGNORE TABLE ibf_core_hooks_files ADD INDEX hook_hook_id (hook_hook_id);
  47. ALTER IGNORE TABLE ibf_core_item_markers ADD UNIQUE KEY combo_key (item_key,item_member_id,item_app);
  48. ALTER IGNORE TABLE ibf_core_item_markers ADD INDEX marker_index (item_member_id,item_app,item_app_key_1);
  49. ALTER IGNORE TABLE ibf_core_item_markers ADD INDEX item_last_saved (item_last_saved);
  50. ALTER IGNORE TABLE ibf_core_item_markers ADD INDEX item_member_id (item_is_deleted,item_member_id);
  51. ALTER IGNORE TABLE ibf_core_item_markers_storage ADD PRIMARY KEY (item_member_id);
  52. ALTER IGNORE TABLE ibf_core_item_markers_storage ADD INDEX item_last_saved (item_last_saved);
  53. ALTER IGNORE TABLE ibf_core_rss_imported ADD PRIMARY KEY (rss_guid);
  54. ALTER IGNORE TABLE ibf_core_rss_imported ADD INDEX rss_grabber (rss_guid,rss_foreign_key);
  55. ALTER IGNORE TABLE ibf_core_share_links ADD PRIMARY KEY (share_id);
  56. ALTER IGNORE TABLE ibf_core_share_links_log ADD PRIMARY KEY (log_id);
  57. ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX findstuff (log_data_app,log_data_type,log_data_primary_id);
  58. ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_date (log_date);
  59. ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_member_id (log_member_id);
  60. ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_share_key (log_share_key);
  61. ALTER IGNORE TABLE ibf_core_share_links_log ADD INDEX log_ip_address (log_ip_address);
  62. ALTER IGNORE TABLE ibf_core_soft_delete_log ADD PRIMARY KEY (sdl_id);
  63. ALTER IGNORE TABLE ibf_core_soft_delete_log ADD INDEX look_up (sdl_obj_id,sdl_obj_key);
  64. ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD PRIMARY KEY (conf_id);
  65. ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD INDEX conf_key (conf_key);
  66. ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD INDEX conf_group (conf_group,conf_position,conf_title);
  67. ALTER IGNORE TABLE ibf_core_sys_conf_settings ADD INDEX conf_add_cache (conf_add_cache);
  68. ALTER IGNORE TABLE ibf_core_sys_cp_sessions ADD PRIMARY KEY (session_id);
  69. ALTER IGNORE TABLE ibf_core_sys_cp_sessions ADD INDEX session_running_time (session_running_time);
  70. ALTER IGNORE TABLE ibf_core_sys_cp_sessions ADD INDEX session_member_id (session_member_id);
  71. ALTER IGNORE TABLE ibf_core_sys_lang ADD PRIMARY KEY (lang_id);
  72. ALTER IGNORE TABLE ibf_core_sys_lang ADD INDEX lang_short (lang_short);
  73. ALTER IGNORE TABLE ibf_core_sys_lang ADD INDEX lang_default (lang_default);
  74. ALTER IGNORE TABLE ibf_core_sys_lang_words ADD PRIMARY KEY (word_id);
  75. ALTER IGNORE TABLE ibf_core_sys_lang_words ADD INDEX word_js (word_js);
  76. ALTER IGNORE TABLE ibf_core_sys_lang_words ADD INDEX word_find (lang_id,word_app(32),word_pack(100));
  77. ALTER IGNORE TABLE ibf_core_sys_module ADD PRIMARY KEY (sys_module_id);
  78. ALTER IGNORE TABLE ibf_core_sys_module ADD INDEX sys_module_application (sys_module_application);
  79. ALTER IGNORE TABLE ibf_core_sys_module ADD INDEX sys_module_visible (sys_module_visible);
  80. ALTER IGNORE TABLE ibf_core_sys_module ADD INDEX sys_module_key (sys_module_key);
  81. ALTER IGNORE TABLE ibf_core_sys_settings_titles ADD PRIMARY KEY (conf_title_id);
  82. ALTER IGNORE TABLE ibf_core_sys_settings_titles ADD INDEX conf_title_keyword (conf_title_keyword);
  83. ALTER IGNORE TABLE ibf_core_uagent_groups ADD PRIMARY KEY (ugroup_id);
  84. ALTER IGNORE TABLE ibf_core_uagent_groups ADD INDEX ugroup_title (ugroup_title);
  85. ALTER IGNORE TABLE ibf_core_uagents ADD PRIMARY KEY (uagent_id);
  86. ALTER IGNORE TABLE ibf_core_uagents ADD INDEX uagent_key (uagent_key);
  87. ALTER IGNORE TABLE ibf_core_uagents ADD INDEX ordering (uagent_position,uagent_key);
  88. ALTER IGNORE TABLE ibf_dnames_change ADD PRIMARY KEY (dname_id);
  89. ALTER IGNORE TABLE ibf_dnames_change ADD INDEX dname_member_id (dname_member_id);
  90. ALTER IGNORE TABLE ibf_dnames_change ADD INDEX date_id (dname_member_id,dname_date);
  91. ALTER IGNORE TABLE ibf_dnames_change ADD INDEX dname_ip_address (dname_ip_address);
  92. ALTER IGNORE TABLE ibf_emoticons ADD PRIMARY KEY (id);
  93. ALTER IGNORE TABLE ibf_emoticons ADD INDEX emo_set (emo_set);
  94. ALTER IGNORE TABLE ibf_error_logs ADD PRIMARY KEY (log_id);
  95. ALTER IGNORE TABLE ibf_error_logs ADD INDEX log_date (log_date);
  96. ALTER IGNORE TABLE ibf_error_logs ADD INDEX log_ip_address (log_ip_address);
  97. ALTER IGNORE TABLE ibf_ignored_users ADD PRIMARY KEY (ignore_id);
  98. ALTER IGNORE TABLE ibf_ignored_users ADD INDEX ignore_owner_id (ignore_owner_id);
  99. ALTER IGNORE TABLE ibf_ignored_users ADD INDEX ignore_ignore_id (ignore_ignore_id);
  100. ALTER IGNORE TABLE ibf_cache_simple ADD UNIQUE KEY lookup (cache_id,cache_perm_key);
  101. ALTER IGNORE TABLE ibf_inline_notifications ADD PRIMARY KEY (notify_id);
  102. ALTER IGNORE TABLE ibf_inline_notifications ADD INDEX notify_to_id (notify_to_id,notify_sent);
  103. ALTER IGNORE TABLE ibf_inline_notifications ADD INDEX grabber (notify_to_id,notify_read,notify_sent);
  104. ALTER IGNORE TABLE ibf_inline_notifications ADD INDEX notify_meta_key (notify_meta_key);
  105. ALTER IGNORE TABLE ibf_members ADD PRIMARY KEY (member_id);
  106. ALTER IGNORE TABLE ibf_members ADD INDEX members_l_display_name (members_l_display_name);
  107. ALTER IGNORE TABLE ibf_members ADD INDEX members_l_username (members_l_username);
  108. ALTER IGNORE TABLE ibf_members ADD INDEX mgroup (member_group_id,member_id);
  109. ALTER IGNORE TABLE ibf_members ADD INDEX bday_day (bday_day);
  110. ALTER IGNORE TABLE ibf_members ADD INDEX bday_month (bday_month);
  111. ALTER IGNORE TABLE ibf_members ADD INDEX member_banned (member_banned);
  112. ALTER IGNORE TABLE ibf_members ADD INDEX members_bitoptions (members_bitoptions);
  113. ALTER IGNORE TABLE ibf_members ADD INDEX ip_address (ip_address);
  114. ALTER IGNORE TABLE ibf_members ADD INDEX failed_login_count (failed_login_count);
  115. ALTER IGNORE TABLE ibf_members ADD INDEX joined (joined);
  116. ALTER IGNORE TABLE ibf_members ADD INDEX fb_uid (fb_uid);
  117. ALTER IGNORE TABLE ibf_members ADD INDEX twitter_id (twitter_id);
  118. ALTER IGNORE TABLE ibf_members ADD INDEX email (email);
  119. ALTER IGNORE TABLE ibf_members_partial ADD PRIMARY KEY (partial_id);
  120. ALTER IGNORE TABLE ibf_members_partial ADD INDEX partial_member_id (partial_member_id);
  121. ALTER IGNORE TABLE ibf_members_warn_actions ADD PRIMARY KEY (wa_id);
  122. ALTER IGNORE TABLE ibf_members_warn_actions ADD INDEX wa_points (wa_points);
  123. ALTER IGNORE TABLE ibf_members_warn_logs ADD PRIMARY KEY (wl_id);
  124. ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_member (wl_member);
  125. ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_moderator (wl_moderator);
  126. ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_date (wl_member,wl_date);
  127. ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX content (wl_content_app,wl_content_id1,wl_content_id2);
  128. ALTER IGNORE TABLE ibf_members_warn_logs ADD INDEX wl_expire_date (wl_expire_date);
  129. ALTER IGNORE TABLE ibf_members_warn_reasons ADD PRIMARY KEY (wr_id);
  130. ALTER IGNORE TABLE ibf_members_warn_reasons ADD INDEX wr_order (wr_order);
  131. ALTER IGNORE TABLE ibf_member_status_actions ADD PRIMARY KEY (action_id);
  132. ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_status_id (action_status_id);
  133. ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_member_id (action_member_id,action_date);
  134. ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_date (action_date);
  135. ALTER IGNORE TABLE ibf_member_status_actions ADD INDEX action_custom (action_custom,action_date);
  136. ALTER IGNORE TABLE ibf_member_status_replies ADD PRIMARY KEY (reply_id);
  137. ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_status_id (reply_status_id);
  138. ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_member_id (reply_member_id);
  139. ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_status_count (reply_status_id,reply_member_id);
  140. ALTER IGNORE TABLE ibf_member_status_replies ADD INDEX reply_date (reply_date);
  141. ALTER IGNORE TABLE ibf_member_status_updates ADD PRIMARY KEY (status_id);
  142. ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_date (status_date);
  143. ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX s_hash (status_member_id,status_hash,status_date);
  144. ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_is_latest (status_is_latest,status_date);
  145. ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_author_lookup (status_author_id,status_member_id,status_date);
  146. ALTER IGNORE TABLE ibf_member_status_updates ADD INDEX status_member_id (status_member_id,status_approved,status_date);
  147. ALTER IGNORE TABLE ibf_permission_index ADD PRIMARY KEY (perm_id);
  148. ALTER IGNORE TABLE ibf_permission_index ADD INDEX perm_index (perm_type,perm_type_id);
  149. ALTER IGNORE TABLE ibf_permission_index ADD INDEX perm_type (app,perm_type,perm_type_id);
  150. ALTER IGNORE TABLE ibf_profile_friends ADD PRIMARY KEY (friends_id);
  151. ALTER IGNORE TABLE ibf_profile_friends ADD INDEX my_friends (friends_member_id,friends_friend_id);
  152. ALTER IGNORE TABLE ibf_profile_friends_flood ADD PRIMARY KEY (friends_id);
  153. ALTER IGNORE TABLE ibf_profile_friends_flood ADD INDEX my_friends (friends_member_id,friends_friend_id);
  154. ALTER IGNORE TABLE ibf_profile_portal_views ADD INDEX views_member_id (views_member_id);
  155. ALTER IGNORE TABLE ibf_profile_ratings ADD PRIMARY KEY (rating_id);
  156. ALTER IGNORE TABLE ibf_profile_ratings ADD INDEX rating_for_member_id (rating_for_member_id);
  157. ALTER IGNORE TABLE ibf_profile_ratings ADD INDEX rating_ip_address (rating_ip_address);
  158. ALTER IGNORE TABLE ibf_rc_classes ADD PRIMARY KEY (com_id);
  159. ALTER IGNORE TABLE ibf_rc_classes ADD INDEX onoff (onoff,mod_group_perm(255));
  160. ALTER IGNORE TABLE ibf_rc_reports ADD PRIMARY KEY (id);
  161. ALTER IGNORE TABLE ibf_rc_reports ADD INDEX rid (rid);
  162. ALTER IGNORE TABLE ibf_rc_reports_index ADD PRIMARY KEY (id);
  163. ALTER IGNORE TABLE ibf_rc_reports_index ADD INDEX uid (uid);
  164. ALTER IGNORE TABLE ibf_rc_reports_index ADD INDEX status (status);
  165. ALTER IGNORE TABLE ibf_rc_status_sev ADD PRIMARY KEY (id);
  166. ALTER IGNORE TABLE ibf_rc_status_sev ADD INDEX status (status,points);
  167. ALTER IGNORE TABLE ibf_reputation_cache ADD PRIMARY KEY (id);
  168. ALTER IGNORE TABLE ibf_reputation_cache ADD UNIQUE KEY app (app,type,type_id);
  169. ALTER IGNORE TABLE ibf_reputation_cache ADD INDEX cache_date (cache_date);
  170. ALTER IGNORE TABLE ibf_reputation_cache ADD INDEX type (type,type_id);
  171. ALTER IGNORE TABLE ibf_reputation_index ADD PRIMARY KEY (id);
  172. ALTER IGNORE TABLE ibf_reputation_index ADD INDEX app (app,type,type_id,member_id);
  173. ALTER IGNORE TABLE ibf_reputation_index ADD INDEX member_rep (member_id,rep_rating,rep_date);
  174. ALTER IGNORE TABLE ibf_rss_import ADD PRIMARY KEY (rss_import_id);
  175. ALTER IGNORE TABLE ibf_rss_import ADD INDEX rss_grab (rss_import_enabled,rss_import_last_import);
  176. ALTER IGNORE TABLE ibf_rss_imported ADD PRIMARY KEY (rss_imported_guid);
  177. ALTER IGNORE TABLE ibf_rss_imported ADD INDEX rss_imported_impid (rss_imported_impid);
  178. ALTER IGNORE TABLE ibf_search_sessions ADD PRIMARY KEY (session_id);
  179. ALTER IGNORE TABLE ibf_search_sessions ADD INDEX session_updated (session_updated);
  180. ALTER IGNORE TABLE ibf_sessions ADD PRIMARY KEY (id);
  181. ALTER IGNORE TABLE ibf_sessions ADD INDEX location1 (location_1_type,location_1_id);
  182. ALTER IGNORE TABLE ibf_sessions ADD INDEX location2 (location_2_type,location_2_id);
  183. ALTER IGNORE TABLE ibf_sessions ADD INDEX location3 (location_3_type,location_3_id);
  184. ALTER IGNORE TABLE ibf_sessions ADD INDEX running_time (running_time);
  185. ALTER IGNORE TABLE ibf_sessions ADD INDEX member_id (member_id);
  186. ALTER IGNORE TABLE ibf_skin_cache ADD PRIMARY KEY (cache_id);
  187. ALTER IGNORE TABLE ibf_skin_cache ADD INDEX cache_type (cache_type);
  188. ALTER IGNORE TABLE ibf_skin_cache ADD INDEX cache_set_id (cache_set_id);
  189. ALTER IGNORE TABLE ibf_skin_collections ADD PRIMARY KEY (set_id);
  190. ALTER IGNORE TABLE ibf_skin_collections ADD INDEX parent_set_id (set_parent_id,set_id);
  191. ALTER IGNORE TABLE ibf_skin_collections ADD INDEX set_is_default (set_is_default);
  192. ALTER IGNORE TABLE ibf_skin_collections ADD INDEX set_order (set_order);
  193. ALTER IGNORE TABLE ibf_skin_css ADD PRIMARY KEY (css_id);
  194. ALTER IGNORE TABLE ibf_skin_css ADD INDEX css_set_id (css_set_id);
  195. ALTER IGNORE TABLE ibf_skin_merge_changes ADD PRIMARY KEY (change_id);
  196. ALTER IGNORE TABLE ibf_skin_merge_changes ADD INDEX change_key_change_data_type (change_key,change_data_type);
  197. ALTER IGNORE TABLE ibf_skin_replacements ADD PRIMARY KEY (replacement_id);
  198. ALTER IGNORE TABLE ibf_skin_replacements ADD INDEX replacement_set_id (replacement_set_id);
  199. ALTER IGNORE TABLE ibf_skin_templates ADD PRIMARY KEY (template_id);
  200. ALTER IGNORE TABLE ibf_skin_templates ADD INDEX template_set_id (template_set_id);
  201. ALTER IGNORE TABLE ibf_skin_templates ADD INDEX template_master_key (template_master_key);
  202. ALTER IGNORE TABLE ibf_skin_templates ADD INDEX template_name (template_name(100),template_group(100));
  203. ALTER IGNORE TABLE ibf_skin_templates_cache ADD PRIMARY KEY (template_id);
  204. ALTER IGNORE TABLE ibf_skin_templates_cache ADD INDEX template_set_id (template_set_id);
  205. ALTER IGNORE TABLE ibf_skin_templates_cache ADD INDEX template_group_name (template_group_name);
  206. ALTER IGNORE TABLE ibf_spider_logs ADD PRIMARY KEY (sid);
  207. ALTER IGNORE TABLE ibf_spider_logs ADD INDEX entry_date (entry_date);
  208. ALTER IGNORE TABLE ibf_tags_index ADD PRIMARY KEY (id);
  209. ALTER IGNORE TABLE ibf_tags_index ADD INDEX app (app);
  210. ALTER IGNORE TABLE ibf_tags_index ADD INDEX tag_grab (app,type,type_id,type_2,type_id_2,tag_hidden);
  211. ALTER IGNORE TABLE ibf_task_logs ADD PRIMARY KEY (log_id);
  212. ALTER IGNORE TABLE ibf_task_logs ADD INDEX log_date (log_date);
  213. ALTER IGNORE TABLE ibf_task_manager ADD PRIMARY KEY (task_id);
  214. ALTER IGNORE TABLE ibf_task_manager ADD UNIQUE KEY task_key (task_application,task_key);
  215. ALTER IGNORE TABLE ibf_task_manager ADD INDEX task_next_run (task_enabled,task_next_run);
  216. ALTER IGNORE TABLE ibf_titles ADD PRIMARY KEY (id);
  217. ALTER IGNORE TABLE ibf_titles ADD INDEX posts (posts);
  218. ALTER IGNORE TABLE ibf_upgrade_history ADD PRIMARY KEY (upgrade_id);
  219. ALTER IGNORE TABLE ibf_upgrade_history ADD INDEX upgrades (upgrade_app,upgrade_version_id);
  220. ALTER IGNORE TABLE ibf_validating ADD PRIMARY KEY (vid);
  221. ALTER IGNORE TABLE ibf_validating ADD INDEX new_reg (new_reg);
  222. ALTER IGNORE TABLE ibf_validating ADD INDEX ip_address (ip_address);
  223. ALTER IGNORE TABLE ibf_validating ADD INDEX lost_pass (lost_pass);
  224. ALTER IGNORE TABLE ibf_validating ADD INDEX coppa_user (coppa_user);
  225. ALTER IGNORE TABLE ibf_validating ADD INDEX spam_flag (spam_flag);
  226. ALTER IGNORE TABLE ibf_validating ADD INDEX member_id (member_id);
  227. ALTER IGNORE TABLE ibf_voters ADD PRIMARY KEY (vid);
  228. ALTER IGNORE TABLE ibf_voters ADD INDEX tid (tid);
  229. ALTER IGNORE TABLE ibf_voters ADD INDEX ip_address (ip_address);
  230. ALTER IGNORE TABLE ibf_warn_logs ADD PRIMARY KEY (wlog_id);
  231. ALTER IGNORE TABLE ibf_warn_logs ADD INDEX wlog_mid (wlog_mid,wlog_date);
  232. ALTER IGNORE TABLE ibf_mobile_notifications ADD PRIMARY KEY (id);
  233. ALTER IGNORE TABLE ibf_mobile_notifications ADD INDEX notify_sent_notify_date (notify_sent,notify_date);
  234. ALTER IGNORE TABLE ibf_message_posts ADD PRIMARY KEY (msg_id);
  235. ALTER IGNORE TABLE ibf_message_posts ADD INDEX msg_topic_id (msg_topic_id);
  236. ALTER IGNORE TABLE ibf_message_posts ADD INDEX msg_date (msg_date);
  237. ALTER IGNORE TABLE ibf_message_posts ADD INDEX msg_ip_address (msg_ip_address);
  238. ALTER IGNORE TABLE ibf_message_topic_user_map ADD PRIMARY KEY (map_id);
  239. ALTER IGNORE TABLE ibf_message_topic_user_map ADD UNIQUE KEY map_main (map_user_id,map_topic_id);
  240. ALTER IGNORE TABLE ibf_message_topic_user_map ADD INDEX map_user (map_user_id,map_folder_id,map_last_topic_reply);
  241. ALTER IGNORE TABLE ibf_message_topic_user_map ADD INDEX map_topic_id (map_topic_id);
  242. ALTER IGNORE TABLE ibf_message_topics ADD PRIMARY KEY (mt_id);
  243. ALTER IGNORE TABLE ibf_message_topics ADD INDEX mt_date (mt_date);
  244. ALTER IGNORE TABLE ibf_message_topics ADD INDEX mt_starter_id (mt_starter_id);
  245. ALTER IGNORE TABLE ibf_forums ADD PRIMARY KEY (id);
  246. ALTER IGNORE TABLE ibf_forums ADD INDEX position (position,parent_id);
  247. ALTER IGNORE TABLE ibf_forums_archive_posts ADD PRIMARY KEY (archive_id);
  248. ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_topic_id (archive_topic_id,archive_queued,archive_content_date);
  249. ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_author_id (archive_author_id);
  250. ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_restored (archive_restored);
  251. ALTER IGNORE TABLE ibf_forums_archive_posts ADD INDEX archive_content_date (archive_content_date,archive_topic_id);
  252. ALTER IGNORE TABLE ibf_forums_recent_posts ADD PRIMARY KEY (post_id);
  253. ALTER IGNORE TABLE ibf_forums_recent_posts ADD INDEX group_lookup (post_author_id,post_forum_id,post_date,post_id);
  254. ALTER IGNORE TABLE ibf_mod_queued_items ADD PRIMARY KEY (id);
  255. ALTER IGNORE TABLE ibf_mod_queued_items ADD INDEX type_id (type_id);
  256. ALTER IGNORE TABLE ibf_moderator_logs ADD PRIMARY KEY (id);
  257. ALTER IGNORE TABLE ibf_moderator_logs ADD INDEX ctime (ctime);
  258. ALTER IGNORE TABLE ibf_moderator_logs ADD INDEX ip_address (ip_address);
  259. ALTER IGNORE TABLE ibf_moderators ADD PRIMARY KEY (mid);
  260. ALTER IGNORE TABLE ibf_moderators ADD INDEX group_id (group_id);
  261. ALTER IGNORE TABLE ibf_moderators ADD INDEX member_id (member_id);
  262. ALTER IGNORE TABLE ibf_polls ADD PRIMARY KEY (pid);
  263. ALTER IGNORE TABLE ibf_polls ADD INDEX tid (tid);
  264. ALTER IGNORE TABLE ibf_posts ADD PRIMARY KEY (pid);
  265. ALTER IGNORE TABLE ibf_posts ADD INDEX topic_id (topic_id,queued,pid,post_date);
  266. ALTER IGNORE TABLE ibf_posts ADD INDEX author_id (author_id,post_date,queued);
  267. ALTER IGNORE TABLE ibf_posts ADD INDEX post_date (post_date);
  268. ALTER IGNORE TABLE ibf_posts ADD INDEX ip_address (ip_address);
  269. ALTER IGNORE TABLE ibf_posts ADD INDEX post_key (post_key);
  270. ALTER IGNORE TABLE ibf_posts ADD INDEX queued (queued,pdelete_time);
  271. ALTER IGNORE TABLE ibf_topic_ratings ADD PRIMARY KEY (rating_id);
  272. ALTER IGNORE TABLE ibf_topic_ratings ADD INDEX rating_tid (rating_tid,rating_member_id);
  273. ALTER IGNORE TABLE ibf_topic_ratings ADD INDEX rating_ip_address (rating_ip_address);
  274. ALTER IGNORE TABLE ibf_topic_views ADD INDEX views_tid (views_tid);
  275. ALTER IGNORE TABLE ibf_topics ADD PRIMARY KEY (tid);
  276. ALTER IGNORE TABLE ibf_topics ADD INDEX topic_firstpost (topic_firstpost);
  277. ALTER IGNORE TABLE ibf_topics ADD INDEX last_post (forum_id,pinned,last_post,state);
  278. ALTER IGNORE TABLE ibf_topics ADD INDEX forum_id (forum_id,pinned,approved);
  279. ALTER IGNORE TABLE ibf_topics ADD INDEX starter_id (starter_id,forum_id,approved,start_date);
  280. ALTER IGNORE TABLE ibf_topics ADD INDEX last_post_sorting (last_post,forum_id);
  281. ALTER IGNORE TABLE ibf_topics ADD INDEX start_date (start_date);
  282. ALTER IGNORE TABLE ibf_topics ADD INDEX last_x_topics (forum_id,approved,start_date);
  283. ALTER IGNORE TABLE ibf_topics ADD INDEX approved (approved,tdelete_time);
  284. ALTER IGNORE TABLE ibf_topics ADD INDEX moved_redirects (moved_on,moved_to,pinned);
  285. 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