Revision 11477
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/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 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 1271 | 1271 |
|
| 1272 | 1272 |
CREATE INDEX ON analytical_stem ("datasource", "occurrenceID");
|
| 1273 | 1273 |
CREATE INDEX ON analytical_stem ("datasource", "specimenHolderInstitutions", "collection", "accessionNumber");
|
| 1274 |
CREATE INDEX ON analytical_stem ("datasource", "projectID", "locationID", "dateCollected");
|
|
| 1275 |
CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies"); -- runtime: 1 h ("3953941 ms") @vegbiendev
|
|
| 1274 |
CREATE INDEX ON analytical_stem ("datasource", "projectID", "locationID", "eventDate");
|
|
| 1275 |
CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies");
|
|
| 1276 | 1276 |
|
| 1277 | 1277 |
-- Re-create dependent objects |
| 1278 | 1278 |
IF analytical_plot_def IS NOT NULL THEN |
| ... | ... | |
| 6505 | 6505 |
|
| 6506 | 6506 |
|
| 6507 | 6507 |
-- |
| 6508 |
-- Name: analytical_stem_datasource_projectID_locationID_dateCollect_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 6508 |
-- Name: analytical_stem_datasource_projectID_locationID_eventDate_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 6509 | 6509 |
-- |
| 6510 | 6510 |
|
| 6511 |
CREATE INDEX "analytical_stem_datasource_projectID_locationID_dateCollect_idx" ON analytical_stem USING btree (datasource, "projectID", "locationID", "dateCollected");
|
|
| 6511 |
CREATE INDEX "analytical_stem_datasource_projectID_locationID_eventDate_idx" ON analytical_stem USING btree (datasource, "projectID", "locationID", "eventDate");
|
|
| 6512 | 6512 |
|
| 6513 | 6513 |
|
| 6514 | 6514 |
-- |
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