Revision 3729
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 4203 | 4203 |
|
| 4204 | 4204 |
|
| 4205 | 4205 |
-- |
| 4206 |
-- Name: locationevent_unique_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4207 |
-- |
|
| 4208 |
|
|
| 4209 |
CREATE UNIQUE INDEX locationevent_unique_accessioncode ON locationevent USING btree (location_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(obsstartdate, 'infinity'::timestamp with time zone))) WHERE (parent_id IS NULL); |
|
| 4210 |
|
|
| 4211 |
|
|
| 4212 |
-- |
|
| 4213 | 4206 |
-- Name: locationevent_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4214 | 4207 |
-- |
| 4215 | 4208 |
|
| ... | ... | |
| 4238 | 4231 |
|
| 4239 | 4232 |
|
| 4240 | 4233 |
-- |
| 4234 |
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4235 |
-- |
|
| 4236 |
|
|
| 4237 |
CREATE UNIQUE INDEX locationevent_unique_within_location ON locationevent USING btree (location_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(obsstartdate, 'infinity'::timestamp with time zone))) WHERE (parent_id IS NULL); |
|
| 4238 |
|
|
| 4239 |
|
|
| 4240 |
-- |
|
| 4241 | 4241 |
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4242 | 4242 |
-- |
| 4243 | 4243 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Renamed locationevent_unique_accessioncode to locationevent_unique_within_location to better reflect what it does