Lucas_Werkmeister_WMDE created this task. Lucas_Werkmeister_WMDE added projects: Wikibase-Quality-Constraints, Wikidata, Wikibase-Quality, Schema-change. Herald added a subscriber: Aklapper. |
Currently, the PRIMARY KEY of the wbqc_constraints table (found on wikis with the WikibaseQualityConstraints extension installed: wikidatawiki and testwikidatawiki) is the constraint_guid, which is a Wikibase statement ID: a forty-something character string like P580$F2A0326E-4245-4D26-A63F-DD700B6B7DDD. @Ladsgroup has kindly informed me that this is not ideal :) if we want to join the table against anything else (which we will want to do for T180582 – see this comment for details: feedback is welcome there too!), we should instead have an auto-incrementing integer as the primary key. (And then I assume there should be an index on the constraint_guid, just like we currently have one on the pid.)
Cc: aude, hoo, thiemowmde, Jonas, Lucas_Werkmeister_WMDE, Aklapper, Ladsgroup, Lahi, GoranSMilovanovic, QZanden, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Ltrlg
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs