Revision 7053
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1667 | 1667 |
CREATE TABLE commconcept ( |
| 1668 | 1668 |
commconcept_id int(11) NOT NULL, |
| 1669 | 1669 |
commname_id int(11) NOT NULL, |
| 1670 |
source_id int(11),
|
|
| 1670 |
reference_id int(11),
|
|
| 1671 | 1671 |
commdescription varchar(255), |
| 1672 | 1672 |
commname varchar(255), |
| 1673 | 1673 |
accessioncode varchar(255) |
| schemas/vegbien.sql | ||
|---|---|---|
| 2495 | 2495 |
CREATE TABLE commconcept ( |
| 2496 | 2496 |
commconcept_id integer NOT NULL, |
| 2497 | 2497 |
commname_id integer NOT NULL, |
| 2498 |
source_id integer,
|
|
| 2498 |
reference_id integer,
|
|
| 2499 | 2499 |
commdescription text, |
| 2500 | 2500 |
commname text, |
| 2501 | 2501 |
accessioncode text |
| ... | ... | |
| 6804 | 6804 |
-- |
| 6805 | 6805 |
|
| 6806 | 6806 |
ALTER TABLE ONLY commconcept |
| 6807 |
ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6807 |
ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6808 | 6808 |
|
| 6809 | 6809 |
|
| 6810 | 6810 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: commconcept: Renamed source_id back to reference_id (it was previously renamed to source_id in a bulk rename)