Revision 6512
Added by Aaron Marcuse-Kubitza over 11 years ago
vegbien.my.sql | ||
---|---|---|
724 | 724 |
`elevationInMeters` double precision, |
725 | 725 |
`plotArea_ha` double precision, |
726 | 726 |
`samplingProtocol` varchar(255), |
727 |
`dateCollected` date NOT NULL,
|
|
727 |
`dateCollected` date, |
|
728 | 728 |
`higherPlantGroup` varchar(255), |
729 | 729 |
family varchar(255), |
730 | 730 |
genus varchar(255), |
... | ... | |
765 | 765 |
`elevationInMeters` double precision, |
766 | 766 |
`plotArea_ha` double precision, |
767 | 767 |
`samplingProtocol` varchar(255), |
768 |
`dateCollected` date NOT NULL,
|
|
768 |
`dateCollected` date, |
|
769 | 769 |
`higherPlantGroup` varchar(255), |
770 | 770 |
family varchar(255), |
771 | 771 |
genus varchar(255), |
... | ... | |
4956 | 4956 |
|
4957 | 4957 |
|
4958 | 4958 |
-- |
4959 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
4959 |
-- Name: analytical_aggregate_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
4960 | 4960 |
-- |
4961 | 4961 |
|
4962 |
CREATE INDEX `analytical_aggregate_by_institutionCode` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`);
|
|
4962 |
CREATE INDEX `analytical_aggregate_institutionCode_plotName_dateCollected_idx` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`);
|
|
4963 | 4963 |
|
4964 | 4964 |
|
4965 | 4965 |
-- |
4966 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
4966 |
-- Name: analytical_stem_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
4967 | 4967 |
-- |
4968 | 4968 |
|
4969 |
CREATE INDEX `analytical_stem_by_institutionCode` ON analytical_stem (`institutionCode`, `plotName`, `dateCollected`);
|
|
4969 |
CREATE INDEX `analytical_stem_institutionCode_plotName_dateCollected_idx` ON analytical_stem (`institutionCode`, `plotName`, `dateCollected`);
|
|
4970 | 4970 |
|
4971 | 4971 |
|
4972 | 4972 |
-- |
... | ... | |
6557 | 6557 |
|
6558 | 6558 |
|
6559 | 6559 |
-- |
6560 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
6561 |
-- |
|
6562 |
|
|
6563 |
|
|
6564 |
|
|
6565 |
|
|
6566 |
|
|
6567 |
|
|
6568 |
|
|
6569 |
-- |
|
6570 | 6560 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
6571 | 6561 |
-- |
6572 | 6562 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Removed NOT NULL constraint on dateCollected