Project

General

Profile

Download (1.88 KB) Statistics
| Revision:

root/schemas/vegbien_empty.sql @ 1772

1 223 aaronmk 
TRUNCATE address CASCADE;
2 476 aaronmk 
TRUNCATE aggregateoccurrence CASCADE;
3 223 aaronmk 
TRUNCATE classcontributor CASCADE;
4 
TRUNCATE commclass CASCADE;
5 
TRUNCATE commconcept CASCADE;
6 
TRUNCATE commcorrelation CASCADE;
7 394 aaronmk 
TRUNCATE commdetermination CASCADE;
8 223 aaronmk 
TRUNCATE commlineage CASCADE;
9 
TRUNCATE commname CASCADE;
10 
TRUNCATE commstatus CASCADE;
11 
TRUNCATE commusage CASCADE;
12 
TRUNCATE coverindex CASCADE;
13 
TRUNCATE covermethod CASCADE;
14 
TRUNCATE definedvalue CASCADE;
15 
TRUNCATE disturbanceobs CASCADE;
16 
TRUNCATE graphic CASCADE;
17 525 aaronmk 
TRUNCATE location CASCADE;
18 906 aaronmk 
TRUNCATE locationdetermination CASCADE;
19 525 aaronmk 
TRUNCATE locationevent CASCADE;
20 
TRUNCATE locationeventcontributor CASCADE;
21 
TRUNCATE locationeventsynonym CASCADE;
22 907 aaronmk 
TRUNCATE method CASCADE;
23 1101 aaronmk 
TRUNCATE methodtaxonclass CASCADE;
24 223 aaronmk 
TRUNCATE namedplace CASCADE;
25 1555 aaronmk 
TRUNCATE namedplace_ancestor CASCADE;
26 223 aaronmk 
TRUNCATE namedplacecorrelation CASCADE;
27 
TRUNCATE note CASCADE;
28 
TRUNCATE notelink CASCADE;
29 
TRUNCATE party CASCADE;
30 
TRUNCATE partymember CASCADE;
31 674 aaronmk 
TRUNCATE plant CASCADE;
32 223 aaronmk 
TRUNCATE plantconcept CASCADE;
33 
TRUNCATE plantcorrelation CASCADE;
34 
TRUNCATE plantlineage CASCADE;
35 
TRUNCATE plantname CASCADE;
36 1555 aaronmk 
TRUNCATE plantname_ancestor CASCADE;
37 1333 aaronmk 
TRUNCATE plantnamescope CASCADE;
38 671 aaronmk 
TRUNCATE plantobservation CASCADE;
39 223 aaronmk 
TRUNCATE plantstatus CASCADE;
40 
TRUNCATE plantusage CASCADE;
41 
TRUNCATE project CASCADE;
42 
TRUNCATE projectcontributor CASCADE;
43 
TRUNCATE reference CASCADE;
44 
TRUNCATE referencealtident CASCADE;
45 
TRUNCATE referencecontributor CASCADE;
46 
TRUNCATE referencejournal CASCADE;
47 
TRUNCATE referenceparty CASCADE;
48 
TRUNCATE revision CASCADE;
49 
TRUNCATE soilobs CASCADE;
50 
TRUNCATE soiltaxon CASCADE;
51 669 aaronmk 
TRUNCATE specimen CASCADE;
52 668 aaronmk 
TRUNCATE specimenreplicate CASCADE;
53 673 aaronmk 
TRUNCATE stemobservation CASCADE;
54 1058 aaronmk 
TRUNCATE stemtag CASCADE;
55 363 aaronmk 
TRUNCATE stratum CASCADE;
56 223 aaronmk 
TRUNCATE taxonalt CASCADE;
57 
TRUNCATE taxondetermination CASCADE;
58 
TRUNCATE taxonoccurrence CASCADE;
59 
TRUNCATE telephone CASCADE;
60 427 aaronmk 
TRUNCATE trait CASCADE;
61 223 aaronmk 
TRUNCATE userdefined CASCADE;
62 544 aaronmk 
TRUNCATE voucher CASCADE;