Page MenuHomePhabricator
Paste P5154

s7: UNIQUE to PK
ActivePublic
Actions

Authored by • Marostegui on Mar 29 2017, 11:25 AM.
Tags
None
Referenced Files
F7081113: s7: UNIQUE to PK
Mar 29 2017, 1:43 PM
F7081085: s7: UNIQUE to PK
Mar 29 2017, 1:38 PM
F7081082: s7: UNIQUE to PK
Mar 29 2017, 1:37 PM
F7081066: s7: UNIQUE to PK
Mar 29 2017, 1:34 PM
F7080898: s7: UNIQUE to PK
Mar 29 2017, 12:57 PM
F7080627:
Mar 29 2017, 11:25 AM
Subscribers
• Marostegui
osc_arwiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=arwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_cawiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=cawiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_eswiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=eswiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_fawiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=fawiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_frwiktionary
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=frwiktionary --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_hewiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=hewiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_huwiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=huwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_kowiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=kowiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_rowiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=rowiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_ukwiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=ukwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_viwiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=viwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
osc_metawiki
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=translate_messageindex --method=ddl --no-replicate "drop key tmi_key ,add primary key (tmi_key)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=translate_reviews --method=ddl --no-replicate "drop key trr_user_page_revision ,add primary key (trr_user,trr_page,trr_revision)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1094.eqiad.wmnet --port=3306 --db=metawiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"

Event Timeline

• Marostegui created this paste.Mar 29 2017, 11:25 AM
• Marostegui changed the title of this paste from untitled to s7: UNIQUE to PK.
• Marostegui subscribed.
• Marostegui edited the content of this paste. (Show Details)Mar 29 2017, 12:57 PM
• Marostegui edited the content of this paste. (Show Details)Mar 29 2017, 1:34 PM
• Marostegui edited the content of this paste. (Show Details)Mar 29 2017, 1:37 PM
• Marostegui edited the content of this paste. (Show Details)
• Marostegui edited the content of this paste. (Show Details)Mar 29 2017, 1:43 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL