Revision 2886
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4163 | 4163 |
|
| 4164 | 4164 |
|
| 4165 | 4165 |
-- |
| 4166 |
-- Name: locationevent_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4167 |
-- |
|
| 4168 |
|
|
| 4169 |
|
|
| 4170 |
|
|
| 4171 |
|
|
| 4172 |
-- |
|
| 4173 |
-- Name: locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4174 |
-- |
|
| 4175 |
|
|
| 4176 |
|
|
| 4177 |
|
|
| 4178 |
|
|
| 4179 |
-- |
|
| 4166 | 4180 |
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4167 | 4181 |
-- |
| 4168 | 4182 |
|
| ... | ... | |
| 4170 | 4184 |
|
| 4171 | 4185 |
|
| 4172 | 4186 |
-- |
| 4187 |
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4188 |
-- |
|
| 4189 |
|
|
| 4190 |
|
|
| 4191 |
|
|
| 4192 |
|
|
| 4193 |
-- |
|
| 4173 | 4194 |
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4174 | 4195 |
-- |
| 4175 | 4196 |
|
| ... | ... | |
| 4191 | 4212 |
|
| 4192 | 4213 |
|
| 4193 | 4214 |
-- |
| 4215 |
-- Name: locationevent_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4216 |
-- |
|
| 4217 |
|
|
| 4218 |
|
|
| 4219 |
|
|
| 4220 |
|
|
| 4221 |
-- |
|
| 4194 | 4222 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4195 | 4223 |
-- |
| 4196 | 4224 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4690 | 4690 |
|
| 4691 | 4691 |
|
| 4692 | 4692 |
-- |
| 4693 |
-- Name: locationevent_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4694 |
-- |
|
| 4695 |
|
|
| 4696 |
CREATE INDEX locationevent_authorlocationcode ON locationevent USING btree ((COALESCE(authorlocationcode, '\\N'::text))); |
|
| 4697 |
|
|
| 4698 |
|
|
| 4699 |
-- |
|
| 4700 |
-- Name: locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4701 |
-- |
|
| 4702 |
|
|
| 4703 |
CREATE INDEX locationevent_datasource_id ON locationevent USING btree ((COALESCE(datasource_id, 2147483647))); |
|
| 4704 |
|
|
| 4705 |
|
|
| 4706 |
-- |
|
| 4693 | 4707 |
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4694 | 4708 |
-- |
| 4695 | 4709 |
|
| ... | ... | |
| 4697 | 4711 |
|
| 4698 | 4712 |
|
| 4699 | 4713 |
-- |
| 4714 |
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4715 |
-- |
|
| 4716 |
|
|
| 4717 |
CREATE INDEX locationevent_parent_id ON locationevent USING btree ((COALESCE(parent_id, 2147483647))); |
|
| 4718 |
|
|
| 4719 |
|
|
| 4720 |
-- |
|
| 4700 | 4721 |
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4701 | 4722 |
-- |
| 4702 | 4723 |
|
| ... | ... | |
| 4718 | 4739 |
|
| 4719 | 4740 |
|
| 4720 | 4741 |
-- |
| 4742 |
-- Name: locationevent_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4743 |
-- |
|
| 4744 |
|
|
| 4745 |
CREATE INDEX locationevent_sourceaccessioncode ON locationevent USING btree ((COALESCE(sourceaccessioncode, '\\N'::text))); |
|
| 4746 |
|
|
| 4747 |
|
|
| 4748 |
-- |
|
| 4721 | 4749 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4722 | 4750 |
-- |
| 4723 | 4751 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Added indexes using COALESCE to match what sql_gen does