Remove column storing numeric entity ID in wb_terms once it has become redundant
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	WMDE-leszek
	Jul 5 2017, 11:09 AM

Description

Once wb_terms got the column for "full" entity ID (term_full_entity_id) and it has been fully populated and is used for all operations instead of the old "numeric" entity ID column (term_entity_id), the old column may be removed as no longer needed.

Related Objects
Search...

Status	Subtype	Assigned	Task
Declined		dchen	T118706 Conduct heuristic evaluation of image upload and insert flow in VisualEditor
Open		None	T115858 Design improvements for mw.ForeignStructuredUpload.BookletLayout
Open		None	T115865 Insert image in content immediately after it's uploaded, skipping the "General settings" step
Duplicate		None	T115864 Figure out if the description of the image can be used as the caption on-wiki
Open	Feature	None	T53032 When inserting an image, set its caption by default to be the Commons image description
Open	Feature	None	T39534 Wikimedia Commons should support searching by color
Duplicate		None	T39535 Wikimedia Commons should support filtering by color
Resolved		None	T19503 Provide metadata support on Wikimedia Commons
Resolved		None	T51662 VisualEditor: Use Multimedia/Wikidata's proposed rich structured meta-data in the image insertion dialog
Resolved		None	T68108 [Epic] Store media information for files on Wikimedia Commons as structured data
Duplicate		None	T66288 basic support for structured data on mediawiki files
Invalid		Lydia_Pintscher	T76012 make use of new entity type for multimedia / structured data of media files
Open		None	T109579 [Epic] Give more sister projects access to Wikidata
Open		None	T187900 There is no way to reference a specific quote on Wikiquote
Stalled		None	T71753 [Story] Wikibase / Wikidata support on Wikiquote
Open		None	T67626 [Epic] Support for queries on-wiki (automated list generation)
Resolved		Addshore	T76019 [Story] Support new types of Entities in Wikibase Client
Resolved		thiemowmde	T135650 [Task] Migrate PropertySuggester away from assuming all entities are numeric
Resolved		Addshore	T75496 [Epic] Support new types of Entities in Wikibase Repository
Declined		None	T58711 [Task] Update the wb_terms table so it does not have a numeric entity id
Open		None	T30599 Deadlock tracking bug (tracking)
Resolved		hoo	T111535 Wikibase\Repo\Store\SQL\EntityPerPageTable::{closure} creating high number of deadlocks
Resolved		Lydia_Pintscher	T146637 Wikidata 2016 Q4 goals
Resolved		None	T86530 Replace wb_terms table with more specialized mechanisms for terms (tracking)
Declined		None	T51982 Add missing wb_entity_per_page entries on LinksUpdate
Invalid		Lydia_Pintscher	T70176 EntityPerPageTable class should be usable from the client
Resolved		Ladsgroup	T67333 Wikibase\EntityPerPageTable::getItemsWithoutSitelinks slow query with large LIMIT offset
Resolved		Addshore	T114902 Remove numeric entity IDs from database schema
Resolved		Ladsgroup	T95685 Drop wb_entity_per_page table
Declined		None	T114903 Migrate wb_terms to using prefixed entity IDs instead of numeric IDs
Declined		None	T169720 Remove column storing numeric entity ID in wb_terms once it has become redundant
Declined		None	T169721 Remove term_entity_id during database schema update when term_full_entity_id is used instead
Declined		None	T169722 Remove term_entity_id column from wb_terms table when no longer needed on WMF cluster
Resolved		Ladsgroup	T188995 Clean up the code base for term_entity_id