Revision 10443
Added by Aaron Marcuse-Kubitza almost 11 years ago
MySQL.schema.sql | ||
---|---|---|
1 | 1 |
SET standard_conforming_strings = off; |
2 | 2 |
SET escape_string_warning = off; |
3 |
SET standard_conforming_strings = off; |
|
4 |
SET escape_string_warning = off; |
|
5 | 3 |
-- MySQL dump 10.13 Distrib 5.1.66, for debian-linux-gnu (x86_64) |
6 | 4 |
-- |
7 | 5 |
-- Host: localhost Database: ua_herbarium |
... | ... | |
45 | 43 |
"collnumsuffix" varchar(10) DEFAULT NULL, |
46 | 44 |
"collnumber_full" varchar(100) DEFAULT NULL, |
47 | 45 |
"other_collectors" varchar(200) DEFAULT NULL, |
48 |
"date_collected" date DEFAULT NULL,
|
|
46 |
"date_collected" text/*date*/ DEFAULT NULL,
|
|
49 | 47 |
"month_collected" varchar(15) DEFAULT NULL, |
50 | 48 |
"day_collected" integer DEFAULT NULL, |
51 | 49 |
"year_collected" integer DEFAULT NULL, |
... | ... | |
84 | 82 |
"project" varchar(50) DEFAULT NULL, |
85 | 83 |
"dups_to" varchar(180) DEFAULT NULL, |
86 | 84 |
"herb_acro" varchar(50) DEFAULT NULL, |
87 |
"datelastmodified" timestamp NOT NULL,
|
|
85 |
"datelastmodified" text/*datetime*/ NOT NULL,
|
|
88 | 86 |
"entered_by" varchar(60) DEFAULT NULL, |
89 | 87 |
"download_source" varchar(50) DEFAULT NULL, |
90 | 88 |
"old_dbsn" integer DEFAULT NULL, |
... | ... | |
94 | 92 |
"land_ownership" varchar(100) DEFAULT NULL, |
95 | 93 |
"coord_source" varchar(100) DEFAULT NULL, |
96 | 94 |
"georeferenceverificationstatus" varchar(150) DEFAULT NULL, |
97 |
"date_entered" timestamp NOT NULL DEFAULT '-infinity',
|
|
95 |
"date_entered" text/*timestamp*/ NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
98 | 96 |
"is_duplicate" integer DEFAULT NULL, |
99 | 97 |
"deleted" integer NOT NULL DEFAULT '0', |
100 | 98 |
"deleted_reason" varchar(250) DEFAULT NULL, |
101 |
"determination_date" date DEFAULT NULL,
|
|
99 |
"determination_date" text/*date*/ DEFAULT NULL,
|
|
102 | 100 |
"det_day" integer DEFAULT NULL, |
103 | 101 |
"det_mo" integer DEFAULT NULL, |
104 | 102 |
"det_yr" integer DEFAULT NULL, |
... | ... | |
130 | 128 |
"parentid" integer NOT NULL, |
131 | 129 |
"tid" integer DEFAULT NULL, |
132 | 130 |
"notes" varchar(250) DEFAULT NULL, |
133 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
131 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
134 | 132 |
PRIMARY KEY ("stmtid"), |
135 | 133 |
/*KEY "FK_chotomouskey_taxa" ("tid")*/CHECK (true), |
136 | 134 |
/*CONSTRAINT "FK_chotomouskey_taxa" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID")*/CHECK (true) |
... | ... | |
166 | 164 |
"uid" integer DEFAULT NULL, |
167 | 165 |
"SortSequence" integer NOT NULL DEFAULT '50', |
168 | 166 |
"expiration" integer DEFAULT NULL, |
169 |
"DateLastModified" timestamp DEFAULT NULL,
|
|
170 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
167 |
"DateLastModified" text/*datetime*/ DEFAULT NULL,
|
|
168 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
171 | 169 |
PRIMARY KEY ("CLID"), |
172 | 170 |
/*KEY "FK_checklists_uid" ("uid")*/CHECK (true), |
173 | 171 |
/*KEY "name" ("Name","Type")*/CHECK (true), |
... | ... | |
189 | 187 |
"decimallatitude" double precision NOT NULL, |
190 | 188 |
"decimallongitude" double precision NOT NULL, |
191 | 189 |
"notes" varchar(250) DEFAULT NULL, |
192 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
190 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
193 | 191 |
PRIMARY KEY ("chklstcoordid"), |
194 | 192 |
/*CONSTRAINT "IndexUnique" */UNIQUE ("clid","tid","decimallatitude","decimallongitude"), |
195 | 193 |
/*KEY "FKchklsttaxalink" ("clid","tid")*/CHECK (true), |
... | ... | |
207 | 205 |
CREATE TABLE "fmchklstprojlink" ( |
208 | 206 |
"pid" integer NOT NULL, |
209 | 207 |
"clid" integer NOT NULL, |
210 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
208 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
211 | 209 |
PRIMARY KEY ("pid","clid"), |
212 | 210 |
/*KEY "FK_chklst" ("clid")*/CHECK (true), |
213 | 211 |
/*CONSTRAINT "FK_chklstprojlink_clid" FOREIGN KEY ("clid") REFERENCES "fmchecklists" ("CLID")*/CHECK (true), |
... | ... | |
235 | 233 |
"Nativity" varchar(50) DEFAULT NULL, |
236 | 234 |
"Endemic" varchar(25) DEFAULT NULL, |
237 | 235 |
"internalnotes" varchar(250) DEFAULT NULL, |
238 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
236 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
239 | 237 |
PRIMARY KEY ("TID","CLID","morphospecies"), |
240 | 238 |
/*KEY "FK_chklsttaxalink_cid" ("CLID")*/CHECK (true), |
241 | 239 |
/*CONSTRAINT "FK_chklsttaxalink_cid" FOREIGN KEY ("CLID") REFERENCES "fmchecklists" ("CLID")*/CHECK (true), |
... | ... | |
258 | 256 |
"uid" integer NOT NULL, |
259 | 257 |
"ispublic" integer NOT NULL DEFAULT '1', |
260 | 258 |
"parentid" integer DEFAULT NULL, |
261 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
259 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
262 | 260 |
PRIMARY KEY ("cltaxacommentsid"), |
263 | 261 |
/*KEY "FK_clcomment_users" ("uid")*/CHECK (true), |
264 | 262 |
/*KEY "FK_clcomment_cltaxa" ("clid","tid")*/CHECK (true), |
... | ... | |
281 | 279 |
"uid" varchar(45) DEFAULT NULL, |
282 | 280 |
"type" varchar(45) NOT NULL DEFAULT 'DynamicList', |
283 | 281 |
"notes" varchar(250) DEFAULT NULL, |
284 |
"expiration" timestamp NOT NULL,
|
|
285 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
282 |
"expiration" text/*datetime*/ NOT NULL,
|
|
283 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
286 | 284 |
PRIMARY KEY ("dynclid") |
287 | 285 |
); |
288 | 286 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
297 | 295 |
CREATE TABLE "fmdyncltaxalink" ( |
298 | 296 |
"dynclid" integer NOT NULL, |
299 | 297 |
"tid" integer NOT NULL, |
300 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
298 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
301 | 299 |
PRIMARY KEY ("dynclid","tid"), |
302 | 300 |
/*KEY "FK_dyncltaxalink_taxa" ("tid")*/CHECK (true), |
303 | 301 |
/*CONSTRAINT "FK_dyncltaxalink_dynclid" FOREIGN KEY ("dynclid") REFERENCES "fmdynamicchecklists" ("dynclid") ON DELETE CASCADE*/CHECK (true), |
... | ... | |
324 | 322 |
"ispublic" integer NOT NULL DEFAULT '0', |
325 | 323 |
"parentpid" integer DEFAULT NULL, |
326 | 324 |
"SortSequence" integer NOT NULL DEFAULT '50', |
327 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
325 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
328 | 326 |
PRIMARY KEY ("pid"), |
329 | 327 |
/*KEY "FK_parentpid_proj" ("parentpid")*/CHECK (true), |
330 | 328 |
/*CONSTRAINT "FK_parentpid_proj" FOREIGN KEY ("parentpid") REFERENCES "fmprojects" ("pid") ON DELETE NO ACTION ON UPDATE NO ACTION*/CHECK (true) |
... | ... | |
345 | 343 |
"Collector" varchar(100) NOT NULL, |
346 | 344 |
"editornotes" varchar(50) DEFAULT NULL, |
347 | 345 |
"Notes" varchar(250) DEFAULT NULL, |
348 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
346 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
349 | 347 |
PRIMARY KEY ("occid","CLID","TID"), |
350 | 348 |
/*KEY "chklst_taxavouchers" ("TID","CLID")*/CHECK (true), |
351 | 349 |
/*CONSTRAINT "FK_fmvouchers_occ" FOREIGN KEY ("occid") REFERENCES "omoccurrences" ("occid")*/CHECK (true), |
... | ... | |
367 | 365 |
"code" varchar(45) DEFAULT NULL, |
368 | 366 |
"lookupterm" integer NOT NULL DEFAULT '1', |
369 | 367 |
"acceptedid" integer DEFAULT NULL, |
370 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
368 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
371 | 369 |
PRIMARY KEY ("gtcid"), |
372 | 370 |
/*KEY "FK_geothescontinent_accepted_idx" ("acceptedid")*/CHECK (true), |
373 | 371 |
/*CONSTRAINT "FK_geothescontinent_accepted" FOREIGN KEY ("acceptedid") REFERENCES "geothescontinent" ("gtcid")*/CHECK (true) |
... | ... | |
391 | 389 |
"lookupterm" integer NOT NULL DEFAULT '1', |
392 | 390 |
"acceptedid" integer DEFAULT NULL, |
393 | 391 |
"continentid" integer DEFAULT NULL, |
394 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
392 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
395 | 393 |
PRIMARY KEY ("gtcid"), |
396 | 394 |
/*KEY "FK_geothescountry__idx" ("continentid")*/CHECK (true), |
397 | 395 |
/*KEY "FK_geothescountry_parent_idx" ("acceptedid")*/CHECK (true), |
... | ... | |
415 | 413 |
"lookupterm" integer NOT NULL DEFAULT '1', |
416 | 414 |
"acceptedid" integer DEFAULT NULL, |
417 | 415 |
"stateid" integer DEFAULT NULL, |
418 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
416 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
419 | 417 |
PRIMARY KEY ("gtcoid"), |
420 | 418 |
/*KEY "FK_geothescounty_state_idx" ("stateid")*/CHECK (true), |
421 | 419 |
/*KEY "FK_geothescounty_accepted_idx" ("acceptedid")*/CHECK (true), |
... | ... | |
439 | 437 |
"lookupterm" integer NOT NULL DEFAULT '1', |
440 | 438 |
"acceptedid" integer DEFAULT NULL, |
441 | 439 |
"countyid" integer DEFAULT NULL, |
442 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
440 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
443 | 441 |
PRIMARY KEY ("gtmid"), |
444 | 442 |
/*KEY "FK_geothesmunicipality_county_idx" ("countyid")*/CHECK (true), |
445 | 443 |
/*KEY "FK_geothesmunicipality_accepted_idx" ("acceptedid")*/CHECK (true), |
... | ... | |
463 | 461 |
"lookupterm" integer NOT NULL DEFAULT '1', |
464 | 462 |
"acceptedid" integer DEFAULT NULL, |
465 | 463 |
"countryid" integer DEFAULT NULL, |
466 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
464 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
467 | 465 |
PRIMARY KEY ("gtspid"), |
468 | 466 |
/*KEY "FK_geothesstate_country_idx" ("countryid")*/CHECK (true), |
469 | 467 |
/*KEY "FK_geothesstate_accepted_idx" ("acceptedid")*/CHECK (true), |
... | ... | |
487 | 485 |
"source" varchar(45) DEFAULT NULL, |
488 | 486 |
"notes" varchar(250) DEFAULT NULL, |
489 | 487 |
"uid" integer DEFAULT NULL, |
490 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
488 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
491 | 489 |
PRIMARY KEY ("glossid"), |
492 | 490 |
/*CONSTRAINT "Index_term" */UNIQUE ("term") |
493 | 491 |
); |
... | ... | |
504 | 502 |
"catid" integer NOT NULL, |
505 | 503 |
"catagory" varchar(45) NOT NULL, |
506 | 504 |
"language" varchar(45) NOT NULL DEFAULT 'English', |
507 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
505 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
508 | 506 |
PRIMARY KEY ("catid") |
509 | 507 |
); |
510 | 508 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
519 | 517 |
CREATE TABLE "glossarycatlink" ( |
520 | 518 |
"glossid" integer NOT NULL, |
521 | 519 |
"catid" integer NOT NULL, |
522 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
520 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
523 | 521 |
PRIMARY KEY ("glossid","catid"), |
524 | 522 |
/*KEY "FK_glossarycatlink_cat" ("catid")*/CHECK (true), |
525 | 523 |
/*CONSTRAINT "glossarycatlink_ibfk_1" FOREIGN KEY ("catid") REFERENCES "glossarycatagories" ("catid")*/CHECK (true), |
... | ... | |
541 | 539 |
"structures" varchar(150) DEFAULT NULL, |
542 | 540 |
"notes" varchar(250) DEFAULT NULL, |
543 | 541 |
"uid" integer DEFAULT NULL, |
544 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
542 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
545 | 543 |
PRIMARY KEY ("glimgid"), |
546 | 544 |
/*KEY "FK_glossaryimages_gloss" ("glossid")*/CHECK (true), |
547 | 545 |
/*CONSTRAINT "glossaryimages_ibfk_1" FOREIGN KEY ("glossid") REFERENCES "glossary" ("glossid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
558 | 556 |
CREATE TABLE "imageannotations" ( |
559 | 557 |
"tid" integer DEFAULT NULL, |
560 | 558 |
"imgid" integer NOT NULL DEFAULT '0', |
561 |
"AnnDate" timestamp NOT NULL DEFAULT '-infinity',
|
|
559 |
"AnnDate" text/*datetime*/ NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
562 | 560 |
"Annotator" varchar(100) DEFAULT NULL, |
563 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
561 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
564 | 562 |
PRIMARY KEY ("imgid","AnnDate"), |
565 | 563 |
/*KEY "TID" ("tid")*/CHECK (true), |
566 | 564 |
/*CONSTRAINT "FK_resourceannotations_imgid" FOREIGN KEY ("imgid") REFERENCES "images" ("imgid")*/CHECK (true), |
... | ... | |
594 | 592 |
"anatomy" varchar(100) DEFAULT NULL, |
595 | 593 |
"username" varchar(45) DEFAULT NULL, |
596 | 594 |
"sortsequence" integer NOT NULL DEFAULT '50', |
597 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
595 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
598 | 596 |
PRIMARY KEY ("imgid"), |
599 | 597 |
/*KEY "Index_tid" ("tid")*/CHECK (true), |
600 | 598 |
/*KEY "FK_images_occ" ("occid")*/CHECK (true), |
... | ... | |
628 | 626 |
"Email" varchar(45) DEFAULT NULL, |
629 | 627 |
"Url" varchar(250) DEFAULT NULL, |
630 | 628 |
"Notes" varchar(250) DEFAULT NULL, |
631 |
"IntialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
629 |
"IntialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
632 | 630 |
PRIMARY KEY ("iid"), |
633 | 631 |
/*CONSTRAINT "Index_instcode" */UNIQUE ("InstitutionCode") |
634 | 632 |
); |
... | ... | |
648 | 646 |
"notes" varchar(255) DEFAULT NULL, |
649 | 647 |
"description" varchar(255) DEFAULT NULL, |
650 | 648 |
"helpurl" varchar(500) DEFAULT NULL, |
651 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
649 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
652 | 650 |
PRIMARY KEY ("cid","language"), |
653 | 651 |
/*CONSTRAINT "kmcharacterlang_ibfk_1" FOREIGN KEY ("cid") REFERENCES "kmcharacters" ("cid")*/CHECK (true) |
654 | 652 |
); |
... | ... | |
674 | 672 |
"helpurl" varchar(500) DEFAULT NULL, |
675 | 673 |
"enteredby" varchar(45) DEFAULT NULL, |
676 | 674 |
"sortsequence" integer DEFAULT NULL, |
677 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
675 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
678 | 676 |
PRIMARY KEY ("cid"), |
679 | 677 |
/*KEY "Index_charname" ("charname")*/CHECK (true), |
680 | 678 |
/*KEY "Index_sort" ("sortsequence")*/CHECK (true) |
... | ... | |
692 | 690 |
"CID" integer NOT NULL, |
693 | 691 |
"CIDDependance" integer NOT NULL, |
694 | 692 |
"CSDependance" varchar(16) NOT NULL, |
695 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
693 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
696 | 694 |
PRIMARY KEY ("CSDependance","CIDDependance","CID"), |
697 | 695 |
/*KEY "FK_chardependance_cid" ("CID")*/CHECK (true), |
698 | 696 |
/*KEY "FK_chardependance_2" ("CIDDependance")*/CHECK (true), |
... | ... | |
714 | 712 |
"language" varchar(45) NOT NULL DEFAULT 'English', |
715 | 713 |
"notes" text, |
716 | 714 |
"sortsequence" integer DEFAULT NULL, |
717 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
715 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
718 | 716 |
PRIMARY KEY ("hid","language"), |
719 | 717 |
/*KEY "HeadingName" ("headingname")*/CHECK (true) |
720 | 718 |
); |
... | ... | |
731 | 729 |
"HID" integer NOT NULL DEFAULT '0', |
732 | 730 |
"CID" integer NOT NULL DEFAULT '0', |
733 | 731 |
"Notes" varchar(255) DEFAULT NULL, |
734 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
732 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
735 | 733 |
PRIMARY KEY ("HID","CID"), |
736 | 734 |
/*KEY "CharactersCharHeadingLinker" ("CID")*/CHECK (true), |
737 | 735 |
/*KEY "CharHeadingCharHeadingLinker" ("HID")*/CHECK (true), |
... | ... | |
755 | 753 |
"Notes" varchar(255) DEFAULT NULL, |
756 | 754 |
"Relation" varchar(45) NOT NULL DEFAULT 'include', |
757 | 755 |
"EditabilityInherited" bit(1) DEFAULT NULL, |
758 |
"timestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
756 |
"timestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
759 | 757 |
PRIMARY KEY ("CID","TID"), |
760 | 758 |
/*KEY "FK_CharTaxaLink-TID" ("TID")*/CHECK (true), |
761 | 759 |
/*CONSTRAINT "kmchartaxalink_ibfk_1" FOREIGN KEY ("CID") REFERENCES "kmcharacters" ("cid")*/CHECK (true), |
... | ... | |
781 | 779 |
"StateID" integer DEFAULT NULL, |
782 | 780 |
"Language" varchar(45) NOT NULL DEFAULT 'English', |
783 | 781 |
"SortSequence" integer DEFAULT NULL, |
784 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
782 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
785 | 783 |
"EnteredBy" varchar(45) DEFAULT NULL, |
786 | 784 |
PRIMARY KEY ("cs","cid"), |
787 | 785 |
/*KEY "FK_cs_chars" ("cid")*/CHECK (true), |
... | ... | |
804 | 802 |
"notes" varchar(250) DEFAULT NULL, |
805 | 803 |
"sortsequence" varchar(45) NOT NULL DEFAULT '50', |
806 | 804 |
"username" varchar(45) DEFAULT NULL, |
807 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
805 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
808 | 806 |
PRIMARY KEY ("csimgid") |
809 | 807 |
); |
810 | 808 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
823 | 821 |
"language" varchar(45) NOT NULL, |
824 | 822 |
"description" varchar(255) DEFAULT NULL, |
825 | 823 |
"notes" varchar(255) DEFAULT NULL, |
826 |
"intialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
824 |
"intialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
827 | 825 |
PRIMARY KEY ("cid","cs","language"), |
828 | 826 |
/*CONSTRAINT "kmcslang_ibfk_1" FOREIGN KEY ("cid", "cs") REFERENCES "kmcs" ("cid", "cs")*/CHECK (true) |
829 | 827 |
); |
... | ... | |
849 | 847 |
"Source" varchar(100) DEFAULT NULL, |
850 | 848 |
"Seq" integer DEFAULT NULL, |
851 | 849 |
"Notes" text, |
852 |
"DateEntered" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
850 |
"DateEntered" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
853 | 851 |
PRIMARY KEY ("TID","CID","CS"), |
854 | 852 |
/*KEY "CSDescr" ("CID","CS")*/CHECK (true), |
855 | 853 |
/*CONSTRAINT "kmdescr_ibfk_1" FOREIGN KEY ("CID", "CS") REFERENCES "kmcs" ("cid", "cs")*/CHECK (true), |
... | ... | |
875 | 873 |
"Source" varchar(100) DEFAULT NULL, |
876 | 874 |
"Seq" integer DEFAULT NULL, |
877 | 875 |
"Notes" text, |
878 |
"InitialTimeStamp" timestamp DEFAULT NULL,
|
|
876 |
"InitialTimeStamp" text/*datetime*/ DEFAULT NULL,
|
|
879 | 877 |
"DeletedBy" varchar(100) NOT NULL, |
880 |
"DeletedTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
878 |
"DeletedTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
881 | 879 |
"PK" integer NOT NULL, |
882 | 880 |
PRIMARY KEY ("PK") |
883 | 881 |
); |
... | ... | |
896 | 894 |
"iso" varchar(2) DEFAULT NULL, |
897 | 895 |
"iso3" varchar(3) DEFAULT NULL, |
898 | 896 |
"numcode" integer DEFAULT NULL, |
899 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
897 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
900 | 898 |
PRIMARY KEY ("countryId"), |
901 | 899 |
/*CONSTRAINT "country_unique" */UNIQUE ("countryName") |
902 | 900 |
); |
... | ... | |
913 | 911 |
"countyId" integer NOT NULL, |
914 | 912 |
"stateId" integer NOT NULL, |
915 | 913 |
"countyName" varchar(100) NOT NULL, |
916 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
914 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
917 | 915 |
PRIMARY KEY ("countyId"), |
918 | 916 |
/*CONSTRAINT "unique_county" */UNIQUE ("stateId","countyName"), |
919 | 917 |
/*KEY "fk_stateprovince" ("stateId")*/CHECK (true), |
... | ... | |
934 | 932 |
"countryId" integer NOT NULL, |
935 | 933 |
"stateName" varchar(100) NOT NULL, |
936 | 934 |
"abbrev" varchar(2) DEFAULT NULL, |
937 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
935 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
938 | 936 |
PRIMARY KEY ("stateId"), |
939 | 937 |
/*CONSTRAINT "state_index" */UNIQUE ("stateName","countryId"), |
940 | 938 |
/*KEY "fk_country" ("countryId")*/CHECK (true), |
... | ... | |
958 | 956 |
"identifier" varchar(250) DEFAULT NULL, |
959 | 957 |
"resourceurl" varchar(250) DEFAULT NULL, |
960 | 958 |
"notes" varchar(250) DEFAULT NULL, |
961 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
959 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
962 | 960 |
PRIMARY KEY ("aoid") |
963 | 961 |
); |
964 | 962 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
973 | 971 |
CREATE TABLE "omcollcatagories" ( |
974 | 972 |
"ccpk" integer NOT NULL, |
975 | 973 |
"catagory" varchar(45) NOT NULL, |
976 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
974 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
977 | 975 |
PRIMARY KEY ("ccpk") |
978 | 976 |
); |
979 | 977 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
989 | 987 |
"ccpk" integer NOT NULL, |
990 | 988 |
"collid" integer NOT NULL, |
991 | 989 |
"sortsequence" integer DEFAULT NULL, |
992 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
990 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
993 | 991 |
PRIMARY KEY ("ccpk","collid"), |
994 | 992 |
/*KEY "FK_collcatlink_coll" ("collid")*/CHECK (true), |
995 | 993 |
/*CONSTRAINT "FK_collcatlink_cat" FOREIGN KEY ("ccpk") REFERENCES "omcollcatagories" ("ccpk") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
... | ... | |
1028 | 1026 |
"bibliographicCitation" varchar(1000) DEFAULT NULL, |
1029 | 1027 |
"accessrights" varchar(250) DEFAULT NULL, |
1030 | 1028 |
"SortSeq" integer DEFAULT NULL, |
1031 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1029 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1032 | 1030 |
PRIMARY KEY ("CollID"), |
1033 | 1031 |
/*KEY "Index_inst" ("InstitutionCode")*/CHECK (true) |
1034 | 1032 |
); |
... | ... | |
1048 | 1046 |
"familycnt" integer DEFAULT NULL, |
1049 | 1047 |
"genuscnt" integer DEFAULT NULL, |
1050 | 1048 |
"speciescnt" integer DEFAULT NULL, |
1051 |
"uploaddate" timestamp DEFAULT NULL,
|
|
1049 |
"uploaddate" text/*datetime*/ DEFAULT NULL,
|
|
1052 | 1050 |
"uploadedby" varchar(45) DEFAULT NULL, |
1053 | 1051 |
"dbtype" varchar(45) DEFAULT NULL, |
1054 | 1052 |
"dburl" varchar(250) DEFAULT NULL, |
1055 | 1053 |
"dbport" varchar(45) DEFAULT NULL, |
1056 | 1054 |
"dblogin" varchar(45) DEFAULT NULL, |
1057 | 1055 |
"dbpassword" varchar(45) DEFAULT NULL, |
1058 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1056 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1059 | 1057 |
PRIMARY KEY ("collid"), |
1060 | 1058 |
/*CONSTRAINT "omcollectionstats_ibfk_1" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID")*/CHECK (true) |
1061 | 1059 |
); |
... | ... | |
1077 | 1075 |
"endyearactive" integer DEFAULT NULL, |
1078 | 1076 |
"notes" varchar(255) DEFAULT NULL, |
1079 | 1077 |
"rating" integer DEFAULT '10', |
1080 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1078 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1081 | 1079 |
PRIMARY KEY ("recordedById"), |
1082 | 1080 |
/*KEY "fullname" ("familyname","firstname")*/CHECK (true) |
1083 | 1081 |
); |
... | ... | |
1107 | 1105 |
"icon" varchar(250) DEFAULT NULL, |
1108 | 1106 |
"CollType" varchar(45) DEFAULT NULL, |
1109 | 1107 |
"SortSeq" integer DEFAULT NULL, |
1110 |
"InitialTimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1108 |
"InitialTimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1111 | 1109 |
PRIMARY KEY ("ocsid"), |
1112 | 1110 |
/*KEY "FK_omcollsecondary_coll" ("collid")*/CHECK (true), |
1113 | 1111 |
/*CONSTRAINT "FK_omcollsecondary_coll" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
1128 | 1126 |
"trainingurl" varchar(500) DEFAULT NULL, |
1129 | 1127 |
"editorlevel" integer NOT NULL DEFAULT '0', |
1130 | 1128 |
"notes" varchar(250) DEFAULT NULL, |
1131 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1129 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1132 | 1130 |
PRIMARY KEY ("omcsid"), |
1133 | 1131 |
/*CONSTRAINT "Index_omcrowdsourcecentral_collid" */UNIQUE ("collid"), |
1134 | 1132 |
/*KEY "FK_omcrowdsourcecentral_collid" ("collid")*/CHECK (true), |
... | ... | |
1151 | 1149 |
"uidprocessor" integer DEFAULT NULL, |
1152 | 1150 |
"points" integer DEFAULT NULL, |
1153 | 1151 |
"notes" varchar(250) DEFAULT NULL, |
1154 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1152 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1155 | 1153 |
PRIMARY KEY ("idomcrowdsourcequeue"), |
1156 | 1154 |
/*CONSTRAINT "Index_omcrowdsource_occid" */UNIQUE ("occid"), |
1157 | 1155 |
/*KEY "FK_omcrowdsourcequeue_occid" ("occid")*/CHECK (true), |
... | ... | |
1173 | 1171 |
"exsnumber" varchar(45) NOT NULL, |
1174 | 1172 |
"ometid" integer NOT NULL, |
1175 | 1173 |
"notes" varchar(250) DEFAULT NULL, |
1176 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1174 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1177 | 1175 |
PRIMARY KEY ("omenid"), |
1178 | 1176 |
/*CONSTRAINT "Index_omexsiccatinumbers_unique" */UNIQUE ("exsnumber","ometid"), |
1179 | 1177 |
/*KEY "FK_exsiccatiTitleNumber" ("ometid")*/CHECK (true), |
... | ... | |
1193 | 1191 |
"occid" integer NOT NULL, |
1194 | 1192 |
"ranking" integer NOT NULL DEFAULT '50', |
1195 | 1193 |
"notes" varchar(250) DEFAULT NULL, |
1196 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1194 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1197 | 1195 |
PRIMARY KEY ("omenid","occid"), |
1198 | 1196 |
/*CONSTRAINT "UniqueOmexsiccatiOccLink" */UNIQUE ("occid"), |
1199 | 1197 |
/*KEY "FKExsiccatiNumOccLink1" ("omenid")*/CHECK (true), |
... | ... | |
1221 | 1219 |
"source" varchar(45) DEFAULT NULL, |
1222 | 1220 |
"notes" varchar(2000) DEFAULT NULL, |
1223 | 1221 |
"lasteditedby" varchar(45) DEFAULT NULL, |
1224 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1222 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1225 | 1223 |
PRIMARY KEY ("ometid"), |
1226 | 1224 |
/*KEY "index_exsiccatiTitle" ("title")*/CHECK (true) |
1227 | 1225 |
); |
... | ... | |
1241 | 1239 |
"uid" integer NOT NULL, |
1242 | 1240 |
"reviewstatus" integer NOT NULL DEFAULT '0', |
1243 | 1241 |
"parentcomid" integer DEFAULT NULL, |
1244 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1242 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1245 | 1243 |
PRIMARY KEY ("comid"), |
1246 | 1244 |
/*KEY "fk_omoccurcomments_occid" ("occid")*/CHECK (true), |
1247 | 1245 |
/*KEY "fk_omoccurcomments_uid" ("uid")*/CHECK (true), |
... | ... | |
1261 | 1259 |
"occid" integer NOT NULL, |
1262 | 1260 |
"datasetid" integer NOT NULL, |
1263 | 1261 |
"notes" varchar(250) DEFAULT NULL, |
1264 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1262 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1265 | 1263 |
PRIMARY KEY ("occid","datasetid"), |
1266 | 1264 |
/*KEY "FK_omoccurdatasetlink_datasetid" ("datasetid")*/CHECK (true), |
1267 | 1265 |
/*KEY "FK_omoccurdatasetlink_occid" ("occid")*/CHECK (true), |
... | ... | |
1283 | 1281 |
"notes" varchar(250) DEFAULT NULL, |
1284 | 1282 |
"sortsequence" integer DEFAULT NULL, |
1285 | 1283 |
"uid" integer NOT NULL, |
1286 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1284 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1287 | 1285 |
PRIMARY KEY ("datasetid") |
1288 | 1286 |
); |
1289 | 1287 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
1309 | 1307 |
"identificationReferences" varchar(255) DEFAULT NULL, |
1310 | 1308 |
"identificationRemarks" varchar(255) DEFAULT NULL, |
1311 | 1309 |
"sortsequence" integer DEFAULT '10', |
1312 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1310 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1313 | 1311 |
PRIMARY KEY ("detid"), |
1314 | 1312 |
/*CONSTRAINT "Index_unique" */UNIQUE ("occid","dateIdentified","identifiedBy"), |
1315 | 1313 |
/*KEY "FK_omoccurdets_tid" ("tidinterpreted")*/CHECK (true), |
... | ... | |
1334 | 1332 |
"isExsiccata" integer NOT NULL DEFAULT '0', |
1335 | 1333 |
"exsiccataEditors" varchar(150) DEFAULT NULL, |
1336 | 1334 |
"notes" varchar(255) DEFAULT NULL, |
1337 |
"initialTimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1335 |
"initialTimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1338 | 1336 |
PRIMARY KEY ("duplicateid") |
1339 | 1337 |
); |
1340 | 1338 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
1350 | 1348 |
"occid" integer NOT NULL, |
1351 | 1349 |
"uid" integer NOT NULL, |
1352 | 1350 |
"ts" integer NOT NULL, |
1353 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1351 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1354 | 1352 |
PRIMARY KEY ("occid") |
1355 | 1353 |
); |
1356 | 1354 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
1371 | 1369 |
"ReviewStatus" integer NOT NULL DEFAULT '1', |
1372 | 1370 |
"AppliedStatus" integer NOT NULL DEFAULT '0', |
1373 | 1371 |
"uid" integer NOT NULL, |
1374 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1372 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1375 | 1373 |
PRIMARY KEY ("ocedid"), |
1376 | 1374 |
/*KEY "fk_omoccuredits_uid" ("uid")*/CHECK (true), |
1377 | 1375 |
/*KEY "fk_omoccuredits_occid" ("occid")*/CHECK (true), |
... | ... | |
1394 | 1392 |
"iid" integer DEFAULT NULL, |
1395 | 1393 |
"transactionType" varchar(10) DEFAULT NULL, |
1396 | 1394 |
"in_out" varchar(3) DEFAULT NULL, |
1397 |
"dateSent" date DEFAULT NULL,
|
|
1398 |
"dateReceived" date DEFAULT NULL,
|
|
1395 |
"dateSent" text/*date*/ DEFAULT NULL,
|
|
1396 |
"dateReceived" text/*date*/ DEFAULT NULL,
|
|
1399 | 1397 |
"totalBoxes" integer DEFAULT NULL, |
1400 | 1398 |
"shippingMethod" varchar(50) DEFAULT NULL, |
1401 | 1399 |
"totalExMounted" integer DEFAULT NULL, |
... | ... | |
1408 | 1406 |
"description" varchar(1000) DEFAULT NULL, |
1409 | 1407 |
"notes" varchar(500) DEFAULT NULL, |
1410 | 1408 |
"createdBy" varchar(20) DEFAULT NULL, |
1411 |
"initialTimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1409 |
"initialTimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1412 | 1410 |
PRIMARY KEY ("exchangeid"), |
1413 | 1411 |
/*KEY "FK_occexch_coll" ("collid")*/CHECK (true), |
1414 | 1412 |
/*CONSTRAINT "FK_occexch_coll" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
1448 | 1446 |
"tid" integer NOT NULL, |
1449 | 1447 |
"decimallatitude" double precision NOT NULL, |
1450 | 1448 |
"decimallongitude" double precision NOT NULL, |
1451 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1449 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1452 | 1450 |
PRIMARY KEY ("tid","decimallatitude","decimallongitude"), |
1453 | 1451 |
/*CONSTRAINT "FK_specgeoindex_taxa" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
1454 | 1452 |
); |
... | ... | |
1469 | 1467 |
"collidBorr" integer DEFAULT NULL, |
1470 | 1468 |
"iidOwner" integer DEFAULT NULL, |
1471 | 1469 |
"iidBorrower" integer DEFAULT NULL, |
1472 |
"dateSent" date DEFAULT NULL,
|
|
1473 |
"dateSentReturn" date DEFAULT NULL,
|
|
1470 |
"dateSent" text/*date*/ DEFAULT NULL,
|
|
1471 |
"dateSentReturn" text/*date*/ DEFAULT NULL,
|
|
1474 | 1472 |
"receivedStatus" varchar(250) DEFAULT NULL, |
1475 | 1473 |
"totalBoxes" integer DEFAULT NULL, |
1476 | 1474 |
"totalBoxesReturned" integer DEFAULT NULL, |
1477 | 1475 |
"numSpecimens" integer DEFAULT NULL, |
1478 | 1476 |
"shippingMethod" varchar(50) DEFAULT NULL, |
1479 | 1477 |
"shippingMethodReturn" varchar(50) DEFAULT NULL, |
1480 |
"dateDue" date DEFAULT NULL,
|
|
1481 |
"dateReceivedOwn" date DEFAULT NULL,
|
|
1482 |
"dateReceivedBorr" date DEFAULT NULL,
|
|
1483 |
"dateClosed" date DEFAULT NULL,
|
|
1478 |
"dateDue" text/*date*/ DEFAULT NULL,
|
|
1479 |
"dateReceivedOwn" text/*date*/ DEFAULT NULL,
|
|
1480 |
"dateReceivedBorr" text/*date*/ DEFAULT NULL,
|
|
1481 |
"dateClosed" text/*date*/ DEFAULT NULL,
|
|
1484 | 1482 |
"forWhom" varchar(50) DEFAULT NULL, |
1485 | 1483 |
"description" varchar(1000) DEFAULT NULL, |
1486 | 1484 |
"invoiceMessageOwn" varchar(500) DEFAULT NULL, |
... | ... | |
1493 | 1491 |
"processedByBorr" varchar(30) DEFAULT NULL, |
1494 | 1492 |
"processedByReturnOwn" varchar(30) DEFAULT NULL, |
1495 | 1493 |
"processedByReturnBorr" varchar(30) DEFAULT NULL, |
1496 |
"initialTimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1494 |
"initialTimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1497 | 1495 |
PRIMARY KEY ("loanid"), |
1498 | 1496 |
/*KEY "FK_occurloans_owninst" ("iidOwner")*/CHECK (true), |
1499 | 1497 |
/*KEY "FK_occurloans_borrinst" ("iidBorrower")*/CHECK (true), |
... | ... | |
1516 | 1514 |
CREATE TABLE "omoccurloanslink" ( |
1517 | 1515 |
"loanid" integer NOT NULL, |
1518 | 1516 |
"occid" integer NOT NULL, |
1519 |
"returndate" date DEFAULT NULL,
|
|
1517 |
"returndate" text/*date*/ DEFAULT NULL,
|
|
1520 | 1518 |
"notes" varchar(255) DEFAULT NULL, |
1521 |
"initialTimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1519 |
"initialTimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1522 | 1520 |
PRIMARY KEY ("loanid","occid"), |
1523 | 1521 |
/*KEY "FK_occurloanlink_occid" ("occid")*/CHECK (true), |
1524 | 1522 |
/*KEY "FK_occurloanlink_loanid" ("loanid")*/CHECK (true), |
... | ... | |
1568 | 1566 |
"recordNumber" varchar(45) DEFAULT NULL, |
1569 | 1567 |
"recordedById" integer DEFAULT NULL, |
1570 | 1568 |
"associatedCollectors" varchar(255) DEFAULT NULL, |
1571 |
"eventDate" date DEFAULT NULL,
|
|
1569 |
"eventDate" text/*date*/ DEFAULT NULL,
|
|
1572 | 1570 |
"year" integer DEFAULT NULL, |
1573 | 1571 |
"month" integer DEFAULT NULL, |
1574 | 1572 |
"day" integer DEFAULT NULL, |
... | ... | |
1623 | 1621 |
"disposition" varchar(100) DEFAULT NULL, |
1624 | 1622 |
"genericcolumn1" varchar(100) DEFAULT NULL, |
1625 | 1623 |
"genericcolumn2" varchar(100) DEFAULT NULL, |
1626 |
"modified" timestamp DEFAULT NULL,
|
|
1624 |
"modified" text/*datetime*/ DEFAULT NULL,
|
|
1627 | 1625 |
"language" varchar(20) DEFAULT NULL, |
1628 | 1626 |
"duplicateid" integer DEFAULT NULL, |
1629 | 1627 |
"observeruid" integer DEFAULT NULL, |
... | ... | |
1632 | 1630 |
"recordEnteredBy" varchar(250) DEFAULT NULL, |
1633 | 1631 |
"duplicateQuantity" integer DEFAULT NULL, |
1634 | 1632 |
"labelProject" varchar(50) DEFAULT NULL, |
1635 |
"dateLastModified" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1633 |
"dateLastModified" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1636 | 1634 |
PRIMARY KEY ("occid"), |
1637 | 1635 |
/*CONSTRAINT "Index_collid" */UNIQUE ("collid","dbpk"), |
1638 | 1636 |
/*KEY "Index_sciname" ("sciname")*/CHECK (true), |
... | ... | |
1676 | 1674 |
"source" varchar(45) DEFAULT NULL, |
1677 | 1675 |
"uid" integer DEFAULT NULL, |
1678 | 1676 |
"notes" varchar(250) DEFAULT NULL, |
1679 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1677 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1680 | 1678 |
PRIMARY KEY ("ovsid"), |
1681 | 1679 |
/*KEY "FK_omoccurverification_occid_idx" ("occid")*/CHECK (true), |
1682 | 1680 |
/*KEY "FK_omoccurverification_uid_idx" ("uid")*/CHECK (true), |
... | ... | |
1696 | 1694 |
"occid" integer NOT NULL, |
1697 | 1695 |
"surveyid" integer NOT NULL, |
1698 | 1696 |
"notes" varchar(250) DEFAULT NULL, |
1699 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1697 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1700 | 1698 |
PRIMARY KEY ("occid","surveyid"), |
1701 | 1699 |
/*KEY "FK_omsurveyoccurlink_sur" ("surveyid")*/CHECK (true), |
1702 | 1700 |
/*CONSTRAINT "FK_omsurveyoccurlink_occ" FOREIGN KEY ("occid") REFERENCES "omoccurrences" ("occid")*/CHECK (true), |
... | ... | |
1714 | 1712 |
CREATE TABLE "omsurveyprojlink" ( |
1715 | 1713 |
"surveyid" integer NOT NULL, |
1716 | 1714 |
"pid" integer NOT NULL, |
1717 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1715 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1718 | 1716 |
PRIMARY KEY ("surveyid","pid"), |
1719 | 1717 |
/*KEY "FK_specprojcatlink_cat" ("pid")*/CHECK (true), |
1720 | 1718 |
/*CONSTRAINT "FK_omsurveyprojlink_proj" FOREIGN KEY ("pid") REFERENCES "fmprojects" ("pid")*/CHECK (true), |
... | ... | |
1739 | 1737 |
"notes" varchar(250) DEFAULT NULL, |
1740 | 1738 |
"ispublic" integer NOT NULL DEFAULT '0', |
1741 | 1739 |
"sortsequence" integer NOT NULL DEFAULT '50', |
1742 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1740 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1743 | 1741 |
PRIMARY KEY ("surveyid") |
1744 | 1742 |
); |
1745 | 1743 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
1770 | 1768 |
"jpgcompression" integer DEFAULT '70', |
1771 | 1769 |
"createTnImg" integer DEFAULT '1', |
1772 | 1770 |
"createLgImg" integer DEFAULT '1', |
1773 |
"initialTimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1771 |
"initialTimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1774 | 1772 |
PRIMARY KEY ("spprid"), |
1775 | 1773 |
/*KEY "FK_specprocessorprojects_coll" ("collid")*/CHECK (true), |
1776 | 1774 |
/*CONSTRAINT "FK_specprocessorprojects_coll" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
1794 | 1792 |
"notes" varchar(255) DEFAULT NULL, |
1795 | 1793 |
"source" varchar(150) DEFAULT NULL, |
1796 | 1794 |
"sortsequence" integer DEFAULT NULL, |
1797 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1795 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1798 | 1796 |
PRIMARY KEY ("prlid"), |
1799 | 1797 |
/*KEY "FK_specproc_images" ("imgid")*/CHECK (true), |
1800 | 1798 |
/*KEY "FK_specproc_occid" ("occid")*/CHECK (true), |
... | ... | |
1817 | 1815 |
"patternmatch" varchar(250) DEFAULT NULL, |
1818 | 1816 |
"notes" varchar(250) DEFAULT NULL, |
1819 | 1817 |
"collid" integer NOT NULL, |
1820 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1818 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1821 | 1819 |
PRIMARY KEY ("spnlpid"), |
1822 | 1820 |
/*KEY "FK_specprocnlp_collid" ("collid")*/CHECK (true), |
1823 | 1821 |
/*CONSTRAINT "FK_specprocnlp_collid" FOREIGN KEY ("collid") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
1838 | 1836 |
"patternmatch" varchar(250) NOT NULL, |
1839 | 1837 |
"notes" varchar(250) DEFAULT NULL, |
1840 | 1838 |
"sortseq" integer DEFAULT '50', |
1841 |
"initialtimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1839 |
"initialtimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1842 | 1840 |
PRIMARY KEY ("spnlpfragid"), |
1843 | 1841 |
/*KEY "FK_specprocnlpfrag_spnlpid" ("spnlpid")*/CHECK (true), |
1844 | 1842 |
/*CONSTRAINT "FK_specprocnlpfrag_spnlpid" FOREIGN KEY ("spnlpid") REFERENCES "specprocnlp" ("spnlpid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
1865 | 1863 |
"UnitName3" varchar(35) DEFAULT NULL, |
1866 | 1864 |
"Author" varchar(100) DEFAULT NULL, |
1867 | 1865 |
"PhyloSortSequence" integer DEFAULT NULL, |
1868 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1866 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1869 | 1867 |
"Status" varchar(50) DEFAULT NULL, |
1870 | 1868 |
"Source" varchar(250) DEFAULT NULL, |
1871 | 1869 |
"Notes" varchar(250) DEFAULT NULL, |
... | ... | |
1899 | 1897 |
"displaylevel" integer NOT NULL DEFAULT '1', |
1900 | 1898 |
"uid" integer NOT NULL, |
1901 | 1899 |
"notes" varchar(250) DEFAULT NULL, |
1902 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1900 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1903 | 1901 |
PRIMARY KEY ("tdbid"), |
1904 | 1902 |
/*CONSTRAINT "Index_unique" */UNIQUE ("tid","displaylevel","language"), |
1905 | 1903 |
/*CONSTRAINT "taxadescrblock_ibfk_1" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID")*/CHECK (true) |
... | ... | |
1921 | 1919 |
"displayheader" integer NOT NULL DEFAULT '1', |
1922 | 1920 |
"notes" varchar(250) DEFAULT NULL, |
1923 | 1921 |
"sortsequence" integer NOT NULL DEFAULT '89', |
1924 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1922 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1925 | 1923 |
PRIMARY KEY ("tdsid"), |
1926 | 1924 |
/*KEY "FK_taxadescrstmts_tblock" ("tdbid")*/CHECK (true), |
1927 | 1925 |
/*CONSTRAINT "taxadescrstmts_ibfk_1" FOREIGN KEY ("tdbid") REFERENCES "taxadescrblock" ("tdbid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
1939 | 1937 |
"tid" integer NOT NULL, |
1940 | 1938 |
"taxauthid" integer NOT NULL, |
1941 | 1939 |
"parenttid" integer NOT NULL, |
1942 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1940 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1943 | 1941 |
PRIMARY KEY ("tid","taxauthid","parenttid"), |
1944 | 1942 |
/*KEY "FK_tet_taxa" ("tid")*/CHECK (true), |
1945 | 1943 |
/*KEY "FK_tet_taxauth" ("taxauthid")*/CHECK (true), |
... | ... | |
1967 | 1965 |
"icon" varchar(45) DEFAULT NULL, |
1968 | 1966 |
"notes" varchar(250) DEFAULT NULL, |
1969 | 1967 |
"sortsequence" integer NOT NULL DEFAULT '50', |
1970 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1968 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1971 | 1969 |
PRIMARY KEY ("tlid"), |
1972 | 1970 |
/*KEY "Index_unique" ("tid","url")*/CHECK (true), |
1973 | 1971 |
/*CONSTRAINT "taxalinks_ibfk_1" FOREIGN KEY ("tid") REFERENCES "taxa" ("TID")*/CHECK (true) |
... | ... | |
1998 | 1996 |
"green" integer DEFAULT NULL, |
1999 | 1997 |
"blue" integer DEFAULT NULL, |
2000 | 1998 |
"latadjustfactor" double precision NOT NULL DEFAULT '0', |
2001 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
1999 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2002 | 2000 |
PRIMARY KEY ("dmid") |
2003 | 2001 |
); |
2004 | 2002 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
2016 | 2014 |
"url" varchar(255) NOT NULL, |
2017 | 2015 |
"title" varchar(100) DEFAULT NULL, |
2018 | 2016 |
"dmid" integer DEFAULT NULL, |
2019 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2017 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2020 | 2018 |
PRIMARY KEY ("mid"), |
2021 | 2019 |
/*CONSTRAINT "Index_unique" */UNIQUE ("tid","dmid"), |
2022 | 2020 |
/*KEY "FK_taxamaps_dmid" ("dmid")*/CHECK (true), |
... | ... | |
2037 | 2035 |
"taxauthid" integer NOT NULL, |
2038 | 2036 |
"leftindex" integer NOT NULL, |
2039 | 2037 |
"rightindex" integer NOT NULL, |
2040 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2038 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2041 | 2039 |
PRIMARY KEY ("tid","taxauthid"), |
2042 | 2040 |
/*KEY "leftindex" ("leftindex")*/CHECK (true), |
2043 | 2041 |
/*KEY "rightindex" ("rightindex")*/CHECK (true), |
... | ... | |
2065 | 2063 |
"email" varchar(100) DEFAULT NULL, |
2066 | 2064 |
"notes" varchar(250) DEFAULT NULL, |
2067 | 2065 |
"isactive" integer NOT NULL DEFAULT '1', |
2068 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2066 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2069 | 2067 |
PRIMARY KEY ("taxauthid") |
2070 | 2068 |
); |
2071 | 2069 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
2087 | 2085 |
"isupperterm" integer DEFAULT '0', |
2088 | 2086 |
"SortSequence" integer DEFAULT '50', |
2089 | 2087 |
"VID" integer NOT NULL, |
2090 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2088 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2091 | 2089 |
PRIMARY KEY ("VID"), |
2092 | 2090 |
/*CONSTRAINT "unique-key" */UNIQUE ("Language","VernacularName","TID"), |
2093 | 2091 |
/*KEY "tid1" ("TID")*/CHECK (true), |
... | ... | |
2110 | 2108 |
"suffix" varchar(45) DEFAULT NULL, |
2111 | 2109 |
"dirparentrankid" integer NOT NULL, |
2112 | 2110 |
"reqparentrankid" integer DEFAULT NULL, |
2113 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2111 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2114 | 2112 |
PRIMARY KEY ("kingdomid","rankid") |
2115 | 2113 |
); |
2116 | 2114 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
2133 | 2131 |
"UnacceptabilityReason" varchar(45) DEFAULT NULL, |
2134 | 2132 |
"notes" varchar(250) DEFAULT NULL, |
2135 | 2133 |
"SortSequence" integer DEFAULT '50', |
2136 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2134 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2137 | 2135 |
PRIMARY KEY ("tid","tidaccepted","taxauthid"), |
2138 | 2136 |
/*KEY "FK_taxstatus_tidacc" ("tidaccepted")*/CHECK (true), |
2139 | 2137 |
/*KEY "FK_taxstatus_taid" ("taxauthid")*/CHECK (true), |
... | ... | |
2169 | 2167 |
"AssocSpp" text, |
2170 | 2168 |
"FirstColl" varchar(255) DEFAULT NULL, |
2171 | 2169 |
"CollNum" varchar(45) DEFAULT NULL, |
2172 |
"DateColl" date DEFAULT NULL,
|
|
2170 |
"DateColl" text/*date*/ DEFAULT NULL,
|
|
2173 | 2171 |
"Country" varchar(64) DEFAULT NULL, |
2174 | 2172 |
"State" varchar(255) DEFAULT NULL, |
2175 | 2173 |
"County" varchar(255) DEFAULT NULL, |
... | ... | |
2181 | 2179 |
"Elev" varchar(255) DEFAULT NULL, |
2182 | 2180 |
"Project" varchar(50) DEFAULT NULL, |
2183 | 2181 |
"Cataloger" varchar(250) DEFAULT NULL, |
2184 |
"DateModified" timestamp NOT NULL DEFAULT '-infinity',
|
|
2182 |
"DateModified" text/*timestamp*/ NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
2185 | 2183 |
"occid" integer NOT NULL DEFAULT '0' |
2186 | 2184 |
); |
2187 | 2185 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
2216 | 2214 |
"old_taxa_id" integer DEFAULT NULL, |
2217 | 2215 |
"scientific_name" varchar(200) NOT NULL, |
2218 | 2216 |
"taxonomic_group" varchar(150) DEFAULT NULL, |
2219 |
"date_created" timestamp NOT NULL DEFAULT '-infinity',
|
|
2217 |
"date_created" text/*timestamp*/ NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
2220 | 2218 |
"rank" varchar(6) DEFAULT NULL, |
2221 | 2219 |
"is_accepted" integer DEFAULT NULL, |
2222 | 2220 |
"entered_by" varchar(60) DEFAULT NULL, |
... | ... | |
2259 | 2257 |
"unkid" integer NOT NULL, |
2260 | 2258 |
"comment" varchar(500) NOT NULL, |
2261 | 2259 |
"username" varchar(45) NOT NULL, |
2262 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2260 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2263 | 2261 |
PRIMARY KEY ("unkcomid"), |
2264 | 2262 |
/*KEY "FK_unknowncomments" ("unkid")*/CHECK (true), |
2265 | 2263 |
/*CONSTRAINT "FK_unknowncomments" FOREIGN KEY ("unkid") REFERENCES "unknowns" ("unkid")*/CHECK (true) |
... | ... | |
2278 | 2276 |
"unkid" integer NOT NULL, |
2279 | 2277 |
"url" varchar(255) NOT NULL, |
2280 | 2278 |
"notes" varchar(250) DEFAULT NULL, |
2281 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2279 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2282 | 2280 |
PRIMARY KEY ("unkimgid"), |
2283 | 2281 |
/*KEY "FK_unknowns" ("unkid")*/CHECK (true), |
2284 | 2282 |
/*CONSTRAINT "FK_unknowns" FOREIGN KEY ("unkid") REFERENCES "unknowns" ("unkid") ON DELETE CASCADE*/CHECK (true) |
... | ... | |
2303 | 2301 |
"notes" varchar(250) DEFAULT NULL, |
2304 | 2302 |
"username" varchar(45) NOT NULL, |
2305 | 2303 |
"idstatus" varchar(45) NOT NULL DEFAULT 'ID pending', |
2306 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2304 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2307 | 2305 |
PRIMARY KEY ("unkid"), |
2308 | 2306 |
/*KEY "FK_unknowns_username" ("username")*/CHECK (true), |
2309 | 2307 |
/*KEY "FK_unknowns_tid" ("tid")*/CHECK (true), |
... | ... | |
2336 | 2334 |
"notes" varchar(255) DEFAULT NULL, |
2337 | 2335 |
"username" varchar(45) DEFAULT NULL, |
2338 | 2336 |
"sortsequence" integer DEFAULT NULL, |
2339 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
2337 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
2340 | 2338 |
); |
2341 | 2339 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2342 | 2340 |
|
... | ... | |
2353 | 2351 |
"sourcefield" varchar(45) NOT NULL, |
2354 | 2352 |
"symbdatatype" varchar(45) NOT NULL DEFAULT 'string', |
2355 | 2353 |
"symbspecfield" varchar(45) NOT NULL, |
2356 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2354 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2357 | 2355 |
PRIMARY KEY ("usmid"), |
2358 | 2356 |
/*CONSTRAINT "Index_unique" */UNIQUE ("uspid","symbspecfield"), |
2359 | 2357 |
/*CONSTRAINT "FK_uploadspecmap_usp" FOREIGN KEY ("uspid") REFERENCES "uploadspecparameters" ("uspid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
2385 | 2383 |
"QueryStr" varchar(2000) DEFAULT NULL, |
2386 | 2384 |
"cleanupsp" varchar(45) DEFAULT NULL, |
2387 | 2385 |
"dlmisvalid" integer DEFAULT '0', |
2388 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2386 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2389 | 2387 |
PRIMARY KEY ("uspid"), |
2390 | 2388 |
/*KEY "FK_uploadspecparameters_coll" ("CollID")*/CHECK (true), |
2391 | 2389 |
/*CONSTRAINT "FK_uploadspecparameters_coll" FOREIGN KEY ("CollID") REFERENCES "omcollections" ("CollID") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
... | ... | |
2434 | 2432 |
"CollectorFamilyName" varchar(255) DEFAULT NULL, |
2435 | 2433 |
"CollectorInitials" varchar(255) DEFAULT NULL, |
2436 | 2434 |
"associatedCollectors" varchar(255) DEFAULT NULL, |
2437 |
"eventDate" date DEFAULT NULL,
|
|
2435 |
"eventDate" text/*date*/ DEFAULT NULL,
|
|
2438 | 2436 |
"year" integer DEFAULT NULL, |
2439 | 2437 |
"month" integer DEFAULT NULL, |
2440 | 2438 |
"day" integer DEFAULT NULL, |
2441 | 2439 |
"startDayOfYear" integer DEFAULT NULL, |
2442 | 2440 |
"endDayOfYear" integer DEFAULT NULL, |
2443 |
"LatestDateCollected" date DEFAULT NULL,
|
|
2441 |
"LatestDateCollected" text/*date*/ DEFAULT NULL,
|
|
2444 | 2442 |
"verbatimEventDate" varchar(255) DEFAULT NULL, |
2445 | 2443 |
"habitat" text, |
2446 | 2444 |
"substrate" varchar(500) DEFAULT NULL, |
... | ... | |
2501 | 2499 |
"disposition" varchar(32) DEFAULT NULL, |
2502 | 2500 |
"genericcolumn1" varchar(100) DEFAULT NULL, |
2503 | 2501 |
"genericcolumn2" varchar(100) DEFAULT NULL, |
2504 |
"modified" timestamp DEFAULT NULL,
|
|
2502 |
"modified" text/*datetime*/ DEFAULT NULL,
|
|
2505 | 2503 |
"language" varchar(2) DEFAULT NULL, |
2506 | 2504 |
"recordEnteredBy" varchar(250) DEFAULT NULL, |
2507 | 2505 |
"duplicateQuantity" integer DEFAULT NULL, |
... | ... | |
2521 | 2519 |
"tempfield13" text, |
2522 | 2520 |
"tempfield14" text, |
2523 | 2521 |
"tempfield15" text, |
2524 |
"initialTimestamp" timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2522 |
"initialTimestamp" text/*timestamp*/ NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2525 | 2523 |
/*KEY "FK_uploadspectemp_coll" ("collid")*/CHECK (true), |
2526 | 2524 |
/*KEY "Index_uploadspectemp_occid" ("occid")*/CHECK (true), |
2527 | 2525 |
/*KEY "Index_uploadspectemp_dbpk" ("dbpk")*/CHECK (true), |
... | ... | |
2566 | 2564 |
"vernacular" varchar(80) DEFAULT NULL, |
2567 | 2565 |
"vernlang" varchar(15) DEFAULT NULL, |
2568 | 2566 |
"Hybrid" varchar(50) DEFAULT NULL, |
2569 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2567 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2570 | 2568 |
PRIMARY KEY ("scinameinput"), |
2571 | 2569 |
/*CONSTRAINT "sciname_index" */UNIQUE ("SciName"), |
2572 | 2570 |
/*KEY "sourceID_index" ("SourceId")*/CHECK (true), |
... | ... | |
2586 | 2584 |
"username" varchar(45) NOT NULL, |
2587 | 2585 |
"password" varchar(45) NOT NULL, |
2588 | 2586 |
"alias" varchar(45) DEFAULT NULL, |
2589 |
"lastlogindate" timestamp DEFAULT NULL,
|
|
2590 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2587 |
"lastlogindate" text/*datetime*/ DEFAULT NULL,
|
|
2588 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2591 | 2589 |
PRIMARY KEY ("username"), |
2592 | 2590 |
/*CONSTRAINT "Index_userlogin_unique" */UNIQUE ("alias"), |
2593 | 2591 |
/*KEY "FK_login_user" ("uid")*/CHECK (true), |
... | ... | |
2606 | 2604 |
"uid" integer NOT NULL, |
2607 | 2605 |
"pname" varchar(45) NOT NULL, |
2608 | 2606 |
"assignedby" varchar(45) DEFAULT NULL, |
2609 |
"initialtimestamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2607 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2610 | 2608 |
PRIMARY KEY ("uid","pname"), |
2611 | 2609 |
/*CONSTRAINT "userpermissions_ibfk_1" FOREIGN KEY ("uid") REFERENCES "users" ("uid") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
2612 | 2610 |
); |
... | ... | |
2642 | 2640 |
"rightsholder" varchar(250) DEFAULT NULL, |
2643 | 2641 |
"validated" varchar(45) NOT NULL DEFAULT '0', |
2644 | 2642 |
"usergroups" varchar(100) DEFAULT NULL, |
2645 |
"InitialTimeStamp" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2643 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
2646 | 2644 |
PRIMARY KEY ("uid"), |
2647 | 2645 |
/*CONSTRAINT "Index_email" */UNIQUE ("email","lastname") |
2648 | 2646 |
); |
Also available in: Unified diff
inputs/{.,}*/*.schema.sql: regenerated using the instructions in bin/my2pg. this primarily replaces timestamp with text/*timestamp*/ (to preserve indefinite dates).