Revision 10725
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1 |
CREATE TABLE "Download settings" |
|
| 2 |
( |
|
| 3 |
"Time_submitted" timestamp with time zone NOT NULL, |
|
| 4 |
"E-mail" text, |
|
| 5 |
"Id" text, |
|
| 6 |
"Job type" text, |
|
| 7 |
"Contains Id" boolean, |
|
| 8 |
"Start time" text, |
|
| 9 |
"Finish time" text, |
|
| 10 |
"TNRS version" text, |
|
| 11 |
"Sources selected" text, |
|
| 12 |
"Match threshold" double precision, |
|
| 13 |
"Classification" text, |
|
| 14 |
"Allow partial matches?" boolean, |
|
| 15 |
"Sort by source" boolean, |
|
| 16 |
"Constrain by higher taxonomy" boolean, |
|
| 17 |
CONSTRAINT "Download settings_pkey" PRIMARY KEY ("Time_submitted" )
|
|
| 18 |
) |
|
| 19 |
WITH ( |
|
| 20 |
OIDS=FALSE |
|
| 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'; |
|
| 24 |
|
|
| 25 |
|
|
| 1 | 26 |
CREATE OR REPLACE FUNCTION score_ok(score double precision) |
| 2 | 27 |
RETURNS boolean AS |
| 3 | 28 |
$BODY$ |
Also available in: Unified diff
inputs/.TNRS/schema.sql: added Download settings table, which stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > Download settings > settings.txt