Revision 10725
Added by Aaron Marcuse-Kubitza over 11 years ago
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