Revision 11477
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 5181 | 5181 |
|
| 5182 | 5182 |
|
| 5183 | 5183 |
-- |
| 5184 |
-- Name: analytical_stem_datasource_projectID_locationID_dateCollect_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5184 |
-- Name: analytical_stem_datasource_projectID_locationID_eventDate_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5185 | 5185 |
-- |
| 5186 | 5186 |
|
| 5187 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_dateCollect_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `dateCollected`);
|
|
| 5187 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_eventDate_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `eventDate`);
|
|
| 5188 | 5188 |
|
| 5189 | 5189 |
|
| 5190 | 5190 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem: locationID... index: use eventDate instead of dateCollected since it's now eventDate that identifies the locationevent