Page MenuHomePhabricator

Write DDL sql files for creating the schema
Closed, ResolvedPublic

Description

  • use integers for entity ids
  • find better naming for the tables

source: https://commons.wikimedia.org/wiki/File:Wikibase_Terms_Store_Schema.png

Details

Related Gerrit Patches:
mediawiki/extensions/Wikibase : masterAdd DDL for new schema of normalized wb_terms
mediawiki/extensions/Wikibase : masterAdd wb_terms replacement tables

Event Timeline

Change 498869 had a related patch set uploaded (by Alaa Sarhan; owner: Jeroen De Dauw):
[mediawiki/extensions/Wikibase@master] Add wb_terms replacement tables

https://gerrit.wikimedia.org/r/498869

Addshore moved this task from incoming to in progress on the Wikidata board.Mar 25 2019, 4:00 PM

Change 499142 had a related patch set uploaded (by Alaa Sarhan; owner: Jeroen De Dauw):
[mediawiki/extensions/Wikibase@master] Add DDL for new schema of normalized wb_terms.

https://gerrit.wikimedia.org/r/499142

Change 498869 abandoned by Alaa Sarhan:
Add wb_terms replacement tables

Reason:
Follow on 499142

https://gerrit.wikimedia.org/r/498869

alaa_wmde updated the task description. (Show Details)

@Ladsgroup I added the covering indexes on all tables with main field as first index and foreign key as the second to serve the joins.. not sure if we want the reverse order too as covering index so I didn't do it yet

@Ladsgroup I just realized that the covering index should actually have the join column first, right?

@Ladsgroup I just realized that the covering index should actually have the join column first, right?

Yes, that's true!

Okay will update the patch then

Change 499142 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Add DDL for new schema of normalized wb_terms

https://gerrit.wikimedia.org/r/499142

alaa_wmde closed this task as Resolved.May 22 2019, 10:27 AM