Revision 5858
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1015 | 1015 |
continent text, |
| 1016 | 1016 |
country text, |
| 1017 | 1017 |
stateprovince text, |
| 1018 |
county text, |
|
| 1019 |
municipality text, |
|
| 1020 |
site text |
|
| 1018 |
county text |
|
| 1021 | 1019 |
); |
| 1022 | 1020 |
|
| 1023 | 1021 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1547 | 1547 |
country text, |
| 1548 | 1548 |
stateprovince text, |
| 1549 | 1549 |
county text, |
| 1550 |
municipality text, |
|
| 1551 |
site text, |
|
| 1552 | 1550 |
CONSTRAINT place_required_key CHECK ((((((placecode IS NOT NULL) OR (continent IS NOT NULL)) OR (country IS NOT NULL)) OR (stateprovince IS NOT NULL)) OR (county IS NOT NULL))) |
| 1553 | 1551 |
); |
| 1554 | 1552 |
|
| ... | ... | |
| 4976 | 4974 |
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4977 | 4975 |
-- |
| 4978 | 4976 |
|
| 4979 |
CREATE UNIQUE INDEX place_unique_within_creator_by_name ON place USING btree (creator_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))) WHERE (placecode IS NULL);
|
|
| 4977 |
CREATE UNIQUE INDEX place_unique_within_creator_by_name ON place USING btree (creator_id, (COALESCE(continent, '\\N'::text)), (COALESCE(country, '\\N'::text)), (COALESCE(stateprovince, '\\N'::text)), (COALESCE(county, '\\N'::text))) WHERE (placecode IS NULL); |
|
| 4980 | 4978 |
|
| 4981 | 4979 |
|
| 4982 | 4980 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: place: Removed municipality, site because they are not used in the geoscrubbing