Revision 5174
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3445 | 3445 |
|
| 3446 | 3446 |
|
| 3447 | 3447 |
-- |
| 3448 |
-- Name: placepath_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3449 |
-- |
|
| 3450 |
|
|
| 3451 |
ALTER TABLE placepath |
|
| 3452 |
ADD CONSTRAINT placepath_unique UNIQUE (place_id); |
|
| 3453 |
|
|
| 3454 |
|
|
| 3455 |
-- |
|
| 3456 | 3448 |
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3457 | 3449 |
-- |
| 3458 | 3450 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4081 | 4081 |
|
| 4082 | 4082 |
|
| 4083 | 4083 |
-- |
| 4084 |
-- Name: placepath_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4085 |
-- |
|
| 4086 |
|
|
| 4087 |
ALTER TABLE ONLY placepath |
|
| 4088 |
ADD CONSTRAINT placepath_unique UNIQUE (place_id); |
|
| 4089 |
|
|
| 4090 |
|
|
| 4091 |
-- |
|
| 4092 | 4084 |
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4093 | 4085 |
-- |
| 4094 | 4086 |
|
| ... | ... | |
| 4597 | 4589 |
-- Name: placepath_unique_within_datasource_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4598 | 4590 |
-- |
| 4599 | 4591 |
|
| 4600 |
CREATE UNIQUE INDEX placepath_unique_within_datasource_by_name ON placepath USING btree (datasource_id, (COALESCE(place_id, 2147483647)), (COALESCE(continent, '\\N'::text)), (COALESCE(country, '\\N'::text)), (COALESCE(stateprovince, '\\N'::text)), (COALESCE(county, '\\N'::text)), (COALESCE(municipality, '\\N'::text)), (COALESCE(site, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedplacename[]))) WHERE (placecode IS NULL);
|
|
| 4592 |
CREATE UNIQUE INDEX placepath_unique_within_datasource_by_name ON placepath USING btree (datasource_id, (COALESCE(continent, '\\N'::text)), (COALESCE(country, '\\N'::text)), (COALESCE(stateprovince, '\\N'::text)), (COALESCE(county, '\\N'::text)), (COALESCE(municipality, '\\N'::text)), (COALESCE(site, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedplacename[]))) WHERE (placecode IS NULL); |
|
| 4601 | 4593 |
|
| 4602 | 4594 |
|
| 4603 | 4595 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: placepath: Removed no longer used placepath_unique constraint on place_id. Removed place_id from placepath_unique_within_datasource_by_name unique index because otherranks is now used to store custom ranks.