Project

General

Profile

« Previous | Next » 

Revision 6511

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: sync_analytical_*_to_view(): Added NOT NULL constraints

View differences:

schemas/vegbien.sql
908 908 
DROP TABLE IF EXISTS analytical_aggregate;
909 909 
CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view;
910 910 

  		




  
  911
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "institutionCode" SET NOT NULL;


  		




  
  912
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "plotName" SET NOT NULL;


  		




  
  913
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "dateCollected" SET NOT NULL;


  		




  
  914
  
    

  		




  911
  915
  
    
CREATE INDEX ON analytical_aggregate ("institutionCode", "plotName", "dateCollected" );


  		




  912
  916
  
    
$$;


  		




  913
  917
  
    

  		




  ......




  922
  926
  
    
DROP TABLE IF EXISTS analytical_stem;


  		




  923
  927
  
    
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view;


  		




  924
  928
  
    

  		




  
  929
  
    
ALTER TABLE analytical_stem ALTER COLUMN "institutionCode" SET NOT NULL;


  		




  
  930
  
    
ALTER TABLE analytical_stem ALTER COLUMN "plotName" SET NOT NULL;


  		




  
  931
  
    
ALTER TABLE analytical_stem ALTER COLUMN "dateCollected" SET NOT NULL;


  		




  
  932
  
    

  		




  925
  933
  
    
CREATE INDEX ON analytical_stem ("institutionCode", "plotName", "dateCollected" );


  		




  926
  934
  
    
$$;


  		




  927
  935
  
    

  		












Also available in:  Unified diff