Revision 10726
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1 |
CREATE TABLE "Download settings"
|
|
| 1 |
CREATE TABLE download_settings
|
|
| 2 | 2 |
( |
| 3 | 3 |
"Time_submitted" timestamp with time zone NOT NULL, |
| 4 | 4 |
"E-mail" text, |
| ... | ... | |
| 14 | 14 |
"Allow partial matches?" boolean, |
| 15 | 15 |
"Sort by source" boolean, |
| 16 | 16 |
"Constrain by higher taxonomy" boolean, |
| 17 |
CONSTRAINT "Download settings_pkey" PRIMARY KEY ("Time_submitted" )
|
|
| 17 |
CONSTRAINT download_settings_pkey PRIMARY KEY ("Time_submitted" )
|
|
| 18 | 18 |
) |
| 19 | 19 |
WITH ( |
| 20 | 20 |
OIDS=FALSE |
| 21 | 21 |
); |
| 22 |
COMMENT ON TABLE "Download settings"
|
|
| 23 |
IS 'stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > Download settings > settings.txt';
|
|
| 22 |
COMMENT ON TABLE download_settings
|
|
| 23 |
IS 'stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > download_settings > settings.txt';
|
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 | 26 |
CREATE OR REPLACE FUNCTION score_ok(score double precision) |
Also available in: Unified diff
inputs/.TNRS/schema.sql: Download settings table: renamed to download_settings because although Download settings is the verbatim name of the button that this info comes from, it is not necessary to name the table a particular way in order to match up data to it correctly, so we can just use the standard naming convention (wiki.vegpath.org/u-name#format) and avoid the need to enclose the name in ""