Revision 8941
Added by Aaron Marcuse-Kubitza about 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 14 | 14 |
-- Table structure for table "aggregate_observation" |
| 15 | 15 |
-- |
| 16 | 16 |
|
| 17 |
DROP TABLE IF EXISTS "aggregate_observation"; |
|
| 18 | 17 |
CREATE TABLE "aggregate_observation" ( |
| 19 | 18 |
"id" varbinary(767) NOT NULL, |
| 20 | 19 |
"taxon_concept" varbinary(767) NOT NULL, |
| ... | ... | |
| 36 | 35 |
-- Table structure for table "base_class" |
| 37 | 36 |
-- |
| 38 | 37 |
|
| 39 |
DROP TABLE IF EXISTS "base_class"; |
|
| 40 | 38 |
CREATE TABLE "base_class" ( |
| 41 | 39 |
"id" varbinary(767) NOT NULL, |
| 42 | 40 |
"referenced_class" varbinary(767) NOT NULL, |
| ... | ... | |
| 57 | 55 |
-- Table structure for table "collection" |
| 58 | 56 |
-- |
| 59 | 57 |
|
| 60 |
DROP TABLE IF EXISTS "collection"; |
|
| 61 | 58 |
CREATE TABLE "collection" ( |
| 62 | 59 |
"id" varbinary(767) NOT NULL, |
| 63 | 60 |
"institution" varbinary(767) NOT NULL, |
| ... | ... | |
| 81 | 78 |
-- Table structure for table "community" |
| 82 | 79 |
-- |
| 83 | 80 |
|
| 84 |
DROP TABLE IF EXISTS "community"; |
|
| 85 | 81 |
CREATE TABLE "community" ( |
| 86 | 82 |
"id" varbinary(767) NOT NULL, |
| 87 | 83 |
"name" varbinary(767) NOT NULL, |
| ... | ... | |
| 101 | 97 |
-- Table structure for table "coordinates" |
| 102 | 98 |
-- |
| 103 | 99 |
|
| 104 |
DROP TABLE IF EXISTS "coordinates"; |
|
| 105 | 100 |
CREATE TABLE "coordinates" ( |
| 106 | 101 |
"id" varbinary(767) NOT NULL, |
| 107 | 102 |
"latitude_deg" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 120 | 115 |
-- Table structure for table "derived_class" |
| 121 | 116 |
-- |
| 122 | 117 |
|
| 123 |
DROP TABLE IF EXISTS "derived_class"; |
|
| 124 | 118 |
CREATE TABLE "derived_class" ( |
| 125 | 119 |
"id" varbinary(767) NOT NULL, |
| 126 | 120 |
PRIMARY KEY ("id"),
|
| ... | ... | |
| 138 | 132 |
-- Table structure for table "event" |
| 139 | 133 |
-- |
| 140 | 134 |
|
| 141 |
DROP TABLE IF EXISTS "event"; |
|
| 142 | 135 |
CREATE TABLE "event" ( |
| 143 | 136 |
"id" varbinary(767) NOT NULL, |
| 144 | 137 |
"parent" varbinary(767) NOT NULL, |
| ... | ... | |
| 167 | 160 |
-- Table structure for table "event_participant" |
| 168 | 161 |
-- |
| 169 | 162 |
|
| 170 |
DROP TABLE IF EXISTS "event_participant"; |
|
| 171 | 163 |
CREATE TABLE "event_participant" ( |
| 172 | 164 |
"event" varbinary(767) NOT NULL, |
| 173 | 165 |
"party" varbinary(767) NOT NULL, |
| ... | ... | |
| 190 | 182 |
-- Table structure for table "geological_context" |
| 191 | 183 |
-- |
| 192 | 184 |
|
| 193 |
DROP TABLE IF EXISTS "geological_context"; |
|
| 194 | 185 |
CREATE TABLE "geological_context" ( |
| 195 | 186 |
"id" varbinary(767) NOT NULL, |
| 196 | 187 |
"name" varbinary(767) NOT NULL, |
| ... | ... | |
| 210 | 201 |
-- Table structure for table "geovalidation" |
| 211 | 202 |
-- |
| 212 | 203 |
|
| 213 |
DROP TABLE IF EXISTS "geovalidation"; |
|
| 214 | 204 |
CREATE TABLE "geovalidation" ( |
| 215 | 205 |
"id" varbinary(767) NOT NULL, |
| 216 | 206 |
"geovalid" tinyint(1) NOT NULL, |
| ... | ... | |
| 231 | 221 |
-- Table structure for table "individual" |
| 232 | 222 |
-- |
| 233 | 223 |
|
| 234 |
DROP TABLE IF EXISTS "individual"; |
|
| 235 | 224 |
CREATE TABLE "individual" ( |
| 236 | 225 |
"id" varbinary(767) NOT NULL, |
| 237 | 226 |
"tag" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 250 | 239 |
-- Table structure for table "individual_observation" |
| 251 | 240 |
-- |
| 252 | 241 |
|
| 253 |
DROP TABLE IF EXISTS "individual_observation"; |
|
| 254 | 242 |
CREATE TABLE "individual_observation" ( |
| 255 | 243 |
"id" varbinary(767) NOT NULL, |
| 256 | 244 |
"individual" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 273 | 261 |
-- Table structure for table "method" |
| 274 | 262 |
-- |
| 275 | 263 |
|
| 276 |
DROP TABLE IF EXISTS "method"; |
|
| 277 | 264 |
CREATE TABLE "method" ( |
| 278 | 265 |
"id" varbinary(767) NOT NULL, |
| 279 | 266 |
"parent" varbinary(767) NOT NULL, |
| ... | ... | |
| 295 | 282 |
-- Table structure for table "organization" |
| 296 | 283 |
-- |
| 297 | 284 |
|
| 298 |
DROP TABLE IF EXISTS "organization"; |
|
| 299 | 285 |
CREATE TABLE "organization" ( |
| 300 | 286 |
"id" varbinary(767) NOT NULL, |
| 301 | 287 |
"info" set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| ... | ... | |
| 314 | 300 |
-- Table structure for table "parsed_taxon_assertion" |
| 315 | 301 |
-- |
| 316 | 302 |
|
| 317 |
DROP TABLE IF EXISTS "parsed_taxon_assertion"; |
|
| 318 | 303 |
CREATE TABLE "parsed_taxon_assertion" ( |
| 319 | 304 |
"id" varbinary(767) NOT NULL, |
| 320 | 305 |
"matched_taxon_concept" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 337 | 322 |
-- Table structure for table "party" |
| 338 | 323 |
-- |
| 339 | 324 |
|
| 340 |
DROP TABLE IF EXISTS "party"; |
|
| 341 | 325 |
CREATE TABLE "party" ( |
| 342 | 326 |
"id" varbinary(767) NOT NULL, |
| 343 | 327 |
"info" set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| ... | ... | |
| 356 | 340 |
-- Table structure for table "place" |
| 357 | 341 |
-- |
| 358 | 342 |
|
| 359 |
DROP TABLE IF EXISTS "place"; |
|
| 360 | 343 |
CREATE TABLE "place" ( |
| 361 | 344 |
"id" varbinary(767) NOT NULL, |
| 362 | 345 |
"parent" varbinary(767) NOT NULL, |
| ... | ... | |
| 384 | 367 |
-- Table structure for table "place_observation" |
| 385 | 368 |
-- |
| 386 | 369 |
|
| 387 |
DROP TABLE IF EXISTS "place_observation"; |
|
| 388 | 370 |
CREATE TABLE "place_observation" ( |
| 389 | 371 |
"id" varbinary(767) NOT NULL, |
| 390 | 372 |
"place" varbinary(767) NOT NULL, |
| ... | ... | |
| 416 | 398 |
-- Table structure for table "place_path" |
| 417 | 399 |
-- |
| 418 | 400 |
|
| 419 |
DROP TABLE IF EXISTS "place_path"; |
|
| 420 | 401 |
CREATE TABLE "place_path" ( |
| 421 | 402 |
"id" varbinary(767) NOT NULL, |
| 422 | 403 |
"continent" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 439 | 420 |
-- Table structure for table "plot" |
| 440 | 421 |
-- |
| 441 | 422 |
|
| 442 |
DROP TABLE IF EXISTS "plot"; |
|
| 443 | 423 |
CREATE TABLE "plot" ( |
| 444 | 424 |
"id" varbinary(767) NOT NULL, |
| 445 | 425 |
"name" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 460 | 440 |
-- Table structure for table "project" |
| 461 | 441 |
-- |
| 462 | 442 |
|
| 463 |
DROP TABLE IF EXISTS "project"; |
|
| 464 | 443 |
CREATE TABLE "project" ( |
| 465 | 444 |
"id" varbinary(767) NOT NULL, |
| 466 | 445 |
"name" varbinary(767) NOT NULL, |
| ... | ... | |
| 480 | 459 |
-- Table structure for table "record" |
| 481 | 460 |
-- |
| 482 | 461 |
|
| 483 |
DROP TABLE IF EXISTS "record"; |
|
| 484 | 462 |
CREATE TABLE "record" ( |
| 485 | 463 |
"id" varbinary(767) NOT NULL, |
| 486 | 464 |
"source" varbinary(767) NOT NULL, |
| ... | ... | |
| 504 | 482 |
-- Table structure for table "referenced_class" |
| 505 | 483 |
-- |
| 506 | 484 |
|
| 507 |
DROP TABLE IF EXISTS "referenced_class"; |
|
| 508 | 485 |
CREATE TABLE "referenced_class" ( |
| 509 | 486 |
"id" varbinary(767) NOT NULL, |
| 510 | 487 |
PRIMARY KEY ("id"),
|
| ... | ... | |
| 522 | 499 |
-- Table structure for table "relationship" |
| 523 | 500 |
-- |
| 524 | 501 |
|
| 525 |
DROP TABLE IF EXISTS "relationship"; |
|
| 526 | 502 |
CREATE TABLE "relationship" ( |
| 527 | 503 |
"id" varbinary(767) NOT NULL, |
| 528 | 504 |
"record" varbinary(767) NOT NULL, |
| ... | ... | |
| 547 | 523 |
-- Table structure for table "soil_observation" |
| 548 | 524 |
-- |
| 549 | 525 |
|
| 550 |
DROP TABLE IF EXISTS "soil_observation"; |
|
| 551 | 526 |
CREATE TABLE "soil_observation" ( |
| 552 | 527 |
"id" varbinary(767) NOT NULL, |
| 553 | 528 |
"observations" set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| ... | ... | |
| 566 | 541 |
-- Table structure for table "source" |
| 567 | 542 |
-- |
| 568 | 543 |
|
| 569 |
DROP TABLE IF EXISTS "source"; |
|
| 570 | 544 |
CREATE TABLE "source" ( |
| 571 | 545 |
"id" varbinary(767) NOT NULL, |
| 572 | 546 |
"parent" varbinary(767) NOT NULL, |
| ... | ... | |
| 595 | 569 |
-- Table structure for table "specimen" |
| 596 | 570 |
-- |
| 597 | 571 |
|
| 598 |
DROP TABLE IF EXISTS "specimen"; |
|
| 599 | 572 |
CREATE TABLE "specimen" ( |
| 600 | 573 |
"id" varbinary(767) NOT NULL, |
| 601 | 574 |
"individual" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 635 | 608 |
-- Table structure for table "specimen_observation" |
| 636 | 609 |
-- |
| 637 | 610 |
|
| 638 |
DROP TABLE IF EXISTS "specimen_observation"; |
|
| 639 | 611 |
CREATE TABLE "specimen_observation" ( |
| 640 | 612 |
"id" varbinary(767) NOT NULL, |
| 641 | 613 |
"specimen" varbinary(767) NOT NULL, |
| ... | ... | |
| 657 | 629 |
-- Table structure for table "stem" |
| 658 | 630 |
-- |
| 659 | 631 |
|
| 660 |
DROP TABLE IF EXISTS "stem"; |
|
| 661 | 632 |
CREATE TABLE "stem" ( |
| 662 | 633 |
"id" varbinary(767) NOT NULL, |
| 663 | 634 |
"individual" varbinary(767) NOT NULL, |
| ... | ... | |
| 678 | 649 |
-- Table structure for table "stem_observation" |
| 679 | 650 |
-- |
| 680 | 651 |
|
| 681 |
DROP TABLE IF EXISTS "stem_observation"; |
|
| 682 | 652 |
CREATE TABLE "stem_observation" ( |
| 683 | 653 |
"id" varbinary(767) NOT NULL, |
| 684 | 654 |
"individual_observation" varbinary(767) NOT NULL, |
| ... | ... | |
| 704 | 674 |
-- Table structure for table "stratum" |
| 705 | 675 |
-- |
| 706 | 676 |
|
| 707 |
DROP TABLE IF EXISTS "stratum"; |
|
| 708 | 677 |
CREATE TABLE "stratum" ( |
| 709 | 678 |
"id" varbinary(767) NOT NULL, |
| 710 | 679 |
"name" varbinary(767) NOT NULL, |
| ... | ... | |
| 724 | 693 |
-- Table structure for table "subplot" |
| 725 | 694 |
-- |
| 726 | 695 |
|
| 727 |
DROP TABLE IF EXISTS "subplot"; |
|
| 728 | 696 |
CREATE TABLE "subplot" ( |
| 729 | 697 |
"id" varbinary(767) NOT NULL, |
| 730 | 698 |
"x_m" double DEFAULT NULL, |
| ... | ... | |
| 744 | 712 |
-- Table structure for table "taxon_assertion" |
| 745 | 713 |
-- |
| 746 | 714 |
|
| 747 |
DROP TABLE IF EXISTS "taxon_assertion"; |
|
| 748 | 715 |
CREATE TABLE "taxon_assertion" ( |
| 749 | 716 |
"id" varbinary(767) NOT NULL, |
| 750 | 717 |
"string" varbinary(767) NOT NULL, |
| ... | ... | |
| 770 | 737 |
-- Table structure for table "taxon_concept" |
| 771 | 738 |
-- |
| 772 | 739 |
|
| 773 |
DROP TABLE IF EXISTS "taxon_concept"; |
|
| 774 | 740 |
CREATE TABLE "taxon_concept" ( |
| 775 | 741 |
"id" varbinary(767) NOT NULL, |
| 776 | 742 |
"according_to" varbinary(767) NOT NULL, |
| ... | ... | |
| 798 | 764 |
-- Table structure for table "taxon_determination" |
| 799 | 765 |
-- |
| 800 | 766 |
|
| 801 |
DROP TABLE IF EXISTS "taxon_determination"; |
|
| 802 | 767 |
CREATE TABLE "taxon_determination" ( |
| 803 | 768 |
"id" varbinary(767) NOT NULL, |
| 804 | 769 |
"taxon_assertion" varbinary(767) NOT NULL, |
| ... | ... | |
| 824 | 789 |
-- Table structure for table "taxon_name" |
| 825 | 790 |
-- |
| 826 | 791 |
|
| 827 |
DROP TABLE IF EXISTS "taxon_name"; |
|
| 828 | 792 |
CREATE TABLE "taxon_name" ( |
| 829 | 793 |
"id" varbinary(767) NOT NULL, |
| 830 | 794 |
"unique_name" varbinary(767) NOT NULL, |
| ... | ... | |
| 850 | 814 |
-- Table structure for table "taxon_observation" |
| 851 | 815 |
-- |
| 852 | 816 |
|
| 853 |
DROP TABLE IF EXISTS "taxon_observation"; |
|
| 854 | 817 |
CREATE TABLE "taxon_observation" ( |
| 855 | 818 |
"id" varbinary(767) NOT NULL, |
| 856 | 819 |
"taxon_occurrence" varbinary(767) NOT NULL, |
| ... | ... | |
| 881 | 844 |
-- Table structure for table "taxon_occurrence" |
| 882 | 845 |
-- |
| 883 | 846 |
|
| 884 |
DROP TABLE IF EXISTS "taxon_occurrence"; |
|
| 885 | 847 |
CREATE TABLE "taxon_occurrence" ( |
| 886 | 848 |
"id" varbinary(767) NOT NULL, |
| 887 | 849 |
"current_determination" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 905 | 867 |
-- Table structure for table "taxon_path" |
| 906 | 868 |
-- |
| 907 | 869 |
|
| 908 |
DROP TABLE IF EXISTS "taxon_path"; |
|
| 909 | 870 |
CREATE TABLE "taxon_path" ( |
| 910 | 871 |
"id" varbinary(767) NOT NULL, |
| 911 | 872 |
"family" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 927 | 888 |
-- Table structure for table "taxon_presence" |
| 928 | 889 |
-- |
| 929 | 890 |
|
| 930 |
DROP TABLE IF EXISTS "taxon_presence"; |
|
| 931 | 891 |
CREATE TABLE "taxon_presence" ( |
| 932 | 892 |
"id" varbinary(767) NOT NULL, |
| 933 | 893 |
"taxon_concept" varbinary(767) NOT NULL, |
| ... | ... | |
| 949 | 909 |
-- Table structure for table "taxon_string" |
| 950 | 910 |
-- |
| 951 | 911 |
|
| 952 |
DROP TABLE IF EXISTS "taxon_string"; |
|
| 953 | 912 |
CREATE TABLE "taxon_string" ( |
| 954 | 913 |
"string" varbinary(767) NOT NULL, |
| 955 | 914 |
"parsed_taxon_assertion" varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 969 | 928 |
-- Table structure for table "validatable_place" |
| 970 | 929 |
-- |
| 971 | 930 |
|
| 972 |
DROP TABLE IF EXISTS "validatable_place"; |
|
| 973 | 931 |
CREATE TABLE "validatable_place" ( |
| 974 | 932 |
"id" varbinary(767) NOT NULL, |
| 975 | 933 |
"coordinates" varbinary(767) NOT NULL, |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb.run: VegCore.my.sql/make (): leave out the DROP TABLE statements for now using --skip-add-drop-table