Revision 12551
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 875 | 875 |
|
| 876 | 876 |
|
| 877 | 877 |
-- |
| 878 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 879 |
-- |
|
| 880 |
|
|
| 881 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 882 |
project_name varchar(255), |
|
| 883 |
plots varchar(255) |
|
| 884 |
); |
|
| 885 |
|
|
| 886 |
|
|
| 887 |
-- |
|
| 888 |
-- Name: keys(`~type._plots_04_count_of_plots_in_each_project_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 889 |
-- |
|
| 890 |
|
|
| 891 |
|
|
| 892 |
|
|
| 893 |
|
|
| 894 |
-- |
|
| 895 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 896 |
-- |
|
| 897 |
|
|
| 898 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 899 |
trait varchar(255), |
|
| 900 |
measurements varchar(255) |
|
| 901 |
); |
|
| 902 |
|
|
| 903 |
|
|
| 904 |
-- |
|
| 905 |
-- Name: keys(`~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 906 |
-- |
|
| 907 |
|
|
| 908 |
|
|
| 909 |
|
|
| 910 |
|
|
| 911 |
-- |
|
| 878 | 912 |
-- Name: query_view_relation_max_prefix_len(); Type: FUNCTION; Schema: public_validations; Owner: - |
| 879 | 913 |
-- |
| 880 | 914 |
|
| ... | ... | |
| 1084 | 1118 |
|
| 1085 | 1119 |
|
| 1086 | 1120 |
-- |
| 1087 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1088 |
-- |
|
| 1089 |
|
|
| 1090 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 1091 |
project_name varchar(255), |
|
| 1092 |
plots varchar(255) |
|
| 1093 |
); |
|
| 1094 |
|
|
| 1095 |
|
|
| 1096 |
-- |
|
| 1097 | 1121 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1098 | 1122 |
-- |
| 1099 | 1123 |
|
| ... | ... | |
| 4021 | 4045 |
|
| 4022 | 4046 |
|
| 4023 | 4047 |
-- |
| 4024 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4025 |
-- |
|
| 4026 |
|
|
| 4027 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 4028 |
trait varchar(255), |
|
| 4029 |
measurements varchar(255) |
|
| 4030 |
); |
|
| 4031 |
|
|
| 4032 |
|
|
| 4033 |
-- |
|
| 4034 | 4048 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 4035 | 4049 |
-- |
| 4036 | 4050 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1971 | 1971 |
SET search_path = public_validations, pg_catalog; |
| 1972 | 1972 |
|
| 1973 | 1973 |
-- |
| 1974 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1975 |
-- |
|
| 1976 |
|
|
| 1977 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 1978 |
project_name text, |
|
| 1979 |
plots bigint |
|
| 1980 |
); |
|
| 1981 |
|
|
| 1982 |
|
|
| 1983 |
-- |
|
| 1984 |
-- Name: keys("~type._plots_04_count_of_plots_in_each_project_in_this_source"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 1985 |
-- |
|
| 1986 |
|
|
| 1987 |
CREATE FUNCTION keys(value "~type._plots_04_count_of_plots_in_each_project_in_this_source") RETURNS record |
|
| 1988 |
LANGUAGE sql IMMUTABLE |
|
| 1989 |
AS $_$ |
|
| 1990 |
SELECT $1.project_name |
|
| 1991 |
$_$; |
|
| 1992 |
|
|
| 1993 |
|
|
| 1994 |
-- |
|
| 1995 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1996 |
-- |
|
| 1997 |
|
|
| 1998 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 1999 |
trait text, |
|
| 2000 |
measurements bigint |
|
| 2001 |
); |
|
| 2002 |
|
|
| 2003 |
|
|
| 2004 |
-- |
|
| 2005 |
-- Name: keys("~type._traits_04_count_records_per_trait"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 2006 |
-- |
|
| 2007 |
|
|
| 2008 |
CREATE FUNCTION keys(value "~type._traits_04_count_records_per_trait") RETURNS record |
|
| 2009 |
LANGUAGE sql IMMUTABLE |
|
| 2010 |
AS $_$ |
|
| 2011 |
SELECT $1.trait |
|
| 2012 |
$_$; |
|
| 2013 |
|
|
| 2014 |
|
|
| 2015 |
-- |
|
| 1974 | 2016 |
-- Name: query_view_relation_max_prefix_len(); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1975 | 2017 |
-- |
| 1976 | 2018 |
|
| ... | ... | |
| 2483 | 2525 |
|
| 2484 | 2526 |
|
| 2485 | 2527 |
-- |
| 2486 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2487 |
-- |
|
| 2488 |
|
|
| 2489 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 2490 |
project_name text, |
|
| 2491 |
plots bigint |
|
| 2492 |
); |
|
| 2493 |
|
|
| 2494 |
|
|
| 2495 |
-- |
|
| 2496 | 2528 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 2497 | 2529 |
-- |
| 2498 | 2530 |
|
| ... | ... | |
| 6524 | 6556 |
|
| 6525 | 6557 |
|
| 6526 | 6558 |
-- |
| 6527 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6528 |
-- |
|
| 6529 |
|
|
| 6530 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 6531 |
trait text, |
|
| 6532 |
measurements bigint |
|
| 6533 |
); |
|
| 6534 |
|
|
| 6535 |
|
|
| 6536 |
-- |
|
| 6537 | 6559 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 6538 | 6560 |
-- |
| 6539 | 6561 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: added back keys() matchup functions, which get cascadingly deleted when the queries are re-created to change column names, etc. note that this causes the associated ~type tables to sort before them.