Project

General

Profile

« Previous | Next » 

Revision 14492

inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_best_match_jerry_lu index to facilitate finding names affected by the match-picking bug (#943)

View differences:

vegbien.my.sql
16724 16724

  
16725 16725

  
16726 16726
--
16727
-- Name: taxon_scrub_best_match_jerry_lu; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: 
16728
--
16729

  
16730
CREATE INDEX taxon_scrub_best_match_jerry_lu ON taxon_match  (`*Name_submitted`, `*Name_score` DESC, `*Overall_score` DESC);
16731

  
16732

  
16733
--
16727 16734
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: 
16728 16735
--
16729 16736

  

Also available in: Unified diff