Project

General

Profile

« Previous | Next » 

Revision 10725

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

View differences:

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