Revision 11459
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5185 | 5185 |
|
| 5186 | 5186 |
|
| 5187 | 5187 |
-- |
| 5188 |
-- Name: analytical_stem_speciesBinomialWithMorphospecies_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5189 |
-- |
|
| 5190 |
|
|
| 5191 |
CREATE INDEX `analytical_stem_speciesBinomialWithMorphospecies_idx` ON analytical_stem (`speciesBinomialWithMorphospecies`); |
|
| 5192 |
|
|
| 5193 |
|
|
| 5194 |
-- |
|
| 5188 | 5195 |
-- Name: classcontributor_commclass_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5189 | 5196 |
-- |
| 5190 | 5197 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1272 | 1272 |
CREATE INDEX ON analytical_stem ("datasource", "occurrenceID");
|
| 1273 | 1273 |
CREATE INDEX ON analytical_stem ("datasource", "specimenHolderInstitutions", "collection", "accessionNumber");
|
| 1274 | 1274 |
CREATE INDEX ON analytical_stem ("datasource", "projectID", "locationID", "dateCollected");
|
| 1275 |
CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies");
|
|
| 1275 | 1276 |
|
| 1276 | 1277 |
-- Re-create dependent objects |
| 1277 | 1278 |
IF analytical_plot_def IS NOT NULL THEN |
| ... | ... | |
| 6507 | 6508 |
|
| 6508 | 6509 |
|
| 6509 | 6510 |
-- |
| 6511 |
-- Name: analytical_stem_speciesBinomialWithMorphospecies_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6512 |
-- |
|
| 6513 |
|
|
| 6514 |
CREATE INDEX "analytical_stem_speciesBinomialWithMorphospecies_idx" ON analytical_stem USING btree ("speciesBinomialWithMorphospecies");
|
|
| 6515 |
|
|
| 6516 |
|
|
| 6517 |
-- |
|
| 6510 | 6518 |
-- Name: classcontributor_commclass_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6511 | 6519 |
-- |
| 6512 | 6520 |
|
Also available in: Unified diff
schemas/vegbien.sql: sync_analytical_stem_to_view(): added index on speciesBinomialWithMorphospecies for Brian Enquist's Canadensys request