Project

General

Profile

« Previous | Next » 

Revision 13094

schemas/vegbien.sql: _specimens_11_list_of_three_standard_political_divisions: ran through pipeline

View differences:

trunk/schemas/vegbien.my.sql
476 476

  
477 477

  
478 478
--
479
-- Name: keys_~type._specimens_11_list_of_three_standard_political_divis; Type: TYPE; Schema: public_validations; Owner: -
480
--
481

  
482

  
483

  
484

  
485
--
486
-- Name: TYPE `keys_~type._specimens_11_list_of_three_standard_political_divis`; Type: COMMENT; Schema: public_validations; Owner: -
487
--
488

  
489

  
490

  
491

  
492
--
479 493
-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: -
480 494
--
481 495

  
......
882 896

  
883 897

  
884 898
--
899
-- Name: values__~type._specimens_11_list_of_three_standard_political_di; Type: TYPE; Schema: public_validations; Owner: -
900
--
901

  
902

  
903

  
904

  
905
--
906
-- Name: TYPE `values__~type._specimens_11_list_of_three_standard_political_di`; Type: COMMENT; Schema: public_validations; Owner: -
907
--
908

  
909

  
910

  
911

  
912
--
885 913
-- Name: values__~type._specimens_12_distinct_collector_name_collect_num; Type: TYPE; Schema: public_validations; Owner: -
886 914
--
887 915

  
......
2165 2193

  
2166 2194

  
2167 2195
--
2196
-- Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2197
--
2198

  
2199
CREATE TABLE `~type._specimens_11_list_of_three_standard_political_divisions` (
2200
    country varchar(255),
2201
    `stateProvince` varchar(255),
2202
    county varchar(255)
2203
);
2204

  
2205

  
2206
--
2207
-- Name: keys(`~type._specimens_11_list_of_three_standard_political_divisions`); Type: FUNCTION; Schema: public_validations; Owner: -
2208
--
2209

  
2210

  
2211

  
2212

  
2213
--
2168 2214
-- Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2169 2215
--
2170 2216

  
......
2766 2812

  
2767 2813

  
2768 2814
--
2815
-- Name: values_(`~type._specimens_11_list_of_three_standard_political_divisions`); Type: FUNCTION; Schema: public_validations; Owner: -
2816
--
2817

  
2818

  
2819

  
2820

  
2821
--
2769 2822
-- Name: values_(`~type._specimens_12_distinct_collector_name_collect_num_date_w_`); Type: FUNCTION; Schema: public_validations; Owner: -
2770 2823
--
2771 2824

  
......
8861 8914

  
8862 8915

  
8863 8916
--
8917
-- Data for Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE DATA; Schema: public_validations; Owner: -
8918
--
8919

  
8920

  
8921

  
8922
--
8864 8923
-- Data for Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE DATA; Schema: public_validations; Owner: -
8865 8924
--
8866 8925

  
trunk/schemas/vegbien.sql
837 837

  
838 838

  
839 839
--
840
-- Name: keys_~type._specimens_11_list_of_three_standard_political_divis; Type: TYPE; Schema: public_validations; Owner: -
841
--
842

  
843
CREATE TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis" AS (
844
	country text,
845
	"stateProvince" text,
846
	county text
847
);
848

  
849

  
850
--
851
-- Name: TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis"; Type: COMMENT; Schema: public_validations; Owner: -
852
--
853

  
854
COMMENT ON TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis" IS '
855
autogenerated
856
';
857

  
858

  
859
--
840 860
-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: -
841 861
--
842 862

  
......
1371 1391

  
1372 1392

  
1373 1393
--
1394
-- Name: values__~type._specimens_11_list_of_three_standard_political_di; Type: TYPE; Schema: public_validations; Owner: -
1395
--
1396

  
1397
CREATE TYPE "values__~type._specimens_11_list_of_three_standard_political_di" AS (
1398
	country text,
1399
	"stateProvince" text,
1400
	county text
1401
);
1402

  
1403

  
1404
--
1405
-- Name: TYPE "values__~type._specimens_11_list_of_three_standard_political_di"; Type: COMMENT; Schema: public_validations; Owner: -
1406
--
1407

  
1408
COMMENT ON TYPE "values__~type._specimens_11_list_of_three_standard_political_di" IS '
1409
autogenerated
1410
';
1411

  
1412

  
1413
--
1374 1414
-- Name: values__~type._specimens_12_distinct_collector_name_collect_num; Type: TYPE; Schema: public_validations; Owner: -
1375 1415
--
1376 1416

  
......
3693 3733

  
3694 3734

  
3695 3735
--
3736
-- Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3737
--
3738

  
3739
CREATE TABLE "~type._specimens_11_list_of_three_standard_political_divisions" (
3740
    country text,
3741
    "stateProvince" text,
3742
    county text
3743
);
3744

  
3745

  
3746
--
3747
-- Name: keys("~type._specimens_11_list_of_three_standard_political_divisions"); Type: FUNCTION; Schema: public_validations; Owner: -
3748
--
3749

  
3750
CREATE FUNCTION keys(value "~type._specimens_11_list_of_three_standard_political_divisions") RETURNS "keys_~type._specimens_11_list_of_three_standard_political_divis"
3751
    LANGUAGE sql IMMUTABLE
3752
    AS $_$
3753
SELECT ROW($1.country, $1."stateProvince", $1.county)::public_validations."keys_~type._specimens_11_list_of_three_standard_political_divis"
3754
$_$;
3755

  
3756

  
3757
--
3696 3758
-- Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3697 3759
--
3698 3760

  
......
4764 4826

  
4765 4827

  
4766 4828
--
4829
-- Name: values_("~type._specimens_11_list_of_three_standard_political_divisions"); Type: FUNCTION; Schema: public_validations; Owner: -
4830
--
4831

  
4832
CREATE FUNCTION values_(value "~type._specimens_11_list_of_three_standard_political_divisions") RETURNS "values__~type._specimens_11_list_of_three_standard_political_di"
4833
    LANGUAGE sql IMMUTABLE
4834
    AS $_$
4835
SELECT ROW($1.country, $1."stateProvince", $1.county)::public_validations."values__~type._specimens_11_list_of_three_standard_political_di"
4836
$_$;
4837

  
4838

  
4839
--
4767 4840
-- Name: values_("~type._specimens_12_distinct_collector_name_collect_num_date_w_"); Type: FUNCTION; Schema: public_validations; Owner: -
4768 4841
--
4769 4842

  
......
12283 12356

  
12284 12357

  
12285 12358
--
12359
-- Data for Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE DATA; Schema: public_validations; Owner: -
12360
--
12361

  
12362

  
12363

  
12364
--
12286 12365
-- Data for Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE DATA; Schema: public_validations; Owner: -
12287 12366
--
12288 12367

  

Also available in: Unified diff