Revision 10740
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 24 | 24 |
time_submitted timestamp with time zone DEFAULT now(), |
| 25 | 25 |
client_version text, |
| 26 | 26 |
CONSTRAINT batch_pkey PRIMARY KEY (id ), |
| 27 |
CONSTRAINT download_settings_id_by_time_key UNIQUE (id_by_time ), |
|
| 27 |
CONSTRAINT batch_download_settings_id_by_time_key UNIQUE (id_by_time ),
|
|
| 28 | 28 |
CONSTRAINT batch_client_version_fkey FOREIGN KEY (client_version) |
| 29 | 29 |
REFERENCES client_version (id) MATCH SIMPLE |
| 30 | 30 |
ON UPDATE CASCADE ON DELETE CASCADE |
| ... | ... | |
| 54 | 54 |
|
| 55 | 55 |
-- |
| 56 | 56 |
|
| 57 |
CREATE TABLE download_settings |
|
| 57 |
CREATE TABLE batch_download_settings
|
|
| 58 | 58 |
( |
| 59 | 59 |
id text NOT NULL, |
| 60 | 60 |
"E-mail" text, |
| ... | ... | |
| 70 | 70 |
"Allow partial matches?" boolean, |
| 71 | 71 |
"Sort by source" boolean, |
| 72 | 72 |
"Constrain by higher taxonomy" boolean, |
| 73 |
CONSTRAINT download_settings_pkey PRIMARY KEY (id ), |
|
| 74 |
CONSTRAINT download_settings_id_fkey FOREIGN KEY (id) |
|
| 73 |
CONSTRAINT batch_download_settings_pkey PRIMARY KEY (id ),
|
|
| 74 |
CONSTRAINT batch_download_settings_id_fkey FOREIGN KEY (id)
|
|
| 75 | 75 |
REFERENCES "TNRS".batch (id) MATCH SIMPLE |
| 76 | 76 |
ON UPDATE CASCADE ON DELETE CASCADE |
| 77 | 77 |
) |
| 78 | 78 |
WITH ( |
| 79 | 79 |
OIDS=FALSE |
| 80 | 80 |
); |
| 81 |
COMMENT ON TABLE download_settings |
|
| 81 |
COMMENT ON TABLE batch_download_settings
|
|
| 82 | 82 |
IS 'stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > Download settings > settings.txt'; |
| 83 | 83 |
|
| 84 | 84 |
-- |
Also available in: Unified diff
inputs/.TNRS/schema.sql: download_settings: renamed to batch_download_settings because this table is actually specific to the batch, and it does not make sense to have a download settings file without a batch