Revision 3219
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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 |
-- |
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.