Project

General

Profile

« Previous | Next » 

Revision 14086

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: analytical_stem_view_modify(): added columns: need to include COMMENT statements

View differences:

trunk/schemas/public_.sql
1992 1992 
DROP TABLE IF EXISTS analytical_stem;
1993 1993 
SELECT util.copy('analytical_stem_view', 'analytical_stem');
1994 1994 
ALTER TABLE analytical_stem ADD COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" serial PRIMARY KEY;
1995 
COMMENT ON COLUMN analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';
1995 1996 

  		




  1996
  1997
  
    
GRANT SELECT ON TABLE analytical_stem TO bien_read;


  		




  1997
  1998
  
    
GRANT SELECT ON TABLE analytical_stem_view TO bien_read;


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  1992
  1992
  
    
DROP TABLE IF EXISTS analytical_stem;


  		




  1993
  1993
  
    
SELECT util.copy('analytical_stem_view', 'analytical_stem');


  		




  1994
  1994
  
    
ALTER TABLE analytical_stem ADD COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" serial PRIMARY KEY;


  		




  
  1995
  
    
COMMENT ON COLUMN analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';


  		




  1995
  1996
  
    

  		




  1996
  1997
  
    
GRANT SELECT ON TABLE analytical_stem TO bien_read;


  		




  1997
  1998
  
    
GRANT SELECT ON TABLE analytical_stem_view TO bien_read;


  		












Also available in:  Unified diff