Revision 955
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 18 | 18 |
|
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: methodtraitname_appliesto; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
|
|
| 25 |
|
|
| 26 |
|
|
| 27 |
-- |
|
| 21 | 28 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 22 | 29 |
-- |
| 23 | 30 |
|
| ... | ... | |
| 1238 | 1245 |
|
| 1239 | 1246 |
|
| 1240 | 1247 |
|
| 1248 |
|
|
| 1249 |
|
|
| 1241 | 1250 |
-- |
| 1251 |
-- Name: methodtrait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1252 |
-- |
|
| 1253 |
|
|
| 1254 |
CREATE TABLE methodtrait ( |
|
| 1255 |
methodtrait_id int(11) NOT NULL, |
|
| 1256 |
method_id int(11) NOT NULL, |
|
| 1257 |
methodtraitname_id int(11) NOT NULL, |
|
| 1258 |
value text NOT NULL |
|
| 1259 |
); |
|
| 1260 |
|
|
| 1261 |
|
|
| 1262 |
-- |
|
| 1263 |
-- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1264 |
-- |
|
| 1265 |
|
|
| 1266 |
|
|
| 1267 |
|
|
| 1268 |
|
|
| 1269 |
-- |
|
| 1270 |
-- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1271 |
-- |
|
| 1272 |
|
|
| 1273 |
|
|
| 1274 |
|
|
| 1275 |
|
|
| 1276 |
-- |
|
| 1277 |
-- Name: methodtraitname; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1278 |
-- |
|
| 1279 |
|
|
| 1280 |
CREATE TABLE methodtraitname ( |
|
| 1281 |
methodtraitname_id int(11) NOT NULL, |
|
| 1282 |
name text NOT NULL, |
|
| 1283 |
appliesto text NOT NULL |
|
| 1284 |
); |
|
| 1285 |
|
|
| 1286 |
|
|
| 1287 |
-- |
|
| 1288 |
-- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1289 |
-- |
|
| 1290 |
|
|
| 1291 |
|
|
| 1292 |
|
|
| 1293 |
|
|
| 1294 |
-- |
|
| 1295 |
-- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1296 |
-- |
|
| 1297 |
|
|
| 1298 |
|
|
| 1299 |
|
|
| 1300 |
|
|
| 1301 |
|
|
| 1302 |
|
|
| 1303 |
-- |
|
| 1242 | 1304 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1243 | 1305 |
-- |
| 1244 | 1306 |
|
| ... | ... | |
| 3176 | 3238 |
|
| 3177 | 3239 |
|
| 3178 | 3240 |
-- |
| 3241 |
-- Name: methodtrait_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3242 |
-- |
|
| 3243 |
|
|
| 3244 |
|
|
| 3245 |
|
|
| 3246 |
|
|
| 3247 |
-- |
|
| 3248 |
-- Name: methodtraitname_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3249 |
-- |
|
| 3250 |
|
|
| 3251 |
|
|
| 3252 |
|
|
| 3253 |
|
|
| 3254 |
-- |
|
| 3179 | 3255 |
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: - |
| 3180 | 3256 |
-- |
| 3181 | 3257 |
|
| ... | ... | |
| 3899 | 3975 |
|
| 3900 | 3976 |
|
| 3901 | 3977 |
-- |
| 3978 |
-- Name: methodtrait_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3979 |
-- |
|
| 3980 |
|
|
| 3981 |
ALTER TABLE methodtrait |
|
| 3982 |
ADD CONSTRAINT methodtrait_keys UNIQUE (method_id, methodtraitname_id); |
|
| 3983 |
|
|
| 3984 |
|
|
| 3985 |
-- |
|
| 3986 |
-- Name: methodtrait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3987 |
-- |
|
| 3988 |
|
|
| 3989 |
ALTER TABLE methodtrait |
|
| 3990 |
ADD CONSTRAINT methodtrait_pkey PRIMARY KEY (methodtrait_id); |
|
| 3991 |
|
|
| 3992 |
|
|
| 3993 |
-- |
|
| 3994 |
-- Name: methodtraitname_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3995 |
-- |
|
| 3996 |
|
|
| 3997 |
ALTER TABLE methodtraitname |
|
| 3998 |
ADD CONSTRAINT methodtraitname_keys UNIQUE (name); |
|
| 3999 |
|
|
| 4000 |
|
|
| 4001 |
-- |
|
| 4002 |
-- Name: methodtraitname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4003 |
-- |
|
| 4004 |
|
|
| 4005 |
ALTER TABLE methodtraitname |
|
| 4006 |
ADD CONSTRAINT methodtraitname_pkey PRIMARY KEY (methodtraitname_id); |
|
| 4007 |
|
|
| 4008 |
|
|
| 4009 |
-- |
|
| 3902 | 4010 |
-- Name: namedplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3903 | 4011 |
-- |
| 3904 | 4012 |
|
| ... | ... | |
| 4832 | 4940 |
|
| 4833 | 4941 |
|
| 4834 | 4942 |
-- |
| 4943 |
-- Name: fki_methodtrait_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4944 |
-- |
|
| 4945 |
|
|
| 4946 |
CREATE INDEX fki_methodtrait_method_id ON methodtrait (method_id); |
|
| 4947 |
|
|
| 4948 |
|
|
| 4949 |
-- |
|
| 4950 |
-- Name: fki_methodtrait_methodtraitname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4951 |
-- |
|
| 4952 |
|
|
| 4953 |
CREATE INDEX fki_methodtrait_methodtraitname_id ON methodtrait (methodtraitname_id); |
|
| 4954 |
|
|
| 4955 |
|
|
| 4956 |
-- |
|
| 4835 | 4957 |
-- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4836 | 4958 |
-- |
| 4837 | 4959 |
|
| ... | ... | |
| 6161 | 6283 |
|
| 6162 | 6284 |
|
| 6163 | 6285 |
-- |
| 6286 |
-- Name: methodtrait_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6287 |
-- |
|
| 6288 |
|
|
| 6289 |
ALTER TABLE methodtrait |
|
| 6290 |
ADD CONSTRAINT methodtrait_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6291 |
|
|
| 6292 |
|
|
| 6293 |
-- |
|
| 6294 |
-- Name: methodtrait_methodtraitname_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6295 |
-- |
|
| 6296 |
|
|
| 6297 |
ALTER TABLE methodtrait |
|
| 6298 |
ADD CONSTRAINT methodtrait_methodtraitname_id FOREIGN KEY (methodtraitname_id) REFERENCES methodtraitname(methodtraitname_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6299 |
|
|
| 6300 |
|
|
| 6301 |
-- |
|
| 6164 | 6302 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6165 | 6303 |
-- |
| 6166 | 6304 |
|
| schemas/vegbien_empty.sql | ||
|---|---|---|
| 35 | 35 |
TRUNCATE locationeventcontributor CASCADE; |
| 36 | 36 |
TRUNCATE locationeventsynonym CASCADE; |
| 37 | 37 |
TRUNCATE method CASCADE; |
| 38 |
TRUNCATE methodtrait CASCADE; |
|
| 39 |
TRUNCATE methodtraitname CASCADE; |
|
| 38 | 40 |
TRUNCATE namedplace CASCADE; |
| 39 | 41 |
TRUNCATE namedplacecorrelation CASCADE; |
| 40 | 42 |
TRUNCATE note CASCADE; |
| schemas/vegbien.sql | ||
|---|---|---|
| 18 | 18 |
SET search_path = public, pg_catalog; |
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: methodtraitname_appliesto; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
CREATE TYPE methodtraitname_appliesto AS ENUM ( |
|
| 25 |
'locationevent', |
|
| 26 |
'taxonoccurrence' |
|
| 27 |
); |
|
| 28 |
|
|
| 29 |
|
|
| 30 |
-- |
|
| 21 | 31 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 22 | 32 |
-- |
| 23 | 33 |
|
| ... | ... | |
| 1429 | 1439 |
ALTER SEQUENCE method_method_id_seq OWNED BY method.method_id; |
| 1430 | 1440 |
|
| 1431 | 1441 |
|
| 1442 |
SET default_with_oids = false; |
|
| 1443 |
|
|
| 1432 | 1444 |
-- |
| 1445 |
-- Name: methodtrait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1446 |
-- |
|
| 1447 |
|
|
| 1448 |
CREATE TABLE methodtrait ( |
|
| 1449 |
methodtrait_id integer NOT NULL, |
|
| 1450 |
method_id integer NOT NULL, |
|
| 1451 |
methodtraitname_id integer NOT NULL, |
|
| 1452 |
value text NOT NULL |
|
| 1453 |
); |
|
| 1454 |
|
|
| 1455 |
|
|
| 1456 |
-- |
|
| 1457 |
-- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1458 |
-- |
|
| 1459 |
|
|
| 1460 |
CREATE SEQUENCE methodtrait_methodtrait_id_seq |
|
| 1461 |
START WITH 1 |
|
| 1462 |
INCREMENT BY 1 |
|
| 1463 |
NO MINVALUE |
|
| 1464 |
NO MAXVALUE |
|
| 1465 |
CACHE 1; |
|
| 1466 |
|
|
| 1467 |
|
|
| 1468 |
-- |
|
| 1469 |
-- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1470 |
-- |
|
| 1471 |
|
|
| 1472 |
ALTER SEQUENCE methodtrait_methodtrait_id_seq OWNED BY methodtrait.methodtrait_id; |
|
| 1473 |
|
|
| 1474 |
|
|
| 1475 |
-- |
|
| 1476 |
-- Name: methodtraitname; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1477 |
-- |
|
| 1478 |
|
|
| 1479 |
CREATE TABLE methodtraitname ( |
|
| 1480 |
methodtraitname_id integer NOT NULL, |
|
| 1481 |
name text NOT NULL, |
|
| 1482 |
appliesto methodtraitname_appliesto[] NOT NULL |
|
| 1483 |
); |
|
| 1484 |
|
|
| 1485 |
|
|
| 1486 |
-- |
|
| 1487 |
-- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1488 |
-- |
|
| 1489 |
|
|
| 1490 |
CREATE SEQUENCE methodtraitname_methodtraitname_id_seq |
|
| 1491 |
START WITH 1 |
|
| 1492 |
INCREMENT BY 1 |
|
| 1493 |
NO MINVALUE |
|
| 1494 |
NO MAXVALUE |
|
| 1495 |
CACHE 1; |
|
| 1496 |
|
|
| 1497 |
|
|
| 1498 |
-- |
|
| 1499 |
-- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1500 |
-- |
|
| 1501 |
|
|
| 1502 |
ALTER SEQUENCE methodtraitname_methodtraitname_id_seq OWNED BY methodtraitname.methodtraitname_id; |
|
| 1503 |
|
|
| 1504 |
|
|
| 1505 |
SET default_with_oids = true; |
|
| 1506 |
|
|
| 1507 |
-- |
|
| 1433 | 1508 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1434 | 1509 |
-- |
| 1435 | 1510 |
|
| ... | ... | |
| 3632 | 3707 |
|
| 3633 | 3708 |
|
| 3634 | 3709 |
-- |
| 3710 |
-- Name: methodtrait_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3711 |
-- |
|
| 3712 |
|
|
| 3713 |
ALTER TABLE methodtrait ALTER COLUMN methodtrait_id SET DEFAULT nextval('methodtrait_methodtrait_id_seq'::regclass);
|
|
| 3714 |
|
|
| 3715 |
|
|
| 3716 |
-- |
|
| 3717 |
-- Name: methodtraitname_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3718 |
-- |
|
| 3719 |
|
|
| 3720 |
ALTER TABLE methodtraitname ALTER COLUMN methodtraitname_id SET DEFAULT nextval('methodtraitname_methodtraitname_id_seq'::regclass);
|
|
| 3721 |
|
|
| 3722 |
|
|
| 3723 |
-- |
|
| 3635 | 3724 |
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: - |
| 3636 | 3725 |
-- |
| 3637 | 3726 |
|
| ... | ... | |
| 4355 | 4444 |
|
| 4356 | 4445 |
|
| 4357 | 4446 |
-- |
| 4447 |
-- Name: methodtrait_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4448 |
-- |
|
| 4449 |
|
|
| 4450 |
ALTER TABLE ONLY methodtrait |
|
| 4451 |
ADD CONSTRAINT methodtrait_keys UNIQUE (method_id, methodtraitname_id); |
|
| 4452 |
|
|
| 4453 |
|
|
| 4454 |
-- |
|
| 4455 |
-- Name: methodtrait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4456 |
-- |
|
| 4457 |
|
|
| 4458 |
ALTER TABLE ONLY methodtrait |
|
| 4459 |
ADD CONSTRAINT methodtrait_pkey PRIMARY KEY (methodtrait_id); |
|
| 4460 |
|
|
| 4461 |
|
|
| 4462 |
-- |
|
| 4463 |
-- Name: methodtraitname_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4464 |
-- |
|
| 4465 |
|
|
| 4466 |
ALTER TABLE ONLY methodtraitname |
|
| 4467 |
ADD CONSTRAINT methodtraitname_keys UNIQUE (name); |
|
| 4468 |
|
|
| 4469 |
|
|
| 4470 |
-- |
|
| 4471 |
-- Name: methodtraitname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4472 |
-- |
|
| 4473 |
|
|
| 4474 |
ALTER TABLE ONLY methodtraitname |
|
| 4475 |
ADD CONSTRAINT methodtraitname_pkey PRIMARY KEY (methodtraitname_id); |
|
| 4476 |
|
|
| 4477 |
|
|
| 4478 |
-- |
|
| 4358 | 4479 |
-- Name: namedplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4359 | 4480 |
-- |
| 4360 | 4481 |
|
| ... | ... | |
| 5288 | 5409 |
|
| 5289 | 5410 |
|
| 5290 | 5411 |
-- |
| 5412 |
-- Name: fki_methodtrait_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5413 |
-- |
|
| 5414 |
|
|
| 5415 |
CREATE INDEX fki_methodtrait_method_id ON methodtrait USING btree (method_id); |
|
| 5416 |
|
|
| 5417 |
|
|
| 5418 |
-- |
|
| 5419 |
-- Name: fki_methodtrait_methodtraitname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5420 |
-- |
|
| 5421 |
|
|
| 5422 |
CREATE INDEX fki_methodtrait_methodtraitname_id ON methodtrait USING btree (methodtraitname_id); |
|
| 5423 |
|
|
| 5424 |
|
|
| 5425 |
-- |
|
| 5291 | 5426 |
-- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5292 | 5427 |
-- |
| 5293 | 5428 |
|
| ... | ... | |
| 6631 | 6766 |
|
| 6632 | 6767 |
|
| 6633 | 6768 |
-- |
| 6769 |
-- Name: methodtrait_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6770 |
-- |
|
| 6771 |
|
|
| 6772 |
ALTER TABLE ONLY methodtrait |
|
| 6773 |
ADD CONSTRAINT methodtrait_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6774 |
|
|
| 6775 |
|
|
| 6776 |
-- |
|
| 6777 |
-- Name: methodtrait_methodtraitname_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6778 |
-- |
|
| 6779 |
|
|
| 6780 |
ALTER TABLE ONLY methodtrait |
|
| 6781 |
ADD CONSTRAINT methodtrait_methodtraitname_id FOREIGN KEY (methodtraitname_id) REFERENCES methodtraitname(methodtraitname_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6782 |
|
|
| 6783 |
|
|
| 6784 |
-- |
|
| 6634 | 6785 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6635 | 6786 |
-- |
| 6636 | 6787 |
|
Also available in: Unified diff
vegbien.sql: Added methodtrait and methodtraitname tables