Project

General

Profile

« Previous | Next » 

Revision 7060

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: sync_analytical_*_to_view(): Added datasource fkey to source.shortname so removing a datasource will also remove the corresponding rows in the analytical views

View differences:

vegbien.sql
929 929 
GRANT SELECT ON TABLE analytical_aggregate TO bien_read;
930 930 
GRANT SELECT ON TABLE analytical_aggregate_view TO bien_read;
931 931 

  		




  
  932
  
    
ALTER TABLE analytical_aggregate ADD FOREIGN KEY (datasource) REFERENCES source (shortname) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  933
  
    

  		




  932
  934
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "datasource" SET NOT NULL;


  		




  933
  935
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "locationID" SET NOT NULL;


  		




  934
  936
  
    

  		




  ......




  949
  951
  
    
GRANT SELECT ON TABLE analytical_stem TO bien_read;


  		




  950
  952
  
    
GRANT SELECT ON TABLE analytical_stem_view TO bien_read;


  		




  951
  953
  
    

  		




  
  954
  
    
ALTER TABLE analytical_stem ADD FOREIGN KEY (datasource) REFERENCES source (shortname) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  955
  
    

  		




  952
  956
  
    
ALTER TABLE analytical_stem ALTER COLUMN "datasource" SET NOT NULL;


  		




  953
  957
  
    
ALTER TABLE analytical_stem ALTER COLUMN "locationID" SET NOT NULL;


  		




  954
  958
  
    

  		




  ......




  7439
  7443
  
    

  		




  7440
  7444
  
    

  		




  7441
  7445
  
    
--


  		




  
  7446
  
    
-- Name: analytical_aggregate_datasource_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  
  7447
  
    
--


  		




  
  7448
  
    

  		




  
  7449
  
    
ALTER TABLE ONLY analytical_aggregate


  		




  
  7450
  
    
    ADD CONSTRAINT analytical_aggregate_datasource_fkey FOREIGN KEY (datasource) REFERENCES source(shortname) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  7451
  
    

  		




  
  7452
  
    

  		




  
  7453
  
    
--


  		




  
  7454
  
    
-- Name: analytical_stem_datasource_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  
  7455
  
    
--


  		




  
  7456
  
    

  		




  
  7457
  
    
ALTER TABLE ONLY analytical_stem


  		




  
  7458
  
    
    ADD CONSTRAINT analytical_stem_datasource_fkey FOREIGN KEY (datasource) REFERENCES source(shortname) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  7459
  
    

  		




  
  7460
  
    

  		




  
  7461
  
    
--


  		




  7442
  7462
  
    
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  7443
  7463
  
    
--


  		




  7444
  7464
  
    

  		












Also available in:  Unified diff