Project

General

Profile

Download (2.83 KB) Statistics
| Revision:

root/schemas/vegbien_empty.sql @ 979

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 dba_confidentialitystatus CASCADE;
15 
TRUNCATE dba_cookie CASCADE;
16 
TRUNCATE dba_cookielabels CASCADE;
17 
TRUNCATE dba_datacache CASCADE;
18 
TRUNCATE dba_datamodelversion CASCADE;
19 
TRUNCATE dba_dbstatstime CASCADE;
20 
TRUNCATE dba_fielddescription CASCADE;
21 
TRUNCATE dba_fieldlist CASCADE;
22 
TRUNCATE dba_onerow CASCADE;
23 
TRUNCATE dba_preassignacccode CASCADE;
24 
TRUNCATE dba_tabledescription CASCADE;
25 
TRUNCATE dba_xmlcache CASCADE;
26 
TRUNCATE definedvalue CASCADE;
27 
TRUNCATE disturbanceobs CASCADE;
28 
TRUNCATE embargo CASCADE;
29 
TRUNCATE graphic CASCADE;
30 
TRUNCATE keywords CASCADE;
31 
TRUNCATE keywords_extra CASCADE;
32 525 aaronmk 
TRUNCATE location CASCADE;
33 906 aaronmk 
TRUNCATE locationdetermination CASCADE;
34 525 aaronmk 
TRUNCATE locationevent CASCADE;
35 
TRUNCATE locationeventcontributor CASCADE;
36 
TRUNCATE locationeventsynonym CASCADE;
37 907 aaronmk 
TRUNCATE method CASCADE;
38 955 aaronmk 
TRUNCATE methodtrait CASCADE;
39 
TRUNCATE methodtraitname CASCADE;
40 223 aaronmk 
TRUNCATE namedplace CASCADE;
41 
TRUNCATE namedplacecorrelation CASCADE;
42 
TRUNCATE note CASCADE;
43 
TRUNCATE notelink CASCADE;
44 
TRUNCATE party CASCADE;
45 
TRUNCATE partymember CASCADE;
46 674 aaronmk 
TRUNCATE plant CASCADE;
47 223 aaronmk 
TRUNCATE plantconcept CASCADE;
48 903 aaronmk 
TRUNCATE plantconceptscope CASCADE;
49 223 aaronmk 
TRUNCATE plantcorrelation CASCADE;
50 
TRUNCATE plantlineage CASCADE;
51 
TRUNCATE plantname CASCADE;
52 671 aaronmk 
TRUNCATE plantobservation CASCADE;
53 223 aaronmk 
TRUNCATE plantstatus CASCADE;
54 674 aaronmk 
TRUNCATE planttag CASCADE;
55 223 aaronmk 
TRUNCATE plantusage CASCADE;
56 
TRUNCATE project CASCADE;
57 
TRUNCATE projectcontributor CASCADE;
58 
TRUNCATE reference CASCADE;
59 
TRUNCATE referencealtident CASCADE;
60 
TRUNCATE referencecontributor CASCADE;
61 
TRUNCATE referencejournal CASCADE;
62 
TRUNCATE referenceparty CASCADE;
63 
TRUNCATE revision CASCADE;
64 596 aaronmk 
TRUNCATE role CASCADE;
65 478 aaronmk 
TRUNCATE sizeclass CASCADE;
66 223 aaronmk 
TRUNCATE soilobs CASCADE;
67 
TRUNCATE soiltaxon CASCADE;
68 669 aaronmk 
TRUNCATE specimen CASCADE;
69 668 aaronmk 
TRUNCATE specimenreplicate CASCADE;
70 673 aaronmk 
TRUNCATE stemobservation CASCADE;
71 363 aaronmk 
TRUNCATE stratum CASCADE;
72 223 aaronmk 
TRUNCATE stratummethod CASCADE;
73 
TRUNCATE stratumtype CASCADE;
74 
TRUNCATE taxonalt CASCADE;
75 
TRUNCATE taxondetermination CASCADE;
76 
TRUNCATE taxonoccurrence CASCADE;
77 
TRUNCATE telephone CASCADE;
78 
TRUNCATE temptbl_std_commnames CASCADE;
79 
TRUNCATE temptbl_std_plantnames CASCADE;
80 427 aaronmk 
TRUNCATE trait CASCADE;
81 223 aaronmk 
TRUNCATE usercertification CASCADE;
82 
TRUNCATE userdataset CASCADE;
83 
TRUNCATE userdatasetitem CASCADE;
84 
TRUNCATE userdefined CASCADE;
85 
TRUNCATE usernotify CASCADE;
86 
TRUNCATE userpermission CASCADE;
87 
TRUNCATE userpreference CASCADE;
88 
TRUNCATE userquery CASCADE;
89 
TRUNCATE userrecordowner CASCADE;
90 
TRUNCATE userregionalexp CASCADE;
91 
TRUNCATE usr CASCADE;
92 544 aaronmk 
TRUNCATE voucher CASCADE;