Project

General

Profile

« Previous | Next » 

Revision 1060

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Removed VegBank-internal tables (including user account tables) because they do not belong in the ecological database. Any web interface should store user account information, cached queries, etc. in a separate interface-specific database.

View differences:

vegbien_empty.sql
11 11 
TRUNCATE commusage CASCADE;
12 12 
TRUNCATE coverindex CASCADE;
13 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 14 
TRUNCATE definedvalue CASCADE;
27 15 
TRUNCATE disturbanceobs CASCADE;
28 16 
TRUNCATE embargo CASCADE;
29 17 
TRUNCATE graphic CASCADE;
30 
TRUNCATE keywords CASCADE;
31 
TRUNCATE keywords_extra CASCADE;
32 18 
TRUNCATE location CASCADE;
33 19 
TRUNCATE locationdetermination CASCADE;
34 20 
TRUNCATE locationevent CASCADE;
......
71 57 
TRUNCATE taxondetermination CASCADE;
72 58 
TRUNCATE taxonoccurrence CASCADE;
73 59 
TRUNCATE telephone CASCADE;
74 
TRUNCATE temptbl_std_commnames CASCADE;
75 
TRUNCATE temptbl_std_plantnames CASCADE;
76 60 
TRUNCATE trait CASCADE;
77 
TRUNCATE usercertification CASCADE;
78 
TRUNCATE userdataset CASCADE;
79 
TRUNCATE userdatasetitem CASCADE;
80 61 
TRUNCATE userdefined CASCADE;
81 
TRUNCATE usernotify CASCADE;
82 
TRUNCATE userpermission CASCADE;
83 
TRUNCATE userpreference CASCADE;
84 
TRUNCATE userquery CASCADE;
85 
TRUNCATE userrecordowner CASCADE;
86 
TRUNCATE userregionalexp CASCADE;
87 
TRUNCATE usr CASCADE;
88 62 
TRUNCATE voucher CASCADE;

Also available in: Unified diff