Revision 2886
Added by Aaron Marcuse-Kubitza about 12 years ago
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