Revision 12503
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1069 | 1069 |
|
| 1070 | 1070 |
|
| 1071 | 1071 |
|
| 1072 |
-- |
|
| 1073 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1074 |
-- |
|
| 1075 | 1072 |
|
| 1076 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 1077 |
`totalRecords` varchar(255) |
|
| 1078 |
); |
|
| 1079 | 1073 |
|
| 1080 |
|
|
| 1081 | 1074 |
-- |
| 1082 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1083 |
-- |
|
| 1084 |
|
|
| 1085 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 1086 |
traits varchar(255) |
|
| 1087 |
); |
|
| 1088 |
|
|
| 1089 |
|
|
| 1090 |
-- |
|
| 1091 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1092 |
-- |
|
| 1093 |
|
|
| 1094 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 1095 |
trait varchar(255) |
|
| 1096 |
); |
|
| 1097 |
|
|
| 1098 |
|
|
| 1099 |
-- |
|
| 1100 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1101 |
-- |
|
| 1102 |
|
|
| 1103 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 1104 |
taxa varchar(255) |
|
| 1105 |
); |
|
| 1106 |
|
|
| 1107 |
|
|
| 1108 |
-- |
|
| 1109 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1110 |
-- |
|
| 1111 |
|
|
| 1112 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 1113 |
taxonwithauthor varchar(255) |
|
| 1114 |
); |
|
| 1115 |
|
|
| 1116 |
|
|
| 1117 |
-- |
|
| 1118 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1119 |
-- |
|
| 1120 |
|
|
| 1121 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 1122 |
trait varchar(255), |
|
| 1123 |
value varchar(255), |
|
| 1124 |
units varchar(255) |
|
| 1125 |
); |
|
| 1126 |
|
|
| 1127 |
|
|
| 1128 |
-- |
|
| 1129 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1130 |
-- |
|
| 1131 |
|
|
| 1132 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 1133 |
taxonwithauthor varchar(255), |
|
| 1134 |
trait varchar(255), |
|
| 1135 |
value varchar(255) |
|
| 1136 |
); |
|
| 1137 |
|
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
|
|
| 1141 |
-- |
|
| 1142 | 1075 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1143 | 1076 |
-- |
| 1144 | 1077 |
|
| ... | ... | |
| 3976 | 3909 |
); |
| 3977 | 3910 |
|
| 3978 | 3911 |
|
| 3912 |
-- |
|
| 3913 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3914 |
-- |
|
| 3979 | 3915 |
|
| 3916 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 3917 |
`totalRecords` varchar(255) |
|
| 3918 |
); |
|
| 3980 | 3919 |
|
| 3920 |
|
|
| 3981 | 3921 |
-- |
| 3922 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3923 |
-- |
|
| 3924 |
|
|
| 3925 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 3926 |
traits varchar(255) |
|
| 3927 |
); |
|
| 3928 |
|
|
| 3929 |
|
|
| 3930 |
-- |
|
| 3931 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3932 |
-- |
|
| 3933 |
|
|
| 3934 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 3935 |
trait varchar(255) |
|
| 3936 |
); |
|
| 3937 |
|
|
| 3938 |
|
|
| 3939 |
-- |
|
| 3940 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3941 |
-- |
|
| 3942 |
|
|
| 3943 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 3944 |
taxa varchar(255) |
|
| 3945 |
); |
|
| 3946 |
|
|
| 3947 |
|
|
| 3948 |
-- |
|
| 3949 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3950 |
-- |
|
| 3951 |
|
|
| 3952 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 3953 |
taxonwithauthor varchar(255) |
|
| 3954 |
); |
|
| 3955 |
|
|
| 3956 |
|
|
| 3957 |
-- |
|
| 3958 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3959 |
-- |
|
| 3960 |
|
|
| 3961 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 3962 |
trait varchar(255), |
|
| 3963 |
value varchar(255), |
|
| 3964 |
units varchar(255) |
|
| 3965 |
); |
|
| 3966 |
|
|
| 3967 |
|
|
| 3968 |
-- |
|
| 3969 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3970 |
-- |
|
| 3971 |
|
|
| 3972 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 3973 |
taxonwithauthor varchar(255), |
|
| 3974 |
trait varchar(255), |
|
| 3975 |
value varchar(255) |
|
| 3976 |
); |
|
| 3977 |
|
|
| 3978 |
|
|
| 3979 |
|
|
| 3980 |
|
|
| 3981 |
-- |
|
| 3982 | 3982 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 3983 | 3983 |
-- |
| 3984 | 3984 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 745 | 745 |
COMMENT ON FUNCTION datasource_publish(datasource text, schema_anchor anyelement) IS ' |
| 746 | 746 |
secure against renamings of the public schema. |
| 747 | 747 |
|
| 748 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 748 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 749 | 749 |
'; |
| 750 | 750 |
|
| 751 | 751 |
|
| ... | ... | |
| 776 | 776 |
COMMENT ON FUNCTION datasource_rename(old text, new text, schema_anchor anyelement) IS ' |
| 777 | 777 |
secure against renamings of the public schema. |
| 778 | 778 |
|
| 779 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 779 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 780 | 780 |
'; |
| 781 | 781 |
|
| 782 | 782 |
|
| ... | ... | |
| 807 | 807 |
COMMENT ON FUNCTION datasource_rm(datasource text, schema_anchor anyelement) IS ' |
| 808 | 808 |
secure against renamings of the public schema. |
| 809 | 809 |
|
| 810 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 810 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 811 | 811 |
|
| 812 | 812 |
runtime: |
| 813 | 813 |
ACAD: 30 s : 27738 ms/ 45,503 rows = 0.61 ms/row |
| ... | ... | |
| 848 | 848 |
COMMENT ON FUNCTION datasource_unpublish(datasource text, schema_anchor anyelement) IS ' |
| 849 | 849 |
secure against renamings of the public schema. |
| 850 | 850 |
|
| 851 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 851 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 852 | 852 |
'; |
| 853 | 853 |
|
| 854 | 854 |
|
| ... | ... | |
| 1398 | 1398 |
|
| 1399 | 1399 |
secure against renamings of the public schema. |
| 1400 | 1400 |
|
| 1401 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 1401 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 1402 | 1402 |
'; |
| 1403 | 1403 |
|
| 1404 | 1404 |
|
| ... | ... | |
| 1435 | 1435 |
|
| 1436 | 1436 |
secure against renamings of the public schema. |
| 1437 | 1437 |
|
| 1438 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 1438 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 1439 | 1439 |
'; |
| 1440 | 1440 |
|
| 1441 | 1441 |
|
| ... | ... | |
| 2095 | 2095 |
|
| 2096 | 2096 |
idempotent, but repeats action each time |
| 2097 | 2097 |
|
| 2098 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2098 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2099 | 2099 |
'; |
| 2100 | 2100 |
|
| 2101 | 2101 |
|
| ... | ... | |
| 2272 | 2272 |
|
| 2273 | 2273 |
idempotent, but repeats action each time |
| 2274 | 2274 |
|
| 2275 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2275 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2276 | 2276 |
'; |
| 2277 | 2277 |
|
| 2278 | 2278 |
|
| ... | ... | |
| 2312 | 2312 |
|
| 2313 | 2313 |
idempotent |
| 2314 | 2314 |
|
| 2315 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2315 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2316 | 2316 |
'; |
| 2317 | 2317 |
|
| 2318 | 2318 |
|
| ... | ... | |
| 2342 | 2342 |
|
| 2343 | 2343 |
idempotent |
| 2344 | 2344 |
|
| 2345 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2345 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2346 | 2346 |
'; |
| 2347 | 2347 |
|
| 2348 | 2348 |
|
| ... | ... | |
| 2382 | 2382 |
|
| 2383 | 2383 |
idempotent |
| 2384 | 2384 |
|
| 2385 |
schema_anchor: identifies which schema to use. should be left as the default value.
|
|
| 2385 |
schema_anchor: identifies this function''s schema. should be left as the default.
|
|
| 2386 | 2386 |
'; |
| 2387 | 2387 |
|
| 2388 | 2388 |
|
| ... | ... | |
| 2421 | 2421 |
$_$; |
| 2422 | 2422 |
|
| 2423 | 2423 |
|
| 2424 |
-- |
|
| 2425 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2426 |
-- |
|
| 2427 |
|
|
| 2428 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 2429 |
"totalRecords" bigint |
|
| 2430 |
); |
|
| 2431 |
|
|
| 2432 |
|
|
| 2433 |
-- |
|
| 2434 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2435 |
-- |
|
| 2436 |
|
|
| 2437 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 2438 |
traits bigint |
|
| 2439 |
); |
|
| 2440 |
|
|
| 2441 |
|
|
| 2442 |
-- |
|
| 2443 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2444 |
-- |
|
| 2445 |
|
|
| 2446 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 2447 |
trait text |
|
| 2448 |
); |
|
| 2449 |
|
|
| 2450 |
|
|
| 2451 |
-- |
|
| 2452 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2453 |
-- |
|
| 2454 |
|
|
| 2455 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 2456 |
taxa bigint |
|
| 2457 |
); |
|
| 2458 |
|
|
| 2459 |
|
|
| 2460 |
-- |
|
| 2461 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2462 |
-- |
|
| 2463 |
|
|
| 2464 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 2465 |
taxonwithauthor text |
|
| 2466 |
); |
|
| 2467 |
|
|
| 2468 |
|
|
| 2469 |
-- |
|
| 2470 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2471 |
-- |
|
| 2472 |
|
|
| 2473 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 2474 |
trait text, |
|
| 2475 |
value text, |
|
| 2476 |
units text |
|
| 2477 |
); |
|
| 2478 |
|
|
| 2479 |
|
|
| 2480 |
-- |
|
| 2481 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2482 |
-- |
|
| 2483 |
|
|
| 2484 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 2485 |
taxonwithauthor text, |
|
| 2486 |
trait text, |
|
| 2487 |
value text |
|
| 2488 |
); |
|
| 2489 |
|
|
| 2490 |
|
|
| 2491 | 2424 |
SET search_path = public, pg_catalog; |
| 2492 | 2425 |
|
| 2493 | 2426 |
-- |
| ... | ... | |
| 6429 | 6362 |
); |
| 6430 | 6363 |
|
| 6431 | 6364 |
|
| 6365 |
-- |
|
| 6366 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6367 |
-- |
|
| 6368 |
|
|
| 6369 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 6370 |
"totalRecords" bigint |
|
| 6371 |
); |
|
| 6372 |
|
|
| 6373 |
|
|
| 6374 |
-- |
|
| 6375 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6376 |
-- |
|
| 6377 |
|
|
| 6378 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 6379 |
traits bigint |
|
| 6380 |
); |
|
| 6381 |
|
|
| 6382 |
|
|
| 6383 |
-- |
|
| 6384 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6385 |
-- |
|
| 6386 |
|
|
| 6387 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 6388 |
trait text |
|
| 6389 |
); |
|
| 6390 |
|
|
| 6391 |
|
|
| 6392 |
-- |
|
| 6393 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6394 |
-- |
|
| 6395 |
|
|
| 6396 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 6397 |
taxa bigint |
|
| 6398 |
); |
|
| 6399 |
|
|
| 6400 |
|
|
| 6401 |
-- |
|
| 6402 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6403 |
-- |
|
| 6404 |
|
|
| 6405 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 6406 |
taxonwithauthor text |
|
| 6407 |
); |
|
| 6408 |
|
|
| 6409 |
|
|
| 6410 |
-- |
|
| 6411 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6412 |
-- |
|
| 6413 |
|
|
| 6414 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 6415 |
trait text, |
|
| 6416 |
value text, |
|
| 6417 |
units text |
|
| 6418 |
); |
|
| 6419 |
|
|
| 6420 |
|
|
| 6421 |
-- |
|
| 6422 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6423 |
-- |
|
| 6424 |
|
|
| 6425 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 6426 |
taxonwithauthor text, |
|
| 6427 |
trait text, |
|
| 6428 |
value text |
|
| 6429 |
); |
|
| 6430 |
|
|
| 6431 |
|
|
| 6432 | 6432 |
SET search_path = public, pg_catalog; |
| 6433 | 6433 |
|
| 6434 | 6434 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: schema_anchor: clarified that this identifies this function's schema (for use in locating helper functions), but is not necessarily the schema operated on, as the comment implied