Revision 12421
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 868 | 868 |
|
| 869 | 869 |
|
| 870 | 870 |
-- |
| 871 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 872 |
-- |
|
| 873 |
|
|
| 874 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 875 |
trait varchar(255), |
|
| 876 |
measurements varchar(255) |
|
| 877 |
); |
|
| 878 |
|
|
| 879 |
|
|
| 880 |
-- |
|
| 881 |
-- Name: =(`~type._traits_04_count_records_per_trait`, `~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 882 |
-- |
|
| 883 |
|
|
| 884 |
|
|
| 885 |
|
|
| 886 |
|
|
| 887 |
-- |
|
| 871 | 888 |
-- Name: query_view_relation_max_prefix_len(); Type: FUNCTION; Schema: public_validations; Owner: - |
| 872 | 889 |
-- |
| 873 | 890 |
|
| ... | ... | |
| 1036 | 1053 |
|
| 1037 | 1054 |
|
| 1038 | 1055 |
-- |
| 1056 |
-- Name: =; Type: OPERATOR; Schema: public_validations; Owner: - |
|
| 1057 |
-- |
|
| 1058 |
|
|
| 1059 |
CREATE OPERATOR = ( |
|
| 1060 |
PROCEDURE = `=`, |
|
| 1061 |
LEFTARG = `~type._traits_04_count_records_per_trait`, |
|
| 1062 |
RIGHTARG = `~type._traits_04_count_records_per_trait` |
|
| 1063 |
); |
|
| 1064 |
|
|
| 1065 |
|
|
| 1066 |
-- |
|
| 1039 | 1067 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1040 | 1068 |
-- |
| 1041 | 1069 |
|
| ... | ... | |
| 3913 | 3941 |
|
| 3914 | 3942 |
|
| 3915 | 3943 |
-- |
| 3916 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3917 |
-- |
|
| 3918 |
|
|
| 3919 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 3920 |
trait varchar(255), |
|
| 3921 |
measurements varchar(255) |
|
| 3922 |
); |
|
| 3923 |
|
|
| 3924 |
|
|
| 3925 |
-- |
|
| 3926 | 3944 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3927 | 3945 |
-- |
| 3928 | 3946 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1951 | 1951 |
SET search_path = public_validations, pg_catalog; |
| 1952 | 1952 |
|
| 1953 | 1953 |
-- |
| 1954 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1955 |
-- |
|
| 1956 |
|
|
| 1957 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 1958 |
trait text, |
|
| 1959 |
measurements bigint |
|
| 1960 |
); |
|
| 1961 |
|
|
| 1962 |
|
|
| 1963 |
-- |
|
| 1964 |
-- Name: =("~type._traits_04_count_records_per_trait", "~type._traits_04_count_records_per_trait"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 1965 |
-- |
|
| 1966 |
|
|
| 1967 |
CREATE FUNCTION "="(left_ "~type._traits_04_count_records_per_trait", right_ "~type._traits_04_count_records_per_trait") RETURNS boolean |
|
| 1968 |
LANGUAGE sql IMMUTABLE |
|
| 1969 |
AS $_$ |
|
| 1970 |
SELECT $1.trait = $2.trait |
|
| 1971 |
$_$; |
|
| 1972 |
|
|
| 1973 |
|
|
| 1974 |
-- |
|
| 1954 | 1975 |
-- Name: query_view_relation_max_prefix_len(); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1955 | 1976 |
-- |
| 1956 | 1977 |
|
| ... | ... | |
| 2380 | 2401 |
|
| 2381 | 2402 |
|
| 2382 | 2403 |
-- |
| 2404 |
-- Name: =; Type: OPERATOR; Schema: public_validations; Owner: - |
|
| 2405 |
-- |
|
| 2406 |
|
|
| 2407 |
CREATE OPERATOR = ( |
|
| 2408 |
PROCEDURE = "=", |
|
| 2409 |
LEFTARG = "~type._traits_04_count_records_per_trait", |
|
| 2410 |
RIGHTARG = "~type._traits_04_count_records_per_trait" |
|
| 2411 |
); |
|
| 2412 |
|
|
| 2413 |
|
|
| 2414 |
-- |
|
| 2383 | 2415 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 2384 | 2416 |
-- |
| 2385 | 2417 |
|
| ... | ... | |
| 6358 | 6390 |
|
| 6359 | 6391 |
|
| 6360 | 6392 |
-- |
| 6361 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6362 |
-- |
|
| 6363 |
|
|
| 6364 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 6365 |
trait text, |
|
| 6366 |
measurements bigint |
|
| 6367 |
); |
|
| 6368 |
|
|
| 6369 |
|
|
| 6370 |
-- |
|
| 6371 | 6393 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 6372 | 6394 |
-- |
| 6373 | 6395 |
|
Also available in: Unified diff
schemas/vegbien.sql: _plots_02_list_of_project_names: added = operator that causes FULL JOIN to only use some columns, so that rows for the same label column are put on the same row in the diff table