Project

General

Profile

« Previous | Next » 

Revision 5820

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/.NCBI/nodes/create.sql: Added foreign key on parent tax_id with covering index

View differences:

inputs/.NCBI/nodes/create.sql
10 10 
USING "parent tax_id"::integer;
11 11 

  		




  12
  12
  
    
ALTER TABLE :table ADD PRIMARY KEY (tax_id);


  		




  
  13
  
    

  		




  
  14
  
    
CREATE INDEX ON :table ("parent tax_id");


  		




  
  15
  
    

  		




  
  16
  
    
ALTER TABLE :table ADD FOREIGN KEY ("parent tax_id") REFERENCES :table (tax_id)


  		




  
  17
  
    
    ON UPDATE CASCADE ON DELETE CASCADE;


  		












Also available in:  Unified diff