Revision 2886
Added by Aaron Marcuse-Kubitza about 12 years ago
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 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Added indexes using COALESCE to match what sql_gen does