Revision 904
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1184 | 1184 |
|
| 1185 | 1185 |
|
| 1186 | 1186 |
-- |
| 1187 |
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 1187 |
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 1188 | 1188 |
-- |
| 1189 | 1189 |
|
| 1190 |
CREATE TABLE locationplace (
|
|
| 1191 |
locationplace_id int(11) NOT NULL,
|
|
| 1190 |
CREATE TABLE locationdetermination (
|
|
| 1191 |
locationdetermination_id int(11) NOT NULL,
|
|
| 1192 | 1192 |
location_id int(11) NOT NULL, |
| 1193 | 1193 |
calculated int(1), |
| 1194 | 1194 |
namedplace_id int(11) NOT NULL |
| ... | ... | |
| 1196 | 1196 |
|
| 1197 | 1197 |
|
| 1198 | 1198 |
-- |
| 1199 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1199 |
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1200 | 1200 |
-- |
| 1201 | 1201 |
|
| 1202 | 1202 |
|
| 1203 | 1203 |
|
| 1204 | 1204 |
|
| 1205 | 1205 |
-- |
| 1206 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 1206 |
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 1207 | 1207 |
-- |
| 1208 | 1208 |
|
| 1209 | 1209 |
|
| ... | ... | |
| 3157 | 3157 |
|
| 3158 | 3158 |
|
| 3159 | 3159 |
-- |
| 3160 |
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3160 |
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3161 | 3161 |
-- |
| 3162 | 3162 |
|
| 3163 | 3163 |
|
| ... | ... | |
| 3886 | 3886 |
|
| 3887 | 3887 |
|
| 3888 | 3888 |
-- |
| 3889 |
-- Name: locationplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3889 |
-- Name: locationdetermination_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3890 | 3890 |
-- |
| 3891 | 3891 |
|
| 3892 |
ALTER TABLE locationplace
|
|
| 3893 |
ADD CONSTRAINT locationplace_keys UNIQUE (location_id, namedplace_id);
|
|
| 3892 |
ALTER TABLE locationdetermination
|
|
| 3893 |
ADD CONSTRAINT locationdetermination_keys UNIQUE (location_id, namedplace_id);
|
|
| 3894 | 3894 |
|
| 3895 | 3895 |
|
| 3896 | 3896 |
-- |
| 3897 |
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3897 |
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3898 | 3898 |
-- |
| 3899 | 3899 |
|
| 3900 |
ALTER TABLE locationplace
|
|
| 3901 |
ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id);
|
|
| 3900 |
ALTER TABLE locationdetermination
|
|
| 3901 |
ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
|
|
| 3902 | 3902 |
|
| 3903 | 3903 |
|
| 3904 | 3904 |
-- |
| ... | ... | |
| 5032 | 5032 |
|
| 5033 | 5033 |
|
| 5034 | 5034 |
-- |
| 5035 |
-- Name: locationplace_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5035 |
-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5036 | 5036 |
-- |
| 5037 | 5037 |
|
| 5038 |
CREATE INDEX locationplace_location_id_x ON locationplace (location_id);
|
|
| 5038 |
CREATE INDEX locationdetermination_location_id_x ON locationdetermination (location_id);
|
|
| 5039 | 5039 |
|
| 5040 | 5040 |
|
| 5041 | 5041 |
-- |
| 5042 |
-- Name: locationplace_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5042 |
-- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5043 | 5043 |
-- |
| 5044 | 5044 |
|
| 5045 |
CREATE INDEX locationplace_namedplace_id_x ON locationplace (namedplace_id);
|
|
| 5045 |
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination (namedplace_id);
|
|
| 5046 | 5046 |
|
| 5047 | 5047 |
|
| 5048 | 5048 |
-- |
| ... | ... | |
| 6092 | 6092 |
|
| 6093 | 6093 |
|
| 6094 | 6094 |
-- |
| 6095 |
-- Name: locationplace_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6095 |
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6096 | 6096 |
-- |
| 6097 | 6097 |
|
| 6098 |
ALTER TABLE locationplace
|
|
| 6099 |
ADD CONSTRAINT locationplace_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6098 |
ALTER TABLE locationdetermination
|
|
| 6099 |
ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6100 | 6100 |
|
| 6101 | 6101 |
|
| 6102 | 6102 |
-- |
| 6103 |
-- Name: locationplace_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6103 |
-- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6104 | 6104 |
-- |
| 6105 | 6105 |
|
| 6106 |
ALTER TABLE locationplace
|
|
| 6107 |
ADD CONSTRAINT locationplace_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6106 |
ALTER TABLE locationdetermination
|
|
| 6107 |
ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6108 | 6108 |
|
| 6109 | 6109 |
|
| 6110 | 6110 |
-- |
Also available in: Unified diff
VegBIEN: Renamed locationplace to locationdetermination