Revision 14436
Added by Aaron Marcuse-Kubitza almost 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 15963 | 15963 |
|
| 15964 | 15964 |
|
| 15965 | 15965 |
-- |
| 15966 |
-- Name: batch; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 15967 |
-- |
|
| 15968 |
|
|
| 15969 |
CREATE TABLE batch ( |
|
| 15970 |
id varchar(255) NOT NULL, |
|
| 15971 |
id_by_time varchar(255), |
|
| 15972 |
time_submitted timestamp NULL , |
|
| 15973 |
client_version varchar(255) |
|
| 15974 |
); |
|
| 15975 |
|
|
| 15976 |
|
|
| 15977 |
-- |
|
| 15978 |
-- Name: batch_download_settings; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 15979 |
-- |
|
| 15980 |
|
|
| 15981 |
CREATE TABLE batch_download_settings ( |
|
| 15982 |
id varchar(255) NOT NULL, |
|
| 15983 |
`E-mail` varchar(255), |
|
| 15984 |
`Id` varchar(255), |
|
| 15985 |
`Job type` varchar(255), |
|
| 15986 |
`Contains Id` int(1), |
|
| 15987 |
`Start time` varchar(255), |
|
| 15988 |
`Finish time` varchar(255), |
|
| 15989 |
`TNRS version` varchar(255), |
|
| 15990 |
`Sources selected` varchar(255), |
|
| 15991 |
`Match threshold` double, |
|
| 15992 |
`Classification` varchar(255), |
|
| 15993 |
`Allow partial matches?` int(1), |
|
| 15994 |
`Sort by source` int(1), |
|
| 15995 |
`Constrain by higher taxonomy` int(1) |
|
| 15996 |
); |
|
| 15997 |
|
|
| 15998 |
|
|
| 15999 |
-- |
|
| 16000 |
-- Name: TABLE batch_download_settings; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16001 |
-- |
|
| 16002 |
|
|
| 16003 |
|
|
| 16004 |
|
|
| 16005 |
|
|
| 16006 |
-- |
|
| 16007 |
-- Name: client_version; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 16008 |
-- |
|
| 16009 |
|
|
| 16010 |
CREATE TABLE client_version ( |
|
| 16011 |
id varchar(255) NOT NULL, |
|
| 16012 |
global_rev int(11) NOT NULL, |
|
| 16013 |
`/lib/tnrs.py rev` int(11), |
|
| 16014 |
`/bin/tnrs_db rev` int(11) |
|
| 16015 |
); |
|
| 16016 |
|
|
| 16017 |
|
|
| 16018 |
-- |
|
| 16019 |
-- Name: TABLE client_version; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16020 |
-- |
|
| 16021 |
|
|
| 16022 |
|
|
| 16023 |
|
|
| 16024 |
|
|
| 16025 |
-- |
|
| 16026 |
-- Name: COLUMN client_version.global_rev; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16027 |
-- |
|
| 16028 |
|
|
| 16029 |
|
|
| 16030 |
|
|
| 16031 |
|
|
| 16032 |
-- |
|
| 16033 |
-- Name: COLUMN client_version.`/lib/tnrs.py rev`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16034 |
-- |
|
| 16035 |
|
|
| 16036 |
|
|
| 16037 |
|
|
| 16038 |
|
|
| 16039 |
-- |
|
| 16040 |
-- Name: COLUMN client_version.`/bin/tnrs_db rev`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16041 |
-- |
|
| 16042 |
|
|
| 16043 |
|
|
| 16044 |
|
|
| 16045 |
|
|
| 16046 |
-- |
|
| 15966 | 16047 |
-- Name: taxon_match; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
| 15967 | 16048 |
-- |
| 15968 | 16049 |
|
| ... | ... | |
| 16302 | 16383 |
|
| 16303 | 16384 |
|
| 16304 | 16385 |
-- |
| 16305 |
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: - |
|
| 16306 |
-- |
|
| 16307 |
|
|
| 16308 |
|
|
| 16309 |
|
|
| 16310 |
|
|
| 16311 |
-- |
|
| 16312 |
-- Name: VIEW `ValidMatchedTaxon`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16313 |
-- |
|
| 16314 |
|
|
| 16315 |
|
|
| 16316 |
|
|
| 16317 |
|
|
| 16318 |
-- |
|
| 16319 |
-- Name: batch; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 16320 |
-- |
|
| 16321 |
|
|
| 16322 |
CREATE TABLE batch ( |
|
| 16323 |
id varchar(255) NOT NULL, |
|
| 16324 |
id_by_time varchar(255), |
|
| 16325 |
time_submitted timestamp NULL , |
|
| 16326 |
client_version varchar(255) |
|
| 16327 |
); |
|
| 16328 |
|
|
| 16329 |
|
|
| 16330 |
-- |
|
| 16331 |
-- Name: batch_download_settings; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 16332 |
-- |
|
| 16333 |
|
|
| 16334 |
CREATE TABLE batch_download_settings ( |
|
| 16335 |
id varchar(255) NOT NULL, |
|
| 16336 |
`E-mail` varchar(255), |
|
| 16337 |
`Id` varchar(255), |
|
| 16338 |
`Job type` varchar(255), |
|
| 16339 |
`Contains Id` int(1), |
|
| 16340 |
`Start time` varchar(255), |
|
| 16341 |
`Finish time` varchar(255), |
|
| 16342 |
`TNRS version` varchar(255), |
|
| 16343 |
`Sources selected` varchar(255), |
|
| 16344 |
`Match threshold` double, |
|
| 16345 |
`Classification` varchar(255), |
|
| 16346 |
`Allow partial matches?` int(1), |
|
| 16347 |
`Sort by source` int(1), |
|
| 16348 |
`Constrain by higher taxonomy` int(1) |
|
| 16349 |
); |
|
| 16350 |
|
|
| 16351 |
|
|
| 16352 |
-- |
|
| 16353 |
-- Name: TABLE batch_download_settings; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16354 |
-- |
|
| 16355 |
|
|
| 16356 |
|
|
| 16357 |
|
|
| 16358 |
|
|
| 16359 |
-- |
|
| 16360 |
-- Name: client_version; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
|
| 16361 |
-- |
|
| 16362 |
|
|
| 16363 |
CREATE TABLE client_version ( |
|
| 16364 |
id varchar(255) NOT NULL, |
|
| 16365 |
global_rev int(11) NOT NULL, |
|
| 16366 |
`/lib/tnrs.py rev` int(11), |
|
| 16367 |
`/bin/tnrs_db rev` int(11) |
|
| 16368 |
); |
|
| 16369 |
|
|
| 16370 |
|
|
| 16371 |
-- |
|
| 16372 |
-- Name: TABLE client_version; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16373 |
-- |
|
| 16374 |
|
|
| 16375 |
|
|
| 16376 |
|
|
| 16377 |
|
|
| 16378 |
-- |
|
| 16379 |
-- Name: COLUMN client_version.global_rev; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16380 |
-- |
|
| 16381 |
|
|
| 16382 |
|
|
| 16383 |
|
|
| 16384 |
|
|
| 16385 |
-- |
|
| 16386 |
-- Name: COLUMN client_version.`/lib/tnrs.py rev`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16387 |
-- |
|
| 16388 |
|
|
| 16389 |
|
|
| 16390 |
|
|
| 16391 |
|
|
| 16392 |
-- |
|
| 16393 |
-- Name: COLUMN client_version.`/bin/tnrs_db rev`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 16394 |
-- |
|
| 16395 |
|
|
| 16396 |
|
|
| 16397 |
|
|
| 16398 |
|
|
| 16399 |
-- |
|
| 16400 | 16386 |
-- Name: taxon_match_input; Type: VIEW; Schema: TNRS; Owner: - |
| 16401 | 16387 |
-- |
| 16402 | 16388 |
|
| ... | ... | |
| 16703 | 16689 |
|
| 16704 | 16690 |
|
| 16705 | 16691 |
-- |
| 16706 |
-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: - |
|
| 16707 |
-- |
|
| 16708 |
|
|
| 16709 |
|
|
| 16710 |
|
|
| 16711 |
|
|
| 16712 |
|
|
| 16713 |
|
|
| 16714 |
|
|
| 16715 |
-- |
|
| 16716 | 16692 |
-- Name: taxon_match_input; Type: ACL; Schema: TNRS; Owner: - |
| 16717 | 16693 |
-- |
| 16718 | 16694 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: removed no longer used view ValidMatchedTaxon. use taxon_scrub instead.