Revision 5860
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1011 | 1011 |
creator_id int(11) NOT NULL, |
| 1012 | 1012 |
placecode text, |
| 1013 | 1013 |
matched_place_id int(11), |
| 1014 |
coordinates_id int(11), |
|
| 1014 | 1015 |
placename_id int(11), |
| 1015 | 1016 |
continent text, |
| 1016 | 1017 |
country text, |
| ... | ... | |
| 5011 | 5012 |
|
| 5012 | 5013 |
|
| 5013 | 5014 |
-- |
| 5015 |
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5016 |
-- |
|
| 5017 |
|
|
| 5018 |
ALTER TABLE place |
|
| 5019 |
ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5020 |
|
|
| 5021 |
|
|
| 5022 |
-- |
|
| 5014 | 5023 |
-- Name: place_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5015 | 5024 |
-- |
| 5016 | 5025 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1542 | 1542 |
creator_id integer NOT NULL, |
| 1543 | 1543 |
placecode text, |
| 1544 | 1544 |
matched_place_id integer, |
| 1545 |
coordinates_id integer, |
|
| 1545 | 1546 |
placename_id integer, |
| 1546 | 1547 |
continent text, |
| 1547 | 1548 |
country text, |
| 1548 | 1549 |
stateprovince text, |
| 1549 | 1550 |
county text, |
| 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)))
|
|
| 1551 |
CONSTRAINT place_required_key CHECK (((((((placecode IS NOT NULL) OR (coordinates_id IS NOT NULL)) OR (continent IS NOT NULL)) OR (country IS NOT NULL)) OR (stateprovince IS NOT NULL)) OR (county IS NOT NULL)))
|
|
| 1551 | 1552 |
); |
| 1552 | 1553 |
|
| 1553 | 1554 |
|
| ... | ... | |
| 5046 | 5047 |
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5047 | 5048 |
-- |
| 5048 | 5049 |
|
| 5049 |
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); |
|
| 5050 |
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(coordinates_id, 2147483647))) WHERE (placecode IS NULL);
|
|
| 5050 | 5051 |
|
| 5051 | 5052 |
|
| 5052 | 5053 |
-- |
| ... | ... | |
| 5886 | 5887 |
|
| 5887 | 5888 |
|
| 5888 | 5889 |
-- |
| 5890 |
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5891 |
-- |
|
| 5892 |
|
|
| 5893 |
ALTER TABLE ONLY place |
|
| 5894 |
ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5895 |
|
|
| 5896 |
|
|
| 5897 |
-- |
|
| 5889 | 5898 |
-- Name: place_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5890 | 5899 |
-- |
| 5891 | 5900 |
|
Also available in: Unified diff
schemas/vegbien.sql: place: Added coordinates_id