https://bugzilla.wikimedia.org/show_bug.cgi?id=33713
--- Comment #1 from Sam Reed (reedy) <[email protected]> 2012-01-14 15:17:50 UTC --- We already have "CodeReivision::addReferencesFrom()" and "CodeReivision::addReferencesTo()" As for indexes, we are fine: -- And for our commenting system... -- To specify follow-up relationships... CREATE TABLE /*_*/code_relations ( cf_repo_id int not null, -- -> cr_id cf_from int not null, -- -> cr_id cf_to int not null, primary key (cf_repo_id, cf_from, cf_to) ) /*$wgDBTableOptions*/; CREATE INDEX /*i*/repo_to_from ON /*_*/code_relations (cf_repo_id, cf_to, cf_from); Always filter by the repo, then we can do a query on to or from no issue! -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
