Revision 1105
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1115 | 1115 |
method_id int(11) NOT NULL, |
| 1116 | 1116 |
growthform_id int(11) NOT NULL, |
| 1117 | 1117 |
included int(1) DEFAULT true NOT NULL, |
| 1118 |
growthformmethod_id int(11)
|
|
| 1118 |
submethod_id int(11)
|
|
| 1119 | 1119 |
); |
| 1120 | 1120 |
|
| 1121 | 1121 |
|
| ... | ... | |
| 1127 | 1127 |
|
| 1128 | 1128 |
|
| 1129 | 1129 |
-- |
| 1130 |
-- Name: COLUMN methodgrowthform.growthformmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 1130 |
-- Name: COLUMN methodgrowthform.submethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 1131 | 1131 |
-- |
| 1132 | 1132 |
|
| 1133 | 1133 |
|
| ... | ... | |
| 1155 | 1155 |
methodtaxonclass_id int(11) NOT NULL, |
| 1156 | 1156 |
method_id int(11) NOT NULL, |
| 1157 | 1157 |
plantconcept_id int(11) NOT NULL, |
| 1158 |
included int(1) DEFAULT true NOT NULL |
|
| 1158 |
included int(1) DEFAULT true NOT NULL, |
|
| 1159 |
submethod_id int(11) |
|
| 1159 | 1160 |
); |
| 1160 | 1161 |
|
| 1161 | 1162 |
|
| ... | ... | |
| 1167 | 1168 |
|
| 1168 | 1169 |
|
| 1169 | 1170 |
-- |
| 1171 |
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1172 |
-- |
|
| 1173 |
|
|
| 1174 |
|
|
| 1175 |
|
|
| 1176 |
|
|
| 1177 |
-- |
|
| 1170 | 1178 |
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1171 | 1179 |
-- |
| 1172 | 1180 |
|
| ... | ... | |
| 3968 | 3976 |
-- Name: fki_methodgrowthform_growthformmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3969 | 3977 |
-- |
| 3970 | 3978 |
|
| 3971 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform (growthformmethod_id);
|
|
| 3979 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform (submethod_id);
|
|
| 3972 | 3980 |
|
| 3973 | 3981 |
|
| 3974 | 3982 |
-- |
| ... | ... | |
| 5183 | 5191 |
|
| 5184 | 5192 |
|
| 5185 | 5193 |
-- |
| 5186 |
-- Name: methodgrowthform_growthformmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5194 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5187 | 5195 |
-- |
| 5188 | 5196 |
|
| 5189 | 5197 |
ALTER TABLE methodgrowthform |
| 5190 |
ADD CONSTRAINT methodgrowthform_growthformmethod_id FOREIGN KEY (growthformmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
|
|
| 5198 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5191 | 5199 |
|
| 5192 | 5200 |
|
| 5193 | 5201 |
-- |
| 5194 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5202 |
-- Name: methodgrowthform_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5195 | 5203 |
-- |
| 5196 | 5204 |
|
| 5197 | 5205 |
ALTER TABLE methodgrowthform |
| 5198 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5206 |
ADD CONSTRAINT methodgrowthform_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
|
|
| 5199 | 5207 |
|
| 5200 | 5208 |
|
| 5201 | 5209 |
-- |
| ... | ... | |
| 5215 | 5223 |
|
| 5216 | 5224 |
|
| 5217 | 5225 |
-- |
| 5226 |
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5227 |
-- |
|
| 5228 |
|
|
| 5229 |
ALTER TABLE methodtaxonclass |
|
| 5230 |
ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5231 |
|
|
| 5232 |
|
|
| 5233 |
-- |
|
| 5218 | 5234 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5219 | 5235 |
-- |
| 5220 | 5236 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1284 | 1284 |
method_id integer NOT NULL, |
| 1285 | 1285 |
growthform_id integer NOT NULL, |
| 1286 | 1286 |
included boolean DEFAULT true NOT NULL, |
| 1287 |
growthformmethod_id integer
|
|
| 1287 |
submethod_id integer
|
|
| 1288 | 1288 |
); |
| 1289 | 1289 |
|
| 1290 | 1290 |
|
| ... | ... | |
| 1296 | 1296 |
|
| 1297 | 1297 |
|
| 1298 | 1298 |
-- |
| 1299 |
-- Name: COLUMN methodgrowthform.growthformmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 1299 |
-- Name: COLUMN methodgrowthform.submethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 1300 | 1300 |
-- |
| 1301 | 1301 |
|
| 1302 |
COMMENT ON COLUMN methodgrowthform.growthformmethod_id IS 'The method used to sample just this growthform, distinct from the main method.';
|
|
| 1302 |
COMMENT ON COLUMN methodgrowthform.submethod_id IS 'The submethod used to sample just this growth form, distinct from the main method.';
|
|
| 1303 | 1303 |
|
| 1304 | 1304 |
|
| 1305 | 1305 |
-- |
| ... | ... | |
| 1329 | 1329 |
methodtaxonclass_id integer NOT NULL, |
| 1330 | 1330 |
method_id integer NOT NULL, |
| 1331 | 1331 |
plantconcept_id integer NOT NULL, |
| 1332 |
included boolean DEFAULT true NOT NULL |
|
| 1332 |
included boolean DEFAULT true NOT NULL, |
|
| 1333 |
submethod_id integer |
|
| 1333 | 1334 |
); |
| 1334 | 1335 |
|
| 1335 | 1336 |
|
| ... | ... | |
| 1341 | 1342 |
|
| 1342 | 1343 |
|
| 1343 | 1344 |
-- |
| 1345 |
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1346 |
-- |
|
| 1347 |
|
|
| 1348 |
COMMENT ON COLUMN methodtaxonclass.submethod_id IS 'The submethod used to sample just this taxon class, distinct from the main method.'; |
|
| 1349 |
|
|
| 1350 |
|
|
| 1351 |
-- |
|
| 1344 | 1352 |
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1345 | 1353 |
-- |
| 1346 | 1354 |
|
| ... | ... | |
| 4337 | 4345 |
-- Name: fki_methodgrowthform_growthformmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4338 | 4346 |
-- |
| 4339 | 4347 |
|
| 4340 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform USING btree (growthformmethod_id);
|
|
| 4348 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform USING btree (submethod_id);
|
|
| 4341 | 4349 |
|
| 4342 | 4350 |
|
| 4343 | 4351 |
-- |
| ... | ... | |
| 5566 | 5574 |
|
| 5567 | 5575 |
|
| 5568 | 5576 |
-- |
| 5569 |
-- Name: methodgrowthform_growthformmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5577 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5570 | 5578 |
-- |
| 5571 | 5579 |
|
| 5572 | 5580 |
ALTER TABLE ONLY methodgrowthform |
| 5573 |
ADD CONSTRAINT methodgrowthform_growthformmethod_id FOREIGN KEY (growthformmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
|
|
| 5581 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5574 | 5582 |
|
| 5575 | 5583 |
|
| 5576 | 5584 |
-- |
| 5577 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5585 |
-- Name: methodgrowthform_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5578 | 5586 |
-- |
| 5579 | 5587 |
|
| 5580 | 5588 |
ALTER TABLE ONLY methodgrowthform |
| 5581 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5589 |
ADD CONSTRAINT methodgrowthform_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
|
|
| 5582 | 5590 |
|
| 5583 | 5591 |
|
| 5584 | 5592 |
-- |
| ... | ... | |
| 5598 | 5606 |
|
| 5599 | 5607 |
|
| 5600 | 5608 |
-- |
| 5609 |
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5610 |
-- |
|
| 5611 |
|
|
| 5612 |
ALTER TABLE ONLY methodtaxonclass |
|
| 5613 |
ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5614 |
|
|
| 5615 |
|
|
| 5616 |
-- |
|
| 5601 | 5617 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5602 | 5618 |
-- |
| 5603 | 5619 |
|
Also available in: Unified diff
vegbien.sql: Renamed methodgrowthform.growthformmethod_id to submethod_id. Added methodtaxonclass.submethod_id (similar to methodgrowthform.submethod_id).