Revision 6543
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 711 | 711 |
`coordinateUncertaintyInMeters` double precision, |
| 712 | 712 |
geovalid int(1), |
| 713 | 713 |
`isNewWorld` int(1), |
| 714 |
`plotName` varchar(255) NOT NULL,
|
|
| 714 |
`locationName` varchar(255) NOT NULL,
|
|
| 715 | 715 |
`elevationInMeters` double precision, |
| 716 | 716 |
`plotArea_ha` double precision, |
| 717 | 717 |
`samplingProtocol` varchar(255), |
| ... | ... | |
| 755 | 755 |
geovalid int(1), |
| 756 | 756 |
`isNewWorld` int(1), |
| 757 | 757 |
`projectID` varchar(255), |
| 758 |
`plotName` varchar(255) NOT NULL,
|
|
| 758 |
`locationName` varchar(255) NOT NULL,
|
|
| 759 | 759 |
`elevationInMeters` double precision, |
| 760 | 760 |
`plotArea_ha` double precision, |
| 761 | 761 |
`samplingProtocol` varchar(255), |
| ... | ... | |
| 4890 | 4890 |
|
| 4891 | 4891 |
|
| 4892 | 4892 |
-- |
| 4893 |
-- Name: analytical_aggregate_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4893 |
-- Name: analytical_aggregate_institutionCode_locationName_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4894 | 4894 |
-- |
| 4895 | 4895 |
|
| 4896 |
CREATE INDEX `analytical_aggregate_institutionCode_plotName_dateCollected_idx` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`);
|
|
| 4896 |
CREATE INDEX `analytical_aggregate_institutionCode_locationName_dateColle_idx` ON analytical_aggregate (`institutionCode`, `locationName`, `dateCollected`);
|
|
| 4897 | 4897 |
|
| 4898 | 4898 |
|
| 4899 | 4899 |
-- |
| ... | ... | |
| 4904 | 4904 |
|
| 4905 | 4905 |
|
| 4906 | 4906 |
-- |
| 4907 |
-- Name: analytical_stem_institutionCode_projectID_plotName_dateColl_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4907 |
-- Name: analytical_stem_institutionCode_projectID_locationName_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4908 | 4908 |
-- |
| 4909 | 4909 |
|
| 4910 |
CREATE INDEX `analytical_stem_institutionCode_projectID_plotName_dateColl_idx` ON analytical_stem (`institutionCode`, `projectID`, `plotName`, `dateCollected`);
|
|
| 4910 |
CREATE INDEX `analytical_stem_institutionCode_projectID_locationName_date_idx` ON analytical_stem (`institutionCode`, `projectID`, `locationName`, `dateCollected`);
|
|
| 4911 | 4911 |
|
| 4912 | 4912 |
|
| 4913 | 4913 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Renamed plotName to locationName to match the new VegCore term name