Project

General

Profile

« Previous | Next » 

Revision 7386

Added by ben leinfelder about 12 years ago

use correct column (guid) for temporary index

View differences:

src/upgrade-db-to-2.0.0-postgres.sql
134 134 

  		




  135
  135
  
    
/** create some indexes to speed up the join **/


  		




  136
  136
  
    
CREATE INDEX maxid_docid_index ON max_identifier (docid);


  		




  137
  
  
    
CREATE INDEX maxid_guid_index ON max_identifier (docid);


  		




  
  137
  
    
CREATE INDEX maxid_guid_index ON max_identifier (guid);


  		




  138
  138
  
    
CREATE INDEX accessfileid_index on xml_access (accessfileid);


  		




  139
  139
  
    
CREATE INDEX xml_access_guid_index on xml_access (guid);


  		




  140
  140
  
    

  		












Also available in:  Unified diff