Revision 6145
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2543 | 2543 |
|
| 2544 | 2544 |
|
| 2545 | 2545 |
-- |
| 2546 |
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2546 |
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2547 | 2547 |
-- |
| 2548 | 2548 |
|
| 2549 |
CREATE TABLE referencealtident (
|
|
| 2550 |
referencealtident_id int(11) NOT NULL,
|
|
| 2549 |
CREATE TABLE referencecontributor (
|
|
| 2550 |
referencecontributor_id int(11) NOT NULL,
|
|
| 2551 | 2551 |
reference_id int(11) NOT NULL, |
| 2552 |
system text, |
|
| 2553 |
identifier text NOT NULL |
|
| 2552 |
referenceparty_id int(11) NOT NULL, |
|
| 2553 |
roletype text, |
|
| 2554 |
`position` int(11) |
|
| 2554 | 2555 |
); |
| 2555 | 2556 |
|
| 2556 | 2557 |
|
| 2557 | 2558 |
-- |
| 2558 |
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2559 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2559 | 2560 |
-- |
| 2560 | 2561 |
|
| 2561 | 2562 |
|
| 2562 | 2563 |
|
| 2563 | 2564 |
|
| 2564 | 2565 |
-- |
| 2565 |
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2566 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2566 | 2567 |
-- |
| 2567 | 2568 |
|
| 2568 | 2569 |
|
| 2569 | 2570 |
|
| 2570 | 2571 |
|
| 2571 | 2572 |
-- |
| 2572 |
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2573 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2573 | 2574 |
-- |
| 2574 | 2575 |
|
| 2575 | 2576 |
|
| 2576 | 2577 |
|
| 2577 | 2578 |
-- |
| 2578 |
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2579 |
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2579 | 2580 |
-- |
| 2580 | 2581 |
|
| 2581 |
CREATE TABLE referencecontributor (
|
|
| 2582 |
referencecontributor_id int(11) NOT NULL,
|
|
| 2583 |
reference_id int(11) NOT NULL,
|
|
| 2584 |
referenceparty_id int(11) NOT NULL,
|
|
| 2585 |
roletype text,
|
|
| 2586 |
`position` int(11)
|
|
| 2582 |
CREATE TABLE referencejournal (
|
|
| 2583 |
referencejournal_id int(11) NOT NULL,
|
|
| 2584 |
journal text NOT NULL,
|
|
| 2585 |
issn text,
|
|
| 2586 |
abbreviation text,
|
|
| 2587 |
accessioncode text
|
|
| 2587 | 2588 |
); |
| 2588 | 2589 |
|
| 2589 | 2590 |
|
| 2590 | 2591 |
-- |
| 2591 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2592 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2592 | 2593 |
-- |
| 2593 | 2594 |
|
| 2594 | 2595 |
|
| 2595 | 2596 |
|
| 2596 | 2597 |
|
| 2597 | 2598 |
-- |
| 2598 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2599 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2599 | 2600 |
-- |
| 2600 | 2601 |
|
| 2601 | 2602 |
|
| 2602 | 2603 |
|
| 2603 | 2604 |
|
| 2604 | 2605 |
-- |
| 2605 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2606 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2606 | 2607 |
-- |
| 2607 | 2608 |
|
| 2608 | 2609 |
|
| 2609 | 2610 |
|
| 2610 | 2611 |
-- |
| 2611 |
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2612 |
-- Name: referencename; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2612 | 2613 |
-- |
| 2613 | 2614 |
|
| 2614 |
CREATE TABLE referencejournal ( |
|
| 2615 |
referencejournal_id int(11) NOT NULL, |
|
| 2616 |
journal text NOT NULL, |
|
| 2617 |
issn text, |
|
| 2618 |
abbreviation text, |
|
| 2619 |
accessioncode text |
|
| 2615 |
CREATE TABLE referencename ( |
|
| 2616 |
referencename_id int(11) NOT NULL, |
|
| 2617 |
reference_id int(11) NOT NULL, |
|
| 2618 |
system text, |
|
| 2619 |
identifier text NOT NULL |
|
| 2620 | 2620 |
); |
| 2621 | 2621 |
|
| 2622 | 2622 |
|
| 2623 | 2623 |
-- |
| 2624 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2624 |
-- Name: referencename_referencename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2625 | 2625 |
-- |
| 2626 | 2626 |
|
| 2627 | 2627 |
|
| 2628 | 2628 |
|
| 2629 | 2629 |
|
| 2630 | 2630 |
-- |
| 2631 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2631 |
-- Name: referencename_referencename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2632 | 2632 |
-- |
| 2633 | 2633 |
|
| 2634 | 2634 |
|
| 2635 | 2635 |
|
| 2636 | 2636 |
|
| 2637 | 2637 |
-- |
| 2638 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2638 |
-- Name: referencename_referencename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2639 | 2639 |
-- |
| 2640 | 2640 |
|
| 2641 | 2641 |
|
| ... | ... | |
| 3596 | 3596 |
|
| 3597 | 3597 |
|
| 3598 | 3598 |
-- |
| 3599 |
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3599 |
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3600 | 3600 |
-- |
| 3601 | 3601 |
|
| 3602 | 3602 |
|
| 3603 | 3603 |
|
| 3604 | 3604 |
|
| 3605 | 3605 |
-- |
| 3606 |
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3606 |
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3607 | 3607 |
-- |
| 3608 | 3608 |
|
| 3609 | 3609 |
|
| 3610 | 3610 |
|
| 3611 | 3611 |
|
| 3612 | 3612 |
-- |
| 3613 |
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3613 |
-- Name: referencename_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3614 | 3614 |
-- |
| 3615 | 3615 |
|
| 3616 | 3616 |
|
| ... | ... | |
| 4014 | 4014 |
|
| 4015 | 4015 |
|
| 4016 | 4016 |
-- |
| 4017 |
-- Data for Name: referencealtident; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4017 |
-- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4018 | 4018 |
-- |
| 4019 | 4019 |
|
| 4020 | 4020 |
|
| 4021 | 4021 |
|
| 4022 | 4022 |
-- |
| 4023 |
-- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4023 |
-- Data for Name: referencejournal; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4024 | 4024 |
-- |
| 4025 | 4025 |
|
| 4026 | 4026 |
|
| 4027 | 4027 |
|
| 4028 | 4028 |
-- |
| 4029 |
-- Data for Name: referencejournal; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4029 |
-- Data for Name: referencename; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4030 | 4030 |
-- |
| 4031 | 4031 |
|
| 4032 | 4032 |
|
| ... | ... | |
| 4532 | 4532 |
|
| 4533 | 4533 |
|
| 4534 | 4534 |
-- |
| 4535 |
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4536 |
-- |
|
| 4537 |
|
|
| 4538 |
ALTER TABLE referencealtident |
|
| 4539 |
ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id); |
|
| 4540 |
|
|
| 4541 |
|
|
| 4542 |
-- |
|
| 4543 | 4535 |
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4544 | 4536 |
-- |
| 4545 | 4537 |
|
| ... | ... | |
| 4556 | 4548 |
|
| 4557 | 4549 |
|
| 4558 | 4550 |
-- |
| 4551 |
-- Name: referencename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4552 |
-- |
|
| 4553 |
|
|
| 4554 |
ALTER TABLE referencename |
|
| 4555 |
ADD CONSTRAINT referencename_pkey PRIMARY KEY (referencename_id); |
|
| 4556 |
|
|
| 4557 |
|
|
| 4558 |
-- |
|
| 4559 | 4559 |
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4560 | 4560 |
-- |
| 4561 | 4561 |
|
| ... | ... | |
| 5937 | 5937 |
|
| 5938 | 5938 |
|
| 5939 | 5939 |
-- |
| 5940 |
-- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5941 |
-- |
|
| 5942 |
|
|
| 5943 |
ALTER TABLE referencealtident |
|
| 5944 |
ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5945 |
|
|
| 5946 |
|
|
| 5947 |
-- |
|
| 5948 | 5940 |
-- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5949 | 5941 |
-- |
| 5950 | 5942 |
|
| ... | ... | |
| 5961 | 5953 |
|
| 5962 | 5954 |
|
| 5963 | 5955 |
-- |
| 5956 |
-- Name: referencename_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5957 |
-- |
|
| 5958 |
|
|
| 5959 |
ALTER TABLE referencename |
|
| 5960 |
ADD CONSTRAINT referencename_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5961 |
|
|
| 5962 |
|
|
| 5963 |
-- |
|
| 5964 | 5964 |
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5965 | 5965 |
-- |
| 5966 | 5966 |
|
Also available in: Unified diff
schemas/vegbien.sql: Renamed referencealtident to referencename to allow any verbatim reference name to go here, with reference containing the corresponding accepted reference name