Revision 12604
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 294 | 294 |
|
| 295 | 295 |
|
| 296 | 296 |
-- |
| 297 |
-- Name: keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_; Type: TYPE; Schema: public_validations; Owner: - |
|
| 298 |
-- |
|
| 299 |
|
|
| 300 |
|
|
| 301 |
|
|
| 302 |
|
|
| 303 |
-- |
|
| 297 | 304 |
-- Name: keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec; Type: TYPE; Schema: public_validations; Owner: - |
| 298 | 305 |
-- |
| 299 | 306 |
|
| ... | ... | |
| 455 | 462 |
|
| 456 | 463 |
|
| 457 | 464 |
-- |
| 465 |
-- Name: values__~type._plots_15_pct_cover_of_each_verb_taxon_in_each_pl; Type: TYPE; Schema: public_validations; Owner: - |
|
| 466 |
-- |
|
| 467 |
|
|
| 468 |
|
|
| 469 |
|
|
| 470 |
|
|
| 471 |
-- |
|
| 458 | 472 |
-- Name: values__~type._plots_17_count_of_subplots_per_plot_for_each_pro; Type: TYPE; Schema: public_validations; Owner: - |
| 459 | 473 |
-- |
| 460 | 474 |
|
| ... | ... | |
| 1378 | 1392 |
|
| 1379 | 1393 |
|
| 1380 | 1394 |
-- |
| 1395 |
-- Name: ~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1396 |
-- |
|
| 1397 |
|
|
| 1398 |
CREATE TABLE `~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea` ( |
|
| 1399 |
project_name varchar(255), |
|
| 1400 |
plot_code varchar(255), |
|
| 1401 |
taxon varchar(255), |
|
| 1402 |
totalpercentcover double precision |
|
| 1403 |
); |
|
| 1404 |
|
|
| 1405 |
|
|
| 1406 |
-- |
|
| 1407 |
-- Name: keys(`~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1408 |
-- |
|
| 1409 |
|
|
| 1410 |
|
|
| 1411 |
|
|
| 1412 |
|
|
| 1413 |
-- |
|
| 1381 | 1414 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1382 | 1415 |
-- |
| 1383 | 1416 |
|
| ... | ... | |
| 1795 | 1828 |
|
| 1796 | 1829 |
|
| 1797 | 1830 |
-- |
| 1831 |
-- Name: values_(`~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1832 |
-- |
|
| 1833 |
|
|
| 1834 |
|
|
| 1835 |
|
|
| 1836 |
|
|
| 1837 |
-- |
|
| 1798 | 1838 |
-- Name: values_(`~type._plots_17_count_of_subplots_per_plot_for_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1799 | 1839 |
-- |
| 1800 | 1840 |
|
| ... | ... | |
| 7570 | 7610 |
|
| 7571 | 7611 |
|
| 7572 | 7612 |
-- |
| 7613 |
-- Data for Name: ~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 7614 |
-- |
|
| 7615 |
|
|
| 7616 |
|
|
| 7617 |
|
|
| 7618 |
-- |
|
| 7573 | 7619 |
-- Data for Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 7574 | 7620 |
-- |
| 7575 | 7621 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 572 | 572 |
|
| 573 | 573 |
|
| 574 | 574 |
-- |
| 575 |
-- Name: keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_; Type: TYPE; Schema: public_validations; Owner: - |
|
| 576 |
-- |
|
| 577 |
|
|
| 578 |
CREATE TYPE "keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_" AS ( |
|
| 579 |
project_name text, |
|
| 580 |
plot_code text, |
|
| 581 |
taxon text, |
|
| 582 |
totalpercentcover double precision |
|
| 583 |
); |
|
| 584 |
|
|
| 585 |
|
|
| 586 |
-- |
|
| 575 | 587 |
-- Name: keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec; Type: TYPE; Schema: public_validations; Owner: - |
| 576 | 588 |
-- |
| 577 | 589 |
|
| ... | ... | |
| 782 | 794 |
|
| 783 | 795 |
|
| 784 | 796 |
-- |
| 797 |
-- Name: values__~type._plots_15_pct_cover_of_each_verb_taxon_in_each_pl; Type: TYPE; Schema: public_validations; Owner: - |
|
| 798 |
-- |
|
| 799 |
|
|
| 800 |
CREATE TYPE "values__~type._plots_15_pct_cover_of_each_verb_taxon_in_each_pl" AS ( |
|
| 801 |
project_name text, |
|
| 802 |
plot_code text, |
|
| 803 |
taxon text, |
|
| 804 |
totalpercentcover double precision |
|
| 805 |
); |
|
| 806 |
|
|
| 807 |
|
|
| 808 |
-- |
|
| 785 | 809 |
-- Name: values__~type._plots_17_count_of_subplots_per_plot_for_each_pro; Type: TYPE; Schema: public_validations; Owner: - |
| 786 | 810 |
-- |
| 787 | 811 |
|
| ... | ... | |
| 2637 | 2661 |
|
| 2638 | 2662 |
|
| 2639 | 2663 |
-- |
| 2664 |
-- Name: ~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2665 |
-- |
|
| 2666 |
|
|
| 2667 |
CREATE TABLE "~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea" ( |
|
| 2668 |
project_name text, |
|
| 2669 |
plot_code text, |
|
| 2670 |
taxon text, |
|
| 2671 |
totalpercentcover double precision |
|
| 2672 |
); |
|
| 2673 |
|
|
| 2674 |
|
|
| 2675 |
-- |
|
| 2676 |
-- Name: keys("~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 2677 |
-- |
|
| 2678 |
|
|
| 2679 |
CREATE FUNCTION keys(value "~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea") RETURNS "keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_" |
|
| 2680 |
LANGUAGE sql IMMUTABLE |
|
| 2681 |
AS $_$ |
|
| 2682 |
SELECT ROW($1.project_name, $1.plot_code, $1.taxon, $1.totalpercentcover)::public_validations."keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_" |
|
| 2683 |
$_$; |
|
| 2684 |
|
|
| 2685 |
|
|
| 2686 |
-- |
|
| 2640 | 2687 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 2641 | 2688 |
-- |
| 2642 | 2689 |
|
| ... | ... | |
| 3441 | 3488 |
|
| 3442 | 3489 |
|
| 3443 | 3490 |
-- |
| 3491 |
-- Name: values_("~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 3492 |
-- |
|
| 3493 |
|
|
| 3494 |
CREATE FUNCTION values_(value "~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea") RETURNS "values__~type._plots_15_pct_cover_of_each_verb_taxon_in_each_pl" |
|
| 3495 |
LANGUAGE sql IMMUTABLE |
|
| 3496 |
AS $_$ |
|
| 3497 |
SELECT ROW($1.project_name, $1.plot_code, $1.taxon, $1.totalpercentcover)::public_validations."values__~type._plots_15_pct_cover_of_each_verb_taxon_in_each_pl" |
|
| 3498 |
$_$; |
|
| 3499 |
|
|
| 3500 |
|
|
| 3501 |
-- |
|
| 3444 | 3502 |
-- Name: values_("~type._plots_17_count_of_subplots_per_plot_for_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3445 | 3503 |
-- |
| 3446 | 3504 |
|
| ... | ... | |
| 10455 | 10513 |
|
| 10456 | 10514 |
|
| 10457 | 10515 |
-- |
| 10516 |
-- Data for Name: ~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 10517 |
-- |
|
| 10518 |
|
|
| 10519 |
|
|
| 10520 |
|
|
| 10521 |
-- |
|
| 10458 | 10522 |
-- Data for Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 10459 | 10523 |
-- |
| 10460 | 10524 |
|
Also available in: Unified diff
schemas/vegbien.sql: _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro: added ~type table