Page MenuHomePhabricator
Create Task
Maniphest T169721

Remove term_entity_id during database schema update when term_full_entity_id is used instead
Closed, DeclinedPublic
Actions

Description

If term_full_entity_id is used for both read and write operations, and it is fully populated (i.e. does not contain any NULLs), it could be dropped during database schema update.

Related Objects
Search...

StatusSubtypeAssignedTask
 OpenNoneT115858 Design improvements for mw.ForeignStructuredUpload.BookletLayout
 OpenNoneT115865 Insert image in content immediately after it's uploaded, skipping the "General settings" step
 DuplicateNoneT115864 Figure out if the description of the image can be used as the caption on-wiki
 OpenFeatureNoneT53032 When inserting an image, set its caption by default to be the Commons image description
 OpenFeatureNoneT39534 Wikimedia Commons should support searching by color
 DuplicateNoneT39535 Wikimedia Commons should support filtering by color
 ResolvedNoneT19503 Provide metadata support on Wikimedia Commons
 ResolvedNoneT51662 VisualEditor: Use Multimedia/Wikidata's proposed rich structured meta-data in the image insertion dialog
 ResolvedNoneT68108 [Epic] Store media information for files on Wikimedia Commons as structured data
 DuplicateNoneT66288 basic support for structured data on mediawiki files
 InvalidLydia_PintscherT76012 make use of new entity type for multimedia / structured data of media files
 OpenNoneT109579 [Epic] Give more sister projects access to Wikidata
 OpenNoneT187900 There is no way to reference a specific quote on Wikiquote
 StalledNoneT71753 [Story] Wikibase / Wikidata support on Wikiquote
 OpenNoneT67626 [Epic] Support for queries on-wiki (automated list generation)
 ResolvedAddshoreT76019 [Story] Support new types of Entities in Wikibase Client
 ResolvedthiemowmdeT135650 [Task] Migrate PropertySuggester away from assuming all entities are numeric
 ResolvedAddshoreT75496 [Epic] Support new types of Entities in Wikibase Repository
 DeclinedNoneT58711 [Task] Update the wb_terms table so it does not have a numeric entity id
 OpenNoneT30599 Deadlock tracking bug (tracking)
 ResolvedhooT111535 Wikibase\Repo\Store\SQL\EntityPerPageTable::{closure} creating high number of deadlocks
 ResolvedLydia_PintscherT146637 Wikidata 2016 Q4 goals
 ResolvedNoneT86530 Replace wb_terms table with more specialized mechanisms for terms (tracking)
 DeclinedNoneT51982 Add missing wb_entity_per_page entries on LinksUpdate
 InvalidLydia_PintscherT70176 EntityPerPageTable class should be usable from the client
 ResolvedLadsgroupT67333 Wikibase\EntityPerPageTable::getItemsWithoutSitelinks slow query with large LIMIT offset
 ResolvedAddshoreT114902 Remove numeric entity IDs from database schema
 ResolvedLadsgroupT95685 Drop wb_entity_per_page table
 DeclinedNoneT114903 Migrate wb_terms to using prefixed entity IDs instead of numeric IDs
 DeclinedNoneT169720 Remove column storing numeric entity ID in wb_terms once it has become redundant
 DeclinedNoneT169721 Remove term_entity_id during database schema update when term_full_entity_id is used instead

Event Timeline

WMDE-leszek created this task.Jul 5 2017, 11:11 AM
Addshore changed the task status from Open to Stalled.Sep 20 2018, 10:11 PM
Addshore subscribed.

Stalled as we are trying not to touch the table, instead migrating away from it.

Addshore closed this task as Declined.Mar 25 2019, 4:18 PM

the wb_terms table is being removed in T208425.

In preparation for that I am simply going to close this task.

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 · Credits