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.sql
22277 22277

  
22278 22278

  
22279 22279
--
22280
-- Name: taxon_scrub_best_match_jerry_lu; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: 
22281
--
22282

  
22283
CREATE INDEX taxon_scrub_best_match_jerry_lu ON taxon_match USING btree ("*Name_submitted", "*Name_score" DESC, "*Overall_score" DESC);
22284

  
22285

  
22286
--
22280 22287
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: 
22281 22288
--
22282 22289

  

Also available in: Unified diff