s4: commons UNIQUE into PK
ActivePublic
Actions

Authored by Marostegui on Mar 28 2017, 2:33 PM.

Tags

None

Referenced Files

	F7072944: s4: commons UNIQUE into PK
	Mar 29 2017, 6:18 AM

	F7051043: s5: commons UNIQUE into PK
	Mar 28 2017, 2:33 PM

Subscribers

Marostegui

	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --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=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=revtag --method=ddl --no-replicate "drop key rt_type_page_revision, add primary key (rt_type,rt_page,rt_revision)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=translate_messageindex --method=ddl --no-replicate "drop key tmi_key ,add primary key (tmi_key)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --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=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
	./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"

Event Timeline

Marostegui created this paste.Mar 28 2017, 2:33 PM

Marostegui changed the title of this paste from s5: commons UNIQUE into PK to s4: commons UNIQUE into PK.

Marostegui edited the content of this paste. (Show Details)Mar 29 2017, 6:18 AM

s4: commons UNIQUE into PKActivePublicActions

Event Timeline

s4: commons UNIQUE into PK
ActivePublic
Actions