Project

General

Profile

« Previous | Next » 

Revision 13835

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: analytical_stem_view_modify(): updated to new analytical_stem_view column names

View differences:

vegbien.sql
1996 1996 
GRANT SELECT ON TABLE analytical_stem TO bien_read;
1997 1997 
GRANT SELECT ON TABLE analytical_stem_view TO bien_read;
1998 1998 

  		




  1999
  
  
    
ALTER TABLE analytical_stem ALTER COLUMN "datasource" SET NOT NULL;


  		




  2000
  
  
    
ALTER TABLE analytical_stem ALTER COLUMN "locationID" SET NOT NULL;


  		




  
  1999
  
    
ALTER TABLE analytical_stem ALTER COLUMN "datasource__@Brad__.identifier_examples@vegpath.org" SET NOT NULL;


  		




  
  2000
  
    
ALTER TABLE analytical_stem ALTER COLUMN "locationID__@DwC__@vegpath.org" SET NOT NULL;


  		




  2001
  2001
  
    

  		




  2002
  
  
    
CREATE INDEX ON analytical_stem ("datasource", "occurrenceID");


  		




  2003
  
  
    
CREATE INDEX ON analytical_stem ("datasource", "specimenHolderInstitutions", "collection", "accessionNumber");


  		




  2004
  
  
    
CREATE INDEX ON analytical_stem ("datasource", "projectID", "locationID", "eventDate");


  		




  2005
  
  
    
CREATE INDEX ON analytical_stem ("scrubbed_morphospecies_binomial");


  		




  
  2002
  
    
CREATE INDEX ON analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");


  		




  
  2003
  
    
CREATE INDEX ON analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");


  		




  
  2004
  
    
CREATE INDEX ON analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");


  		




  
  2005
  
    
CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");


  		




  2006
  2006
  
    
$$);


  		




  2007
  2007
  
    
$_$;


  		




  2008
  2008
  
    

  		












Also available in:  Unified diff