Revision 3217
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3148 | 3148 |
|
| 3149 | 3149 |
|
| 3150 | 3150 |
-- |
| 3151 |
-- Name: locationevent_unique_datasource_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3152 |
-- |
|
| 3153 |
|
|
| 3154 |
ALTER TABLE locationevent |
|
| 3155 |
ADD CONSTRAINT locationevent_unique_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode); |
|
| 3156 |
|
|
| 3157 |
|
|
| 3158 |
-- |
|
| 3159 | 3151 |
-- Name: locationevent_unique_parent_authorcode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3160 | 3152 |
-- |
| 3161 | 3153 |
|
| ... | ... | |
| 4232 | 4224 |
|
| 4233 | 4225 |
|
| 4234 | 4226 |
-- |
| 4235 |
-- Name: locationevent_unique_location; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4227 |
-- Name: locationevent_unique_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4236 | 4228 |
-- |
| 4237 | 4229 |
|
| 4238 | 4230 |
|
| 4239 | 4231 |
|
| 4240 | 4232 |
|
| 4241 | 4233 |
-- |
| 4242 |
-- Name: locationevent_unique_location_date; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4243 |
-- |
|
| 4244 |
|
|
| 4245 |
|
|
| 4246 |
|
|
| 4247 |
|
|
| 4248 |
-- |
|
| 4249 | 4234 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4250 | 4235 |
-- |
| 4251 | 4236 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Fixed bug where locationevent_unique_location index was overconstraining locationevent when a sourceaccessioncode or obsstartdate was specified, by combining the locationevent_unique_location, locationevent_unique_accessioncode, and locationevent_unique_location_date indexes into one COALESCE index on the combined fields of those indexes