Revision 12399
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 2349 | 2349 |
$_$; |
| 2350 | 2350 |
|
| 2351 | 2351 |
|
| 2352 |
-- |
|
| 2353 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2354 |
-- |
|
| 2355 |
|
|
| 2356 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 2357 |
"totalRecords" bigint |
|
| 2358 |
); |
|
| 2359 |
|
|
| 2360 |
|
|
| 2361 |
-- |
|
| 2362 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2363 |
-- |
|
| 2364 |
|
|
| 2365 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 2366 |
traits bigint |
|
| 2367 |
); |
|
| 2368 |
|
|
| 2369 |
|
|
| 2370 |
-- |
|
| 2371 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2372 |
-- |
|
| 2373 |
|
|
| 2374 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 2375 |
trait text |
|
| 2376 |
); |
|
| 2377 |
|
|
| 2378 |
|
|
| 2379 |
-- |
|
| 2380 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2381 |
-- |
|
| 2382 |
|
|
| 2383 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 2384 |
trait text, |
|
| 2385 |
measurements bigint |
|
| 2386 |
); |
|
| 2387 |
|
|
| 2388 |
|
|
| 2389 |
-- |
|
| 2390 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2391 |
-- |
|
| 2392 |
|
|
| 2393 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 2394 |
taxa bigint |
|
| 2395 |
); |
|
| 2396 |
|
|
| 2397 |
|
|
| 2398 |
-- |
|
| 2399 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2400 |
-- |
|
| 2401 |
|
|
| 2402 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 2403 |
taxonwithauthor text |
|
| 2404 |
); |
|
| 2405 |
|
|
| 2406 |
|
|
| 2407 |
-- |
|
| 2408 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2409 |
-- |
|
| 2410 |
|
|
| 2411 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 2412 |
trait text, |
|
| 2413 |
value text, |
|
| 2414 |
units text |
|
| 2415 |
); |
|
| 2416 |
|
|
| 2417 |
|
|
| 2418 |
-- |
|
| 2419 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2420 |
-- |
|
| 2421 |
|
|
| 2422 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 2423 |
taxonwithauthor text, |
|
| 2424 |
trait text, |
|
| 2425 |
value text |
|
| 2426 |
); |
|
| 2427 |
|
|
| 2428 |
|
|
| 2429 | 2352 |
SET search_path = public, pg_catalog; |
| 2430 | 2353 |
|
| 2431 | 2354 |
-- |
| ... | ... | |
| 6340 | 6263 |
ORDER BY taxonverbatim.taxonname; |
| 6341 | 6264 |
|
| 6342 | 6265 |
|
| 6266 |
-- |
|
| 6267 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6268 |
-- |
|
| 6269 |
|
|
| 6270 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 6271 |
"totalRecords" bigint |
|
| 6272 |
); |
|
| 6273 |
|
|
| 6274 |
|
|
| 6275 |
-- |
|
| 6276 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6277 |
-- |
|
| 6278 |
|
|
| 6279 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 6280 |
traits bigint |
|
| 6281 |
); |
|
| 6282 |
|
|
| 6283 |
|
|
| 6284 |
-- |
|
| 6285 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6286 |
-- |
|
| 6287 |
|
|
| 6288 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 6289 |
trait text |
|
| 6290 |
); |
|
| 6291 |
|
|
| 6292 |
|
|
| 6293 |
-- |
|
| 6294 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6295 |
-- |
|
| 6296 |
|
|
| 6297 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 6298 |
trait text, |
|
| 6299 |
measurements bigint |
|
| 6300 |
); |
|
| 6301 |
|
|
| 6302 |
|
|
| 6303 |
-- |
|
| 6304 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6305 |
-- |
|
| 6306 |
|
|
| 6307 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 6308 |
taxa bigint |
|
| 6309 |
); |
|
| 6310 |
|
|
| 6311 |
|
|
| 6312 |
-- |
|
| 6313 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6314 |
-- |
|
| 6315 |
|
|
| 6316 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 6317 |
taxonwithauthor text |
|
| 6318 |
); |
|
| 6319 |
|
|
| 6320 |
|
|
| 6321 |
-- |
|
| 6322 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6323 |
-- |
|
| 6324 |
|
|
| 6325 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 6326 |
trait text, |
|
| 6327 |
value text, |
|
| 6328 |
units text |
|
| 6329 |
); |
|
| 6330 |
|
|
| 6331 |
|
|
| 6332 |
-- |
|
| 6333 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6334 |
-- |
|
| 6335 |
|
|
| 6336 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 6337 |
taxonwithauthor text, |
|
| 6338 |
trait text, |
|
| 6339 |
value text |
|
| 6340 |
); |
|
| 6341 |
|
|
| 6342 |
|
|
| 6343 | 6343 |
SET search_path = public, pg_catalog; |
| 6344 | 6344 |
|
| 6345 | 6345 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: synced to DB, which changes the sort order (due to system update?)