Revision 12886
Added by Aaron Marcuse-Kubitza about 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2964 | 2964 |
source_id int(11) NOT NULL, |
| 2965 | 2965 |
sourceaccessioncode varchar(255), |
| 2966 | 2966 |
plantobservation_id int(11), |
| 2967 |
institution_id int(11),
|
|
| 2967 |
duplicate_institutions_sourcelist_id int(11),
|
|
| 2968 | 2968 |
collectioncode_dwc varchar(255), |
| 2969 | 2969 |
catalognumber_dwc varchar(255), |
| 2970 | 2970 |
collectionnumber varchar(255), |
| ... | ... | |
| 2981 | 2981 |
|
| 2982 | 2982 |
|
| 2983 | 2983 |
-- |
| 2984 |
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 2984 |
-- Name: COLUMN specimenreplicate.duplicate_institutions_sourcelist_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 2985 | 2985 |
-- |
| 2986 | 2986 |
|
| 2987 | 2987 |
|
| ... | ... | |
| 9497 | 9497 |
|
| 9498 | 9498 |
|
| 9499 | 9499 |
-- |
| 9500 |
-- Name: specimenreplicate_institution_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 9500 |
-- Name: specimenreplicate_duplicate_institutions_sourcelist_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 9501 | 9501 |
-- |
| 9502 | 9502 |
|
| 9503 |
CREATE INDEX specimenreplicate_institution_id_idx ON specimenreplicate (institution_id);
|
|
| 9503 |
CREATE INDEX specimenreplicate_duplicate_institutions_sourcelist_id_idx ON specimenreplicate (duplicate_institutions_sourcelist_id);
|
|
| 9504 | 9504 |
|
| 9505 | 9505 |
|
| 9506 | 9506 |
-- |
| ... | ... | |
| 10720 | 10720 |
|
| 10721 | 10721 |
|
| 10722 | 10722 |
-- |
| 10723 |
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 10723 |
-- Name: specimenreplicate_duplicate_institutions_sourcelist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 10724 | 10724 |
-- |
| 10725 | 10725 |
|
| 10726 | 10726 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate.institution_id: renamed to duplicate_institutions_sourcelist_id, as decided in the conference calls (wiki.vegpath.org/2014-03-13_conference_call#schema-changes-2)