Revision 12399
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1021 | 1021 |
|
| 1022 | 1022 |
|
| 1023 | 1023 |
|
| 1024 |
-- |
|
| 1025 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1026 |
-- |
|
| 1027 | 1024 |
|
| 1028 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 1029 |
`totalRecords` varchar(255) |
|
| 1030 |
); |
|
| 1031 | 1025 |
|
| 1032 |
|
|
| 1033 | 1026 |
-- |
| 1034 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1035 |
-- |
|
| 1036 |
|
|
| 1037 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 1038 |
traits varchar(255) |
|
| 1039 |
); |
|
| 1040 |
|
|
| 1041 |
|
|
| 1042 |
-- |
|
| 1043 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1044 |
-- |
|
| 1045 |
|
|
| 1046 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 1047 |
trait varchar(255) |
|
| 1048 |
); |
|
| 1049 |
|
|
| 1050 |
|
|
| 1051 |
-- |
|
| 1052 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1053 |
-- |
|
| 1054 |
|
|
| 1055 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 1056 |
trait varchar(255), |
|
| 1057 |
measurements varchar(255) |
|
| 1058 |
); |
|
| 1059 |
|
|
| 1060 |
|
|
| 1061 |
-- |
|
| 1062 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1063 |
-- |
|
| 1064 |
|
|
| 1065 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 1066 |
taxa varchar(255) |
|
| 1067 |
); |
|
| 1068 |
|
|
| 1069 |
|
|
| 1070 |
-- |
|
| 1071 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1072 |
-- |
|
| 1073 |
|
|
| 1074 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 1075 |
taxonwithauthor varchar(255) |
|
| 1076 |
); |
|
| 1077 |
|
|
| 1078 |
|
|
| 1079 |
-- |
|
| 1080 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1081 |
-- |
|
| 1082 |
|
|
| 1083 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 1084 |
trait varchar(255), |
|
| 1085 |
value varchar(255), |
|
| 1086 |
units varchar(255) |
|
| 1087 |
); |
|
| 1088 |
|
|
| 1089 |
|
|
| 1090 |
-- |
|
| 1091 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1092 |
-- |
|
| 1093 |
|
|
| 1094 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 1095 |
taxonwithauthor varchar(255), |
|
| 1096 |
trait varchar(255), |
|
| 1097 |
value varchar(255) |
|
| 1098 |
); |
|
| 1099 |
|
|
| 1100 |
|
|
| 1101 |
|
|
| 1102 |
|
|
| 1103 |
-- |
|
| 1104 | 1027 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1105 | 1028 |
-- |
| 1106 | 1029 |
|
| ... | ... | |
| 3911 | 3834 |
|
| 3912 | 3835 |
|
| 3913 | 3836 |
|
| 3837 |
-- |
|
| 3838 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3839 |
-- |
|
| 3914 | 3840 |
|
| 3841 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 3842 |
`totalRecords` varchar(255) |
|
| 3843 |
); |
|
| 3915 | 3844 |
|
| 3845 |
|
|
| 3916 | 3846 |
-- |
| 3847 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3848 |
-- |
|
| 3849 |
|
|
| 3850 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 3851 |
traits varchar(255) |
|
| 3852 |
); |
|
| 3853 |
|
|
| 3854 |
|
|
| 3855 |
-- |
|
| 3856 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3857 |
-- |
|
| 3858 |
|
|
| 3859 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 3860 |
trait varchar(255) |
|
| 3861 |
); |
|
| 3862 |
|
|
| 3863 |
|
|
| 3864 |
-- |
|
| 3865 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3866 |
-- |
|
| 3867 |
|
|
| 3868 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 3869 |
trait varchar(255), |
|
| 3870 |
measurements varchar(255) |
|
| 3871 |
); |
|
| 3872 |
|
|
| 3873 |
|
|
| 3874 |
-- |
|
| 3875 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3876 |
-- |
|
| 3877 |
|
|
| 3878 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 3879 |
taxa varchar(255) |
|
| 3880 |
); |
|
| 3881 |
|
|
| 3882 |
|
|
| 3883 |
-- |
|
| 3884 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3885 |
-- |
|
| 3886 |
|
|
| 3887 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 3888 |
taxonwithauthor varchar(255) |
|
| 3889 |
); |
|
| 3890 |
|
|
| 3891 |
|
|
| 3892 |
-- |
|
| 3893 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3894 |
-- |
|
| 3895 |
|
|
| 3896 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 3897 |
trait varchar(255), |
|
| 3898 |
value varchar(255), |
|
| 3899 |
units varchar(255) |
|
| 3900 |
); |
|
| 3901 |
|
|
| 3902 |
|
|
| 3903 |
-- |
|
| 3904 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3905 |
-- |
|
| 3906 |
|
|
| 3907 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 3908 |
taxonwithauthor varchar(255), |
|
| 3909 |
trait varchar(255), |
|
| 3910 |
value varchar(255) |
|
| 3911 |
); |
|
| 3912 |
|
|
| 3913 |
|
|
| 3914 |
|
|
| 3915 |
|
|
| 3916 |
-- |
|
| 3917 | 3917 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 3918 | 3918 |
-- |
| 3919 | 3919 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2349 | 2349 |
$_$; |
| 2350 | 2350 |
|
| 2351 | 2351 |
|
| 2352 |
-- |
|
| 2353 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2354 |
-- |
|
| 2355 |
|
|
| 2356 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 2357 |
"totalRecords" bigint |
|
| 2358 |
); |
|
| 2359 |
|
|
| 2360 |
|
|
| 2361 |
-- |
|
| 2362 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2363 |
-- |
|
| 2364 |
|
|
| 2365 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 2366 |
traits bigint |
|
| 2367 |
); |
|
| 2368 |
|
|
| 2369 |
|
|
| 2370 |
-- |
|
| 2371 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2372 |
-- |
|
| 2373 |
|
|
| 2374 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 2375 |
trait text |
|
| 2376 |
); |
|
| 2377 |
|
|
| 2378 |
|
|
| 2379 |
-- |
|
| 2380 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2381 |
-- |
|
| 2382 |
|
|
| 2383 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 2384 |
trait text, |
|
| 2385 |
measurements bigint |
|
| 2386 |
); |
|
| 2387 |
|
|
| 2388 |
|
|
| 2389 |
-- |
|
| 2390 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2391 |
-- |
|
| 2392 |
|
|
| 2393 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 2394 |
taxa bigint |
|
| 2395 |
); |
|
| 2396 |
|
|
| 2397 |
|
|
| 2398 |
-- |
|
| 2399 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2400 |
-- |
|
| 2401 |
|
|
| 2402 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 2403 |
taxonwithauthor text |
|
| 2404 |
); |
|
| 2405 |
|
|
| 2406 |
|
|
| 2407 |
-- |
|
| 2408 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2409 |
-- |
|
| 2410 |
|
|
| 2411 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 2412 |
trait text, |
|
| 2413 |
value text, |
|
| 2414 |
units text |
|
| 2415 |
); |
|
| 2416 |
|
|
| 2417 |
|
|
| 2418 |
-- |
|
| 2419 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2420 |
-- |
|
| 2421 |
|
|
| 2422 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 2423 |
taxonwithauthor text, |
|
| 2424 |
trait text, |
|
| 2425 |
value text |
|
| 2426 |
); |
|
| 2427 |
|
|
| 2428 |
|
|
| 2429 | 2352 |
SET search_path = public, pg_catalog; |
| 2430 | 2353 |
|
| 2431 | 2354 |
-- |
| ... | ... | |
| 6340 | 6263 |
ORDER BY taxonverbatim.taxonname; |
| 6341 | 6264 |
|
| 6342 | 6265 |
|
| 6266 |
-- |
|
| 6267 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6268 |
-- |
|
| 6269 |
|
|
| 6270 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 6271 |
"totalRecords" bigint |
|
| 6272 |
); |
|
| 6273 |
|
|
| 6274 |
|
|
| 6275 |
-- |
|
| 6276 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6277 |
-- |
|
| 6278 |
|
|
| 6279 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 6280 |
traits bigint |
|
| 6281 |
); |
|
| 6282 |
|
|
| 6283 |
|
|
| 6284 |
-- |
|
| 6285 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6286 |
-- |
|
| 6287 |
|
|
| 6288 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 6289 |
trait text |
|
| 6290 |
); |
|
| 6291 |
|
|
| 6292 |
|
|
| 6293 |
-- |
|
| 6294 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6295 |
-- |
|
| 6296 |
|
|
| 6297 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 6298 |
trait text, |
|
| 6299 |
measurements bigint |
|
| 6300 |
); |
|
| 6301 |
|
|
| 6302 |
|
|
| 6303 |
-- |
|
| 6304 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6305 |
-- |
|
| 6306 |
|
|
| 6307 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 6308 |
taxa bigint |
|
| 6309 |
); |
|
| 6310 |
|
|
| 6311 |
|
|
| 6312 |
-- |
|
| 6313 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6314 |
-- |
|
| 6315 |
|
|
| 6316 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 6317 |
taxonwithauthor text |
|
| 6318 |
); |
|
| 6319 |
|
|
| 6320 |
|
|
| 6321 |
-- |
|
| 6322 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6323 |
-- |
|
| 6324 |
|
|
| 6325 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 6326 |
trait text, |
|
| 6327 |
value text, |
|
| 6328 |
units text |
|
| 6329 |
); |
|
| 6330 |
|
|
| 6331 |
|
|
| 6332 |
-- |
|
| 6333 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6334 |
-- |
|
| 6335 |
|
|
| 6336 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 6337 |
taxonwithauthor text, |
|
| 6338 |
trait text, |
|
| 6339 |
value text |
|
| 6340 |
); |
|
| 6341 |
|
|
| 6342 |
|
|
| 6343 | 6343 |
SET search_path = public, pg_catalog; |
| 6344 | 6344 |
|
| 6345 | 6345 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: synced to DB, which changes the sort order (due to system update?)