Revision 3219
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4182 | 4182 |
|
| 4183 | 4183 |
|
| 4184 | 4184 |
-- |
| 4185 |
-- Name: locationevent_obsstartdate; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4186 |
-- |
|
| 4187 |
|
|
| 4188 |
|
|
| 4189 |
|
|
| 4190 |
|
|
| 4191 |
-- |
|
| 4185 | 4192 |
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4186 | 4193 |
-- |
| 4187 | 4194 |
|
| ... | ... | |
| 4196 | 4203 |
|
| 4197 | 4204 |
|
| 4198 | 4205 |
-- |
| 4199 |
-- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4206 |
-- Name: locationevent_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4200 | 4207 |
-- |
| 4201 | 4208 |
|
| 4202 |
CREATE INDEX locationevent_project_id_x ON locationevent (project_id); |
|
| 4203 | 4209 |
|
| 4204 | 4210 |
|
| 4211 |
|
|
| 4205 | 4212 |
-- |
| 4206 | 4213 |
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4207 | 4214 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 4713 | 4713 |
|
| 4714 | 4714 |
|
| 4715 | 4715 |
-- |
| 4716 |
-- Name: locationevent_obsstartdate; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4717 |
-- |
|
| 4718 |
|
|
| 4719 |
CREATE INDEX locationevent_obsstartdate ON locationevent USING btree ((COALESCE(obsstartdate, 'infinity'::timestamp with time zone))); |
|
| 4720 |
|
|
| 4721 |
|
|
| 4722 |
-- |
|
| 4716 | 4723 |
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4717 | 4724 |
-- |
| 4718 | 4725 |
|
| ... | ... | |
| 4727 | 4734 |
|
| 4728 | 4735 |
|
| 4729 | 4736 |
-- |
| 4730 |
-- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4737 |
-- Name: locationevent_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4731 | 4738 |
-- |
| 4732 | 4739 |
|
| 4733 |
CREATE INDEX locationevent_project_id_x ON locationevent USING btree (project_id);
|
|
| 4740 |
CREATE INDEX locationevent_project_id ON locationevent USING btree ((COALESCE(project_id, 2147483647)));
|
|
| 4734 | 4741 |
|
| 4735 | 4742 |
|
| 4736 | 4743 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Added sql_gen-compatible indexes on all columns in the locationevent_unique_project_authorcode UNIQUE index: Changed locationevent_project_id index to use COALESCE. Added index on obsstartdate.