Project

General

Profile

« Previous | Next » 

Revision 1555

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Added namedplace_update_ancestors and plantname_update_ancestors triggers to populate ancestor cross-links in new namedplace_ancestor and plantname_ancestor tables

View differences:

vegbien_empty.sql
22 22 
TRUNCATE method CASCADE;
23 23 
TRUNCATE methodtaxonclass CASCADE;
24 24 
TRUNCATE namedplace CASCADE;
25 
TRUNCATE namedplace_ancestor CASCADE;
25 26 
TRUNCATE namedplacecorrelation CASCADE;
26 27 
TRUNCATE note CASCADE;
27 28 
TRUNCATE notelink CASCADE;
......
32 33 
TRUNCATE plantcorrelation CASCADE;
33 34 
TRUNCATE plantlineage CASCADE;
34 35 
TRUNCATE plantname CASCADE;
36 
TRUNCATE plantname_ancestor CASCADE;
35 37 
TRUNCATE plantnamescope CASCADE;
36 38 
TRUNCATE plantobservation CASCADE;
37 39 
TRUNCATE plantstatus CASCADE;

Also available in: Unified diff