Revision 4791
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3707 | 3707 |
|
| 3708 | 3708 |
|
| 3709 | 3709 |
-- |
| 3710 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3711 |
-- |
|
| 3712 |
|
|
| 3713 |
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence (taxonoccurrence_id); |
|
| 3714 |
|
|
| 3715 |
|
|
| 3716 |
-- |
|
| 3710 | 3717 |
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3711 | 3718 |
-- |
| 3712 | 3719 |
|
| ... | ... | |
| 3805 | 3812 |
|
| 3806 | 3813 |
|
| 3807 | 3814 |
-- |
| 3815 |
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3816 |
-- |
|
| 3817 |
|
|
| 3818 |
CREATE INDEX locationevent_location ON locationevent (location_id); |
|
| 3819 |
|
|
| 3820 |
|
|
| 3821 |
-- |
|
| 3808 | 3822 |
-- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3809 | 3823 |
-- |
| 3810 | 3824 |
|
| ... | ... | |
| 4057 | 4071 |
|
| 4058 | 4072 |
|
| 4059 | 4073 |
-- |
| 4074 |
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4075 |
-- |
|
| 4076 |
|
|
| 4077 |
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence (locationevent_id); |
|
| 4078 |
|
|
| 4079 |
|
|
| 4080 |
-- |
|
| 4060 | 4081 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4061 | 4082 |
-- |
| 4062 | 4083 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4295 | 4295 |
|
| 4296 | 4296 |
|
| 4297 | 4297 |
-- |
| 4298 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4299 |
-- |
|
| 4300 |
|
|
| 4301 |
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence USING btree (taxonoccurrence_id); |
|
| 4302 |
|
|
| 4303 |
|
|
| 4304 |
-- |
|
| 4298 | 4305 |
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4299 | 4306 |
-- |
| 4300 | 4307 |
|
| ... | ... | |
| 4393 | 4400 |
|
| 4394 | 4401 |
|
| 4395 | 4402 |
-- |
| 4403 |
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4404 |
-- |
|
| 4405 |
|
|
| 4406 |
CREATE INDEX locationevent_location ON locationevent USING btree (location_id); |
|
| 4407 |
|
|
| 4408 |
|
|
| 4409 |
-- |
|
| 4396 | 4410 |
-- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4397 | 4411 |
-- |
| 4398 | 4412 |
|
| ... | ... | |
| 4645 | 4659 |
|
| 4646 | 4660 |
|
| 4647 | 4661 |
-- |
| 4662 |
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4663 |
-- |
|
| 4664 |
|
|
| 4665 |
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence USING btree (locationevent_id); |
|
| 4666 |
|
|
| 4667 |
|
|
| 4668 |
-- |
|
| 4648 | 4669 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4649 | 4670 |
-- |
| 4650 | 4671 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added indexes for the analytical_db_view joins, as described at <https://projects.nceas.ucsb.edu/nceas/issues/494>