Revision 381
Added by Aaron Marcuse-Kubitza about 13 years ago
vegbien_empty.sql | ||
---|---|---|
1 | 1 |
TRUNCATE address CASCADE; |
2 | 2 |
TRUNCATE aux_role CASCADE; |
3 | 3 |
TRUNCATE classcontributor CASCADE; |
4 |
TRUNCATE collectiveobservation CASCADE; |
|
4 | 5 |
TRUNCATE commclass CASCADE; |
5 | 6 |
TRUNCATE commconcept CASCADE; |
6 | 7 |
TRUNCATE commcorrelation CASCADE; |
... | ... | |
27 | 28 |
TRUNCATE disturbanceobs CASCADE; |
28 | 29 |
TRUNCATE embargo CASCADE; |
29 | 30 |
TRUNCATE graphic CASCADE; |
31 |
TRUNCATE individualplant CASCADE; |
|
30 | 32 |
TRUNCATE keywords CASCADE; |
31 | 33 |
TRUNCATE keywords_extra CASCADE; |
32 | 34 |
TRUNCATE namedplace CASCADE; |
... | ... | |
57 | 59 |
TRUNCATE soilobs CASCADE; |
58 | 60 |
TRUNCATE soiltaxon CASCADE; |
59 | 61 |
TRUNCATE stemcount CASCADE; |
60 |
TRUNCATE individualplant CASCADE; |
|
61 | 62 |
TRUNCATE stratum CASCADE; |
62 | 63 |
TRUNCATE stratummethod CASCADE; |
63 | 64 |
TRUNCATE stratumtype CASCADE; |
64 | 65 |
TRUNCATE taxonalt CASCADE; |
65 |
TRUNCATE collectiveobservation CASCADE;
|
|
66 |
TRUNCATE taxonbin CASCADE;
|
|
66 | 67 |
TRUNCATE taxondetermination CASCADE; |
67 | 68 |
TRUNCATE taxonoccurrence CASCADE; |
68 | 69 |
TRUNCATE telephone CASCADE; |
... | ... | |
79 | 80 |
TRUNCATE userrecordowner CASCADE; |
80 | 81 |
TRUNCATE userregionalexp CASCADE; |
81 | 82 |
TRUNCATE usr CASCADE; |
82 |
TRUNCATE taxonbin CASCADE; |
Also available in: Unified diff
Regenerate vegbien.sql by dumping the vegbien db